Still having lots of mysql errors

ozy · 2024-10-22T08:01:17+00:00

Hello, Running current gromox-2.35.0.g5b29178-lp155.1.1.x86_64, I still got lots of mysql errors: 2024-10-22 0:12:37 1930 [Warning] Aborted connection 193...

crpb

WalterH wait_timeout=288000

Now that value is just nasty! and i must confess i didn't see it until this moment... o_0..
Will change that to something *sane* everywhere now..

EDIT: and the default is also a bit bonkers (8Hours) https://mariadb.com/kb/en/server-system-variables/#wait_timeout

WalterH

crpb 288000 is 8 hours.

crpb

WalterH 288000 is 8 hours.

remove a zero and i'm with you 😛

echo $((288000/60/60)) $((28800/60/60))

crpb

Anyhow, reduced it to '3600' and watching for anything but i guess this won't affect anything other than not using 80/eighty hours anymore 😛

2024-11-28 20:48:33 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-11-28 20:48:33 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.11.9-MariaDB'  socket: '/run/mysql/mysql.sock'  port: 3306  MariaDB package
2024-11-28 20:48:33 0 [Note] InnoDB: Buffer pool(s) load completed at 241128 20:48:33

───────────────────────────────────────────────────────────────────────
2024-11-28 20:54:56 0 [Note] Added new Master_info '' to hash table
2024-11-28 20:54:56 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.18-MariaDB'  socket: '/run/mysql/mysql.sock'  port: 3306  MariaDB package
2024-11-28 20:54:56 0 [Note] InnoDB: Buffer pool(s) load completed at 241128 20:54:56

───────────────────────────────────────────────────────────────────────
2024-11-28 20:48:26 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-11-28 20:48:26 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.11.9-MariaDB'  socket: '/run/mysql/mysql.sock'  port: 3306  MariaDB package
2024-11-28 20:48:26 0 [Note] InnoDB: Buffer pool(s) load completed at 241128 20:48:26

───────────────────────────────────────────────────────────────────────
2024-11-28 20:54:31 0 [Note] Added new Master_info '' to hash table
2024-11-28 20:54:31 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.18-MariaDB'  socket: '/run/mysql/mysql.sock'  port: 3306  MariaDB package
2024-11-28 20:54:31 0 [Note] InnoDB: Buffer pool(s) load completed at 241128 20:54:31

───────────────────────────────────────────────────────────────────────
2024-11-28 20:48:31 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-11-28 20:48:31 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.18-MariaDB'  socket: '/run/mysql/mysql.sock'  port: 3306  MariaDB package
2024-11-28 20:48:31 0 [Note] InnoDB: Buffer pool(s) load completed at 241128 20:48:31

───────────────────────────────────────────────────────────────────────
2024-11-28 20:48:32 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-11-28 20:48:32 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.11.9-MariaDB'  socket: '/run/mysql/mysql.sock'  port: 3306  MariaDB package
2024-11-28 20:48:32 0 [Note] InnoDB: Buffer pool(s) load completed at 241128 20:48:32

───────────────────────────────────────────────────────────────────────
2024-11-28 20:48:32 0 [Note] InnoDB: Buffer pool(s) load completed at 241128 20:48:32
2024-11-28 20:48:32 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-11-28 20:48:32 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.18-MariaDB'  socket: '/run/mysql/mysql.sock'  port: 3306  MariaDB package

───────────────────────────────────────────────────────────────────────
2024-11-28 20:48:32 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-11-28 20:48:32 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.18-MariaDB'  socket: '/run/mysql/mysql.sock'  port: 3306  MariaDB package
2024-11-28 20:48:32 0 [Note] InnoDB: Buffer pool(s) load completed at 241128 20:48:32

───────────────────────────────────────────────────────────────────────
2024-11-28 20:48:32 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-11-28 20:48:32 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.18-MariaDB'  socket: '/run/mysql/mysql.sock'  port: 3306  MariaDB package
2024-11-28 20:48:32 0 [Note] InnoDB: Buffer pool(s) load completed at 241128 20:48:32

───────────────────────────────────────────────────────────────────────
2024-11-28 20:48:11 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-11-28 20:48:11 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.18-MariaDB'  socket: '/run/mysql/mysql.sock'  port: 3306  MariaDB package
2024-11-28 20:48:11 0 [Note] InnoDB: Buffer pool(s) load completed at 241128 20:48:11

───────────────────────────────────────────────────────────────────────
2024-11-28 20:48:30 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-11-28 20:48:30 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.18-MariaDB'  socket: '/run/mysql/mysql.sock'  port: 3306  MariaDB package
2024-11-28 20:48:31 0 [Note] InnoDB: Buffer pool(s) load completed at 241128 20:48:31

───────────────────────────────────────────────────────────────────────
2024-11-28 20:48:33 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-11-28 20:48:33 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.18-MariaDB'  socket: '/run/mysql/mysql.sock'  port: 3306  MariaDB package
2024-11-28 20:48:33 0 [Note] InnoDB: Buffer pool(s) load completed at 241128 20:48:33

───────────────────────────────────────────────────────────────────────
2024-11-28 20:48:32 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-11-28 20:48:32 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.18-MariaDB'  socket: '/run/mysql/mysql.sock'  port: 3306  MariaDB package
2024-11-28 20:48:32 0 [Note] InnoDB: Buffer pool(s) load completed at 241128 20:48:32

───────────────────────────────────────────────────────────────────────
2024-11-28 20:48:32 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-11-28 20:48:32 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.18-MariaDB'  socket: '/run/mysql/mysql.sock'  port: 3306  MariaDB package
2024-11-28 20:48:32 0 [Note] InnoDB: Buffer pool(s) load completed at 241128 20:48:32

───────────────────────────────────────────────────────────────────────
2024-11-28 20:48:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-11-28 20:48:32 0 [Note] Server socket created on IP: '127.0.0.1'.
2024-11-28 20:48:32 0 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.6.18-MariaDB'  socket: '/run/mysql/mysql.sock'  port: 3306  MariaDB package
2024-11-28 20:48:32 0 [Note] InnoDB: Buffer pool(s) load completed at 241128 20:48:32

WalterH

We will see.

crpb

i additionally activated the following on two test-systems to see which fooding query(id) was actually used to maybe find out where it's coming from.

general_log
general_log_file=/var/log/mysql/mariadb.log

i wouldn't recommend it on a live system 😛

crpb

If you can, set the mysql-stuff to less than 80 hours and here comes the finisher:

disable grommunio-fetchmail.timer if not needed
I again got *hourly* warnings and looked through the timers and that one was just spitting in my eye.

Will see how it behaves during the week but i think we have a winner.

Why this would happen with that timer/service i can't really imagine other than there would be some kind icky leftover state when it's finished and that especially on systems which don't even use fetchmail.
And this would just survive because the admin-api will keep it alive. But that is most likely as a grommunio-admin call does spent some time on talking to it's api as we know :>

WalterH

I guess, this have nothing to do with fetchmail.

I see this errors a random time, here the list from today:

2024-12-02  0:48:51 5998 [Warning] Aborted connection 5998 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-02  1:13:15 6070 [Warning] Aborted connection 6070 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-02  1:48:51 6201 [Warning] Aborted connection 6201 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-02  2:48:51 6415 [Warning] Aborted connection 6415 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-02  3:25:19 6662 [Warning] Aborted connection 6662 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-02  3:27:23 6665 [Warning] Aborted connection 6665 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-02  3:37:47 6695 [Warning] Aborted connection 6695 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-02  3:48:51 6753 [Warning] Aborted connection 6753 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-02  4:48:51 6956 [Warning] Aborted connection 6956 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-02  5:25:36 7066 [Warning] Aborted connection 7066 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-02  5:48:51 7140 [Warning] Aborted connection 7140 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-02  6:48:52 7330 [Warning] Aborted connection 7330 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-02  7:48:52 7558 [Warning] Aborted connection 7558 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-02  8:19:51 7683 [Warning] Aborted connection 7683 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-02  8:21:45 7692 [Warning] Aborted connection 7692 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-02  8:22:44 7990 [Warning] Aborted connection 7990 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got an error reading communication packets)
2024-12-02  8:22:44 7989 [Warning] Aborted connection 7989 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got an error reading communication packets)
2024-12-02  8:43:40 8064 [Warning] Aborted connection 8064 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got an error reading communication packets)
2024-12-02  8:43:40 8063 [Warning] Aborted connection 8063 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got an error reading communication packets)
2024-12-02  8:48:51 7824 [Warning] Aborted connection 7824 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-02  9:24:03 8244 [Warning] Aborted connection 8244 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got an error reading communication packets)
2024-12-02  9:24:03 8243 [Warning] Aborted connection 8243 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got an error reading communication packets)
2024-12-02  9:41:06 8088 [Warning] Aborted connection 8088 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-02  9:42:14 8412 [Warning] Aborted connection 8412 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got an error reading communication packets)
2024-12-02  9:42:14 8411 [Warning] Aborted connection 8411 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got an error reading communication packets)
2024-12-02  9:48:51 8125 [Warning] Aborted connection 8125 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)

I also see communication errors and timeouts!
System is on Open SuSE 15.6 with latest grommunio 2.37.0.ae11dd0.

ozy

@mwilliams Do you have enough data yet ?

WalterH

I als see these errors

2024-12-17 9:10:23 11166 [Warning] Aborted connection 11166 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got an error reading communication packets)
2024-12-17 9:10:23 11165 [Warning] Aborted connection 11165 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got an error reading communication packets)
2024-12-17 9:38:34 11085 [Warning] Aborted connection 11085 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 10:02:57 11141 [Warning] Aborted connection 11141 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 10:27:20 11214 [Warning] Aborted connection 11214 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 10:27:21 11215 [Warning] Aborted connection 11215 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 10:38:44 11249 [Warning] Aborted connection 11249 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 11:02:57 11324 [Warning] Aborted connection 11324 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 11:38:49 11442 [Warning] Aborted connection 11442 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 12:02:57 11514 [Warning] Aborted connection 11514 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 12:39:26 11617 [Warning] Aborted connection 11617 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 13:02:57 11675 [Warning] Aborted connection 11675 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 13:39:58 11781 [Warning] Aborted connection 11781 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 14:02:57 11839 [Warning] Aborted connection 11839 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 14:40:32 11947 [Warning] Aborted connection 11947 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 14:51:46 11919 [Warning] Aborted connection 11919 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 14:51:46 11962 [Warning] Aborted connection 11962 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 15:02:34 11973 [Warning] Aborted connection 11973 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 15:02:57 11994 [Warning] Aborted connection 11994 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 15:45:18 12275 [Warning] Aborted connection 12275 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got an error reading communication packets)
2024-12-17 15:45:18 12274 [Warning] Aborted connection 12274 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got an error reading communication packets)
2024-12-17 16:02:57 12160 [Warning] Aborted connection 12160 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 16:41:09 12092 [Warning] Aborted connection 12092 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 16:46:59 12278 [Warning] Aborted connection 12278 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 17:02:57 12334 [Warning] Aborted connection 12334 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 17:41:40 12413 [Warning] Aborted connection 12413 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 18:02:57 12482 [Warning] Aborted connection 12482 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 18:42:12 12570 [Warning] Aborted connection 12570 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 19:02:57 12621 [Warning] Aborted connection 12621 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)

Name : gromox
Version : 2.38.14.330426e

crpb

recently moved our local installation to a fresh 15.6 (xfs) vm and nothing special configured since then (stock)

# of course this goes back but i guess 24 hours are enough ¯\_(ツ)_/¯
2024-12-16 19:30:48 665 [Warning] Aborted connection 665 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-16 20:30:48 803 [Warning] Aborted connection 803 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-16 21:30:48 884 [Warning] Aborted connection 884 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-16 22:30:48 962 [Warning] Aborted connection 962 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-16 23:30:48 1040 [Warning] Aborted connection 1040 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17  0:30:48 1154 [Warning] Aborted connection 1154 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17  1:30:48 1208 [Warning] Aborted connection 1208 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17  2:30:48 1297 [Warning] Aborted connection 1297 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17  3:30:48 1353 [Warning] Aborted connection 1353 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17  4:30:48 1405 [Warning] Aborted connection 1405 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17  5:30:48 1428 [Warning] Aborted connection 1428 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17  6:30:48 1461 [Warning] Aborted connection 1461 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17  7:30:48 1513 [Warning] Aborted connection 1513 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17  8:30:48 1618 [Warning] Aborted connection 1618 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17  9:30:48 1678 [Warning] Aborted connection 1678 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 10:30:48 1712 [Warning] Aborted connection 1712 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 11:30:48 1741 [Warning] Aborted connection 1741 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 12:30:48 1774 [Warning] Aborted connection 1774 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 13:30:48 1804 [Warning] Aborted connection 1804 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 14:30:49 1874 [Warning] Aborted connection 1874 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 15:30:48 1920 [Warning] Aborted connection 1920 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 16:30:49 1970 [Warning] Aborted connection 1970 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 17:30:49 2081 [Warning] Aborted connection 2081 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 18:30:48 2227 [Warning] Aborted connection 2227 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)
2024-12-17 19:30:48 2336 [Warning] Aborted connection 2336 to db: 'grommunio' user: 'grommunio' host: 'localhost' (Got timeout reading communication packets)

WalterH

Maybe we should test with wait_timeout=288000 again?

crpb

For me this is just some silly thing that doesn't have any real impact as it's just a timed out connection from one of those services which will just reconnect itself when it needs to so .. i kinda lost interest on tinkering with those settings just to remove an "INFO" (imho).

OUTLOOK! OUTLOOK! OUTLOOK!

WalterH

I set this high value at 10:15:59 and so far there is no errors in the log (12:11).

« Previous Page