Limits für Mariadb erhöhen: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 1: | Zeile 1: | ||
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 9: | Zeile 13: | ||
:<code><nowiki>echo '[Service]</nowiki></code> | :<code><nowiki>echo '[Service]</nowiki></code> | ||
:<code><nowiki>LimitNOFILE= | :<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> | ||
Version vom 20. Januar 2019, 04:31 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