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

Сообщите об ошибках в ioBroker
Benutzeravatar
instalator
guru
Beiträge: 1258
Registriert: 09.11.2014, 16:50
Wohnort: Барнаул
Kontaktdaten:

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

Beitrag von instalator » 13.02.2016, 09:42

Spoiler: Show hidden text

Code: Alles auswählen

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'
Высокий уровень Децибел вреден для здоровья!
Мой блог

Benutzeravatar
Bluefox
Site Admin
Beiträge: 7909
Registriert: 13.07.2014, 14:42
Kontaktdaten:

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

Beitrag von Bluefox » 13.02.2016, 10:39

instalator hat geschrieben:
Spoiler: Show hidden text

Code: Alles auswählen

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'
Какие настройки?

Benutzeravatar
instalator
guru
Beiträge: 1258
Registriert: 09.11.2014, 16:50
Wohnort: Барнаул
Kontaktdaten:

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

Beitrag von instalator » 13.02.2016, 10:55

Раньше не было ошибки, настройки не менял.
Dateianhänge
sql2.png
sql.png
Высокий уровень Децибел вреден для здоровья!
Мой блог

Benutzeravatar
instalator
guru
Beiträge: 1258
Registriert: 09.11.2014, 16:50
Wohnort: Барнаул
Kontaktdaten:

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

Beitrag von instalator » 26.02.2016, 13:29

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

Code: Alles auswählen

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
starter
Beiträge: 73
Registriert: 20.12.2015, 11:24

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

Beitrag von DAndre » 26.02.2016, 15:30

Тоже так было,(после оптимизации sql) + винт грузил ужасно.
Не стал заморачиватся все переменные перевел на History.
Потом переменные которые мне нужны (типа данные с портов) вернул на sql, 2 недели полет нормальный.
Ubuntu 14.04 trusty DISTRIB_DESCRIPTION="Ubuntu 14.04.3 LTS, Android v4.4.2"
Ubuntu 16.04.1 LTS (GNU/Linux 4.4.0-31-generic x86_64)

Haus
professional
Beiträge: 529
Registriert: 12.05.2015, 16:49
Wohnort: Lithuania, Vilnius

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

Beitrag von Haus » 26.02.2016, 18:29

DAndre hat geschrieben:Тоже так было,(после оптимизации sql) + винт грузил ужасно.
Не стал заморачиватся все переменные перевел на History.
Потом переменные которые мне нужны (типа данные с портов) вернул на sql, 2 недели полет нормальный.
Не вы неправы, у меня база вообще на другом сервере лежит вместе с еще одной базой от Андрея все крутится как надо. Может диск кривой?
js-controller: 1.2.3 / node.js: v4.8.7 / npm: 2.15.11
admin: 3.2.0
javascript: 3.6.4
web: 2.1.9 vis: 1.1.2
cloud: 2.4.6

Server: DELL FX170 / linux: Debian 8.8 Jessie
Adapter: MegaD-2561, Mega-ESP, Wrapper(Home)

DAndre
starter
Beiträge: 73
Registriert: 20.12.2015, 11:24

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

Beitrag von DAndre » 27.02.2016, 07:01

HDD я упомянул так, для информации.
После указанных телодвижений у меня пропала ошибка аналогичная как у instalator. Может конечно совпадение.
Ubuntu 14.04 trusty DISTRIB_DESCRIPTION="Ubuntu 14.04.3 LTS, Android v4.4.2"
Ubuntu 16.04.1 LTS (GNU/Linux 4.4.0-31-generic x86_64)

ford7
starter
Beiträge: 59
Registriert: 27.10.2014, 12:28

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

Beitrag von ford7 » 29.02.2016, 10:11

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

Code: Alles auswählen

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
Dateianhänge
sql3.JPG
Zuletzt geändert von ford7 am 29.02.2016, 15:48, insgesamt 1-mal geändert.

spectrekr
professional
Beiträge: 255
Registriert: 26.12.2014, 09:40

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

Beitrag von spectrekr » 29.02.2016, 10:28

Аналогично, сегодня посыпались.
Spoiler: Show hidden text
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'

Benutzeravatar
Bluefox
Site Admin
Beiträge: 7909
Registriert: 13.07.2014, 14:42
Kontaktdaten:

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

Beitrag von Bluefox » 29.02.2016, 12:24

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

spectrekr
professional
Beiträge: 255
Registriert: 26.12.2014, 09:40

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

Beitrag von spectrekr » 29.02.2016, 12:51

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

Haus
professional
Beiträge: 529
Registriert: 12.05.2015, 16:49
Wohnort: Lithuania, Vilnius

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

Beitrag von Haus » 29.02.2016, 13:07

SQL Hystory 0.1.2 MySQL
js-controller: 1.2.3 / node.js: v4.8.7 / npm: 2.15.11
admin: 3.2.0
javascript: 3.6.4
web: 2.1.9 vis: 1.1.2
cloud: 2.4.6

Server: DELL FX170 / linux: Debian 8.8 Jessie
Adapter: MegaD-2561, Mega-ESP, Wrapper(Home)

RDim
starter
Beiträge: 51
Registriert: 19.11.2015, 12:46

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

Beitrag von RDim » 01.03.2016, 06:56

Подключен к удаленному серверу MySQL 5.5.47 на debian 7.9, cubieboard.
ioBroker на debian 8.3 , cubietruck.
Полет отличный, ошибок MySQL не замечено.

spectrekr
professional
Beiträge: 255
Registriert: 26.12.2014, 09:40

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

Beitrag von spectrekr » 02.03.2016, 07:56

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

ford7
starter
Beiträge: 59
Registriert: 27.10.2014, 12:28

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

Beitrag von ford7 » 12.05.2016, 10:18

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

Code: Alles auswählen

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

Benutzeravatar
electric
starter
Beiträge: 64
Registriert: 09.05.2016, 19:35

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

Beitrag von electric » 16.05.2016, 20:35

ford7 hat geschrieben:У меня не перестает.

Code: Alles auswählen

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, БД находится здесь

Code: Alles auswählen

/opt/iobroker/iobroker-data/sqlite/sqlite.db
Пробовал играться с настройками минимального интервала (ms), все равно ошибки выскакивают.

Code: Alles auswählen

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

Benutzeravatar
Bluefox
Site Admin
Beiträge: 7909
Registriert: 13.07.2014, 14:42
Kontaktdaten:

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

Beitrag von Bluefox » 16.05.2016, 21:18

electric hat geschrieben:
ford7 hat geschrieben:У меня не перестает.

Code: Alles auswählen

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, БД находится здесь

Code: Alles auswählen

/opt/iobroker/iobroker-data/sqlite/sqlite.db
Пробовал играться с настройками минимального интервала (ms), все равно ошибки выскакивают.

Code: Alles auswählen

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
starter
Beiträge: 59
Registriert: 27.10.2014, 12:28

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

Beitrag von ford7 » 26.07.2016, 19:34

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

Code: Alles auswählen

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

Benutzeravatar
Bluefox
Site Admin
Beiträge: 7909
Registriert: 13.07.2014, 14:42
Kontaktdaten:

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

Beitrag von Bluefox » 26.07.2016, 20:38

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

Benutzeravatar
electric
starter
Beiträge: 64
Registriert: 09.05.2016, 19:35

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

Beitrag von electric » 27.07.2016, 08:44

Bluefox hat geschrieben:Может быть такое, что базу кто то ещё открыл?
я тестил версию драйвера пару недель назад с sqlite, та же ошибка была.
Сейчас попробовал, настроил хранение в sqlite параметров памяти сервера, настройки по-умолчанию.
После перезапуска сервера (полного) такие ошибки в логе:
Spoiler: Show hidden text

Code: Alles auswählen

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

Antworten