Hello, first I have to say i'm a mysql newbie. so basically i have this error in MariaDB 10.3:
2022-05-23 7:37:43 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-05-23 7:37:43 0 [Note] InnoDB: Uses event mutexes
2022-05-23 7:37:43 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2022-05-23 7:37:43 0 [Note] InnoDB: Number of pools: 1
2022-05-23 7:37:43 0 [Note] InnoDB: Using SSE2 crc32 instructions
2022-05-23 7:37:43 0 [Note] InnoDB: Initializing buffer pool, total size = 256M, instances = 1, chunk size = 128M
2022-05-23 7:37:43 0 [Note] InnoDB: Completed initialization of buffer pool
2022-05-23 7:37:43 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2022-05-23 7:37:43 0 [Note] InnoDB: Transaction 62780867 was in the XA prepared state.
2022-05-23 7:37:43 0 [Note] InnoDB: Transaction 62780898 was in the XA prepared state.
2022-05-23 7:37:43 0 [Note] InnoDB: 2 transaction(s) which must be rolled back or cleaned up in total 0 row operations to undo
2022-05-23 7:37:43 0 [Note] InnoDB: Trx id counter is 62780899
2022-05-23 7:37:43 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2022-05-23 7:37:43 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
2022-05-23 7:37:43 0 [Note] InnoDB: Rollback of non-prepared transactions completed
2022-05-23 7:37:43 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-05-23 7:37:43 0 [Note] InnoDB: Setting file '/www/server/data/ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-05-23 7:37:43 0 [Note] InnoDB: File '/www/server/data/ibtmp1' size is now 12 MB.
2022-05-23 7:37:43 0 [Note] InnoDB: Waiting for purge to start
2022-05-23 7:37:43 0 [Note] InnoDB: 10.3.20 started; log sequence number 18669385297; transaction id 62780901
2022-05-23 7:37:43 0 [Note] InnoDB: Loading buffer pool(s) from /www/server/data/ib_buffer_pool
2022-05-23 7:37:43 0 [Note] Plugin 'FEEDBACK' is disabled.
2022-05-23 7:37:43 0 [Note] InnoDB: Starting recovery for XA transactions...
2022-05-23 7:37:43 0 [Note] InnoDB: Transaction 62780867 in prepared state after recovery
2022-05-23 7:37:43 0 [Note] InnoDB: Transaction contains changes to 1 rows
2022-05-23 7:37:43 0 [Note] InnoDB: Transaction 62780898 in prepared state after recovery
2022-05-23 7:37:43 0 [Note] InnoDB: Transaction contains changes to 1 rows
2022-05-23 7:37:43 0 [Note] InnoDB: 2 transactions in prepared state after recovery
2022-05-23 7:37:43 0 [Note] Found 2 prepared transaction(s) in InnoDB
2022-05-23 7:37:43 0 [ERROR] Found 2 prepared transactions! It means that mysqld 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 mysqld with --tc-heuristic-recover switch to commit or rollback pending transactions.
2022-05-23 7:37:43 0 [ERROR] Aborting
Help please
