{"id":1675,"date":"2022-08-30T15:18:30","date_gmt":"2022-08-30T15:18:30","guid":{"rendered":"https:\/\/unknownerror.org\/index.php\/2013\/11\/27\/what-is-the-best-way-to-handle-warning-mysql_connect-too-many-connections-with-kohana-3-collection-of-common-programming-errors\/"},"modified":"2022-08-30T15:18:30","modified_gmt":"2022-08-30T15:18:30","slug":"what-is-the-best-way-to-handle-warning-mysql_connect-too-many-connections-with-kohana-3-collection-of-common-programming-errors","status":"publish","type":"post","link":"https:\/\/unknownerror.org\/index.php\/2022\/08\/30\/what-is-the-best-way-to-handle-warning-mysql_connect-too-many-connections-with-kohana-3-collection-of-common-programming-errors\/","title":{"rendered":"What is the best way to handle “Warning: mysql_connect(): Too many connections” with Kohana 3?-Collection of common programming errors"},"content":{"rendered":"

I’ve got a web application that is used by a company for logging their employees’ work.<\/p>\n

A lot of people are often logged in at once.<\/p>\n

The application runs on a shared host.<\/p>\n

I sometimes receive…<\/p>\n

\n

Warning: mysql_connect() [function.mysql-connect]: Too many connections<\/p>\n<\/blockquote>\n

Which then lets further errors cascade… like errors with mysql_select_db()<\/code>, mysql_error()<\/code>, mysql_errnon()<\/code> and finally the uncaught Database_Eexception<\/code>.<\/p>\n

When I run my main request, I wrap it in a try<\/code> and capture any exception and display a not found<\/em> page. This is because usually my controllers throw exceptions if a resource is not found (though the route may be valid) e.g. http:\/\/example.com\/products\/30<\/code> is a valid route, but product #30 doesn’t exist.<\/p>\n

What is the best way to handle the too many connections<\/em>? Ideally I’d like to capture that exception separately, then display a nice page that informs the employee to try again in 5 minutes.<\/p>\n

The code that runs my main request in application\/bootstrap.php<\/code> looks like this…<\/p>\n

$request = Request::instance();\n\ntry {\n    $request->execute();\n} catch (Exception $e) {\n\n    if (Kohana::$environment === Kohana::DEVELOPMENT) throw $e;\n\n    \/\/ Log the error\n    Kohana::$log->add(Kohana::ERROR, Kohana::exception_text($e));\n\n    \/\/ Create a 404 response\n    $request->status = 404;\n    $request->response = Request::factory(Route::get('catch_all')->uri(array('path' => 'errors\/404')))->execute();\n}\n\n$request->send_headers();\necho $request->response;\n<\/code><\/pre>\n
Thanks for any help!<\/p>\n
    \n
  1. \n
    I just created such file to handle all the errors:<\/p>\n<\/li>\n<\/ol>\n
    Originally posted 2013-11-27 12:27:01. <\/small><\/p>","protected":false},"excerpt":{"rendered":"
    I’ve got a web application that is used by a company for logging their employees’ work. A lot of people are often logged in at once. The application runs on a shared host. I sometimes receive… Warning: mysql_connect() [function.mysql-connect]: Too many connections Which then lets further errors cascade… like errors with mysql_select_db(), mysql_error(), mysql_errnon() and […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1675","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1675","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/comments?post=1675"}],"version-history":[{"count":0,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/posts\/1675\/revisions"}],"wp:attachment":[{"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/media?parent=1675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/categories?post=1675"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unknownerror.org\/index.php\/wp-json\/wp\/v2\/tags?post=1675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}