Usually db works fine & stable months, but couple days ago it was PANIC, and i have no ideas why this happen.
Nov 5 20:22:30 monstr postgres[16071]: [1] LOG: connection received: host=[local] Nov 5 20:22:30 monstr postgres[16071]: [2] LOG: connection authorized: user=ant database=tele Nov 5 20:22:42 monstr postgres[16071]: [3] PANIC: open of /usr/local/pgsql/data/pg_clog/0040 failed: No such file or directory ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Nov 5 20:22:42 monstr postgres[16071]: [4-1] LOG: statement: select [...] skip the log of failed query (it was just usual query) Nov 5 20:22:42 monstr postgres[1109]: [1] LOG: server process (pid 16071) was terminated by signal 6 Nov 5 20:22:42 monstr postgres[1109]: [2] LOG: terminating any other active server processes Nov 5 20:22:42 monstr postgres[15913]: [3-1] WARNING: Message from PostgreSQL backend: Nov 5 20:22:42 monstr postgres[1412]: [143-1] WARNING: Message from PostgreSQL backend: Nov 5 20:22:42 monstr postgres[15913]: [3-2] ^IThe Postmaster has informed me that some other backend Nov 5 20:22:42 monstr postgres[1412]: [143-2] ^IThe Postmaster has informed me that some other backend Nov 5 20:22:42 monstr postgres[15913]: [3-3] ^Idied abnormally and possibly corrupted shared memory. Nov 5 20:22:42 monstr postgres[1412]: [143-3] ^Idied abnormally and possibly corrupted shared memory. Nov 5 20:22:42 monstr postgres[15913]: [3-4] ^II have rolled back the current transaction and am Nov 5 20:22:42 monstr postgres[1412]: [143-4] ^II have rolled back the current transaction and am Nov 5 20:22:42 monstr postgres[15913]: [3-5] ^Igoing to terminate your database system connection and exit. Nov 5 20:22:42 monstr postgres[1412]: [143-5] ^Igoing to terminate your database system connection and exit. Nov 5 20:22:42 monstr postgres[15913]: [3-6] ^IPlease reconnect to the database system and repeat your query. Nov 5 20:22:42 monstr postgres[1412]: [143-6] ^IPlease reconnect to the database system and repeat your query. Nov 5 20:22:42 monstr postgres[1109]: [3] LOG: all server processes terminated; reinitializing shared memory and semaphores Nov 5 20:22:42 monstr postgres[16077]: [4] LOG: database system was interrupted at 2003-11-05 20:17:48 EET Nov 5 20:22:42 monstr postgres[16077]: [5] LOG: checkpoint record is at 14/E956482C Nov 5 20:22:42 monstr postgres[16077]: [6] LOG: redo record is at 14/E956482C; undo record is at 0/0; shutdown FALSE Nov 5 20:22:42 monstr postgres[16077]: [7] LOG: next transaction id: 13580788; next oid: 190057632 Nov 5 20:22:42 monstr postgres[16077]: [8] LOG: database system was not properly shut down; automatic recovery in progress Nov 5 20:22:42 monstr postgres[16077]: [9] LOG: redo starts at 14/E956486C Nov 5 20:22:42 monstr postgres[16077]: [10] LOG: ReadRecord: record with zero length at 14/E95ACA14 Nov 5 20:22:42 monstr postgres[16077]: [11] LOG: redo done at 14/E95AC9F0 Nov 5 20:22:45 monstr postgres[16077]: [12] LOG: database system is ready so db was restarted succesfully itself but all applications that had static connection (it's tcl apps) where fell the hard disk is fine (might be, because i've used to check it at night time from cron like this: cat /dev/hda > /dev/null), so i have no idea why pg didn't find this file (see error from log). Does someone? system is: Linux 2.4.18-5 (RH) Thank you, Andriy Tkachuk. -- http://www.imt.com.ua ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
