LAMPP MySQL Ubuntu не работает

Question

У меня есть проблема при перезапуске сервера MySQL:

через следующее:

/opt/lampp/var/mysql$ sudo /opt/lampp/lampp start
Starting XAMPP for Linux 5.6.36-0...
XAMPP: Starting Apache...already running.
XAMPP: Starting MySQL...ok.
XAMPP: Starting ProFTPD...already running.
After sometime it fails to the following :

/opt/lampp/var/mysql$ sudo /opt/lampp/lampp status
Version: XAMPP for Linux 5.6.36-0
Apache is running.
MySQL is not running.
ProFTPD is running.

Когда я проверяю журнал ошибок корзины, я получаю следующую ошибку =>

2018-10-11 10:00:41 140280246654784 [ERROR] InnoDB: Failed to find tablespace for table '"t4a"."tbl_responses"' in the cache. Attempting to load the tablespace with space id 2845.
InnoDB: 2 transaction(s) which must be rolled back or cleaned up
InnoDB: in total 0 row operations to undo
InnoDB: Trx id counter is 3472600576
2018-10-11 10:00:41 140280246654784 [Note] InnoDB: 128 rollback segment(s) are active.
2018-10-11 10:00:41 140277711759104 [Note] InnoDB: Starting in background the rollback of recovered transactions
2018-10-11 10:00:41 140277711759104 [Note] InnoDB: Rollback of non-prepared transactions completed
2018-10-11 10:00:41 140280246654784 [Note] InnoDB: Waiting for purge to start
2018-10-11 10:00:41 140280246654784 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.38-83.0 started; log sequence number 342276173866
2018-10-11 10:00:41 140277623092992 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-10-11 10:00:41 140280246654784 [Note] Plugin 'FEEDBACK' is disabled.
2018-10-11 10:00:41 7f958a455740  InnoDB: Starting recovery for XA transactions...
2018-10-11 10:00:41 7f958a455740  InnoDB: Transaction 3472595085 in prepared state after recovery
2018-10-11 10:00:41 7f958a455740  InnoDB: Transaction contains changes to 1 rows
2018-10-11 10:00:41 7f958a455740  InnoDB: Transaction 3472595084 in prepared state after recovery
2018-10-11 10:00:41 7f958a455740  InnoDB: Transaction contains changes to 1 rows
2018-10-11 10:00:41 7f958a455740  InnoDB: 2 transactions in prepared state after recovery
2018-10-11 10:00:41 140280246654784 [Note] Found 2 prepared transaction(s) in InnoDB
2018-10-11 10:00:41 140280246654784 [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.
2018-10-11 10:00:41 140280246654784 [ERROR] Aborting

Как мне решить это?

Answer 1

Это означает, что mysqld не был правильно отключен в прошлый раз, а критическая информация о восстановлении (последний файл binlog или tc.log) была вручную удалена после сбоя. Вы должны начать MySQL с --tc-heuristic-recover переключиться на принятие или откат ожидающих транзакций