Hi, i had a rather strange crash of my server (log file at the end of my mailling) and i was googling for Signal 4 and read http://en.wikipedia.org/wiki/SIGILL i am running on linux 2.6.18-5-686 and postgresql-8.1.9-0etch2. Most (all?) other processes on this machine got signal 4 at this time also (postfix, munin), etc As i understood my reading about signal 4, there must be some kind of hardware failure as the postgresql log says, too. I rebooted the server and since then everything works fine. But i am going to drop this server and replace it with a new one of course. I just want to ask if there is something else besideds hardware failure which could force a signall 4 (ILL)? I am asking as i did a lot of CREATE/DROP Tables before to move some data back and forth between to schemas. Is it possible that massive creating and dropping of tables generated this error. If so, i have to rethink my sql script. Otherwise i just would replace the hardware. here is my log: LOG: server process (PID 27884) was terminated by signal 4 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. WARNING: terminating connection because of crash of another server process [...] 26 times LOG: all server processes terminated; reinitializing LOG: database system was interrupted at 2007-12-31 13:43:49 CET LOG: checkpoint record is at 4/D401C5FC LOG: redo record is at 4/D401C5FC; undo record is at 0/0; shutdown FALSE LOG: next transaction ID: 22378390; next OID: 373396 LOG: next MultiXactId: 2; next MultiXactOffset: 3 LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at 4/D401C640 LOG: record with zero length at 4/D401E88C LOG: redo done at 4/D401E864 LOG: database system is ready LOG: transaction ID wrap limit is 2147484146, limited by database "postgres" LOG: database system was interrupted at 2007-12-31 13:43:59 CET LOG: checkpoint record is at 4/D401E88C LOG: redo record is at 4/D401E88C; undo record is at 0/0; shutdown TRUE LOG: next transaction ID: 22378414; next OID: 373396 LOG: next MultiXactId: 2; next MultiXactOffset: 3 LOG: database system was not properly shut down; automatic recovery in progress LOG: incomplete startup packet LOG: record with zero length at 4/D401E8D0 LOG: redo is not required LOG: database system is ready LOG: transaction ID wrap limit is 2147484146, limited by database "postgres" kind regards, janning ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
