<div dir="ltr"><div><div><div>> string(63) "DELETE command denied to user 'vz'@'localhost' for table 'data'"<br><br></div>Dein vz User hat keine DELETE Rechte -> Installationsskript nochmal laufen lassen und die Option für die Rechte dabei auswählen. Oder von Hand auf der DB vergeben (Windows: z.B. MySQL Workbench).<br><br></div>Viele Grüße,<br></div>Andreas<br><br></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Apr 22, 2015 at 9:27 AM, <a href="mailto:Heine.thomas@online.de">Heine.thomas@online.de</a> <span dir="ltr"><<a href="mailto:Heine.thomas@online.de" target="_blank">Heine.thomas@online.de</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
<div>Hallo,<br>
<br>
Es liegen seit Anfang April etwa 4,3 Mio Datensätze (ca.350MB)
vor. <br>
Ich denkejedoch, dass noch nichts da ist, was älter als 30 Tage
ist. <br>
Aber es gibt genügend,was älter als eine Woche ist (Reduzierung
auf 1 Datensatz/sek.).<br>
<br>
hab jetzt mal folgende Reduzierung eingertagen:<br>
<br>
(7*24*60*60) => 2, //Older than 7 Days Datapoint per 2 sekunde<br>
(30*24*60*60) => 30, //Older than 30 Days Datapoint per 30 sek<span class=""><br>
(6*30*24*60*60) => (1*60), //Older than 6 Month Datapoint per 1
Minutes<br>
(365*24*60*60) => (3*60), //Older than 1 Year Datapoint per 3
Minutes<br>
<br>
<br></span>
Hier das Ergebnis:<br>
<br>
04/22/15 09:23:52 - Processing Sensor ID 1...<br>
04/22/15 09:23:52 - Skipping compression pass for datapoints
between 03/23/15 08:23:52 and 04/15/15 09:23:52 using a 2 second
timeframe: No Datapoints found<br>
04/22/15 09:23:52 - Skipping compression pass for datapoints
between 10/24/14 09:23:52 and 03/23/15 08:23:52 using a 30 second
timeframe: No Datapoints found<br>
04/22/15 09:23:52 - Skipping compression pass for datapoints
between 04/22/14 09:23:52 and 10/24/14 09:23:52 using a 60 second
timeframe: No Datapoints found<br>
04/22/15 09:23:52 - Skipping compression pass for datapoints
between 04/22/15 09:23:52 and 04/22/14 09:23:52 using a 180 second
timeframe: No Datapoints found<br>
04/22/15 09:23:52 - Processing Sensor ID 2...<br>
04/22/15 09:23:52 - Skipping compression pass for datapoints
between 03/23/15 08:23:52 and 04/15/15 09:23:52 using a 2 second
timeframe: No Datapoints found<br>
04/22/15 09:23:52 - Skipping compression pass for datapoints
between 10/24/14 09:23:52 and 03/23/15 08:23:52 using a 30 second
timeframe: No Datapoints found<br>
04/22/15 09:23:52 - Skipping compression pass for datapoints
between 04/22/14 09:23:52 and 10/24/14 09:23:52 using a 60 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/15 09:23:52 and 04/22/14 09:23:52 using a 180 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID 3...<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 03/23/15 08:23:53 and 04/15/15 09:23:53 using a 2 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 10/24/14 09:23:53 and 03/23/15 08:23:53 using a 30 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/14 09:23:53 and 10/24/14 09:23:53 using a 60 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/15 09:23:53 and 04/22/14 09:23:53 using a 180 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID 4...<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 03/23/15 08:23:53 and 04/15/15 09:23:53 using a 2 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 10/24/14 09:23:53 and 03/23/15 08:23:53 using a 30 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/14 09:23:53 and 10/24/14 09:23:53 using a 60 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/15 09:23:53 and 04/22/14 09:23:53 using a 180 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID 5...<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 03/23/15 08:23:53 and 04/15/15 09:23:53 using a 2 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 10/24/14 09:23:53 and 03/23/15 08:23:53 using a 30 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/14 09:23:53 and 10/24/14 09:23:53 using a 60 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/15 09:23:53 and 04/22/14 09:23:53 using a 180 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID 6...<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 03/23/15 08:23:53 and 04/15/15 09:23:53 using a 2 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 10/24/14 09:23:53 and 03/23/15 08:23:53 using a 30 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/14 09:23:53 and 10/24/14 09:23:53 using a 60 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/15 09:23:53 and 04/22/14 09:23:53 using a 180 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID 7...<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 03/23/15 08:23:53 and 04/15/15 09:23:53 using a 2 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 10/24/14 09:23:53 and 03/23/15 08:23:53 using a 30 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/14 09:23:53 and 10/24/14 09:23:53 using a 60 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/15 09:23:53 and 04/22/14 09:23:53 using a 180 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID 8...<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 03/23/15 08:23:53 and 04/15/15 09:23:53 using a 2 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 10/24/14 09:23:53 and 03/23/15 08:23:53 using a 30 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/14 09:23:53 and 10/24/14 09:23:53 using a 60 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/15 09:23:53 and 04/22/14 09:23:53 using a 180 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID 9...<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 03/23/15 08:23:53 and 04/15/15 09:23:53 using a 2 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 10/24/14 09:23:53 and 03/23/15 08:23:53 using a 30 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/14 09:23:53 and 10/24/14 09:23:53 using a 60 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/15 09:23:53 and 04/22/14 09:23:53 using a 180 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID 10...<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 03/23/15 08:23:53 and 04/15/15 09:23:53 using a 2 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 10/24/14 09:23:53 and 03/23/15 08:23:53 using a 30 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/14 09:23:53 and 10/24/14 09:23:53 using a 60 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/15 09:23:53 and 04/22/14 09:23:53 using a 180 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID 11...<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 03/23/15 08:23:53 and 04/15/15 09:23:53 using a 2 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 10/24/14 09:23:53 and 03/23/15 08:23:53 using a 30 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/14 09:23:53 and 10/24/14 09:23:53 using a 60 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Skipping compression pass for datapoints
between 04/22/15 09:23:53 and 04/22/14 09:23:53 using a 180 second
timeframe: No Datapoints found<br>
04/22/15 09:23:53 - Processing Sensor ID 12...<br>
04/22/15 09:23:53 - Compressing datapoints between 04/01/15
18:19:24 and 04/15/15 09:23:51 using a 2 second timeframe<br>
04/22/15 09:23:53 - Processing: 04/01/15 18:19:26 - 04/01/15
18:19:28 (0%)... array(3) {<br>
[0]=><br>
string(5) "42000"<br>
[1]=><br>
int(1142)<br>
[2]=><br>
string(63) "DELETE command denied to user 'vz'@'localhost' for
table 'data'"<br>
}<br>
PHP Fatal error: SQL FAILURE in
/home/pi/<a href="http://volkszaehler.org/misc/tools/vzcompress2.php" target="_blank">volkszaehler.org/misc/tools/vzcompress2.php</a> on line 220<br>
<br>
Was hab ich falsch gemacht????<br>
<br>
Danke Gruß Thomas<div><div class="h5"><br>
<br>
<br>
Am 22.04.2015 um 08:02 schrieb Andreas Götz:<br>
</div></div></div><div><div class="h5">
<blockquote type="cite">
<div>In welcher Auflösung liegen Deine Daten denn vor bzw.
wieviele Einträge pro Kanal hast Du in welchem Zeitraum? Sieht
aus als hätte vzcompress nichts gefunden...</div>
<div><br>
</div>
<div>Viele Grüße, Andreas <br>
<br>
<br>
</div>
<div><br>
Am 22.04.2015 um 06:58 schrieb "<a href="mailto:Heine.thomas@online.de" target="_blank">Heine.thomas@online.de</a>"
<<a href="mailto:Heine.thomas@online.de" target="_blank">Heine.thomas@online.de</a>>:<br>
<br>
</div>
<blockquote type="cite">
<div>
<div>Hallo zusammen,<br>
<br>
hab das VZCompress einmalig durchlaufen lassen (hat etwa 17
Stunden gedauert, wie ihr seht). Mit folgendem Ergebniss:<br>
<br>
...<br>
...<br>
...<br>
04/22/15 06:42:16 - Processing: 04/15/15 02:14:21 -
04/15/15 02:14:22
(100%)...
<br>
04/22/15 06:42:16 - Processing: 04/15/15 02:14:22 -
04/15/15 02:14:23
(100%)...
<br>
04/22/15 06:42:16 - Processing: 04/15/15 02:14:23 -
04/15/15 02:14:24
(100%)...
<br>
04/22/15 06:42:16 - Removed 0 Datapoints in <b>16071</b>
Seconds.
<br>
04/22/15 06:42:16 - Skipping compression pass for
datapoints between 10/24/14 02:14:25 and
<br>
03/23/15 01:14:25 using a 20 second timeframe: No Datapoints
found<br>
04/22/15 06:42:16 - Skipping compression pass for
datapoints between 04/22/14 02:14:25 and <br>
10/24/14 02:14:25 using a 60 second timeframe: No Datapoints
found<br>
04/22/15 06:42:16 - Skipping compression pass for
datapoints between 04/22/15 02:14:25 and <br>
04/22/14 02:14:25 using a 180 second timeframe: No
Datapoints found<br>
04/22/15 06:42:16 - Done. Purged Datapoints from 16
Channels in <b>59200</b> Seconds<br>
<br>
<br>
Irgendwie stimmt das aber nicht mit meiner Configuration
überein, oder?<br>
In meinem Script steht folgendes:<br>
<br>
<div>(7*24*60*60) => (1*1), //Older than 7 Days Datapoint
per 1 sekunde<br>
(30*24*60*60) => (5*6), //Older than 30 Days Datapoint
per 30 sek<br>
(6*30*24*60*60) => (1*60), //Older than 6 Month
Datapoint per 1 Minutes<br>
(365*24*60*60) => (3*60), //Older than 1 Year Datapoint
per 3 Minutes<br>
<br>
wo hab ich den Fehler gemacht?<br>
<br>
Danke Gruß Thomas<br>
</div>
<br>
<br>
<br>
Am 02.04.2015 um 10:35 schrieb Thomas Heine:<br>
</div>
<blockquote type="cite">
<div style="font-family:Verdana;font-size:12.0px">
<div>Hallo,</div>
<div>ich muss die Datenmenge meines Volkszählers
verkleinern.<br>
Würde das gerne mit vzcompress machen.<br>
Ein Messpunkt/minute ist mir aber zu wenig.<br>
Wie soll ich das skript abändern?</div>
<div>Ursprüngliches skript:</div>
<div>(7*24*60*60) => (1*60), //Older than 7 Days
Datapoint per 1 Minute<br>
(30*24*60*60) => (5*60), //Older than 30 Days
Datapoint per 5 Minutes<br>
(6*30*24*60*60) => (15*60), //Older than 6 Month
Datapoint per 15 Minutes<br>
(365*24*60*60) => (30*60), //Older than 1 Year
Datapoint per 30 Minutes</div>
<div><br>
Mein script:</div>
<div>(7*24*60*60) => (1*1), //Older than 7 Days
Datapoint per 1 sekunde<br>
(30*24*60*60) => (5*6), //Older than 30 Days
Datapoint per 30 sek<br>
(6*30*24*60*60) => (1*60), //Older than 6 Month
Datapoint per 1 Minutes<br>
(365*24*60*60) => (3*60), //Older than 1 Year
Datapoint per 3 Minutes</div>
<div> </div>
<div>würde das so klappen?</div>
<div>Kann ich das skript irgendwie einmalig aufrufen? oder
macht es sinn, es<br>
in eine crontab zu schreiben?</div>
<div><br>
Danke für die Hilfe!</div>
<div>Gruß</div>
<div>Thomas</div>
<div> </div>
</div>
</blockquote>
<br>
</div>
</blockquote>
</blockquote>
<br>
</div></div></div>
</blockquote></div><br></div>