{"action":"closed","issue":{"url":"https://api.github.com/repos/CachetHQ/Cachet/issues/2082","repository_url":"https://api.github.com/repos/CachetHQ/Cachet","labels_url":"https://api.github.com/repos/CachetHQ/Cachet/issues/2082/labels{/name}","comments_url":"https://api.github.com/repos/CachetHQ/Cachet/issues/2082/comments","events_url":"https://api.github.com/repos/CachetHQ/Cachet/issues/2082/events","html_url":"https://github.com/CachetHQ/Cachet/issues/2082","id":172762454,"number":2082,"title":"General error: 1615 Prepared statement needs to be re-prepared","user":{"login":"karthik-22feb","id":17992464,"avatar_url":"https://avatars.githubusercontent.com/u/17992464?v=3","gravatar_id":"","url":"https://api.github.com/users/karthik-22feb","html_url":"https://github.com/karthik-22feb","followers_url":"https://api.github.com/users/karthik-22feb/followers","following_url":"https://api.github.com/users/karthik-22feb/following{/other_user}","gists_url":"https://api.github.com/users/karthik-22feb/gists{/gist_id}","starred_url":"https://api.github.com/users/karthik-22feb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/karthik-22feb/subscriptions","organizations_url":"https://api.github.com/users/karthik-22feb/orgs","repos_url":"https://api.github.com/users/karthik-22feb/repos","events_url":"https://api.github.com/users/karthik-22feb/events{/privacy}","received_events_url":"https://api.github.com/users/karthik-22feb/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-08-23T17:46:08Z","updated_at":"2016-08-23T17:50:59Z","closed_at":"2016-08-23T17:50:59Z","body":"Hi Team,\r\n\r\nI am using the latest version of CACHE ( 2.3.0-RC4) with Mysql 5.0.11 & PHP 5.5.9\r\n\r\nSometimes i get \"Error 500 - internal server error\" in my website. (Refer screenshot)\r\n\r\nThis error resolves automatically after sometime without clearing the cache in BOOTSTRAP folder. The log always shows one common error message saying 'General error: 1615 Prepared statement needs to be re-prepared' '\r\n\r\nThis error occurs randomly and it clears at some point. Please let me know how to avoid this error permanently \r\n\r\nError Log:\r\nNext exception 'Illuminate\\Database\\QueryException' with message 'SQLSTATE[HY000]: General error: 1615 Prepared statement needs to be re-prepared (SQL: select * from `incidents` where (`scheduled_at` is null or `scheduled_at` <= 2016-08-23 12:54:12) and `visible` >= 1 and `created_at` between 2016-08-17 00:00:00 and 2016-08-23 23:59:59 and `incidents`.`deleted_at` is null order by `scheduled_at` desc, `created_at` desc)' in /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Database/Connection.php:713\r\nStack trace:\r\n#0 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Database/Connection.php(669): Illuminate\\Database\\Connection->runQueryCallback('select * from `...', Array, Object(Closure))\r\n#1 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Database/Connection.php(342): Illuminate\\Database\\Connection->run('select * from `...', Array, Object(Closure))\r\n#2 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1583): Illuminate\\Database\\Connection->select('select * from `...', Array, true)\r\n#3 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php(1569): Illuminate\\Database\\Query\\Builder->runSelect()\r\n#4 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(624): Illuminate\\Database\\Query\\Builder->get(Array)\r\n#5 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php(316): Illuminate\\Database\\Eloquent\\Builder->getModels(Array)\r\n#6 /web/sites/catalog/cachet/app/Http/Controllers/StatusPageController.php(92): Illuminate\\Database\\Eloquent\\Builder->get()\r\n#7 [internal function]: CachetHQ\\Cachet\\Http\\Controllers\\StatusPageController->showIndex()\r\n#8 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Controller.php(80): call_user_func_array(Array, Array)\r\n#9 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(146): Illuminate\\Routing\\Controller->callAction('showIndex', Array)\r\n#10 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(94): Illuminate\\Routing\\ControllerDispatcher->call(Object(CachetHQ\\Cachet\\Http\\Controllers\\StatusPageController), Object(Illuminate\\Routing\\Route), 'showIndex')\r\n#11 [internal function]: Illuminate\\Routing\\ControllerDispatcher->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\r\n#12 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))\r\n#13 [internal function]: Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\r\n#14 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))\r\n#15 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(96): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\r\n#16 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php(54): Illuminate\\Routing\\ControllerDispatcher->callWithinStack(Object(CachetHQ\\Cachet\\Http\\Controllers\\StatusPageController), Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request), 'showIndex')\r\n#17 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Route.php(174): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request), 'CachetHQ\\Cachet...', 'showIndex')\r\n#18 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Route.php(140): Illuminate\\Routing\\Route->runController(Object(Illuminate\\Http\\Request))\r\n#19 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Router.php(724): Illuminate\\Routing\\Route->run(Object(Illuminate\\Http\\Request))\r\n#20 [internal function]: Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\r\n#21 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))\r\n#22 /web/sites/catalog/cachet/app/Http/Middleware/Localize.php(59): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\r\n#23 [internal function]: CachetHQ\\Cachet\\Http\\Middleware\\Localize->handle(Object(Illuminate\\Http\\Request), Object(Closure))\r\n#24 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(136): call_user_func_array(Array, Array)\r\n#25 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\r\n#26 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))\r\n#27 /web/sites/catalog/cachet/app/Http/Middleware/ReadyForUse.php(40): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\r\n#28 [internal function]: CachetHQ\\Cachet\\Http\\Middleware\\ReadyForUse->handle(Object(Illuminate\\Http\\Request), Object(Closure))\r\n#29 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(136): call_user_func_array(Array, Array)\r\n#30 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\r\n#31 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))\r\n#32 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(64): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\r\n#33 [internal function]: Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken->handle(Object(Illuminate\\Http\\Request), Object(Closure))\r\n#34 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(136): call_user_func_array(Array, Array)\r\n#35 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\r\n#36 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))\r\n#37 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\r\n#38 [internal function]: Illuminate\\View\\Middleware\\ShareErrorsFromSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\r\n#39 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(136): call_user_func_array(Array, Array)\r\n#40 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\r\n#41 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))\r\n#42 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(62): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\r\n#43 [internal function]: Illuminate\\Session\\Middleware\\StartSession->handle(Object(Illuminate\\Http\\Request), Object(Closure))\r\n#44 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(136): call_user_func_array(Array, Array)\r\n#45 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\r\n#46 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))\r\n#47 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\r\n#48 [internal function]: Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse->handle(Object(Illuminate\\Http\\Request), Object(Closure))\r\n#49 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(136): call_user_func_array(Array, Array)\r\n#50 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\r\n#51 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))\r\n#52 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(59): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\r\n#53 [internal function]: Illuminate\\Cookie\\Middleware\\EncryptCookies->handle(Object(Illuminate\\Http\\Request), Object(Closure))\r\n#54 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(136): call_user_func_array(Array, Array)\r\n#55 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\r\n#56 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))\r\n#57 [internal function]: Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\r\n#58 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))\r\n#59 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Router.php(726): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\r\n#60 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Router.php(699): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request))\r\n#61 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Router.php(675): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request))\r\n#62 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(246): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request))\r\n#63 [internal function]: Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request))\r\n#64 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(52): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))\r\n#65 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/CheckForMaintenanceMode.php(44): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\r\n#66 [internal function]: Illuminate\\Foundation\\Http\\Middleware\\CheckForMaintenanceMode->handle(Object(Illuminate\\Http\\Request), Object(Closure))\r\n#67 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(136): call_user_func_array(Array, Array)\r\n#68 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\r\n#69 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))\r\n#70 /web/sites/catalog/cachet/vendor/fideloper/proxy/src/TrustProxies.php(46): Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\r\n#71 [internal function]: Fideloper\\Proxy\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure))\r\n#72 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(136): call_user_func_array(Array, Array)\r\n#73 [internal function]: Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request))\r\n#74 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php(32): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))\r\n#75 [internal function]: Illuminate\\Routing\\Pipeline->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request))\r\n#76 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(103): call_user_func(Object(Closure), Object(Illuminate\\Http\\Request))\r\n#77 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(132): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\r\n#78 /web/sites/catalog/cachet/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(99): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request))\r\n#79 /web/sites/catalog/cachet/public/index.php(54): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request))\r\n#80 {main} {\"identification\":{\"id\":\"eba33053-e284-4587-b680-e4e518576c5f\"}} \r\n\r\n\r\n![internal_server_error](https://cloud.githubusercontent.com/assets/17992464/17903027/dcdea048-6937-11e6-9d5f-c5c427a9993a.jpg)\r\n\r\nThanks,\r\nKarthik "}}
{"actor":{"display_login":"GrahamCampbell"}}