<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
Hi Andi<br>
<blockquote
cite="mid:CAD+a8MinxQj3cn8hNC85DE8n0awo7e8A9sfq2NTv+0QKZviK_Q@mail.gmail.com"
type="cite">
<div dir="ltr">
<div class="gmail_extra"><br>
<div class="gmail_quote"><br>
<div>Ja- Commit 8ac2c5039273b590aec2a9890f87400c08b949a8
liegt dazwischen.<br>
<br>
</div>
<br>
<div>Ich kann's nicht mehr nachvollziehen:<br>
<br>
SELECT e0_.id AS id0, e0_.uuid AS uuid1, e0_.type AS
type2, p1_.id AS id3, p1_.pkey AS pkey4, p1_.value AS
value5, e0_.class AS class6, p1_.entity_id AS entity_id7
FROM entities e0_ LEFT JOIN properties p1_ ON e0_.id =
p1_.entity_id WHERE (e0_.uuid = ?) AND e0_.class IN
('channel', 'aggregator') ORDER BY p1_.pkey ASC<br>
START TRANSACTION<br>
INSERT INTO data (timestamp, value, channel_id) VALUES (?,
?, ?)<br>
COMMIT<br>
<br>
</div>
<div>Bist Du sicher dass der Code den Du siehst auch
wirklich der ist der ausgeführt wird?<br>
</div>
</div>
</div>
</div>
</blockquote>
Ich bin sicher, dass das aktueller Code ist, ja. Zur Sicherheit
habe ich gerade eben nochmal kurz mitgeloggt:<br>
<br>
<br>
/usr/sbin/mysqld, Version: 5.5.33-0+wheezy1 ((Debian)). started
with:<br>
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock<br>
Time Id Command Argument<br>
140113 <b><font color="#ff0000">20:16:29 </font></b>118183
Connect vz@localhost on volkszaehler<br>
118183 Query SELECT e0_.id AS id0, e0_.uuid AS
uuid1, e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4,
p1_.value AS value5, e0_.class AS class6, p1_.entity_id AS
entity_id7 FROM entities e0_ LEFT JOIN properties p1_ ON e0_.id =
p1_.entity_id WHERE (e0_.uuid =
'89277390-f2dc-11e2-94d6-9984a2fec1dc') AND e0_.class IN ('channel',
'aggregator') ORDER BY p1_.pkey ASC<br>
118183 Query START TRANSACTION<br>
118183 Query INSERT INTO data (timestamp, value,
channel_id) VALUES ('1389640589168', '1', 13)<br>
118183 Query UPDATE properties SET value = '1'
WHERE id = 65<br>
118183 Query UPDATE properties SET value = '1'
WHERE id = 63<br>
118183 Query UPDATE properties SET value = '1000'
WHERE id = 61<br>
118183 Query commit<br>
118183 Quit<br>
140113 20:16:43 118184 Connect vz@localhost on volkszaehler<br>
118184 Query SELECT e0_.id AS id0, e0_.uuid AS
uuid1, e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4,
p1_.value AS value5, e0_.class AS class6, p1_.entity_id AS
entity_id7 FROM entities e0_ LEFT JOIN properties p1_ ON e0_.id =
p1_.entity_id WHERE (e0_.uuid =
'267f2810-f2dc-11e2-8d7c-cb14f79472e0') AND e0_.class IN ('channel',
'aggregator') ORDER BY p1_.pkey ASC<br>
118184 Query START TRANSACTION<br>
118184 Query INSERT INTO data (timestamp, value,
channel_id) VALUES ('1389640603905', '3.81', 6)<br>
118184 Query UPDATE properties SET value = '1'
WHERE id = 28<br>
118184 Query UPDATE properties SET value = '1'
WHERE id = 26<br>
118184 Query commit<br>
118184 Quit<br>
140113 20:16:44 118185 Connect vz@localhost on volkszaehler<br>
118185 Query SELECT e0_.id AS id0, e0_.uuid AS
uuid1, e0_.type AS type2, p1_.id AS id3, p1_.pkey AS pkey4,
p1_.value AS value5, e0_.class AS class6, p1_.entity_id AS
entity_id7 FROM entities e0_ LEFT JOIN properties p1_ ON e0_.id =
p1_.entity_id WHERE (e0_.uuid =
'c80251e0-f2db-11e2-8178-ef2453dba49c') AND e0_.class IN ('channel',
'aggregator') ORDER BY p1_.pkey ASC<br>
118185 Query START TRANSACTION<br>
140113 20:16:45 118185 Query INSERT INTO data (timestamp, value,
channel_id) VALUES ('1389640604969', '3.62', 1)<br>
118185 Query UPDATE properties SET value = '1'
WHERE id = 2<br>
118185 Query commit<br>
118185 Quit<br>
140113 <font color="#ff0000"><b>20:16:46 </b></font>118075
Query SET GLOBAL general_log = 'OFF'<br>
<br>
Insofern würde ich schon sagen, dass die updates immer noch heftig
einprasseln...<br>
</body>
</html>