hi, i've a strange problem started about 5 days ago, i have at least 25 websites on aapanel on a server running ubuntu 22.04.3, php 8.2 and mysql 8.0.35.
the problem is that sometimes mysql stop and i have to restart it manually, in the panel i see that mysql is running with the green arrow near but it's not.
here's the log
User@Host: sql_management_t[sql_management_t] @ localhost [] Id: 3479
Query_time: 21659.808033 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1705980062;
LOCK TABLES pnptc_tasks
WRITE, pnptc_tasks
AS s
WRITE, pnptc_sites
WRITE;
Time: 2024-01-23T09:22:01.929374Z
User@Host: sql_management_t[sql_management_t] @ localhost [] Id: 3494
Query_time: 21539.824568 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1705980182;
LOCK TABLES pnptc_tasks
WRITE, pnptc_tasks
AS s
WRITE, pnptc_sites
WRITE;
Time: 2024-01-23T09:22:01.954405Z
User@Host: sql_management_t[sql_management_t] @ localhost [] Id: 3503
Query_time: 21419.843748 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1705980302;
LOCK TABLES pnptc_tasks
WRITE, pnptc_tasks
AS s
WRITE, pnptc_sites
WRITE;
Time: 2024-01-23T09:22:01.962091Z
User@Host: sql_management_t[sql_management_t] @ localhost [] Id: 3534
Query_time: 21119.844974 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1705980602;
LOCK TABLES pnptc_tasks
WRITE, pnptc_tasks
AS s
WRITE, pnptc_sites
WRITE;
Time: 2024-01-23T09:22:01.977758Z
User@Host: sql_management_t[sql_management_t] @ localhost [] Id: 3567
Query_time: 20819.852284 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1705980902;
LOCK TABLES pnptc_tasks
WRITE, pnptc_tasks
AS s
WRITE, pnptc_sites
WRITE;
Time: 2024-01-23T09:22:01.994976Z
User@Host: sql_management_t[sql_management_t] @ localhost [] Id: 3574
Query_time: 20759.859040 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1705980962;
LOCK TABLES pnptc_tasks
WRITE, pnptc_tasks
AS s
WRITE, pnptc_sites
WRITE;
Time: 2024-01-23T09:22:01.995770Z
User@Host: sql_management_t[sql_management_t] @ localhost [] Id: 3631
Query_time: 20279.598565 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1705981442;
LOCK TABLES pnptc_tasks
WRITE, pnptc_tasks
AS s
WRITE, pnptc_sites
WRITE;
Time: 2024-01-23T09:22:01.998229Z
User@Host: sql_management_t[sql_management_t] @ localhost [] Id: 3647
Query_time: 20159.592891 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1705981562;
LOCK TABLES pnptc_tasks
WRITE, pnptc_tasks
AS s
WRITE, pnptc_sites
WRITE;
Time: 2024-01-23T09:22:02.014420Z
User@Host: sql_management_t[sql_management_t] @ localhost [] Id: 3662
Query_time: 20039.601373 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1705981682;
LOCK TABLES pnptc_tasks
WRITE, pnptc_tasks
AS s
WRITE, pnptc_sites
WRITE;
Time: 2024-01-23T09:22:02.045097Z
User@Host: sql_management_t[sql_management_t] @ localhost [] Id: 3719
Query_time: 19439.615254 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1705982282;
LOCK TABLES pnptc_tasks
WRITE, pnptc_tasks
AS s
WRITE, pnptc_sites
WRITE;
Time: 2024-01-23T09:22:02.281260Z
User@Host: sql_management_t[sql_management_t] @ localhost [] Id: 3735
Query_time: 19319.817004 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1705982402;
LOCK TABLES pnptc_tasks
WRITE, pnptc_tasks
AS s
WRITE, pnptc_sites
WRITE;
Time: 2024-01-23T09:22:02.764693Z
User@Host: sql_management_t[sql_management_t] @ localhost [] Id: 3751
Query_time: 19200.097904 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1705982522;
LOCK TABLES pnptc_tasks
WRITE, pnptc_tasks
AS s
WRITE, pnptc_sites
WRITE;
Time: 2024-01-23T09:22:02.864134Z
User@Host: sql_management_t[sql_management_t] @ localhost [] Id: 4039
Query_time: 18480.178111 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1705983242;
LOCK TABLES pnptc_tasks
WRITE, pnptc_tasks
AS s
WRITE, pnptc_sites
WRITE;
Time: 2024-01-23T09:22:03.454193Z
User@Host: sql_management_t[sql_management_t] @ localhost [] Id: 4151
Query_time: 18240.743121 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1705983482;
LOCK TABLES pnptc_tasks
WRITE, pnptc_tasks
AS s
WRITE, pnptc_sites
WRITE;
Time: 2024-01-23T09:22:03.454217Z
User@Host: sql_management_t[sql_management_t] @ localhost [] Id: 4551
Query_time: 16321.222486 Lock_time: 0.000000 Rows_sent: 0 Rows_examined: 0
SET timestamp=1705985402;
LOCK TABLES pnptc_tasks
WRITE, pnptc_tasks
AS s
WRITE, pnptc_sites
WRITE;
/www/server/mysql/bin/mysqld, Version: 8.0.35 (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
/www/server/mysql/bin/mysqld, Version: 8.0.35 (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
/www/server/mysql/bin/mysqld, Version: 8.0.35 (Source distribution). started with:
Tcp port: 3306 Unix socket: /tmp/mysql.sock
Time Id Command Argument
Time: 2024-01-23T09:38:06.327328Z
User@Host: sql_management_t[sql_management_t] @ localhost [] Id: 31
Query_time: 8.314240 Lock_time: 0.000029 Rows_sent: 0 Rows_examined: 0
use sql_management_t;
SET timestamp=1706002678;
LOCK TABLES pnptc_tasks
WRITE, pnptc_tasks
AS s
WRITE, pnptc_sites
WRITE;
Time: 2024-01-23T09:38:06.335927Z
User@Host: sql_management_t[sql_management_t] @ localhost [] Id: 17
Query_time: 8.193963 Lock_time: 0.000026 Rows_sent: 0 Rows_examined: 0
SET timestamp=1706002678;
LOCK TABLES pnptc_tasks
WRITE, pnptc_tasks
AS s
WRITE, pnptc_sites
WRITE;
Time: 2024-01-23T09:38:06.345817Z
User@Host: sql_management_t[sql_management_t] @ localhost [] Id: 50
Query_time: 3.717265 Lock_time: 0.000027 Rows_sent: 0 Rows_examined: 0
SET timestamp=1706002682;
LOCK TABLES pnptc_tasks
WRITE, pnptc_tasks
AS s
WRITE, pnptc_sites
WRITE;
and here error logs
2024-01-23T09:52:24.975433Z 221 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-01-23T09:52:29.480888Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.35).
2024-01-23T09:52:31.481833Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 216 user: 'sql_management_t'.
2024-01-23T09:52:31.481951Z 0 [Warning] [MY-010909] [Server] /www/server/mysql/bin/mysqld: Forcing close of thread 208 user: 'sql_management_t'.
2024-01-23T09:52:32.224044Z 0 [System] [MY-010910] [Server] /www/server/mysql/bin/mysqld: Shutdown complete (mysqld 8.0.35) Source distribution.
2024-01-23T09:52:33.404934Z 0 [Warning] [MY-000081] [Server] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824.
2024-01-23T09:52:33.404992Z 0 [Warning] [MY-011070] [Server] 'binlog_format' is deprecated and will be removed in a future release.
2024-01-23T09:52:33.405068Z 0 [Warning] [MY-010915] [Server] 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
2024-01-23T09:52:33.405194Z 0 [System] [MY-010116] [Server] /www/server/mysql/bin/mysqld (mysqld 8.0.35) starting as process 32348
2024-01-23T09:52:33.482309Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=4294967296. Please use innodb_redo_log_capacity instead.
2024-01-23T09:52:33.485315Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-01-23T09:52:34.591410Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2024-01-23T09:52:35.043298Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-01-23T09:52:35.043344Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-01-23T09:52:35.076732Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock
2024-01-23T09:52:35.076830Z 0 [System] [MY-010931] [Server] /www/server/mysql/bin/mysqld: ready for connections. Version: '8.0.35' socket: '/tmp/mysql.sock' port: 3306 Source distribution.
2024-01-23T09:52:39.139608Z 8 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'