postmaster PANIC? - Mailing list pgsql-general
From | Jeremiah Elliott |
---|---|
Subject | postmaster PANIC? |
Date | |
Msg-id | 200311202234.16592.jelliott@artcobell.com Whole thread Raw |
List | pgsql-general |
I have a java application that pulls data off db2/400 an inserts it into a postgres(7.3.2) database. The jdbc errors out with this message: ConnectionBean: Driver not loaded Something unusual has occured to cause the driver to fail. Please report this exception: Exception: java.sql.SQLException: FATAL: The database system is starting up Stack Trace: java.sql.SQLException: FATAL: The database system is starting up at org.postgresql.Connection.openConnection(Connection.java:178) at org.postgresql.Driver.connect(Driver.java:149) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at schedule.MyConnection0.Connect(MyConnection0.java:72) This is the postgres log file: could someone explain to me what the data/pg_clog/0202 file is? LOG: checkpoint record is at 28/B469B6C8 LOG: redo record is at 28/B469B6C8; undo record is at 0/0; shutdown TRUE LOG: next transaction id: 124790609; next oid: 26680076 LOG: database system is ready LOG: pq_flush: send() failed: Broken pipe LOG: pq_recvbuf: unexpected EOF on client connection PANIC: open of /usr/local/pgsql/data/pg_clog/0202 failed: No such file or directory LOG: statement: delete from sodetailtabletrans LOG: server process (pid 1679) was terminated by signal 6 LOG: terminating any other active server processes WARNING: Message from PostgreSQL backend: The Postmaster has informed me that some other backend died abnormally and possibly corrupted shared memory. I have rolled back the current transaction and am going to terminate your database system connection and exit. Please reconnect to the database system and repeat your query. LOG: all server processes terminated; reinitializing shared memory and semaphores FATAL: The database system is starting up LOG: database system was interrupted at 2003-11-20 22:53:26 CST LOG: checkpoint record is at 28/B469B6C8 LOG: redo record is at 28/B469B6C8; undo record is at 0/0; shutdown TRUE LOG: next transaction id: 124790609; next oid: 26680076 LOG: database system was not properly shut down; automatic recovery in progress LOG: redo starts at 28/B469B708 LOG: ReadRecord: unexpected pageaddr 28/A97C8000 in log file 40, segment 180, offset 8159232 LOG: redo done at 28/B47C6B50 FATAL: The database system is starting up FATAL: The database system is starting up FATAL: The database system is starting up LOG: database system is ready LOG: pq_recvbuf: unexpected EOF on client connection LOG: recycled transaction log file 00000028000000B4 Thanks Jeremiah
pgsql-general by date: