{"action":"created","issue":{"url":"https://api.github.com/repos/modoboa/modoboa-amavis/issues/28","repository_url":"https://api.github.com/repos/modoboa/modoboa-amavis","labels_url":"https://api.github.com/repos/modoboa/modoboa-amavis/issues/28/labels{/name}","comments_url":"https://api.github.com/repos/modoboa/modoboa-amavis/issues/28/comments","events_url":"https://api.github.com/repos/modoboa/modoboa-amavis/issues/28/events","html_url":"https://github.com/modoboa/modoboa-amavis/issues/28","id":149506343,"number":28,"title":"amavis slow long running select","user":{"login":"blendi-93","id":4957651,"avatar_url":"https://avatars.githubusercontent.com/u/4957651?v=3","gravatar_id":"","url":"https://api.github.com/users/blendi-93","html_url":"https://github.com/blendi-93","followers_url":"https://api.github.com/users/blendi-93/followers","following_url":"https://api.github.com/users/blendi-93/following{/other_user}","gists_url":"https://api.github.com/users/blendi-93/gists{/gist_id}","starred_url":"https://api.github.com/users/blendi-93/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/blendi-93/subscriptions","organizations_url":"https://api.github.com/users/blendi-93/orgs","repos_url":"https://api.github.com/users/blendi-93/repos","events_url":"https://api.github.com/users/blendi-93/events{/privacy}","received_events_url":"https://api.github.com/users/blendi-93/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2016-04-19T16:03:18Z","updated_at":"2016-04-27T14:05:37Z","closed_at":null,"body":"my cpus going crazy while mysql is using 100%\r\n\r\n    mysql> SHOW FULL PROCESSLIST;\r\n\r\none of the lonrunning:\r\n\r\n    | Id    | User    | Host                             | db      | Command | Time | State        | Info                                                                                                                                                                                                                                                                                                                    \r\n    |  1758 | amavis  | netzwerkplan01.mivitec.net:48759 | amavis  | Query   | 7712 | Sending data | SELECT COUNT(*) AS `__count` FROM `msgrcpt` INNER JOIN `maddr` ON ( `msgrcpt`.`rid` = `maddr`.`id` ) INNER JOIN `msgs` ON ( `msgrcpt`.`mail_id` = `msgs`.`mail_id` ) WHERE (`msgrcpt`.`rs` IN (' ', 'V', 'R', 'p', 'S', 'H') AND `maddr`.`email` REGEXP BINARY '(sadoni.net)' AND (`msgrcpt`.`mail_id`) IN (SELECT U0.`mail_id` FROM `quarantine` U0 WHERE U0.`chunk_ind` = 1)) |\r\n\r\nId|User|Host|db|Command|Time|State|Info\r\n---|---|---|---|---|---|---|---\r\n65|dovecot|localhost|modoboa|Sleep|0||NULL\r\n66|dovecot|localhost|modoboa|Sleep|0||NULL\r\n1757|modoboa|netzwerkplan01.mivitec.net:48758|modoboa|Sleep|7745||NULL\r\n1758|amavis|netzwerkplan01.mivitec.net:48759|amavis|Query|7745|Sending data|SELECT COUNT(*) AS `__count` FROM `msgrcpt` INNER JOIN `maddr` ON ( `msgrcpt`.`rid` = `maddr`.`id` ) INNER JOIN `msgs` ON ( `msgrcpt`.`mail_id` = `msgs`.`mail_id` ) WHERE (`msgrcpt`.`rs` IN (' ', 'V', 'R', 'p', 'S', 'H') AND `maddr`.`email` REGEXP BINARY '(sadoni.net)' AND (`msgrcpt`.`mail_id`) IN (SELECT U0.`mail_id` FROM `quarantine` U0 WHERE U0.`chunk_ind` = 1))\r\n1806|modoboa|netzwerkplan01.mivitec.net:48817|modoboa|Sleep|7721||NULL\r\n1807|amavis|netzwerkplan01.mivitec.net:48818|amavis|Query|7721|Sending data|SELECT COUNT(*) AS `__count` FROM `msgrcpt` INNER JOIN `maddr` ON ( `msgrcpt`.`rid` = `maddr`.`id` ) INNER JOIN `msgs` ON ( `msgrcpt`.`mail_id` = `msgs`.`mail_id` ) WHERE (`msgrcpt`.`rs` IN (' ', 'V', 'R', 'p', 'S', 'H') AND `maddr`.`email` IN ('nwp@sadoni.net') AND (`msgrcpt`.`mail_id`) IN (SELECT U0.`mail_id` FROM `quarantine` U0 WHERE U0.`chunk_ind` = 1))\r\n1830|modoboa|netzwerkplan01.mivitec.net:48847|modoboa|Sleep|7712||NULL\r\n1831|amavis|netzwerkplan01.mivitec.net:48848|amavis|Query|7712|Sending data|SELECT COUNT(*) AS `__count` FROM `msgrcpt` INNER JOIN `maddr` ON ( `msgrcpt`.`rid` = `maddr`.`id` ) INNER JOIN `msgs` ON ( `msgrcpt`.`mail_id` = `msgs`.`mail_id` ) WHERE (`msgrcpt`.`rs` IN (' ', 'V', 'R', 'p', 'S', 'H') AND `maddr`.`email` IN ('nwp@sadoni.net') AND (`msgrcpt`.`mail_id`) IN (SELECT U0.`mail_id` FROM `quarantine` U0 WHERE U0.`chunk_ind` = 1))\r\n16309|dovecot|localhost|modoboa|Sleep|2144||NULL\r\n19989|dovecot|localhost|modoboa|Sleep|566||NULL\r\n20853|modoboa|localhost:42798|modoboa|Sleep|13||NULL\r\n20855|modoboa|localhost:42799|modoboa|Sleep|13||NULL\r\n20856|modoboa|localhost:42800|modoboa|Sleep|13||NULL\r\n20857|modoboa|localhost:42801|modoboa|Sleep|13||NULL\r\n20858|modoboa|localhost:42802|modoboa|Sleep|13||NULL\r\n20859|modoboa|localhost:42803|modoboa|Sleep|13||NULL\r\n21480|modoboa|localhost:42804|modoboa|Sleep|13||NULL\r\n21481|modoboa|localhost:42805|modoboa|Sleep|13||NULL\r\n21482|dovecot|localhost|modoboa|Sleep|7||NULL\r\n21487|modoboa|localhost:42807|modoboa|Sleep|13||NULL\r\n21491|root|localhost|NULL|Query|0|NULL|SHOW FULL PROCESSLIST\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/modoboa/modoboa-amavis/issues/comments/215094481","html_url":"https://github.com/modoboa/modoboa-amavis/issues/28#issuecomment-215094481","issue_url":"https://api.github.com/repos/modoboa/modoboa-amavis/issues/28","id":215094481,"user":{"login":"tonioo","id":531694,"avatar_url":"https://avatars.githubusercontent.com/u/531694?v=3","gravatar_id":"","url":"https://api.github.com/users/tonioo","html_url":"https://github.com/tonioo","followers_url":"https://api.github.com/users/tonioo/followers","following_url":"https://api.github.com/users/tonioo/following{/other_user}","gists_url":"https://api.github.com/users/tonioo/gists{/gist_id}","starred_url":"https://api.github.com/users/tonioo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tonioo/subscriptions","organizations_url":"https://api.github.com/users/tonioo/orgs","repos_url":"https://api.github.com/users/tonioo/repos","events_url":"https://api.github.com/users/tonioo/events{/privacy}","received_events_url":"https://api.github.com/users/tonioo/received_events","type":"User","site_admin":false},"created_at":"2016-04-27T14:05:37Z","updated_at":"2016-04-27T14:05:37Z","body":"That's strange... Maybe too many modoboa cron jobs are running at the same time ?"}}