Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Deutsch
    3. Error/Bug
    4. SQL Instanz geht nicht mehr (update von node/npm)

    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

    SOLVED SQL Instanz geht nicht mehr (update von node/npm)

    This topic has been deleted. Only users with topic management privileges can see it.
    • bahnuhr
      bahnuhr Forum Testing Most Active last edited by

      Hallo,
      habe node und npm upgedatet. (win7 laptop)
      Im Info steht jetzt auch:
      2cad0cf9-7b6e-4f71-8536-37a6fcda168a-image.png

      Nun läuft aber sql nicht mehr.
      Habe die Instanz deinstalliert; den Adapter über git neu installiert und dann die Instanz neu installiert.
      Instanz wird auch grün.

      Bei Abruf einer flot kommt dann im log:

      host.Asus-Buero	2019-12-28 10:02:02.595	error	instance system.adapter.sql.0 terminated with code 0 (OK)
      host.Asus-Buero	2019-12-28 10:02:02.595	error	Caught by controller[0]: at clientPool.borrow (C:\ioBroker\node_modules\iobroker.sql\main.js:1530:16) __augmented: true }
      host.Asus-Buero	2019-12-28 10:02:02.595	error	Caught by controller[0]: at SQLClient.execute (C:\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\sql-client.js:4:59)
      host.Asus-Buero	2019-12-28 10:02:02.595	error	Caught by controller[0]: at SQLClient.execute (C:\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\sql-client.js:87:29)
      host.Asus-Buero	2019-12-28 10:02:02.595	error	Caught by controller[0]: at SQLite3ConnectionFactory.pre_process_sql (C:\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\connection-factory.js:4:59)
      host.Asus-Buero	2019-12-28 10:02:02.595	error	Caught by controller[0]: at SQLite3ConnectionFactory.ConnectionFactory.pre_process_sql (C:\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\connection-factory.js:42:14)
      host.Asus-Buero	2019-12-28 10:02:02.595	error	Caught by controller[0]: at C:\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\sql-client.js:95:36
      host.Asus-Buero	2019-12-28 10:02:02.595	error	Caught by controller[0]: at SQLite3ConnectionFactory.execute (C:\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\connection-factory.js:4:59)
      host.Asus-Buero	2019-12-28 10:02:02.595	error	Caught by controller[0]: at SQLite3ConnectionFactory.<anonymous> (C:\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\sqlite3-client.js:4:59)
      host.Asus-Buero	2019-12-28 10:02:02.595	error	Caught by controller[0]: at SQLite3ConnectionFactory.execute (C:\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\lib\sqlite3-client.js:63:17)
      host.Asus-Buero	2019-12-28 10:02:02.595	error	Caught by controller[0]: --> in Database#all('SELECT ts, val FROM ts_number WHERE ts_number.id=19 AND ts_number.ts < 1577523721735 AND ts_number.ts >= 1577437321735 UNION SELECT * from ( SELECT ts, v
      host.Asus-Buero	2019-12-28 10:02:02.595	error	Caught by controller[0]: at Statement.client.execute (C:\ioBroker\node_modules\iobroker.sql\main.js:1568:27)
      host.Asus-Buero	2019-12-28 10:02:02.595	error	Caught by controller[0]: at _getDataFromDB (C:\ioBroker\node_modules\iobroker.sql\main.js:1356:49)
      host.Asus-Buero	2019-12-28 10:02:02.595	error	Caught by controller[0]: at Object.getDataFromDB [as callback] (C:\ioBroker\node_modules\iobroker.sql\main.js:1669:21)
      host.Asus-Buero	2019-12-28 10:02:02.594	error	Caught by controller[0]: at Object.sendResponse (C:\ioBroker\node_modules\iobroker.sql\lib\aggregate.js:454:29)
      host.Asus-Buero	2019-12-28 10:02:02.594	error	Caught by controller[0]: at aggregation (C:\ioBroker\node_modules\iobroker.sql\lib\aggregate.js:43:41)
      host.Asus-Buero	2019-12-28 10:02:02.593	error	Caught by controller[0]: { TypeError: Assignment to constant variable.
      sql.0	2019-12-28 10:02:02.146	error	TypeError: Assignment to constant variable. at aggregation (C:\ioBroker\node_modules\iobroker.sql\lib\aggregate.js:43:41) at Object.sendResponse (C:\ioBroker\node_modules\iobroker.sql\lib\aggr
      sql.0	2019-12-28 10:02:02.146	error	uncaught exception: Assignment to constant variable.
      sql.0	2019-12-28 10:02:02.145	warn	Exception: TypeError: Assignment to constant variable.
      

      Was hab ich jetzt wieder gemacht ?!
      Oder anders; was ist da schief gelaufen.
      Gebt mir mal einen Tipp.

      mfg

      1 Reply Last reply Reply Quote 0
      • bahnuhr
        bahnuhr Forum Testing Most Active last edited by

        So,
        bei dem update der sql auf 1.10.0 ist wohl etwas schief gelaufen (oder 1.10.0 funktioniert noch nicht ;-))

        Bin jetzt wieder auf sql 1.9.4.
        Und meine flot funktionieren wieder.

        mfg

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

        Support us

        ioBroker
        Community Adapters
        Donate

        455
        Online

        31.9k
        Users

        80.1k
        Topics

        1.3m
        Posts

        problem sql
        1
        2
        109
        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