Skip site navigation (1) Skip section navigation (2)

Test of 8.2beta1 fails

From: "Per Jensen" <per2jensen(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Test of 8.2beta1 fails
Date: 2006-10-10 09:27:06
Message-ID: 8ddb7c4f0610100227m42e6f5f3w1cf1112075420318@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-jdbc
List,

First of all, I am not sure this list is the right one to write to.

I am trying out the postgresql 8.2.beta1 with the jdbc driver contained in '
postgresql-8.2dev-503.jdbc3.jar' downloaded from 'jdbc.postgresql.org'.

The database is accessed through iBatis version 1.3.1 --> jakarta DBCP 1.2.1

I have dumped a production database from  a debian sarge-PG7.4 instance and
restored onto a test PG-8.1.3. This works nicely.

The same dump restored to a test PG-8.2.beta1 works not quite as well, some
queries succeed and some fail.

The exception given on a failed query is:

Client logfile:
-------------------
Caused by: java.io.EOFException
        at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:258)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(
QueryExecutorImpl.java:1164)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(
QueryExecutorImpl.java:190)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(
AbstractJdbc2Statement.java:452)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
AbstractJdbc2Statement.java
:354)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(
AbstractJdbc2Statement.java:258
)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery
(DelegatingPreparedState
ment.java:92)

This is what happens at server side

Server logfile:
-------------------
LOG:  server process (PID 22651) was terminated by signal 11
LOG:  terminating any other active server processes
WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and
repeat your command.
WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the
current transaction and exit, because another server process exited
abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and
repeat your command.
LOG:  all server processes terminated; reinitializing
LOG:  database system was interrupted at 2006-10-10 11:16:01 CEST
LOG:  checkpoint record is at 0/523346C8
LOG:  redo record is at 0/523346C8; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 0/138643; next OID: 6619443
LOG:  next MultiXactId: 1; next MultiXactOffset: 0
LOG:  database system was not properly shut down; automatic recovery in
progress
LOG:  connection received: host=::ffff:127.0.0.1 port=33821
FATAL:  the database system is starting up
LOG:  redo starts at 0/52334710
LOG:  record with zero length at 0/523FC550
LOG:  redo done at 0/523FC528
LOG:  database system is ready
LOG:  transaction ID wrap limit is 2147484172, limited by database
"postgres"
LOG:  connection received: host=::ffff:127.0.0.1 port=33822
LOG:  connection authorized: user=XXXX database=XXXX


Another query gives this error on the client side:
-------------------------------------------------------------------
Caused by: java.io.EOFException
        at org.postgresql.core.PGStream.ReceiveChar(PGStream.java:258)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(
QueryExecutorImpl.java:1164)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(
QueryExecutorImpl.java:190)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(
AbstractJdbc2Statement.java:452)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
AbstractJdbc2Statement.java:354)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(
AbstractJdbc2Statement.java:258)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(
DelegatingPreparedStatement.java:92)
        ... 54 more

where the server once again restarts.

Any hint/idea of what is going is much appreciated.

Regards
Per Jensen

Responses

pgsql-hackers by date

Next:From: Heikki LinnakangasDate: 2006-10-10 10:25:33
Subject: Re: Test of 8.2beta1 fails
Previous:From: Vitali StupinDate: 2006-10-10 07:35:53
Subject: BUG #2683: spi_exec_query in plperl returns column names which are not marked as UTF8

pgsql-jdbc by date

Next:From: Heikki LinnakangasDate: 2006-10-10 10:25:33
Subject: Re: Test of 8.2beta1 fails
Previous:From: Heikki LinnakangasDate: 2006-10-09 21:32:46
Subject: Re: Postgres XA support

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group