NEWS
SOLVED SQL Instanz geht nicht mehr (update von node/npm)
-
Hallo,
habe node und npm upgedatet. (win7 laptop)
Im Info steht jetzt auch:
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
-
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