Navigation

    Logo
    • Register
    • Login
    • Search
    • Recent
    • Tags
    • Unread
    • Categories
    • Unreplied
    • Popular
    • GitHub
    • Docu
    • Hilfe
    1. Home
    2. Русский
    3. ioBroker
    4. Ошибка
    5. ioBroker ошибки
    6. Ошибки драйвера SQL

    NEWS

    • Neuer Blog: Fotos und Eindrücke aus Solingen

    • ioBroker@Smart Living Forum Solingen, 14.06. - Agenda added

    • ioBroker goes Matter ... Matter Adapter in Stable

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

    This topic has been deleted. Only users with topic management privileges can see it.
    • D
      DAndre last edited by

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

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

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

      1 Reply Last reply Reply Quote 0
      • H
        Haus last edited by

        @DAndre:

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

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

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

        1 Reply Last reply Reply Quote 0
        • D
          DAndre last edited by

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

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

          1 Reply Last reply Reply Quote 0
          • F
            ford7 last edited by

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

            ! ````
            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)
            1 Reply Last reply Reply Quote 0
            • S
              spectrekr last edited by

              Аналогично, сегодня посыпались.

              ! 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'

              1 Reply Last reply Reply Quote 0
              • Bluefox
                Bluefox last edited by

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

                1 Reply Last reply Reply Quote 0
                • S
                  spectrekr last edited by

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

                  1 Reply Last reply Reply Quote 0
                  • H
                    Haus last edited by

                    SQL Hystory 0.1.2 MySQL

                    1 Reply Last reply Reply Quote 0
                    • R
                      RDim last edited by

                      Подключен к удаленному серверу MySQL 5.5.47 на debian 7.9, cubieboard.

                      ioBroker на debian 8.3 , cubietruck.

                      Полет отличный, ошибок MySQL не замечено.

                      1 Reply Last reply Reply Quote 0
                      • S
                        spectrekr last edited by

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

                        1 Reply Last reply Reply Quote 0
                        • F
                          ford7 last edited by

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

                          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

                          1 Reply Last reply Reply Quote 0
                          • E
                            electric last edited by

                            @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

                            1 Reply Last reply Reply Quote 0
                            • Bluefox
                              Bluefox last edited by

                              @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го опубликую. Или попробуйте с гита

                              1 Reply Last reply Reply Quote 0
                              • F
                                ford7 last edited by

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

                                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
                                1 Reply Last reply Reply Quote 0
                                • Bluefox
                                  Bluefox last edited by

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

                                  1 Reply Last reply Reply Quote 0
                                  • E
                                    electric last edited by

                                    @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 !

                                    1 Reply Last reply Reply Quote 0
                                    • I
                                      instalator last edited by

                                      при попвтке обновится до 1.4.0.

                                      В итоге не обновляется

                                      ! ````
                                      $ ./iobroker upgrade sql
                                      host.Server-PC Adapter "system.adapter.sql.0" is stopped.
                                      npm install iobroker.sql --production --prefix "C:/ioBroker" (System call)
                                      npm

                                      WARN

                                      deprecated
                                      node-uuid@1.4.7: use uuid module instead
                                      gyp

                                      ERR!

                                      configure error

                                      gyp

                                      ERR!

                                      stack
                                      Error: Can't find Python executable "python", you can set the PYTHON env variable.
                                      gyp

                                      ERR!

                                      stack
                                      at failNoPython (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:449:14)
                                      gyp

                                      ERR!

                                      stack
                                      at C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:404:11
                                      gyp

                                      ERR!

                                      stack
                                      at FSReqWrap.oncomplete (fs.js:82:15)
                                      gyp

                                      ERR!

                                      System
                                      Windows_NT 6.1.7601
                                      gyp

                                      ERR!

                                      command
                                      "C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" "rebuild"
                                      gyp

                                      ERR!

                                      cwd
                                      C:\ioBroker\node_modules\iobroker.sql\node_modules\sql-client\node_modules\inote-util\node_modules\mmmagic
                                      gyp

                                      ERR!

                                      node -v
                                      v4.6.2
                                      gyp

                                      ERR!

                                      node-gyp -v
                                      v3.4.0
                                      gyp

                                      ERR!

                                      not ok

                                      node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.8/node-v46-win32-ia32.tar.gz node-pre-gyp ERR! Pre-built binaries not found for sqlite3@3.1.8 and node@4.6.2 (node-v46 ABI) (falling back to source compile with node-gyp)

                                      ! gyp

                                      ERR!

                                      configure error

                                      gyp

                                      ERR!

                                      stack
                                      Error: Can't find Python executable "python", you can set the PYTHON env variable.
                                      gyp

                                      ERR!

                                      stack
                                      at failNoPython (C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:449:14)
                                      gyp

                                      ERR!

                                      stack
                                      at C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\lib\configure.js:404:11
                                      gyp

                                      ERR!

                                      stack
                                      at FSReqWrap.oncomplete (fs.js:82:15)
                                      gyp

                                      ERR!

                                      System
                                      Windows_NT 6.1.7601
                                      gyp

                                      ERR!

                                      command
                                      "C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\node_modules\node-gyp\bin\node-gyp.js" "configure" "--fallback-to-build" "--module=C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\lib\binding\node-v46-win32-ia32\node_sqlite3.node" "--module_name=node_sqlite3" "--module_path=C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\lib\binding\node-v46-win32-ia32"
                                      gyp

                                      ERR!

                                      cwd
                                      C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3
                                      gyp

                                      ERR!

                                      node -v
                                      v4.6.2
                                      gyp

                                      ERR!

                                      node-gyp -v
                                      v3.4.0
                                      gyp

                                      ERR!

                                      not ok

                                      node-pre-gyp

                                      ERR!

                                      build error

                                      node-pre-gyp

                                      ERR!

                                      stack
                                      Error: Failed to execute 'node-gyp.cmd configure --fallback-to-build --module=C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\lib\binding\node-v46-win32-ia32\node_sqlite3.node --module_name=node_sqlite3 --module_path=C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\lib\binding\node-v46-win32-ia32' (1)
                                      node-pre-gyp

                                      ERR!

                                      stack
                                      at ChildProcess. <anonymous>(C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\node_modules\node-pre-gyp\lib\util\compile.js:83:29)
                                      node-pre-gyp

                                      ERR!

                                      stack
                                      at emitTwo (events.js:87:13)
                                      node-pre-gyp

                                      ERR!

                                      stack
                                      at ChildProcess.emit (events.js:172:7)
                                      node-pre-gyp

                                      ERR!

                                      stack
                                      at maybeClose (internal/child_process.js:854:16)
                                      node-pre-gyp

                                      ERR!

                                      stack
                                      at Process.ChildProcess._handle.onexit (internal/child_process.js:222:5)
                                      node-pre-gyp

                                      ERR!

                                      System
                                      Windows_NT 6.1.7601
                                      node-pre-gyp

                                      ERR!

                                      command
                                      "C:\Program Files\nodejs\node.exe" "C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3\node_modules\node-pre-gyp\bin\node-pre-gyp" "install" "--fallback-to-build"
                                      node-pre-gyp

                                      ERR!

                                      cwd
                                      C:\ioBroker\node_modules\iobroker.sql\node_modules\sqlite3
                                      node-pre-gyp

                                      ERR!

                                      node -v
                                      v4.6.2
                                      node-pre-gyp

                                      ERR!

                                      node-pre-gyp -v
                                      v0.6.31
                                      node-pre-gyp

                                      ERR!

                                      not ok

                                      npm

                                      WARN

                                      optional dep failed, continuing
                                      sqlite3@3.1.8
                                      npm

                                      ERR!
                                      Windows_NT 6.1.7601
                                      npm

                                      ERR!

                                      argv
                                      "C:\Program Files\nodejs\node.exe" "C:\Program Files\nodejs\node_modules\npm\bin\npm-cli.js" "install" "iobroker.sql" "--production" "--prefix" "C:/ioBroker"
                                      npm

                                      ERR!

                                      node
                                      v4.6.2
                                      npm

                                      ERR!

                                      npm
                                      v2.15.11
                                      npm

                                      ERR!

                                      code
                                      ELIFECYCLE

                                      ! npm

                                      ERR!
                                      mmmagic@0.4.5 install: node-gyp rebuild
                                      npm

                                      ERR!
                                      Exit status 1
                                      npm

                                      ERR!

                                      npm

                                      ERR!
                                      Failed at the mmmagic@0.4.5 install script 'node-gyp rebuild'.
                                      npm

                                      ERR!
                                      This is most likely a problem with the mmmagic package,
                                      npm

                                      ERR!
                                      not with npm itself.
                                      npm

                                      ERR!
                                      Tell the author that this fails on your system:
                                      npm

                                      ERR!
                                      node-gyp rebuild
                                      npm

                                      ERR!
                                      You can get information on how to open an issue for this project with:
                                      npm

                                      ERR!
                                      npm bugs mmmagic
                                      npm

                                      ERR!
                                      Or if that isn't available, you can get their info via:
                                      npm

                                      ERR!

                                      npm

                                      ERR!
                                      npm owner ls mmmagic
                                      npm

                                      ERR!
                                      There is likely additional logging output above.

                                      ! npm

                                      ERR!
                                      Please include the following file with any support request:
                                      npm

                                      ERR!
                                      C:\ioBroker\node_modules\iobroker\npm-debug.log
                                      ERROR: host.Server-PC Cannot install iobroker.sql: 1
                                      ERROR: process exited with code 25</anonymous>

                                      1 Reply Last reply Reply Quote 0
                                      • sigma
                                        sigma last edited by

                                        SQL History 1.5.6. Коннект к внешнему серверу PostgreSQL.

                                        В логе постоянно сыпятся ошибки:

                                        sql.0	2017-10-04 10:41:45.719	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898623, 'Subscribe [Equipment/Relays/R0045]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:45.499	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898620, 'Subscribe [Equipment/Relays/R0040]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:45.467	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898619, 'Subscribe [Equipment/Relays/R0037]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:45.151	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898611, 'Subscribe [Equipment/Relays/R0029]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:45.149	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898610, 'Subscribe [Equipment/Relays/R0028]', true, 1, 0);: error: duplicate key value violates unique constraint "ts
sql.0	2017-10-04 10:41:44.944	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898603, 'Subscribe [Equipment/Buttons/B0017]', true, 1, 0);: error: duplicate key value violates unique constraint "t
sql.0	2017-10-04 10:41:44.890	error	Cannot insert INSERT INTO ts_string (id, ts, val, ack, _from, q) VALUES(1, 1507102898602, 'Subscribe [Equipment/Buttons/B0016]', true, 1, 0);: error: duplicate key value violates unique constraint "t

                                        Каким образом он умудряется выдать две записи в 1 мс?

                                        1 Reply Last reply Reply Quote 0
                                        • Bluefox
                                          Bluefox last edited by

                                          Настрой Минимальный интервал

                                          1 Reply Last reply Reply Quote 0
                                          • F
                                            ford7 last edited by

                                            Периодически слетает настройка истории в sql (активно) только для данной переменной.

                                            Подскажите, что бы это значило?
                                            256_sql1.jpg

                                            1 Reply Last reply Reply Quote 0
                                            • First post
                                              Last post

                                            Support us

                                            ioBroker
                                            Community Adapters
                                            Donate

                                            777
                                            Online

                                            31.8k
                                            Users

                                            80.0k
                                            Topics

                                            1.3m
                                            Posts

                                            9
                                            24
                                            9446
                                            Loading More Posts
                                            • Oldest to Newest
                                            • Newest to Oldest
                                            • Most Votes
                                            Reply
                                            • Reply as topic
                                            Log in to reply
                                            Community
                                            Impressum | Datenschutz-Bestimmungen | Nutzungsbedingungen
                                            The ioBroker Community 2014-2023
                                            logo