By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,852 Members | 2,220 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,852 IT Pros & Developers. It's quick & easy.

postmaster PANIC?

P: n/a
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(Connectio n.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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.