bgwriter bails out
| От | John Hansen |
|---|---|
| Тема | bgwriter bails out |
| Дата | |
| Msg-id | 5066E5A966339E42AA04BA10BA706AE55FC2@rodrick.geeknet.com.au обсуждение исходный текст |
| Список | 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
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 по дате отправления: