Hi, since I updated to 2.6.5, mysql is running amok. /srv/www/obs/api/log/delayed_job.log containing many entries and some like this: E, [2015-10-13T08:32:45.780268 #5420] ERROR -- : 2015-10-13T08:32:45+0200: [Worker(delayed_job.2 host:buildservice pid:5420)] Job SendEventEmails (id=499046) FAILED (0 prior attempts) with ActiveRecord::StatementInvalid: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: DELETE FROM `delayed_jobs` WHERE `delayed_jobs`.`id` = 499046 I, [2015-10-13T08:04:15.614209 #5414] INFO -- : 2015-10-13T08:04:15+0200: [Worker(delayed_job.1 host:buildservice pid:5414)] Error while reserving job: Mysql2::Error: Deadlock found when trying to get lock; try restarting transaction: UPDATE `delayed_jobs` SET `delayed_jobs`.`locked_at` = '2015-10-13 06:04:11', `delayed_jobs`.`locked_by` = 'delayed_job.1 host:buildservice pid:5414' WHERE ((run_at <= '2015-10-13 06:04:11' AND (locked_at IS NULL OR locked_at < '2015-10-13 02:04:11') OR locked_by = 'delayed_job.1 host:buildservice pid:5414') AND failed_at IS NULL) AND `delayed_jobs`.`queue` IN ('quick') ORDER BY priority ASC, run_at ASC LIMIT 1 buildservice:~ # grep "Deadlock found when" /srv/www/obs/api/log/delayed_job.log | wc -l 1081 Did something went wrong on my system or is that a general problem? MariaDB [(none)]> SHOW FULL PROCESSLIST; +-----+------+-----------+----------------+---------+------+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ | Id | User | Host | db | Command | Time | State | Info | Progress | +-----+------+-----------+----------------+---------+------+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ | 90 | obs | localhost | api_production | Sleep | 46 | | NULL | 0.000 | | 91 | obs | localhost | api_production | Query | 1 | init | UPDATE `delayed_jobs` SET `delayed_jobs`.`locked_at` = '2015-10-13 06:48:37', `delayed_jobs`.`locked_by` = 'delayed_job.0 host:buildservice pid:5408' WHERE ((run_at <= '2015-10-13 06:48:37' AND (locked_at IS NULL OR locked_at < '2015-10-13 02:48:37') OR locked_by = 'delayed_job.0 host:buildservice pid:5408') AND failed_at IS NULL) AND `delayed_jobs`.`queue` IN ('quick') ORDER BY priority ASC, run_at ASC LIMIT 1 | 0.000 | | 92 | obs | localhost | api_production | Query | 4 | init | UPDATE `delayed_jobs` SET `delayed_jobs`.`locked_at` = '2015-10-13 06:48:34', `delayed_jobs`.`locked_by` = 'delayed_job.1 host:buildservice pid:5414' WHERE ((run_at <= '2015-10-13 06:48:34' AND (locked_at IS NULL OR locked_at < '2015-10-13 02:48:34') OR locked_by = 'delayed_job.1 host:buildservice pid:5414') AND failed_at IS NULL) AND `delayed_jobs`.`queue` IN ('quick') ORDER BY priority ASC, run_at ASC LIMIT 1 | 0.000 | | 93 | obs | localhost | api_production | Query | 0 | init | UPDATE `delayed_jobs` SET `delayed_jobs`.`locked_at` = '2015-10-13 06:48:38', `delayed_jobs`.`locked_by` = 'delayed_job.2 host:buildservice pid:5420' WHERE ((run_at <= '2015-10-13 06:48:38' AND (locked_at IS NULL OR locked_at < '2015-10-13 02:48:38') OR locked_by = 'delayed_job.2 host:buildservice pid:5420') AND failed_at IS NULL) AND `delayed_jobs`.`queue` IN ('quick') ORDER BY priority ASC, run_at ASC LIMIT 1 | 0.000 | | 94 | obs | localhost | api_production | Sleep | 2 | | NULL | 0.000 | | 95 | obs | localhost | api_production | Sleep | 3 | | NULL | 0.000 | | 96 | obs | localhost | api_production | Query | 0 | updating | DELETE FROM `delayed_jobs` WHERE `delayed_jobs`.`id` = 499660 | 0.000 | | 97 | obs | localhost | api_production | Sleep | 5 | | NULL | 0.000 | | 98 | obs | localhost | api_production | Sleep | 1620 | | NULL | 0.000 | | 99 | obs | localhost | api_production | Sleep | 10 | | NULL | 0.000 | | 100 | obs | localhost | api_production | Sleep | 441 | | NULL | 0.000 | | 101 | root | localhost | NULL | Query | 0 | init | SHOW FULL PROCESSLIST | 0.000 | +-----+------+-----------+----------------+---------+------+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------+ 12 rows in set (0.00 sec) -- mit freundlichen Gruessen/with best regards, Carsten Hoeger Open-Xchange GmbH -------------------------------------------------------------------------------- Open-Xchange AG, Rollnerstr. 14, 90408 Nürnberg, Amtsgericht Nürnberg HRB 24738 Vorstand: Rafael Laguna de la Vera, Carsten Dirks Aufsichtsratsvorsitzender: Richard Seibt European Office: Open-Xchange GmbH, Martinstr. 41, D-57462 Olpe, Germany Amtsgericht Siegen, HRB 8718, Geschäftsführer: Frank Hoberg, Martin Kauss US Office: Open-Xchange. Inc., 530 Lytton Avenue, Palo Alto, CA 94301, USA --------------------------------------------------------------------------------