Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

MariaDB shutting down

  • 08-11-2018 1:28am
    #1
    Orion
    Closed Accounts Posts: 12,807 ✭✭✭✭


    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?


Comments

  • #2
    Tom Dunne
    Registered Users, Registered Users 2 Posts: 23,212 ✭✭✭✭Tom Dunne


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


  • #3
    Orion
    Closed Accounts Posts: 12,807 ✭✭✭✭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 :D


Advertisement