I have a distributed application that updates statistics informations on
a VDB. The cluster is, during my test, composed of a single controller
and 2 backends
using raidb1 configuration (normally there's 2 controllers holding each
2 backends but, for now i've unactivated one of the controllers). The 2
backends are mysql 5 databases. During the execution I encounter the
following errors. Does soneone knows the meaning of such errors ?
2007-08-06 10:44:49,421 WARN backend.DatabaseBackend.sd02 Task
execution failed (java.sql.SQLException: Request 'select agencystat0_.ID
as ID26_0_, agenc...' failed on backend sd02 (java.sql.SQLException:
Unknown error))
2007-08-06 10:44:49,424 WARN backend.DatabaseBackend.sd01 Task
execution failed (java.sql.SQLException: Request 'select agencystat0_.ID
as ID26_0_, agenc...' failed on backend sd01 (java.sql.SQLException:
Unknown error))
2007-08-06 10:45:13,086 WARN backend.DatabaseBackend.sd01 Unexpected
free lock on table AGENCY_STAT([ID, CATEGORY, CURRENT, MAX, TERMINAL_STAT])
2007-08-06 10:45:13,086 WARN backend.DatabaseBackend.sd01 Unexpected
free lock on table SITE_STAT([ID])
2007-08-06 10:45:13,086 WARN backend.DatabaseBackend.sd01 Unexpected
free lock on table STAT_COUNTERS([ID, COUNTER_TYPE, NAME, NUMBER, SUM,
SUM2, VALUE, AGENCY_COUNTER, INC_COUNTER, SITE_COUNTER])
2007-08-06 10:45:13,088 WARN backend.DatabaseBackend.sd01 Task
execution failed (java.sql.SQLException: Request 'select agencystat0_.ID
as ID26_0_, agenc...' failed on backend sd01 (java.sql.SQLException:
Unknown error))
2007-08-06 10:46:04,560 INFO backend.DatabaseBackend.sd02 Backend
Backend: Name[sd02] State[1] JDBCConnected[true] ActiveTransactions[1]
PersistentConnections[{}] PendingRequests[0] already notified task
StatementExecuteQueryTask from transaction 15677 (select agencystat0_.ID
as ID26_0_, agencystat0_.CATEGORY as CATEGORY26_0_, agencystat0_.CURRENT
as CURRENT26_0_, agencystat0_.MAX as MAX26_0_ from AGENCY_STAT
agencystat0_ where agencystat0_.ID=? for
update/<!%S|ff808081143a580f01143a58968e0001|!%>)
2007-08-06 10:46:04,592 WARN backend.DatabaseBackend.sd01 Task
execution failed (java.sql.SQLException: Request 'select agencystat0_.ID
as ID26_0_, agenc...' failed on backend sd01 (java.sql.SQLException:
Lock wait timeout exceeded; try restarting transaction))
2007-08-06 10:46:04,597 INFO backend.DatabaseBackend.sd01 Backend
Backend: Name[sd01] State[1] JDBCConnected[true] ActiveTransactions[2]
PersistentConnections[{}] PendingRequests[0] already notified task
StatementExecuteQueryTask from transaction 15677 (select agencystat0_.ID
as ID26_0_, agencystat0_.CATEGORY as CATEGORY26_0_, agencystat0_.CURRENT
as CURRENT26_0_, agencystat0_.MAX as MAX26_0_ from AGENCY_STAT
agencystat0_ where agencystat0_.ID=? for
update/<!%S|ff808081143a580f01143a58968e0001|!%>)
2007-08-06 10:46:04,597 WARN controller.virtualdatabase.MATISSEDB
Request select agencystat0_.ID as ID26_0_, agenc... failed, transaction
has been aborted (No backend to execute the request.)
2007-08-06 10:46:04,597 WARN
virtualdatabase.VirtualDatabaseWorkerThread.MATISSEDB Error during
command execution (No backend to execute the request.)
2007-08-06 10:46:04,610 WARN
virtualdatabase.VirtualDatabaseWorkerThread.MATISSEDB Transaction 15677
was aborted by database
2
--
*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 <http://www.altran.com>
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
