Hi Andi
Ja- Commit 8ac2c5039273b590aec2a9890f87400c08b949a8 liegt dazwischen.
Ich kann's nicht mehr nachvollziehen:
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
START TRANSACTION
INSERT INTO data (timestamp, value, channel_id) VALUES (?, ?, ?)
COMMIT
Bist Du sicher dass der Code den Du siehst auch wirklich der ist der
ausgeführt wird?
Ich bin sicher, dass das aktueller Code ist, ja. Zur Sicherheit habe
ich gerade eben nochmal kurz mitgeloggt:
/usr/sbin/mysqld, Version: 5.5.33-0+wheezy1 ((Debian)). started with:
Tcp port: 3306 Unix socket: /var/run/mysqld/mysqld.sock
Time Id Command Argument
140113 *20:16:29 *118183 Connect vz@localhost on volkszaehler
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
118183 Query START TRANSACTION
118183 Query INSERT INTO data (timestamp, value,
channel_id) VALUES ('1389640589168', '1', 13)
118183 Query UPDATE properties SET value = '1' WHERE
id = 65
118183 Query UPDATE properties SET value = '1' WHERE
id = 63
118183 Query UPDATE properties SET value = '1000'
WHERE id = 61
118183 Query commit
118183 Quit
140113 20:16:43 118184 Connect vz@localhost on volkszaehler
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
118184 Query START TRANSACTION
118184 Query INSERT INTO data (timestamp, value,
channel_id) VALUES ('1389640603905', '3.81', 6)
118184 Query UPDATE properties SET value = '1' WHERE
id = 28
118184 Query UPDATE properties SET value = '1' WHERE
id = 26
118184 Query commit
118184 Quit
140113 20:16:44 118185 Connect vz@localhost on volkszaehler
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
118185 Query START TRANSACTION
140113 20:16:45 118185 Query INSERT INTO data (timestamp, value,
channel_id) VALUES ('1389640604969', '3.62', 1)
118185 Query UPDATE properties SET value = '1' WHERE
id = 2
118185 Query commit
118185 Quit
140113 *20:16:46 *118075 Query SET GLOBAL general_log = 'OFF'
Insofern würde ich schon sagen, dass die updates immer noch heftig
einprasseln...
