NEWS
Fehler bei SQL 1.4.2
-
Hallo,
wenn ich einen Adapter update (habe die neue Version des REGA-Adapters installiert)
kachelt regelmäßig der SQL-Adapter ab:
host.zotac 2017-02-11 09:09:29.342 error instance system.adapter.sql.0 terminated with code 6 (uncaught exception) sql.0 2017-02-11 09:09:29.115 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-11 09:09:29.114 error at Immediate._tickCallback (internal/process/next_tick.js:98:9) sql.0 2017-02-11 09:09:29.114 error at _combinedTickCallback (internal/process/next_tick.js:71:11) sql.0 2017-02-11 09:09:29.114 error at listOnTimeoutNT (timers.js:255:26) sql.0 2017-02-11 09:09:29.114 error at Timer.listOnTimeout (timers.js:207:5) sql.0 2017-02-11 09:09:29.114 error at tryOnTimeout (timers.js:237:5) sql.0 2017-02-11 09:09:29.114 error at ontimeout (timers.js:365:14) sql.0 2017-02-11 09:09:29.114 error at Timeout._onTimeout (/opt/iobroker/node_modules/iobroker.js-controller/lib/adapter.js:746:30) sql.0 2017-02-11 09:09:29.114 error at Adapter.emit (events.js:191:7) sql.0 2017-02-11 09:09:29.114 error at emitTwo (events.js:106:13) sql.0 2017-02-11 09:09:29.114 error at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:42:49) sql.0 2017-02-11 09:09:29.114 error TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-11 09:09:29.113 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-11 09:09:29.111 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-11 09:09:29.110 error at Immediate._tickCallback (internal/process/next_tick.js:98:9) sql.0 2017-02-11 09:09:29.110 error at _combinedTickCallback (internal/process/next_tick.js:71:11) sql.0 2017-02-11 09:09:29.110 error at listOnTimeoutNT (timers.js:255:26) sql.0 2017-02-11 09:09:29.110 error at Timer.listOnTimeout (timers.js:207:5) sql.0 2017-02-11 09:09:29.110 error at tryOnTimeout (timers.js:237:5) sql.0 2017-02-11 09:09:29.110 error at ontimeout (timers.js:365:14) sql.0 2017-02-11 09:09:29.110 error at Timeout._onTimeout (/opt/iobroker/node_modules/iobroker.js-controller/lib/adapter.js:746:30) sql.0 2017-02-11 09:09:29.110 error at Adapter.emit (events.js:191:7) sql.0 2017-02-11 09:09:29.110 error at emitTwo (events.js:106:13) sql.0 2017-02-11 09:09:29.110 error at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:42:49) sql.0 2017-02-11 09:09:29.110 error TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-11 09:09:29.103 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-11 09:09:29.100 warn Exception: TypeError: Cannot read property 'sql.0' of undefinedNach einem manuellen Neustart des SQL-Adapters ist wieder alles gut.
Ist das in der 1.4.3 behoben? Leider zeigt er mir das Update nur in grau an, obwohl alles andere bei mir aktuell ist?
PS: Echte MySQL-DB auf gesonderten Server.
-
Für die neueste sql-version muss auch dein admin-Adapter aktuell sein. Dann geht das "graue" weg.
Und du hast nen kleinen Bug gefunden :-) Nach dem Admin-Update SQL neu von Github installieren und testen bitte. Danke `
Hallo,
ich habe 1.16.11 vom Admin. Was neueres wird mir nicht angezeigt.
-
Und der js-controller muss >=0.12.0 sein. Was hast Du?
Was kommt denn als Mouseover wenn DU über das graue Icon gehst? `
Hallo, der JS-Controller ist 0.15.3
PS: Den SQL-Adapter habe ich manuell aktualisert.
Der Fehler ist aber immer noch da. Nachdem ich den REGA-Adapter neu gestartet habe, stürzt der SQL-Adapter ab.
sql.0 2017-02-17 09:40:29.986 error TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-17 09:40:29.986 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-17 09:40:29.978 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-17 09:40:29.973 error at Timer.listOnTimeout (timers.js:207:5) sql.0 2017-02-17 09:40:29.973 error at tryOnTimeout (timers.js:237:5) sql.0 2017-02-17 09:40:29.973 error at ontimeout (timers.js:365:14) sql.0 2017-02-17 09:40:29.973 error at Timeout._onTimeout (/opt/iobroker/node_modules/iobroker.js-controller/lib/adapter.js:746:30) sql.0 2017-02-17 09:40:29.973 error at Adapter.emit (events.js:191:7) sql.0 2017-02-17 09:40:29.973 error at emitTwo (events.js:106:13) sql.0 2017-02-17 09:40:29.973 error at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:42:49) sql.0 2017-02-17 09:40:29.973 error TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-17 09:40:29.965 error uncaught exception: Cannot read property 'sql.0' of undefined hm-rega.0 2017-02-17 09:40:29.938 info added/updated 89 programs hm-rega.0 2017-02-17 09:40:29.707 info got 89 programs hm-rega.0 2017-02-17 09:40:27.975 info added/updated rooms to enum.rooms hm-rega.0 2017-02-17 09:40:27.697 info added/updated functions to enum.functions hm-rega.0 2017-02-17 09:40:27.243 info added/updated 26 favorites to enum.favorites hm-rega.0 2017-02-17 09:40:26.747 info time difference local-ccu 1s hm-rega.0 2017-02-17 09:40:26.669 info ReGaHSS 192.168.1.11 up hm-rega.0 2017-02-17 09:40:25.534 info subscribe hm-rpc.0.BidCoS-RF.50.PRESS_SHORT hm-rega.0 2017-02-17 09:40:25.476 info starting. Version 1.4.3 in /opt/iobroker/node_modules/iobroker.hm-rega, node: v6.9.2 host.zotac 2017-02-17 09:40:24.156 info instance system.adapter.hm-rega.0 started with pid 28888 host.zotac 2017-02-17 09:40:21.742 info instance system.adapter.hm-rega.0 terminated with code 0 (OK) hm-rega.0 2017-02-17 09:40:21.636 info terminating host.zotac 2017-02-17 09:40:21.582 info stopInstance system.adapter.hm-rega.0 killing pid 6778 host.zotac 2017-02-17 09:40:21.580 info stopInstance system.adapter.hm-rega.0 host.zotac 2017-02-17 09:40:21.572 info object change system.adapter.hm-rega.0 -
Hast Du normal aktualisiert oder vom github aktualisiert? Musst von Githuvb holen weil erstmal nur da der Fehler gefixt ist (zum testen) `
Habe ich jetzt:
SQL 1.4.4
bei admin gibt es aber:
$ ./iobroker url "https://github.com/ioBroker/ioBroker.admin/tarball/master" admin install https://github.com/ioBroker/ioBroker.admin/tarball/master npm install https://github.com/ioBroker/ioBroker.admin/tarball/master --production --prefix "/opt/iobroker" (System call) npm WARN enoent ENOENT: no such file or directory, open '/opt/iobroker/node_modules/buildmail/package.json'npm WARN enoent ENOENT: no such file or directory, open '/opt/iobroker/node_modules/commist/package.json' npm WARN enoent ENOENT: no such file or directory, open '/opt/iobroker/node_modules/concat-stream/package.json' npm WARN enoent ENOENT: no such file or directory, open '/opt/iobroker/node_modules/duplexify/package.json' npm WARN enoent ENOENT: no such file or directory, open '/opt/iobroker/node_modules/follow-redirects/package.json' npm WARN enoent ENOENT: no such file or directory, open '/opt/iobroker/node_modules/glob-stream/package.json' npm WARN enoent ENOENT: no such file or directory, open '/opt/iobroker/node_modules/imap/package.json' ERROR: host.zotac Cannot install https://github.com/ioBroker/ioBroker.admin/tarball/master: 1 ERROR: process exited with code 25 -
Admin brauchst DU an sich nicht vom Github. Der Bugfix von mir war in sql drin. `
Ok,
nach Neustart Rega kommt jetzt:
hm-rega.0 2017-02-17 14:31:30.565 info hm-rega.0 added/updated 66 variables zotac 2017-02-17 14:31:28.887 info host.zotac Restart adapter system.adapter.sql.0 because enabled zotac 2017-02-17 14:31:28.886 error host.zotac instance system.adapter.sql.0 terminated with code 0 (OK) hm-rega.0 2017-02-17 14:31:28.824 info hm-rega.0 got 66 variables sql.0 2017-02-17 14:31:27.924 warn sql.0 Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-17 14:31:27.924 error sql.0 TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:42:49) at emitTwo (events.js:106:13) at Adapter.emit (eve sql.0 2017-02-17 14:31:27.924 error sql.0 uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-17 14:31:27.922 warn sql.0 Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-17 14:31:27.922 error sql.0 TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:42:49) at emitTwo (events.js:106:13) at Adapter.emit (eve sql.0 2017-02-17 14:31:27.920 error sql.0 uncaught exception: Cannot read property 'sql.0' of undefined hm-rega.0 2017-02-17 14:31:27.874 info hm-rega.0 deleted 0 programs hm-rega.0 2017-02-17 14:31:27.874 info hm-rega.0 added/updated 89 programs hm-rega.0 2017-02-17 14:31:27.553 info hm-rega.0 got 89 programs -
Ich kapiere es nicht …
Schau bitte mal auf der Platte in /opt/iobroker/node_modules/iobroker.sql/main.js in Zeile 42. Diese sollte mit dem Github Update so aussehen:
(obj.common.history && obj.common.history[adapter.namespace]) ||Wenn nein ändere Sie mal so, dann hast Du irgendwie doch das upfdate von Github nicht bekommen (was komisch wäre). Aber erstmal egal :-)
-
Hallo,
da steht:
38 var adapter = utils.adapter('sql'); 39 adapter.on('objectChange', function (id, obj) { 40 if (obj && obj.common && ( 41 // todo remove history sometime (2016.08) - Do not forget object selector in io-package.json 42 (obj.common.history && obj.common.history[adapter.namespace]) || 43 (obj.common.custom && obj.common.custom[adapter.namespace])) && 44 (obj.common.custom[adapter.namespace].enabled) 45 ) { 46 if (!sqlDPs[id] && !subscribeAll) { -
jetzt kapier ichs nimmer … versuch nochmal nicht das beim letzten update nicht neu gestartet war und deswegen noch das alte lief ... ;-)
ANsonsten kann ichs echt nicht mehr verstehen weil jetzt auch die Spaltennummer nicht mehr 49 sein kann ...
-
Hallo,
Neustart hat er heute Nacht automatisch gemacht.
Restart REGA-Adapter:
hm-rega.0 2017-02-18 10:57:05.154 info added/updated 66 variables hm-rega.0 2017-02-18 10:57:04.640 info got 66 variables zotac 2017-02-18 10:57:04.637 info host.zotac Restart adapter system.adapter.sql.0 because enabled zotac 2017-02-18 10:57:04.636 error host.zotac instance system.adapter.sql.0 terminated with code 6 (uncaught exception) sql.0 2017-02-18 10:57:03.650 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.650 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-18 10:57:03.650 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.650 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.650 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-18 10:57:03.650 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.650 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.650 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-18 10:57:03.650 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.649 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.649 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-18 10:57:03.648 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.648 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.647 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-18 10:57:03.647 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.647 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.647 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-18 10:57:03.646 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.646 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.646 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-18 10:57:03.644 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.644 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.644 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-18 10:57:03.644 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.644 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.644 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-18 10:57:03.643 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.643 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.643 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-18 10:57:03.643 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.643 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.643 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-18 10:57:03.643 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.643 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.643 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-18 10:57:03.642 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.344 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-18 10:57:03.318 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-18 10:57:03.316 error uncaught exception: Cannot read property 'sql.0' of undefined hm-rega.0 2017-02-18 10:57:03.278 info deleted 0 programs hm-rega.0 2017-02-18 10:57:03.278 info added/updated 89 programs hm-rega.0 2017-02-18 10:57:02.944 info got 89 programs hm-rega.0 2017-02-18 10:57:00.781 info added/updated rooms to enum.room -
Jetzt ists auch ne andere Zeilennummer :-)
Kannst Du mir einen gefallen tun (sonst muss ich weiter raten): Überleg mal welcher der hm-Datenpunkte die DU loggst der ist der am längsten loggt. Un bei den gehst DU in der "Objekte"-Ansicht auf den Stift rechts am Ende. Dort auf "Raw-Ansicht (Experten only)" und schick mir mal das JSON was Du da siehst. Dann sollte das simpel sein final zu fixen weil ich das Problem jetzt im Blick hab
-
{ "common": { "name": "HZ-01:4.ACTUAL_TEMPERATURE", "type": "number", "unit": "°C", "role": "value.temperature", "def": 0, "min": -10, "max": 56, "read": true, "write": false, "custom": { "history.0": { "enabled": true, "changesOnly": true, "minLength": 480, "maxLength": 960, "retention": 0, "debounce": 10000 }, "sql.0": { "enabled": true, "changesOnly": false, "debounce": 1000, "retention": 63072000 } } }, "native": { "CONTROL": "HEATING_CONTROL.TEMPERATURE", "ID": "ACTUAL_TEMPERATURE", "TYPE": "FLOAT", "UNIT": "�C", "DEFAULT": 0, "FLAGS": 1, "MAX": 56, "MIN": -10, "OPERATIONS": 5, "TAB_ORDER": 5 }, "acl": { "object": 1638, "owner": "system.user.admin", "ownerGroup": "system.group.administrator", "state": 1638 }, "_id": "hm-rpc.0.MEQ0008905.4.ACTUAL_TEMPERATURE", "type": "state" } -
Hallo,
welcher der wirklich älteste ist, weiss ich nicht, habe einen recht alten ausgewählt.
Mit neuer Version 1.4.5:
sql.0 2017-02-19 15:36:24.010 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:24.010 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:24.010 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:24.010 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:24.010 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:24.010 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:24.010 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:24.010 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:24.010 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:24.010 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:24.010 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:24.009 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:24.009 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:24.009 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:24.009 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:24.009 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:24.009 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:24.009 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:24.009 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:24.009 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:24.009 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.694 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.694 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:23.693 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.570 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.569 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:23.569 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.569 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.569 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:23.569 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.569 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.569 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:23.569 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.569 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.569 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:23.569 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.569 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.569 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:23.568 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.568 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.568 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:23.568 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.568 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.568 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:23.568 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.562 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.562 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:23.562 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.562 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.562 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:23.562 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.562 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.562 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:23.562 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.561 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.561 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:23.561 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.561 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.561 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:23.561 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.561 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.561 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:23.560 error uncaught exception: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.306 warn Exception: TypeError: Cannot read property 'sql.0' of undefined sql.0 2017-02-19 15:36:23.306 error TypeError: Cannot read property 'sql.0' of undefined at Adapter. (/opt/iobroker/node_modules/iobroker.sql/main.js:44:27) at emitTwo (events.js:106:13) at Adapter.emit (events.js sql.0 2017-02-19 15:36:23.305 error uncaught exception: Cannot read property 'sql.0' of undefined hm-rega.0 2017-02-19 15:36:23.278 info deleted 0 programs hm-rega.0 2017-02-19 15:36:23.278 info added/updated 89 programs hm-rega.0 2017-02-19 15:36:22.923 info got 89 programs hm-rega.0 2017-02-19 15:36:21.147 info added/updated rooms to enum.rooms hm-rega.0 2017-02-19 15:36:20.872 info added/updated functions to enum.functions hm-rega.0 2017-02-19 15:36:20.385 info added/updated 26 favorites to enum.favorites hm-rega.0 2017-02-19 15:36:20.077 info time difference local-ccu 0s hm-rega.0 2017-02-19 15:36:20.004 info ReGaHSS 192.168.1.11 up hm-rega.0 2017-02-19 15:36:18.934 info subscribe hm-rpc.0.BidCoS-RF.50.PRESS_SHORT hm-rega.0 2017-02-19 15:36:18.917 info starting. Version 1.4.3 in /opt/iobroker/node_modules/iobroker.hm-rega, node: v6.9.2 host.zotac 2017-02-19 15:36:17.848 info instance system.adapter.hm-rega.0 started with pid 397 host.zotac 2017-02-19 15:36:15.410 info instance system.adapter.hm-rega.0 terminated with code 0 (OK) hm-rega.0 2017-02-19 15:36:15.343 info terminating host.zotac 2017-02-19 15:36:15.287 info stopInstance system.adapter.hm-rega.0 killing pid 19130 host.zotac 2017-02-19 15:36:15.287 info stopInstance system.adapter.hm-rega.0 host.zotac 2017-02-19 15:36:15.284 info object change system.adapter.hm-rega.0 host.zotac 2017-02-19 15:34:42.429 info Update repository "default" under "conf/sources-dist.json" iobroker 2017-02-19 15:34:42.114 info exit 0 -
Also irgendwie hat Install von Github nicht geklappt oder restart hat gefehlt.Zeilennnummer des Fehlers passen wieder nicht zur neuen Version :-)
Ab Zeile 40 muss es so aussehen: https://github.com/ioBroker/ioBroker.sq … ain.js#L40
-
Hallo,
der sql-Adapter ist immer neu gestartet. Der Rest natürlich nicht.
Aber nach Neustart heute Nacht kommt folgendes:
admin.0 2017-02-20 11:53:06.174 info received all states admin.0 2017-02-20 11:53:05.196 info Subscribe on all states again admin.0 2017-02-20 11:52:33.385 info Unsubscribe from all states, except system's, because over 3 seconds the number of events is over 200 (in last second 0) hm-rega.0 2017-02-20 11:52:30.021 info got state values hm-rega.0 2017-02-20 11:52:25.223 info request state values hm-rega.0 2017-02-20 11:52:25.221 info deleted 0 variables hm-rega.0 2017-02-20 11:52:25.220 info added/updated 66 variables hm-rega.0 2017-02-20 11:52:24.707 info got 66 variables hm-rega.0 2017-02-20 11:52:23.758 info deleted 0 programs hm-rega.0 2017-02-20 11:52:23.757 info added/updated 89 programs hm-rega.0 2017-02-20 11:52:23.430 info got 89 programs hm-rega.0 2017-02-20 11:52:22.050 info added/updated rooms to enum.rooms hm-rega.0 2017-02-20 11:52:21.348 info added/updated functions to enum.functions hm-rega.0 2017-02-20 11:52:20.867 info added/updated 26 favorites to enum.favorites hm-rega.0 2017-02-20 11:52:20.517 info time difference local-ccu 1s hm-rega.0 2017-02-20 11:52:20.439 info ReGaHSS 192.168.1.11 up hm-rega.0 2017-02-20 11:52:19.394 info subscribe hm-rpc.0.BidCoS-RF.50.PRESS_SHORT hm-rega.0 2017-02-20 11:52:19.377 info starting. Version 1.4.3 in /opt/iobroker/node_modules/iobroker.hm-rega, node: v6.9.2 host.zotac 2017-02-20 11:52:18.155 info instance system.adapter.hm-rega.0 started with pid 31795 host.zotac 2017-02-20 11:52:15.724 info instance system.adapter.hm-rega.0 terminated with code 0 (OK) hm-rega.0 2017-02-20 11:52:15.652 info terminating host.zotac 2017-02-20 11:52:15.607 info stopInstance system.adapter.hm-rega.0 killing pid 21557 host.zotac 2017-02-20 11:52:15.605 info stopInstance system.adapter.hm-rega.0 host.zotac 2017-02-20 11:52:15.598 info object change system.adapter.hm-rega.0 host.zotac 2017-02-20 11:46:03.026 info instance system.adapter.tankerkoenig.0 terminated with code 0 (OK)
Support us
741
Online32.5k
Benutzer81.7k
Themen1.3m
Beiträge