Mariadb 10.1 auto restart

itdungpt

Verified User
Joined
Aug 8, 2015
Messages
24
I use Mariadb 10.1 on directadmin on centos 6.10, it's auto shutdown every 1 second
Then i was upgrade to 10.2 10.3 but errors do not fix.
This is error says:

2020-09-07 22:53:17 139908880111584 [Note] InnoDB: 5.7.30 started; log sequence number 86661571
2020-09-07 22:53:17 139907924215552 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-09-07 22:53:18 139908880111584 [Note] Plugin 'FEEDBACK' is disabled.
2020-09-07 22:53:18 139908880111584 [Note] Server socket created on IP: '::'.
2020-09-07 22:53:18 139908880111584 [Note] Reading of all Master_info entries succeeded
2020-09-07 22:53:18 139908880111584 [Note] Added new Master_info '' to hash table
2020-09-07 22:53:18 139908880111584 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.2.32-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
2020-09-07 22:53:18 139907924215552 [Note] InnoDB: Buffer pool(s) load completed at 200907 22:53:18
2020-09-07 22:53:18 139908761868032 [Warning] Access denied for user 'root'@'localhost' (using password: NO)
2020-09-07 22:54:02 139908413159168 [Note] /usr/sbin/mysqld (initiated by: unknown): Normal shutdown
2020-09-07 22:54:02 139908413159168 [Note] Event Scheduler: Purging the queue. 0 events
2020-09-07 22:54:02 139908182161152 [Note] InnoDB: FTS optimize thread exiting.
2020-09-07 22:54:02 139908413159168 [Note] InnoDB: Starting shutdown...
2020-09-07 22:54:02 139907924215552 [Note] InnoDB: Dumping buffer pool(s) to /var/lib/mysql/ib_buffer_pool
2020-09-07 22:54:02 139907924215552 [Note] InnoDB: Buffer pool(s) dump completed at 200907 22:54:02
2020-09-07 22:54:03 139908413159168 [Note] InnoDB: Shutdown completed; log sequence number 86661672
2020-09-07 22:54:03 139908413159168 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2020-09-07 22:54:03 139908413159168 [Note] /usr/sbin/mysqld: Shutdown complete

2020-09-07 22:54:04 140555062233056 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-09-07 22:54:04 140555062233056 [Note] InnoDB: Uses event mutexes
2020-09-07 22:54:04 140555062233056 [Note] InnoDB: Compressed tables use zlib 1.2.3
2020-09-07 22:54:04 140555062233056 [Note] InnoDB: Using Linux native AIO
2020-09-07 22:54:04 140555062233056 [Note] InnoDB: Number of pools: 1
2020-09-07 22:54:04 140555062233056 [Note] InnoDB: Using SSE2 crc32 instructions
2020-09-07 22:54:04 140555062233056 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-09-07 22:54:04 140555062233056 [Note] InnoDB: Completed initialization of buffer pool
2020-09-07 22:54:04 140554494183168 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-09-07 22:54:04 140555062233056 [Note] InnoDB: Highest supported file format is Barracuda.
2020-09-07 22:54:04 140555062233056 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-09-07 22:54:04 140555062233056 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-09-07 22:54:04 140555062233056 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-09-07 22:54:04 140555062233056 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2020-09-07 22:54:04 140555062233056 [Note] InnoDB: Waiting for purge to start
2020-09-07 22:54:04 140555062233056 [Note] InnoDB: 5.7.30 started; log sequence number 86661672
2020-09-07 22:54:04 140554239194880 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
2020-09-07 22:54:04 140555062233056 [Note] Plugin 'FEEDBACK' is disabled.
2020-09-07 22:54:04 140555062233056 [Note] Server socket created on IP: '::'.
2020-09-07 22:54:04 140554239194880 [Note] InnoDB: Buffer pool(s) load completed at 200907 22:54:04
2020-09-07 22:54:04 140555062233056 [Note] Reading of all Master_info entries succeeded
2020-09-07 22:54:04 140555062233056 [Note] Added new Master_info '' to hash table
2020-09-07 22:54:04 140555062233056 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.2.32-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
 
Last edited:

kristian

Verified User
Joined
Nov 4, 2005
Messages
270
Location
Norway
The only actual error I see in that log is this:

2020-09-07 22:53:18 139908761868032 [Warning] Access denied for user 'root'@'localhost' (using password: NO)

The very last log line you have pasted seem to indicate MariaDB is running, but I assume that's not the case. I don't know if the above error is the cause of this, it does seem unlikely. Is it perhaps some monitoring software that tries to connect as root, fails, and then proceeds to restart mariadb in an attempt to resolve the problem?
 

bdacus01

Verified User
Joined
Jul 22, 2017
Messages
3,130
Location
Murfreesboro
centos 6.10
Why worry you have about 2 months and you need to upgrade

MariaDB as well. https://mariadb.org/tag/eol/
10.14 years and 11 months ago
(17 Oct 2015)
Ends in 1 month and 6 days
(17 Oct 2020)

Other than that you need to read logs. Take the use of the application into thought. What does htop show? What is server specs? Did it just stop working? Are you the Admin or a User? What did the Host you use say?
 
Top