Database issues?!

Support
1

My YunoHost server

Hardware: amd 64 rack.
YunoHost version: Latest stabele i cannot acces it now…
I have access to my server : Yes.
Are you in a special context, or did you perform some particular tweaking on your YunoHost instance ? : no

Description of my issue

Since yesterday, I get downtime on my database websites such as WordPress are saying; error establishing database connection, when I try to log in on the admin panel it loops back to the password field. I tried an ssh reboot before, which worked for a few hours, then it showed the errors again.

So I try to give a reboot command, but now it gives me;

-bash: warning: setlocale: LC_ALL: cannot change locale (en_US.UTF-8)
 root@ecz-srv-01:~# reboot now
 root@ecz-srv-01:~# reboot
 Failed to open initctl fifo: No such device or address
 Failed to talk to init daemon.
 root@ecz-srv-01:~# reboot now
 Failed to open initctl fifo: No such device or address

Thanks for your help!

2

I’ve had that few month ago.

Try :

systemctl --force reboot

If it doesn’t work, do :

systemctl --force --force reboot

Let us know how it goes

3

Yeah, or walk to system and press power button :wink:

However, this does not short the db issue, any words on that?

4

What does answer this command :

yunohost service status

5 
avahi-daemon: 
  configuration: unknown
  description: Allows you to reach your server using 'yunohost.local' in your local network
  last_state_change: 2021-07-26 12:52:50
  start_on_boot: enabled
  status: running
dnsmasq: 
  configuration: valid
  description: Handles domain name resolution (DNS)
  last_state_change: 2021-07-26 12:52:50
  start_on_boot: enabled
  status: running
dovecot: 
  configuration: unknown
  description: Allows e-mail clients to access/fetch email (via IMAP and POP3)
  last_state_change: 2021-07-26 12:52:50
  start_on_boot: enabled
  status: running
fail2ban: 
  configuration: valid
  description: Protects against brute-force and other kinds of attacks from the Internet
  last_state_change: 2021-07-26 12:53:05
  start_on_boot: enabled
  status: running
metronome: 
  configuration: unknown
  description: Manage XMPP instant messaging accounts
  last_state_change: 2021-07-26 12:52:51
  start_on_boot: enabled
  status: running
mysql: 
  configuration: unknown
  description: Stores app data (SQL database)
  last_state_change: 2021-07-26 12:52:53
  start_on_boot: enabled
  status: running
nginx: 
  configuration: valid
  description: Serves or provides access to all the websites hosted on your server
  last_state_change: 2021-07-26 12:52:52
  start_on_boot: enabled
  status: running
php7.3-fpm: 
  configuration: valid
  description: Runs apps written in PHP with NGINX
  last_state_change: 2021-07-26 12:52:52
  start_on_boot: enabled
  status: running
php7.4-fpm: 
  configuration: unknown
  description: The PHP 7.4 FastCGI Process Manager
  last_state_change: 2021-07-26 12:52:51
  start_on_boot: enabled
  status: running
postfix: 
  configuration: unknown
  description: Used to send and receive e-mails
  last_state_change: 2021-07-26 12:52:52
  start_on_boot: enabled
  status: running
redis-server: 
  configuration: unknown
  description: A specialized database used for rapid data access, task queue, and communication between programs
  last_state_change: 2021-07-26 12:52:50
  start_on_boot: enabled
  status: running
rspamd: 
  configuration: unknown
  description: Filters spam, and other e-mail related features
  last_state_change: 2021-07-26 12:52:50
  start_on_boot: enabled
  status: running
slapd: 
  configuration: valid
  description: Stores users, domains and related info
  last_state_change: 2021-07-26 12:52:50
  start_on_boot: enabled
  status: running
ssh: 
  configuration: valid
  description: Allows you to connect remotely to your server via a terminal (SSH protocol)
  last_state_change: 2021-07-26 12:52:50
  start_on_boot: enabled
  status: running
yunohost-api: 
  configuration: unknown
  description: Manages interactions between the YunoHost web interface and the system
  last_state_change: 2021-07-26 12:52:50
  start_on_boot: enabled
  status: running
yunohost-firewall: 
  configuration: unknown
  description: Manages open and close connection ports to services
  last_state_change: 2021-07-26 12:53:05
  start_on_boot: enabled
  status: running
root@ecz-srv-01:~#
6

What about :
systemctl status mysql

And :
df -h

?

7 
● mariadb.service - MariaDB 10.3.29 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: active (running) since Mon 2021-07-26 12:52:53 CEST; 2h 43min ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 650 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
  Process: 691 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 715 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl se
  Process: 1621 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 1639 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
 Main PID: 795 (mysqld)
   Status: "Taking your SQL requests now..."
    Tasks: 40 (limit: 4915)
   Memory: 605.3M
   CGroup: /system.slice/mariadb.service
           └─795 /usr/sbin/mysqld

Jul 26 12:52:53 ecz-srv-01 mysqld[795]: 2021-07-26 12:52:53 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Jul 26 12:52:53 ecz-srv-01 mysqld[795]: 2021-07-26 12:52:53 0 [Note] Server socket created on IP: '::'.
Jul 26 12:52:53 ecz-srv-01 mysqld[795]: 2021-07-26 12:52:53 0 [Note] Reading of all Master_info entries succeeded
Jul 26 12:52:53 ecz-srv-01 mysqld[795]: 2021-07-26 12:52:53 0 [Note] Added new Master_info '' to hash table
Jul 26 12:52:53 ecz-srv-01 mysqld[795]: 2021-07-26 12:52:53 0 [Note] /usr/sbin/mysqld: ready for connections.
Jul 26 12:52:53 ecz-srv-01 mysqld[795]: Version: '10.3.29-MariaDB-0+deb10u1'  socket: '/var/run/mysqld/mysqld.sock'  port: 3306  Debian 10
Jul 26 12:52:53 ecz-srv-01 systemd[1]: Started MariaDB 10.3.29 database server.
Jul 26 12:52:53 ecz-srv-01 /etc/mysql/debian-start[1677]: Checking for insecure root accounts.
Jul 26 12:52:53 ecz-srv-01 /etc/mysql/debian-start[1682]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Jul 26 12:52:53 ecz-srv-01 mysqld[795]: 2021-07-26 12:52:53 0 [Note] InnoDB: Buffer pool(s) load completed at 210726 12:52:53
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~

[1]+  Stopped                 systemctl status mysql
root@ecz-srv-01:~# df -h
Filesystem      Size  Used Avail Use% Mounted on
udev             15G     0   15G   0% /dev
tmpfs           3.0G   27M  3.0G   1% /run
/dev/sdc2       878G  220G  614G  27% /
tmpfs            15G     0   15G   0% /dev/shm
tmpfs           5.0M     0  5.0M   0% /run/lock
tmpfs            15G     0   15G   0% /sys/fs/cgroup
/dev/sdc1       511M  3.3M  508M   1% /boot/efi
tmpfs           3.0G     0  3.0G   0% /run/user/0
8

OK.
Where did you see the original error message (error establishing database connection) ?
Can you post it here ?

9

As i said

10

WHERE did you get this message ?
Where as in where was it, on your terminal, on your web browser ?

11

browser

12

I was also having similar issues… Did the issue get resolved?

13

yes by just restarting the services

14

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