Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen!

For topics beyond KeyHelp. / Für Themen jenseits von KeyHelp.
User avatar
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!

Post by Manuel »

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 :cry:

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.
User avatar
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

Post by Manuel »

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
User avatar
24unix
Posts: 1648
Joined: Sun 21. Jun 2020, 17:16
Location: Kollmar
Contact:

Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen

Post by 24unix »

Wie viel RAM hat die Kiste?

Was sagt

Code: Select all

systemctl status mariadb.service
mfg Micha
--
If Bill Gates had a nickel for every time Windows crashed …
… oh wait, he does.
User avatar
Ralph
Posts: 850
Joined: Mon 30. Mar 2020, 16:14

Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen

Post by Ralph »

systemctl status mariadb.service
und prüfe zusätzlich noch:
df -h
free -m

läuft amavis?
systemctl status amavis

dig localhost
und antwortet localhost?
ping localhost
User avatar
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

Post by Manuel »

24unix wrote: Thu 3. Aug 2023, 18:27 Wie viel RAM hat die Kiste?

Was sagt

Code: Select all

systemctl status mariadb.service
Hy, danke für die schnelle Rückmeldung :D

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)
User avatar
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

Post by Manuel »

Ralph wrote: Thu 3. Aug 2023, 19:19
systemctl status mariadb.service
und prüfe zusätzlich noch:
df -h
free -m

läuft amavis?
systemctl status amavis

dig localhost
und antwortet localhost?
ping localhost

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 ~ # 
dig localhost sagt das:

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
ping localhost läuft auch:

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! :D
User avatar
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

Post by Manuel »

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? :shock:
Jetzt ist es schon über eine stunde.

UPDATE:
Zu früh gefreut :cry:
Nach etwa 2 Stunden wieder von vorne.
Leider
User avatar
24unix
Posts: 1648
Joined: Sun 21. Jun 2020, 17:16
Location: Kollmar
Contact:

Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen

Post by 24unix »

Manuel wrote: Thu 3. Aug 2023, 21:27 Zu früh gefreut :cry:
Nach etwa 2 Stunden wieder von vorne.
Leider
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
und schau (und poste hier), was passiert, wen Du die Verbindung zum Panel verlierst.
mfg Micha
--
If Bill Gates had a nickel for every time Windows crashed …
… oh wait, he does.
User avatar
Ralph
Posts: 850
Joined: Mon 30. Mar 2020, 16:14

Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen

Post by Ralph »

Manuel wrote: Thu 3. Aug 2023, 21:27 Could not increase number of max_open_files to more than 16544
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
optimieren:

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.
User avatar
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

Post by Manuel »

24unix wrote: Thu 3. Aug 2023, 23:42
Manuel wrote: Thu 3. Aug 2023, 21:27 Zu früh gefreut :cry:
Nach etwa 2 Stunden wieder von vorne.
Leider
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
und schau (und poste hier), was passiert, wen Du die Verbindung zum Panel verlierst.
Hy, danke für den Tip, lass ich gerade laufen das journalctl -f, aber aktuell hat sich nix geändert.
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.


Ralph wrote: Fri 4. Aug 2023, 08:12
Manuel wrote: Thu 3. Aug 2023, 21:27 Could not increase number of max_open_files to more than 16544
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
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
optimieren:

Code: Select all

mysqlcheck --auto-repair --optimize --all-databases

Code: Select all

apt-get install mysqltuner
perl mysqltuner.pl
nano /lib/systemd/system/mariadb.service
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 :D
User avatar
Ralph
Posts: 850
Joined: Mon 30. Mar 2020, 16:14

Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen

Post by Ralph »

Could not increase number of max_open_files to more than 16544
Dein System blockiert die von Mysql geforderten max open_files, das mußt du dann schon selber machen wie oben beschrieben (komplett).
Alternativ kannst du natürlich auch sämtliche Datenbanken löschen um wieder unter das open_files Limit zu kommen :D
User avatar
Florian
Keyweb AG
Posts: 1261
Joined: Wed 20. Jan 2016, 02:28

Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen

Post by Florian »

Hallo,

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
3. systemctl restart mariadb

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
**************************************************************
User avatar
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

Post by Manuel »

Ralph wrote: Fri 4. Aug 2023, 11:34
Could not increase number of max_open_files to more than 16544
Dein System blockiert die von Mysql geforderten max open_files, das mußt du dann schon selber machen wie oben beschrieben (komplett).
Alternativ kannst du natürlich auch sämtliche Datenbanken löschen um wieder unter das open_files Limit zu kommen :D
Ich finde in der Datei nur folgende Zeile:

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=
Muss ich hier die LimitNOFILE=32768 einfach ändern zu den 80000 und die LimitMEMLOCK darunter ergänzen?

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.
User avatar
Ralph
Posts: 850
Joined: Mon 30. Mar 2020, 16:14

Re: Keyhelp-Webinterface und alle Webseiten immer kurz nach Neustart unzugänglich, Server nur noch über SSH zu erreichen

Post by Ralph »

Manuel wrote: Fri 4. Aug 2023, 11:48 Ich finde in der Datei nur folgende Zeile:
LimitNOFILE=32768

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.
User avatar
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

Post by Manuel »

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.:

Code: Select all

[Service]
LimitNOFILE=64000
3. systemctl restart mariadb

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.
Hallo, danke, aber ich komm ned weiter, ich kann das ned speichern. Hab an Mac, control+O geht in der Datei ned.

Code: Select all

root@server ~ # systemctl edit mariadb

[Service]
LimitNOFILE=64000



























--**-Mg: .#override.confd1f64fa3b0e02425  (fundamental)----All--------------------------------------------------------------

Ausserdem versteh i ned ganz, warum in der Datei nano /lib/systemd/system/mariadb.service LimitNOFILE32xxx gestanden ist, habs vor deinem Post schon auf LimitNOFILE80000 geändert. Dein Befehl zeigt aber trotzdem immer noch folgendes an:

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 ~ # 
Post Reply