Skip to main content

MariaDB Restart

Andy83

Hi, 

I am unable to restart MariaDB via CPanel. 

It shows - Restarting Server Database Server. 

But it has taken more than 15 minutes.

Previously I rebooted the server because the restart was taking too long.

Please advise. Thank you.

Comments

6 comments

Date Votes
  • Andy83

    2024-08-07 14:09:26 0 [Note] InnoDB: 1 transaction(s) which must be rolled back or cleaned up in total 5071808532 row operations to undo
    2024-08-07 14:09:26 0 [Note] InnoDB: Trx id counter is 4184151
    2024-08-07 14:09:26 0 [Note] InnoDB: 128 rollback segments are active.
    2024-08-07 14:09:26 0 [Note] InnoDB: Starting in background the rollback of recovered transactions
    2024-08-07 14:09:26 0 [Note] InnoDB: Setting file './ibtmp1' size to 12.000MiB. Physically writing the file full; Please wait ...
    2024-08-07 14:09:26 0 [Note] InnoDB: To roll back: 1 transactions, 5071808532 rows
    2024-08-07 14:09:26 0 [Note] InnoDB: File './ibtmp1' size is now 12.000MiB.
    2024-08-07 14:09:26 0 [Note] InnoDB: log sequence number 2704752308199; transaction id 4184152
    2024-08-07 14:09:26 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
    2024-08-07 14:09:26 0 [Note] Plugin 'FEEDBACK' is disabled.
    2024-08-07 14:09:26 0 [Note] Plugin 'unix_socket' is disabled.
    2024-08-07 14:09:26 0 [Note] Server socket created on IP: '127.0.0.1'.
    2024-08-07 14:09:26 0 [Note] InnoDB: Buffer pool(s) load completed at 240807 14:09:26
    2024-08-07 14:09:26 0 [Note] /usr/sbin/mariadbd: ready for connections.
    Version: '10.11.8-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server
    2024-08-07 14:09:26 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown
    2024-08-07 14:09:26 0 [Note] InnoDB: FTS optimize thread exiting.
    2024-08-07 14:09:26 0 [Note] InnoDB: Rollback of non-prepared transactions completed
    2024-08-07 14:09:26 0 [Note] InnoDB: Starting shutdown...
    2024-08-07 14:09:26 0 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
    2024-08-07 14:09:26 0 [Note] InnoDB: Buffer pool(s) dump completed at 240807 14:09:26
    2024-08-07 14:09:26 0 [Note] InnoDB: Removed temporary tablespace data file: "./ibtmp1"
    2024-08-07 14:09:26 0 [Note] InnoDB: Shutdown completed; log sequence number 2704752655605; transaction id 4184153
    2024-08-07 14:09:26 0 [Note] /usr/sbin/mariadbd: Shutdown complete

    Warning: Memory not freed: 4464
    2024-08-07 14:09:27 0 [Note] Starting MariaDB 10.11.8-MariaDB source revision 3a069644682e336e445039e48baae9693f9a08ee as process 67300
    2024-08-07 14:09:27 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
    2024-08-07 14:09:27 0 [Note] InnoDB: Using transactional memory
    2024-08-07 14:09:27 0 [Note] InnoDB: Number of transaction pools: 1
    2024-08-07 14:09:27 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
    2024-08-07 14:09:27 0 [Note] InnoDB: Using Linux native AIO
    2024-08-07 14:09:27 0 [Note] InnoDB: Initializing buffer pool, total size = 24.000GiB, chunk size = 384.000MiB
    2024-08-07 14:09:27 0 [Note] InnoDB: Completed initialization of buffer pool
    2024-08-07 14:09:27 0 [Note] InnoDB: File system buffers for log disabled (block size=512 bytes)
    2024-08-07 14:09:27 0 [Note] InnoDB: End of log at LSN=2704752655605

    0
  • Andy83

    ]# systemctl status mariadb
    ● mariadb.service - MariaDB 10.11.8 database server
       Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
      Drop-In: /etc/systemd/system/mariadb.service.d
               └─migrated-from-my.cnf-settings.conf
       Active: deactivating (stop-sigterm) (Result: timeout)
         Docs: man:mariadbd(8)
               https://mariadb.com/kb/en/library/systemd/
      Process: 75269 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, statu>
      Process: 75267 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
     Main PID: 75314 (mariadbd)
        Tasks: 5 (limit: 1015650)
       Memory: 24.3G
       CGroup: /system.slice/mariadb.service
               └─75314 /usr/sbin/mariadbd

    Aug 07 14:48:53 hello.xx.com systemd[1]: Starting MariaDB 10.11.8 database server...
    Aug 07 15:03:53 hello.xx.com systemd[1]: mariadb.service: start operation timed out. Terminating.

    0
  • Andrew
    Translate

    What is the OS you are running on? What changes were made before you started to see this issue?

    Andrew N. - cPanel Plesk VMWare Certified Professional
    Do you need immediate assistance? 20 minutes response time!* Open a ticket
    EmergencySupport - Professional Server Management and One-time Services

     

     

    0
  • Andy83

    Mine is MariaDB 10.11.8 database server

    I have a general question. 

    Is the following commands achieve the same result or different? 

     systemctl restart mariadb

    service mysql restart

     

    0
  • Andrew

    Same result. OS version?

    Andrew N. - cPanel Plesk VMWare Certified Professional
    Do you need immediate assistance? 20 minutes response time!* Open a ticket
    EmergencySupport - Professional Server Management and One-time Services

    0
  • cPRex Jurassic Moderator

    None of those log entries look like errors - we want to see something that isn't just NOTE from the logs.  Do you have any more data from the main MySQL log you can share?

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post