MyBB Community Forums

Looking at my forum this morning and I get this error:

MyBB has experienced an internal SQL error and cannot continue.

SQL Error:2002 - No such file or directory

Query:[READ] Unable to connect to MySQL server

Please contact the MyBB Group for technical support.


The address is http://forum.dingo-den.com  I only installed it yesterday and it was running fine but not this morning.

I have mariadb installed:
mariadb-client is already the newest version (1:10.1.43-0ubuntu0.18.04.1).

mariadb-server is already the newest version (1:10.1.43-0ubuntu0.18.04.1).

I had a look and the service does not start:

root@forum:~# systemctl status mariadb.service
● mariadb.service - MariaDB 10.1.43 database server
  Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
  Active: failed (Result: timeout) since Wed 2019-12-11 17:58:53 EST; 1min 34s ago
    Docs: man:mysqld(8)
          https://mariadb.com/kb/en/library/systemd/
  Process: 21729 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 21652 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||  VAR=/usr/bin/galera_recovery; [ $? -eq 0 ]  && systemctl set-environment _WSREP_START_
  Process: 21643 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 21633 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 21729 (code=exited, status=0/SUCCESS)

Dec 11 17:57:20 forum.dingo-den.com systemd[1]: Starting MariaDB 10.1.43 database server...
Dec 11 17:57:21 forum.dingo-den.com mysqld[21729]: 2019-12-11 17:57:21 140537820200064 [Note] /usr/sbin/mysqld (mysqld 10.1.43-MariaDB-0ubuntu0.18.04.1) starting as process 2172
Dec 11 17:58:51 forum.dingo-den.com systemd[1]: mariadb.service: Start operation timed out. Terminating.
Dec 11 17:58:53 forum.dingo-den.com systemd[1]: mariadb.service: Failed with result 'timeout'.
Dec 11 17:58:53 forum.dingo-den.com systemd[1]: Failed to start MariaDB 10.1.43 database server.

---

I did a reboot of the server and it now works again. It timed out when I tried to start maridb on the command line ?

So OK again for now

Not a MyBB issue, search for "mariadb.service: Start operation timed out. Terminating." on Google.