Gérard,
On 2/2/07, Gérard BUNEL <[EMAIL PROTECTED]> wrote:
here is the full stack trace from full_cluster.log. In fact there's as many
stack trace as there are client queries.
Can you provide me the full log file?
I dig a bit more on this problem yesterday evening and AFAICS you
should have lines like:
21:47:01,721 ERROR sequoia.controller.recoverylog WARNING! Your
recovery log is probably corrupted, you should perform a restore log
operation
And the exception should be nested into a SQLException.
With PostgreSQL, I have the following lines for each query:
21:47:01,714 ERROR sequoia.controller.recoverylog Failed to log update
test set message='6' where message='plop'
org.postgresql.util.PSQLException: FATAL: terminating connection due
to administrator command
at
org.postgresql.core.v2.QueryExecutorImpl.receiveErrorMessage(QueryExecutorImpl.java:557)
at
org.postgresql.core.v2.QueryExecutorImpl.processResults(QueryExecutorImpl.java:480)
at
org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:364)
at
org.postgresql.core.v2.QueryExecutorImpl.execute(QueryExecutorImpl.java:258)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:308)
at
org.continuent.sequoia.controller.recoverylog.events.LogRequestEvent.execute(LogRequestEvent.java:102)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:732)
21:47:01,721 ERROR sequoia.controller.recoverylog Failed to log update
test set message='6' where message='plop'
java.sql.SQLException: Failed to get connection
(org.postgresql.util.PSQLException: Connection refused. Check that the
hostname and port are correct and that the postmaster is accepting
TCP/IP connections.)
at
org.continuent.sequoia.controller.recoverylog.RecoveryLog.getDatabaseConnection(RecoveryLog.java:336)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.getLogPreparedStatement(LoggerThread.java:114)
at
org.continuent.sequoia.controller.recoverylog.events.LogRequestEvent.execute(LogRequestEvent.java:75)
at
org.continuent.sequoia.controller.recoverylog.LoggerThread.run(LoggerThread.java:732)
21:47:01,721 ERROR sequoia.controller.recoverylog WARNING! Your
recovery log is probably corrupted, you should perform a restore log
operation
Thanks,
--
Guillaume
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
