sorry , guys, for my english i meant "enterprise db" in subj, not enterprice :)
On Fri, 7 Nov 2003, Andriy Tkachuk wrote: > 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 > С уважением, Андрей Ткачук. http://www.imt.com.ua ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
