Wb-mqtt-db не корректно выполняет ротацию данных

Программное обеспечение
1

Добрый вечер!
Сегодня хотел посмотреть исторические данные на контроллере, но смог получить только за последние пол дня. Раньше отображался месяц, может больше. Запускал давно.

ps -aux | grep wb-mqtt-db
root       518  0.0  2.0  18176 10620 ?        S    Mar07  60:03 /usr/bin/wb-mqtt-db -c /etc/wb-mqtt-db.conf
cat /etc/wb-mqtt-db.conf 
{
    "database": "/mnt/data/meters.db",
    "debug": false,
    "groups": [
        {
            "channels": [
                "0x00158d00010dd4d7/+",
                "0x00158d00044f6119/+"
            ],
            "min_interval": 120,
            "min_unchanged_interval": 1200,
            "name": "all",
            "values": 10000,
            "values_total": 100000
        }
    ]
}

Файл базы данных:
meters.db.tar.gz (48.4 КБ)

Версия wb-mqtt-db 1.7.3

grep wb-mqtt-db /var/log/messages 
Jun 27 06:25:37 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 06:25:37.865 NOTICE: Bulk processing took 41ms
Jun 27 06:32:09 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 06:32:09.111 NOTICE: Bulk processing took 40ms
Jun 27 06:34:09 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 06:34:09.150 NOTICE: Bulk processing took 53ms
Jun 27 06:38:52 wirenboard-AFSX6O7W user.warn wb-mqtt-db[518]: 2021-06-27 06:38:52.533 WARN: Channel data limit is reached: channel 0x00158d00044f6119/battery, row count 10201, limit 10000
Jun 27 06:38:53 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 06:38:53.430 NOTICE: Bulk processing took 1067ms
Jun 27 06:42:40 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 06:42:40.683 NOTICE: Bulk processing took 36ms
Jun 27 06:44:40 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 06:44:40.739 NOTICE: Bulk processing took 42ms
Jun 27 06:46:56 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 06:46:56.430 NOTICE: Bulk processing took 41ms
Jun 27 06:48:56 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 06:48:56.435 NOTICE: Bulk processing took 37ms
Jun 27 06:51:18 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 06:51:18.373 NOTICE: Bulk processing took 36ms
Jun 27 06:53:18 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 06:53:18.415 NOTICE: Bulk processing took 47ms
Jun 27 06:56:18 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 06:56:18.356 NOTICE: Bulk processing took 36ms
Jun 27 06:58:18 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 06:58:18.380 NOTICE: Bulk processing took 52ms
Jun 27 07:00:18 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 07:00:18.410 NOTICE: Bulk processing took 52ms
Jun 27 07:19:05 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 07:19:05.425 NOTICE: Bulk processing took 37ms
Jun 27 07:21:05 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 07:21:05.455 NOTICE: Bulk processing took 47ms
Jun 27 07:24:17 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 07:24:17.173 NOTICE: Bulk processing took 33ms
Jun 27 07:26:17 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 07:26:17.209 NOTICE: Bulk processing took 37ms
Jun 27 07:39:50 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 07:39:50.025 NOTICE: Bulk processing took 35ms
Jun 27 07:41:50 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 07:41:50.040 NOTICE: Bulk processing took 49ms
Jun 27 07:43:56 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 07:43:56.480 NOTICE: Bulk processing took 41ms
Jun 27 07:45:56 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 07:45:56.492 NOTICE: Bulk processing took 43ms
Jun 27 07:47:56 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 07:47:56.508 NOTICE: Bulk processing took 46ms
Jun 27 07:49:56 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 07:49:56.522 NOTICE: Bulk processing took 54ms
Jun 27 07:51:56 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 07:51:56.524 NOTICE: Bulk processing took 46ms
Jun 27 07:54:33 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 07:54:33.518 NOTICE: Bulk processing took 38ms
Jun 27 07:56:33 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 07:56:33.569 NOTICE: Bulk processing took 46ms
Jun 27 07:58:33 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 07:58:33.617 NOTICE: Bulk processing took 48ms
Jun 27 08:01:04 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 08:01:04.805 NOTICE: Bulk processing took 32ms
Jun 27 08:03:04 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 08:03:04.861 NOTICE: Bulk processing took 72ms
Jun 27 08:05:04 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 08:05:04.835 NOTICE: Bulk processing took 32ms
Jun 27 08:07:16 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 08:07:16.071 NOTICE: Bulk processing took 36ms
Jun 27 08:09:16 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 08:09:16.098 NOTICE: Bulk processing took 39ms
Jun 27 08:11:16 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 08:11:16.135 NOTICE: Bulk processing took 47ms
Jun 27 08:14:42 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 08:14:42.491 NOTICE: Bulk processing took 38ms
Jun 27 08:16:42 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 08:16:42.567 NOTICE: Bulk processing took 58ms
Jun 27 08:22:58 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 08:22:58.834 NOTICE: Bulk processing took 36ms
Jun 27 08:24:59 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 08:24:59.272 NOTICE: Bulk processing took 459ms
Jun 27 08:33:30 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 08:33:30.443 NOTICE: Bulk processing took 50ms
Jun 27 08:35:30 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 08:35:30.466 NOTICE: Bulk processing took 36ms
Jun 27 08:38:30 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 08:38:30.511 NOTICE: Bulk processing took 39ms
Jun 27 08:40:30 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 08:40:30.549 NOTICE: Bulk processing took 49ms
Jun 27 08:44:59 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 08:44:59.802 NOTICE: Bulk processing took 64ms
Jun 27 08:55:58 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 08:55:58.431 NOTICE: Bulk processing took 40ms
Jun 27 08:57:58 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 08:57:58.453 NOTICE: Bulk processing took 54ms
Jun 27 09:04:59 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 09:04:59.892 NOTICE: Bulk processing took 38ms
Jun 27 09:08:55 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 09:08:55.948 NOTICE: Bulk processing took 35ms
Jun 27 09:10:55 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 09:10:55.960 NOTICE: Bulk processing took 42ms
Jun 27 09:25:00 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 09:25:00.023 NOTICE: Bulk processing took 44ms
Jun 27 09:27:33 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 09:27:33.649 NOTICE: Bulk processing took 39ms
Jun 27 09:29:33 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 09:29:33.686 NOTICE: Bulk processing took 49ms
Jun 27 09:32:08 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 09:32:08.431 NOTICE: Bulk processing took 37ms
Jun 27 09:34:08 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 09:34:08.462 NOTICE: Bulk processing took 58ms
Jun 27 09:40:31 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 09:40:31.379 NOTICE: Bulk processing took 35ms
Jun 27 09:42:31 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 09:42:31.453 NOTICE: Bulk processing took 63ms
Jun 27 09:45:00 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 09:45:00.508 NOTICE: Bulk processing took 51ms
Jun 27 09:47:32 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 09:47:32.582 NOTICE: Bulk processing took 41ms
Jun 27 09:49:32 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 09:49:32.624 NOTICE: Bulk processing took 37ms
Jun 27 09:51:32 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 09:51:32.635 NOTICE: Bulk processing took 44ms
Jun 27 09:54:58 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 09:54:58.784 NOTICE: Bulk processing took 35ms
Jun 27 09:56:58 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 09:56:58.795 NOTICE: Bulk processing took 37ms
Jun 27 10:01:04 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:01:04.852 NOTICE: Bulk processing took 40ms
Jun 27 10:03:04 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:03:04.922 NOTICE: Bulk processing took 93ms
Jun 27 10:05:04 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:05:04.899 NOTICE: Bulk processing took 58ms
Jun 27 10:08:26 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:08:26.091 NOTICE: Bulk processing took 40ms
Jun 27 10:10:26 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:10:26.133 NOTICE: Bulk processing took 47ms
Jun 27 10:15:27 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:15:27.303 NOTICE: Bulk processing took 39ms
Jun 27 10:17:27 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:17:27.335 NOTICE: Bulk processing took 37ms
Jun 27 10:19:27 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:19:27.382 NOTICE: Bulk processing took 51ms
Jun 27 10:22:34 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:22:34.982 NOTICE: Bulk processing took 43ms
Jun 27 10:24:35 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:24:35.023 NOTICE: Bulk processing took 37ms
Jun 27 10:26:35 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:26:35.081 NOTICE: Bulk processing took 56ms
Jun 27 10:32:21 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:32:21.437 NOTICE: Bulk processing took 34ms
Jun 27 10:34:21 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:34:21.469 NOTICE: Bulk processing took 51ms
Jun 27 10:38:37 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:38:37.541 NOTICE: Bulk processing took 37ms
Jun 27 10:40:37 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:40:37.603 NOTICE: Bulk processing took 52ms
Jun 27 10:45:49 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:45:49.009 NOTICE: Bulk processing took 275ms
Jun 27 10:47:48 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:47:48.834 NOTICE: Bulk processing took 57ms
Jun 27 10:53:45 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:53:45.144 NOTICE: Bulk processing took 39ms
Jun 27 10:55:45 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:55:45.218 NOTICE: Bulk processing took 60ms
Jun 27 10:57:45 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 10:57:45.229 NOTICE: Bulk processing took 38ms
Jun 27 11:04:41 wirenboard-AFSX6O7W user.warn wb-mqtt-db[518]: 2021-06-27 11:04:41.961 WARN: Channel data limit is reached: channel 0x00158d00044f6119/last_seen, row count 10201, limit 10000
Jun 27 11:04:42 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 11:04:42.015 NOTICE: Bulk processing took 118ms
Jun 27 11:06:41 wirenboard-AFSX6O7W user.warn wb-mqtt-db[518]: 2021-06-27 11:06:41.970 WARN: Channel data limit is reached: channel 0x00158d00044f6119/temperature, row count 10201, limit 10000
Jun 27 11:06:42 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 11:06:42.022 NOTICE: Bulk processing took 82ms
Jun 27 11:08:42 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 11:08:42.031 NOTICE: Bulk processing took 60ms
Jun 27 11:12:43 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 11:12:43.304 NOTICE: Bulk processing took 32ms
Jun 27 11:14:43 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 11:14:43.361 NOTICE: Bulk processing took 38ms
Jun 27 11:16:43 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 11:16:43.391 NOTICE: Bulk processing took 56ms
Jun 27 11:28:42 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 11:28:42.326 NOTICE: Bulk processing took 58ms
Jun 27 11:32:07 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 11:32:07.144 NOTICE: Bulk processing took 30ms
Jun 27 11:34:07 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 11:34:07.171 NOTICE: Bulk processing took 42ms
Jun 27 11:48:43 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 11:48:43.264 NOTICE: Bulk processing took 48ms
Jun 27 11:53:00 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 11:53:00.442 NOTICE: Bulk processing took 34ms
Jun 27 11:55:00 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 11:55:00.459 NOTICE: Bulk processing took 41ms
Jun 27 12:03:47 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 12:03:47.264 NOTICE: Bulk processing took 35ms
Jun 27 12:05:47 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 12:05:47.313 NOTICE: Bulk processing took 56ms
Jun 27 12:08:43 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 12:08:43.426 NOTICE: Bulk processing took 45ms
Jun 27 12:33:02 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 12:33:02.332 NOTICE: Bulk processing took 35ms
Jun 27 12:35:02 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 12:35:02.369 NOTICE: Bulk processing took 64ms
Jun 27 12:53:02 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 12:53:02.755 NOTICE: Bulk processing took 50ms
Jun 27 12:57:25 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 12:57:25.744 NOTICE: Bulk processing took 32ms
Jun 27 12:59:25 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 12:59:25.793 NOTICE: Bulk processing took 44ms
Jun 27 13:02:36 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:02:36.996 NOTICE: Bulk processing took 44ms
Jun 27 13:04:37 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:04:37.036 NOTICE: Bulk processing took 38ms
Jun 27 13:12:54 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:12:54.299 NOTICE: Bulk processing took 45ms
Jun 27 13:14:54 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:14:54.328 NOTICE: Bulk processing took 67ms
Jun 27 13:24:26 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:24:26.147 NOTICE: Bulk processing took 31ms
Jun 27 13:26:26 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:26:26.188 NOTICE: Bulk processing took 39ms
Jun 27 13:28:26 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:28:26.226 NOTICE: Bulk processing took 48ms
Jun 27 13:30:26 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:30:26.248 NOTICE: Bulk processing took 39ms
Jun 27 13:32:26 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:32:26.250 NOTICE: Bulk processing took 36ms
Jun 27 13:34:33 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:34:33.607 NOTICE: Bulk processing took 34ms
Jun 27 13:36:33 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:36:33.664 NOTICE: Bulk processing took 54ms
Jun 27 13:38:33 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:38:33.696 NOTICE: Bulk processing took 43ms
Jun 27 13:41:30 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:41:30.092 NOTICE: Bulk processing took 35ms
Jun 27 13:43:30 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:43:30.149 NOTICE: Bulk processing took 56ms
Jun 27 13:45:30 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:45:30.765 NOTICE: Bulk processing took 656ms
Jun 27 13:49:11 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:49:11.748 NOTICE: Bulk processing took 36ms
Jun 27 13:51:11 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:51:11.773 NOTICE: Bulk processing took 47ms
Jun 27 13:53:11 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:53:11.784 NOTICE: Bulk processing took 36ms
Jun 27 13:55:11 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:55:11.802 NOTICE: Bulk processing took 36ms
Jun 27 13:57:11 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 13:57:11.814 NOTICE: Bulk processing took 45ms
Jun 27 14:01:50 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:01:50.115 NOTICE: Bulk processing took 37ms
Jun 27 14:03:50 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:03:50.117 NOTICE: Bulk processing took 39ms
Jun 27 14:07:31 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:07:31.252 NOTICE: Bulk processing took 43ms
Jun 27 14:09:31 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:09:31.290 NOTICE: Bulk processing took 45ms
Jun 27 14:13:17 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:13:17.457 NOTICE: Bulk processing took 35ms
Jun 27 14:15:17 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:15:17.483 NOTICE: Bulk processing took 37ms
Jun 27 14:17:17 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:17:17.521 NOTICE: Bulk processing took 58ms
Jun 27 14:22:29 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:22:29.191 NOTICE: Bulk processing took 32ms
Jun 27 14:24:29 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:24:29.243 NOTICE: Bulk processing took 45ms
Jun 27 14:27:50 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:27:50.335 NOTICE: Bulk processing took 48ms
Jun 27 14:29:50 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:29:50.379 NOTICE: Bulk processing took 40ms
Jun 27 14:34:16 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:34:16.619 NOTICE: Bulk processing took 35ms
Jun 27 14:36:16 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:36:16.640 NOTICE: Bulk processing took 47ms
Jun 27 14:38:16 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:38:16.640 NOTICE: Bulk processing took 36ms
Jun 27 14:40:16 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:40:16.677 NOTICE: Bulk processing took 48ms
Jun 27 14:45:59 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:45:59.081 NOTICE: Bulk processing took 36ms
Jun 27 14:47:59 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:47:59.117 NOTICE: Bulk processing took 67ms
Jun 27 14:51:34 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:51:34.082 NOTICE: Bulk processing took 34ms
Jun 27 14:53:34 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:53:34.123 NOTICE: Bulk processing took 43ms
Jun 27 14:55:34 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:55:34.170 NOTICE: Bulk processing took 57ms
Jun 27 14:58:17 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 14:58:17.280 NOTICE: Bulk processing took 66ms
Jun 27 15:07:54 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 15:07:54.003 NOTICE: Bulk processing took 35ms
Jun 27 15:09:54 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 15:09:54.031 NOTICE: Bulk processing took 63ms
Jun 27 15:18:17 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 15:18:17.651 NOTICE: Bulk processing took 39ms
Jun 27 15:20:17 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 15:20:17.669 NOTICE: Bulk processing took 42ms
Jun 27 15:38:18 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 15:38:18.099 NOTICE: Bulk processing took 55ms
Jun 27 15:43:45 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 15:43:45.754 NOTICE: Bulk processing took 32ms
Jun 27 15:45:45 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 15:45:45.799 NOTICE: Bulk processing took 37ms
Jun 27 15:47:45 wirenboard-AFSX6O7W user.warn wb-mqtt-db[518]: 2021-06-27 15:47:45.838 WARN: Channel data limit is reached: channel 0x00158d00044f6119/linkquality, row count 10201, limit 10000
Jun 27 15:47:46 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 15:47:46.512 NOTICE: Bulk processing took 709ms
Jun 27 15:49:45 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 15:49:45.884 NOTICE: Bulk processing took 35ms
Jun 27 15:58:18 wirenboard-AFSX6O7W user.warn wb-mqtt-db[518]: 2021-06-27 15:58:18.462 WARN: Channel data limit is reached: channel 0x00158d00044f6119/voltage, row count 10201, limit 10000
Jun 27 15:58:18 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 15:58:18.516 NOTICE: Bulk processing took 78ms
Jun 27 16:28:45 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:28:45.186 NOTICE: Bulk processing took 54ms
Jun 27 16:30:45 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:30:45.232 NOTICE: Bulk processing took 56ms
Jun 27 16:37:11 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:37:11.930 NOTICE: Bulk processing took 35ms
Jun 27 16:39:11 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:39:11.960 NOTICE: Bulk processing took 52ms
Jun 27 16:39:14 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:39:14.094 NOTICE: Run RPC get_channels()
Jun 27 16:39:14 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:39:14.098 NOTICE: RPC request took 3ms
Jun 27 16:39:24 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:39:24.296 NOTICE: Run RPC get_channels()
Jun 27 16:39:24 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:39:24.299 NOTICE: RPC request took 1ms
Jun 27 16:39:24 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:39:24.302 NOTICE: Run RPC get_values()
Jun 27 16:39:24 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:39:24.315 NOTICE: get_values() took 12ms
Jun 27 16:39:43 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:39:43.354 NOTICE: Run RPC get_channels()
Jun 27 16:39:43 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:39:43.356 NOTICE: RPC request took 1ms
Jun 27 16:39:43 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:39:43.363 NOTICE: Run RPC get_values()
Jun 27 16:39:43 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:39:43.376 NOTICE: get_values() took 11ms
Jun 27 16:39:49 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:39:49.288 NOTICE: Run RPC get_channels()
Jun 27 16:39:49 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:39:49.291 NOTICE: RPC request took 2ms
Jun 27 16:39:49 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:39:49.299 NOTICE: Run RPC get_values()
Jun 27 16:39:49 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:39:49.331 NOTICE: get_values() took 29ms
Jun 27 16:40:06 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:40:06.654 NOTICE: Run RPC get_channels()
Jun 27 16:40:06 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:40:06.656 NOTICE: RPC request took 1ms
Jun 27 16:40:06 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:40:06.660 NOTICE: Run RPC get_values()
Jun 27 16:40:06 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:40:06.662 NOTICE: get_values() took 1ms
Jun 27 16:40:34 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:40:34.368 NOTICE: Run RPC get_channels()
Jun 27 16:40:34 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:40:34.371 NOTICE: RPC request took 1ms
Jun 27 16:40:38 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:40:38.242 NOTICE: Run RPC get_channels()
Jun 27 16:40:38 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:40:38.250 NOTICE: RPC request took 5ms
Jun 27 16:40:38 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:40:38.254 NOTICE: Run RPC get_values()
Jun 27 16:40:38 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:40:38.269 NOTICE: get_values() took 12ms
Jun 27 16:40:48 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:40:48.319 NOTICE: Run RPC get_channels()
Jun 27 16:40:48 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:40:48.322 NOTICE: RPC request took 1ms
Jun 27 16:40:48 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:40:48.326 NOTICE: Run RPC get_values()
Jun 27 16:40:48 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:40:48.335 NOTICE: get_values() took 8ms
Jun 27 16:40:54 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:40:54.680 NOTICE: Run RPC get_channels()
Jun 27 16:40:54 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:40:54.686 NOTICE: RPC request took 4ms
Jun 27 16:40:54 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:40:54.690 NOTICE: Run RPC get_values()
Jun 27 16:40:54 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:40:54.712 NOTICE: get_values() took 20ms
Jun 27 16:41:11 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:41:11.967 NOTICE: Bulk processing took 54ms
Jun 27 16:44:59 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:44:59.355 NOTICE: Bulk processing took 47ms
Jun 27 16:46:59 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:46:59.372 NOTICE: Bulk processing took 60ms
Jun 27 16:48:59 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 16:48:59.367 NOTICE: Bulk processing took 52ms
Jun 27 17:24:28 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:24:28.947 NOTICE: Bulk processing took 43ms
Jun 27 17:26:28 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:26:28.967 NOTICE: Bulk processing took 37ms
Jun 27 17:28:53 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:28:53.613 NOTICE: Run RPC get_channels()
Jun 27 17:28:53 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:28:53.617 NOTICE: RPC request took 2ms
Jun 27 17:29:00 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:29:00.386 NOTICE: Run RPC get_channels()
Jun 27 17:29:00 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:29:00.390 NOTICE: RPC request took 2ms
Jun 27 17:29:00 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:29:00.396 NOTICE: Run RPC get_values()
Jun 27 17:29:00 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:29:00.406 NOTICE: get_values() took 8ms
Jun 27 17:29:11 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:29:11.467 NOTICE: Run RPC get_channels()
Jun 27 17:29:11 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:29:11.475 NOTICE: RPC request took 6ms
Jun 27 17:29:11 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:29:11.480 NOTICE: Run RPC get_values()
Jun 27 17:29:11 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:29:11.490 NOTICE: get_values() took 8ms
Jun 27 17:29:16 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:29:16.767 NOTICE: Run RPC get_channels()
Jun 27 17:29:16 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:29:16.771 NOTICE: RPC request took 2ms
Jun 27 17:29:16 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:29:16.787 NOTICE: Run RPC get_values()
Jun 27 17:29:16 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:29:16.793 NOTICE: get_values() took 4ms
Jun 27 17:30:35 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:30:35.953 NOTICE: Run RPC get_channels()
Jun 27 17:30:35 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:30:35.959 NOTICE: RPC request took 2ms
Jun 27 17:30:35 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:30:35.963 NOTICE: Run RPC get_values()
Jun 27 17:30:35 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:30:35.976 NOTICE: get_values() took 9ms
Jun 27 17:32:42 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:32:42.624 NOTICE: Bulk processing took 34ms
Jun 27 17:34:42 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:34:42.638 NOTICE: Bulk processing took 42ms
Jun 27 17:36:42 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:36:42.632 NOTICE: Bulk processing took 31ms
Jun 27 17:40:05 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:40:05.264 NOTICE: Bulk processing took 41ms
Jun 27 17:42:05 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:42:05.287 NOTICE: Bulk processing took 39ms
Jun 27 17:44:29 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:44:29.404 NOTICE: Bulk processing took 102ms
Jun 27 17:57:18 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:57:18.445 NOTICE: Bulk processing took 43ms
Jun 27 17:59:18 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 17:59:18.514 NOTICE: Bulk processing took 74ms
Jun 27 18:04:29 wirenboard-AFSX6O7W user.notice wb-mqtt-db[518]: 2021-06-27 18:04:29.821 NOTICE: Bulk processing took 53ms
3

Проблему воспроизвели, будем исправлять. Пока могу предложить поставить ограничение на группу = 0 ("values_total": 0).

1 лайк
4

Понял. А ограничение по каналам корректно работает?

5

Корректно работает, если установлено только одно из ограничений, одновременно - нет.

6

Аналогичная проблема. Найдено ли решение?
“values_total”: 0 - не помогает.

release wb-2201 (as stable)
Linux wirenboard 4.9.22-wb1 #2 Thu May 20 15:58:00 UTC 2021 armv5tejl G NU/Linux

root@wirenboard:/etc# service wb-mqtt-db status
● wb-mqtt-db.service - LSB: : Wiren Board database logger
Loaded: loaded (/etc/init.d/wb-mqtt-db; generated; vendor preset: enabled)
Active: active (running) since Sat 2022-05-07 11:59:40 UTC; 20min ago
Docs: man:systemd-sysv-generator(8)
Process: 3952 ExecStop=/etc/init.d/wb-mqtt-db stop (code=exited, status=0/SUCCESS)
Process: 3966 ExecStart=/etc/init.d/wb-mqtt-db start (code=exited, status=0/SUCCESS)
CGroup: /system.slice/wb-mqtt-db.service
└─3976 /usr/bin/wb-mqtt-db -c /etc/wb-mqtt-db.conf

May 07 12:01:42 wirenboard wb-mqtt-db[3976]: 2022-05-07 12:01:42.299 NOTICE: Bulk processing took 77ms
May 07 12:03:42 wirenboard wb-mqtt-db[3976]: 2022-05-07 12:03:42.304 NOTICE: Bulk processing took 82ms
May 07 12:05:42 wirenboard wb-mqtt-db[3976]: 2022-05-07 12:05:42.296 NOTICE: Bulk processing took 74ms
May 07 12:07:42 wirenboard wb-mqtt-db[3976]: 2022-05-07 12:07:42.302 NOTICE: Bulk processing took 80ms
May 07 12:09:42 wirenboard wb-mqtt-db[3976]: 2022-05-07 12:09:42.295 NOTICE: Bulk processing took 72ms

7

А сколько записей в БД?
Какое ограничение по количеству?

8

Как посмотреть фактический размер БД? В мегабайтах сейчас меньше 2.

Конфиг такой:

{
“debug”: false,
“database” : “/var/lib/wirenboard/db/data.db”,

"groups": [
    {
        "name": "all",
        "channels" : ["+/+"],
        "values" : 10000,
        "values_total" : 0,
        "min_interval" : 120,
        "min_unchanged_interval" : 1200
    }
]

}

Интересно другое, по какой причине полез в логи. Через некоторое время после старта (меньше суток) отваливается всё в вебке, даже исчезает кнопка Reboot, датчик температуры и пр. Правила работают (кнопки, по крайней мере). Причины непонятны.

9

количество записей получается довольно просто: Как можно оптимизировать wb-mqtt-db? - #2 от пользователя BrainRoot

“отваливается” - это какаие-то ошибки? В mqtt топики есть и не выводятся? покажите топик, того же виртуального устройства с кнопкой reboor.

10

Меньше 60 тысяч записей сейчас. Ошибка Bulk присутствует раз в несколько минут.

Удалил-установил serial, конфиги не менял, пару дней без “отваливания”.

Нет, если отваливается, то исчезает из mqtt и devices.
Встречаются еще такие ошибки изредка:

wb-mqtt-db[636]: 2022-05-09 03:13:56.555 NOTICE: Run RPC get_values()
wb-mqtt-db[636]: 2022-05-09 03:13:56.861 NOTICE: get_values() took 279ms

image
image1322×57 2.21 KB

image

И при загрузке:

wb-hwconf-manager[352]: :12.4-17: Warning (reg_format): /fragment/overlay/extio1_wbio_di_wd_14@27:reg: property has invalid length (4 bytes) (#address-cells == 2, #size-cells == 1)
wb-hwconf-manager[352]: : Warning (pci_device_reg): Failed prerequisite ‘reg_format’
wb-hwconf-manager[352]: : Warning (pci_device_bus_num): Failed prerequisite ‘reg_format’
wb-hwconf-manager[352]: : Warning (simple_bus_reg): Failed prerequisite ‘reg_format’
wb-hwconf-manager[352]: : Warning (i2c_bus_reg): Failed prerequisite ‘reg_format’
wb-hwconf-manager[352]: : Warning (spi_bus_reg): Failed prerequisite ‘reg_format’
wb-hwconf-manager[352]: :8.27-20.5: Warning (avoid_default_addr_size): /fragment/overlay/extio1_wbio_di_wd_14@27: Relying on default #address-cells value
wb-hwconf-manager[352]: :8.27-20.5: Warning (avoid_default_addr_size): /fragment/overlay/extio1_wbio_di_wd_14@27: Relying on default #size-cells value
wb-hwconf-manager[352]: : Warning (avoid_unnecessary_addr_size): Failed prerequisite ‘avoid_default_addr_size’
wb-hwconf-manager[352]: : Warning (unique_unit_address): Failed prerequisite ‘avoid_default_addr_size’

11

Ошибка? Почему же? notice зачем относить к ошибкам?

Покажите, что именно исчезает. Не видя как и что происходит я не могу составить представление…

12

Спасибо за попытку помочь. Ошибка исчезла после удаления wb-serial и wb-rules и установки повторно. Конфиги при этом старые остались. Падений с тех пор не было.