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
