2002-02-21 09:14:31 [2712] DEBUG: ProcessUtility: end 2002-02-21 09:14:31 [2100] DEBUG: query: update accounts set abalance = abalance + 288 where aid = 57927 2002-02-21 09:14:31 [2100] DEBUG: query: select abalance from accounts where aid = 57927 2002-02-21 09:14:31 [2100] DEBUG: query: update tellers set tbalance = tbalance + 288 where tid = 9 2002-02-21 09:14:31 [2100] DEBUG: query: update branches set bbalance = bbalance + 288 where bid = 1 2002-02-21 09:14:31 [2100] DEBUG: query: insert into history(tid,bid,aid,delta,time) values(9,1,57927,288,'now') 2002-02-21 09:14:31 [2632] DEBUG: query: update branches set bbalance = bbalance + 509 where bid = 1 2002-02-21 09:14:31 [2100] DEBUG: query: end 2002-02-21 09:14:31 [2100] DEBUG: ProcessUtility: end FATAL: s_lock(0x1aca0016) at spin.c:158, stuck spinlock. Aborting. FATAL: s_lock(0x1aca0016) at spin.c:158, stuck spinlock. Aborting. FATAL: s_lock(0x1aca0016) at spin.c:158, stuck spinlock. Aborting. FATAL: s_lock(0x1aca0016) at spin.c:158, stuck spinlock. Aborting. FATAL: s_lock(0x1aca0016) at spin.c:158, stuck spinlock. Aborting. FATAL: s_lock(0x1aca0016) at spin.c:158, stuck spinlock. Aborting. Stack trace: Frame Function Args 0022F228 77E76A3D (00000000, 00000000, 0022F278, 6105A669) 0022F278 6105A91E (00000000, 00000002, 0022F2B8, 6108AACE) 0022F2B8 61058025 (00000834, 00000006, 1ACA0016, 00000000) 0022F2F8 61058262 (00000834, 00000006, 0022F358, 610586A9) 0022F318 610580EA (00000006, 00000000, 0022F358, 61058674) 0022F358 610586BF (05F5E100, 00004E21, 0022F3B0, 004CCB95) 0022F378 004CCAEB (1ACA0016, 004D0BE6, 0000009E, 004CA9A7) 0022F3B8 004CCB81 (00004E21, 05F5E100, 00000000, 1ACA0016) 0022F3F8 004CCBCA (1ACA0016, 004D0BE6, 0000009E, 00000002) 0022F428 004D0C1E (00000006, 1406F618, 0022F488, 004203CF) 0022F498 004D33AB (00000001, 1AE5D220, 00000000, 0000A223) 0022F4C8 004D3B24 (00000001, 0174BA77, 0022F518, 0041DFDB) 0022F4E8 0041DCB0 (00000001, 0A029D20, 0022F518, 0041DF59) 0022F518 0041DFFC (0A0AF4B8, 00000001, 0022F578, 004D84CB) 0022F538 0041E40D (0A029D20, 00000002, 0022F578, 004D8616) 0022F548 004D86DF (00000051, 0A0AF298, 0A020F60, 004D7F57) End of stack trace (more stack frames may be present) FATAL: s_lock(0x1aca0016) at spin.c:158, stuck spinlock. Aborting. Server process (pid 2800) exited with status 134 at Thu Feb 21 09:20:02 2002 Terminating any active server processes... 2002-02-21 09:20:02 [2632] NOTICE: Message from PostgreSQL backend: The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory. I have rolled back the current transaction and am going to terminate your database system connection and exit. Please reconnect to the database system and repeat your query. (00000BB4, 00000006, 1ACA0016, 00000000) 0022EF68 61058262 (00000BB4, 00000006, 0022EFC8, 610586A9) 0022EF88 610580EA (00000006, 00000000, 0022EFC8, 61058674) 0022EFC8 610586BF (05F5E100, 00004E21, 0022F020, 004CCB95) 0022EFE8 004CCAEB (1ACA0016, 004D0BE6, 0000009E, 0022F0F8) 0022F028 004CCB81 (00004E21, 05F5E100, 00000000, 1ACA0016) 0022F068 004CCBCA (1ACA0016, 004D0BE6, 0000009E, 0022F0BC) 0022F098 004D0C1E (00000006, 00000001, 0022F0C8, 004D4024) 0022F0C8 004D4034 (0000000E, 00000000, 00000004, FFFFFFFF) 0022F0F8 6100FA23 (00000000, 0022F020, 0022F020, 0022F020) 0022F148 004CCB95 (00000000, 05F5E100, 00000000, 1ACA0016) 0022F188 004CCBCA (1ACA0016, 004D0BE6, 0000009E, 610736F7) 0022F1B8 004D0C1E (00000006, 0022F218, 0022F208, 004CA930) 0022F228 004D3EF0 (0A010540, 00000004, 1AE5A87C, 1AE5D354) 0022F268 004D2D61 (00000001, 00000004, 1AE5A87C, 1AE5D354) 0022F308 004D2AE8 (00000001, 0022F338, 0000A207, 00000004) End of stack trace (more stack frames may be present) FATAL: s_lock(0x1aca0016) at spin.c:158, stuck spinlock. Aborting. FATAL: s_lock(0x1aca0016) at spin.c:158, stuck spinlock. Aborting. 2002-02-21 09:20:04 [896] NOTICE: Message from PostgreSQL backend: The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory. I have rolled back the current transaction and am going to terminate your database system connection and exit. Please reconnect to the database system and repeat your query. Server processes were terminated at Thu Feb 21 09:20:04 2002 Reinitializing shared memory and semaphores 2002-02-21 09:20:12 [2336] DEBUG: database system was interrupted at 2002-02-21 09:17:32 2002-02-21 09:20:12 [2336] DEBUG: CheckPoint record at (0, 336000536) 2002-02-21 09:20:12 [2336] DEBUG: Redo record at (0, 336000536); Undo record at (0, 335559664); Shutdown FALSE 2002-02-21 09:20:12 [2336] DEBUG: NextTransactionId: 41508; NextOid: 1083890 2002-02-21 09:20:12 [2336] DEBUG: database system was not properly shut down; automatic recovery in progress... 2002-02-21 09:20:12 [2336] DEBUG: ReadRecord: record with zero len at (0, 336000600) 2002-02-21 09:20:12 [2336] DEBUG: redo is not required 2002-02-21 09:20:14 [2336] DEBUG: MoveOfflineLogs: remove 0000000000000013 2002-02-21 09:20:14 [2336] DEBUG: database system is in production state 2002-02-21 09:45:11 [1860] DEBUG: connection: host=127.0.0.1 user=Administrateur database=pgbench 2002-02-21 09:45:11 [1860] DEBUG: query: select getdatabaseencoding() 2002-02-21 09:45:11 [1860] DEBUG: query: select count(*) from branches 2002-02-21 09:45:11 [1860] DEBUG: query: vacuum branches 2002-02-21 09:45:11 [1860] DEBUG: ProcessUtility: vacuum branches 2002-02-21 09:45:11 [1860] DEBUG: --Relation branches-- 2002-02-21 09:45:11 [1860] DEBUG: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 1: Vac 79, Keep/VTL 0/0, Crash 0, UnUsed 77, MinLen 48, MaxLen 48; Re-using: Free/Avail. Space 7496/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 2002-02-21 09:45:11 [1860] DEBUG: Index branches_pkey: Pages 13; Tuples 1: Deleted 79. CPU 0.00s/0.00u sec. 2002-02-21 09:45:11 [1860] DEBUG: query: vacuum tellers 2002-02-21 09:45:11 [1860] DEBUG: ProcessUtility: vacuum tellers 2002-02-21 09:45:11 [1860] DEBUG: --Relation tellers-- 2002-02-21 09:45:11 [1860] DEBUG: Pages 1: Changed 1, reaped 1, Empty 0, New 0; Tup 10: Vac 81, Keep/VTL 0/0, Crash 2, UnUsed 45, MinLen 52, MaxLen 52; Re-using: Free/Avail. Space 7068/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. 2002-02-21 09:45:11 [1860] DEBUG: Index tellers_pkey: Pages 5; Tuples 10: Deleted 81. CPU 0.00s/0.00u sec. 2002-02-21 09:45:11 [1860] DEBUG: query: delete from history 2002-02-21 09:45:11 [1860] DEBUG: query: vacuum history 2002-02-21 09:45:11 [1860] DEBUG: ProcessUtility: vacuum history 2002-02-21 09:45:11 [1860] DEBUG: --Relation history-- 2002-02-21 09:45:11 [1860] DEBUG: Pages 1: Changed 0, reaped 1, Empty 0, New 0; Tup 0: Vac 79, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 0, MaxLen 0; Re-using: Free/Avail. Space 7856/0; EndEmpty/Avail. Pages 1/0. CPU 0.00s/0.00u sec. 2002-02-21 09:45:11 [1860] DEBUG: Rel history: Pages: 1 --> 0. 2002-02-21 09:45:11 [2884] DEBUG: connection: host=127.0.0.1 user=Administrateur database=pgbench 2002-02-21 09:45:11 [2884] DEBUG: query: select getdatabaseencoding() 2002-02-21 09:45:12 [1804] DEBUG: connection: host=127.0.0.1 user=Administrateur database=pgbench 2002-02-21 09:45:12 [1804] DEBUG: query: select getdatabaseencoding() 2002-02-21 09:45:12 [2684] DEBUG: connection: host=127.0.0.1 user=Administrateur database=pgbench 2002-02-21 09:45:12 [2684] DEBUG: query: select getdatabaseencoding() 2002-02-21 09:45:13 [2496] DEBUG: connection: host=127.0.0.1 user=Administrateur database=pgbench 2002-02-21 09:45:13 [2496] DEBUG: query: select getdatabaseencoding() 2002-02-21 09:45:13 [2792] DEBUG: connection: host=127.0.0.1 user=Administrateur database=pgbench 2002-02-21 09:45:13 [2792] DEBUG: query: select getdatabaseencoding() 2002-02-21 09:45:13 [2968] DEBUG: connection: host=127.0.0.1 user=Administrateur database=pgbench