Skip to main content Skip to complementary content

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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here