{"action":"created","issue":{"url":"https://api.github.com/repos/centreon/centreon/issues/2161","repository_url":"https://api.github.com/repos/centreon/centreon","labels_url":"https://api.github.com/repos/centreon/centreon/issues/2161/labels{/name}","comments_url":"https://api.github.com/repos/centreon/centreon/issues/2161/comments","events_url":"https://api.github.com/repos/centreon/centreon/issues/2161/events","html_url":"https://github.com/centreon/centreon/issues/2161","id":97044638,"number":2161,"title":"problem with cron_operation table and running values after reboot","user":{"login":"centreon","id":1890152,"avatar_url":"https://avatars.githubusercontent.com/u/1890152?v=3","gravatar_id":"","url":"https://api.github.com/users/centreon","html_url":"https://github.com/centreon","followers_url":"https://api.github.com/users/centreon/followers","following_url":"https://api.github.com/users/centreon/following{/other_user}","gists_url":"https://api.github.com/users/centreon/gists{/gist_id}","starred_url":"https://api.github.com/users/centreon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/centreon/subscriptions","organizations_url":"https://api.github.com/users/centreon/orgs","repos_url":"https://api.github.com/users/centreon/repos","events_url":"https://api.github.com/users/centreon/events{/privacy}","received_events_url":"https://api.github.com/users/centreon/received_events","type":"Organization","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/centreon/centreon/milestones/9","html_url":"https://github.com/centreon/centreon/milestones/3.0.0","labels_url":"https://api.github.com/repos/centreon/centreon/milestones/9/labels","id":1223521,"number":9,"title":"3.0.0","description":"","creator":{"login":"centreon","id":1890152,"avatar_url":"https://avatars.githubusercontent.com/u/1890152?v=3","gravatar_id":"","url":"https://api.github.com/users/centreon","html_url":"https://github.com/centreon","followers_url":"https://api.github.com/users/centreon/followers","following_url":"https://api.github.com/users/centreon/following{/other_user}","gists_url":"https://api.github.com/users/centreon/gists{/gist_id}","starred_url":"https://api.github.com/users/centreon/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/centreon/subscriptions","organizations_url":"https://api.github.com/users/centreon/orgs","repos_url":"https://api.github.com/users/centreon/repos","events_url":"https://api.github.com/users/centreon/events{/privacy}","received_events_url":"https://api.github.com/users/centreon/received_events","type":"Organization","site_admin":false},"open_issues":112,"closed_issues":141,"state":"open","created_at":"2015-07-24T08:02:48Z","updated_at":"2016-07-06T08:59:56Z","due_on":"2016-08-31T22:00:00Z","closed_at":null},"comments":1,"created_at":"2014-02-13T19:02:34Z","updated_at":"2016-07-06T08:59:56Z","closed_at":"2016-07-06T08:59:56Z","body":"---\n\n\nAuthor Name: **victor hugo dos santos** (victor hugo dos santos)\nOriginal Redmine Issue: 5202, https://forge.centreon.com/issues/5202\nOriginal Date: 2014-02-13\nOriginal Assignee: remi werquin\n\n---\n\nHi,\r\n\r\nthe other day, I reboot my server normaly and all services were stopped and started correctly.\r\nbut, after 3 days... I look in the dashboard page and the values of services status is not correct (all they are showing \"undertemined\" values).\r\n\r\nso... I log in the mysql and that is the output of cron_operation table:\r\n\r\n\r\n*************************\r\n mysql> select * from cron_operation;\r\n +----+-----------------+---------+-------------+-------------------+--------+--------+---------+---------------------+----------+\r\n | id | name            | command | time_launch | last_modification | system | module | running | last_execution_time | activate |\r\n +----+-----------------+---------+-------------+-------------------+--------+--------+---------+---------------------+----------+\r\n |  2 | centAcl.php     | NULL    |  1392317041 |                 0 | 1      | NULL   | 0       |                   0 | 1        |\r\n |  3 | nagiosPerfTrace | NULL    |  1391897402 |                 0 | 1      | NULL   | 1       |                  62 | 1        |\r\n |  4 | logAnalyser     | NULL    |  1392317041 |                 0 | 1      | NULL   | 1       |                   2 | 1        |\r\n +----+-----------------+---------+-------------+-------------------+--------+--------+---------+---------------------+----------+\r\n 3 rows in set (0.00 sec)\r\n*************************\r\n\r\n\r\nSo... the problem is that in the shutdown process, centreon \"dont\" update this table.. and the \"running\" still in \"1\"\r\nand after the reboot, the cron process dont process the logs, because this value is set in 1 and \"never\" change to \"0\" again.\r\n\r\nsolutions (??):\r\n- when the centreon is stopped, update this values to 0 \r\n- when the system boot, make this values to 0 (maybe in the cron at @reboot option)\r\n\r\nthanks and attentive.\r\n\n\n\n"},"comment":{"url":"https://api.github.com/repos/centreon/centreon/issues/comments/230716880","html_url":"https://github.com/centreon/centreon/issues/2161#issuecomment-230716880","issue_url":"https://api.github.com/repos/centreon/centreon/issues/2161","id":230716880,"user":{"login":"julienmathis","id":2294502,"avatar_url":"https://avatars.githubusercontent.com/u/2294502?v=3","gravatar_id":"","url":"https://api.github.com/users/julienmathis","html_url":"https://github.com/julienmathis","followers_url":"https://api.github.com/users/julienmathis/followers","following_url":"https://api.github.com/users/julienmathis/following{/other_user}","gists_url":"https://api.github.com/users/julienmathis/gists{/gist_id}","starred_url":"https://api.github.com/users/julienmathis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/julienmathis/subscriptions","organizations_url":"https://api.github.com/users/julienmathis/orgs","repos_url":"https://api.github.com/users/julienmathis/repos","events_url":"https://api.github.com/users/julienmathis/events{/privacy}","received_events_url":"https://api.github.com/users/julienmathis/received_events","type":"User","site_admin":false},"created_at":"2016-07-06T08:59:56Z","updated_at":"2016-07-06T08:59:56Z","body":"deprecated"}}
{"actor":{"display_login":"julienmathis"}}