NEWS
Ошибки драйвера SQL
-
Тоже так было,(после оптимизации sql) + винт грузил ужасно.
Не стал заморачиватся все переменные перевел на History.
Потом переменные которые мне нужны (типа данные с портов) вернул на sql, 2 недели полет нормальный. `
Не вы неправы, у меня база вообще на другом сервере лежит вместе с еще одной базой от Андрея все крутится как надо. Может диск кривой? -
Тоже начали выскакивать ошибки:
! ````
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) -
Аналогично, сегодня посыпались.
! 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' -
У меня не перестает.
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 lockedP. 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 -
У меня не перестает.
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 lockedP. 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го опубликую. Или попробуйте с гита -
Может я что-то не так делаю…
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 -
Может быть такое, что базу кто то ещё открыл? `
я тестил версию драйвера пару недель назад с 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 ! -
при попвтке обновится до 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)
npmWARN
deprecated
node-uuid@1.4.7: use uuid module instead
gypERR!
configure error
gyp
ERR!
stack
Error: Can't find Python executable "python", you can set the PYTHON env variable.
gypERR!
stack
at failNoPython (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:449:14)
gypERR!
stack
at C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:404:11
gypERR!
stack
at FSReqWrap.oncomplete (fs.js:82:15)
gypERR!
System
Windows_NT 6.1.7601
gypERR!
command
"C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" "rebuild"
gypERR!
cwd
C:\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\node_modules\inote-util\node_modules\mmmagic
gypERR!
node -v
v4.6.2
gypERR!
node-gyp -v
v3.4.0
gypERR!
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.
gypERR!
stack
at failNoPython (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:449:14)
gypERR!
stack
at C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:404:11
gypERR!
stack
at FSReqWrap.oncomplete (fs.js:82:15)
gypERR!
System
Windows_NT 6.1.7601
gypERR!
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"
gypERR!
cwd
C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3
gypERR!
node -v
v4.6.2
gypERR!
node-gyp -v
v3.4.0
gypERR!
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-gypERR!
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-gypERR!
stack
at emitTwo (events.js:87:13)
node-pre-gypERR!
stack
at ChildProcess.emit (events.js:172:7)
node-pre-gypERR!
stack
at maybeClose (internal/child_process.js:854:16)
node-pre-gypERR!
stack
at Process.ChildProcess._handle.onexit (internal/child_process.js:222:5)
node-pre-gypERR!
System
Windows_NT 6.1.7601
node-pre-gypERR!
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-gypERR!
cwd
C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3
node-pre-gypERR!
node -v
v4.6.2
node-pre-gypERR!
node-pre-gyp -v
v0.6.31
node-pre-gypERR!
not ok
npm
WARN
optional dep failed, continuing
sqlite3@3.1.8
npmERR!
Windows_NT 6.1.7601
npmERR!
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"
npmERR!
node
v4.6.2
npmERR!
npm
v2.15.11
npmERR!
code
ELIFECYCLE! npm
ERR!
mmmagic@0.4.5 install:node-gyp rebuild
npmERR!
Exit status 1
npmERR!
npm
ERR!
Failed at the mmmagic@0.4.5 install script 'node-gyp rebuild'.
npmERR!
This is most likely a problem with the mmmagic package,
npmERR!
not with npm itself.
npmERR!
Tell the author that this fails on your system:
npmERR!
node-gyp rebuild
npmERR!
You can get information on how to open an issue for this project with:
npmERR!
npm bugs mmmagic
npmERR!
Or if that isn't available, you can get their info via:
npmERR!
npm
ERR!
npm owner ls mmmagic
npmERR!
There is likely additional logging output above.! npm
ERR!
Please include the following file with any support request:
npmERR!
C:\ioBroker\node_modules\iobroker\npm-debug.log
ERROR: host.Server-PC Cannot install iobroker.sql: 1
ERROR: process exited with code 25</anonymous> -
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 мс?
-
Периодически слетает настройка истории в sql (активно) только для данной переменной.
Подскажите, что бы это значило?
256_sql1.jpg
Support us
765
Online32.5k
Benutzer81.6k
Themen1.3m
Beiträge