Preventing transaction issue when resuming a Job Conductor trigger with a MySQL database

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
Talend Real-Time Big Data Platform
Talend Data Integration
Talend Data Fabric
Talend Big Data
Talend Big Data Platform
Talend ESB
Talend Data Services Platform
Talend Data Management Platform
Talend MDM Platform
task
Deployment > Scheduling > Scheduling Jobs
Data Governance > Third-party systems > Database components > MySQL components
Data Quality and Preparation > Third-party systems > Database components > MySQL components
Design and Development > Third-party systems > Database components > MySQL components
EnrichPlatform
Talend Administration Center
Talend JobServer

Preventing transaction issue when resuming a Job Conductor trigger with a MySQL database

When resuming a trigger on the Job Conductor page of Talend Administration Center, MySQL users may get the following error: Lock wait timeout exceeded; try restarting transaction

To solve this issue, you need to edit a MySQL configuration file.

Procedure

  1. Open the following configuration file: mysql.ini or mysql.cnf
  2. Edit it as follows and save your changes:
    [mysqld]
    transaction-isolation=READ-COMMITTED

    This transaction isolation level will solve the issue at next server start-up.

    For more information on isolation levels, read this section of the MySQL documentation.