Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen!
- Manuel
- Posts: 58
- Joined: Fri 14. Jun 2019, 11:48
- Location: Echo-Gipfel, wo Träume Wirklichkeit werden
Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen!
Hallo Leute,
Ich habe nun auch ein Problem hoffe ihr könnt ,ir weiterhelfen und zwar.
Ich habe einen Ubuntu 20.04 (64-bit) Server mit dem Admin Panel Keyhelp 23.1.1 (Build 3016).
Seid etwa 2 Tagen läuft das Panell ca. 10-20 Minuten, danach ist der Server nur noch über SSH erreichbar und muss neu gestartet werden. Nach dem neustart funktioniert alles wieder um die 10-20 Minuten, danach wieder selbes spiel.
Kein Keyhelp aber SSH ok für reboot.
Ich habe die Firewall wie original angepasst.
Ich habe unter Backup Probleme lösen, alle Operationen, die sich im Status Startet in Kürze befinden entfernt.
Ich habe domains gelöscht, die nicht mehr aktiv sind, wo lets encrypt versuchte das zertifikat zu erneuern, natürlich vergeblich.
Nichts davon hat geholfen.
Was kann ich noch machen?
In welcher log Datei kann ich mögliche Fehler finden?
Hab mal unter SSH "top" und "htop" laufen lassen, kann da leider ned so viel rauslesen.
Hab mit dem server seid 1 Jahr nichts mehr gemacht und lief anstandslos, mein Admin ist mir auch davongestoben (neues Projekt), jetzt steh ich da mit naja mässiger Ahnung
Danke vielmals schon mal für die Hilfe.
LG Manuel
Server-Betriebssystem + Version
Ubuntu 20.04 (64-bit) Server
Eingesetzte Server-Virtualisierung-Technologie
Hetzner Auktion Dedizierter server
KeyHelp-Version + Build-Nummer
Keyhelp 23.1.1 (Build 3016)
Problembeschreibung / Fehlermeldungen
Webinterface von jetzt auf gleich nicht mehr zugänglich seit ca. 2 Tagen inklusive alle Webseiten, alles auf dem neuesten Stand, außer dass ich in der Konsole gefragt werde, ob ich auf Ubuntu 22 updaten möchte.
Ich habe den Verdacht, dass es ein Datenbankproblem sein könnte, da der Server immer über SSH erreichbar bleibt.
Schritte zur Reproduktion
Tritt nach jedem Neustart zwischen 10 und 20 Minuten immer wieder auf
Zusätzliche Informationen
Ich kann Log zur Verfügung stellen, ich weiß nur nicht, welche nützlich sind und der SSH zugriff funktioniert immer.
Ich habe nun auch ein Problem hoffe ihr könnt ,ir weiterhelfen und zwar.
Ich habe einen Ubuntu 20.04 (64-bit) Server mit dem Admin Panel Keyhelp 23.1.1 (Build 3016).
Seid etwa 2 Tagen läuft das Panell ca. 10-20 Minuten, danach ist der Server nur noch über SSH erreichbar und muss neu gestartet werden. Nach dem neustart funktioniert alles wieder um die 10-20 Minuten, danach wieder selbes spiel.
Kein Keyhelp aber SSH ok für reboot.
Ich habe die Firewall wie original angepasst.
Ich habe unter Backup Probleme lösen, alle Operationen, die sich im Status Startet in Kürze befinden entfernt.
Ich habe domains gelöscht, die nicht mehr aktiv sind, wo lets encrypt versuchte das zertifikat zu erneuern, natürlich vergeblich.
Nichts davon hat geholfen.
Was kann ich noch machen?
In welcher log Datei kann ich mögliche Fehler finden?
Hab mal unter SSH "top" und "htop" laufen lassen, kann da leider ned so viel rauslesen.
Hab mit dem server seid 1 Jahr nichts mehr gemacht und lief anstandslos, mein Admin ist mir auch davongestoben (neues Projekt), jetzt steh ich da mit naja mässiger Ahnung
Danke vielmals schon mal für die Hilfe.
LG Manuel
Server-Betriebssystem + Version
Ubuntu 20.04 (64-bit) Server
Eingesetzte Server-Virtualisierung-Technologie
Hetzner Auktion Dedizierter server
KeyHelp-Version + Build-Nummer
Keyhelp 23.1.1 (Build 3016)
Problembeschreibung / Fehlermeldungen
Webinterface von jetzt auf gleich nicht mehr zugänglich seit ca. 2 Tagen inklusive alle Webseiten, alles auf dem neuesten Stand, außer dass ich in der Konsole gefragt werde, ob ich auf Ubuntu 22 updaten möchte.
Ich habe den Verdacht, dass es ein Datenbankproblem sein könnte, da der Server immer über SSH erreichbar bleibt.
Schritte zur Reproduktion
Tritt nach jedem Neustart zwischen 10 und 20 Minuten immer wieder auf
Zusätzliche Informationen
Ich kann Log zur Verfügung stellen, ich weiß nur nicht, welche nützlich sind und der SSH zugriff funktioniert immer.
- Manuel
- Posts: 58
- Joined: Fri 14. Jun 2019, 11:48
- Location: Echo-Gipfel, wo Träume Wirklichkeit werden
Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen
Fals es hilft, hier mal der aktuelle php-error.log
Code: Select all
[26-Jul-2023 00:07:31 Europe/Berlin] PHP Warning: MySQL - Connection Error: 2002 (No such file or directory) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[26-Jul-2023 00:07:31 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[26-Jul-2023 00:07:31 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[26-Jul-2023 00:07:31 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[26-Jul-2023 00:07:31 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[26-Jul-2023 00:07:31 Europe/Berlin] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[26-Jul-2023 00:07:31 Europe/Berlin] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[26-Jul-2023 00:07:32 Europe/Berlin] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[26-Jul-2023 00:07:32 Europe/Berlin] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[26-Jul-2023 00:07:32 Europe/Berlin] PHP Warning: MySQL - Connection Error: 2002 (No such file or directory) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[26-Jul-2023 00:07:32 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[26-Jul-2023 00:07:32 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[26-Jul-2023 00:07:32 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[26-Jul-2023 00:07:32 Europe/Berlin] PHP Warning: MySQL - Query Error: () in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[27-Jul-2023 00:31:00 Europe/Berlin] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[28-Jul-2023 07:04:31 Europe/Berlin] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[29-Jul-2023 13:01:51 Europe/Berlin] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[30-Jul-2023 15:50:33 Europe/Berlin] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[31-Jul-2023 07:59:44 Europe/Berlin] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[01-Aug-2023 11:45:09 Europe/Berlin] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[01-Aug-2023 11:45:10 Europe/Berlin] PHP Warning: MySQL - Connection Error: 2002 (No such file or directory) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[01-Aug-2023 11:45:10 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[01-Aug-2023 11:45:10 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[01-Aug-2023 11:45:10 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[01-Aug-2023 11:45:10 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[01-Aug-2023 11:45:10 Europe/Berlin] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[01-Aug-2023 11:45:10 Europe/Berlin] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[01-Aug-2023 11:45:11 Europe/Berlin] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[01-Aug-2023 11:45:11 Europe/Berlin] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[01-Aug-2023 11:45:11 Europe/Berlin] PHP Warning: MySQL - Connection Error: 2002 (No such file or directory) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[01-Aug-2023 11:45:11 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[01-Aug-2023 11:45:11 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[01-Aug-2023 11:45:11 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[01-Aug-2023 11:45:11 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[01-Aug-2023 11:45:11 Europe/Berlin] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[01-Aug-2023 11:45:11 Europe/Berlin] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[01-Aug-2023 11:45:12 Europe/Berlin] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[01-Aug-2023 11:45:12 Europe/Berlin] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[01-Aug-2023 11:45:12 Europe/Berlin] PHP Warning: MySQL - Connection Error: 2002 (No such file or directory) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[01-Aug-2023 11:45:12 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[01-Aug-2023 11:45:12 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[01-Aug-2023 11:45:12 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[01-Aug-2023 11:45:12 Europe/Berlin] PHP Warning: MySQL - Query Error: () in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[02-Aug-2023 00:09:15 Europe/Berlin] PHP Warning: unlink(/home/keyhelp/.lock/update.lock): No such file or directory in /home/keyhelp/www/keyhelp/cronjob/mastercronjob.php on line 451
[02-Aug-2023 16:38:37 Europe/Berlin] PHP Warning: unlink(/home/keyhelp/.lock/update.lock): No such file or directory in /home/keyhelp/www/keyhelp/cronjob/mastercronjob.php on line 451
[03-Aug-2023 12:46:15 Europe/Berlin] PHP Warning: MySQL - Connection Error: 2002 (No such file or directory) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[03-Aug-2023 12:46:15 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[03-Aug-2023 12:46:15 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[03-Aug-2023 12:46:15 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[03-Aug-2023 12:46:15 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[03-Aug-2023 12:46:15 Europe/Berlin] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[03-Aug-2023 12:46:15 Europe/Berlin] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[03-Aug-2023 12:46:16 Europe/Berlin] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[03-Aug-2023 12:46:16 Europe/Berlin] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[03-Aug-2023 12:46:16 Europe/Berlin] PHP Warning: MySQL - Connection Error: 2002 (No such file or directory) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[03-Aug-2023 12:46:16 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[03-Aug-2023 12:46:16 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[03-Aug-2023 12:46:16 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[03-Aug-2023 12:46:16 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[03-Aug-2023 12:46:16 Europe/Berlin] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[03-Aug-2023 12:46:16 Europe/Berlin] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[03-Aug-2023 12:46:17 Europe/Berlin] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[03-Aug-2023 12:46:17 Europe/Berlin] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[03-Aug-2023 12:46:17 Europe/Berlin] PHP Warning: MySQL - Connection Error: 2002 (No such file or directory) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[03-Aug-2023 12:46:17 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[03-Aug-2023 12:46:17 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[03-Aug-2023 12:46:17 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[03-Aug-2023 12:46:17 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[03-Aug-2023 12:46:17 Europe/Berlin] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[03-Aug-2023 12:46:17 Europe/Berlin] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[03-Aug-2023 12:46:18 Europe/Berlin] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[03-Aug-2023 12:46:18 Europe/Berlin] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[03-Aug-2023 12:46:19 Europe/Berlin] PHP Warning: MySQL - Query Error: () in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[03-Aug-2023 12:46:19 Europe/Berlin] PHP Notice: Undefined index: version in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 426
[03-Aug-2023 13:54:09 Europe/Berlin] PHP Warning: unlink(/home/keyhelp/.lock/update.lock): No such file or directory in /home/keyhelp/www/keyhelp/cronjob/mastercronjob.php on line 451
[03-Aug-2023 14:01:08 Europe/Berlin] PHP Warning: MySQL - Connection Error: 2002 (No such file or directory) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[03-Aug-2023 14:01:09 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[03-Aug-2023 14:01:09 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[03-Aug-2023 14:01:09 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[03-Aug-2023 14:01:09 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[03-Aug-2023 14:01:09 Europe/Berlin] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[03-Aug-2023 14:01:09 Europe/Berlin] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[03-Aug-2023 14:01:10 Europe/Berlin] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[03-Aug-2023 14:01:10 Europe/Berlin] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[03-Aug-2023 14:01:10 Europe/Berlin] PHP Warning: MySQL - Connection Error: 2002 (No such file or directory) in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 315
[03-Aug-2023 14:01:10 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 86
[03-Aug-2023 14:01:10 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 87
[03-Aug-2023 14:01:10 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 88
[03-Aug-2023 14:01:10 Europe/Berlin] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 136
[03-Aug-2023 14:01:10 Europe/Berlin] PHP Warning: DBConnection::query(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 137
[03-Aug-2023 14:01:10 Europe/Berlin] PHP Warning: mysqli::ping(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 146
[03-Aug-2023 14:01:11 Europe/Berlin] PHP Notice: DB-Connection timed out, now reconnecting... in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 155
[03-Aug-2023 14:01:11 Europe/Berlin] PHP Warning: mysqli::close(): Couldn't fetch mysqli in /home/keyhelp/www/keyhelp/core/pending/DBConnection.php on line 93
[03-Aug-2023 15:07:25 Europe/Berlin] PHP Warning: Database error: SQLSTATE[08S01]: Communication link failure: 1053 Server shutdown in progress in /home/keyhelp/www/keyhelp/core-ns/Database/DatabaseConnection.php on line 492
[03-Aug-2023 15:07:26 Europe/Berlin] PHP Notice: Database connection timed out, reconnecting... in /home/keyhelp/www/keyhelp/core-ns/Database/DatabaseConnection.php on line 255
[03-Aug-2023 15:07:26 Europe/Berlin] PHP Warning: Database error: SQLSTATE[HY000] [2002] No such file or directory in /home/keyhelp/www/keyhelp/core-ns/Database/DatabaseConnection.php on line 492
[03-Aug-2023 15:07:27 Europe/Berlin] PHP Notice: Database connection timed out, reconnecting... in /home/keyhelp/www/keyhelp/core-ns/Database/DatabaseConnection.php on line 255
[03-Aug-2023 15:07:27 Europe/Berlin] PHP Warning: Database error: SQLSTATE[HY000] [2002] No such file or directory in /home/keyhelp/www/keyhelp/core-ns/Database/DatabaseConnection.php on line 492
[03-Aug-2023 15:07:28 Europe/Berlin] PHP Notice: Database connection timed out, reconnecting... in /home/keyhelp/www/keyhelp/core-ns/Database/DatabaseConnection.php on line 255
[03-Aug-2023 15:07:28 Europe/Berlin] PHP Warning: Database error: SQLSTATE[HY000] [2002] No such file or directory in /home/keyhelp/www/keyhelp/core-ns/Database/DatabaseConnection.php on line 492
Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen
mfg Micha
--
If Bill Gates had a nickel for every time Windows crashed …
… oh wait, he does.
--
If Bill Gates had a nickel for every time Windows crashed …
… oh wait, he does.
Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen
und prüfe zusätzlich noch:systemctl status mariadb.service
df -h
free -m
läuft amavis?
systemctl status amavis
dig localhost
und antwortet localhost?
ping localhost
- Manuel
- Posts: 58
- Joined: Fri 14. Jun 2019, 11:48
- Location: Echo-Gipfel, wo Träume Wirklichkeit werden
Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen
Hy, danke für die schnelle Rückmeldung24unix wrote: ↑Thu 3. Aug 2023, 18:27 Wie viel RAM hat die Kiste?
Was sagtCode: Select all
systemctl status mariadb.service
Hier ein screenshot zur Kiste:
https://ibb.co/crDQVhz
Der code sagt das, hab den server Namen vorerst geändert wenn das kein problem ist
Code: Select all
root@server ~ # systemctl status mariadb.service
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
● mariadb.service - MariaDB 10.3.38 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Thu 2023-08-03 20:32:54 CEST; 9min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 731 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 766 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 772 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_re>
Process: 1980 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1982 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 897 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 54 (limit: 38360)
Memory: 978.4M
CGroup: /system.slice/mariadb.service
└─897 /usr/sbin/mysqld
Aug 03 20:32:38 server.namegeaendert.net systemd[1]: Starting MariaDB 10.3.38 database server...
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Could not increase number of max_open_files t>
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Changed limits: max_open_files: 16544 max_co>
Aug 03 20:32:54 server.namegeaendert.net systemd[1]: Started MariaDB 10.3.38 database server.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-23/23 (END)
● mariadb.service - MariaDB 10.3.38 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Thu 2023-08-03 20:32:54 CEST; 9min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 731 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 766 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 772 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_rec>
Process: 1980 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1982 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 897 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 54 (limit: 38360)
Memory: 978.4M
CGroup: /system.slice/mariadb.service
└─897 /usr/sbin/mysqld
Aug 03 20:32:38 server.namegeaendert.net systemd[1]: Starting MariaDB 10.3.38 database server...
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Could not increase number of max_open_files to>
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Changed limits: max_open_files: 16544 max_con>
Aug 03 20:32:54 server.namegeaendert.net systemd[1]: Started MariaDB 10.3.38 database server.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-23/23 (END)
● mariadb.service - MariaDB 10.3.38 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Thu 2023-08-03 20:32:54 CEST; 9min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 731 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 766 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 772 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_reco>
Process: 1980 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1982 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 897 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 54 (limit: 38360)
Memory: 978.4M
CGroup: /system.slice/mariadb.service
└─897 /usr/sbin/mysqld
Aug 03 20:32:38 server.namegeaendert.net systemd[1]: Starting MariaDB 10.3.38 database server...
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Could not increase number of max_open_files to >
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Changed limits: max_open_files: 16544 max_conn>
Aug 03 20:32:54 server.namegeaendert.net systemd[1]: Started MariaDB 10.3.38 database server.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-23/23 (END)
● mariadb.service - MariaDB 10.3.38 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Thu 2023-08-03 20:32:54 CEST; 9min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 731 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 766 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 772 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recover>
Process: 1980 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1982 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 897 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 54 (limit: 38360)
Memory: 978.4M
CGroup: /system.slice/mariadb.service
└─897 /usr/sbin/mysqld
Aug 03 20:32:38 server.namegeaendert.net systemd[1]: Starting MariaDB 10.3.38 database server...
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Could not increase number of max_open_files to mor>
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Changed limits: max_open_files: 16544 max_connect>
Aug 03 20:32:54 server.namegeaendert.net systemd[1]: Started MariaDB 10.3.38 database server.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-23/23 (END)
● mariadb.service - MariaDB 10.3.38 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Thu 2023-08-03 20:32:54 CEST; 9min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 731 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 766 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 772 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery>
Process: 1980 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1982 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 897 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 54 (limit: 38360)
Memory: 978.4M
CGroup: /system.slice/mariadb.service
└─897 /usr/sbin/mysqld
Aug 03 20:32:38 server.namegeaendert.net systemd[1]: Starting MariaDB 10.3.38 database server...
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Could not increase number of max_open_files to more>
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Changed limits: max_open_files: 16544 max_connecti>
Aug 03 20:32:54 server.namegeaendert.net systemd[1]: Started MariaDB 10.3.38 database server.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-23/23 (END)
● mariadb.service - MariaDB 10.3.38 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Thu 2023-08-03 20:32:54 CEST; 9min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 731 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 766 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 772 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; >
Process: 1980 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1982 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 897 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 54 (limit: 38360)
Memory: 978.4M
CGroup: /system.slice/mariadb.service
└─897 /usr/sbin/mysqld
Aug 03 20:32:38 server.namegeaendert.net systemd[1]: Starting MariaDB 10.3.38 database server...
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Could not increase number of max_open_files to more th>
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Changed limits: max_open_files: 16544 max_connections>
Aug 03 20:32:54 server.namegeaendert.net systemd[1]: Started MariaDB 10.3.38 database server.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-23/23 (END)
● mariadb.service - MariaDB 10.3.38 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Thu 2023-08-03 20:32:54 CEST; 9min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 731 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 766 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 772 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ >
Process: 1980 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1982 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 897 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 54 (limit: 38360)
Memory: 978.4M
CGroup: /system.slice/mariadb.service
└─897 /usr/sbin/mysqld
Aug 03 20:32:38 server.namegeaendert.net systemd[1]: Starting MariaDB 10.3.38 database server...
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Could not increase number of max_open_files to more than>
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Changed limits: max_open_files: 16544 max_connections: >
Aug 03 20:32:54 server.namegeaendert.net systemd[1]: Started MariaDB 10.3.38 database server.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-23/23 (END)
● mariadb.service - MariaDB 10.3.38 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Thu 2023-08-03 20:32:54 CEST; 9min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 731 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 766 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 772 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? >
Process: 1980 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1982 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 897 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 54 (limit: 38360)
Memory: 978.4M
CGroup: /system.slice/mariadb.service
└─897 /usr/sbin/mysqld
Aug 03 20:32:38 server.namegeaendert.net systemd[1]: Starting MariaDB 10.3.38 database server...
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Could not increase number of max_open_files to more than 16>
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Changed limits: max_open_files: 16544 max_connections: 200>
Aug 03 20:32:54 server.namegeaendert.net systemd[1]: Started MariaDB 10.3.38 database server.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-23/23 (END)
● mariadb.service - MariaDB 10.3.38 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Thu 2023-08-03 20:32:54 CEST; 9min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 731 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 766 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 772 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq>
Process: 1980 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1982 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 897 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 54 (limit: 38360)
Memory: 978.4M
CGroup: /system.slice/mariadb.service
└─897 /usr/sbin/mysqld
Aug 03 20:32:38 server.namegeaendert.net systemd[1]: Starting MariaDB 10.3.38 database server...
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Could not increase number of max_open_files to more than 16544>
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Changed limits: max_open_files: 16544 max_connections: 200 (w>
Aug 03 20:32:54 server.namegeaendert.net systemd[1]: Started MariaDB 10.3.38 database server.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-23/23 (END)
● mariadb.service - MariaDB 10.3.38 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Thu 2023-08-03 20:32:54 CEST; 9min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 731 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 766 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 772 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0>
Process: 1980 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1982 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 897 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 54 (limit: 38360)
Memory: 978.4M
CGroup: /system.slice/mariadb.service
└─897 /usr/sbin/mysqld
Aug 03 20:32:38 server.namegeaendert.net systemd[1]: Starting MariaDB 10.3.38 database server...
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Could not increase number of max_open_files to more than 16544 (>
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Changed limits: max_open_files: 16544 max_connections: 200 (was>
Aug 03 20:32:54 server.namegeaendert.net systemd[1]: Started MariaDB 10.3.38 database server.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-23/23 (END)
● mariadb.service - MariaDB 10.3.38 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Thu 2023-08-03 20:32:54 CEST; 9min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 731 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 766 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 772 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]>
Process: 1980 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1982 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 897 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 54 (limit: 38360)
Memory: 978.4M
CGroup: /system.slice/mariadb.service
└─897 /usr/sbin/mysqld
Aug 03 20:32:38 server.namegeaendert.net systemd[1]: Starting MariaDB 10.3.38 database server...
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Could not increase number of max_open_files to more than 16544 (re>
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Changed limits: max_open_files: 16544 max_connections: 200 (was 2>
Aug 03 20:32:54 server.namegeaendert.net systemd[1]: Started MariaDB 10.3.38 database server.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-23/23 (END)
● mariadb.service - MariaDB 10.3.38 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Thu 2023-08-03 20:32:54 CEST; 9min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 731 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 766 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 772 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] >
Process: 1980 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1982 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 897 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 54 (limit: 38360)
Memory: 978.4M
CGroup: /system.slice/mariadb.service
└─897 /usr/sbin/mysqld
Aug 03 20:32:38 server.namegeaendert.net systemd[1]: Starting MariaDB 10.3.38 database server...
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Could not increase number of max_open_files to more than 16544 (req>
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Changed limits: max_open_files: 16544 max_connections: 200 (was 20>
Aug 03 20:32:54 server.namegeaendert.net systemd[1]: Started MariaDB 10.3.38 database server.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-23/23 (END)
● mariadb.service - MariaDB 10.3.38 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Thu 2023-08-03 20:32:54 CEST; 9min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 731 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 766 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 772 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] >
Process: 1980 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1982 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 897 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 54 (limit: 38360)
Memory: 978.4M
CGroup: /system.slice/mariadb.service
└─897 /usr/sbin/mysqld
Aug 03 20:32:38 server.namegeaendert.net systemd[1]: Starting MariaDB 10.3.38 database server...
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Could not increase number of max_open_files to more than 16544 (requ>
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Changed limits: max_open_files: 16544 max_connections: 200 (was 200>
Aug 03 20:32:54 server.namegeaendert.net systemd[1]: Started MariaDB 10.3.38 database server.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-23/23 (END)
● mariadb.service - MariaDB 10.3.38 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Thu 2023-08-03 20:32:54 CEST; 9min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 731 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 766 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 772 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] >
Process: 1980 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1982 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 897 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 54 (limit: 38360)
Memory: 978.4M
CGroup: /system.slice/mariadb.service
└─897 /usr/sbin/mysqld
Aug 03 20:32:38 server.namegeaendert.net systemd[1]: Starting MariaDB 10.3.38 database server...
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Could not increase number of max_open_files to more than 16544 (reque>
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Changed limits: max_open_files: 16544 max_connections: 200 (was 200)>
Aug 03 20:32:54 server.namegeaendert.net systemd[1]: Started MariaDB 10.3.38 database server.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-23/23 (END)
● mariadb.service - MariaDB 10.3.38 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Thu 2023-08-03 20:32:54 CEST; 9min ago
Docs: man:mysqld(8)
https://mariadb.com/kb/en/library/systemd/
Process: 731 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 766 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 772 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] &>
Process: 1980 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 1982 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
Main PID: 897 (mysqld)
Status: "Taking your SQL requests now..."
Tasks: 54 (limit: 38360)
Memory: 978.4M
CGroup: /system.slice/mariadb.service
└─897 /usr/sbin/mysqld
Aug 03 20:32:38 server.namegeaendert.net systemd[1]: Starting MariaDB 10.3.38 database server...
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Could not increase number of max_open_files to more than 16544 (reques>
Aug 03 20:32:41 server.namegeaendert.net mysqld[897]: 2023-08-03 20:32:41 0 [Warning] Changed limits: max_open_files: 16544 max_connections: 200 (was 200) >
Aug 03 20:32:54 server.namegeaendert.net systemd[1]: Started MariaDB 10.3.38 database server.
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1-23/23 (END)
- Manuel
- Posts: 58
- Joined: Fri 14. Jun 2019, 11:48
- Location: Echo-Gipfel, wo Träume Wirklichkeit werden
Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen
df-h sagt folgendes:
Code: Select all
root@server ~ # df -h
Filesystem Size Used Avail Use% Mounted on
udev 16G 0 16G 0% /dev
tmpfs 3.2G 1.1M 3.2G 1% /run
/dev/md2 1007G 230G 726G 25% /
tmpfs 16G 0 16G 0% /dev/shm
tmpfs 5.0M 0 5.0M 0% /run/lock
tmpfs 16G 0 16G 0% /sys/fs/cgroup
/dev/md3 1.7T 333G 1.3T 21% /home
/dev/md1 486M 158M 302M 35% /boot
tmpfs 3.2G 0 3.2G 0% /run/user/0
free -m sagt das:
Code: Select all
root@server ~ # free -m
total used free shared buff/cache available
Mem: 32031 2574 27028 155 2429 28874
Swap: 16367 0 16367
systemctl status amavis sagt das:
Code: Select all
root@server ~ # systemctl status amavis
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
lines 1--1...skipping...
● amavis.service - LSB: Starts amavisd-new mailfilter
Loaded: loaded (/etc/init.d/amavis; generated)
Active: active (running) since Thu 2023-08-03 20:32:51 CEST; 21min ago
Docs: man:systemd-sysv-generator(8)
Process: 725 ExecStart=/etc/init.d/amavis start (code=exited, status=0/SUCCESS)
Tasks: 3 (limit: 38360)
Memory: 171.9M
CGroup: /system.slice/amavis.service
├─1944 /usr/sbin/amavisd-new (master)
├─1989 /usr/sbin/amavisd-new (virgin child)
└─1990 /usr/sbin/amavisd-new (virgin child)
Aug 03 20:32:51 server.namegeaendert.net amavis[1944]: No ext program for .doc, tried: ripole
Aug 03 20:32:51 server.namegeaendert.net amavis[1944]: No ext program for .cab, tried: cabextract
Aug 03 20:32:51 server.namegeaendert.net amavis[1944]: No decoder for .F
Aug 03 20:32:51 server.namegeaendert.net amavis[1944]: No decoder for .arc
Aug 03 20:32:51 server.namegeaendert.net amavis[1944]: No decoder for .doc
Aug 03 20:32:51 server.namegeaendert.net amavis[1944]: No decoder for .lrz
Aug 03 20:32:51 server.namegeaendert.net amavis[1944]: No decoder for .lzo
Aug 03 20:32:51 server.namegeaendert.net amavis[1944]: No decoder for .zoo
Aug 03 20:32:51 server.namegeaendert.net amavis[1944]: Using primary internal av scanner code for ClamAV-clamd
Aug 03 20:32:51 server.namegeaendert.net amavis[1944]: Found secondary av scanner ClamAV-clamscan at /usr/bin/clamscan
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
root@server ~ #
Code: Select all
root@server ~ # dig localhost
; <<>> DiG 9.16.1-Ubuntu <<>> localhost
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 31019
;; flags: qr rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 1
;; OPT PSEUDOSECTION:
; EDNS: version: 0, flags:; udp: 65494
;; QUESTION SECTION:
;localhost. IN A
;; ANSWER SECTION:
localhost. 0 IN A 127.0.0.1
;; Query time: 0 msec
;; SERVER: 127.0.0.53#53(127.0.0.53)
;; WHEN: Thu Aug 03 20:55:22 CEST 2023
;; MSG SIZE rcvd: 54
Code: Select all
PING localhost.localdomain (127.0.0.1) 56(84) bytes of data.
64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=1 ttl=64 time=0.038 ms
64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=2 ttl=64 time=0.039 ms
64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=3 ttl=64 time=0.038 ms
64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=4 ttl=64 time=0.034 ms
64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=5 ttl=64 time=0.037 ms
64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=6 ttl=64 time=0.037 ms
64 bytes from localhost.localdomain (127.0.0.1): icmp_seq=7 ttl=64 time=0.049 ms
Vielen lieben Dank leute!
- Manuel
- Posts: 58
- Joined: Fri 14. Jun 2019, 11:48
- Location: Echo-Gipfel, wo Träume Wirklichkeit werden
Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen
Also aktuell läuft er noch.
So lange ging er noch nie seid 2 Tagen
https://ibb.co/d2LjKPQ
Ich will es nicht verschreien, aber kann es sein dass sich ein derartiges problem nach tagen selber löst?
Jetzt ist es schon über eine stunde.
UPDATE:
Zu früh gefreut
Nach etwa 2 Stunden wieder von vorne.
Leider
So lange ging er noch nie seid 2 Tagen
https://ibb.co/d2LjKPQ
Ich will es nicht verschreien, aber kann es sein dass sich ein derartiges problem nach tagen selber löst?
Jetzt ist es schon über eine stunde.
UPDATE:
Zu früh gefreut
Nach etwa 2 Stunden wieder von vorne.
Leider
Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen
Dein Terminal ist etwas strange, viele, sehr viele unnötige Zeilen …
Egal, öffne mal eins, lasse es offen und tipp da
Code: Select all
journalctl -f
mfg Micha
--
If Bill Gates had a nickel for every time Windows crashed …
… oh wait, he does.
--
If Bill Gates had a nickel for every time Windows crashed …
… oh wait, he does.
Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen
Deine Datenbanken bzw. Einstellungen für Mysql sind nicht optimal.
versuche mal:
Code: Select all
nano /lib/systemd/system/mariadb.service
# suche und ändern
LimitNOFILE=80000
# oder auf infinity setzen
cp /lib/systemd/system/mariadb.service /etc/systemd/system/mariadb.service
nano /etc/security/limits.conf
* soft nofile 95535
* hard nofile 95535
root soft nofile 95535
root hard nofile 95535
systemctl daemon-reload
systemctl restart mysql
Code: Select all
mysqlcheck --auto-repair --optimize --all-databases
Code: Select all
apt-get install mysqltuner
perl mysqltuner.pl
Last edited by Ralph on Fri 4. Aug 2023, 11:43, edited 1 time in total.
- Manuel
- Posts: 58
- Joined: Fri 14. Jun 2019, 11:48
- Location: Echo-Gipfel, wo Träume Wirklichkeit werden
Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen
Hy, danke für den Tip, lass ich gerade laufen das journalctl -f, aber aktuell hat sich nix geändert.24unix wrote: ↑Thu 3. Aug 2023, 23:42Dein Terminal ist etwas strange, viele, sehr viele unnötige Zeilen …
Egal, öffne mal eins, lasse es offen und tipp daund schau (und poste hier), was passiert, wen Du die Verbindung zum Panel verlierst.Code: Select all
journalctl -f
Ich habe mittlerweile so eine Vorahnung das es eventuell eine Website gewesen sein könnte oder immer noch ist, da wenn ich diese lange nicht geöffnet habe der server lief und kurz danach wieder reboot nötig war.
War ein Shopware 5 shop, der ewig nicht upgedatet wurde.
Wurde nun Upgedatete inkl. aller plugins, mal sehen.
nano /lib/systemd/system/mariadb.serviceRalph wrote: ↑Fri 4. Aug 2023, 08:12Deine Datenbanken bzw. Einstellungen für Mysql sind nicht optimal.
versuche mal:optimieren:Code: Select all
nano /lib/systemd/system/mariadb.service # suche und ändern LimitNOFILE=80000 LimitMEMLOCK=80000 # oder auf infinity setzen cp /lib/systemd/system/mariadb.service /etc/systemd/system/mariadb.service nano /etc/security/limits.conf * soft nofile 95535 * hard nofile 95535 root soft nofile 95535 root hard nofile 95535 systemctl daemon-reload systemctl restart mysql
Code: Select all
mysqlcheck --auto-repair --optimize --all-databases
Code: Select all
apt-get install mysqltuner perl mysqltuner.pl
Ich habe nur LimitNOFILE in der Datei gefunden und kein LimitMEMLOCK, hab aber dadurch aktuell auch noch nichts geändert.
Ist cp /lib/systemd/system/mariadb.service /etc/systemd/system/mariadb.service auch ein Befehl oder gehts da um die Datei wo sie sein könnte?
nano /etc/security/limits.conf
Hier habe ich erstmal auch nichts geändert, aber mal alle Befehle ausgeführt.
Optimiert hab ich auch und die Datenbank ist Aktuell.
Wie gesagt, hab ich mal auf verdacht den Shopware shop upgedatet, danach kann ich deine Empfehlungen immer noch ändern bzw. in den Nano Dein nachtragen wenn das geht.
Danke erstmal für die vielen tollen tips, ich melde mich wieder
Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen
Dein System blockiert die von Mysql geforderten max open_files, das mußt du dann schon selber machen wie oben beschrieben (komplett).Could not increase number of max_open_files to more than 16544
Alternativ kannst du natürlich auch sämtliche Datenbanken löschen um wieder unter das open_files Limit zu kommen
Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen
Hallo,
zum Ändern der Open Files bei MariaDB sollte man so vorgehen:
1. systemctl edit mariadb
2. Gewünschten Wert setzen, z.B.:
3. systemctl restart mariadb
4. Prüfen:
Wie immer bei Abstürzen sollte man auch mal "dmesg" zu Rate ziehen. Ggf. gibt es hier Segmentation faults oder der OOM Killer schlägt zu.
zum Ändern der Open Files bei MariaDB sollte man so vorgehen:
1. systemctl edit mariadb
2. Gewünschten Wert setzen, z.B.:
Code: Select all
[Service]
LimitNOFILE=64000
4. Prüfen:
Code: Select all
egrep "open files" /proc/$(cat `mysql -Ne "show variables like 'pid_file'" | awk '{print $2}'`)/limits
Wie immer bei Abstürzen sollte man auch mal "dmesg" zu Rate ziehen. Ggf. gibt es hier Segmentation faults oder der OOM Killer schlägt zu.
Mit freundlichen Grüßen / Best regards
Florian Cheno
**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
Florian Cheno
**************************************************************
Keyweb AG - Die Hosting Marke
Neuwerkstr. 45/46, 99084 Erfurt / Germany
http://www.keyweb.de - http://www.keyhelp.de
**************************************************************
- Manuel
- Posts: 58
- Joined: Fri 14. Jun 2019, 11:48
- Location: Echo-Gipfel, wo Träume Wirklichkeit werden
Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen
Ich finde in der Datei nur folgende Zeile:Ralph wrote: ↑Fri 4. Aug 2023, 11:34Dein System blockiert die von Mysql geforderten max open_files, das mußt du dann schon selber machen wie oben beschrieben (komplett).Could not increase number of max_open_files to more than 16544
Alternativ kannst du natürlich auch sämtliche Datenbanken löschen um wieder unter das open_files Limit zu kommen
Code: Select all
# Number of files limit. previously [mysqld_safe] open-files-limit
LimitNOFILE=32768
# Maximium core size. previously [mysqld_safe] core-file-size
# LimitCore=
Was meinst du mit der Zeile?
cp /lib/systemd/system/mariadb.service /etc/systemd/system/mariadb.service
Unter nano /etc/security/limits.conf hab ich folgendes stehen:
Code: Select all
root@server ~ # nano /etc/security/limits.conf
GNU nano 4.8 /etc/security/limits.conf
# - a group name, with @group syntax
# - the wildcard *, for default entry
# - the wildcard %, can be also used with %group syntax,
# for maxlogin limit
# - NOTE: group and wildcard limits are not applied to root.
# To apply a limit to the root user, <domain> must be
# the literal username root.
#
#<type> can have the two values:
# - "soft" for enforcing the soft limits
# - "hard" for enforcing hard limits
#
#<item> can be one of the following:
# - core - limits the core file size (KB)
# - data - max data size (KB)
# - fsize - maximum filesize (KB)
# - memlock - max locked-in-memory address space (KB)
# - nofile - max number of open file descriptors
# - rss - max resident set size (KB)
# - stack - max stack size (KB)
# - cpu - max CPU time (MIN)
# - nproc - max number of processes
# - as - address space limit (KB)
# - maxlogins - max number of logins for this user
# - maxsyslogins - max number of logins on the system
# - priority - the priority to run user process with
# - locks - max number of file locks the user can hold
# - sigpending - max number of pending signals
# - msgqueue - max memory used by POSIX message queues (bytes)
# - nice - max nice priority allowed to raise to values: [-20, 19]
# - rtprio - max realtime priority
# - chroot - change root to directory (Debian-specific)
#
#<domain> <type> <item> <value>
#
#* soft core 0
#root hard core 100000
#* hard rss 10000
#@student hard nproc 20
#@faculty soft nproc 20
#@faculty hard nproc 50
#ftp hard nproc 0
#ftp - chroot /ftp
#@student - maxlogins 4
# End of file
Soll ich deine werte einfach direkt unter #@student - maxlogins 4 ohne # ergänzen und speichern?
Danke dir.
Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen
Du mußt LimitNOFILE erhöhen, wie hoch kannst Du überprüfen bzw. einfach mal testen mit geschätzten 60 bis 80000 ...
Danach alles neu durchladen oder reboot, dann am Ende die Optimierung, mysqltuner wird dabei Werte vorschlagen auch für open-files-limit.
- Manuel
- Posts: 58
- Joined: Fri 14. Jun 2019, 11:48
- Location: Echo-Gipfel, wo Träume Wirklichkeit werden
Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen
Hallo, danke, aber ich komm ned weiter, ich kann das ned speichern. Hab an Mac, control+O geht in der Datei ned.Florian wrote: ↑Fri 4. Aug 2023, 11:43 Hallo,
zum Ändern der Open Files bei MariaDB sollte man so vorgehen:
1. systemctl edit mariadb
2. Gewünschten Wert setzen, z.B.:
3. systemctl restart mariadbCode: Select all
[Service] LimitNOFILE=64000
4. Prüfen:Code: Select all
egrep "open files" /proc/$(cat `mysql -Ne "show variables like 'pid_file'" | awk '{print $2}'`)/limits
Wie immer bei Abstürzen sollte man auch mal "dmesg" zu Rate ziehen. Ggf. gibt es hier Segmentation faults oder der OOM Killer schlägt zu.
Code: Select all
root@server ~ # systemctl edit mariadb
[Service]
LimitNOFILE=64000
--**-Mg: .#override.confd1f64fa3b0e02425 (fundamental)----All--------------------------------------------------------------
Code: Select all
root@server ~ # egrep "open files" /proc/$(cat `mysql -Ne "show variables like 'pid_file'" | awk '{print $2}'`)/limits
Max open files 16544 16544 files
root@server ~ #