473,322 Members | 1,409 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

postmaster PANIC?

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
0 2394

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Chris Webster | last post by:
I have one process which writes a single float into 300 columns once per second. I then run 4 process, from remote computers, to query a small subset of the latest row. I have even commented...
2
by: Andy Harrison | last post by:
-----BEGIN PGP SIGNED MESSAGE----- Could anyone explain about the max_connections in postgres? We ran into the connection limit on one of our production servers. One reason is that we have...
2
by: pw | last post by:
Hello, I am having problems running postmaster. I get the following error: DEBUG: invoking IpcMemoryCreate(size=1466368) PANIC: invalid checksum in control file The postmaster then...
0
by: Melanie Bergeron | last post by:
Hi all! I have a big problem installing postmaster as a service under Windows XP with cygwin. I already installed postgresql on 2 machines without problems but this machine really seem to don't...
1
by: Durai raj | last post by:
Hello All, After starting the postmaster, I just entered in database like: $ psql test Welcome to psql 7.4.2, the PostgreSQL interactive terminal. Type: \copyright for distribution terms
8
by: Thomas Hallgren | last post by:
I'm writing a small test harness. I have two threads. One that starts the postmaster and another that does all the testing and finally stops the postmaster with a pg_ctl stop. At present, the...
2
by: Ying Lu | last post by:
Hello all, I met a problem about cannot start postmaster. The situation I met is that I was running postmaster, but because of the server closed all my konsole. As a result, I did not...
15
by: niteshkpatil | last post by:
Hi, I am compiling a C program on Hp-UX11.11 using the HP C compiler. % cc test.c (say for example....) I get the following message and the compilation is aborted. % cc: panic 3011:
1
by: cpptutor2000 | last post by:
I am trying to debug some kernel software and running into a kernel panic problem. The OS is Linux 2.6.18 and I am running on a PMC-Sierra processor. When the kernel panic occurs, there is a...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.