Issue: Director not processing work when using MySQL

Applies to:

MySQL 5.5

Symptom:

Director is unable to process work such as renewing a certificate or generating a report. Certificate renewals will stay in “Queued for renewal” status indefinitely. Reports will not get delivered or become available for download.

Cause:

MySQL sometimes fails to insert a config_lock. This is a bug in MySQL  reported in http://bugs.mysql.com/bug.php?id=65418.

Resolution:

When MySQL is required use version 5.1 or 5.6.