MariaDB shutting down

Orion

Brand new server. Installed mariaDB and can get into it briefly - if I'm quick. Within about 90-120 seconds it shuts down. I'm the only user on this server so it can't be someone else but it's a normal shutdown.

user@host:/etc/init.d$ sudo mysql -u root
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 2
Server version: 10.1.34-MariaDB-0ubuntu0.18.04.1 Ubuntu 18.04

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]> SELECT USER from mysql.user;
+------+
| USER |
+------+
| root |
+------+
1 row in set (0.00 sec)

MariaDB [(none)]>

errorlog is showing this:

2018-11-08  2:09:27 139904565460096 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2018-11-08  2:09:27 139904565460096 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-11-08  2:09:27 139904565460096 [Note] InnoDB: The InnoDB memory heap is disabled
2018-11-08  2:09:27 139904565460096 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-11-08  2:09:27 139904565460096 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2018-11-08  2:09:27 139904565460096 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-11-08  2:09:27 139904565460096 [Note] InnoDB: Using Linux native AIO
2018-11-08  2:09:27 139904565460096 [Note] InnoDB: Using SSE crc32 instructions
2018-11-08  2:09:27 139904565460096 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-11-08  2:09:27 139904565460096 [Note] InnoDB: Completed initialization of buffer pool
2018-11-08  2:09:27 139904565460096 [Note] InnoDB: Highest supported file format is Barracuda.
2018-11-08  2:09:27 139904565460096 [Note] InnoDB: 128 rollback segment(s) are active.
2018-11-08  2:09:27 139904565460096 [Note] InnoDB: Waiting for purge to start
2018-11-08  2:09:27 139904565460096 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.39-83.1 started; log sequence number 1616877
2018-11-08  2:09:27 139904565460096 [Note] Plugin 'FEEDBACK' is disabled.
2018-11-08  2:09:27 139903945893632 [Note] InnoDB: Dumping buffer pool(s) not yet started
2018-11-08  2:09:27 139904565460096 [Note] Server socket created on IP: '127.0.0.1'.
2018-11-08  2:09:27 139904565460096 [Note] /usr/sbin/mysqld: ready for connections.
Version: '10.1.34-MariaDB-0ubuntu0.18.04.1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Ubuntu 18.04
2018-11-08  2:10:56 139904564819712 [Note] /usr/sbin/mysqld: Normal shutdown
2018-11-08  2:10:56 139904564819712 [Note] Event Scheduler: Purging the queue. 0 events
2018-11-08  2:10:56 139903971071744 [Note] InnoDB: FTS optimize thread exiting.
2018-11-08  2:10:56 139904564819712 [Note] InnoDB: Starting shutdown...
2018-11-08  2:10:57 139904564819712 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
2018-11-08  2:10:58 139904564819712 [Note] InnoDB: Shutdown completed; log sequence number 1616887
2018-11-08  2:10:58 139904564819712 [Note] /usr/sbin/mysqld: Shutdown complete

I go back in and sudo ./mysql start and I can reconnect to mysql for another ~2 mins and it shuts down again.

MariaDB [(none)]> SELECT USER from mysql.user;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory")
ERROR: Can't connect to the server

Nothing else really installed this server. I have set up firewall and Fail2Ban but that's about it. And disabled IPV6 but that shouldn't make any difference.

Any ideas?

Tom Dunne

I'd start rummaging through /var/log to see if you can spot anything in there.

Orion

I'll have a root through the logs. Cursory look showed nothing and haven't had a lot of time to go digging. It's a personal VM I'm setting up for no real purpose except to play with Linux, LAMP, etc - it's been a while since I used it much and want to refresh myself. Got a Minecraft server working for the kids no problem