[vz-users] Cron job für /var/mail/pi

[wall at gmx.at]

Hab heute zufällig mal in /var/mail/pi reingesehen und festgestellt das da
im 10-Minutentakt Mails abgelegt werden:

 

Hab ich da einen Fehler in der Config? Wobei die funktioniert..

Verbosity ist auf 1

 

Danke

Markus

 

 

 

 

Inhalt:

Date: Tue, 14 Feb 2023 11:20:03 +0100

From: Cron Daemon <root at raspberrypi>

To: pi at raspberrypi

Subject: Cron <pi at raspberrypi> 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, "10", "10", 1, "10"]:

 

  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>...]

 

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