postmaster PANIC?

From: Jeremiah Elliott <jelliott(at)artcobell(dot)com>
To: "PgSQL General ML" <pgsql-general(at)postgresql(dot)org>
Subject: postmaster PANIC?
Date: 2003-11-21 04:34:16
Message-ID: 200311202234.16592.jelliott@artcobell.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-11-21 05:04:46 Re: Psql bug?
Previous Message Jordan S. Jones 2003-11-21 01:20:14 SuSE PostgreSQL 7.4 RPMS