Bryan's picture
Bryan - Fri, 2016/02/19 - 20:24

I am having a bizzar (and new) issue with my wiki server. It runs fine for a period of time (less than 24 hours) and then begins loosing its connection to the MySQL system. The virtual macahine remains responsive during this time - i.e. I can log into the command line using the :12321 port, and a reboot temporarily fixes the issue but it always returns.

A similar problem appears to have been reported before, but the solution (updating tklbam) doesn't work - the current version is installed.

The specific error I get is:

Sorry! This site is experiencing technical difficulties.

Try waiting a few minutes and reloading.

(Can't contact the database server: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) (localhost))

Any advice is appreciated!

Bryan

Forum: 
Support
Tags: 
mysql
mediawiki
Jeremy Davis's picture

Jeremy Davis - Mon, 2016/02/22 - 00:15
It does sound very similar result and my guess is that it's caused by MySQL crashing. The most common cause for that is running out of RAM.

To confirm MySQL status try this: 

service mysql status

I also suggest that you check your MySQL logs (in /var/log) and keep an eye on RAM consumption to see if that is a problem.

Bryan's picture

Bryan - Mon, 2016/02/22 - 14:24

So now its running normally, so I cannot see what's going on during the errors. Non-the-les, the "service mysql status" command gives me the following:

==========================================

* mysql.service - LSB: Start and stop the mysql database server daemon
Loaded: loaded (/etc/init.d/mysql)
Active: active (running) since Fri 2016-02-19 18:15:00 UTC; 2 days ago
Process: 498 ExecStart=/etc/init.d/mysql start (code=exited, status=0/SUCCESS)
CGroup: /system.slice/mysql.service
|- 632 /bin/sh /usr/bin/mysqld_safe
`-1156 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-err...
 
Feb 19 18:15:00 mediawiki mysql[498]: Starting MySQL database server: mysqld . ..
Feb 19 18:15:00 mediawiki mysql[498]: Checking for tables which need an upgrade, are corrupt or were
Feb 19 18:15:00 mediawiki mysql[498]: not closed cleanly..
Feb 19 18:15:00 mediawiki systemd[1]: Started LSB: Start and stop the mysql database server daemon.
Feb 19 18:15:00 mediawiki /etc/mysql/debian-start[1234]: Upgrading MySQL tables if necessary.
Feb 19 18:15:01 mediawiki /etc/mysql/debian-start[1331]: Checking for insecure root accounts.
Feb 19 18:15:01 mediawiki /etc/mysql/debian-start[1336]: Triggering myisam-recover for all MyISAM tables
 
==========================================
/var/log/mysql.log is empty
 
Bryan

Add new comment