Ошибки драйвера SQL

ford7

Тоже начали выскакивать ошибки:

! ````
sql-0 2016-02-29 09:11:00 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1456722654000, 88, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
host-zvmubn 2016-02-29 04:26:11 info Delete log file iobroker.log.2016-02-22
sql-0 2016-02-29 03:29:58 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1456702197000, 88, 1, 1, 0);: Error: SQLITE_BUSY: database is locked

[256_sql3.jpg](/assets/uploads/files/256_sql3.jpg)

spectrekr

Аналогично, сегодня посыпались.

! sql-0 2016-02-29 12:24:52 error Cannot insert INSERT INTO iobroker.ts_number (id, ts, val, ack, _from, q) VALUES(7, 1456737892000, 771, 1, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '7-1456737892000' for key 'PRIMARY'
! sql-0 2016-02-29 12:24:52 error Cannot insert INSERT INTO iobroker.ts_number (id, ts, val, ack, _from, q) VALUES(6, 1456737892000, 19.33, 1, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '6-1456737892000' for key 'PRIMARY'
! sql-0 2016-02-29 12:24:52 error Cannot insert INSERT INTO iobroker.ts_number (id, ts, val, ack, _from, q) VALUES(5, 1456737892000, 34.67, 1, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '5-1456737892000' for key 'PRIMARY'
! sql-0 2016-02-29 12:24:52 error Cannot insert INSERT INTO iobroker.ts_number (id, ts, val, ack, _from, q) VALUES(4, 1456737892000, 49.94, 1, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '4-1456737892000' for key 'PRIMARY'
! sql-0 2016-02-29 12:24:52 error Cannot insert INSERT INTO iobroker.ts_number (id, ts, val, ack, _from, q) VALUES(3, 1456737892000, 31, 1, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '3-1456737892000' for key 'PRIMARY'
! sql-0 2016-02-29 12:24:52 error Cannot insert INSERT INTO iobroker.ts_number (id, ts, val, ack, _from, q) VALUES(2, 1456737892000, 0.58, 1, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '2-1456737892000' for key 'PRIMARY'

Bluefox

SQL типов 4 штуки. Пожалуйста конкретизируйте.

spectrekr

В моем случае это MySQL

Haus

SQL Hystory 0.1.2 MySQL

RDim

Подключен к удаленному серверу MySQL 5.5.47 на debian 7.9, cubieboard.

ioBroker на debian 8.3 , cubietruck.

Полет отличный, ошибок MySQL не замечено.

spectrekr

Странно, но со вчерашнего утра больше ни одной ошибки не выскочило.

ford7

У меня не перестает.

sql-0	2016-05-12 11:20:26	error	Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463037621000, 38.38, 1, 1, 0);: Error: SQLITE_BUSY: database is locked

P. s. SQLite3

electric

~~@ford7:~~

У меня не перестает.
sql-0	2016-05-12 11:20:26	error	Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463037621000, 38.38, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
P. s. SQLite3 `
Подтверждаю, у меня тоже сыплет ошибки. Настройки по-умолчанию (SQLite3).

Система Linux Debian, БД находится здесь````
/opt/iobroker/iobroker-data/sqlite/sqlite.db

Пробовал играться с настройками минимального интервала (ms), все равно ошибки выскакивают.

sql-0 2016-05-16 22:02:20 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425330000, 25.41, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 22:01:50 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(4, 1463425300000, 46.26, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 22:01:35 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425285000, 25.36, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 22:01:05 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425255000, 25.35, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 22:00:50 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425240000, 25.34, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 22:00:35 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425225000, 25.29, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 22:00:20 warn Cannot get index of "system.host.vm32test.memHeapTotal": Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 22:00:20 error Cannot select SELECT id, type FROM datapoints WHERE name='system.host.vm32test.memHeapTotal';: Error: SQLITE_BUSY: database is locked
host-vm32test 2016-05-16 21:55:21 info instance system.adapter.sql.0 terminated with code 0 (OK)
sql-0 2016-05-16 21:59:50 warn Cannot get index of "system.host.vm32test.memHeapTotal": Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:59:50 error Cannot select SELECT id, type FROM datapoints WHERE name='system.host.vm32test.memHeapTotal';: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:59:35 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(4, 1463425165000, 46.06, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:59:20 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425150000, 25.2, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:59:05 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425135000, 25.17, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:58:50 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425120000, 25.19, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:58:20 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425090000, 25.1, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:58:07 info Send: 4 of: 4 in: 3ms
sql-0 2016-05-16 21:58:05 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425075000, 24.44, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:57:35 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425045000, 24.45, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:57:16 info Send: 1 of: 1 in: 4ms
sql-0 2016-05-16 21:56:05 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463424955000, 23.85, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:56:05 warn Cannot get index of "system.host.vm32test.memHeapTotal": Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:56:05 error Cannot select SELECT id, type FROM datapoints WHERE name='system.host.vm32test.memHeapTotal';: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:55:38 info enabled logging of system.host.vm32test.load
sql-0 2016-05-16 21:55:38 info enabled logging of system.host.vm32test.memRss
sql-0 2016-05-16 21:55:38 info enabled logging of system.host.vm32test.memHeapTotal
sql-0 2016-05-16 21:55:38 info enabled logging of system.host.vm32test.memHeapUsed
sql-0 2016-05-16 21:55:38 info enabled logging of system.host.vm32test.mem
sql-0 2016-05-16 21:55:51 error Cannot delete DELETE FROM ts_number WHERE id=3 AND ts < 1431888901;: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:55:51 warn Cannot get index of "system.host.vm32test.memHeapTotal": Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:55:51 error Cannot insert INSERT INTO datapoints (name, type) VALUES('system.host.vm32test.memHeapTotal', 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:55:48 info No Data
sql-0 2016-05-16 21:55:48 warn Cannot get index of "system.host.vm32test.load": id not found
sql-0 2016-05-16 21:55:38 info Connected to sqlite
sql-0 2016-05-16 21:55:38 info starting. Version 0.1.2 in /opt/iobroker/node_modules/iobroker.sql

Bluefox

~~@electric:~~

~~@ford7:~~
У меня не перестает.
sql-0	2016-05-12 11:20:26	error	Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463037621000, 38.38, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
P. s. SQLite3 `
Подтверждаю, у меня тоже сыплет ошибки. Настройки по-умолчанию (SQLite3).
Система Linux Debian, БД находится здесь````
/opt/iobroker/iobroker-data/sqlite/sqlite.db
Пробовал играться с настройками минимального интервала (ms), все равно ошибки выскакивают.
sql-0 2016-05-16 22:02:20 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425330000, 25.41, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 22:01:50 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(4, 1463425300000, 46.26, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 22:01:35 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425285000, 25.36, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 22:01:05 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425255000, 25.35, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 22:00:50 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425240000, 25.34, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 22:00:35 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425225000, 25.29, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 22:00:20 warn Cannot get index of "system.host.vm32test.memHeapTotal": Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 22:00:20 error Cannot select SELECT id, type FROM datapoints WHERE name='system.host.vm32test.memHeapTotal';: Error: SQLITE_BUSY: database is locked
host-vm32test 2016-05-16 21:55:21 info instance system.adapter.sql.0 terminated with code 0 (OK)
sql-0 2016-05-16 21:59:50 warn Cannot get index of "system.host.vm32test.memHeapTotal": Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:59:50 error Cannot select SELECT id, type FROM datapoints WHERE name='system.host.vm32test.memHeapTotal';: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:59:35 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(4, 1463425165000, 46.06, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:59:20 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425150000, 25.2, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:59:05 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425135000, 25.17, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:58:50 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425120000, 25.19, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:58:20 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425090000, 25.1, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:58:07 info Send: 4 of: 4 in: 3ms
sql-0 2016-05-16 21:58:05 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425075000, 24.44, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:57:35 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463425045000, 24.45, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:57:16 info Send: 1 of: 1 in: 4ms
sql-0 2016-05-16 21:56:05 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(2, 1463424955000, 23.85, 1, 1, 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:56:05 warn Cannot get index of "system.host.vm32test.memHeapTotal": Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:56:05 error Cannot select SELECT id, type FROM datapoints WHERE name='system.host.vm32test.memHeapTotal';: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:55:38 info enabled logging of system.host.vm32test.load
sql-0 2016-05-16 21:55:38 info enabled logging of system.host.vm32test.memRss
sql-0 2016-05-16 21:55:38 info enabled logging of system.host.vm32test.memHeapTotal
sql-0 2016-05-16 21:55:38 info enabled logging of system.host.vm32test.memHeapUsed
sql-0 2016-05-16 21:55:38 info enabled logging of system.host.vm32test.mem
sql-0 2016-05-16 21:55:51 error Cannot delete DELETE FROM ts_number WHERE id=3 AND ts < 1431888901;: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:55:51 warn Cannot get index of "system.host.vm32test.memHeapTotal": Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:55:51 error Cannot insert INSERT INTO datapoints (name, type) VALUES('system.host.vm32test.memHeapTotal', 0);: Error: SQLITE_BUSY: database is locked
sql-0 2016-05-16 21:55:48 info No Data
sql-0 2016-05-16 21:55:48 warn Cannot get index of "system.host.vm32test.load": id not found
sql-0 2016-05-16 21:55:38 info Connected to sqlite
sql-0 2016-05-16 21:55:38 info starting. Version 0.1.2 in /opt/iobroker/node_modules/iobroker.sql

```` `
Я уже всё поправил. После 21го опубликую. Или попробуйте с гита

ford7

Может я что-то не так делаю…

2016-07-26 22:31:55.986	info	Update repository "fast-online" under "http://download.iobroker.net/sources-dist.json"
sql-0	2016-07-26 21:41:25.562	error	Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(5, 1469554824557, 1, 1, 2, 0);: Error: SQLITE_BUSY: database is locked
sql-0	2016-07-26 21:39:25.428	error	Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(5, 1469554704424, 1, 1, 2, 0);: Error: SQLITE_BUSY: database is locked
sql-0	2016-07-26 21:37:25.357	error	Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(5, 1469554584340, 1, 1, 2, 0);: Error: SQLITE_BUSY: database is locked
sql-0	2016-07-26 21:35:25.189	error	Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(5, 1469554464175, 1, 1, 2, 0);: Error: SQLITE_BUSY: database is locked
sql-0	2016-07-26 21:33:25.145	error	Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(5, 1469554344130, 1, 1, 2, 0);: Error: SQLITE_BUSY: database is locked
sql-0	2016-07-26 21:31:25.053	error	Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(5, 1469554224039, 1, 1, 2, 0);: Error: SQLITE_BUSY: database is locked
sql-0	2016-07-26 21:29:24.995	error	Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(5, 1469554103986, 1, 1, 2, 0);: Error: SQLITE_BUSY: database is locked
sql-0	2016-07-26 21:27:24.939	error	Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(5, 1469553983932, 1, 1, 2, 0);: Error: SQLITE_BUSY: database is locked
sql-0	2016-07-26 21:25:24.883	error	Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(5, 1469553863869, 1, 1, 2, 0);: Error: SQLITE_BUSY: database is locked
sql-0	2016-07-26 21:23:24.819	error	Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(5, 1469553743803, 1, 1, 2, 0);: Error: SQLITE_BUSY: database is locked
sql-0	2016-07-26 21:21:24.753	error	Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(5, 1469553623745, 1, 1, 2, 0);: Error: SQLITE_BUSY: database is locked
sql-0	2016-07-26 21:17:24.658	error	Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(5, 1469553383643, 1, 1, 2, 0);: Error: SQLITE_BUSY: database is locked
sql-0	2016-07-26 21:15:24.599	error	Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(5, 1469553263588, 1, 1, 2, 0);: Error: SQLITE_BUSY: database is locked
sql-0	2016-07-26 21:13:24.541	error	Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(5, 1469553143537, 1, 1, 2, 0);: Error: SQLITE_BUSY: database is locked
sql-0	2016-07-26 21:11:24.508	error	Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(5, 1469553023501, 1, 1, 2, 0);: Error: SQLITE_BUSY: database is locked
sql-0	2016-07-26 21:09:24.444	error	Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(5, 1469552903431, 1, 1, 2, 0);: Error: SQLITE_BUSY: database is locked
sql-0	2016-07-26 21:07:24.380	error	Cannot insert INSERT INTO ts_bool (id, ts, val, ack, _from, q) VALUES(5, 1469552783375, 1, 1, 2, 0);: Error: SQLITE_BUSY: database is locked

Bluefox

Может быть такое, что базу кто то ещё открыл?

electric

~~@Bluefox:~~

Может быть такое, что базу кто то ещё открыл? `
я тестил версию драйвера пару недель назад с sqlite, та же ошибка была.

Сейчас попробовал, настроил хранение в sqlite параметров памяти сервера, настройки по-умолчанию.

После перезапуска сервера (полного) такие ошибки в логе:

! sql.0 2016-07-27 11:09:10.567 error sql.0 Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(3, 1469606939556, 21.56, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql.0 2016-07-27 11:09:10.565 error sql.0 Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(5, 1469606939556, 44.69, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:08:55.557 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(1, 1469606924547, 150, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:08:55.556 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(3, 1469606924547, 22.01, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:08:40.550 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(3, 1469606909539, 21.72, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:08:40.549 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(5, 1469606909539, 44.84, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:08:25.555 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(3, 1469606894534, 21.19, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:08:25.555 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(5, 1469606894533, 43.8, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:07:55.537 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(1, 1469606864518, 128, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:07:55.533 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(3, 1469606864517, 21.31, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:07:40.524 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(1, 1469606849510, 129, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:07:40.520 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(3, 1469606849510, 21.73, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:07:25.512 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(3, 1469606834501, 21.26, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:07:10.510 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(5, 1469606819492, 45.2, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:07:10.509 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(3, 1469606819493, 21.71, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:06:55.505 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(6, 1469606804487, 31.65, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:06:55.505 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(3, 1469606804487, 21.04, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:06:41.485 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(3, 1469606789468, 21.16, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:06:25.462 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(6, 1469606774450, 30.69, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:06:10.456 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(3, 1469606759441, 33.45, 1, 1, 0);: Error: SQLITE_BUSY: database is locked host-vm32test 2016-07-27 11:06:06.045 info instance system.adapter.yr.0 terminated with code 0 (OK) yr-0 2016-07-27 11:06:00.980 info got weather data from yr.no yr-0 2016-07-27 11:06:00.817 info starting. Version 1.0.4 in /opt/iobroker/node_modules/iobroker.yr host-vm32test 2016-07-27 11:06:00.438 info instance system.adapter.yr.0 started with pid 6999 sql-0 2016-07-27 11:05:55.458 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(6, 1469606744431, 61.55, 1, 1, 0);: Error: SQLITE_BUSY: database is locked sql-0 2016-07-27 11:05:55.457 error Cannot insert INSERT INTO ts_number (id, ts, val, ack, _from, q) VALUES(5, 1469606744431, 58.62, 1, 1, 0);: Error: SQLITE_BUSY: database is locked host-vm32test 2016-07-27 11:05:47.498 info instance system.adapter.yr.0 terminated with code 0 (OK) yr-0 2016-07-27 11:05:42.442 info got weather data from yr.no yr-0 2016-07-27 11:05:41.888 info starting. Version 1.0.4 in /opt/iobroker/node_modules/iobroker.yr host-vm32test 2016-07-27 11:05:41.432 info instance system.adapter.yr.0 started with pid 6990 host-vm32test 2016-07-27 11:05:41.429 info instance scheduled system.adapter.yr.0 6 * * * * admin-0 2016-07-27 11:05:40.455 info successful connection to socket.io from ::ffff:109.194.66.17 host-vm32test 2016-07-27 11:05:37.437 info instance scheduled system.adapter.weatherunderground.0 */48 * * * * sql-0 2016-07-27 11:05:34.065 info Connected to sqlite sql-0 2016-07-27 11:05:34.046 info enabled logging of system.host.vm32test.freemem sql-0 2016-07-27 11:05:34.045 info enabled logging of system.host.vm32test.load sql-0 2016-07-27 11:05:34.045 info enabled logging of system.host.vm32test.memRss sql-0 2016-07-27 11:05:34.045 info enabled logging of system.host.vm32test.memHeapTotal sql-0 2016-07-27 11:05:34.045 info enabled logging of system.host.vm32test.memHeapUsed sql-0 2016-07-27 11:05:34.045 info enabled logging of system.host.vm32test.mem sql-0 2016-07-27 11:05:34.015 info starting. Version 1.0.9 in /opt/iobroker/node_modules/iobroker.sql host-vm32test 2016-07-27 11:05:33.432 info instance system.adapter.sql.0 started with pid 6981 admin-0 2016-07-27 11:05:30.851 info Repository received successfully. admin-0 2016-07-27 11:05:30.499 info received all states admin-0 2016-07-27 11:05:30.485 info received all objects host-vm32test 2016-07-27 11:05:30.290 info Update repository "default" under "http://download.iobroker.net/sources-dist.json" admin-0 2016-07-27 11:05:30.210 info Use link "https://localhost:8081" to configure. admin-0 2016-07-27 11:05:30.210 info https server listening on port 8081 admin-0 2016-07-27 11:05:30.208 info requesting all objects admin-0 2016-07-27 11:05:30.203 info requesting all states admin-0 2016-07-27 11:05:30.093 info Request actual repository... admin-0 2016-07-27 11:05:30.070 info starting. Version 1.2.6 in /opt/iobroker/node_modules/iobroker.admin host-vm32test 2016-07-27 11:05:29.435 info instance system.adapter.admin.0 started with pid 6972 host-vm32test 2016-07-27 11:05:29.426 info starting 4 instances host-vm32test 2016-07-27 11:05:29.425 info 24 instances found host-vm32test 2016-07-27 11:05:29.422 info InMemoryDB connected inMem-objects 2016-07-27 11:05:29.419 info listening on port 9001 inMem-states 2016-07-27 11:05:29.403 info listening on port 9000 host-vm32test 2016-07-27 11:05:29.392 info ip addresses: 192.168.69.32 fe80::5054:ff:fe9b:9929 host-vm32test 2016-07-27 11:05:29.392 info hostname: vm32test host-vm32test 2016-07-27 11:05:29.391 info Copyright (c) 2014-2016 bluefox, hobbyquaker host-vm32test 2016-07-27 11:05:29.389 info iobroker.js-controller version 0.10.1 js-controller starting !

instalator

при попвтке обновится до 1.4.0.

В итоге не обновляется

! ````
$ ./iobroker upgrade sql
host.Server-PC Adapter "system.adapter.sql.0" is stopped.
npm install iobroker.sql --production --prefix "C:/ioBroker" (System call)
npm

WARN

deprecated
node-uuid@1.4.7: use uuid module instead
gyp

ERR!

configure error

gyp

ERR!

stack
Error: Can't find Python executable "python", you can set the PYTHON env variable.
gyp

ERR!

stack
at failNoPython (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:449:14)
gyp

ERR!

stack
at C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:404:11
gyp

ERR!

stack
at FSReqWrap.oncomplete (fs.js:82:15)
gyp

ERR!

System
Windows_NT 6.1.7601
gyp

ERR!

command
"C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" "rebuild"
gyp

ERR!

cwd
C:\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\node_modules\inote-util\node_modules\mmmagic
gyp

ERR!

node -v
v4.6.2
gyp

ERR!

node-gyp -v
v3.4.0
gyp

ERR!

not ok

node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.8/node-v46-win32-ia32.tar.gz node-pre-gyp ERR! Pre-built binaries not found for sqlite3@3.1.8 and node@4.6.2 (node-v46 ABI) (falling back to source compile with node-gyp)

! gyp

ERR!

configure error

gyp

ERR!

stack
Error: Can't find Python executable "python", you can set the PYTHON env variable.
gyp

ERR!

stack
at failNoPython (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:449:14)
gyp

ERR!

stack
at C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:404:11
gyp

ERR!

stack
at FSReqWrap.oncomplete (fs.js:82:15)
gyp

ERR!

System
Windows_NT 6.1.7601
gyp

ERR!

command
"C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" "configure" "--fallback-to-build" "--module=C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\lib\binding\node-v46-win32-ia32\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\lib\binding\node-v46-win32-ia32"
gyp

ERR!

cwd
C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3
gyp

ERR!

node -v
v4.6.2
gyp

ERR!

node-gyp -v
v3.4.0
gyp

ERR!

not ok

node-pre-gyp

ERR!

build error

node-pre-gyp

ERR!

stack
Error: Failed to execute 'node-gyp.cmd configure --fallback-to-build --module=C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\lib\binding\node-v46-win32-ia32\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\lib\binding\node-v46-win32-ia32' (1)
node-pre-gyp

ERR!

stack
at ChildProcess. <anonymous>(C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
node-pre-gyp

ERR!

stack
at emitTwo (events.js:87:13)
node-pre-gyp

ERR!

stack
at ChildProcess.emit (events.js:172:7)
node-pre-gyp

ERR!

stack
at maybeClose (internal/child_process.js:854:16)
node-pre-gyp

ERR!

stack
at Process.ChildProcess._handle.onexit (internal/child_process.js:222:5)
node-pre-gyp

ERR!

System
Windows_NT 6.1.7601
node-pre-gyp

ERR!

command
"C:\Program Files\nodejs\node.exe" "C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\node_modules\node-pre-gyp\bin\node-pre-gyp" "install" "--fallback-to-build"
node-pre-gyp

ERR!

cwd
C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3
node-pre-gyp

ERR!

node -v
v4.6.2
node-pre-gyp

ERR!

node-pre-gyp -v
v0.6.31
node-pre-gyp

ERR!

not ok

npm

WARN

optional dep failed, continuing
sqlite3@3.1.8
npm

ERR!
Windows_NT 6.1.7601
npm

ERR!

argv
"C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\bin\npm-cli.js" "install" "iobroker.sql" "--production" "--prefix" "C:/ioBroker"
npm

ERR!

node
v4.6.2
npm

ERR!

npm
v2.15.11
npm

ERR!

code
ELIFECYCLE

! npm

ERR!
mmmagic@0.4.5 install: node-gyp rebuild
npm

ERR!
Exit status 1
npm

ERR!

npm

ERR!
Failed at the mmmagic@0.4.5 install script 'node-gyp rebuild'.
npm

ERR!
This is most likely a problem with the mmmagic package,
npm

ERR!
not with npm itself.
npm

ERR!
Tell the author that this fails on your system:
npm

ERR!
node-gyp rebuild
npm

ERR!
You can get information on how to open an issue for this project with:
npm

ERR!
npm bugs mmmagic
npm

ERR!
Or if that isn't available, you can get their info via:
npm

ERR!

npm

ERR!
npm owner ls mmmagic
npm

ERR!
There is likely additional logging output above.

! npm

ERR!
Please include the following file with any support request:
npm

ERR!
C:\ioBroker\node_modules\iobroker\npm-debug.log
ERROR: host.Server-PC Cannot install iobroker.sql: 1
ERROR: process exited with code 25</anonymous>

sigma

SQL History 1.5.6. Коннект к внешнему серверу PostgreSQL.

В логе постоянно сыпятся ошибки:

sql.0	2017-10-04 10:41:45.719	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898623, 'Subscribe [Equipment/Relays/R0045]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:45.499	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898620, 'Subscribe [Equipment/Relays/R0040]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:45.467	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898619, 'Subscribe [Equipment/Relays/R0037]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:45.151	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898611, 'Subscribe [Equipment/Relays/R0029]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:45.149	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898610, 'Subscribe [Equipment/Relays/R0028]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:44.944	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898603, 'Subscribe [Equipment/Buttons/B0017]', true, 1, 0);: error: duplicate key value violates unique constraint "t
sql.0	2017-10-04 10:41:44.890	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898602, 'Subscribe [Equipment/Buttons/B0016]', true, 1, 0);: error: duplicate key value violates unique constraint "t

Каким образом он умудряется выдать две записи в 1 мс?

Bluefox

Настрой Минимальный интервал

ford7

Периодически слетает настройка истории в sql (активно) только для данной переменной.

Подскажите, что бы это значило?
256_sql1.jpg

NEWS

Ошибки драйвера SQL

Support us

477
Online

31.7k
Users

79.8k
Topics

1.3m
Posts

NEWS

Ошибки драйвера SQL

Support us

477Online

31.7kUsers

79.8kTopics

1.3mPosts

477
Online

31.7k
Users

79.8k
Topics

1.3m
Posts