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:

Previous
From: "Jordan S. Jones"
Date:
Subject: SuSE PostgreSQL 7.4 RPMS
Next
From: Tom Lane
Date:
Subject: Re: Psql bug?