I added the second controller into the configuration. Now I have 2 controllers
with 2 backends each. Each backend is running on its own MySQL server, and the
recovery dbs are collocated on the same MySQL server with 2 of the backends.
Now I run again into the lock error.
******************************
2008-01-23 14:00:35,423 WARN DatabaseBackend.myDB.patricia_seq A worker thread
was still processing task StatementExecuteUpdateTask from transaction
281474976710717 (update log_call_session set call_type=?, city_name=?,
city_selection_count=?, session_ended=?, session_started=?, state_name=?,
version=? where id=? and version=?/<!%S|EXIT_TO_OPERATOR|!%><!%S|Sierra
Vista|!%><!%I|1|!%><!%T|2008-01-23 14:05:13.062|!%><!%T|2008-01-23
14:04:59.5|!%><!%S|Arizona|!%><!%I|1|!%><!%S|5303f576-615c-4830-870d-d2988ba69501|!%><!%I|0|!%>),
aborting the request execution.
2008-01-23 14:00:35,428 INFO sequoia.controller.connection 8 connections freed
on "jdbc:mysql://192.168.50.78:3306/poundtaxi_seq"
2008-01-23 14:00:35,428 WARN sequoia.controller.connection Some connections
are still active, destroying them.
2008-01-23 14:00:35,513 WARN controller.loadbalancer.RAIDb1 Active
transactions after backend patricia_seq is disabled: [43, 281474976710717]
2008-01-23 14:00:35,513 ERROR backend.DatabaseBackend.patricia_seq Request
'update log_call_session set call_type=?,...' failed on backend patricia_seq
but 1 succeeded (java.sql.SQLException: Lock wait timeout exceeded; try
restarting transaction)
2008-01-23 14:00:35,513 WARN backend.DatabaseBackend.patricia_seq Task
execution failed (java.sql.SQLException: Request 'update log_call_session set
call_type=?,...' failed on backend patricia_seq but 1 succeeded
(java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction))
2008-01-23 14:00:35,514 WARN DatabaseBackend.myDB.patricia_seq Unable to
remove task StatementExecuteUpdateTask from transaction 281474976710717 (update
log_call_session set call_type=?, city_name=?, city_selection_count=?,
session_ended=?, session_started=?, state_name=?, version=? where id=? and
version=?/<!%S|EXIT_TO_OPERATOR|!%><!%S|Sierra
Vista|!%><!%I|1|!%><!%T|2008-01-23 14:05:13.062|!%><!%T|2008-01-23
14:04:59.5|!%><!%S|Arizona|!%><!%I|1|!%><!%S|5303f576-615c-4830-870d-d2988ba69501|!%><!%I|0|!%>)
from pending request queue
**********************************
I changed the WaitForCompletion policy to ALL, but that didn't help either. Is
there any other configuration that I can use?
Thanks,
Patricia
---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now._______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
