{"action":"created","issue":{"url":"https://api.github.com/repos/quartz-scheduler/quartz/issues/85","repository_url":"https://api.github.com/repos/quartz-scheduler/quartz","labels_url":"https://api.github.com/repos/quartz-scheduler/quartz/issues/85/labels{/name}","comments_url":"https://api.github.com/repos/quartz-scheduler/quartz/issues/85/comments","events_url":"https://api.github.com/repos/quartz-scheduler/quartz/issues/85/events","html_url":"https://github.com/quartz-scheduler/quartz/issues/85","id":189414571,"number":85,"title":"Quartz Scheduler missing trigger simple_triggers table due to presence of trigger in triggers table","user":{"login":"srampv","id":6702943,"avatar_url":"https://avatars.githubusercontent.com/u/6702943?v=3","gravatar_id":"","url":"https://api.github.com/users/srampv","html_url":"https://github.com/srampv","followers_url":"https://api.github.com/users/srampv/followers","following_url":"https://api.github.com/users/srampv/following{/other_user}","gists_url":"https://api.github.com/users/srampv/gists{/gist_id}","starred_url":"https://api.github.com/users/srampv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/srampv/subscriptions","organizations_url":"https://api.github.com/users/srampv/orgs","repos_url":"https://api.github.com/users/srampv/repos","events_url":"https://api.github.com/users/srampv/events{/privacy}","received_events_url":"https://api.github.com/users/srampv/received_events","type":"User","site_admin":false},"labels":[{"id":462130967,"url":"https://api.github.com/repos/quartz-scheduler/quartz/labels/needs%20more%20info","name":"needs more info","color":"c5def5","default":false}],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2016-11-15T15:00:38Z","updated_at":"2016-11-16T03:30:57Z","closed_at":null,"body":"QuartzSchedulerThread will do as below:\r\nfor (TriggerKey triggerKey: misfiredTriggers) {\r\n            OperableTrigger trig = \r\n                retrieveTrigger(conn, triggerKey);\r\n            if (trig == null) {\r\n                continue;\r\n            }\r\n\r\n\r\nretrieveTrigger should return null instead of Exception this caused other triggers to be blocked "},"comment":{"url":"https://api.github.com/repos/quartz-scheduler/quartz/issues/comments/260844153","html_url":"https://github.com/quartz-scheduler/quartz/issues/85#issuecomment-260844153","issue_url":"https://api.github.com/repos/quartz-scheduler/quartz/issues/85","id":260844153,"user":{"login":"srampv","id":6702943,"avatar_url":"https://avatars.githubusercontent.com/u/6702943?v=3","gravatar_id":"","url":"https://api.github.com/users/srampv","html_url":"https://github.com/srampv","followers_url":"https://api.github.com/users/srampv/followers","following_url":"https://api.github.com/users/srampv/following{/other_user}","gists_url":"https://api.github.com/users/srampv/gists{/gist_id}","starred_url":"https://api.github.com/users/srampv/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/srampv/subscriptions","organizations_url":"https://api.github.com/users/srampv/orgs","repos_url":"https://api.github.com/users/srampv/repos","events_url":"https://api.github.com/users/srampv/events{/privacy}","received_events_url":"https://api.github.com/users/srampv/received_events","type":"User","site_admin":false},"created_at":"2016-11-16T03:30:57Z","updated_at":"2016-11-16T03:30:57Z","body":"intially db will be loaded with good data i.e: our application has logic , when jboss is started , we have file watcher which monitor folders and loads proper data into MGMT_TRIGGERS and MGMT_SIMPLE_TRIGGERS table , prefix is defined in spring-core.xml as MGMT . while jobs running as per schedule , at certain point we observed that trigger is being missed MGMT_SIMPLE_TRIGGERS table where as MGMT_TRIGGERS table has that record . since this record is present , exception is thrown and quartz couldn't recover any triggers and everything is stuck . no job runs . \r\nwe have to bounce server to start all jobs as a workaround .  "}}
{"actor":{"display_login":"srampv"}}