Hello,
I'm currently facing a problem with lock on database.
I do intensive read/write queries and the log report may Lock timeout:
Backend MATISSEDB - BackendWorkerThread for backend 'sd02' with RAIDb
level:1 failed (Lock wait timeout exceeded; try restarting transaction)
So that nothing is writen in database.
When doing the same test without sequoia, directly querying MySQL
(5.0.37 under Linux RHEL 4, Connector/J 5.0.5)
I have no problem.
So should there be a configuration problem ? I've attached the VDB
configuration
Any help appreciated
Gerard
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.4//EN" "http://sequoia.continuent.org/dtds/sequoia-2.10.4.dtd";>
<SEQUOIA>
<VirtualDatabase name="DB">
<!-- Distribution hederaPropertiesFile="/hedera_jgroups.properties" clientFailoverTimeout="120000" -->
<Distribution hederaPropertiesFile="/hedera_appia.properties" clientFailoverTimeout="120000">
<MessageTimeouts/>
</Distribution>
<Backup>
<Backuper backuperName="MySQLBackuper"
className="org.continuent.sequoia.controller.backup.backupers.MySQLBackuper"
options="zip=true"/>
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password=""/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user" vPassword="****"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="sd01" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://ptrimd02/db?zeroDateTimeBehavior=convertToNull&autoReconnect=true" connectionTestStatement="select 1">
<ConnectionManager vLogin="user" rLogin="user" rPassword="****">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="10" maxPoolSize="100" idleTimeout="60" waitTimeout="30"/>
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="sd02" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://ptrimd03/db?zeroDateTimeBehavior=convertToNull&autoReconnect=true" connectionTestStatement="select 1">
<ConnectionManager vLogin="user" rLogin="user" rPassword="****">
<VariablePoolConnectionManager initPoolSize="10" minPoolSize="10" maxPoolSize="100" idleTimeout="60" waitTimeout="30"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough" waitForSuspendedTransactionsTimeout="0" waitForPersistentConnectionsTimeout="0"/>
</RequestScheduler>
<RequestCache>
<MetadataCache/>
<ParsingCache/>
</RequestCache>
<LoadBalancer transactionIsolation="readCommitted">
<!-- LoadBalancer -->
<RAIDb-1>
<WaitForCompletion policy="all" enforceTableLocking="false" deadlockTimeoutInMs="50000"/>
<!-- WaitForCompletion policy="all"/ -->
<RAIDb-1-RoundRobin/>
<!-- RAIDb-1-LeastPendingRequestsFirst/ -->
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost/seq_recovery" login="seq_user" password="****">
<RecoveryLogTable tableName="RECOVERY" logIdColumnType="BIGINT NOT NULL"
vloginColumnType="TEXT NOT NULL" sqlColumnType="TEXT NOT NULL"
sqlParamColumnType="TEXT"
sqlColumnName="sql_data"
extraStatementDefinition=",PRIMARY KEY (log_id)"/>
<CheckpointTable tableName="CHECKPOINT"
logIdColumnType="BIGINT"
extraStatementDefinition=",PRIMARY KEY (name)"
checkpointNameColumnType="VARCHAR(255) NOT NULL"/>
<BackendTable tableName="BACKEND"
databaseNameColumnType="TEXT NOT NULL"
backendNameColumnType="TEXT NOT NULL"
checkpointNameColumnType="TEXT NOT NULL"/>
<DumpTable tableName="DUMP" dumpNameColumnType="TEXT NOT NULL"
dumpDateColumnType="TIMESTAMP"
dumpPathColumnType="TEXT NOT NULL"
dumpFormatColumnType="TEXT NOT NULL"
tablesColumnName="tables_"
checkpointNameColumnType="TEXT NOT NULL"
backendNameColumnType="TEXT NOT NULL"
tablesColumnType="TEXT NOT NULL"/>
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
