search cancel

Lock wait timeout exceeded; try restarting transaction in Coord log

book

Article ID: 202211

calendar_today

Updated On:

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)

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.

Environment

Release : 10.5

Component : CA Application Test

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.