bgwriter bails out - Mailing list pgsql-hackers

From John Hansen
Subject bgwriter bails out
Date
Msg-id 5066E5A966339E42AA04BA10BA706AE55FC2@rodrick.geeknet.com.au
Whole thread Raw
List pgsql-hackers
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

pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: 7.4.2 packaged ...
Next
From: Tom Lane
Date:
Subject: Re: 7.4.2 packaged ...