Hi,
We are using Postgres 9.1.1 on a board with Coldfire controller.
The postgres processes are crashing and restarting upon executing a particular
instruction and it keeps repeating. Even when we tried with Postgres 9.1.3,
same problem happens.
It works fine until the FINANCIALTRANSACTIONID reaches 1000.
But the same setup is working fine on a windows PC. We have tried to compare
the configuration differences between windows PC and the board and found that
only difference is the Shared Buffers which is 32 on the PC and 24 on the board.
I am pasting the server log from the board here.
The line highlighted in yellow is the instruction which is causing the crash.
Please let us know why this crash is happening and how we can fix it.
LOG: redo starts at 0/D9B75B4
LOG: record with zero length at 0/D9BBE5C
LOG: redo done at 0/D9BBE22
LOG: last completed transaction was at log time 2012-05-22 02:22:26.641488+00
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
ERROR: duplicate key value violates unique constraint
"financialtransaction_pkey"
DETAIL: Key (financialtransactionid)=(1004) already exists.
STATEMENT: Insert into FINANCIALTRANSACTION
(ATTENDANT,ENGINEHOUR,RECEIPTPRINTED,FINANCIALTRANSACTIONID) values
('0','0.0','0','1004')
LOG: server process (PID 4016) was terminated by signal 11: Segmentation fault
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited abnormally
and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat
your command.
FATAL: poll() failed in statistics collector: Unknown error 516
LOG: statistics collector process (PID 3962) exited with exit code 1
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted; last known up at 2012-05-22 02:22:29 UTC
LOG: database system was not properly shut down; automatic recovery in progress
LOG: consistent recovery state reached at 0/D9BBEAA
LOG: redo starts at 0/D9BBEAA
LOG: record with zero length at 0/D9C07FA
LOG: redo done at 0/D9C07C0
LOG: last completed transaction was at log time 2012-05-22 02:23:05.372245+00
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
ERROR: duplicate key value violates unique constraint
"financialtransaction_pkey"
DETAIL: Key (financialtransactionid)=(1004) already exists.
STATEMENT: Insert into FINANCIALTRANSACTION
(ATTENDANT,ENGINEHOUR,RECEIPTPRINTED,FINANCIALTRANSACTIONID) values
('0','0.0','0','1004')
LOG: server process (PID 4098) was terminated by signal 11: Segmentation fault
LOG: terminating any other active server processes
WARNING: terminating connection because of crash of another server process
DETAIL: The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited abnormally
and possibly corrupted shared memory.
HINT: In a moment you should be able to reconnect to the database and repeat
your command.
FATAL: poll() failed in statistics collector: Unknown error 516
LOG: statistics collector process (PID 4035) exited with exit code 1
LOG: all server processes terminated; reinitializing
LOG: database system was interrupted; last known up at 2012-05-22 02:23:08 UTC
LOG: database system was not properly shut down; automatic recovery in progress
LOG: consistent recovery state reached at 0/D9C0848
LOG: redo starts at 0/D9C0848
LOG: record with zero length at 0/D9C5218
LOG: redo done at 0/D9C51DE
LOG: last completed transaction was at log time 2012-05-22 02:23:49.659502+00
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
Thanks and Regards
Jayashankar
Larsen & Toubro Limited
www.larsentoubro.com
This Email may contain confidential or privileged information for the intended
recipient (s). If you are not the intended recipient, please do not use or
disseminate the information, notify the sender and delete it from your system.
Earth Day. Every Day.
