Limits für Mariadb erhöhen: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
(Die Seite wurde neu angelegt: „https://support.plesk.com/hc/en-us/articles/213938885-Plesk-or-website-are-not-working-Unable-to-connect-to-database-MySQL-server-has-gone-away-Full-server-bac…“) |
Keine Bearbeitungszusammenfassung |
||
| (2 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
[[Category:Datenbanksystem]] | |||
https://support.plesk.com/hc/en-us/articles/213938885-Plesk-or-website-are-not-working-Unable-to-connect-to-database-MySQL-server-has-gone-away-Full-server-backup-is-created-with-warning-errno-24-Too-many-open-files | https://support.plesk.com/hc/en-us/articles/213938885-Plesk-or-website-are-not-working-Unable-to-connect-to-database-MySQL-server-has-gone-away-Full-server-backup-is-created-with-warning-errno-24-Too-many-open-files | ||
;Fehler: | |||
ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/var/tmp/#sql_5fc_0.MAI' (Errcode: 24), query was: DESCRIBE `sessions` | |||
Hier die Lösung in Skript Form: | Hier die Lösung in Skript Form: | ||
| Zeile 7: | Zeile 12: | ||
:<code><nowiki>mkdir -p /etc/systemd/system/mariadb.service.d/</nowiki></code> | :<code><nowiki>mkdir -p /etc/systemd/system/mariadb.service.d/</nowiki></code> | ||
:<code><nowiki>echo '[Service]</nowiki></code> | |||
:<code><nowiki>LimitNOFILE=65534' > /etc/systemd/system/mariadb.service.d/limits.conf</nowiki></code> | |||
:<code><nowiki>systemctl daemon-reload</nowiki></code> | :<code><nowiki>systemctl daemon-reload</nowiki></code> | ||
:<code><nowiki>systemctl restart mariadb</nowiki></code> | :<code><nowiki>systemctl restart mariadb</nowiki></code> | ||
Aktuelle Version vom 8. November 2019, 21:02 Uhr
- Fehler
ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000]: General error: 23 Out of resources when opening file '/var/tmp/#sql_5fc_0.MAI' (Errcode: 24), query was: DESCRIBE `sessions`
Hier die Lösung in Skript Form:
#!/bin/bash
mkdir -p /etc/systemd/system/mariadb.service.d/
echo '[Service]
LimitNOFILE=65534' > /etc/systemd/system/mariadb.service.d/limits.conf
systemctl daemon-reload
systemctl restart mariadb