[gelöst] iobroker bleibt hängen und bringt Fehler im Log…

[etv]

Liebe Leute,

hab seit ein paar Tagen das Phänomen, dass ioBroker einmal pro Tag hängen bleibt (kein Admin Aufruf in Chrome möglich - Fehler "Connection refused"), VIS am Tablett geht nicht und ein stoppen und starten auf der Raspi Console bringt nach dem Start folgende Fehler:

Socket.IO (Log aus dem Web = von unten nach oben lesen…)

host-etv-iob-main 2016-01-06 14:17:12 error instance system.adapter.socketio.0 terminated with code 1 ()

socketio-0 2016-01-06 14:17:12 error port 8084 already in use

socketio-0 2016-01-06 14:17:12 info starting. Version 1.2.3 in /opt/iobroker/node_modules/iobroker.socketio

host-etv-iob-main 2016-01-06 14:17:08 info instance system.adapter.socketio.0 started with pid 15025

sql.0

sql-0 2016-01-06 14:18:00 error Cannot insert INSERT INTO iobroker.ts_number (id, ts, val, ack, _from, q) VALUES(1, 1452086280000, 212, 0, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '1-1452086280000' for key 'PRIMARY'

sql-0 2016-01-06 14:18:00 error Cannot insert INSERT INTO iobroker.ts_number (id, ts, val, ack, _from, q) VALUES(2, 1452086280000, 14.3, 0, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '2-1452086280000' for key 'PRIMARY'

sowie folgende Zeilen

sql.0 2016-01-06 14:30:00 error sql.0 Cannot insert INSERT INTO iobroker.ts_number (id, ts, val, ack, _from, q) VALUES(1, 1452087000000, 214, 0, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '1-1452087000000' for key 'PRIMARY'

sql.0 2016-01-06 14:30:00 error sql.0 Cannot insert INSERT INTO iobroker.ts_number (id, ts, val, ack, _from, q) VALUES(2, 1452087000000, 13.1, 0, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '2-1452087000000' for key 'PRIMARY'

sql.0 2016-01-06 14:29:00 error sql.0 Cannot insert INSERT INTO iobroker.ts_number (id, ts, val, ack, _from, q) VALUES(1, 1452086940000, 214, 0, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '1-1452086940000' for key 'PRIMARY'

sql.0 2016-01-06 14:29:00 error sql.0 Cannot insert INSERT INTO iobroker.ts_number (id, ts, val, ack, _from, q) VALUES(2, 1452086940000, 13.2, 0, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '2-1452086940000' for key 'PRIMARY'

sql.0 2016-01-06 14:28:00 error sql.0 Cannot insert INSERT INTO iobroker.ts_number (id, ts, val, ack, _from, q) VALUES(1, 1452086880000, 214, 0, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '1-1452086880000' for key 'PRIMARY'

sql.0 2016-01-06 14:28:00 error sql.0 Cannot insert INSERT INTO iobroker.ts_number (id, ts, val, ack, _from, q) VALUES(2, 1452086880000, 13.3, 0, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '2-1452086880000' for key 'PRIMARY'

sql.0 2016-01-06 14:27:00 error sql.0 Cannot insert INSERT INTO iobroker.ts_number (id, ts, val, ack, _from, q) VALUES(1, 1452086820000, 213, 0, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '1-1452086820000' for key 'PRIMARY'

sql.0 2016-01-06 14:27:00 error sql.0 Cannot insert INSERT INTO iobroker.ts_number (id, ts, val, ack, _from, q) VALUES(2, 1452086820000, 13.4, 0, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '2-1452086820000' for key 'PRIMARY'

etv-iob-main 2016-01-06 14:26:28 error WARNING: cannot find message with id = 538

etv-iob-main 2016-01-06 14:26:28 error WARNING: cannot find message with id = 535

Wenn ich zwischen iobroker stop und iobroker start ein paar Minuten vergehen lasse, dann funktioniert der restart….

Anbei noch der Log der letzten Minuten vor dem händischen Restart - vielleicht finden unsere Spezialisten da was drinnen

! 2016-01-06 13:05:59.258 - info: web.0 sendTo "getHistory" to system.adapter.sql.0 from system.adapter.web.0: {"id":"hm
! 2016-01-06 13:05:59.522 - info: sql.0 Send: 600 of: 1689 in: 245ms
! 2016-01-06 13:05:59.530 - info: sql.0 sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0: {"result"
! 2016-01-06 13:09:13.704 - info: admin.0 Request actual repository…
! 2016-01-06 13:09:13.902 - info: host.etv-iob-main Update repository "default" under "conf/sources-dist.json"
! 2016-01-06 13:09:25.629 - info: admin.0 Repository received successfully.
! 2016-01-06 13:09:25.841 - info: web.0 sendTo "getHistory" to system.adapter.sql.0 from system.adapter.web.0: {"id":"hm
! 2016-01-06 13:09:25.883 - info: sql.0 Send: 72 of: 142 in: 25ms
! 2016-01-06 13:09:25.885 - info: sql.0 sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0: {"result"
! 2016-01-06 13:12:02.776 - info: javascript.0 script.js.Spritpreise: -------------------- Spritpreise eingelesen - �AMT
! 2016-01-06 13:12:32.296 - info: web.0 sendTo "getHistory" to system.adapter.sql.0 from system.adapter.web.0: {"id":"hm
! 2016-01-06 13:12:32.471 - info: sql.0 Send: 600 of: 1688 in: 160ms
! 2016-01-06 13:12:32.480 - info: sql.0 sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0: {"result"
! 2016-01-06 13:22:01.526 - info: javascript.0 script.js.Spritpreise: -------------------- Spritpreise eingelesen - �AMT
! 2016-01-06 13:27:46.760 - info: web.0 sendTo "getHistory" to system.adapter.sql.0 from system.adapter.web.0: {"id":"hm
! 2016-01-06 13:27:46.805 - info: sql.0 Send: 72 of: 142 in: 25ms
! 2016-01-06 13:27:46.809 - info: sql.0 sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0: {"result"
! 2016-01-06 13:30:00.936 - info: socketio.0 terminating http server on port 8084
! 2016-01-06 13:30:01.088 - info: web.0 terminating http server on port 8082
! 2016-01-06 13:30:01.123 - info: web.0 terminated http server on port 8082
! 2016-01-06 13:30:01.086 - info: admin.0 terminating http server on port 8081
! 2016-01-06 12:13:03.327 - info: pushbullet.0 Nachricht erhalten.
! 2016-01-06 12:13:03.328 - info: pushbullet.0 Pushe Nachricht
! 2016-01-06 12:13:03.329 - info: pushbullet.0 note
! 2016-01-06 13:30:01.223 - info: pushbullet.0 cleaned everything up...
! 2016-01-06 13:30:01.226 - info: hm-rpc.0 binrpc -> 192.168.68.222:2001 init ["xmlrpc_bin://192.168.68.223:2001",""]
! 2016-01-06 13:30:02.676 - info: admin.0 terminating with timeout
! 2016-01-06 13:30:02.733 - info: pushbullet.0 terminating with timeout
! 2016-01-06 13:32:01.430 - info: javascript.0 script.js.Spritpreise: –------------------ Spritpreise eingelesen - �AMT
! 2016-01-06 13:34:31.337 - info: hm-rpc.0 binrpc <- system.listMethods ["hm-rpc.0"]
! 2016-01-06 13:38:05.923 - warn: hm-rega.0 Reconnection to DB.
! 2016-01-06 13:38:06.113 - warn: hm-rega.0 Reconnection to DB.
! 2016-01-06 13:38:06.040 - warn: web.0 Reconnection to DB.
! 2016-01-06 13:38:06.192 - warn: web.0 Reconnection to DB.
! 2016-01-06 13:38:06.213 - warn: javascript.0 Reconnection to DB.
! 2016-01-06 13:38:06.499 - warn: javascript.0 Reconnection to DB.
! 2016-01-06 13:40:28.386 - info: host.etv-iob-main iobroker.js-controller version 0.8.2 js-controller starting
! 2016-01-06 13:40:28.410 - info: host.etv-iob-main Copyright 2014-2015 bluefox, hobbyquaker
! 2016-01-06 13:40:28.414 - info: host.etv-iob-main hostname: etv-iob-main

vor dem restart hab ich versucht folgende adapter per iobroker retstart "adapter" neu zu starten - ohne erfolg

• web

• vis

• admin

Grüße

etv

[etv]

Liebe Leute,

wie hier im Forum an anderer Stelle diskutiert http://forum.iobroker.net/viewtopic.php?f=20&t=2007, liegt es mit hoher Sicherheit am massiven Editieren in VIS, denn seit ich mit den aktuellen Views fertig bin, ist dieser Fehler wieder weg!

Grüße

etv