[vz-users] Restart worker #5505 because it reached max requests of 1000

[Michael Hartmann]

Hallo,

 

cron schickt mir alle 10min eine Email da folgender Job fehlschlägt: */10 * * * *  php /var/www/volkszaehler.org/bin/aggregate run -m delta -l minute >/dev/null

 

 

In AbstractMySQLDriver.php line 128:

 

  An exception occurred while executing 'REPLACE INTO aggregate (channel_id,

  type, timestamp, value, count) SELECT channel_id, ? AS type, MAX(agg.timest

  amp) AS timestamp, COALESCE( SUM(agg.val_by_time) / (MAX(agg.timestamp) - M

  IN(agg.prev_timestamp)), AVG(agg.value)) AS value, COUNT(agg.value) AS coun

  t FROM ( SELECT channel_id, timestamp, value, value * (timestamp - @prev_ti

  mestamp) AS val_by_time, COALESCE(@prev_timestamp, 0) AS prev_timestamp, @p

  rev_timestamp := timestamp FROM data CROSS JOIN (SELECT @prev_timestamp :=

  UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(MAX(timestamp) / 1000, "%Y-%m-%d %H:%

  i:00"), INTERVAL 1 minute)) * 1000 FROM aggregate WHERE type = ? AND aggreg

  ate.channel_id = ?) AS vars WHERE channel_id = ? AND timestamp >= IFNULL((S

  ELECT UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(MAX(timestamp) / 1000, "%Y-%m-%

  d %H:%i:00"), INTERVAL 1 minute)) * 1000 FROM aggregate WHERE type = ? AND

  aggregate.channel_id = ? ), 0) AND timestamp < UNIX_TIMESTAMP(DATE_FORMAT(N

  OW(), "%Y-%m-%d %H:%i:00")) * 1000 ) AS agg GROUP BY channel_id, YEAR(FROM_

  UNIXTIME(timestamp/1000)), DAYOFYEAR(FROM_UNIXTIME(timestamp/1000)), HOUR(F

  ROM_UNIXTIME(timestamp/1000)), MINUTE(FROM_UNIXTIME(timestamp/1000))' with

  params [1, 1, "3", "3", 1, "3"]:

 

  SQLSTATE[22012]: Division by zero: 1365 Division by 0

 

 

In Exception.php line 18:

 

  SQLSTATE[22012]: Division by zero: 1365 Division by 0

 

 

In PDOStatement.php line 117:

 

  SQLSTATE[22012]: Division by zero: 1365 Division by 0

 

 

run [-l|--level LEVEL] [-m|--mode MODE] [-p|--periods PERIODS] [-v|--verbose] [--] [<uuid>...]

 

Der Status der middleware gibt folgendes:

 

pi at SmartHomeServer:~ $ sudo systemctl status middleware

● middleware.service - Volkszaehler.org Middleware

     Loaded: loaded (/etc/systemd/system/middleware.service; enabled; vendor preset: enabled)

     Active: active (running) since Thu 2022-12-29 15:57:06 CET; 1 months 22 days ago

   Main PID: 565 (php)

      Tasks: 9 (limit: 4163)

        CPU: 3h 42min 40.936s

     CGroup: /system.slice/middleware.service

             ├─   565 /usr/bin/php /var/www/volkszaehler.org/vendor/bin/ppm start -c /var/www/volkszaehler.org/etc/middleware.json --cgi-pa>

             ├─620136 /usr/bin/php -C /tmp/dbgUnv6PW

             ├─620491 /usr/bin/php -C /tmp/dbgGCfJWU

             ├─621064 /usr/bin/php -C /tmp/dbgXg6YoU

             ├─621454 /usr/bin/php -C /tmp/dbgbk1jjT

             ├─621798 /usr/bin/php -C /tmp/dbgHjQNoW

             ├─622230 /usr/bin/php -C /tmp/dbg43raBU

             ├─622675 /usr/bin/php -C /tmp/dbgDTJG3U

             └─623318 /usr/bin/php -C /tmp/dbguizneT

 

Feb 20 00:03:41 SmartHomeServer php[565]: Restart worker #5504 because it reached max requests of 1000

Feb 20 00:52:10 SmartHomeServer php[565]: Restart worker #5505 because it reached max requests of 1000

Feb 20 01:40:10 SmartHomeServer php[565]: Restart worker #5506 because it reached max requests of 1000

Feb 20 02:29:30 SmartHomeServer php[565]: Restart worker #5507 because it reached max requests of 1000

Feb 20 03:22:10 SmartHomeServer php[565]: Restart worker #5508 because it reached max requests of 1000

Feb 20 04:10:10 SmartHomeServer php[565]: Restart worker #5501 because it reached max requests of 1000

Feb 20 04:58:41 SmartHomeServer php[565]: Restart worker #5502 because it reached max requests of 1000

Feb 20 05:46:10 SmartHomeServer php[565]: Restart worker #5503 because it reached max requests of 1000

Feb 20 06:34:21 SmartHomeServer php[565]: Restart worker #5504 because it reached max requests of 1000

Feb 20 07:22:36 SmartHomeServer php[565]: Restart worker #5505 because it reached max requests of 1000

­­­­­­­­­­­­­

Die middleware ist weiterhin über das Frontend erreichbar es sind auch laufend Daten eingegangen. Auch ein restart der middleware schafft keine Abhilfe. Ich habe KEINE Änderungen vorgenommen!

 

Was ist da plötzlich los?

 

Grüße

 

Micha

 

 

-------------- nächster Teil --------------
Ein Dateianhang mit HTML-Daten wurde abgetrennt...
URL: <http://demo.volkszaehler.org/pipermail/volkszaehler-users/attachments/20230220/924c1961/attachment.html>