statusengine / worker

PHP worker process that writes all event data to a storage backend
https://statusengine.org/worker/#overview
GNU General Public License v3.0
9 stars 8 forks source link

Statusengine crash with to many Performancedata #37

Open tinoklauer opened 1 year ago

tinoklauer commented 1 year ago

Hello,

i get the following error message if there is too much performance data, e.g. 2 years or more.

"<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\" \"http://www.w3.org/TR/html4/loose.dtd\">\n\n \n <meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />\n The requested URL could not be retrieved\n <link href=\"http://passthrough.fw-notify.net/static/default.css\" rel=\"stylesheet\" type=\"text/css\" />\n <script type=\"text/javascript\" src=\"http://passthrough.fw-notify.net/static/default.js\">\n \n <body onload=\"checkResize();\">\n <div id=\"emsg_large\">

\n <div id=\"page\">\n <div id=\"header\">\n
<img src=\"http://passthrough.fw-notify.net/static/topbar_left.png\" width=\"6\" height=\"72\" border=\"0\" />
\n <div id=\"company_logo\"><img src=\"http://passthrough.fw-notify.net/static/logo.png\" border=\"0\" />
\n <div id=\"company_text\"><h1 class=\"orange\">UTM 9 http://www.sophos.com\n
<img src=\"http://passthrough.fw-notify.net/static/topbar_right.png\" width=\"6\" height=\"72\" border=\"0\" />
\n \n <br class=\"clearer\" />\n\n <div id=\"content\">\n <img src=\"http://passthrough.fw-notify.net/static/warning.png\" border=\"0\" align=\"left\" />\n <h1 class=\"orange\">An error occurred while handling your request\n\n <div class=\"line\">\n <div class=\"label\">While trying to retrieve the URL:\n <div class=\"desc\"> \n http://XXX.XXX.XXX.XXX/api/index.php/servicedetails?hostname=XXXXXXX&amp;servicedescription=E:+drive+space\n \n \n\n <div class=\"line\">\n <div class=\"label\">The content could not be delivered due to the following condition:\n <div class=\"desc\"> \n Timeout while reading response from Server\n \n \n\n <div class=\"line\">\n <div class=\"label\">Your cache administrator is:\n <div class=\"desc\"> \n XXXX@XXXXX\n \n \n <br class=\"clearer\" />\n \n <br class=\"clearer\" />\n\n <div id=\"footer\">\n
<a href=\"http://www.sophos.com\" target=\"_blank\" title=\"Sophos\"><img src=\"http://passthrough.fw-notify.net/static/footer_left.png\" width=\"136\" height=\"33\" border=\"0\" />
\n <div class=\"orange\" id=\"copyright\">Powered by UTM Web Protection\n
<img src=\"http://passthrough.fw-notify.net/static/footer_right.png\" width=\"6\" height=\"33\" border=\"0\" />
\n \n \n \n\n"

The Statuseninge crasht and after a long time it can be used again.

thanks

nook24 commented 1 year ago

Without further information it is hard to diagnose the root cause for this. What storage backend do you use for performance data? Graphite, MySQL, CrateDB or Elasticsearch?

The error message you have posted is not from Statusengine, it is from your Sophos (Reverse?) Proxy. It says Timeout while reading response from Server. So i assume that your storage backend is just loading to long to return the data. You are probably using MySQL? If this is the issue, than you need to increase PHPs max_execution_time so that the Statusengine UI has more time to wait for the database. You could also optimize your database.

It could also be an timeout from your Sophos proxy.