ioBroker Forum


Nutzungsbedingungen |Datenschutzrichtlinie
Cloud |Dokumentation
Aktuelle Zeit: 22.02.2018, 11:52

Alle Zeiten sind UTC+01:00




Ein neues Thema erstellen  Auf das Thema antworten  [ 24 Beiträge ]  Gehe zu Seite 1 2 Nächste
Autor Nachricht
 Betreff des Beitrags: Ошибки драйвера SQL
BeitragVerfasst: 13.02.2016, 09:42 
Offline
guru
Benutzeravatar

Registriert: 09.11.2014, 16:50
Beiträge: 1238
Wohnort: Барнаул
Hat sich bedankt: 15 Mal
Danksagung erhalten: 41 Mal
Spoiler: Show hidden text
Code:
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'

_________________
Высокий уровень Децибел вреден для здоровья!
Мой блог


Nach oben
   
BeitragVerfasst: 13.02.2016, 10:39 
Offline
Site Admin
Benutzeravatar

Registriert: 13.07.2014, 14:42
Beiträge: 7712
Hat sich bedankt: 290 Mal
Danksagung erhalten: 829 Mal
instalator hat geschrieben:
Spoiler: Show hidden text
Code:
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'

Какие настройки?


Nach oben
   
BeitragVerfasst: 13.02.2016, 10:55 
Offline
guru
Benutzeravatar

Registriert: 09.11.2014, 16:50
Beiträge: 1238
Wohnort: Барнаул
Hat sich bedankt: 15 Mal
Danksagung erhalten: 41 Mal
Раньше не было ошибки, настройки не менял.


Dateianhänge:
sql2.png
sql2.png [ 56.07 KiB | 2913 mal betrachtet ]
sql.png
sql.png [ 61.31 KiB | 2913 mal betrachtet ]

_________________
Высокий уровень Децибел вреден для здоровья!
Мой блог
Nach oben
   
BeitragVerfasst: 26.02.2016, 13:29 
Offline
guru
Benutzeravatar

Registriert: 09.11.2014, 16:50
Beiträge: 1238
Wohnort: Барнаул
Hat sich bedankt: 15 Mal
Danksagung erhalten: 41 Mal
Ошибка периодически выскакивает:
Code:
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'

_________________
Высокий уровень Децибел вреден для здоровья!
Мой блог


Nach oben
   
BeitragVerfasst: 26.02.2016, 15:30 
Offline
starter

Registriert: 20.12.2015, 11:24
Beiträge: 73
Hat sich bedankt: 8 Mal
Тоже так было,(после оптимизации 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)


Nach oben
   
BeitragVerfasst: 26.02.2016, 18:29 
Offline
professional

Registriert: 12.05.2015, 16:49
Beiträge: 514
Wohnort: Lithuania, Vilnius
Hat sich bedankt: 17 Mal
Danksagung erhalten: 38 Mal
DAndre hat geschrieben:
Тоже так было,(после оптимизации sql) + винт грузил ужасно.
Не стал заморачиватся все переменные перевел на History.
Потом переменные которые мне нужны (типа данные с портов) вернул на sql, 2 недели полет нормальный.

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

_________________
js-controller: 1.2.0 / node.js: v4.8.6 / npm: 2.15.11
admin: 3.0.1
javascript: 3.5.0
web: 2.1.7 vis: 1.0.4
cloud: 2.0.5

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


Nach oben
   
BeitragVerfasst: 27.02.2016, 07:01 
Offline
starter

Registriert: 20.12.2015, 11:24
Beiträge: 73
Hat sich bedankt: 8 Mal
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)


Nach oben
   
BeitragVerfasst: 29.02.2016, 10:11 
Offline
starter

Registriert: 27.10.2014, 12:28
Beiträge: 59
Hat sich bedankt: 9 Mal
Danksagung erhalten: 1 Mal
Тоже начали выскакивать ошибки:
Spoiler: Show hidden text
Code:
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
sql3.JPG [ 29.99 KiB | 2816 mal betrachtet ]


Zuletzt geändert von ford7 am 29.02.2016, 15:48, insgesamt 1-mal geändert.
Nach oben
   
BeitragVerfasst: 29.02.2016, 10:28 
Offline
professional

Registriert: 26.12.2014, 09:40
Beiträge: 252
Hat sich bedankt: 2 Mal
Danksagung erhalten: 14 Mal
Аналогично, сегодня посыпались.

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'


Nach oben
   
BeitragVerfasst: 29.02.2016, 12:24 
Offline
Site Admin
Benutzeravatar

Registriert: 13.07.2014, 14:42
Beiträge: 7712
Hat sich bedankt: 290 Mal
Danksagung erhalten: 829 Mal
SQL типов 4 штуки. Пожалуйста конкретизируйте.


Nach oben
   
BeitragVerfasst: 29.02.2016, 12:51 
Offline
professional

Registriert: 26.12.2014, 09:40
Beiträge: 252
Hat sich bedankt: 2 Mal
Danksagung erhalten: 14 Mal
В моем случае это MySQL


Nach oben
   
BeitragVerfasst: 29.02.2016, 13:07 
Offline
professional

Registriert: 12.05.2015, 16:49
Beiträge: 514
Wohnort: Lithuania, Vilnius
Hat sich bedankt: 17 Mal
Danksagung erhalten: 38 Mal
SQL Hystory 0.1.2 MySQL

_________________
js-controller: 1.2.0 / node.js: v4.8.6 / npm: 2.15.11
admin: 3.0.1
javascript: 3.5.0
web: 2.1.7 vis: 1.0.4
cloud: 2.0.5

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


Nach oben
   
BeitragVerfasst: 01.03.2016, 06:56 
Offline
starter

Registriert: 19.11.2015, 12:46
Beiträge: 51
Hat sich bedankt: 3 Mal
Danksagung erhalten: 1 Mal
Подключен к удаленному серверу MySQL 5.5.47 на debian 7.9, cubieboard.
ioBroker на debian 8.3 , cubietruck.
Полет отличный, ошибок MySQL не замечено.


Nach oben
   
BeitragVerfasst: 02.03.2016, 07:56 
Offline
professional

Registriert: 26.12.2014, 09:40
Beiträge: 252
Hat sich bedankt: 2 Mal
Danksagung erhalten: 14 Mal
Странно, но со вчерашнего утра больше ни одной ошибки не выскочило.


Nach oben
   
BeitragVerfasst: 12.05.2016, 10:18 
Offline
starter

Registriert: 27.10.2014, 12:28
Beiträge: 59
Hat sich bedankt: 9 Mal
Danksagung erhalten: 1 Mal
У меня не перестает.
Code:
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


Nach oben
   
BeitragVerfasst: 16.05.2016, 20:35 
Offline
starter
Benutzeravatar

Registriert: 09.05.2016, 19:35
Beiträge: 64
Hat sich bedankt: 5 Mal
Danksagung erhalten: 3 Mal
ford7 hat geschrieben:
У меня не перестает.
Code:
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:
/opt/iobroker/iobroker-data/sqlite/sqlite.db

Пробовал играться с настройками минимального интервала (ms), все равно ошибки выскакивают.
Code:
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


Nach oben
   
BeitragVerfasst: 16.05.2016, 21:18 
Offline
Site Admin
Benutzeravatar

Registriert: 13.07.2014, 14:42
Beiträge: 7712
Hat sich bedankt: 290 Mal
Danksagung erhalten: 829 Mal
electric hat geschrieben:
ford7 hat geschrieben:
У меня не перестает.
Code:
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:
/opt/iobroker/iobroker-data/sqlite/sqlite.db

Пробовал играться с настройками минимального интервала (ms), все равно ошибки выскакивают.
Code:
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го опубликую. Или попробуйте с гита


Nach oben
   
BeitragVerfasst: 26.07.2016, 19:34 
Offline
starter

Registriert: 27.10.2014, 12:28
Beiträge: 59
Hat sich bedankt: 9 Mal
Danksagung erhalten: 1 Mal
Может я что-то не так делаю...
Code:
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


Nach oben
   
BeitragVerfasst: 26.07.2016, 20:38 
Offline
Site Admin
Benutzeravatar

Registriert: 13.07.2014, 14:42
Beiträge: 7712
Hat sich bedankt: 290 Mal
Danksagung erhalten: 829 Mal
Может быть такое, что базу кто то ещё открыл?


Nach oben
   
BeitragVerfasst: 27.07.2016, 08:44 
Offline
starter
Benutzeravatar

Registriert: 09.05.2016, 19:35
Beiträge: 64
Hat sich bedankt: 5 Mal
Danksagung erhalten: 3 Mal
Bluefox hat geschrieben:
Может быть такое, что базу кто то ещё открыл?

я тестил версию драйвера пару недель назад с sqlite, та же ошибка была.
Сейчас попробовал, настроил хранение в sqlite параметров памяти сервера, настройки по-умолчанию.
После перезапуска сервера (полного) такие ошибки в логе:
Spoiler: Show hidden text
Code:
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


Nach oben
   
Beiträge der letzten Zeit anzeigen:  Sortiere nach  
Ein neues Thema erstellen  Auf das Thema antworten  [ 24 Beiträge ]  Gehe zu Seite 1 2 Nächste

Alle Zeiten sind UTC+01:00


Wer ist online?

Mitglieder in diesem Forum: 0 Mitglieder und 1 Gast


Du darfst keine neuen Themen in diesem Forum erstellen.
Du darfst keine Antworten zu Themen in diesem Forum erstellen.
Du darfst deine Beiträge in diesem Forum nicht ändern.
Du darfst deine Beiträge in diesem Forum nicht löschen.
Du darfst keine Dateianhänge in diesem Forum erstellen.

Suche nach:
Gehe zu Forum:  
Powered by phpBB® Forum Software © phpBB Limited
Deutsche Übersetzung durch phpBB.de