Re: [Sequoia] Strange result with recovery

Gérard BUNEL Wed, 31 Jan 2007 08:07:44 -0800

Title: ALTRAN OUEST

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

Re: [Sequoia] Strange result with recovery

Reply via email to