Ошибки драйвера SQL
-
Раньше не было ошибки, настройки не менял.
266_sql.png
266_sql2.png -
Ошибка периодически выскакивает:
sql.0 2016-02-26 18:23:50 error sql.0 Cannot insert INSERT INTO iobroker.ts_string (id, ts, val, ack, _from, q) VALUES(32, 1456489420000, 'HDMI2', 1, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '32-1456489420000' for key 'PRIMARY' -
Тоже так было,(после оптимизации 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 мс?
Hey! Du scheinst an dieser Unterhaltung interessiert zu sein, hast aber noch kein Konto.
Hast du es satt, bei jedem Besuch durch die gleichen Beiträge zu scrollen? Wenn du dich für ein Konto anmeldest, kommst du immer genau dorthin zurück, wo du zuvor warst, und kannst dich über neue Antworten benachrichtigen lassen (entweder per E-Mail oder Push-Benachrichtigung). Du kannst auch Lesezeichen speichern und Beiträge positiv bewerten, um anderen Community-Mitgliedern deine Wertschätzung zu zeigen.
Mit deinem Input könnte dieser Beitrag noch besser werden 💗
Registrieren AnmeldenSupport us
610
Online32.8k
Benutzer82.9k
Themen1.3m
Beiträge