Bus error in postgres 8.3
От | Peter Koczan |
---|---|
Тема | Bus error in postgres 8.3 |
Дата | |
Msg-id | 4544e0330804282205odfcac5al6bca78bd27c8751b@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Bus error in postgres 8.3
(Tom Lane <tgl@sss.pgh.pa.us>)
Re: Bus error in postgres 8.3 ("Pavan Deolasee" <pavan.deolasee@gmail.com>) |
Список | pgsql-admin |
Hi all, I'm looking to push 8.3 out this week, but I'm running into a particularly nasty bus error. I'm not sure what's causing it as it appears to be transient (or at least somewhat random), but I do know that it bites on connection time and takes down the entire server with it. I'm going to try to force a crash on my test server to see if I can find out anything more. Does anyone know how to get useful debugging info at the time of the crash? I don't think I have things set to dump core anywhere, but that and/or stack traces would be nice (especially for child processes). If anyone has any idea what's going on and could clue me in, that would be excellent. Peter P.S. Here's the syslog transcript of the crash. Apr 28 23:02:02 mitchell postgres[3442]: [3-1] LOG: connection received: host=mitchell.cs.wisc.edu port=37588 Apr 28 23:02:02 mitchell postgres[3442]: [4-1] LOG: connection authorized: user=postgres database=template1 Apr 28 23:02:02 mitchell postgres[3442]: [5-1] LOG: disconnection: session time: 0:00:00.239 user=postgres database=template1 host=mitchell.cs.wisc.edu port=37588 Apr 28 23:02:02 mitchell postgres[3444]: [3-1] LOG: connection received: host=mitchell.cs.wisc.edu port=37589 Apr 28 23:02:02 mitchell postgres[3444]: [4-1] LOG: connection authorized: user=postgres database=564testdb Apr 28 23:02:02 mitchell postgres[461]: [3-1] LOG: server process (PID 3444) was terminated by signal 7: Bus error Apr 28 23:02:02 mitchell postgres[461]: [4-1] LOG: terminating any other active server processes Apr 28 23:02:02 mitchell postgres[461]: [5-1] LOG: all server processes terminated; reinitializing Apr 28 23:02:02 mitchell postgres[3447]: [6-1] LOG: connection received: host=mitchell.cs.wisc.edu port=37590 Apr 28 23:02:02 mitchell postgres[3447]: [7-1] FATAL: the database system is in recovery mode Apr 28 23:02:02 mitchell postgres[3448]: [6-1] LOG: connection received: host=mitchell.cs.wisc.edu port=37591 Apr 28 23:02:02 mitchell postgres[3448]: [7-1] FATAL: the database system is in recovery mode Apr 28 23:02:23 mitchell postgres[461]: [6-1] LOG: startup process (PID 3446) was terminated by signal 7: Bus error Apr 28 23:02:23 mitchell postgres[461]: [7-1] LOG: aborting startup due to startup process failure Apr 28 23:22:15 mitchell postgres[3702]: [1-1] LOG: could not load root certificate file "root.crt": No such file or directory Apr 28 23:22:15 mitchell postgres[3702]: [1-2] DETAIL: Will not verify client certificates. Apr 28 23:22:15 mitchell postgres[3703]: [2-1] LOG: database system was interrupted; last known up at 2008-04-28 07:02:32 CDT Apr 28 23:22:15 mitchell postgres[3703]: [3-1] LOG: database system was not properly shut down; automatic recovery in progress Apr 28 23:22:15 mitchell postgres[3703]: [4-1] LOG: record with zero length at 6/915320A0
В списке pgsql-admin по дате отправления: