KeyHelp Community

Hallo

seit dem update von euch habe ich immer wieder Datenbank Verbindung Fehler
MySQL - Connection Error: 2002 (Connection refused) wenn ich die Seite ein paar mal aktualisiere funktioniert es wieder, aber die ganze Zeit Probleme mit Datenbank Verbindung nervt.
Vor dem Update hatte ich nie solche Probleme gehabt.

Ich bin sicher, dass die Ursache des Problems bei KeyHelp liegt

Debian 11

Keine

23.2 Build 3097

Wie oben schon erwähnt habe ich in mein Keyhelp Panel ganze zeit dieses Problem, meine Webseiten haben immer wieder diese Probleme,
bei manche Seiten obwohl die Domain Aktiv ist und auch eine Webseite vorhanden ist kommt
Not Found
The requested URL was not found on this server.
genau so wenn ich das anklicke http://sublimatos.admin.tirexhost.de kommt auch diese Fehler:
Not Found
The requested URL was not found on this server.

Ich würde mich über Hilfreiche antworten sehr freuen.
Vielen Dank

Grüße

Mal ein Auszug von meinem Error Log Datei

Code: Select all

[08-Oct-2023 13:45:07 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[08-Oct-2023 13:45:07 Europe/Berlin] PHP Warning:  DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[08-Oct-2023 13:45:07 Europe/Berlin] PHP Warning:  mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[08-Oct-2023 13:45:08 Europe/Berlin] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[08-Oct-2023 13:45:08 Europe/Berlin] PHP Warning:  mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[08-Oct-2023 13:45:08 Europe/Berlin] PHP Warning:  MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[08-Oct-2023 13:45:08 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[08-Oct-2023 13:45:08 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[08-Oct-2023 13:45:08 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[08-Oct-2023 13:45:08 Europe/Berlin] PHP Warning:  MySQL - Query Error:  () in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[08-Oct-2023 13:46:02 Europe/Berlin] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[08-Oct-2023 13:46:02 Europe/Berlin] PHP Warning:  MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[08-Oct-2023 13:46:02 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[08-Oct-2023 13:46:02 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[08-Oct-2023 13:46:02 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[08-Oct-2023 13:46:02 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[08-Oct-2023 13:46:02 Europe/Berlin] PHP Warning:  DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[08-Oct-2023 13:46:02 Europe/Berlin] PHP Warning:  mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[08-Oct-2023 13:46:03 Europe/Berlin] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[08-Oct-2023 13:46:03 Europe/Berlin] PHP Warning:  mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[08-Oct-2023 13:46:03 Europe/Berlin] PHP Warning:  MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[08-Oct-2023 13:46:03 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[08-Oct-2023 13:46:03 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[08-Oct-2023 13:46:03 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[08-Oct-2023 13:46:03 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[08-Oct-2023 13:46:03 Europe/Berlin] PHP Warning:  DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[08-Oct-2023 13:46:03 Europe/Berlin] PHP Warning:  mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[08-Oct-2023 13:46:04 Europe/Berlin] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[08-Oct-2023 13:46:04 Europe/Berlin] PHP Warning:  mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[08-Oct-2023 13:46:04 Europe/Berlin] PHP Warning:  MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[08-Oct-2023 13:46:04 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[08-Oct-2023 13:46:04 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[08-Oct-2023 13:46:04 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[08-Oct-2023 13:46:04 Europe/Berlin] PHP Warning:  MySQL - Query Error:  () in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[08-Oct-2023 13:46:04 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[08-Oct-2023 13:46:04 Europe/Berlin] PHP Warning:  DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[08-Oct-2023 13:46:04 Europe/Berlin] PHP Warning:  mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[08-Oct-2023 13:46:05 Europe/Berlin] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[08-Oct-2023 13:46:05 Europe/Berlin] PHP Warning:  mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[08-Oct-2023 13:46:05 Europe/Berlin] PHP Warning:  MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[08-Oct-2023 13:46:05 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[08-Oct-2023 13:46:05 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[08-Oct-2023 13:46:05 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[08-Oct-2023 13:46:05 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[08-Oct-2023 13:46:05 Europe/Berlin] PHP Warning:  DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[08-Oct-2023 13:46:05 Europe/Berlin] PHP Warning:  mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[08-Oct-2023 13:46:06 Europe/Berlin] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[08-Oct-2023 13:46:06 Europe/Berlin] PHP Warning:  mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[08-Oct-2023 13:46:06 Europe/Berlin] PHP Warning:  MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[08-Oct-2023 13:46:06 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[08-Oct-2023 13:46:06 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[08-Oct-2023 13:46:06 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[08-Oct-2023 13:46:06 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[08-Oct-2023 13:46:06 Europe/Berlin] PHP Warning:  DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[08-Oct-2023 13:46:06 Europe/Berlin] PHP Warning:  mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[08-Oct-2023 13:46:07 Europe/Berlin] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[08-Oct-2023 13:46:07 Europe/Berlin] PHP Warning:  mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[08-Oct-2023 13:46:07 Europe/Berlin] PHP Warning:  MySQL - Connection Error: 2002 (Connection refused) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[08-Oct-2023 13:46:07 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[08-Oct-2023 13:46:07 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[08-Oct-2023 13:46:07 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[08-Oct-2023 13:46:07 Europe/Berlin] PHP Warning:  MySQL - Query Error:  () in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[08-Oct-2023 13:46:07 Europe/Berlin] PHP Warning:  mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[08-Oct-2023 13:46:07 Europe/Berlin] PHP Warning:  DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[08-Oct-2023 13:46:07 Europe/Berlin] PHP Warning:  mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[08-Oct-2023 13:46:08 Europe/Berlin] PHP Notice:  DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[08-Oct-2023 13:46:08 Europe/Berlin] PHP Warning:  mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93

[Mod-Edit]
CODE-Tags eingefügt.
Konsolenausgaben, Inhalte von Konfigurationsdateien, Auszüge aus Logfiles o.ä. bitte zukünftig immer mit CODE-Tags versehen!

Läuft der DB Server überhaupt?
Was ist die Ausgabe von:

Code: Select all

systemctl status mariadb

Was noch anzumerken ist, die offizielle Beitragsvorlage wurde nicht ausgefüllt / genutzt.
Thread ist deshalb unübersichtlich.. Wo ich bereits in der Vergangenheit erleben muss, dass es eine Pflicht dazu gibt.

Die Seiten Funktionieren aber immer wieder kommt es zu Datenbank Probleme, wo Kurzzeitig die Seiten Datenbank Probleme anzeigen und nicht die gewünschte Seite.

Code: Select all

/$ systemctl status mariadb
● mariadb.service - MariaDB 10.5.21 database server
     Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
     Active: activating (start) since Sun 2023-10-08 21:45:06 CEST; 738ms ago
       Docs: man:mariadbd(8)
             https://mariadb.com/kb/en/library/systemd/
    Process: 502169 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
    Process: 502170 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
    Process: 502172 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
   Main PID: 502279 (mariadbd)
     Status: "Starting final batch to recover 485 pages from redo log"
      Tasks: 22 (limit: 36077)
     Memory: 117.4M
        CPU: 302ms
     CGroup: /system.slice/mariadb.service
             └─502279 /usr/sbin/mariadbd

Oct 08 21:45:07 admin.tirexhost.de mariadbd[502279]: 2023-10-08 21:45:07 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
Oct 08 21:45:07 admin.tirexhost.de mariadbd[502279]: 2023-10-08 21:45:07 0 [Note] Plugin 'FEEDBACK' is disabled.
Oct 08 21:45:07 admin.tirexhost.de mariadbd[502279]: 2023-10-08 21:45:07 0 [Note] Server socket created on IP: '127.0.0.1'.
Oct 08 21:45:07 admin.tirexhost.de mariadbd[502279]: 2023-10-08 21:45:07 0 [Note] Reading of all Master_info entries succeeded
Oct 08 21:45:07 admin.tirexhost.de mariadbd[502279]: 2023-10-08 21:45:07 0 [Note] Added new Master_info '' to hash table
Oct 08 21:45:07 admin.tirexhost.de mariadbd[502279]: 2023-10-08 21:45:07 0 [Note] /usr/sbin/mariadbd: ready for connections.
Oct 08 21:45:07 admin.tirexhost.de mariadbd[502279]: Version: '10.5.21-MariaDB-0+deb11u1'  socket: '/run/mysqld/mysqld.sock'  port: 3306  Debian 11
Oct 08 21:45:07 admin.tirexhost.de systemd[1]: Started MariaDB 10.5.21 database server.
Oct 08 21:45:07 admin.tirexhost.de /etc/mysql/debian-start[502324]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Oct 08 21:45:07 admin.tirexhost.de mariadbd[502279]: 2023-10-08 21:45:07 0 [Note] InnoDB: Buffer pool(s) load completed at 231008 21:45:07

[Mod-Edit]
CODE-Tags eingefügt.
Konsolenausgaben, Inhalte von Konfigurationsdateien, Auszüge aus Logfiles o.ä. bitte zukünftig immer mit CODE-Tags versehen!

Der Dienst scheint dort erst zu starten und das schon ganz schön lange:

Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: activating (start) since Sun 2023-10-08 21:45:06 CEST; 738ms ago

---

Entweder du hast eine defekte Datenbank/Tabelle, welche einen Start verzögert/behindert oder einen defekten SQL Dienst. Ich glaube aber ersteres aufgrund folgender Zeilen:

Oct 08 21:45:07 admin.tirexhost.de /etc/mysql/debian-start[502324]: Triggering myisam-recover for all MyISAM tables and aria-recover for all Aria tables
Oct 08 21:45:07 admin.tirexhost.de mariadbd[502279]: 2023-10-08 21:45:07 0 [Note] InnoDB: Buffer pool(s) load completed at 231008 21:45:07

Aktiviere doch bitte mal das Logging in eine Datei und schau einmal nach, was dieses dann meldet:
https://mariadb.com/kb/en/error-log/

Dafür kann aber KeyHelp nichts im direkten, wenn eine DB zB. bei einem Upgrade crasht oder inkompatibel ist

Moderativer Hinweis:

@BigBen:
Ich habe nun schon zum zweiten Mal hintereinander deine Beiträge moderieren müssen, um CODE-Tags einzufügen...Das ist aber nicht mein Job!
Du erwartest hier Hilfe, also leiste auch deinen eigenen Beitrag und formatiere zukünftig deine Beiträge.

Ich weise dich noch einmal darauf hin:
Konsolenausgaben, Inhalte von Konfigurationsdateien, Auszüge aus Logfiles o.ä. bitte zukünftig immer mit CODE-Tags versehen!

Jolinar wrote: ↑Sun 8. Oct 2023, 22:40 Moderativer Hinweis:

@BigBen:
Ich habe nun schon zum zweiten Mal hintereinander deine Beiträge moderieren müssen, um CODE-Tags einzufügen...Das ist aber nicht mein Job!
Du erwartest hier Hilfe, also leiste auch deinen eigenen Beitrag und formatiere zukünftig deine Beiträge.

Ich weise dich noch einmal darauf hin:
Konsolenausgaben, Inhalte von Konfigurationsdateien, Auszüge aus Logfiles o.ä. bitte zukünftig immer mit CODE-Tags versehen!

Ok Entschuldigung

KeyHelp Community

Datenbankverbindung Fehler

Datenbankverbindung Fehler

Re: Datenbankverbindung Fehler

Re: Datenbankverbindung Fehler

Re: Datenbankverbindung Fehler

Re: Datenbankverbindung Fehler

Re: Datenbankverbindung Fehler

Re: Datenbankverbindung Fehler