Mariadb Mysql Failed to start (Found 1 prepared transactions! It means that mysqld was not shut down properly last time)


Solution insert this command :- mysqld --tc-heuristic-recover=ROLLBACK
then insert command => service mysqld start

Check : Service mysqld status
issue:

Drop-In: /etc/systemd/system/mariadb.service.d

           └─migrated-from-my.cnf-settings.conf

   Active: failed (Result: exit-code) since Mon 2019-01-07 08:56:29 EST; 2min 32s ago

     Docs: man:mysqld(8)

           https://mariadb.com/kb/en/library/systemd/

  Process: 2834 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)

  Process: 2668 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITIO

  Process: 2661 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)

  Process: 2655 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)

Main PID: 2834 (code=exited, status=1/FAILURE)

   Status: "MariaDB server is down"

Jan 07 08:56:27 yourserver mysqld[2834]: 2019-01-07  8:56:27 139786823903424 [Note] InnoDB: Transaction 802468 in prepared state after recovery

Jan 07 08:56:27 yourserver[2834]: 2019-01-07  8:56:27 139786823903424 [Note] InnoDB: Transaction contains changes to 1 rows

Jan 07 08:56:27 yourserver mysqld[2834]: 2019-01-07  8:56:27 139786823903424 [Note] InnoDB: 1 transactions in prepared state after recovery

Jan 07 08:56:27 yourserver mysqld[2834]: 2019-01-07  8:56:27 139786823903424 [Note] Found 1 prepared transaction(s) in InnoDB

Jan 07 08:56:27 yourserver mysqld[2834]: 2019-01-07  8:56:27 139786823903424 [ERROR] Found 1 prepared transactions! It means that mysqld was not shut down properly last time an

Jan 07 08:56:27 yourserver mysqld[2834]: 2019-01-07  8:56:27 139786823903424 [ERROR] Aborting

Jan 07 08:56:29 yourserver systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE

Jan 07 08:56:29 yourserver systemd[1]: Failed to start MariaDB 10.2.19 database server.

Jan 07 08:56:29 yourserver systemd[1]: mariadb.service: Unit entered failed state.


Did you find this article useful?



  • SSL Runcloud + WordPress
    1) Setup SSL Runcloud            1. Access your runcloud dashboard             &...

  • Migration of WordPress to Runcloud
    Migration of WordPress to RUNCLOUD1. Firstly zip file to public_html2. Secondly export SQL file from phpmyadmin     3. Third upload zi...

  • Migration of Domain to Runcloud
    Description 1. Check wp-confiq information          i.   If you forget the name of the file use.  &n...

  • Problem with folder permission (chown)
    If u get error regarding permission folder failed to rewriteplease use this command by ssh your server =chown -R runcloud:runcloud /home/runcloud/weba...

  • Cron job
    Cron job runcloud1) Go to runcloud cronjob2) Fill up cronjob name3) Select php version or insert your own commandFor example:-/usr/bin/php -q /home/ru...