WAL Crash during index vacuuming 7.1beta4

Поиск
Список
Период
Сортировка
От Giuseppe Tanzilli - CSF
Тема WAL Crash during index vacuuming 7.1beta4
Дата
Msg-id 3A7936DD.5080804@gruppocsf.com
обсуждение исходный текст
Список pgsql-hackers
Hi,
during the nightly vacuum pgsql closed and do not start any more.
Attached the log.

Seems the problem was rebuilding an Index,
There is a way to force wal to ignore indexes ?
Can I delete it ?

thanks in advance

-------------------------------------------------------
Giuseppe Tanzilli        g.tanzilli@gruppocsf.com
CSF Sistemi srl            phone ++39 0775 7771
Via del Ciavattino 
Anagni FR
Italy

/usr/local/pgsql/bin/postmaster: reaping dead processes...
/usr/local/pgsql/bin/postmaster: CleanupProc: pid 30842 exited with status 0
DEBUG:  Index BD_Prodotto_SuddMerc_key: Pages 14533; Tuples 247153: Deleted 246556. CPU 2.61s/4.93u sec.
DEBUG:  XLogWrite: new log file created - try to increase WAL_FILES
DEBUG:  XLogWrite: new log file created - try to increase WAL_FILES
DEBUG:  XLogWrite: new log file created - try to increase WAL_FILES
DEBUG:  XLogWrite: new log file created - try to increase WAL_FILES
DEBUG:  XLogWrite: new log file created - try to increase WAL_FILES
DEBUG:  XLogWrite: new log file created - try to increase WAL_FILES
DEBUG:  XLogWrite: new log file created - try to increase WAL_FILES
DEBUG:  XLogWrite: new log file created - try to increase WAL_FILES
DEBUG:  XLogWrite: new log file created - try to increase WAL_FILES
DEBUG:  XLogWrite: new log file created - try to increase WAL_FILES
DEBUG:  XLogWrite: new log file created - try to increase WAL_FILES

FATAL: s_lock(0x402a3535) at bufmgr.c:2072, stuck spinlock. Aborting.

FATAL: s_lock(0x402a3535) at bufmgr.c:2072, stuck spinlock. Aborting.
/usr/local/pgsql/bin/postmaster: reaping dead processes...
/usr/local/pgsql/bin/postmaster: CleanupProc: pid 30355 exited with status 6
Server process (pid 30355) exited with status 6 at Thu Feb  1 04:36:21 2001
Terminating any active server processes...
/usr/local/pgsql/bin/postmaster: CleanupProc: sending SIGUSR1 to process 30843
/usr/local/pgsql/bin/postmaster: ServerLoop:        handling reading 5
/usr/local/pgsql/bin/postmaster: ServerLoop:        handling reading 5
The Data Base System is in recovery mode
/usr/local/pgsql/bin/postmaster: ServerLoop:        handling writing 5
/usr/local/pgsql/bin/postmaster: ServerLoop:        handling reading 5
/usr/local/pgsql/bin/postmaster: ServerLoop:        handling reading 5
The Data Base System is in recovery mode
/usr/local/pgsql/bin/postmaster: ServerLoop:        handling writing 5
/usr/local/pgsql/bin/postmaster: ServerLoop:        handling reading 5
/usr/local/pgsql/bin/postmaster: ServerLoop:        handling reading 5
The Data Base System is in recovery mode
/usr/local/pgsql/bin/postmaster: ServerLoop:        handling writing 5
DEBUG:  proc_exit(0)
DEBUG:  shmem_exit(0)
DEBUG:  exit(0)
/usr/local/pgsql/bin/postmaster: reaping dead processes...
/usr/local/pgsql/bin/postmaster: CleanupProc: pid 30843 exited with status 0
Server processes were terminated at Thu Feb  1 04:36:38 2001
Reinitializing shared memory and semaphores
invoking IpcMemoryCreate(size=68608000)
DEBUG:  starting up
DEBUG:  database system was interrupted at 2001-02-01 04:36:38
DEBUG:  CheckPoint record at (6, 4150292860)
DEBUG:  Redo record at (6, 4144414796); Undo record at (6, 3622728240); Shutdown FALSE
DEBUG:  NextTransactionId: 156659; NextOid: 7401689
DEBUG:  database system was not properly shut down; automatic recovery in progress...
DEBUG:  redo starts at (6, 4144414796)
NOTICE:  PageAddItem: tried overwrite of used ItemId
FATAL 2:  heap_update_redo: failed to add tuple
DEBUG:  proc_exit(2)
DEBUG:  shmem_exit(2)
DEBUG:  exit(2)
/usr/local/pgsql/bin/postmaster: reaping dead processes...
Startup failed - abort
invoking IpcMemoryCreate(size=68608000)
FindExec: found "/usr/local/pgsql/bin/postmaster" using argv[0]
DEBUG:  starting up
DEBUG:  database system was interrupted being in recovery at 2001-02-01 04:36:38This propably means that some data
blocksare corruptedand you will have to use last backup for recovery.
 
DEBUG:  CheckPoint record at (6, 4150292860)
DEBUG:  Redo record at (6, 4144414796); Undo record at (6, 3622728240); Shutdown FALSE
DEBUG:  NextTransactionId: 156659; NextOid: 7401689
DEBUG:  database system was not properly shut down; automatic recovery in progress...
DEBUG:  redo starts at (6, 4144414796)
NOTICE:  PageAddItem: tried overwrite of used ItemId
FATAL 2:  heap_update_redo: failed to add tuple
DEBUG:  proc_exit(2)
DEBUG:  shmem_exit(2)
DEBUG:  exit(2)
/usr/local/pgsql/bin/postmaster: reaping dead processes...
Startup failed - abort
invoking IpcMemoryCreate(size=68608000)
FindExec: found "/usr/local/pgsql/bin/postmaster" using argv[0]
DEBUG:  starting up
DEBUG:  database system was interrupted being in recovery at 2001-02-01 09:47:40This propably means that some data
blocksare corruptedand you will have to use last backup for recovery.
 
DEBUG:  CheckPoint record at (6, 4150292860)
DEBUG:  Redo record at (6, 4144414796); Undo record at (6, 3622728240); Shutdown FALSE
DEBUG:  NextTransactionId: 156659; NextOid: 7401689
DEBUG:  database system was not properly shut down; automatic recovery in progress...
DEBUG:  redo starts at (6, 4144414796)
NOTICE:  PageAddItem: tried overwrite of used ItemId
FATAL 2:  heap_update_redo: failed to add tuple
DEBUG:  proc_exit(2)
DEBUG:  shmem_exit(2)
DEBUG:  exit(2)
/usr/local/pgsql/bin/postmaster: reaping dead processes...
Startup failed - abort

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Martin A. Marques"
Дата:
Сообщение: Re: [GENERAL] Re: grant privileges to a database
Следующее
От: "Martin A. Marques"
Дата:
Сообщение: Re: Re: grant privileges to a database [URGENT]