aaP_alhamya53 230821 10:02:16 mysqld_safe Starting mariadbd daemon with databases from /www/server/data 2023-08-21 10:02:16 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824 2023-08-21 10:02:16 0 [Note] /www/server/mysql/bin/mariadbd (server 10.6.7-MariaDB-log) starting as process 14771 ... 2023-08-21 10:02:16 0 [Note] InnoDB: Compressed tables use zlib 1.2.7 2023-08-21 10:02:16 0 [Note] InnoDB: Number of pools: 1 2023-08-21 10:02:16 0 [Note] InnoDB: Using generic crc32 instructions 2023-08-21 10:02:16 0 [Note] InnoDB: Using Linux native AIO 2023-08-21 10:02:16 0 [Note] InnoDB: Initializing buffer pool, total size = 268435456, chunk size = 134217728 2023-08-21 10:02:16 0 [Note] InnoDB: Completed initialization of buffer pool 2023-08-21 10:02:16 0 [Note] InnoDB: Transaction 16712929 was in the XA prepared state. 2023-08-21 10:02:16 0 [Note] InnoDB: Transaction 16712930 was in the XA prepared state. 2023-08-21 10:02:16 0 [Note] InnoDB: 2 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo 2023-08-21 10:02:16 0 [Note] InnoDB: Trx id counter is 16712931 2023-08-21 10:02:16 0 [Note] InnoDB: 128 rollback segments are active. 2023-08-21 10:02:16 0 [Note] InnoDB: Starting in background the rollback of recovered transactions 2023-08-21 10:02:16 0 [Note] InnoDB: Rollback of non-prepared transactions completed 2023-08-21 10:02:16 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2023-08-21 10:02:16 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2023-08-21 10:02:16 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB. 2023-08-21 10:02:16 0 [Note] InnoDB: 10.6.7 started; log sequence number 157201563394; transaction id 16712932 2023-08-21 10:02:16 0 [Note] Plugin 'FEEDBACK' is disabled. 2023-08-21 10:02:16 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool 2023-08-21 10:02:16 0 [Note] InnoDB: Buffer pool(s) load completed at 230821 10:02:16 2023-08-21 10:02:16 0 [Note] InnoDB: Starting recovery for XA transactions... 2023-08-21 10:02:16 0 [Note] InnoDB: Transaction 16712930 in prepared state after recovery 2023-08-21 10:02:16 0 [Note] InnoDB: Transaction contains changes to 1 rows 2023-08-21 10:02:16 0 [Note] InnoDB: Transaction 16712929 in prepared state after recovery 2023-08-21 10:02:16 0 [Note] InnoDB: Transaction contains changes to 1 rows 2023-08-21 10:02:16 0 [Note] InnoDB: 2 transactions in prepared state after recovery 2023-08-21 10:02:16 0 [Note] Found 2 prepared transaction(s) in InnoDB 2023-08-21 10:02:16 0 [ERROR] Found 2 prepared transactions! It means that server was not shut down properly last time and critical recovery information (last binlog or tc.log file) was manually deleted after a crash. You have to start server with --tc-heuristic-recover switch to commit or rollback pending transactions. 2023-08-21 10:02:16 0 [ERROR] Aborting 230821 10:02:17 mysqld_safe mysqld from pid file /www/server/data/srv8253833711.bitcommand.net.pid ended
aaPanel_Kern aaP_alhamya53 Hello, after the server makes a snapshot backup, try executing this command mysqld --tc-heuristic-recover
aaPanel_Kern Hello, after the server makes a snapshot backup, try executing this command /www/server/mysql/bin/mysqld --tc-heuristic-recover aaP_alhamya53
aaP_alhamya53 Hello. When executing this command 2023-08-22 6:02:43 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824 2023-08-22 6:02:43 0 [ERROR] /www/server/mysql/bin/mysqld: option '--tc-heuristic-recover' requires an argument
aaPanel_Kern aaP_alhamya53 ROLLBACK: Roll back incomplete transactions. COMMIT: Commit outstanding transactions. OFF: Does not perform any repair operations. To set --tc-heuristic-recover to ROLLBACK, you can modify the command to: /www/server/mysql/bin/mysqld --tc-heuristic-recover=ROLLBACK
aaPanel_Kern aaPanel_Kern /www/server/mysql/bin/mysqld --tc-heuristic-recover=ROLLBACK --user=mysql aaP_alhamya53
aaP_alhamya53 When performing Tommy commands 2023-08-22 6:30:01 0 [Warning] option 'max_allowed_packet': unsigned value 107374182400 adjusted to 1073741824 2023-08-22 6:30:01 0 [Note] /www/server/mysql/bin/mysqld (server 10.6.7-MariaDB-log) starting as process 9093 ... /www/server/mysql/bin/mysqld: Please consult the Knowledge Base to find out how to run mysqld as root! 2023-08-22 6:30:01 0 [ERROR] Aborting
aaP_alhamya53 Thank you very much, the problem is solved and mysql is turned on and Tommy sites are working correctly. What is the problem? The database has this problem every few days and we have to restart it to activate it again
aaPanel_Kern Hello, is the problem solved? If it is a fresh installation, consider reinstalling mysql. koji