Neuer ioBroker-Blog online: Monatsrückblick März/April 2026

[bahnuhr]

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

[bahnuhr]

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