BUG #1206: sig fault 12 and core dumps using conflux
The following bug has been logged online:
Bug reference: 1206
Logged by: Ertan Kucukoglu
Email address: ertank@softhome.net
PostgreSQL version: 7.4
Operating system: FreeBSD 5.2-CURRENT (port build)
Description: sig fault 12 and core dumps using conflux
Details:
I just have below lines in my log:
Aug 5 11:40:52 furby kernel: pid 75103 (postgres), uid 70: exited on
Show quoted text
signal 12 (core dumped)
Aug 5 11:40:52 furby postgres[75104]: [5-1] WARNING: terminating
connection because of crash of another server process
Aug 5 11:40:52 furby postgres[75104]: [5-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and
exit, because another server
Aug 5 11:40:52 furby postgres[75104]: [5-3] process exited abnormally
and possibly corrupted shared memory.
Aug 5 11:40:52 furby postgres[75104]: [5-4] HINT: In a moment you should
be able to reconnect to the database and repeat your command.[snipped]
Aug 5 11:40:53 furby postgres[75115]: [5-1] WARNING: terminating
connection because of crash of another server process
Aug 5 11:40:53 furby postgres[75115]: [5-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and
exit, because another server
Aug 5 11:40:53 furby postgres[75115]: [5-3] process exited abnormally
and possibly corrupted shared memory.
Aug 5 11:40:53 furby postgres[75115]: [5-4] HINT: In a moment you should
be able to reconnect to the database and repeat your command.
Aug 5 11:43:14 furby kernel: pid 75133 (postgres), uid 70: exited on
signal 12 (core dumped)
Aug 5 11:43:14 furby postgres[75132]: [8-1] WARNING: terminating
connection because of crash of another server process
Aug 5 11:43:14 furby postgres[75132]: [8-2] DETAIL: The postmaster has
commanded this server process to roll back the current transaction and
exit, because another server
Aug 5 11:43:14 furby postgres[75132]: [8-3] process exited abnormally
and possibly corrupted shared memory.
Aug 5 11:43:14 furby postgres[75132]: [8-4] HINT: In a moment you should
be able to reconnect to the database and repeat your command.
"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
Aug 5 11:40:52 furby kernel: pid 75103 (postgres), uid 70: exited on
signal 12 (core dumped)
Hmm. What is signal 12 on your machine? (/usr/include/signal.h or
/usr/include/sys/signal.h are likely places to look for the answer.)
Can you provide a debugger stack trace from that core file?
regards, tom lane