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
To solve this issue, you need to edit a MySQL configuration file.
- Open the following configuration file: mysql.ini or mysql.cnf
Edit it as follows and save your changes:
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.