DataBase connection errors

[DavidCK]

Hello,

I've been getting database connection errors on my websites for more than week. I got this error:

froxlor[3673]: SQLSTATE[HY000] [2002] Connection refused
froxlor[3673]: --- DEBUG: #0 /var/www/froxlor/lib/classes/database/class.Database.php(297): PDO->__construct('mysql:d                                                                                                                        

bname=st...', 'stuser', 'DB_UNPRIV_PWD...', Array) #1 /var/www/froxlor/lib/classes/database/class.Database.php(183):                                                                                                                         Database::getDB() #2 /var/www/froxlor/lib/cron_init.php(92): Database::__callStatic('query', Array) #3 /var/www/froxl                      or/scripts/froxlor_master_cronjob.php(20): include_once('/var/www/froxlo...') #4 {main}
 

I've solved them with this command: sevice mariadb restart. However, I found today that the databases which my customers created are not working. For example, I ran a fresh wordpress installation today and the database created by customers is not connecting to complete the installation.

 

Any guess?

I appreciate your help. 

[d00p]

Anything in the system logs? 

[DavidCK]

51 minutes ago, d00p said:

Anything in the system logs? 

Feb  4 00:24:03  froxlor[4011]: SQLSTATE[HY000] [2002] Connection refused
Feb  4 00:24:03 froxlor[4012]: SQLSTATE[HY000] [2002] Connection refused
Feb  4 00:24:03  froxlor[4012]: --- DEBUG: #0 /var/www/froxlor/lib/classes/database/class.Database.php(297): PDO->__construct('mysql:dbname=st...', 'stuser', 'DB_UNPRIV_PWD...', Array) #1 /var/www/froxlor/lib/classes/dat$
Feb  4 00:24:03  froxlor[4011]: --- DEBUG: #0 /var/www/froxlor/lib/classes/database/class.Database.php(297): PDO->__construct('mysql:dbname=st...', 'stuser', 'DB_UNPRIV_PWD...', Array) #1 /var/www/froxlor/lib/classes/dat$
Feb  4 00:24:03 ip-172-26-13-168 postfix/pickup[2534]: 99CAC8207F: uid=0 from=<root>
 

Feb  4 00:29:18 kernel: [ 7839.329991] Out of memory: Kill process 4203 (mysqld) score 178 or sacrifice child
Feb  4 00:29:18  kernel: [ 7839.334578] Killed process 4203 (mysqld) total-vm:646552kB, anon-rss:89300kB, file-rss:0kB, shmem-rss:0kB
Feb  4 00:29:18  systemd[1]: mariadb.service: Main process exited, code=killed, status=9/KILL
Feb  4 00:29:18  systemd[1]: mariadb.service: Unit entered failed state.
Feb  4 00:29:18  systemd[1]: mariadb.service: Failed with result 'signal'.

[d00p]

that's just the error being logged when trying to connect. I meant something that indicates why the mariadb service seems to stop responding? Connection refused just indicates that the service cannot be reached. Never had this problem, this surely can have many causes....but froxlor is most likely none of them. Maybe google knows some more

[DavidCK]

Not enough memory? 

Feb  4 01:10:42  kernel: [10323.321102] Out of memory: Kill process 6700 (mysqld) score 170 or sacrifice child
Feb  4 01:10:42  kernel: [10323.338759] Killed process 6700 (mysqld) total-vm:646748kB, anon-rss:85280kB, file-rss:0kB, shmem-rss:0kB
Feb  4 01:10:42  systemd[1]: mariadb.service: Main process exited, code=killed, status=9/KILL
Feb  4 01:10:42  systemd[1]: mariadb.service: Unit entered failed state.
Feb  4 01:10:42  systemd[1]: mariadb.service: Failed with result 'signal'.
Feb  4 01:10:47  systemd[1]: mariadb.service: Service hold-off time over, scheduling restart.
Feb  4 01:10:47  systemd[1]: Stopped MariaDB 10.1.37 database server.
Feb  4 01:10:47  systemd[1]: Starting MariaDB 10.1.37 database server...
Feb  4 01:10:47  mysqld[7045]: 2019-02-04  1:10:47 140575933501888 [Note] /usr/sbin/mysqld (mysqld 10.1.37-MariaDB-0+deb9u1) starting as process 7045 ...
Feb  4 01:10:48  systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Feb  4 01:10:48 systemd[1]: Failed to start MariaDB 10.1.37 database server.
Feb  4 01:10:48  systemd[1]: mariadb.service: Unit entered failed state.
Feb  4 01:10:48  systemd[1]: mariadb.service: Failed with result 'exit-code'.
Feb  4 01:10:49  froxlor[7049]: SQLSTATE[HY000] [2002] Connection refused
Feb  4 01:10:49  froxlor[7049]: --- DEBUG: #0 /var/www/froxlor/lib/classes/database/class.Database.php(297): PDO->__construct('mysql:dbname=st...', 'stuser', 'DB_UNPRIV_PWD...', Array) #1 /var/www/froxlor/lib/classes/dat$

[d00p]

That is one possibility yes.