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 -
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?
-
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)
-
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.
-
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" } -
Der kanns nicht sein … aber naja ... versuch mal neu mit der github version ... und nach install (ist dann die 1.4.5) neu startenvom sql Adapter und dann versuch nochmal
-
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) -
Ja das sieht doch dann nach "kein Fehler mehr "aus, oder ?! :-)))
