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

instalator

! ````
sql-0 2016-02-13 14:40:11 error Cannot insert INSERT INTO iobroker.ts_string (id, ts, val, ack, _from, q) VALUES(32, 1455352801000, 'HDMI2', 1, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '32-1455352801000' for key 'PRIMARY'
sql-0 2016-02-13 14:37:00 info sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0: {"result":[{"ts":1455266437,"val":null},{"ts":1455266869,"val":null},{"ts":1455267301,"val":null},{"ts":1455267733,"val":null},{
sql-0 2016-02-13 14:37:00 info Send: 200 of: 2528 in: 156ms
sql-0 2016-02-13 14:36:58 info sendTo "getHistory" to system.adapter.admin.0 from system.adapter.sql.0: {"result":[{"ts":1455352062,"val":null,"ack":true,"from":"system.adapter.mqtt.0","q":0},{"ts":1455352073,"val":null,"ack":true
sql-0 2016-02-13 14:36:58 info Send: 50 of: 50 in: 62ms
sql-0 2016-02-13 14:35:11 error Cannot insert INSERT INTO iobroker.ts_string (id, ts, val, ack, _from, q) VALUES(32, 1455352501000, 'HDMI2', 1, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '32-1455352501000' for key 'PRIMARY'
sql-0 2016-02-13 14:30:11 error Cannot insert INSERT INTO iobroker.ts_string (id, ts, val, ack, _from, q) VALUES(32, 1455352201000, 'HDMI2', 1, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '32-1455352201000' for key 'PRIMARY'

Bluefox

~~@instalator:~~

! sql-0 2016-02-13 14:40:11 error Cannot insert INSERT INTO iobroker.ts_string (id, ts, val, ack, _from, q) VALUES(32, 1455352801000, 'HDMI2', 1, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '32-1455352801000' for key 'PRIMARY' sql-0 2016-02-13 14:37:00 info sendTo "getHistory" to system.adapter.web.0 from system.adapter.sql.0: {"result":[{"ts":1455266437,"val":null},{"ts":1455266869,"val":null},{"ts":1455267301,"val":null},{"ts":1455267733,"val":null},{ sql-0 2016-02-13 14:37:00 info Send: 200 of: 2528 in: 156ms sql-0 2016-02-13 14:36:58 info sendTo "getHistory" to system.adapter.admin.0 from system.adapter.sql.0: {"result":[{"ts":1455352062,"val":null,"ack":true,"from":"system.adapter.mqtt.0","q":0},{"ts":1455352073,"val":null,"ack":true sql-0 2016-02-13 14:36:58 info Send: 50 of: 50 in: 62ms sql-0 2016-02-13 14:35:11 error Cannot insert INSERT INTO iobroker.ts_string (id, ts, val, ack, _from, q) VALUES(32, 1455352501000, 'HDMI2', 1, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '32-1455352501000' for key 'PRIMARY' sql-0 2016-02-13 14:30:11 error Cannot insert INSERT INTO iobroker.ts_string (id, ts, val, ack, _from, q) VALUES(32, 1455352201000, 'HDMI2', 1, 1, 0);: Error: ER_DUP_ENTRY: Duplicate entry '32-1455352201000' for key 'PRIMARY' `
Какие настройки?

instalator

Раньше не было ошибки, настройки не менял.
266_sql.png
266_sql2.png

instalator

Ошибка периодически выскакивает:

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'

DAndre

Тоже так было,(после оптимизации sql) + винт грузил ужасно.

Не стал заморачиватся все переменные перевел на History.

Потом переменные которые мне нужны (типа данные с портов) вернул на sql, 2 недели полет нормальный.

Haus

~~@DAndre:~~

Тоже так было,(после оптимизации sql) + винт грузил ужасно.

Не стал заморачиватся все переменные перевел на History.

Потом переменные которые мне нужны (типа данные с портов) вернул на sql, 2 недели полет нормальный. `
Не вы неправы, у меня база вообще на другом сервере лежит вместе с еще одной базой от Андрея все крутится как надо. Может диск кривой?

DAndre

HDD я упомянул так, для информации.

После указанных телодвижений у меня пропала ошибка аналогичная как у instalator. Может конечно совпадение.

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 !

NEWS

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

Support us

928
Online

31.7k
Users

79.6k
Topics

1.3m
Posts

NEWS

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

Support us

928Online

31.7kUsers

79.6kTopics

1.3mPosts

928
Online

31.7k
Users

79.6k
Topics

1.3m
Posts