Auto Recovary failuer when backend crash.
-----------------------------------------
Key: SEQUOIA-936
URL: https://forge.continuent.org/jira/browse/SEQUOIA-936
Project: Sequoia
Type: Bug
Versions: Sequoia 2.10.6
Environment: RHL4.0 / Jboss 4 and postgresSQL 8
Reporter: indika maligaspe
We are using sequoia with 2 backend nodes. The sequoia controller and 1 backend
is in one server whilst the 2nd backend is in another server. We are currently
doing some testing on different scenarios. The following is out test.
Enable both backends , let the system update both backends, after a while
disable one backend and then continue with the updates. After about 10 updates,
we again enable the disabled backend and sequoia seems to update the enabled
backend with the missing entries.
However if we do the same test and at a certain time crash one backend without
disabling that backend, when we try to enable that backend sequoia does not
seam to be able to recover the missing entries. Also I do not see a checkpoint
when the backend got disabled, where as if we manually disabled the backend we
get a checkpoint.
Is this how sequoia works? Or am I missing something here? Because I think if a
backend crashes then there should be a checkpoint entry for that and when the
backend comes online sequoia should be able to re-run the missing updates when
we enable the backend.
Another issue is we have around 300K transactions happening for a day (some
small and some bit heavy). So our rcovarylog table (which is also in postgres)
keeps growing so within a month we have huge number of rows. What I would like
to know is, when a backend goes offline and we try to enable again, does
sequoia replays the full recoverylog from the initial restore, or does it only
need the entries from the disabled checkpoint onwards. If that is the case we
can keep clearing the recovarylog table daily unless there is a backend failure
so that we can recover from that point onwards.
--
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
