<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Hallo Andreas,<br>
<br>
ich habe das Image für den Raspberry von der Volkszähler Homepage
auf meinem Pi installiert, dann habe ich die Datenbank und Anzeige
auf meinem Webspace nach einer Anleitung auf der Volkszähler
Homepage angelegt.<br>
<br>
Die composer.log habe ich angehängt.<br>
<br>
Gruß Andre<br>
<br>
<br>
<div class="moz-cite-prefix">Am 02.05.2015 um 22:05 schrieb Andreas
Götz:<br>
</div>
<blockquote
cite="mid:84D69180-07EB-4649-99D9-08DDF7E4E89A@gmail.com"
type="cite">
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<div>Verstehe. Dumme Frage: ist die Middleware neu installiert?
Könntest Du mal die composer.lock posten?<br>
<br>
Viele Grüße,
<div>Andreas</div>
</div>
<div><br>
Am 02.05.2015 um 21:51 schrieb Viper <<a
moz-do-not-send="true" href="mailto:viper@viper1.de">viper@viper1.de</a>>:<br>
<br>
</div>
<blockquote type="cite">
<div>Hallo Andreas, <br>
<br>
das stimmt, hat nichts mit dem vermuteten Fehler zu tun aber
Matthias war so nett sich mal meinen Error Log anzuschauen und
da war der Timestand Fehler sehr oft drin. Da ich an den
Datenbank-Einstellungen nichts geändert habe ist dies
zumindest in dem Raspberry-Immage so drin. <br>
Hier der Teil des Fehlerlogs:<br>
[Apr 24 01:19:01][d0] Failed to parse obis code
(1-0:1.8.1*25/ISk)<br>
[Apr 24 01:31:01][d0] Too much data for value (byte=0x2E)<br>
[Apr 24 01:31:01][d0] Too much data for value (byte=0x30)<br>
[Apr 24 01:31:01][d0] Too much data for unit (byte=0x32)<br>
[Apr 24 01:31:01][d0] Too much data for unit (byte=0x34)<br>
[Apr 24 01:31:01][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?)' with params [1429831861547.5, 30653,
1429831861547.7, 30653.6229]:<br>
<br>
SQLSTATE[23000]: Integrity constraint violation: 1062 <br>
[Apr 24 01:31:31][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?)' with params [1429831861547.5,
30653, 1429831861547.7, 30653.6229, 1429831891549.4,
30653.6232]:<br>
<br>
SQLSTATE[23000]<br>
[Apr 24 01:32:01][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?)' with params
[1429831861547.5, 30653, 1429831861547.7, 30653.6229,
1429831891549.4, 30653.6232, 1429831<br>
[Apr 24 01:32:32][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?)' with params
[1429831861547.5, 30653, 1429831861547.7, 30653.6229,
1429831891549.4, 30653.623<br>
[Apr 24 01:33:02][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?)'
with params [1429831861547.5, 30653, 1429831861547.7,
30653.6229, 1429831891549.4,<br>
[Apr 24 01:33:32][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?)' with params [1429831861547.5, 30653,
1429831861547.7, 30653.6229, 142983<br>
[Apr 24 01:34:02][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?)' with params [1429831861547.5, 30653,
1429831861547.7, 30653.6229, 142983<br>
[Apr 24 01:34:33][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?)' with params [1429831861547.5, 30653,
1429831861547.7, 30653.62<br>
[Apr 24 01:35:01][d0] Too much data for value (byte=0x30)<br>
[Apr 24 01:35:01][d0] Too much data for unit (byte=0x32)<br>
[Apr 24 01:35:01][d0] Too much data for unit (byte=0x34)<br>
[Apr 24 01:35:03][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?)' with params [1429831861547.5,
30653, 1429831861547.7<br>
[Apr 24 01:35:33][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?)' with params
[1429831861547.5, 30653, 14298<br>
[Apr 24 01:36:03][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?)' with params
[1429831861547.5, 30<br>
[Apr 24 01:36:33][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?)'
with params [142983186<br>
[Apr 24 01:37:03][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?)' with params <br>
[Apr 24 01:37:33][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?)' wi<br>
[Apr 24 01:38:04][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:38:34][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:39:04][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:39:34][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:40:04][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:40:35][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:41:05][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:41:35][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:42:05][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:42:35][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:43:05][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:43:36][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:44:06][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:44:36][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:45:06][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:45:36][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:46:07][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:46:37][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:47:07][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:47:37][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:48:07][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:48:38][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:49:08][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:49:38][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:50:08][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:50:38][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:51:01][d0] Too much data for unit (byte=0x32)<br>
[Apr 24 01:51:01][d0] Too much data for unit (byte=0x34)<br>
[Apr 24 01:51:09][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:51:39][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:52:09][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:52:39][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:53:09][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:53:40][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:54:10][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:54:40][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:55:10][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
[Apr 24 01:55:41][chn4] CURL Error from middleware:
'DBALException': 'An exception occurred while executing
'INSERT INTO data (channel_id, timestamp, value) VALUES
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?), (10,?,?),
(10,?,?), (10,?,?), (1<br>
<br>
<br>
<br>
<div class="gmail_quote">Am 2. Mai 2015 08:08:26 MESZ, schrieb
"Andreas Götz" <<a moz-do-not-send="true"
href="mailto:cpuidle@gmail.com">cpuidle@gmail.com</a>>:
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt
0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left: 1ex;">
<pre class="k9mail">Moin,
<blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;"> Am 01.05.2015 um 23:14 schrieb Matthias Behr <<a moz-do-not-send="true" href="mailto:mbehr@mcbehr.de">mbehr@mcbehr.de</a>>:
Der Code ist aus dem Logger.
Aus meiner Sicht darf timestamp nicht als unique-key in der Datenbank definiert sein.
</blockquote>
Ist es doch auch nicht. Aber timestamp/channel_id ist sehr wohl unique und das wird vom Logger auch abgefangen. Hat doch aber alles nix mit dem Ursprungsproblem von Viper zu tun?
Viele Grüße, Andreas
<blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #729fcf; padding-left: 1ex;">
<blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ad7fa8; padding-left: 1ex;"> Am 01.05.2015 um 23:11 schrieb Andreas Götz <<a moz-do-not-send="true" href="mailto:cpuidle@gmail.com">cpuidle@gmail.com</a>>:
Hi Matthias,
<blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #8ae234; padding-left: 1ex;"> Am 01.05.2015 um 21:58 schrieb Matthias Behr <<a moz-do-not-send="true" href="mailto:mbehr@mcbehr.de">mbehr@mcbehr.de</a>>:
Hier das ursprüngliche Problem. Es gibt Curl Fehler, weil offensichtlich ein timestamp bereits in der DB vorliegt. Der akt. Code versucht das dann immer wieder -> hat nie wieder Erfolg.
timestamp (da ja in ms Auflösung) darf nicht als unique-key definiert sein. Frage ist, ob das Install-Skript das so anlegt.
<blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #fcaf3e; padding-left: 1ex;"><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #e9b96e; padding-left: 1ex;"><blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ccc; padding-left: 1ex;"> (Auszug)
</blockquote></blockquote></blockquote> Wenn es aus irgendeinem Grund (Integrity constraint
violation: 1062???) zu einem Fehler kommt, dann wird versucht, diese Werte erneut an die Middleware zu schicken. Wenn es aber ein Werte Paar gibt, welches immer einen Fehler erzeugt, dann werden diese immer werden versucht und es wird nie mehr klappen.
</blockquote>
Ich bin total lost. Irgendwo gibt es Code der eine UniqueConstraintViolation abfängt- der fehlt unten.
Und was ist jetzt das Problem- Fehler in den Indizes bei der MW oder beim Handling im Logger?
Viele Grüße, Andreas
<blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #8ae234; padding-left: 1ex;">
D.h. das Fehlermanagement in Volkszaehler.cpp sollte überdacht werden.
akt. Code (_values.clear() nur im Ok Fall):
// check response
if (curl_code == CURLE_OK && http_code == 200) { // everything is ok
print(log_debug, "CURL Request succeeded with code: %i",
channel()->name(), http_code);
_values.clear();
// clear buffer-readings
//channel()->buffer.sent = last->next;
}
else { // error
if (curl_code != CURLE_OK) {
print(log_error, "CURL: %s", channel()->name(), curl_easy_strerror(curl_code));
}
else if (http_code != 200) {
char err[255];
api_parse_exception(response, err, 255);
print(log_error, "CURL Error from middleware: %s", channel()->name(), err);
}
}
<blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #fcaf3e; padding-left: 1ex;"> Am 01.05.2015 um 21:50 schrieb Andreas Götz <<a moz-do-not-send="true" href="mailto:cpuidle@gmail.com">cpuidle@gmail.com</a>>:
Mir fehlt der Mittelteil- was ist los?
Viele Grüße, Andreas
<blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px
solid #e9b96e; padding-left: 1ex;"> Am 01.05.2015 um 20:11 schrieb Viper <<a moz-do-not-send="true" href="mailto:viper@viper1.de">viper@viper1.de</a>>:
Kann ich das irgendwie ändern?
Am 1. Mai 2015 19:53:50 MESZ, schrieb Matthias Behr <<a moz-do-not-send="true" href="mailto:mbehr@mcbehr.de">mbehr@mcbehr.de</a>>:
<blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ccc; padding-left: 1ex;"> Da ist auch schon der Fehler:
timestamp darf nicht data_unique sein.
@Andig: ist das so gewollt? Macht das Install-Skript das so?
<blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ccc; padding-left: 1ex;"> Am 01.05.2015 um 18:32 schrieb Viper <<a moz-do-not-send="true" href="mailto:viper@viper1.de">viper@viper1.de</a>>:
Glaube ich habe es geschafft:
Tabelle
Datensätze 1 - 4 von insgesamt 4 << < > >>
Ansicht: kompakt
</blockquote>
Die Abfrage enthält 13 Spalten
<blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex
0.8ex; border-left: 1px solid #ccc; padding-left: 1ex;"> # <blank.gif> Table <blank.gif> Non_unique <blank.gif>
</blockquote> Key_name <blank.gif> Seq_in_index <blank.gif> Column_name <blank.gif>
Collation <blank.gif> Cardinality <blank.gif> Sub_part <blank.gif>
Packed <blank.gif> Null <blank.gif> Index_type <blank.gif>
Comment <blank.gif> Index_comment
<blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ccc; padding-left: 1ex;"> 1.
data
0
PRIMARY
1
id
A
13651
NULL
NULL
BTREE
2.
data
0
data_unique
1
channel_id
A
2
NULL
NULL
YES
BTREE
3.
data
0
data_unique
2
timestamp
A
13651
NULL
NULL
BTREE
4.
data
1
IDX_ADF3F36372F5A1AA
1
channel_id
A
2
NULL
NULL
YES
BTREE
Datensätze 1 - 4 von insgesamt 4 << < > >>
Habe auch das Dump File angehängt.
<blockquote class="gmail_quote" style="margin: 0pt 0pt 1ex 0.8ex; border-left: 1px solid #ccc; padding-left: 1ex;"> Am 30.04.2015 um 22:43 schrieb Matthias Behr:
show index from
</blockquote>
<dumpD0.txt>
</blockquote>
Gruß
Matthias
</blockquote>
--
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.
</blockquote></blockquote>
Gruß
Matthias
</blockquote></blockquote>
Gruß
Matthias
</blockquote></pre>
</blockquote>
</div>
<br>
-- <br>
Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9
Mail gesendet.</div>
</blockquote>
</blockquote>
<br>
</body>
</html>