[ https://forge.continuent.org/jira/browse/SEQUOIA-974?page=all ]
Robert Hodges resolved SEQUOIA-974:
-----------------------------------
Resolution: Fixed
Checked in code in Sequoia 2.10 to fix problem w/ recovery log errors due to
connection invalidation. At this point the recovery log connection handling is
better. It could be made better still by eliminating the task to watch for
idle connections and adding a timer to invalidate recovery log connections over
the idleConnectionTimeout value in RecoveryLog.getDatabaseConnection().
However, that is a task for yet another day.
> Recovery log does not correctly invalidate prepared statements when idle
> connection is timed out
> ------------------------------------------------------------------------------------------------
>
> Key: SEQUOIA-974
> URL: https://forge.continuent.org/jira/browse/SEQUOIA-974
> Project: Sequoia
> Type: Bug
> Components: Recovery Log
> Versions: Sequoia 2.10.9
> Reporter: Robert Hodges
> Assignee: Robert Hodges
> Fix For: sequoia 2.10.10
>
>
> The LoggerThread prepared statements provided by getUpdatePreparedStatement()
> and getLogPreparedStatement() are not correctly invalidated when the JDBC
> connection is timed out in RecoveryLog.invalidateInternalConnection(). This
> causes unnecessary and confusing errors in the log because we try to use
> cached prepared statements that are attached to a dead connection that has
> been discarded and depending on the DBMS server settings may be loggedout.
> Also, it is possible that it is preventing connections from being properly
> garbage collected when they are invalidated (nulled out), since there may be
> a backwards reference to the JDBC connection from the prepare statement
> instances, which are in turn still held by the LoggerThread instance.
> This should be corrected by moving the prepared statements into the
> RecoveryLog and synchronizing with connection invalidation.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
