I'm maybe completely stupid, maybed really tired.
The test I tried was not correct.
My objective was to test a backend failure, but as I stopped mysql
services, I also put the RecoveryLog in a failed state (yes both are on
the same machine, not having sufficient cpu resources).
So this test was more or less a controller failure test.
Sorry for the disturbance.
But, this point out some feature I'm looking at: Alert generation on
backend failure, controller failure.
How can this be done ?
I've seen in the log4j.properties that it could be possible to register
an Appender on FATAL level message in order to send alarms, but is
there somewhere a list of possible FATAL errors from Sequoia ? is
backend or controller failure considered as FATAL ?
Gérard
Gérard BUNEL a écrit :
Guillaume Smet a écrit :
On 1/31/07, Gérard BUNEL <[EMAIL PROTECTED]>
wrote:
maybe this can help: When I type the command "show backend *" "the
item last known checkpoint" is set to <unknown>
No, it's not a problem.
Could you take a look at what is in your recovery log? To debug this
sort of problem I usually put the recovery log in a real db instead of
hsqldb, it's easier to debug.
That's OK, my recoveryLog is also a mysql database.
If it's a problem for you and if the recovery log is not
too long, you
can simply use:
vdb(admin) > debug on
vdb(admin) > dump recoverylog
to see the content of the recovery log.
Or you can set a jdbc client to access to the hsqldb recovery log.
I've used mysqldump and the following record is the last inserted in
the recovery table, and corresponds to what is in the database (398)
after enabling it.
But it's not what's in the other database nor in the other controller
recoveryLog.
INSERT INTO `RECOVERY` (`log_id`, `vlogin`, `sql_data`,
`sql_data_param`, `auto_conn_tran`, `transaction_id`, `request_id`,
`exec_status`, `exec_time`, `update_count`) VALUES("1196", "TEST",
"update Counter set COUNTER=? where ID=?",
"<!%L|398|!%><!%S|Singleton|!%>", "T", "183", "366", "S",
"2", "1");
INSERT INTO `RECOVERY` (`log_id`, `vlogin`, `sql_data`,
`sql_data_param`, `auto_conn_tran`, `transaction_id`, `request_id`,
`exec_status`, `exec_time`, `update_count`) VALUES("1195", "TEST",
"begin", NULL, "T", "183", "0", "S", "0", "-1");
INSERT INTO `RECOVERY` (`log_id`, `vlogin`, `sql_data`,
`sql_data_param`, `auto_conn_tran`, `transaction_id`, `request_id`,
`exec_status`, `exec_time`, `update_count`) VALUES("1194", "TEST",
"commit", NULL, "T", "182", "0", "S", "0", "0");
--
Guillaume
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
--
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
--
ALTRAN OUEST
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
|
