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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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

Browse pgsql-hackers by date

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

Browse pgsql-jdbc by date

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