Witam dziś podczas aktualizacji serwera napotkałem problem z aktualizacją mysql i nie mogę się zalogować do bazy danych w error.log mam coś takiego
Cytat 2019-04-27T01:06:58.439724Z 0 [ERROR] [MY-010119] [Server] Aborting 2019-04-27T01:07:00.426797Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.16) MySQL Community Server - GPL. 2019-04-27T01:07:23.974944Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.16) starting as process 14212 2019-04-27T01:07:25.403735Z 4 [System] [MY-013381] [Server] Server upgrade from '80015' to '80016' started. 2019-04-27T01:07:29.196602Z 4 [ERROR] [MY-013384] [Server] Could not create server upgrade info file at '/var/lib/mysql/'. 2019-04-27T01:07:29.207096Z 0 [ERROR] [MY-013380] [Server] Failed to upgrade server. 2019-04-27T01:07:29.207569Z 0 [ERROR] [MY-010119] [Server] Aborting 2019-04-27T01:07:31.037151Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.16) MySQL Community Server - GPL.
Przy restarcie mysql mam
Cytat Apr 27 03:10:08 vps314934 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE Apr 27 03:10:08 vps314934 systemd[1]: Failed to start MySQL Community Server. -- Subject: Unit mysql.service has failed -- Defined-By: systemd -- Support: https://www.debian.org/support -- -- Unit mysql.service has failed. -- -- The result is failed. Apr 27 03:10:08 vps314934 systemd[1]: mysql.service: Unit entered failed state. Apr 27 03:10:08 vps314934 systemd[1]: mysql.service: Failed with result 'exit-code'.
A to błąd podczas aktualizacji
Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details. invoke-rc.d: initscript mysql, action "start" failed. ● mysql.service - MySQL Community Server Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled) Active: failed (Result: exit-code) since Sat 2019-04-27 03:13:53 CEST; 18ms ago Docs: man:mysqld(8) http://dev.mysql.com/doc/refman/en/using-systemd.html Process: 15468 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE) Process: 15433 ExecStartPre=/usr/share/mysql-8.0/mysql-systemd-start pre (code=exited, status=0/SUCCESS) Main PID: 15468 (code=exited, status=1/FAILURE) Status: "SERVER_BOOTING" Error: 2 (No such file or directory)
Apr 27 03:13:45 vps314934 systemd[1]: Starting MySQL Community Server... Apr 27 03:13:53 vps314934 systemd[1]: mysql.service: Main process exited, code=exited, status=1/FAILURE Apr 27 03:13:53 vps314934 systemd[1]: Failed to start MySQL Community Server. Apr 27 03:13:53 vps314934 systemd[1]: mysql.service: Unit entered failed state. Apr 27 03:13:53 vps314934 systemd[1]: mysql.service: Failed with result 'exit-code'. dpkg: error processing package mysql-community-server (--configure): subprocess installed post-installation script returned error exit status 1 dpkg: dependency problems prevent configuration of mysql-server: mysql-server depends on mysql-community-server (= 8.0.16-1debian9); however: Package mysql-community-server is not configured yet.
dpkg: error processing package mysql-server (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mysql-community-server mysql-server
Jakiś pomysł dlaczego i co zrobić?
