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