{"action":"created","issue":{"url":"https://api.github.com/repos/centreon/centreon/issues/6192","repository_url":"https://api.github.com/repos/centreon/centreon","labels_url":"https://api.github.com/repos/centreon/centreon/issues/6192/labels{/name}","comments_url":"https://api.github.com/repos/centreon/centreon/issues/6192/comments","events_url":"https://api.github.com/repos/centreon/centreon/issues/6192/events","html_url":"https://github.com/centreon/centreon/issues/6192","id":312452087,"number":6192,"title":"[2.8.19] SQL Deadlock","user":{"login":"Crash-Fox","id":29780310,"avatar_url":"https://avatars3.githubusercontent.com/u/29780310?v=4","gravatar_id":"","url":"https://api.github.com/users/Crash-Fox","html_url":"https://github.com/Crash-Fox","followers_url":"https://api.github.com/users/Crash-Fox/followers","following_url":"https://api.github.com/users/Crash-Fox/following{/other_user}","gists_url":"https://api.github.com/users/Crash-Fox/gists{/gist_id}","starred_url":"https://api.github.com/users/Crash-Fox/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Crash-Fox/subscriptions","organizations_url":"https://api.github.com/users/Crash-Fox/orgs","repos_url":"https://api.github.com/users/Crash-Fox/repos","events_url":"https://api.github.com/users/Crash-Fox/events{/privacy}","received_events_url":"https://api.github.com/users/Crash-Fox/received_events","type":"User","site_admin":false},"labels":[{"id":324064296,"url":"https://api.github.com/repos/centreon/centreon/labels/status/more-info-needed","name":"status/more-info-needed","color":"eb6420","default":false},{"id":384633866,"url":"https://api.github.com/repos/centreon/centreon/labels/status/needs-attention","name":"status/needs-attention","color":"0052cc","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-04-09T09:11:31Z","updated_at":"2018-04-26T14:27:17Z","closed_at":null,"author_association":"NONE","body":"<!--\r\nIf you are reporting a new issue, make sure that we do not have any duplicates already open. You \r\ncan ensure this by searching the issue list for this repository. If there is a duplicate, please \r\nclose your issue and add a comment to the existing issue instead.\r\n\r\nIf you think that your problem is a bug, please add a description organized like the BUG REPORT \r\nINFORMATION shown below. If you can't provide all this information, it's possible that we will not \r\nbe able to debug and fix your problems, and so we will be obliged to close the ticket. Nevertheless, \r\nYou will be able to provide them later in order to reactivate it. \r\n\r\nWhen we need more information, we will reply in order to ask some element in order. If you do not answer \r\nin the next 30 days, the ticket will be automaticaly closed.\r\n\r\nThank you to describe your issue in English.\r\n-->\r\n\r\n---------------------------------------------------\r\nBUG REPORT INFORMATION\r\n---------------------------------------------------\r\n\r\n**Centreon Web version**: 2.8.19\r\n\r\n**Centreon Engine version**: 1.8.1\r\n\r\n**OS**: CentOS 6.9\r\n\r\n**Steps to reproduce the issue:**\r\n1. Go to Configuration --> Poller --> Export configuration\r\n2. Select one or more collectors\r\n3. Select \"Deplacer les fichiers générés\" and \"Redémarrer l'ordonnanceur\"\r\n4. Click on the Export button\r\n\r\n**Describe the results you received:**\r\nAfter few seconds, the error **SQLSTATE[40001]: Serialization Failure: 1213 Deadlock found ... [file:/usr/share/centreon/www/class/config-generate/generate.class.php] [line: 112]** is displayed.\r\n\r\n**Describe the results you expected:**\r\nIt shouldn't appeared and we shouldn't have to continuosly restart this process (for exporting and reloading/restarting the configuration on collectors) until no Deadlock error appeared.\r\n\r\n**Additional information you think important (e.g. issue happens only occasionally):**\r\nPlease find attached to this ticket the show full processlist output (txt file.\r\n[show_full_processlist.txt](https://github.com/centreon/centreon/files/1889168/show_full_processlist.txt)\r\n)"},"comment":{"url":"https://api.github.com/repos/centreon/centreon/issues/comments/384660697","html_url":"https://github.com/centreon/centreon/issues/6192#issuecomment-384660697","issue_url":"https://api.github.com/repos/centreon/centreon/issues/6192","id":384660697,"user":{"login":"Crash-Fox","id":29780310,"avatar_url":"https://avatars3.githubusercontent.com/u/29780310?v=4","gravatar_id":"","url":"https://api.github.com/users/Crash-Fox","html_url":"https://github.com/Crash-Fox","followers_url":"https://api.github.com/users/Crash-Fox/followers","following_url":"https://api.github.com/users/Crash-Fox/following{/other_user}","gists_url":"https://api.github.com/users/Crash-Fox/gists{/gist_id}","starred_url":"https://api.github.com/users/Crash-Fox/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Crash-Fox/subscriptions","organizations_url":"https://api.github.com/users/Crash-Fox/orgs","repos_url":"https://api.github.com/users/Crash-Fox/repos","events_url":"https://api.github.com/users/Crash-Fox/events{/privacy}","received_events_url":"https://api.github.com/users/Crash-Fox/received_events","type":"User","site_admin":false},"created_at":"2018-04-26T14:27:17Z","updated_at":"2018-04-26T14:27:17Z","author_association":"NONE","body":"We have currently 6 collectors\r\nThe repartition of hosts/services is very different from each of them:\r\n\r\n- Collector 1: 644 Hosts\r\n- Collector 2: 92 Hosts\r\n- Collector 3: 1366 Hosts\r\n- Collector 4: 194 Hosts\r\n- Collector 5: 128 Hosts\r\n- Collector 6: 1502 Hosts"}}
{"actor":{"display_login":"Crash-Fox"}}