- ioBroker Community Home
- Deutsch
- ioBroker Allgemein
- SQL Probleme - Cannot insert INSERT INTO `ioBroker` ....
SQL Probleme - Cannot insert INSERT INTO `ioBroker` ....
-
Liebes Forum,
ich habe keine Ahnung wo ich noch drehen soll. Der SQL Adapter lief 2 Jahre völlig unauffällig, vor ca. 1. Woche hatte ich das erste Mal das Log voll mit solchen Einträgen:
sql.0 2020-12-13 16:26:22.066 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873181923, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873181923' for sql.0 2020-12-13 16:26:05.459 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873165315, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873165315' for sql.0 2020-12-13 16:25:48.525 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873148424, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873148424' for key ' sql.0 2020-12-13 16:25:48.501 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873148423, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873148423' for sql.0 2020-12-13 16:25:21.483 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873121289, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873121289' for sql.0 2020-12-13 16:25:21.322 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873121288, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873121288' for key ' sql.0 2020-12-13 16:25:05.875 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873105603, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873105603' for sql.0 2020-12-13 16:24:50.916 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873090756, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873090756' for sql.0 2020-12-13 16:24:50.880 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873090755, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873090755' for key ' sql.0 2020-12-13 16:23:55.379 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873035017, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873035017' for sql.0 2020-12-13 16:23:55.371 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873035016, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873035016' for key ' sql.0 2020-12-13 16:21:40.223 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607872899796, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607872899796' for sql.0 2020-12-13 16:21:39.918 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607872899795, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607872899795' for key ' sql.0 2020-12-13 16:21:26.933 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607872886503, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607872886503' for sql.0 2020-12-13 16:20:32.952 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607872832832, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607872832832' for sql.0 2020-12-13 16:20:17.740 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607872817649, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607872817649' for key ' sql.0 2020-12-13 16:20:02.931 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607872802761, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607872802761' for key ' sql.0 2020-12-13 16:19:25.271 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607872764923, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607872764923' for sql.0 2020-12-13 16:19:11.504 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607872751118, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607872751118' forDann hatte ich ein Backup eingespielt, mußte Float neu installieren, dann lief wieder alles ruhig. Seit 2 Stunden habe ich genau das gleiche Spiel wieder. Die Syno (da läuft mariaDB 5) habe ich neu gestartet, die VM auf einem NUC mit Proxmox ebenso.
Hier das Log, kurz vor dem Zeitpunkt der Fehlerorgie:
2020-12-13 13:36:03.275 - warn: fullybrowser.0 (4381) Generate State problem 192_168_0_121 {"message":"connect EHOSTUNREACH 192.168.0.121:2323","name":"Error","stack":"Error: connect EHOSTUNREACH 192.168.0.121:2323\n at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1145:16)","config":{"url":"http://192.168.0.121:2323/?cmd=deviceInfo&type=json&password=kalksburG","method":"get","headers":{"Accept":"application/json, text/plain, */*","User-Agent":"axios/0.20.0"},"transformRequest":[null],"transformResponse":[null],"timeout":0,"xsrfCookieName":"XSRF-TOKEN","xsrfHeaderName":"X-XSRF-TOKEN","maxContentLength":-1,"maxBodyLength":-1},"code":"EHOSTUNREACH"} 2020-12-13 13:36:03.929 - info: fullybrowser.0 (4381) Start with IP : 192.168.0.123 2020-12-13 13:36:17.581 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 13:39:54.255 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.BAD_Radar_BWM_schaltet_var: + + + var einschalten und in 9 Min ausschalten + + + 2020-12-13 13:39:54.264 - info: javascript.0 (20648) script.js.common.350-379_Heizung-WW.350_WW_Zirkulationspumpe: Zirkop Keller ein 2020-12-13 13:39:54.265 - info: javascript.0 (20648) script.js.common.600-699_Licht.620_Bad_Licht_Spiegelschrank: * * * Spiegel KALT ein * * * 2020-12-13 13:39:54.266 - info: javascript.0 (20648) script.js.common.200-299_Audio-Video.240_neu_BAD_Radio_ein_aus: * * * Radio BAD ein * * * 2020-12-13 13:39:58.599 - info: nut.0 (21333) Start NUT update 2020-12-13 13:39:58.623 - info: nut.0 (21333) All Nut values set 2020-12-13 13:40:14.386 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.BAD_Radar_BWM_schaltet_var: + + + ausschaltdauer in 9 Minuten erneut gesetzt + + + 2020-12-13 13:40:17.407 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 13:40:57.801 - info: unifi.0 (22696) Update done 2020-12-13 13:41:04.082 - info: web.0 (23327) ==>Connected system.user.admin from ::ffff:192.168.0.121 2020-12-13 13:43:00.044 - info: host.ioBroker-Prod instance system.adapter.daswetter.0 started with pid 19041 2020-12-13 13:43:03.287 - info: daswetter.0 (19041) starting. Version 3.0.4 in /opt/iobroker/node_modules/iobroker.daswetter, node: v12.19.0, js-controller: 3.1.6 2020-12-13 13:43:12.656 - info: daswetter.0 (19041) Terminated (NO_ERROR): Without reason 2020-12-13 13:43:13.181 - info: host.ioBroker-Prod instance system.adapter.daswetter.0 terminated with code 0 (NO_ERROR) 2020-12-13 13:43:40.719 - error: sql.0 (22409) No type undefined found for g-homa.0.1E493A.state. Retention is not possible. 2020-12-13 13:44:40.699 - error: sql.0 (22409) No type undefined found for g-homa.0.1E493A.state. Retention is not possible. 2020-12-13 13:44:58.601 - info: nut.0 (21333) Start NUT update 2020-12-13 13:44:58.637 - info: nut.0 (21333) All Nut values set 2020-12-13 13:45:00.055 - info: host.ioBroker-Prod instance system.adapter.ical.0 started with pid 23215 2020-12-13 13:45:05.502 - info: ical.0 (23215) starting. Version 1.7.4 in /opt/iobroker/node_modules/iobroker.ical, node: v12.19.0, js-controller: 3.1.6 2020-12-13 13:45:06.016 - info: ical.0 (23215) processing URL: Feiertage https://calendar.google.com/calendar/ical/de.austrian%23holiday%40group.v.calendar.google.com/public/basic.ics 2020-12-13 13:45:06.152 - info: ical.0 (23215) processing URL: Geburtstage Cech https://calendar.google.com/calendar/ical/hd4b3rtin1f1qsvjbg64eg1jhc%40group.calendar.google.com/private-712abecefef0c24fe5521b59d2aade04/basic.ics 2020-12-13 13:45:06.844 - info: ical.0 (23215) processing URL: Muell https://calendar.google.com/calendar/ical/tqloimait9lkmlutadl0t27a9s%40group.calendar.google.com/private-289a3b0f58d98779693d103d163962a1/basic.ics 2020-12-13 13:45:07.087 - info: ical.0 (23215) processing URL: SonneMitHaus https://calendar.google.com/calendar/ical/sonnemithaus%40gmail.com/private-2575f3ee698831cfae2a0b7b1c348855/basic.ics 2020-12-13 13:45:12.249 - info: ical.0 (23215) Terminated (NO_ERROR): Without reason 2020-12-13 13:45:12.777 - info: host.ioBroker-Prod instance system.adapter.ical.0 terminated with code 0 (NO_ERROR) 2020-12-13 13:45:13.644 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 13:45:51.825 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 13:46:08.538 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 13:46:45.318 - info: javascript.0 (20648) Stop script script.js.common.200-299_Audio-Video.276_Tablet_BAD_Akku_laden 2020-12-13 13:46:45.419 - info: javascript.0 (20648) Start javascript script.js.common.200-299_Audio-Video.276_Tablet_BAD_Akku_laden 2020-12-13 13:46:45.449 - info: javascript.0 (20648) script.js.common.200-299_Audio-Video.276_Tablet_BAD_Akku_laden: registered 1 subscription and 0 schedules 2020-12-13 13:47:48.803 - info: web.0 (23327) <==Disconnect system.user.admin from ::ffff:192.168.0.123 vis.0 2020-12-13 13:49:14.394 - info: javascript.0 (20648) script.js.common.350-379_Heizung-WW.350_WW_Zirkulationspumpe: Zirkop Keller aus 2020-12-13 13:49:14.395 - info: javascript.0 (20648) script.js.common.600-699_Licht.620_Bad_Licht_Spiegelschrank: * * * Spiegel alles AUS * * * 2020-12-13 13:49:14.396 - info: javascript.0 (20648) script.js.common.200-299_Audio-Video.240_neu_BAD_Radio_ein_aus: * * * Radio BAD aus * * * 2020-12-13 13:49:34.496 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863774190, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863774190' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:49:34.712 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863774191, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863774191' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:49:51.230 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863790938, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863790938' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:49:58.604 - info: nut.0 (21333) Start NUT update 2020-12-13 13:49:58.660 - info: nut.0 (21333) All Nut values set 2020-12-13 13:50:06.662 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863806565, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863806565' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:50:06.673 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863806566, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863806566' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:50:06.684 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863806565, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863806565' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:50:21.276 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863821123, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863821123' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:50:21.347 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863821124, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863821124' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:50:56.306 - info: unifi.0 (22696) Update done 2020-12-13 13:51:00.193 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863859998, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863859998' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:51:28.277 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863888029, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863888029' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:51:32.640 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863892390, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863892390' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:51:50.779 - info: host.ioBroker-Prod stopInstance system.adapter.fullybrowser.0 (force=false, process=true) 2020-12-13 13:51:50.787 - info: host.ioBroker-Prod stopInstance system.adapter.fullybrowser.0 send kill signal 2020-12-13 13:51:50.794 - info: fullybrowser.0 (4381) Got terminate signal TERMINATE_YOURSELF 2020-12-13 13:51:50.795 - info: fullybrowser.0 (4381) cleaned everything up... 2020-12-13 13:51:50.797 - info: fullybrowser.0 (4381) terminating 2020-12-13 13:51:50.799 - info: fullybrowser.0 (4381) Terminated (ADAPTER_REQUESTED_TERMINATION): Without reason 2020-12-13 13:51:51.371 - info: host.ioBroker-Prod instance system.adapter.fullybrowser.0 terminated with code 11 (ADAPTER_REQUESTED_TERMINATION) 2020-12-13 13:51:53.334 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863913229, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863913229' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:51:53.844 - info: host.ioBroker-Prod instance system.adapter.fullybrowser.0 started with pid 4005 2020-12-13 13:51:57.120 - info: fullybrowser.0 (4005) starting. Version 2.0.1 in /opt/iobroker/node_modules/iobroker.fullybrowser, node: v12.19.0, js-controller: 3.1.6 2020-12-13 13:51:57.160 - info: fullybrowser.0 (4005) Start with IP : 192.168.0.121 2020-12-13 13:51:59.412 - info: fullybrowser.0 (4005) Start with IP : 192.168.0.123 2020-12-13 13:52:08.212 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863927883, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863927883' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:52:20.912 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863940839, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863940839' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:52:33.317 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863953057, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863953057' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:53:28.884 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864008723, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864008723' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:53:29.018 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864008724, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864008724' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:53:45.038 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864024880, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864024880' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:53:45.041 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864024880, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864024880' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:53:45.046 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864024881, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864024881' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:54:10.855 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864050383, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864050383' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:54:10.886 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864050384, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864050384' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:54:14.625 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.BAD_Radar_BWM_schaltet_var: + + + var einschalten und in 9 Min ausschalten + + + 2020-12-13 13:54:14.629 - info: javascript.0 (20648) script.js.common.350-379_Heizung-WW.350_WW_Zirkulationspumpe: Zirkop Keller ein 2020-12-13 13:54:14.632 - info: javascript.0 (20648) script.js.common.600-699_Licht.620_Bad_Licht_Spiegelschrank: * * * Spiegel KALT ein * * * 2020-12-13 13:54:14.633 - info: javascript.0 (20648) script.js.common.200-299_Audio-Video.240_neu_BAD_Radio_ein_aus: * * * Radio BAD ein * * * 2020-12-13 13:54:14.680 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 13:54:22.402 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864062228, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864062228' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:54:39.658 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864079457, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864079457' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:54:44.014 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 13:54:58.606 - info: nut.0 (21333) Start NUT update 2020-12-13 13:54:58.631 - info: nut.0 (21333) All Nut values set 2020-12-13 13:55:00.060 - info: host.ioBroker-Prod instance system.adapter.ical.0 started with pid 10585 2020-12-13 13:55:03.926 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864103643, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864103643' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:55:04.626 - info: ical.0 (10585) starting. Version 1.7.4 in /opt/iobroker/node_modules/iobroker.ical, node: v12.19.0, js-controller: 3.1.6 2020-12-13 13:55:05.291 - info: ical.0 (10585) processing URL: Feiertage https://calendar.google.com/calendar/ical/de.austrian%23holiday%40group.v.calendar.google.com/public/basic.ics 2020-12-13 13:55:05.435 - info: ical.0 (10585) processing URL: Geburtstage Cech https://calendar.google.com/calendar/ical/hd4b3rtin1f1qsvjbg64eg1jhc%40group.calendar.google.com/private-712abecefef0c24fe5521b59d2aade04/basic.ics 2020-12-13 13:55:06.179 - info: ical.0 (10585) processing URL: Muell https://calendar.google.com/calendar/ical/tqloimait9lkmlutadl0t27a9s%40group.calendar.google.com/private-289a3b0f58d98779693d103d163962a1/basic.ics 2020-12-13 13:55:06.303 - info: ical.0 (10585) processing URL: SonneMitHaus https://calendar.google.com/calendar/ical/sonnemithaus%40gmail.com/private-2575f3ee698831cfae2a0b7b1c348855/basic.ics 2020-12-13 13:55:11.478 - info: ical.0 (10585) Terminated (NO_ERROR): Without reason 2020-12-13 13:55:11.997 - info: host.ioBroker-Prod instance system.adapter.ical.0 terminated with code 0 (NO_ERROR) 2020-12-13 13:55:20.065 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864119798, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864119798' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:55:21.056 - info: web.0 (23327) ==>Connected system.user.admin from ::ffff:192.168.0.202 2020-12-13 13:55:34.613 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864134493, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864134493' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:55:48.964 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864148867, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864148867' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:55:49.103 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864148868, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864148868' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:55:57.312 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 13:56:00.760 - info: web.0 (23327) <==Disconnect system.user.admin from ::ffff:192.168.0.202 flot 2020-12-13 13:56:24.579 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 13:56:41.335 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864200973, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864200973' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:56:41.355 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864200974, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864200974' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:56:41.841 - error: sourceanalytix.0 (22358) Cannot execute calculations for sonoff.0.SONOFF_32_POW.ENERGY_Total adjust settings ! 2020-12-13 13:56:41.848 - error: sourceanalytix.0 (22358) Selected Type Wählen does not exist in Price Definitions 2020-12-13 13:56:41.848 - error: sourceanalytix.0 (22358) Please choose proper type for state sonoff.0.SONOFF_32_POW.ENERGY_Total 2020-12-13 13:56:41.848 - error: sourceanalytix.0 (22358) Or add price definition Wählen in adapter settings 2020-12-13 13:56:41.850 - error: sourceanalytix.0 (22358) Cannot handle initialisation for sonoff.0.SONOFF_32_POW.ENERGY_Total 2020-12-13 13:56:47.686 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864207570, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864207570' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:56:47.721 - error: sourceanalytix.0 (22358) Cannot execute calculations for sonoff.0.SONOFF_32_POW.ENERGY_Total adjust settings ! 2020-12-13 13:56:47.722 - error: sourceanalytix.0 (22358) Selected Type Wählen does not exist in Price Definitions 2020-12-13 13:56:47.723 - error: sourceanalytix.0 (22358) Please choose proper type for state sonoff.0.SONOFF_32_POW.ENERGY_Total 2020-12-13 13:56:47.723 - error: sourceanalytix.0 (22358) Or add price definition Wählen in adapter settings 2020-12-13 13:56:47.724 - error: sourceanalytix.0 (22358) Cannot handle initialisation for sonoff.0.SONOFF_32_POW.ENERGY_Total 2020-12-13 13:56:47.760 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864207571, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864207571' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:57:48.678 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864268575, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864268575' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:57:48.818 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864268576, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864268576' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:57:48.945 - info: web.0 (23327) ==>Connected system.user.admin from ::ffff:192.168.0.202 2020-12-13 13:58:00.895 - info: web.0 (23327) <==Disconnect system.user.admin from ::ffff:192.168.0.202 flot 2020-12-13 13:58:02.854 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864282715, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864282715' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:58:02.908 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864282716, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864282716' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:58:16.609 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864296510, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864296510' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:58:16.708 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864296511, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864296511' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:58:54.497 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864334461, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864334461' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:59:22.325 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864362286, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864362286' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:59:58.607 - info: nut.0 (21333) Start NUT update 2020-12-13 13:59:58.639 - info: nut.0 (21333) All Nut values set 2020-12-13 13:59:59.827 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864399431, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864399431' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:00:00.013 - info: javascript.0 (20648) script.js.common.900-919_Information.900_eMail_grosser_Bericht: Mail wurde versandt 2020-12-13 14:00:00.066 - info: email.0 (19555) Send email: {"html":"Servicemeldungen: 1 EG Tuere Terrasse (KEQ0858830) - Spannung Batterien/Akkus gering. 3x LR6/AA Sicherheit: Verschluss gesamt: offen Temperaturen aussen: Nord: 5.7°C - Luftfeuchte: 86% Poolwasser: 4.4°C Poolsolar: 10.8°C Temperaturen innen: Bad & WC: 21.7 (21)°C - Luftfeuchte: 54% Schlafzimmer: 17.1 (17)°C - Luftfeuchte: 47% Büro: 18.1 (17)°C Wohnzimmer/Diele: 21.8 (21.5)°C - Luftfeuchte: 42% Küche: 20.9 (21)°C - Luftfeuchte: 41% Keller: 18.4 (16)°C - Luftfeuchte: 55% Wassertemperaturen innen: WW-Gas-Speicher: 36.5°C WW-Solar-Speicher: 15°C ","to":"cech.andreas@chello.at","subject":"KB Statusmeldung","from":"smart-kb@inode.at"} 2020-12-13 14:00:00.320 - info: email.0 (19555) sent to cech.andreas@chello.at 2020-12-13 14:00:16.518 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864416428, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864416428' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:00:39.827 - info: daikin.0 (19540) Set State sensorInfo.indoorTemperature: "16" 2020-12-13 14:00:39.830 - info: daikin.0 (19540) 1 Values updated 2020-12-13 14:00:56.096 - info: unifi.0 (22696) Update done 2020-12-13 14:01:10.535 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864469973, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864469973' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:01:28.912 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864488764, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864488764' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:01:28.915 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864488763, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864488763' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:01:45.170 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864504971, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864504971' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:01:45.312 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864504972, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864504972' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:02:14.699 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864534554, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864534554' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:02:30.935 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864550787, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864550787' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:03:14.630 - info: javascript.0 (20648) script.js.common.350-379_Heizung-WW.350_WW_Zirkulationspumpe: Zirkop Keller aus 2020-12-13 14:03:14.632 - info: javascript.0 (20648) script.js.common.600-699_Licht.620_Bad_Licht_Spiegelschrank: * * * Spiegel alles AUS * * * 2020-12-13 14:03:14.635 - info: javascript.0 (20648) script.js.common.200-299_Audio-Video.240_neu_BAD_Radio_ein_aus: * * * Radio BAD aus * * * 2020-12-13 14:04:20.336 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864660190, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864660190' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:04:20.342 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864660191, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864660191' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:04:20.417 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864660190, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864660190' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:04:36.306 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864676273, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864676273' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:04:36.338 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864676274, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864676274' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:04:52.623 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864692459, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864692459' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:04:58.608 - info: nut.0 (21333) Start NUT update 2020-12-13 14:04:58.631 - info: nut.0 (21333) All Nut values set 2020-12-13 14:05:00.061 - info: host.ioBroker-Prod instance system.adapter.ical.0 started with pid 31097 2020-12-13 14:05:04.300 - info: ical.0 (31097) starting. Version 1.7.4 in /opt/iobroker/node_modules/iobroker.ical, node: v12.19.0, js-controller: 3.1.6 2020-12-13 14:05:04.933 - info: ical.0 (31097) processing URL: Feiertage https://calendar.google.com/calendar/ical/de.austrian%23holiday%40group.v.calendar.google.com/public/basic.ics 2020-12-13 14:05:05.036 - info: ical.0 (31097) processing URL: Geburtstage Cech https://calendar.google.com/calendar/ical/hd4b3rtin1f1qsvjbg64eg1jhc%40group.calendar.google.com/private-712abecefef0c24fe5521b59d2aade04/basic.ics 2020-12-13 14:05:05.729 - info: ical.0 (31097) processing URL: Muell https://calendar.google.com/calendar/ical/tqloimait9lkmlutadl0t27a9s%40group.calendar.google.com/private-289a3b0f58d98779693d103d163962a1/basic.ics 2020-12-13 14:05:05.829 - info: ical.0 (31097) processing URL: SonneMitHaus https://calendar.google.com/calendar/ical/sonnemithaus%40gmail.com/private-2575f3ee698831cfae2a0b7b1c348855/basic.ics 2020-12-13 14:05:07.639 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864707572, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864707572' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:05:11.007 - info: ical.0 (31097) Terminated (NO_ERROR): Without reason 2020-12-13 14:05:11.560 - info: host.ioBroker-Prod instance system.adapter.ical.0 terminated with code 0 (NO_ERROR) 2020-12-13 14:05:22.987 - info: sonoff.0 (22016) Client [Kueche-LED-Power-32] connection closed: closed 2020-12-13 14:05:27.150 - info: sonoff.0 (22016) Client [Kueche-LED-Power-32] connected with secret 1607864727136_5858 2020-12-13 14:05:27.235 - info: sonoff.0 (22016) new object created: sonoff.0.Kueche-LED-Power-32.INFO.Module 2020-12-13 14:05:27.258 - info: sonoff.0 (22016) new object created: sonoff.0.Kueche-LED-Power-32.INFO.Version 2020-12-13 14:05:27.316 - info: sonoff.0 (22016) new object created: sonoff.0.Kueche-LED-Power-32.INFO.Hostname 2020-12-13 14:05:27.368 - info: sonoff.0 (22016) new object created: sonoff.0.Kueche-LED-Power-32.INFO.IPAddress 2020-12-13 14:05:27.425 - info: sonoff.0 (22016) new object created: sonoff.0.Kueche-LED-Power-32.INFO.RestartReason 2020-12-13 14:06:04.904 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864764796, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864764796' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:06:04.938 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864764797, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864764797' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:06:04.949 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864764797, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864764797' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:06:44.239 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864804015, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864804015' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:07:12.040 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864831964, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864831964' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:07:12.217 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864831965, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864831965' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:07:50.993 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864870891, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864870891' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:08:05.126 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864885027, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864885027' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:08:05.134 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864885028, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864885028' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:08:56.822 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864936617, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864936617' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:09:24.634 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864964527, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864964527' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:09:24.674 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864964528, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864964528' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:09:38.737 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864978665, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864978665' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:09:58.609 - info: nut.0 (21333) Start NUT update 2020-12-13 14:09:58.657 - info: nut.0 (21333) All Nut values set 2020-12-13 14:10:03.501 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865003425, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865003425' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:10:03.911 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865003426, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865003426' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:10:55.869 - info: unifi.0 (22696) Update done 2020-12-13 14:11:12.106 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865071877, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865071877' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:11:27.862 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865087509, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865087509' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:11:33.210 - warn: mqtt.0 (21147) Client [ESP1-Garage-Poolsteuerung_1] Message undefined deleted after 2726 retries 2020-12-13 14:11:42.988 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865102883, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865102883' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:11:57.217 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865117064, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865117064' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:12:21.148 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865141087, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865141087' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:12:21.292 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865141088, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865141088' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:12:35.581 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865155180, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865155180' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:12:49.379 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865169199, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865169199' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:13:00.059 - info: host.ioBroker-Prod instance system.adapter.daswetter.0 started with pid 14429 2020-12-13 14:13:02.768 - info: daswetter.0 (14429) starting. Version 3.0.4 in /opt/iobroker/node_modules/iobroker.daswetter, node: v12.19.0, js-controller: 3.1.6 2020-12-13 14:13:13.792 - info: daswetter.0 (14429) Terminated (NO_ERROR): Without reason 2020-12-13 14:13:14.313 - info: host.ioBroker-Prod instance system.adapter.daswetter.0 terminated with code 0 (NO_ERROR) 2020-12-13 14:13:28.827 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865208774, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865208774' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:13:29.029 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865208775, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865208775' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:13:57.795 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865237585, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865237585' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:14:06.130 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 14:14:12.245 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865251971, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865251971' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:14:35.728 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865275661, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865275661' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:14:35.754 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865275662, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865275662' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:14:58.610 - info: nut.0 (21333) Start NUT update 2020-12-13 14:14:58.636 - info: nut.0 (21333) All Nut values set 2020-12-13 14:15:00.224 - info: host.ioBroker-Prod instance system.adapter.ical.0 started with pid 18188 2020-12-13 14:15:00.590 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865299997, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865299997' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:15:04.785 - info: ical.0 (18188) starting. Version 1.7.4 in /opt/iobroker/node_modules/iobroker.ical, node: v12.19.0, js-controller: 3.1.6 2020-12-13 14:15:05.387 - info: ical.0 (18188) processing URL: Feiertage https://calendar.google.com/calendar/ical/de.austrian%23holiday%40group.v.calendar.google.com/public/basic.ics 2020-12-13 14:15:05.535 - info: ical.0 (18188) processing URL: Geburtstage Cech https://calendar.google.com/calendar/ical/hd4b3rtin1f1qsvjbg64eg1jhc%40group.calendar.google.com/private-712abecefef0c24fe5521b59d2aade04/basic.ics 2020-12-13 14:15:06.205 - info: ical.0 (18188) processing URL: Muell https://calendar.google.com/calendar/ical/tqloimait9lkmlutadl0t27a9s%40group.calendar.google.com/private-289a3b0f58d98779693d103d163962a1/basic.ics 2020-12-13 14:15:06.303 - info: ical.0 (18188) processing URL: SonneMitHaus https://calendar.google.com/calendar/ical/sonnemithaus%40gmail.com/private-2575f3ee698831cfae2a0b7b1c348855/basic.ics 2020-12-13 14:15:08.003 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865307911, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865307911' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:15:08.091 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865307912, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865307912' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:15:11.485 - info: ical.0 (18188) Terminated (NO_ERROR): Without reason 2020-12-13 14:15:12.008 - info: host.ioBroker-Prod instance system.adapter.ical.0 terminated with code 0 (NO_ERROR) 2020-12-13 14:16:14.699 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865374454, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865374454' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:16:30.043 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865389861, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865389861' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:16:44.675 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 14:17:09.445 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865429379, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865429379' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:17:09.480 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865429380, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865429380' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:17:34.716 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 14:17:37.403 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865457144, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865457144' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:18:02.584 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865482244, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865482244' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:18:02.594 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865482243, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865482243' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:18:31.423 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865511259, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865511259' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:18:39.997 - info: web.0 (23327) ==>Connected system.user.admin from ::ffff:192.168.0.123 2020-12-13 14:18:47.243 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865526951, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865526951' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:18:47.355 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865526952, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865526952' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:18:54.104 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 14:19:32.641 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865572376, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865572376' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:19:32.818 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 14:19:41.383 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865581310, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865581310' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:19:41.620 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865581311, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865581311' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:19:48.039 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865587717, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865587717' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:19:56.523 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865596405, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865596405' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:19:58.612 - info: nut.0 (21333) Start NUT update 2020-12-13 14:19:58.635 - info: nut.0 (21333) All Nut values set 2020-12-13 14:20:23.523 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 14:20:47.828 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865647685, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865647685' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:20:56.669 - info: unifi.0 (22696) Update done 2020-12-13 14:21:06.937 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865666852, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865666852' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:21:07.044 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865666853, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865666853' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:21:31.263 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865691092, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865691092' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:21:31.288 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865691093, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865691093' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:21:46.523 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865706442, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865706442' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:21:46.568 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865706443, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865706443' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:22:01.428 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 14:22:01.473 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 14:22:01.528 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865721364, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865721364' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:22:15.520 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865735367, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865735367' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:22:15.613 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865735368, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865735368' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:22:41.121 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865760746, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865760746' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:23:11.365 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865791239, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865791239' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:23:11.767 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865791240, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865791240' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:23:52.953 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865832856, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865832856' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:23:52.979 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865832857, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865832857' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:24:08.455 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865848201, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865848201' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:24:13.842 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 14:24:42.051 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865881720, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865881720' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:24:42.054 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865881719, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865881719' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT)


Ich bin durch das Backup wieder auf die 1.15.1 zurück, da ich da noch keine Probs hatte.
Könnt ihr mir bitte raten, wo ich anfangen kann das Problem zu suchen. Ich habe so gar keinen Ansatz .....
Lieben Dank im Voraus
mxa -
Liebes Forum,
ich habe keine Ahnung wo ich noch drehen soll. Der SQL Adapter lief 2 Jahre völlig unauffällig, vor ca. 1. Woche hatte ich das erste Mal das Log voll mit solchen Einträgen:
sql.0 2020-12-13 16:26:22.066 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873181923, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873181923' for sql.0 2020-12-13 16:26:05.459 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873165315, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873165315' for sql.0 2020-12-13 16:25:48.525 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873148424, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873148424' for key ' sql.0 2020-12-13 16:25:48.501 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873148423, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873148423' for sql.0 2020-12-13 16:25:21.483 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873121289, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873121289' for sql.0 2020-12-13 16:25:21.322 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873121288, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873121288' for key ' sql.0 2020-12-13 16:25:05.875 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873105603, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873105603' for sql.0 2020-12-13 16:24:50.916 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873090756, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873090756' for sql.0 2020-12-13 16:24:50.880 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873090755, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873090755' for key ' sql.0 2020-12-13 16:23:55.379 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873035017, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873035017' for sql.0 2020-12-13 16:23:55.371 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607873035016, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607873035016' for key ' sql.0 2020-12-13 16:21:40.223 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607872899796, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607872899796' for sql.0 2020-12-13 16:21:39.918 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607872899795, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607872899795' for key ' sql.0 2020-12-13 16:21:26.933 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607872886503, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607872886503' for sql.0 2020-12-13 16:20:32.952 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607872832832, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607872832832' for sql.0 2020-12-13 16:20:17.740 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607872817649, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607872817649' for key ' sql.0 2020-12-13 16:20:02.931 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607872802761, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607872802761' for key ' sql.0 2020-12-13 16:19:25.271 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607872764923, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607872764923' for sql.0 2020-12-13 16:19:11.504 error (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607872751118, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607872751118' forDann hatte ich ein Backup eingespielt, mußte Float neu installieren, dann lief wieder alles ruhig. Seit 2 Stunden habe ich genau das gleiche Spiel wieder. Die Syno (da läuft mariaDB 5) habe ich neu gestartet, die VM auf einem NUC mit Proxmox ebenso.
Hier das Log, kurz vor dem Zeitpunkt der Fehlerorgie:
2020-12-13 13:36:03.275 - warn: fullybrowser.0 (4381) Generate State problem 192_168_0_121 {"message":"connect EHOSTUNREACH 192.168.0.121:2323","name":"Error","stack":"Error: connect EHOSTUNREACH 192.168.0.121:2323\n at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1145:16)","config":{"url":"http://192.168.0.121:2323/?cmd=deviceInfo&type=json&password=kalksburG","method":"get","headers":{"Accept":"application/json, text/plain, */*","User-Agent":"axios/0.20.0"},"transformRequest":[null],"transformResponse":[null],"timeout":0,"xsrfCookieName":"XSRF-TOKEN","xsrfHeaderName":"X-XSRF-TOKEN","maxContentLength":-1,"maxBodyLength":-1},"code":"EHOSTUNREACH"} 2020-12-13 13:36:03.929 - info: fullybrowser.0 (4381) Start with IP : 192.168.0.123 2020-12-13 13:36:17.581 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 13:39:54.255 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.BAD_Radar_BWM_schaltet_var: + + + var einschalten und in 9 Min ausschalten + + + 2020-12-13 13:39:54.264 - info: javascript.0 (20648) script.js.common.350-379_Heizung-WW.350_WW_Zirkulationspumpe: Zirkop Keller ein 2020-12-13 13:39:54.265 - info: javascript.0 (20648) script.js.common.600-699_Licht.620_Bad_Licht_Spiegelschrank: * * * Spiegel KALT ein * * * 2020-12-13 13:39:54.266 - info: javascript.0 (20648) script.js.common.200-299_Audio-Video.240_neu_BAD_Radio_ein_aus: * * * Radio BAD ein * * * 2020-12-13 13:39:58.599 - info: nut.0 (21333) Start NUT update 2020-12-13 13:39:58.623 - info: nut.0 (21333) All Nut values set 2020-12-13 13:40:14.386 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.BAD_Radar_BWM_schaltet_var: + + + ausschaltdauer in 9 Minuten erneut gesetzt + + + 2020-12-13 13:40:17.407 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 13:40:57.801 - info: unifi.0 (22696) Update done 2020-12-13 13:41:04.082 - info: web.0 (23327) ==>Connected system.user.admin from ::ffff:192.168.0.121 2020-12-13 13:43:00.044 - info: host.ioBroker-Prod instance system.adapter.daswetter.0 started with pid 19041 2020-12-13 13:43:03.287 - info: daswetter.0 (19041) starting. Version 3.0.4 in /opt/iobroker/node_modules/iobroker.daswetter, node: v12.19.0, js-controller: 3.1.6 2020-12-13 13:43:12.656 - info: daswetter.0 (19041) Terminated (NO_ERROR): Without reason 2020-12-13 13:43:13.181 - info: host.ioBroker-Prod instance system.adapter.daswetter.0 terminated with code 0 (NO_ERROR) 2020-12-13 13:43:40.719 - error: sql.0 (22409) No type undefined found for g-homa.0.1E493A.state. Retention is not possible. 2020-12-13 13:44:40.699 - error: sql.0 (22409) No type undefined found for g-homa.0.1E493A.state. Retention is not possible. 2020-12-13 13:44:58.601 - info: nut.0 (21333) Start NUT update 2020-12-13 13:44:58.637 - info: nut.0 (21333) All Nut values set 2020-12-13 13:45:00.055 - info: host.ioBroker-Prod instance system.adapter.ical.0 started with pid 23215 2020-12-13 13:45:05.502 - info: ical.0 (23215) starting. Version 1.7.4 in /opt/iobroker/node_modules/iobroker.ical, node: v12.19.0, js-controller: 3.1.6 2020-12-13 13:45:06.016 - info: ical.0 (23215) processing URL: Feiertage https://calendar.google.com/calendar/ical/de.austrian%23holiday%40group.v.calendar.google.com/public/basic.ics 2020-12-13 13:45:06.152 - info: ical.0 (23215) processing URL: Geburtstage Cech https://calendar.google.com/calendar/ical/hd4b3rtin1f1qsvjbg64eg1jhc%40group.calendar.google.com/private-712abecefef0c24fe5521b59d2aade04/basic.ics 2020-12-13 13:45:06.844 - info: ical.0 (23215) processing URL: Muell https://calendar.google.com/calendar/ical/tqloimait9lkmlutadl0t27a9s%40group.calendar.google.com/private-289a3b0f58d98779693d103d163962a1/basic.ics 2020-12-13 13:45:07.087 - info: ical.0 (23215) processing URL: SonneMitHaus https://calendar.google.com/calendar/ical/sonnemithaus%40gmail.com/private-2575f3ee698831cfae2a0b7b1c348855/basic.ics 2020-12-13 13:45:12.249 - info: ical.0 (23215) Terminated (NO_ERROR): Without reason 2020-12-13 13:45:12.777 - info: host.ioBroker-Prod instance system.adapter.ical.0 terminated with code 0 (NO_ERROR) 2020-12-13 13:45:13.644 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 13:45:51.825 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 13:46:08.538 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 13:46:45.318 - info: javascript.0 (20648) Stop script script.js.common.200-299_Audio-Video.276_Tablet_BAD_Akku_laden 2020-12-13 13:46:45.419 - info: javascript.0 (20648) Start javascript script.js.common.200-299_Audio-Video.276_Tablet_BAD_Akku_laden 2020-12-13 13:46:45.449 - info: javascript.0 (20648) script.js.common.200-299_Audio-Video.276_Tablet_BAD_Akku_laden: registered 1 subscription and 0 schedules 2020-12-13 13:47:48.803 - info: web.0 (23327) <==Disconnect system.user.admin from ::ffff:192.168.0.123 vis.0 2020-12-13 13:49:14.394 - info: javascript.0 (20648) script.js.common.350-379_Heizung-WW.350_WW_Zirkulationspumpe: Zirkop Keller aus 2020-12-13 13:49:14.395 - info: javascript.0 (20648) script.js.common.600-699_Licht.620_Bad_Licht_Spiegelschrank: * * * Spiegel alles AUS * * * 2020-12-13 13:49:14.396 - info: javascript.0 (20648) script.js.common.200-299_Audio-Video.240_neu_BAD_Radio_ein_aus: * * * Radio BAD aus * * * 2020-12-13 13:49:34.496 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863774190, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863774190' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:49:34.712 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863774191, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863774191' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:49:51.230 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863790938, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863790938' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:49:58.604 - info: nut.0 (21333) Start NUT update 2020-12-13 13:49:58.660 - info: nut.0 (21333) All Nut values set 2020-12-13 13:50:06.662 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863806565, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863806565' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:50:06.673 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863806566, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863806566' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:50:06.684 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863806565, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863806565' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:50:21.276 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863821123, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863821123' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:50:21.347 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863821124, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863821124' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:50:56.306 - info: unifi.0 (22696) Update done 2020-12-13 13:51:00.193 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863859998, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863859998' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:51:28.277 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863888029, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863888029' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:51:32.640 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863892390, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863892390' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:51:50.779 - info: host.ioBroker-Prod stopInstance system.adapter.fullybrowser.0 (force=false, process=true) 2020-12-13 13:51:50.787 - info: host.ioBroker-Prod stopInstance system.adapter.fullybrowser.0 send kill signal 2020-12-13 13:51:50.794 - info: fullybrowser.0 (4381) Got terminate signal TERMINATE_YOURSELF 2020-12-13 13:51:50.795 - info: fullybrowser.0 (4381) cleaned everything up... 2020-12-13 13:51:50.797 - info: fullybrowser.0 (4381) terminating 2020-12-13 13:51:50.799 - info: fullybrowser.0 (4381) Terminated (ADAPTER_REQUESTED_TERMINATION): Without reason 2020-12-13 13:51:51.371 - info: host.ioBroker-Prod instance system.adapter.fullybrowser.0 terminated with code 11 (ADAPTER_REQUESTED_TERMINATION) 2020-12-13 13:51:53.334 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863913229, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863913229' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:51:53.844 - info: host.ioBroker-Prod instance system.adapter.fullybrowser.0 started with pid 4005 2020-12-13 13:51:57.120 - info: fullybrowser.0 (4005) starting. Version 2.0.1 in /opt/iobroker/node_modules/iobroker.fullybrowser, node: v12.19.0, js-controller: 3.1.6 2020-12-13 13:51:57.160 - info: fullybrowser.0 (4005) Start with IP : 192.168.0.121 2020-12-13 13:51:59.412 - info: fullybrowser.0 (4005) Start with IP : 192.168.0.123 2020-12-13 13:52:08.212 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863927883, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863927883' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:52:20.912 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863940839, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863940839' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:52:33.317 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607863953057, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607863953057' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:53:28.884 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864008723, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864008723' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:53:29.018 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864008724, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864008724' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:53:45.038 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864024880, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864024880' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:53:45.041 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864024880, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864024880' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:53:45.046 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864024881, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864024881' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:54:10.855 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864050383, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864050383' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:54:10.886 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864050384, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864050384' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:54:14.625 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.BAD_Radar_BWM_schaltet_var: + + + var einschalten und in 9 Min ausschalten + + + 2020-12-13 13:54:14.629 - info: javascript.0 (20648) script.js.common.350-379_Heizung-WW.350_WW_Zirkulationspumpe: Zirkop Keller ein 2020-12-13 13:54:14.632 - info: javascript.0 (20648) script.js.common.600-699_Licht.620_Bad_Licht_Spiegelschrank: * * * Spiegel KALT ein * * * 2020-12-13 13:54:14.633 - info: javascript.0 (20648) script.js.common.200-299_Audio-Video.240_neu_BAD_Radio_ein_aus: * * * Radio BAD ein * * * 2020-12-13 13:54:14.680 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 13:54:22.402 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864062228, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864062228' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:54:39.658 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864079457, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864079457' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:54:44.014 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 13:54:58.606 - info: nut.0 (21333) Start NUT update 2020-12-13 13:54:58.631 - info: nut.0 (21333) All Nut values set 2020-12-13 13:55:00.060 - info: host.ioBroker-Prod instance system.adapter.ical.0 started with pid 10585 2020-12-13 13:55:03.926 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864103643, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864103643' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:55:04.626 - info: ical.0 (10585) starting. Version 1.7.4 in /opt/iobroker/node_modules/iobroker.ical, node: v12.19.0, js-controller: 3.1.6 2020-12-13 13:55:05.291 - info: ical.0 (10585) processing URL: Feiertage https://calendar.google.com/calendar/ical/de.austrian%23holiday%40group.v.calendar.google.com/public/basic.ics 2020-12-13 13:55:05.435 - info: ical.0 (10585) processing URL: Geburtstage Cech https://calendar.google.com/calendar/ical/hd4b3rtin1f1qsvjbg64eg1jhc%40group.calendar.google.com/private-712abecefef0c24fe5521b59d2aade04/basic.ics 2020-12-13 13:55:06.179 - info: ical.0 (10585) processing URL: Muell https://calendar.google.com/calendar/ical/tqloimait9lkmlutadl0t27a9s%40group.calendar.google.com/private-289a3b0f58d98779693d103d163962a1/basic.ics 2020-12-13 13:55:06.303 - info: ical.0 (10585) processing URL: SonneMitHaus https://calendar.google.com/calendar/ical/sonnemithaus%40gmail.com/private-2575f3ee698831cfae2a0b7b1c348855/basic.ics 2020-12-13 13:55:11.478 - info: ical.0 (10585) Terminated (NO_ERROR): Without reason 2020-12-13 13:55:11.997 - info: host.ioBroker-Prod instance system.adapter.ical.0 terminated with code 0 (NO_ERROR) 2020-12-13 13:55:20.065 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864119798, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864119798' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:55:21.056 - info: web.0 (23327) ==>Connected system.user.admin from ::ffff:192.168.0.202 2020-12-13 13:55:34.613 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864134493, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864134493' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:55:48.964 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864148867, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864148867' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:55:49.103 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864148868, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864148868' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:55:57.312 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 13:56:00.760 - info: web.0 (23327) <==Disconnect system.user.admin from ::ffff:192.168.0.202 flot 2020-12-13 13:56:24.579 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 13:56:41.335 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864200973, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864200973' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:56:41.355 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864200974, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864200974' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:56:41.841 - error: sourceanalytix.0 (22358) Cannot execute calculations for sonoff.0.SONOFF_32_POW.ENERGY_Total adjust settings ! 2020-12-13 13:56:41.848 - error: sourceanalytix.0 (22358) Selected Type Wählen does not exist in Price Definitions 2020-12-13 13:56:41.848 - error: sourceanalytix.0 (22358) Please choose proper type for state sonoff.0.SONOFF_32_POW.ENERGY_Total 2020-12-13 13:56:41.848 - error: sourceanalytix.0 (22358) Or add price definition Wählen in adapter settings 2020-12-13 13:56:41.850 - error: sourceanalytix.0 (22358) Cannot handle initialisation for sonoff.0.SONOFF_32_POW.ENERGY_Total 2020-12-13 13:56:47.686 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864207570, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864207570' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:56:47.721 - error: sourceanalytix.0 (22358) Cannot execute calculations for sonoff.0.SONOFF_32_POW.ENERGY_Total adjust settings ! 2020-12-13 13:56:47.722 - error: sourceanalytix.0 (22358) Selected Type Wählen does not exist in Price Definitions 2020-12-13 13:56:47.723 - error: sourceanalytix.0 (22358) Please choose proper type for state sonoff.0.SONOFF_32_POW.ENERGY_Total 2020-12-13 13:56:47.723 - error: sourceanalytix.0 (22358) Or add price definition Wählen in adapter settings 2020-12-13 13:56:47.724 - error: sourceanalytix.0 (22358) Cannot handle initialisation for sonoff.0.SONOFF_32_POW.ENERGY_Total 2020-12-13 13:56:47.760 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864207571, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864207571' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:57:48.678 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864268575, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864268575' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:57:48.818 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864268576, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864268576' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:57:48.945 - info: web.0 (23327) ==>Connected system.user.admin from ::ffff:192.168.0.202 2020-12-13 13:58:00.895 - info: web.0 (23327) <==Disconnect system.user.admin from ::ffff:192.168.0.202 flot 2020-12-13 13:58:02.854 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864282715, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864282715' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:58:02.908 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864282716, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864282716' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:58:16.609 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864296510, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864296510' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:58:16.708 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864296511, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864296511' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:58:54.497 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864334461, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864334461' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:59:22.325 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864362286, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864362286' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 13:59:58.607 - info: nut.0 (21333) Start NUT update 2020-12-13 13:59:58.639 - info: nut.0 (21333) All Nut values set 2020-12-13 13:59:59.827 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864399431, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864399431' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:00:00.013 - info: javascript.0 (20648) script.js.common.900-919_Information.900_eMail_grosser_Bericht: Mail wurde versandt 2020-12-13 14:00:00.066 - info: email.0 (19555) Send email: {"html":"Servicemeldungen: 1 EG Tuere Terrasse (KEQ0858830) - Spannung Batterien/Akkus gering. 3x LR6/AA Sicherheit: Verschluss gesamt: offen Temperaturen aussen: Nord: 5.7°C - Luftfeuchte: 86% Poolwasser: 4.4°C Poolsolar: 10.8°C Temperaturen innen: Bad & WC: 21.7 (21)°C - Luftfeuchte: 54% Schlafzimmer: 17.1 (17)°C - Luftfeuchte: 47% Büro: 18.1 (17)°C Wohnzimmer/Diele: 21.8 (21.5)°C - Luftfeuchte: 42% Küche: 20.9 (21)°C - Luftfeuchte: 41% Keller: 18.4 (16)°C - Luftfeuchte: 55% Wassertemperaturen innen: WW-Gas-Speicher: 36.5°C WW-Solar-Speicher: 15°C ","to":"cech.andreas@chello.at","subject":"KB Statusmeldung","from":"smart-kb@inode.at"} 2020-12-13 14:00:00.320 - info: email.0 (19555) sent to cech.andreas@chello.at 2020-12-13 14:00:16.518 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864416428, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864416428' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:00:39.827 - info: daikin.0 (19540) Set State sensorInfo.indoorTemperature: "16" 2020-12-13 14:00:39.830 - info: daikin.0 (19540) 1 Values updated 2020-12-13 14:00:56.096 - info: unifi.0 (22696) Update done 2020-12-13 14:01:10.535 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864469973, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864469973' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:01:28.912 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864488764, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864488764' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:01:28.915 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864488763, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864488763' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:01:45.170 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864504971, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864504971' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:01:45.312 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864504972, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864504972' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:02:14.699 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864534554, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864534554' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:02:30.935 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864550787, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864550787' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:03:14.630 - info: javascript.0 (20648) script.js.common.350-379_Heizung-WW.350_WW_Zirkulationspumpe: Zirkop Keller aus 2020-12-13 14:03:14.632 - info: javascript.0 (20648) script.js.common.600-699_Licht.620_Bad_Licht_Spiegelschrank: * * * Spiegel alles AUS * * * 2020-12-13 14:03:14.635 - info: javascript.0 (20648) script.js.common.200-299_Audio-Video.240_neu_BAD_Radio_ein_aus: * * * Radio BAD aus * * * 2020-12-13 14:04:20.336 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864660190, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864660190' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:04:20.342 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864660191, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864660191' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:04:20.417 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864660190, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864660190' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:04:36.306 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864676273, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864676273' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:04:36.338 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864676274, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864676274' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:04:52.623 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864692459, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864692459' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:04:58.608 - info: nut.0 (21333) Start NUT update 2020-12-13 14:04:58.631 - info: nut.0 (21333) All Nut values set 2020-12-13 14:05:00.061 - info: host.ioBroker-Prod instance system.adapter.ical.0 started with pid 31097 2020-12-13 14:05:04.300 - info: ical.0 (31097) starting. Version 1.7.4 in /opt/iobroker/node_modules/iobroker.ical, node: v12.19.0, js-controller: 3.1.6 2020-12-13 14:05:04.933 - info: ical.0 (31097) processing URL: Feiertage https://calendar.google.com/calendar/ical/de.austrian%23holiday%40group.v.calendar.google.com/public/basic.ics 2020-12-13 14:05:05.036 - info: ical.0 (31097) processing URL: Geburtstage Cech https://calendar.google.com/calendar/ical/hd4b3rtin1f1qsvjbg64eg1jhc%40group.calendar.google.com/private-712abecefef0c24fe5521b59d2aade04/basic.ics 2020-12-13 14:05:05.729 - info: ical.0 (31097) processing URL: Muell https://calendar.google.com/calendar/ical/tqloimait9lkmlutadl0t27a9s%40group.calendar.google.com/private-289a3b0f58d98779693d103d163962a1/basic.ics 2020-12-13 14:05:05.829 - info: ical.0 (31097) processing URL: SonneMitHaus https://calendar.google.com/calendar/ical/sonnemithaus%40gmail.com/private-2575f3ee698831cfae2a0b7b1c348855/basic.ics 2020-12-13 14:05:07.639 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864707572, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864707572' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:05:11.007 - info: ical.0 (31097) Terminated (NO_ERROR): Without reason 2020-12-13 14:05:11.560 - info: host.ioBroker-Prod instance system.adapter.ical.0 terminated with code 0 (NO_ERROR) 2020-12-13 14:05:22.987 - info: sonoff.0 (22016) Client [Kueche-LED-Power-32] connection closed: closed 2020-12-13 14:05:27.150 - info: sonoff.0 (22016) Client [Kueche-LED-Power-32] connected with secret 1607864727136_5858 2020-12-13 14:05:27.235 - info: sonoff.0 (22016) new object created: sonoff.0.Kueche-LED-Power-32.INFO.Module 2020-12-13 14:05:27.258 - info: sonoff.0 (22016) new object created: sonoff.0.Kueche-LED-Power-32.INFO.Version 2020-12-13 14:05:27.316 - info: sonoff.0 (22016) new object created: sonoff.0.Kueche-LED-Power-32.INFO.Hostname 2020-12-13 14:05:27.368 - info: sonoff.0 (22016) new object created: sonoff.0.Kueche-LED-Power-32.INFO.IPAddress 2020-12-13 14:05:27.425 - info: sonoff.0 (22016) new object created: sonoff.0.Kueche-LED-Power-32.INFO.RestartReason 2020-12-13 14:06:04.904 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864764796, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864764796' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:06:04.938 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864764797, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864764797' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:06:04.949 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864764797, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864764797' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:06:44.239 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864804015, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864804015' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:07:12.040 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864831964, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864831964' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:07:12.217 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864831965, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864831965' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:07:50.993 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864870891, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864870891' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:08:05.126 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864885027, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864885027' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:08:05.134 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864885028, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864885028' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:08:56.822 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864936617, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864936617' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:09:24.634 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864964527, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864964527' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:09:24.674 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864964528, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864964528' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:09:38.737 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607864978665, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607864978665' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:09:58.609 - info: nut.0 (21333) Start NUT update 2020-12-13 14:09:58.657 - info: nut.0 (21333) All Nut values set 2020-12-13 14:10:03.501 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865003425, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865003425' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:10:03.911 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865003426, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865003426' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:10:55.869 - info: unifi.0 (22696) Update done 2020-12-13 14:11:12.106 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865071877, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865071877' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:11:27.862 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865087509, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865087509' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:11:33.210 - warn: mqtt.0 (21147) Client [ESP1-Garage-Poolsteuerung_1] Message undefined deleted after 2726 retries 2020-12-13 14:11:42.988 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865102883, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865102883' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:11:57.217 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865117064, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865117064' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:12:21.148 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865141087, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865141087' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:12:21.292 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865141088, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865141088' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:12:35.581 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865155180, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865155180' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:12:49.379 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865169199, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865169199' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:13:00.059 - info: host.ioBroker-Prod instance system.adapter.daswetter.0 started with pid 14429 2020-12-13 14:13:02.768 - info: daswetter.0 (14429) starting. Version 3.0.4 in /opt/iobroker/node_modules/iobroker.daswetter, node: v12.19.0, js-controller: 3.1.6 2020-12-13 14:13:13.792 - info: daswetter.0 (14429) Terminated (NO_ERROR): Without reason 2020-12-13 14:13:14.313 - info: host.ioBroker-Prod instance system.adapter.daswetter.0 terminated with code 0 (NO_ERROR) 2020-12-13 14:13:28.827 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865208774, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865208774' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:13:29.029 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865208775, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865208775' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:13:57.795 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865237585, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865237585' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:14:06.130 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 14:14:12.245 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865251971, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865251971' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:14:35.728 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865275661, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865275661' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:14:35.754 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865275662, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865275662' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:14:58.610 - info: nut.0 (21333) Start NUT update 2020-12-13 14:14:58.636 - info: nut.0 (21333) All Nut values set 2020-12-13 14:15:00.224 - info: host.ioBroker-Prod instance system.adapter.ical.0 started with pid 18188 2020-12-13 14:15:00.590 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865299997, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865299997' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:15:04.785 - info: ical.0 (18188) starting. Version 1.7.4 in /opt/iobroker/node_modules/iobroker.ical, node: v12.19.0, js-controller: 3.1.6 2020-12-13 14:15:05.387 - info: ical.0 (18188) processing URL: Feiertage https://calendar.google.com/calendar/ical/de.austrian%23holiday%40group.v.calendar.google.com/public/basic.ics 2020-12-13 14:15:05.535 - info: ical.0 (18188) processing URL: Geburtstage Cech https://calendar.google.com/calendar/ical/hd4b3rtin1f1qsvjbg64eg1jhc%40group.calendar.google.com/private-712abecefef0c24fe5521b59d2aade04/basic.ics 2020-12-13 14:15:06.205 - info: ical.0 (18188) processing URL: Muell https://calendar.google.com/calendar/ical/tqloimait9lkmlutadl0t27a9s%40group.calendar.google.com/private-289a3b0f58d98779693d103d163962a1/basic.ics 2020-12-13 14:15:06.303 - info: ical.0 (18188) processing URL: SonneMitHaus https://calendar.google.com/calendar/ical/sonnemithaus%40gmail.com/private-2575f3ee698831cfae2a0b7b1c348855/basic.ics 2020-12-13 14:15:08.003 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865307911, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865307911' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:15:08.091 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865307912, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865307912' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:15:11.485 - info: ical.0 (18188) Terminated (NO_ERROR): Without reason 2020-12-13 14:15:12.008 - info: host.ioBroker-Prod instance system.adapter.ical.0 terminated with code 0 (NO_ERROR) 2020-12-13 14:16:14.699 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865374454, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865374454' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:16:30.043 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865389861, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865389861' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:16:44.675 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 14:17:09.445 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865429379, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865429379' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:17:09.480 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865429380, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865429380' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:17:34.716 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 14:17:37.403 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865457144, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865457144' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:18:02.584 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865482244, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865482244' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:18:02.594 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865482243, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865482243' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:18:31.423 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865511259, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865511259' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:18:39.997 - info: web.0 (23327) ==>Connected system.user.admin from ::ffff:192.168.0.123 2020-12-13 14:18:47.243 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865526951, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865526951' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:18:47.355 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865526952, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865526952' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:18:54.104 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 14:19:32.641 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865572376, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865572376' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:19:32.818 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 14:19:41.383 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865581310, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865581310' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:19:41.620 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865581311, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865581311' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:19:48.039 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865587717, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865587717' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:19:56.523 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865596405, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865596405' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:19:58.612 - info: nut.0 (21333) Start NUT update 2020-12-13 14:19:58.635 - info: nut.0 (21333) All Nut values set 2020-12-13 14:20:23.523 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 14:20:47.828 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865647685, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865647685' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:20:56.669 - info: unifi.0 (22696) Update done 2020-12-13 14:21:06.937 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865666852, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865666852' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:21:07.044 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865666853, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865666853' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:21:31.263 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865691092, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865691092' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:21:31.288 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865691093, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865691093' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:21:46.523 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865706442, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865706442' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:21:46.568 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865706443, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865706443' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:22:01.428 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 14:22:01.473 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 14:22:01.528 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865721364, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865721364' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:22:15.520 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865735367, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865735367' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:22:15.613 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865735368, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865735368' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:22:41.121 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865760746, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865760746' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:23:11.365 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865791239, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865791239' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:23:11.767 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865791240, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865791240' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:23:52.953 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865832856, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865832856' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:23:52.979 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865832857, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865832857' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:24:08.455 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865848201, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865848201' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:24:13.842 - info: javascript.0 (20648) script.js.common.780-799_Bewegung.Diele_Radar_BWM_schaltet_var: + + + var BWM Diele um 3 Min. verlängert + + + 2020-12-13 14:24:42.051 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865881720, 'Connection Lost', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865881720' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT) 2020-12-13 14:24:42.054 - error: sql.0 (22409) Cannot insert INSERT INTO `ioBroker`.ts_string (id, ts, val, ack, _from, q) VALUES(86, 1607865881719, 'Connected', 1, 14, 0);: Error: ER_DUP_ENTRY: Duplicate entry '86-1607865881719' for key 'PRIMARY' (id: mqtt.0.ESP1-Garage-Poolsteuerung.status.LWT)


Ich bin durch das Backup wieder auf die 1.15.1 zurück, da ich da noch keine Probs hatte.
Könnt ihr mir bitte raten, wo ich anfangen kann das Problem zu suchen. Ich habe so gar keinen Ansatz .....
Lieben Dank im Voraus
mxa@metaxa Die Logs der Datenbank (nicht von ioBroker) wären interessant.
Und Speicherplatz hat die DB noch genug?
Bitte bei Problemen mit meinen Adaptern, Issue auf GitHub erfassen: Loxone | I2C | Luxtronik2
♡-lichen Dank an meine Sponsoren -
@metaxa Die Logs der Datenbank (nicht von ioBroker) wären interessant.
Und Speicherplatz hat die DB noch genug?
Hey! Du scheinst an dieser Unterhaltung interessiert zu sein, hast aber noch kein Konto.
Hast du es satt, bei jedem Besuch durch die gleichen Beiträge zu scrollen? Wenn du dich für ein Konto anmeldest, kommst du immer genau dorthin zurück, wo du zuvor warst, und kannst dich über neue Antworten benachrichtigen lassen (entweder per E-Mail oder Push-Benachrichtigung). Du kannst auch Lesezeichen speichern und Beiträge positiv bewerten, um anderen Community-Mitgliedern deine Wertschätzung zu zeigen.
Mit deinem Input könnte dieser Beitrag noch besser werden 💗
Registrieren Anmelden
