what could cause this PANIC on enterprice 7.3.4 db? - Mailing list pgsql-hackers

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