Re: what could cause this PANIC on enterprise 7.3.4 db? - Mailing list pgsql-hackers

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
ordirectory
 
>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> 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