<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto">Kannst Du das Kommando bitte nochmal mit -v ausführen damit ich den Verursacher der Fehlermeldung sehr?<br><br>Wäre es evtl möglich mir einen Dump Deiner DB zukommen zu lassen? Was für eine DB ist das?<div><br><div id="AppleMailSignature" dir="ltr">Viele Grüße,<div>Andreas</div></div><div dir="ltr"><br>Am 04.07.2019 um 08:25 schrieb Christian S <<a href="mailto:schnellrieder.cs@gmail.com">schnellrieder.cs@gmail.com</a>>:<br><br></div><blockquote type="cite"><div dir="ltr"><div dir="ltr"><br><div>Hallo.</div><div><br></div><div>Seit Tagen bekomme ich beim Ausführen von "aggregate" immer einen Fehler (nur auf dem Level "minute").</div><div>In den Log Files hätte ich jetzt nichts gefunden. Unten der Fehler im Detail aber so richtig schlau werde ich nicht daraus.</div><div><br></div><div>Grüße</div><div><br></div><div>root@service-uplink:/home/nas# php /var/www/<a href="http://volkszaehler.org/bin/aggregate">volkszaehler.org/bin/aggregate</a> run -m delta -l minute<br>Performing 'delta' aggregation on 'minute' level<br><br> [>---------------------------] 0% < 1 sec/< 1 sec 0 channels<br> [===>------------------------] 11% < 1 sec/< 1 sec 1 channels<br> [======>---------------------] 22% < 1 sec/< 1 sec 2 channels<br> [=========>------------------] 33% < 1 sec/< 1 sec 3 channels<br> [============>---------------] 44% < 1 sec/< 1 sec 4 channels<br>In AbstractMySQLDriver.php line 106:<br><br> An exception occurred while executing 'REPLACE INTO aggregate (channel_id, type, timestamp, value, count) SELECT channel_<br> id, ? AS type, MAX(agg.timestamp) AS timestamp, COALESCE( SUM(agg.val_by_time) / (MAX(agg.timestamp) - MIN(agg.prev_times<br> tamp)), AVG(agg.value)) AS value, COUNT(agg.value) AS count FROM ( SELECT channel_id, timestamp, value, value * (timestam<br> p - @prev_timestamp) AS val_by_time, COALESCE(@prev_timestamp, 0) AS prev_timestamp, @prev_timestamp := timestamp FROM da<br> ta CROSS JOIN (SELECT @prev_timestamp := UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(MAX(timestamp) / 1000, "%Y-%m-%d %H:%i:00"<br> ), INTERVAL 1 minute)) * 1000 FROM aggregate WHERE type = ? AND aggregate.channel_id = ?) AS vars WHERE channel_id = ? AN<br> D timestamp >= IFNULL((SELECT UNIX_TIMESTAMP(DATE_ADD(FROM_UNIXTIME(MAX(timestamp) / 1000, "%Y-%m-%d %H:%i:00"), INTERVAL<br> 1 minute)) * 1000 FROM aggregate WHERE type = ? AND aggregate.channel_id = ? ), 0) AND timestamp < UNIX_TIMESTAMP(DATE_F<br> ORMAT(NOW(), "%Y-%m-%d %H:%i:00")) * 1000 ) AS agg GROUP BY channel_id, YEAR(FROM_UNIXTIME(timestamp/1000)), DAYOFYEAR(FR<br> OM_UNIXTIME(timestamp/1000)), HOUR(FROM_UNIXTIME(timestamp/1000)), MINUTE(FROM_UNIXTIME(timestamp/1000))' with params [1,<br> 1, "19", "19", 1, "19"]:<br><br> SQLSTATE[22012]: Division by zero: 1365 Division by 0<br><br><br>In PDOStatement.php line 119:<br><br> SQLSTATE[22012]: Division by zero: 1365 Division by 0<br><br><br>In PDOStatement.php line 117:<br><br> SQLSTATE[22012]: Division by zero: 1365 Division by 0<br><br><br>run [-l|--level LEVEL] [-m|--mode MODE] [-p|--periods PERIODS] [-v|--verbose] [--] [<uuid>...]<br></div><div><br></div></div>
</div></blockquote></div></body></html>