Lock wait timeout exceeded; try restarting transaction in Coord log

Products

• CA Cloud Test Mobile
• CA Application Test

Issue/Introduction

Seeing below error in Coordinator log files.  Maria db is not being used with DevTest.  MySQL is configured for the DevTest components

 

ERROR com.itko.lisa.history.InternalQueueToDb - Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.BatchUpdateException: (conn=404483) Lock wait timeout exceeded; try restarting transaction

Caused by: java.sql.SQLException: (conn=404483) Lock wait timeout exceeded; try restarting transaction
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:184)
        at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:106)
        at org.mariadb.jdbc.MariaDbStatement.executeBatchExceptionEpilogue(MariaDbStatement.java:279)
        ... 43 more
Caused by: java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
Query is: INSERT INTO HST_PROPERTY_INFO (PROP_ID, PROP_NAME, TIME_STAMP, TIME_STAMP_TS, PROP_VALUE, STEP_STEP_RUN_ID, TEST_TEST_RUN_ID, PTYPE)

Environment

Release : 10.5

Component : CA Application Test

Cause

There is a Maria JDBC Driver in the same path. Since MariaDB resolves for both "jdbc:mariadb" and "jdbc:mysql", it is picked up instead of MySQL JDBC Driver.

Resolution

An additional property "disableMariaDbDriver" added to SQL JDBC URL will prevent MariaJDBC Driver from being used for DevTest Components.

Please follow the steps below:

1. Edit file site.properties on Coordinator server

Existing: lisadb.pool.common.url=jdbc:mysql://<server>:<Port>/<dbname>useSSL=false

Change it to

lisadb.pool.common.url=jdbc:mysql://<server>:<Port>/<dbname>useSSL=false&disableMariaDbDriver

2. Save the file and restart all the DevTest components; Registry, Coordinator, Simulator.