Hallo,
seit gestern Abend funktioniert MySQL, FTP usw nicht mehr. Meine Webseiten zeigen einen Datenbankfehler. Es konnte keine Verbindung zur Datenbank aufgebaut werden. Zum FTP kann ich mich auch nicht mehr verbinden.
service mysql status
QuoteDisplay More
mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; enabled)
Active: failed (Result: start-limit) since Sat 2020-05-30 15:39:52 CEST; 8min ago
Process: 6995 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid (code=exited, status=1/FAILURE)
Process: 6958 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=0/SUCCESS)
May 30 15:39:52 srv systemd[1]: Failed to start MySQL Community Server.
May 30 15:39:52 srv systemd[1]: Unit mysql.service entered failed state.
May 30 15:39:52 srv systemd[1]: mysql.service holdoff time over, scheduling restart.
May 30 15:39:52 srv systemd[1]: Stopping MySQL Community Server...
May 30 15:39:52 srv systemd[1]: Starting MySQL Community Server...
May 30 15:39:52 srv systemd[1]: mysql.service start request repeated too quickly, refusing to start.
May 30 15:39:52 srv systemd[1]: Failed to start MySQL Community Server.
May 30 15:39:52 srv systemd[1]: Unit mysql.service entered failed state.
service mysql restart
journalctl -xn
QuoteDisplay MoreCode
- -- Logs begin at Sat 2020-05-30 13:37:45 CEST, end at Sat 2020-05-30 15:41:09 CEST. --
- May 30 15:41:00 srv dovecot[742]: auth: Warning: auth client 0 disconnected with 1 pending requests: EOF
- May 30 15:41:00 srv postfix/smtpd[4037]: disconnect from unknown[87.246.7.74]
- May 30 15:41:00 srv dovecot[742]: auth: Warning: auth client 0 disconnected with 1 pending requests: EOF
- May 30 15:41:05 srv postfix/smtpd[5930]: warning: unknown[185.143.74.73]: SASL LOGIN authentication failed: Connection lost to authentication server
- May 30 15:41:06 srv postfix/smtpd[5930]: disconnect from unknown[185.143.74.73]
- May 30 15:41:06 srv postfix/smtpd[4725]: warning: hostname net6-ip70.linkbg.com does not resolve to address 87.246.7.70: Name or service not known
- May 30 15:41:06 srv postfix/smtpd[4725]: connect from unknown[87.246.7.70]
- May 30 15:41:07 srv postfix/smtpd[4726]: warning: unknown[87.246.7.70]: SASL LOGIN authentication failed: Connection lost to authentication server
- May 30 15:41:08 srv postfix/smtpd[4726]: disconnect from unknown[87.246.7.70]
- May 30 15:41:09 srv dovecot[742]: auth: Warning: auth client 0 disconnected with 1 pending requests: EOF
Filezilla zeigt mit diesen Fehler wenn ich mich verbinden will:
QuoteDisplay More
Status: Verbinde mit XXXXXXXX:21...
Status: Verbindung hergestellt, warte auf Willkommensnachricht...
Status: Initialisiere TLS...
Status: Überprüfe Zertifikat...
Status: TLS-Verbindung hergestellt.
Befehl: USER ftp@XXXXXXX
Antwort: 331 Password required for ftp@XXXXXXX
Befehl: PASS ****************
Fehler: GnuTLS-Fehler -110 in gnutls_record_recv: The TLS connection was non-properly terminated.
Status: Server hat die TLS-Verbindung nicht ordnungsgemäß geschlossen
Fehler: Konnte vom Socket nicht lesen: ECONNABORTED - Verbindung abgebrochen
Fehler: Herstellen der Verbindung zum Server fehlgeschlagen
Status: Nächsten Versuch abwarten...
File: /var/log/mysql/error.log
QuoteDisplay More
2020-05-30T13:39:51.763949Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-05-30T13:39:51.763998Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2020-05-30T13:39:51.764064Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.30) starting as process 6997 ...
2020-05-30T13:39:51.765726Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-05-30T13:39:51.765737Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-05-30T13:39:51.765741Z 0 [Note] InnoDB: Uses event mutexes
2020-05-30T13:39:51.765743Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-05-30T13:39:51.765746Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-05-30T13:39:51.765749Z 0 [Note] InnoDB: Using Linux native AIO
2020-05-30T13:39:51.765929Z 0 [Note] InnoDB: Number of pools: 1
2020-05-30T13:39:51.765978Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-05-30T13:39:51.766682Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2020-05-30T13:39:51.770769Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-05-30T13:39:51.771746Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-05-30T13:39:51.782650Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-05-30T13:39:51.783241Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 22890768605
2020-05-30T13:39:51.783251Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 22890777088
2020-05-30T13:39:51.783456Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 22890768605 and the end 22890777088.
2020-05-30T13:39:51.783462Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-05-30T13:39:52.383949Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-05-30T13:39:52.383959Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-05-30T13:39:52.383962Z 0 [ERROR] Failed to initialize builtin plugins.
2020-05-30T13:39:52.383964Z 0 [ERROR] Aborting
2020-05-30T13:39:52.383976Z 0 [Note] Binlog end
2020-05-30T13:39:52.384004Z 0 [Note] Shutting down plugin 'MyISAM'
2020-05-30T13:39:52.384013Z 0 [Note] Shutting down plugin 'CSV'
2020-05-30T13:39:52.384202Z 0 [Note] /usr/sbin/mysqld: Shutdown complete
Das ganze kam plötzlich, ohne das ich was verstellt habe. Ich kann mir das nicht erklären.
Kann mir jemand helfen?
Ich nutze I-MSCP 1.5.3 und Debian Jessie
LG