Title: ALTRAN OUEST
It was ConnectorJ 5.0.4
Guillaume Smet (JIRA) a écrit :
[ https://forge.continuent.org/jira/browse/SEQUOIA-910?page=comments#action_13673 ]
Guillaume Smet commented on SEQUOIA-910:
----------------------------------------
Marc,
Hmmm, I have the source of a version of the MySQL driver and it seems to wrap the exception correctly into a SQLException. I wonder which version of the driver Gérard is using. I ask him on the list.
IMHO, it's not a bad idea to be driver-proof on this problem even if we add a line in the log as you suggest it.
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
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?
--
Gérard
BUNEL
Chef
de Projet
____________________________________________________________________
Technopôle
Brest Iroise
Site du Vernis – CS 23866
29238
Brest Cedex 3
Tél : + 33 2 98 05 43 21
Fax : + 33 2 98 05 20 34
www.altran.com
|
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
