{"action":"created","issue":{"url":"https://api.github.com/repos/bolt/bolt/issues/7579","repository_url":"https://api.github.com/repos/bolt/bolt","labels_url":"https://api.github.com/repos/bolt/bolt/issues/7579/labels{/name}","comments_url":"https://api.github.com/repos/bolt/bolt/issues/7579/comments","events_url":"https://api.github.com/repos/bolt/bolt/issues/7579/events","html_url":"https://github.com/bolt/bolt/issues/7579","id":347009371,"node_id":"MDU6SXNzdWUzNDcwMDkzNzE=","number":7579,"title":"Crash in TimedRecords","user":{"login":"Boorj","id":2145313,"node_id":"MDQ6VXNlcjIxNDUzMTM=","avatar_url":"https://avatars0.githubusercontent.com/u/2145313?v=4","gravatar_id":"","url":"https://api.github.com/users/Boorj","html_url":"https://github.com/Boorj","followers_url":"https://api.github.com/users/Boorj/followers","following_url":"https://api.github.com/users/Boorj/following{/other_user}","gists_url":"https://api.github.com/users/Boorj/gists{/gist_id}","starred_url":"https://api.github.com/users/Boorj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Boorj/subscriptions","organizations_url":"https://api.github.com/users/Boorj/orgs","repos_url":"https://api.github.com/users/Boorj/repos","events_url":"https://api.github.com/users/Boorj/events{/privacy}","received_events_url":"https://api.github.com/users/Boorj/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2018-08-02T13:21:28Z","updated_at":"2018-08-02T13:25:46Z","closed_at":null,"author_association":"CONTRIBUTOR","body":"**norepro 😢  **\r\n\r\nI'm having a crash in prod environment (linux centos).\r\n![image](https://user-images.githubusercontent.com/2145313/43585849-4e592d9c-9690-11e8-97b7-cc353b611127.png)\r\nWhen i copy that same base to dev environment (windows) - and everything works ok.\r\n\r\n#### callstack\r\n![image](https://user-images.githubusercontent.com/2145313/43585877-5e08b1d6-9690-11e8-9287-0fde6392d11b.png)\r\n\r\n<details><summary><strong>dump() in text mode {...}</strong></summary>\r\narray:3 [▼\r\n  0 => \"SELECT t.*, GROUP_CONCAT(developers.id) as _developers_id, GROUP_CONCAT(developers.to_id) as _developers_toid, GROUP_CONCAT(incomingrelation.id) as _incomingrelation_id, GROUP_CONCAT(incomingrelation.from_id) as _incomingrelation_fromid, GROUP_CONCAT(incomingrelation.from_contenttype) as _incomingrelation_fromcontenttype FROM bolt_residentials t LEFT JOIN bolt_relations developers ON t.id = developers.from_id AND developers.from_contenttype='residentials' AND developers.to_contenttype='developers' LEFT JOIN bolt_relations incomingrelation ON t.id = incomingrelation.to_id AND incomingrelation.to_contenttype='residentials' WHERE (t.status = :status) AND (status = :status) AND (datepublish < :currenttime) GROUP BY t.id, t.id\"\r\n  1 => array:2 [▼\r\n    \"currenttime\" => Carbon {#2798 ▼\r\n      +\"date\": \"2018-08-02 12:59:41.700550\"\r\n      +\"timezone_type\": 3\r\n      +\"timezone\": \"UTC\"\r\n    }\r\n    \"status\" => \"timed\"\r\n  ]\r\n  2 => array:1 [▼\r\n    \"currenttime\" => \"datetime\"\r\n  ]\r\n]\r\n</details><br>\r\n\r\n\r\nWhen i comment these lines:\r\nhttps://github.com/bolt/bolt/blob/3.5/src/EventListener/StorageEventListener.php#L158-L163\r\neverything works perfectly on production too.\r\n\r\n\r\nSo password is okay, connection is ok. It only breaks in `getTimedRecords`\r\n\r\n_(Database was created in nov 2015)_"},"comment":{"url":"https://api.github.com/repos/bolt/bolt/issues/comments/409925122","html_url":"https://github.com/bolt/bolt/issues/7579#issuecomment-409925122","issue_url":"https://api.github.com/repos/bolt/bolt/issues/7579","id":409925122,"node_id":"MDEyOklzc3VlQ29tbWVudDQwOTkyNTEyMg==","user":{"login":"Boorj","id":2145313,"node_id":"MDQ6VXNlcjIxNDUzMTM=","avatar_url":"https://avatars0.githubusercontent.com/u/2145313?v=4","gravatar_id":"","url":"https://api.github.com/users/Boorj","html_url":"https://github.com/Boorj","followers_url":"https://api.github.com/users/Boorj/followers","following_url":"https://api.github.com/users/Boorj/following{/other_user}","gists_url":"https://api.github.com/users/Boorj/gists{/gist_id}","starred_url":"https://api.github.com/users/Boorj/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Boorj/subscriptions","organizations_url":"https://api.github.com/users/Boorj/orgs","repos_url":"https://api.github.com/users/Boorj/repos","events_url":"https://api.github.com/users/Boorj/events{/privacy}","received_events_url":"https://api.github.com/users/Boorj/received_events","type":"User","site_admin":false},"created_at":"2018-08-02T13:25:46Z","updated_at":"2018-08-02T13:25:46Z","author_association":"CONTRIBUTOR","body":"hm.. looks like it reads all data from DB, so it's on air"}}
{"actor":{"display_login":"Boorj"}}