Test of 8.2beta1 fails

Поиск
Список
Период
Сортировка
От Per Jensen
Тема Test of 8.2beta1 fails
Дата
Msg-id 8ddb7c4f0610100227m42e6f5f3w1cf1112075420318@mail.gmail.com
обсуждение исходный текст
Ответы Re: Test of 8.2beta1 fails
Re: Test of 8.2beta1 fails
Список 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

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Postgres XA support
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Test of 8.2beta1 fails