Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. Error/Bug
    4. Fehler bei SQL 1.4.2

    NEWS

    • Neuer Blog: Fotos und Eindrücke aus Solingen

    • ioBroker@Smart Living Forum Solingen, 14.06. - Agenda added

    • ioBroker goes Matter ... Matter Adapter in Stable

    Fehler bei SQL 1.4.2

    This topic has been deleted. Only users with topic management privileges can see it.
    • apollon77
      apollon77 last edited by

      Und der js-controller muss >=0.12.0 sein. Was hast Du?

      Was kommt denn als Mouseover wenn DU über das graue Icon gehst?

      1 Reply Last reply Reply Quote 0
      • sissiwup
        sissiwup last edited by

        @apollon77:

        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
        
        1 Reply Last reply Reply Quote 0
        • apollon77
          apollon77 last edited by

          Hast Du normal aktualisiert oder vom github aktualisiert? Musst von Githuvb holen weil erstmal nur da der Fehler gefixt ist (zum testen)

          1 Reply Last reply Reply Quote 0
          • sissiwup
            sissiwup last edited by

            @apollon77:

            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
            
            1 Reply Last reply Reply Quote 0
            • apollon77
              apollon77 last edited by

              Admin brauchst DU an sich nicht vom Github. Der Bugfix von mir war in sql drin.

              1 Reply Last reply Reply Quote 0
              • sissiwup
                sissiwup last edited by

                @apollon77:

                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
                
                1 Reply Last reply Reply Quote 0
                • apollon77
                  apollon77 last edited by

                  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 🙂

                  1 Reply Last reply Reply Quote 0
                  • sissiwup
                    sissiwup last edited by

                    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) {
                    
                    
                    1 Reply Last reply Reply Quote 0
                    • apollon77
                      apollon77 last edited by

                      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 ...

                      1 Reply Last reply Reply Quote 0
                      • sissiwup
                        sissiwup last edited by

                        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
                        
                        1 Reply Last reply Reply Quote 0
                        • apollon77
                          apollon77 last edited by

                          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

                          1 Reply Last reply Reply Quote 0
                          • sissiwup
                            sissiwup last edited by

                            {
                              "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"
                            }
                            
                            1 Reply Last reply Reply Quote 0
                            • apollon77
                              apollon77 last edited by

                              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

                              1 Reply Last reply Reply Quote 0
                              • sissiwup
                                sissiwup last edited by

                                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
                                
                                1 Reply Last reply Reply Quote 0
                                • apollon77
                                  apollon77 last edited by

                                  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

                                  1 Reply Last reply Reply Quote 0
                                  • sissiwup
                                    sissiwup last edited by

                                    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)
                                    
                                    1 Reply Last reply Reply Quote 0
                                    • apollon77
                                      apollon77 last edited by

                                      Ja das sieht doch dann nach "kein Fehler mehr "aus, oder ?! :-)))

                                      1 Reply Last reply Reply Quote 0
                                      • First post
                                        Last post

                                      Support us

                                      ioBroker
                                      Community Adapters
                                      Donate

                                      786
                                      Online

                                      31.8k
                                      Users

                                      80.0k
                                      Topics

                                      1.3m
                                      Posts

                                      2
                                      20
                                      1759
                                      Loading More Posts
                                      • Oldest to Newest
                                      • Newest to Oldest
                                      • Most Votes
                                      Reply
                                      • Reply as topic
                                      Log in to reply
                                      Community
                                      Impressum | Datenschutz-Bestimmungen | Nutzungsbedingungen
                                      The ioBroker Community 2014-2023
                                      logo