DB timeouts in logs

[pbertra]

Looking at the logs of the teslalogger_database_1, i see the following warnings after startup:

Normal startup: 2020-03-26 17:10:12 0 [Note] mysqld (initiated by: unknown): Normal shutdown

2020-03-26 17:10:12 0 [Note] Event Scheduler: Purging the queue. 0 events 2020-03-26 17:10:12 0 [Note] InnoDB: FTS optimize thread exiting. 2020-03-26 17:10:12 0 [Note] InnoDB: Starting shutdown... 2020-03-26 17:10:12 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool 2020-03-26 17:10:12 0 [Note] InnoDB: Buffer pool(s) dump completed at 200326 17:10:12 2020-03-26 17:10:14 0 [Note] InnoDB: Shutdown completed; log sequence number 5323682; transaction id 22849 2020-03-26 17:10:14 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2020-03-26 17:10:14 0 [Note] mysqld: Shutdown complete 2020-03-26 17:10:18 0 [Note] mysqld (mysqld 10.4.7-MariaDB-1:10.4.7+maria bionic) starting as process 1 ... 2020-03-26 17:10:18 0 [Note] InnoDB: Using Linux native AIO 2020-03-26 17:10:18 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2020-03-26 17:10:18 0 [Note] InnoDB: Uses event mutexes 2020-03-26 17:10:18 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2020-03-26 17:10:18 0 [Note] InnoDB: Number of pools: 1 2020-03-26 17:10:18 0 [Note] InnoDB: Using SSE2 crc32 instructions 2020-03-26 17:10:18 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) 2020-03-26 17:10:18 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M 2020-03-26 17:10:18 0 [Note] InnoDB: Completed initialization of buffer pool 2020-03-26 17:10:18 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2020-03-26 17:10:18 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2020-03-26 17:10:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2020-03-26 17:10:18 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2020-03-26 17:10:18 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2020-03-26 17:10:18 0 [Note] InnoDB: Waiting for purge to start 2020-03-26 17:10:18 0 [Note] InnoDB: 10.4.7 started; log sequence number 5323682; transaction id 22851 2020-03-26 17:10:18 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-03-26 17:10:18 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-03-26 17:10:18 0 [Note] Server socket created on IP: '::'. 2020-03-26 17:10:18 0 [Warning] 'proxies_priv' entry '@% root@1f9b34c8f573' ignored in --skip-name-resolve mode. 2020-03-26 17:10:18 0 [Note] Reading of all Master_info entries succeeded 2020-03-26 17:10:18 0 [Note] Added new Master_info '' to hash table 2020-03-26 17:10:18 0 [Note] mysqld: ready for connections. Version: '10.4.7-MariaDB-1:10.4.7+maria~bionic' socket: '/var/run/mysqld/mysqld.sock' port: 3306 mariadb.org binary distribution 2020-03-26 17:10:18 0 [Note] InnoDB: Buffer pool(s) load completed at 200326 17:10:18

Followed by tens of the following warnings (I only included the last two days):

2020-04-12 12:25:06 3196 [Warning] Aborted connection 3196 to db: 'teslalogger' user: 'root' host: '172.19.0.3' (Got timeout reading communication packets), 2020-04-12 12:25:06 3194 [Warning] Aborted connection 3194 to db: 'teslalogger' user: 'root' host: '172.19.0.3' (Got timeout reading communication packets), 2020-04-12 19:35:24 3271 [Warning] Aborted connection 3271 to db: 'teslalogger' user: 'root' host: '172.19.0.3' (Got timeout reading communication packets), 2020-04-12 19:36:35 3272 [Warning] Aborted connection 3272 to db: 'teslalogger' user: 'root' host: '172.19.0.3' (Got timeout reading communication packets), 2020-04-12 20:18:08 3277 [Warning] Aborted connection 3277 to db: 'teslalogger' user: 'root' host: '172.19.0.3' (Got timeout reading communication packets), 2020-04-12 20:18:15 3282 [Warning] Aborted connection 3282 to db: 'teslalogger' user: 'root' host: '172.19.0.3' (Got timeout reading communication packets), 2020-04-12 23:11:00 3291 [Warning] Aborted connection 3291 to db: 'teslalogger' user: 'root' host: '172.19.0.3' (Got timeout reading communication packets), 2020-04-12 23:11:00 3290 [Warning] Aborted connection 3290 to db: 'teslalogger' user: 'root' host: '172.19.0.3' (Got timeout reading communication packets), 2020-04-13 8:50:07 3308 [Warning] Aborted connection 3308 to db: 'teslalogger' user: 'root' host: '172.19.0.3' (Got timeout reading communication packets), 2020-04-13 8:50:07 3306 [Warning] Aborted connection 3306 to db: 'teslalogger' user: 'root' host: '172.19.0.3' (Got timeout reading communication packets), 2020-04-13 10:38:09 3313 [Warning] Aborted connection 3313 to db: 'teslalogger' user: 'root' host: '172.19.0.3' (Got timeout reading communication packets), 2020-04-13 10:38:09 3321 [Warning] Aborted connection 3321 to db: 'teslalogger' user: 'root' host: '172.19.0.3' (Got timeout reading communication packets), 2020-04-13 11:23:48 3341 [Warning] Aborted connection 3341 to db: 'teslalogger' user: 'root' host: '172.19.0.3' (Got timeout reading communication packets), 2020-04-13 11:23:48 3337 [Warning] Aborted connection 3337 to db: 'teslalogger' user: 'root' host: '172.19.0.3' (Got timeout reading communication packets), 2020-04-13 12:41:45 3569 [Warning] Aborted connection 3569 to db: 'teslalogger' user: 'root' host: '172.19.0.3' (Got timeout reading communication packets), 2020-04-13 12:41:45 3566 [Warning] Aborted connection 3566 to db: 'teslalogger' user: 'root' host: '172.19.0.3' (Got timeout reading communication packets), 2020-04-13 14:56:06 3573 [Warning] Aborted connection 3573 to db: 'teslalogger' user: 'root' host: '172.19.0.3' (Got timeout reading communication packets), 2020-04-13 14:56:06 3570 [Warning] Aborted connection 3570 to db: 'teslalogger' user: 'root' host: '172.19.0.3' (Got timeout reading communication packets)

It seems like sometimes the packets are too big for the default config (1MB). But what is causing these large queries?

[bassmaster187]

could you please check the exception folder for more informations: /etc/teslalogger/Exception

[pbertra]

Exception.zip Here are the Exception files