after roughly 6 hours of constant updates and inserts...
I have absolutely no clue as to how many transactions or how many
updates or inserts.
see below.
Regards,
John (applejack)
Mar 8 06:25:10 fred postgres[614]: [2-1] ERROR: could not write block
2333 of relation 17142/21672885: Cannot allocate memory
Mar 8 06:25:10 fred postgres[614]: [2-2] CONTEXT: writing block 2333
of relation 17142/21672885
Mar 8 06:25:25 fred postgres[598]: [2-1] LOG: bgwriter process (PID
614) was terminated by signal 9
Mar 8 06:25:25 fred postgres[598]: [3-1] LOG: terminating any other
active server processes
Mar 8 06:25:35 fred postgres[27526]: [4-1] WARNING: terminating
connection because of crash of another server process
Mar 8 06:25:35 fred postgres[27526]: [4-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and
exit, because another server
Mar 8 06:25:35 fred postgres[27526]: [4-3] process exited abnormally
and possibly corrupted shared memory.
Mar 8 06:25:35 fred postgres[27526]: [4-4] HINT: In a moment you
should be able to reconnect to the database and repeat your command.
Mar 8 06:25:35 fred postgres[27526]: [5-1] ERROR: could not send data
to client: Broken pipe
Mar 8 06:25:35 fred postgres[27527]: [4-1] WARNING: terminating
connection because of crash of another server process
Mar 8 06:25:35 fred postgres[27527]: [4-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and
exit, because another server
Mar 8 06:25:35 fred postgres[27527]: [4-3] process exited abnormally
and possibly corrupted shared memory.
Mar 8 06:25:35 fred postgres[27527]: [4-4] HINT: In a moment you
should be able to reconnect to the database and repeat your command.
Mar 8 06:25:35 fred postgres[27527]: [5-1] ERROR: could not send data
to client: Broken pipe
Mar 8 06:25:36 fred postgres[27592]: [4-1] WARNING: terminating
connection because of crash of another server process
Mar 8 06:25:36 fred postgres[27592]: [4-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and
exit, because another server
Mar 8 06:25:36 fred postgres[27592]: [4-3] process exited abnormally
and possibly corrupted shared memory.
Mar 8 06:25:36 fred postgres[27592]: [4-4] HINT: In a moment you
should be able to reconnect to the database and repeat your command.
Mar 8 06:25:36 fred postgres[27526]: [6-1] WARNING: AbortTransaction
and not in in-progress state
Mar 8 06:25:36 fred postgres[27526]: [7-1] LOG: unexpected EOF on
client connection
Mar 8 06:25:36 fred postgres[27527]: [6-1] WARNING: AbortTransaction
and not in in-progress state
Mar 8 06:25:36 fred postgres[27527]: [7-1] LOG: unexpected EOF on
client connection
Mar 8 06:25:38 fred postgres[598]: [4-1] LOG: all server processes
terminated; reinitializing
Mar 8 06:25:38 fred postgres[27663]: [5-1] LOG: database system was
interrupted at 2004-03-08 06:24:01 EST
Mar 8 06:25:38 fred postgres[27663]: [6-1] LOG: checkpoint record is
at 18/61431A88
Mar 8 06:25:38 fred postgres[27663]: [7-1] LOG: redo record is at
18/61431A88; undo record is at 0/0; shutdown FALSE
Mar 8 06:25:38 fred postgres[27663]: [8-1] LOG: next transaction ID:
51079855; next OID: 32618747
Mar 8 06:25:38 fred postgres[27663]: [9-1] LOG: database system was
not properly shut down; automatic recovery in progress
Mar 8 06:25:39 fred postgres[27663]: [10-1] LOG: redo starts at
18/61431AC8
Mar 8 06:25:56 fred postgres[27663]: [11-1] LOG: record with zero
length at 18/620FE3F8
Mar 8 06:25:56 fred postgres[27663]: [12-1] LOG: redo done at
18/620FE3D4
Mar 8 06:26:01 fred postgres[27663]: [13-1] LOG: recycled transaction
log file "000000180000005E"
Mar 8 06:26:01 fred postgres[27663]: [14-1] LOG: recycled transaction
log file "000000180000005F"
Mar 8 06:26:01 fred postgres[27663]: [15-1] LOG: recycled transaction
log file "0000001800000060"
Mar 8 06:26:01 fred postgres[27663]: [16-1] LOG: database system is
ready