Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. Error/Bug
    4. "Verbunden mit influxdb" Falsch -> Keine Werte in Datenbank

    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

    "Verbunden mit influxdb" Falsch -> Keine Werte in Datenbank

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

      @apollon77:

      Admin und js-controller sind aktuell? `
      ioBroker Admin: 1.6.11

      js-controller: 0.15.3
      @apollon77:

      Was steht denn im "connected" Datenpunkt vom Adapter/Instanz? `
      Nichts…!? Siehe Bild
      1408_clipboard01.jpg

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

        Ich blick es genauso wenig wie bei Homoran … Bitte update vom Github. Jetzt gibts error-logging wenn "connected" nicht aktualisiert werden kann. Mal schauen ob das mehr Infos bringt.

        1 Reply Last reply Reply Quote 0
        • E
          eastcoast last edited by

          @apollon77:

          Ich blick es genauso wenig wie bei Homoran … Bitte update vom Github. Jetzt gibts error-logging wenn "connected" nicht aktualisiert werden kann. Mal schauen ob das mehr Infos bringt. `
          Hallo,

          installiert via console mit "npm install https://github.com/ioBroker/ioBroker.influxdb.git" und hier der Log:

          influxdb.0	2017-03-06 18:53:13.083	debug	influxdb.0 Datatype javascript.0.froniusSymo.meter.PowerReal_P_Sum: Currently: number, StorageType: false
          influxdb.0	2017-03-06 18:53:13.083	debug	influxdb.0 Datatype javascript.0.froniusSymo.inverter.DAY_ENERGY: Currently: number, StorageType: false
          influxdb.0	2017-03-06 18:53:13.074	debug	influxdb.0 Datatype javascript.0.froniusSymo.inverter.PAC: Currently: number, StorageType: false
          influxdb.0	2017-03-06 18:53:03.064	debug	inMem message javascript.0.froniusSymo.meter.PowerReal_P_Sum javascript.0.froniusSymo.meter.PowerReal_P_Sum
          influxdb.0	2017-03-06 18:53:03.056	debug	inMem message javascript.0.froniusSymo.inverter.DAY_ENERGY javascript.0.froniusSymo.inverter.DAY_ENERGY
          influxdb.0	2017-03-06 18:53:03.021	debug	inMem message javascript.0.froniusSymo.inverter.PAC javascript.0.froniusSymo.inverter.PAC
          influxdb.0	2017-03-06 18:52:34.215	info	enabled logging of javascript.0.froniusSymo.history.energyProdDay, 6 points now activated
          influxdb.0	2017-03-06 18:52:34.215	info	enabled logging of javascript.0.froniusSymo.history.energyRetDay, 5 points now activated
          influxdb.0	2017-03-06 18:52:34.214	info	enabled logging of javascript.0.froniusSymo.history.energyConsDay, 4 points now activated
          influxdb.0	2017-03-06 18:52:34.214	info	enabled logging of javascript.0.froniusSymo.meter.PowerReal_P_Sum, 3 points now activated
          influxdb.0	2017-03-06 18:52:34.213	info	enabled logging of javascript.0.froniusSymo.inverter.DAY_ENERGY, 2 points now activated
          influxdb.0	2017-03-06 18:52:34.209	info	enabled logging of javascript.0.froniusSymo.inverter.PAC, 1 points now activated
          influxdb.0	2017-03-06 18:52:34.175	info	Connected!
          influxdb.0	2017-03-06 18:52:34.025	info	Connecting http://localhost:8086 ...
          influxdb.0	2017-03-06 18:52:34.021	info	Buffer initialized with data for 0 points and 0 conflicts from last exit
          influxdb.0	2017-03-06 18:52:34.014	info	starting. Version 1.4.0 in /opt/iobroker/node_modules/iobroker.influxdb, node: v4.8.0
          influxdb.0	2017-03-06 18:52:33.969	debug	statesDB connected
          influxdb.0	2017-03-06 18:52:33.889	debug	objectDB connected
          host.xxxx-iobroker	2017-03-06 18:52:32.034	info	instance system.adapter.influxdb.0 started with pid 13381
          
          
          1 Reply Last reply Reply Quote 0
          • apollon77
            apollon77 last edited by

            Kooooomisch …

            Bitte nochmal und "iobroker upload influxdb" nicht vergessen!! Habe jetzt auch Success-Logging eingebaut 🙂

            1 Reply Last reply Reply Quote 0
            • Homoran
              Homoran Global Moderator Administrators last edited by

              der fast erste Satz ist "connected"

              dann finde ich nur noch Datenaktualisierungen und sonst nichts.

              Unter Objekte nach wie vor keine Angabe ob connected = true oder false

              Gibt es etwas wonach man das log filtern kann?

              Gruß

              Rainer

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

                also basierend auf "debug"-level hatte ich das eingebaut

                adapter.log.debug('connected set to ' + connected);

                also es sollte etwas kommen wie "connected set to true". Aber halt als Debug.

                https://github.com/ioBroker/ioBroker.in … in.js#L123

                Kannst es lokal auch einfach in info ändern oder so

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

                  Kann das nochmal einer machen/checken bitte?!

                  1 Reply Last reply Reply Quote 0
                  • Homoran
                    Homoran Global Moderator Administrators last edited by

                    @apollon77:

                    Kann das nochmal einer machen/checken bitte?! `
                    Was willst du sehen?

                    Mein log von heute ist inzwischen 188MB groß, da muss ich schon wissen wonach ich suchen kann.

                    Habe nochmal aus dem git upgedated und upgeloaded 😉

                    Auf Anhieb finde ich jetzt:

                    `2017-03-07 18:02:59.020  - [32minfo[39m: host.ioBroker_Pine64 object change system.adapter.influxdb.0
                    2017-03-07 18:02:59.022  - [32minfo[39m: host.ioBroker_Pine64 "system.adapter.influxdb.0" enabled
                    2017-03-07 18:02:59.022  - [32minfo[39m: host.ioBroker_Pine64 stopInstance system.adapter.influxdb.0
                    2017-03-07 18:02:59.023  - [32minfo[39m: host.ioBroker_Pine64 stopInstance system.adapter.influxdb.0 killing pid 1350
                    2017-03-07 18:02:59.219  - [33mwarn[39m: host.ioBroker_Pine64 instance system.adapter.influxdb.0 terminated due to SIGTERM
                    2017-03-07 18:02:59.220  - [32minfo[39m: host.ioBroker_Pine64 instance system.adapter.influxdb.0 terminated with code null ()
                    2017-03-07 18:03:01.558  - [32minfo[39m: host.ioBroker_Pine64 instance system.adapter.influxdb.0 started with pid 1392
                    2017-03-07 18:03:02.597  - [32minfo[39m: host.ioBroker_Pine64 instance system.adapter.rflink.0 started with pid 1398
                    2017-03-07 18:03:04.024  - [32minfo[39m: solarwetter.0 force terminating adapter after 1 minute
                    2017-03-07 18:03:04.593  - [32minfo[39m: host.ioBroker_Pine64 instance system.adapter.solarwetter.0 terminated with code 0 (OK)
                    2017-03-07 18:03:05.741  - [32minfo[39m: host. States connected to redis 127.0.0.1:6379
                    2017-03-07 18:03:05.860  - [32minfo[39m: rflink.0 starting. Version 1.0.8 in /opt/iobroker/node_modules/iobroker.rflink, node: v4.6.1
                    2017-03-07 18:03:05.830  - [34mdebug[39m: influxdb.0 objectDB connected
                    2017-03-07 18:03:05.917  - [34mdebug[39m: influxdb.0 statesDB connected
                    2017-03-07 18:03:05.948  - [32minfo[39m: host. States connected to redis 127.0.0.1:6379
                    2017-03-07 18:03:05.983  - [34mdebug[39m: host. redis get system.adapter.influxdb.0.alive ok: {"val":false,"ack":true,"ts":1488906179221,"q":0,"from":"system.host.ioBroker_Pine64","lc":1488906179221}
                    2017-03-07 18:03:06.079  - [32minfo[39m: influxdb.0 starting. Version 1.4.0 in /opt/iobroker/node_modules/iobroker.influxdb, node: v4.6.1
                    2017-03-07 18:03:06.086  - [32minfo[39m: vis.0 400 files uploaded...
                    2017-03-07 18:03:06.191  - [32minfo[39m: rflink.0 Serial port opened
                    2017-03-07 18:03:06.116  - [32minfo[39m: influxdb.0 No stored data from last exit found
                    2017-03-07 18:03:06.126  - [32minfo[39m: influxdb.0 Connecting http://localhost:8086 ...
                    2017-03-07 18:03:06.202  - [34mdebug[39m: host. redis psubscribe io.influxdb.0.checkLogging
                    2017-03-07 18:03:06.241  - [34mdebug[39m: host. redis keys 1 *.logging[/code]`
                    
                    Die Ampel ist gelb, unter influxdb.0.info.connection steht immer noch nichts
                    
                    EDIT:
                    
                    das noch gefunden:
                    `~~[code]~~2017-03-07 17:59:43.956  - [32minfo[39m: iobroker got /opt/iobroker/node_modules/iobroker.influxdb/admin
                    2017-03-07 17:59:43.986  - [32minfo[39m: iobroker upload [2] influxdb.admin /opt/iobroker/node_modules/iobroker.influxdb/admin/influxdb.png influxdb.png image/png
                    2017-03-07 17:59:44.124  - [32minfo[39m: iobroker upload [1] influxdb.admin /opt/iobroker/node_modules/iobroker.influxdb/admin/index.html index.html text/html
                    2017-03-07 17:59:44.224  - [32minfo[39m: iobroker upload [0] influxdb.admin /opt/iobroker/node_modules/iobroker.influxdb/admin/custom.html custom.html text/html
                    2017-03-07 17:59:44.305  - [34mdebug[39m: host. redis pmessage  io.* io.system.adapter.influxdb.upload {"val":0,"ack":false,"ts":1488905984302,"q":0,"lc":1480363337473}
                    2017-03-07 17:59:44.412  - [32minfo[39m: host.ioBroker_Pine64 object change system.adapter.influxdb.0
                    2017-03-07 17:59:44.439  - [33mwarn[39m: influxdb.0 Store data for 0 points and 0 conflicts
                    2017-03-07 17:59:44.444  - [34mdebug[39m: host. redis publish io.system.adapter.influxdb.0.alive {"val":false,"ack":true,"ts":1488905984444,"q":0,"from":"system.adapter.influxdb.0","lc":1488905984444}
                    2017-03-07 17:59:44.413  - [32minfo[39m: host.ioBroker_Pine64 "system.adapter.influxdb.0" disabled
                    2017-03-07 17:59:44.416  - [32minfo[39m: host.ioBroker_Pine64 stopInstance system.adapter.influxdb.0
                    2017-03-07 17:59:44.417  - [32minfo[39m: host.ioBroker_Pine64 stopInstance system.adapter.influxdb.0 killing pid 12189
                    2017-03-07 17:59:44.456  - [32minfo[39m: influxdb.0 terminating
                    2017-03-07 17:59:44.492  - [32minfo[39m: host.ioBroker_Pine64 object change system.adapter.influxdb.0
                    2017-03-07 17:59:44.494  - [32minfo[39m: host.ioBroker_Pine64 "system.adapter.influxdb.0" enabled
                    2017-03-07 17:59:44.539  - [32minfo[39m: host.ioBroker_Pine64 instance system.adapter.influxdb.0 started with pid 23258
                    2017-03-07 17:59:44.602  - [32minfo[39m: host.ioBroker_Pine64 instance system.adapter.influxdb.0 terminated with code 0 (OK)
                    2017-03-07 17:59:44.623  - [32minfo[39m: iobroker Adapter "system.adapter.influxdb.0" restarted.
                    2017-03-07 17:59:44.643  - [32minfo[39m: iobroker exit 0
                    2017-03-07 17:59:45.061  - [32minfo[39m: host.ioBroker_Pine64 Update repository "default" under "http://download.iobroker.net/sources-dist.json"
                    2017-03-07 17:59:47.801  - [34mdebug[39m: influxdb.0 objectDB connected
                    2017-03-07 17:59:47.867  - [34mdebug[39m: influxdb.0 statesDB connected
                    2017-03-07 17:59:47.882  - [32minfo[39m: host. States connected to redis 127.0.0.1:6379
                    2017-03-07 17:59:47.906  - [34mdebug[39m: host. redis get system.adapter.influxdb.0.alive ok: {"val":false,"ack":true,"ts":1488905984628,"q":0,"from":"system.host.ioBroker_Pine64","lc":1488905984444}
                    2017-03-07 17:59:47.966  - [32minfo[39m: influxdb.0 starting. Version 1.4.0 in /opt/iobroker/node_modules/iobroker.influxdb, node: v4.6.1
                    2017-03-07 17:59:47.982  - [32minfo[39m: influxdb.0 Buffer initialized with data for 0 points and 0 conflicts from last exit
                    2017-03-07 17:59:47.989  - [32minfo[39m: influxdb.0 Connecting http://localhost:8086 ...
                    2017-03-07 17:59:48.034  - [34mdebug[39m: host. redis psubscribe io.influxdb.0.checkLogging
                    2017-03-07 17:59:48.062  - [34mdebug[39m: host. redis keys 1 *.logging
                    2017-03-07 17:59:48.066  - [34mdebug[39m: host. redis publish io.system.adapter.influxdb.0.alive {"val":true,"ack":true,"ts":1488905988066,"q":0,"from":"system.adapter.influxdb.0","lc":1488905988066}
                    2017-03-07 17:59:48.072  - [34mdebug[39m: host. redis publish io.system.adapter.influxdb.0.connected {"val":true,"ack":true,"ts":1488905988068,"q":0,"from":"system.adapter.influxdb.0","lc":1488905988068}
                    2017-03-07 17:59:48.075  - [34mdebug[39m: host. redis publish io.system.adapter.influxdb.0.memRss {"val":41.66,"ack":true,"ts":1488905988074,"q":0,"from":"system.adapter.influxdb.0","lc":1488905988074}
                    2017-03-07 17:59:48.079  - [34mdebug[39m: host. redis publish io.system.adapter.influxdb.0.memHeapTotal {"val":36.73,"ack":true,"ts":1488905988078,"q":0,"from":"system.adapter.influxdb.0","lc":1488905988078}
                    2017-03-07 17:59:48.083  - [34mdebug[39m: host. redis publish io.system.adapter.influxdb.0.memHeapUsed {"val":25.55,"ack":true,"ts":1488905988082,"q":0,"from":"system.adapter.influxdb.0","lc":1488905988082}
                    2017-03-07 17:59:48.088  - [34mdebug[39m: host. redis publish io.system.adapter.influxdb.0.uptime {"val":3,"ack":true,"ts":1488905988087,"q":0,"from":"system.adapter.influxdb.0","lc":1488905988087}
                    2017-03-07 17:59:48.093  - [34mdebug[39m: host. redis publish io.influxdb.0.info.connected {"val":false,"ack":true,"ts":1488905988093,"q":0,"from":"system.adapter.influxdb.0","lc":1488905988093}
                    2017-03-07 17:59:48.108  - [34mdebug[39m: host. redis mget 1 1
                    2017-03-07 17:59:48.113  - [34mdebug[39m: influxdb.0 connected set to false
                    2017-03-07 17:59:48.171  - [32minfo[39m: influxdb.0 Connected!
                    2017-03-07 17:59:48.172  - [34mdebug[39m: host. redis publish io.influxdb.0.info.connected {"val":true,"ack":true,"ts":1488905988172,"q":0,"from":"system.adapter.influxdb.0","lc":1488905988172}
                    2017-03-07 17:59:48.178  - [34mdebug[39m: influxdb.0 connected set to true[/code]`
                    
                    Gruß
                    
                    Rainer[/code]
                    
                    1 Reply Last reply Reply Quote 0
                    • E
                      eastcoast last edited by

                      @apollon77:

                      Kann das nochmal einer machen/checken bitte?! `
                      Hallo,

                      habe gerade nochmal von github aktualisiert…

                      Status ist noch gelb, Objekt influxdb.0.info.connection hat keinen Wert, hier der Log:

                      influxdb.0	2017-03-07 18:42:12.333	debug	influxdb.0 Datatype javascript.0.froniusSymo.meter.PowerReal_P_Sum: Currently: number, StorageType: false
                      influxdb.0	2017-03-07 18:42:12.274	debug	influxdb.0 Datatype javascript.0.froniusSymo.inverter.DAY_ENERGY: Currently: number, StorageType: false
                      influxdb.0	2017-03-07 18:42:12.271	debug	influxdb.0 Datatype javascript.0.froniusSymo.inverter.PAC: Currently: number, StorageType: false
                      influxdb.0	2017-03-07 18:42:02.329	debug	inMem message javascript.0.froniusSymo.meter.PowerReal_P_Sum javascript.0.froniusSymo.meter.PowerReal_P_Sum
                      influxdb.0	2017-03-07 18:42:02.250	debug	inMem message javascript.0.froniusSymo.inverter.DAY_ENERGY javascript.0.froniusSymo.inverter.DAY_ENERGY
                      influxdb.0	2017-03-07 18:42:02.243	debug	inMem message javascript.0.froniusSymo.inverter.PAC javascript.0.froniusSymo.inverter.PAC
                      influxdb.0	2017-03-07 18:41:04.279	info	enabled logging of javascript.0.froniusSymo.history.energyProdDay, 6 points now activated
                      influxdb.0	2017-03-07 18:41:04.279	info	enabled logging of javascript.0.froniusSymo.history.energyRetDay, 5 points now activated
                      influxdb.0	2017-03-07 18:41:04.279	info	enabled logging of javascript.0.froniusSymo.history.energyConsDay, 4 points now activated
                      influxdb.0	2017-03-07 18:41:04.279	info	enabled logging of javascript.0.froniusSymo.meter.PowerReal_P_Sum, 3 points now activated
                      influxdb.0	2017-03-07 18:41:04.278	info	enabled logging of javascript.0.froniusSymo.inverter.DAY_ENERGY, 2 points now activated
                      influxdb.0	2017-03-07 18:41:04.278	info	enabled logging of javascript.0.froniusSymo.inverter.PAC, 1 points now activated
                      influxdb.0	2017-03-07 18:41:04.266	debug	connected set to true
                      influxdb.0	2017-03-07 18:41:04.257	info	Connected!
                      influxdb.0	2017-03-07 18:41:04.160	debug	connected set to false
                      influxdb.0	2017-03-07 18:41:04.071	info	Connecting http://localhost:8086 ...
                      influxdb.0	2017-03-07 18:41:04.069	info	Buffer initialized with data for 0 points and 0 conflicts from last exit
                      influxdb.0	2017-03-07 18:41:04.065	info	starting. Version 1.4.0 in /opt/iobroker/node_modules/iobroker.influxdb, node: v4.8.0
                      influxdb.0	2017-03-07 18:41:04.015	debug	statesDB connected
                      influxdb.0	2017-03-07 18:41:03.952	debug	objectDB connected
                      
                      
                      1 Reply Last reply Reply Quote 0
                      • apollon77
                        apollon77 last edited by

                        ` > 2017-03-07 17:59:48.171 - [32minfo[39m: influxdb.0 Connected!

                        2017-03-07 17:59:48.172 - [34mdebug[39m: host. redis publish io.influxdb.0.info.connected {"val":true,"ack":true,"ts":1488905988172,"q":0,"from":"system.adapter.influxdb.0","lc":1488905988172}

                        2017-03-07 17:59:48.178 - [34mdebug[39m: influxdb.0 connected set to true `

                        Also das hier sagt (und das andere Log ist bis auf die redis-Debug-Logs identisch) hier eindeutig das das setzen des Wertes klappt…

                        Also die Frage ist damit für mich eher: Warum wird es im Admin nicht angezeigt ...? Kann es sein das Ihr irgendwie in die "Anzahl der Meldungten und daher "Unsubscribe im Admin" reingerannt seid?

                        @Homoran: Schalt dorhc für den Datenpunkt mal History ein und schaue nach ein paa ein/aus-Sachen (also Adapte restarts oder so) was History sagt 🙂

                        Und kannst Debug wieder ausschalten. `

                        1 Reply Last reply Reply Quote 0
                        • E
                          eastcoast last edited by

                          @apollon77:

                          Also die Frage ist damit für mich eher: Warum wird es im Admin nicht angezeigt …? Kann es sein das Ihr irgendwie in die "Anzahl der Meldungten und daher "Unsubscribe im Admin" reingerannt seid? `
                          Keine Ahnung wie ich einen "Unsubscribe im Admin" feststellen kann,

                          aber die Anzahl neuer Meldungen im Log ist Minimal…
                          @apollon77:

                          @Homoran: Schalt dorhc für den Datenpunkt mal History ein und schaue nach ein paa ein/aus-Sachen (also Adapte restarts oder so) was History sagt 🙂 `
                          Ich hab das mal gemacht, aber es gibt einfach keine Werte…

                          in der Historie Tabelle steht dann nur "No data", hier der Log von History (SQL)

                          sql.0	2017-03-10 14:43:05.709	info	No Data
                          sql.0	2017-03-10 14:43:05.709	warn	Cannot get index of "influxdb.0.info.connection": id not found
                          
                          

                          Bin mitlerweile auf

                          js-controller 0.16.2

                          admin 1.7.0

                          …damit hat sich nichts geändert.

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

                            So, ich habs … wer lesen kann ist arg im Vorteil ...

                            connected != connection ... Der Adapter hat schlicht den Status in den falschen State geschrieben und ich habs nicht gesehn :-((

                            Bitte version von Github versuchen. Passts damit?

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

                            Support us

                            ioBroker
                            Community Adapters
                            Donate

                            820
                            Online

                            31.8k
                            Users

                            80.0k
                            Topics

                            1.3m
                            Posts

                            4
                            22
                            5748
                            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