[ https://forge.continuent.org/jira/browse/SEQUOIA-910?page=comments#action_13722 ]
Emmanuel Cecchet commented on SEQUOIA-910: ------------------------------------------ Guillaume, I re-checked the code and you are right (my post yesterday on the Sequoia mailing list was wrong). I thought we had an infinite retry loop in case of a logging error, but this is not true for request events. They are dropped if they fail twice. You are right that we need a mechanism that tells whether a recovery log is clean or not so that we can prevent recovery operations (besides restore log) to happen in case of a recovery log inconsistency. > Undetected recovery log failure causes a major problem in replication > --------------------------------------------------------------------- > > Key: SEQUOIA-910 > URL: https://forge.continuent.org/jira/browse/SEQUOIA-910 > Project: Sequoia > Type: Bug > Components: Core > Versions: Sequoia 3.0 beta3 > Reporter: Guillaume Smet > > > This is a followup of the thread > https://forge.continuent.org/pipermail/sequoia/2007-February/004683.html on > sequoia list. > In RecoveryLog.getDatabaseConnection(), Sequoia catches RuntimeException and > SQLException but not others. In the case of RuntimeException and > SQLException, a problem to establish the connection is correctly handled > (inserts in the recovery log are postponed) but not in the case of a > ConnectException for instance. > In the case reported by Gérard Bunel, the MySQL server hosting the recovery > log is shutdown and it throws a java.net.ConnectException. Write queries are > not logged in this recovery log and the failure of the recovery log is not > detected by Sequoia. This leads to a synchronisation problem when restarting > the recovery log and enabling the backend as the recovery logs of both > controllers are not identical. > IMHO we should catch every Exception instead of just SQLException in the last > catch of getDatabaseConnection(). > Thoughts? -- 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
