Constant MySQL crashing

Virtualmin
1

Hi all. Having a bunch of issues with MySQL on my server where it crashes quite frequently. I use Monit to monitor the service and restart it if it fails. Problem is, I can’t really figure out why it’s crashing so often. The logs are gibberish to me. Any assistance would be fantastic.

Here’s the current error.log for MySQL on my system: https://pastebin.com/rGNU35Ts

OS: Ubuntu Linux 18.04.3
MySQL: MySQL version 5.7.30-0ubuntu0.18.04.1
Usermin ver: 1.802
Processors: Intel® Xeon® CPU E5-2650 v4 @ 2.20GHz, 2 cores
Memory: 1.54 GiB used / 2 GiB cached / 3.85 GiB total

2

Hello, can you also post the mysql configuration?
Just go to Webmin > Servers > MySQl database Server > Edit Config Files

3

Hi there,

Apparently /etc/mysql/conf.d/mysql.cnf is basically blank:

The only entry is this:

[mysql]

4

Hello,

You can run
Virtualmin > System Settings > Re-Run Install Wizard
and set MariaDB/MySQL configuration size to Small system (256M)

Also, you can disable virus filtering if it’s enabled in
Virtualmin > Your Domain > Edit Virtual Server > Enabled features

to reduce the ram usage

5

When I run this, it doesn’t actually populate the mysql config with anything.

6

If you go to
Webmin > Servers > MySQL Database server > MySQL Server Configuration
are the values set to default?
If yes, you can add this to /etc/mysql/conf.d/mysql.cnf
https://pastebin.com/Jzsyx3Lp
and restart MySQL server

7

This was empty, said it could not find the [mysql] information.

I did as you instructed, added the file information, restarted and now the MySQL Server Configuration values show up properly.

8

Now you can run
mysqlcheck --repair --all-databases
to fix the database.

9

It looks like Monit had to restart the DB again after making these changes.

Monit description: Description: failed protocol test [MYSQL] at [localhost]:3306 [TCP/IP] – Server returned error code 1130 – Host ‘127.0.0.1’ is not allowed to connect to this MySQL server

Error log: https://pastebin.com/Ww0nUGHu

10

During the mysqlcheck, this came up and stopped the repair:

Error : Server shutdown in progress
error : Corrupt
mysqlcheck: Got error: 2002: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) when executing 'REPAIR TABLE … ’
root@newweb:~#

rror : 127 when fixing table
status : Operation failed
mysqlcheck: Got error: 2013: Lost connection to MySQL server during query when executing 'REPAIR TABLE … ’
root@newweb:~#

Edit:
It does not actually appear that MySQL actually stopped running though…

11

Can you create another database and install the application? Then, drop the old one.

12

And please change
innodb_buffer_pool_size=4096M to something like innodb_buffer_pool_size=128M
in mysql.cnf Sorry :slight_smile:

13

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.