staging.inyokaproject.org

Moin zusammen, Ich habe folgendes Problem: Ich wollte MySQL auf meinem Ubuntu-Server neu installieren, da es Probleme bei dem Start davon gab. Leider lässt sich das Paket "MySQL-Server-5.7" nicht auf herkömmliche Weise entfernen. Ich habe es bereits mit "sudo apt-get remove mysql-server-5.7" versucht, dabei hat er mir auch keine Fehler ausgegeben. Versuche ich dann allerdings mit "sudo apt-get install mysql-server" das Paket wieder zu installieren bekomme ich folgende Meldung:

root@XXXXX:/etc# apt-get install mysql-server
Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following additional packages will be installed:
  libaio1 libevent-core-2.0-5 mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server-5.7
  mysql-server-core-5.7
Suggested packages:
  mailx tinyca
The following NEW packages will be installed
  libaio1 libevent-core-2.0-5 mysql-client-5.7 mysql-client-core-5.7 mysql-common mysql-server
  mysql-server-5.7 mysql-server-core-5.7
0 to upgrade, 8 to newly install, 0 to remove and 0 not to upgrade.
Need to get 15.9 MB/18.7 MB of archives.
After this operation, 161 MB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 mysql-common all 5.7.21-0ubuntu0.16.04.1 [15.7 kB]
Get:2 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial/main amd64 libaio1 amd64 0.3.110-2 [6,356 B]
Get:3 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 mysql-client-core-5.7 amd64 5.7.21-0ubuntu0.16.04.1 [6,363 kB]
Get:4 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 mysql-client-5.7 amd64 5.7.21-0ubuntu0.16.04.1 [1,676 kB]
Get:5 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 mysql-server-core-5.7 amd64 5.7.21-0ubuntu0.16.04.1 [7,809 kB]
Get:6 ftp://ftp.stratoserver.net/pub/linux/ubuntu xenial-updates/main amd64 libevent-core-2.0-5 amd64 2.0.21-stable-2ubuntu0.16.04.1 [70.6 kB]
Fetched 15.9 MB in 4s (3,940 kB/s)        
Preconfiguring packages ...
Selecting previously unselected package mysql-common.
(Reading database ... 99224 files and directories currently installed.)
Preparing to unpack .../mysql-common_5.7.21-0ubuntu0.16.04.1_all.deb ...
Unpacking mysql-common (5.7.21-0ubuntu0.16.04.1) ...
Selecting previously unselected package libaio1:amd64.
Preparing to unpack .../libaio1_0.3.110-2_amd64.deb ...
Unpacking libaio1:amd64 (0.3.110-2) ...
Selecting previously unselected package mysql-client-core-5.7.
Preparing to unpack .../mysql-client-core-5.7_5.7.21-0ubuntu0.16.04.1_amd64.deb ...
Unpacking mysql-client-core-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Selecting previously unselected package mysql-client-5.7.
Preparing to unpack .../mysql-client-5.7_5.7.21-0ubuntu0.16.04.1_amd64.deb ...
Unpacking mysql-client-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Selecting previously unselected package mysql-server-core-5.7.
Preparing to unpack .../mysql-server-core-5.7_5.7.21-0ubuntu0.16.04.1_amd64.deb ...
Unpacking mysql-server-core-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Selecting previously unselected package libevent-core-2.0-5:amd64.
Preparing to unpack .../libevent-core-2.0-5_2.0.21-stable-2ubuntu0.16.04.1_amd64.deb ...
Unpacking libevent-core-2.0-5:amd64 (2.0.21-stable-2ubuntu0.16.04.1) ...
Processing triggers for libc-bin (2.23-0ubuntu10) ...
Processing triggers for man-db (2.7.5-1) ...
Setting up mysql-common (5.7.21-0ubuntu0.16.04.1) ...
update-alternatives: using /etc/mysql/my.cnf.fallback to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Selecting previously unselected package mysql-server-5.7.
(Reading database ... 99392 files and directories currently installed.)
Preparing to unpack .../mysql-server-5.7_5.7.21-0ubuntu0.16.04.1_amd64.deb ...
Unpacking mysql-server-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Selecting previously unselected package mysql-server.
Preparing to unpack .../mysql-server_5.7.21-0ubuntu0.16.04.1_all.deb ...
Unpacking mysql-server (5.7.21-0ubuntu0.16.04.1) ...
Processing triggers for systemd (229-4ubuntu21.1) ...
Processing triggers for ureadahead (0.100.0-19) ...
ureadahead will be reprofiled on next reboot
Processing triggers for man-db (2.7.5-1) ...
Setting up libaio1:amd64 (0.3.110-2) ...
Setting up mysql-client-core-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Setting up mysql-client-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Setting up mysql-server-core-5.7 (5.7.21-0ubuntu0.16.04.1) ...
Setting up libevent-core-2.0-5:amd64 (2.0.21-stable-2ubuntu0.16.04.1) ...
Setting up mysql-server-5.7 (5.7.21-0ubuntu0.16.04.1) ...
update-alternatives: using /etc/mysql/mysql.cnf to provide /etc/mysql/my.cnf (my.cnf) in auto mode
Renaming removed key_buffer and myisam-recover options (if present)
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: activating (auto-restart) (Result: exit-code) since Sat 2018-02-17 15:09:11 GMT; 4ms ago
  Process: 5483 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)

Feb 17 15:09:11 h2745035.stratoserver.net systemd[1]: Failed to start MySQL Community Server.
Feb 17 15:09:11 h2745035.stratoserver.net systemd[1]: mysql.service: Unit entered failed state.
Feb 17 15:09:11 h2745035.stratoserver.net systemd[1]: mysql.service: Failed with result 'exit-code'.
dpkg: error processing package mysql-server-5.7 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.7; however:
  Package mysql-server-5.7 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
Processing triggers for libc-bin (2.23-0ubuntu10) ...
Processing triggers for systemd (229-4ubuntu21.1) ...
Processing triggers for ureadahead (0.100.0-19) ...
Errors were encountered while processing:
 mysql-server-5.7
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

Ich weiß da leider nicht weiter und hoffe ihr könnt mir Lösungsvorschläge geben ☺

Danke im Vorraus,

r00tOS

Moin r00tOS,

während der Installation von MySQL versucht die Paketverwaltung automatisch auch den Dienst gleich zu starten. Und da beim Entfernen von MySQL alle alten Konfigurationen erhalten blieben, hat die Paketverwaltung bei diesem Start das gleiche Problem, was auch du beim Starten von MySQL hattest.

Die Moral von der Geschicht'? Unter Linux hat eine Neuinstallation einer Software selten den gewünschten Effekt. Stattdessen sollte man bei Problemen versuchen die Konfiguration der Anwendung zu reparieren (oder im Zweifel mit dieser von vorne beginnen).

Deshalb (und zur Klärung des Status Quo) einige Fragen:

1. Lagen in deinem MySQL-Dienst bereits Datenbanken die dir wichtig sind und von denen du kein Backup hast?

2. Was steht im MySQL-Error-Log? Das ist entweder eine Log-Datei irgendwo unter /var/log/ oder es steht in der Fehler-Datei im MySQL-Datenverzeichnis (/var/lib/mysql/ oder im von dir definierten) oder du kommst da irgendwie per journalctl ran. Aber da du Server-Admin bist, wirst du das schon finden.

Gruß

Torben

Ich häng mich an das Problem mal ran.

Ich hab genau die gleiche Fehlermeldung, allerdings nicht beim Neuinstallieren sondern beim ausführen eines Updates mit "aptitude upgrade".

Der Error-Log ist leer, außerdem wird MySQL auf diesem Server nicht verwendet, daher auch keine wichtigen Datenbanken. Gesucht wird aber trotzdem eine Lösung, die nicht darauf ausgerichtet ist alles neu machen zu müssen.

Da ich genau den gleichen Fehler beim Update bekommen habe, gehe ich mal von einem Problem während des Upgradevorgangs aus.

Mehrere andere Lösungsvorschläge haben nichts gebracht. - https://ubuntuforums.org/showthread.php?t=2325143 - https://askubuntu.com/questions/760724/16-04-upgrade-broke-mysql-server

root@mein_server:/home/ubuntu# aptitude upgrade
Resolving dependencies...                
The following NEW packages will be installed:
  linux-headers-4.13.0-37{a} linux-headers-4.13.0-37-generic{a} linux-image-4.13.0-37-generic{a} 
The following packages will be upgraded:
  apparmor base-files cloud-init friendly-recovery google-cloud-sdk grub-common grub-pc grub-pc-bin grub2-common libapparmor-perl libapparmor1 libaudit-common libaudit1 libgcrypt20 libnuma1 libpython-stdlib 
  linux-headers-generic-hwe-16.04 linux-headers-virtual-hwe-16.04 linux-image-virtual-hwe-16.04 linux-virtual-hwe-16.04 ntp open-vm-tools python python-apt-common python-minimal python3-apt python3-distupgrade 
  ubuntu-release-upgrader-core update-notifier-common 
The following partially installed packages will be configured:
  mysql-server mysql-server-5.7
29 packages upgraded, 3 newly installed, 0 to remove and 0 not upgraded.
Need to get 52.8 MB of archives. After unpacking 157 MB will be used.
Do you want to continue? [Y/n/?] y


Setting up mysql-server-5.7 (5.7.21-0ubuntu0.16.04.1) ...
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: activating (auto-restart) (Result: exit-code) since Wed 2018-03-14 13:02:50 UTC; 10ms ago
  Process: 19080 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)

Mar 14 13:02:50 mein_server systemd[1]: mysql.service: Unit entered failed state.
Mar 14 13:02:50 mein_server systemd[1]: mysql.service: Failed with result 'exit-code'.
dpkg: error processing package mysql-server-5.7 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.7; however:
  Package mysql-server-5.7 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured



Processing triggers for libc-bin (2.23-0ubuntu10) ...
Errors were encountered while processing:
 mysql-server-5.7
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
Failed to perform requested operation on package.  Trying to recover:
Setting up mysql-server-5.7 (5.7.21-0ubuntu0.16.04.1) ...
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: activating (auto-restart) (Result: exit-code) since Wed 2018-03-14 13:03:45 UTC; 8ms ago
  Process: 31718 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)

Mar 14 13:03:45 mein_server systemd[1]: mysql.service: Control process exited, code=exited status=1
Mar 14 13:03:45 mein_server systemd[1]: Failed to start MySQL Community Server.
Mar 14 13:03:45 mein_server systemd[1]: mysql.service: Unit entered failed state.
Mar 14 13:03:45 mein_server systemd[1]: mysql.service: Failed with result 'exit-code'.
dpkg: error processing package mysql-server-5.7 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.7; however:
  Package mysql-server-5.7 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-5.7
 mysql-server

2. Versuch

root@mein_server:/home/ubuntu# aptitude upgrade      
The following partially installed packages will be configured:
  mysql-server mysql-server-5.7 
No packages will be installed, upgraded, or removed.
0 packages upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 0 B of archives. After unpacking 0 B will be used.
Setting up mysql-server-5.7 (5.7.21-0ubuntu0.16.04.1) ...
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: activating (auto-restart) (Result: exit-code) since Wed 2018-03-14 13:16:04 UTC; 9ms ago
  Process: 3300 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)

Mar 14 13:16:04 mein_server systemd[1]: mysql.service: Unit entered failed state.
Mar 14 13:16:04 mein_server systemd[1]: mysql.service: Failed with result 'exit-code'.
dpkg: error processing package mysql-server-5.7 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.7; however:
  Package mysql-server-5.7 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
No apport report written because the error message indicates its a followup error from a previous failure.
                                                                                                          Errors were encountered while processing:
 mysql-server-5.7
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
Failed to perform requested operation on package.  Trying to recover:
Setting up mysql-server-5.7 (5.7.21-0ubuntu0.16.04.1) ...
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: activating (auto-restart) (Result: exit-code) since Wed 2018-03-14 13:16:07 UTC; 10ms ago
  Process: 3647 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)

Mar 14 13:16:07 mein_server systemd[1]: mysql.service: Control process exited, code=exited status=1
Mar 14 13:16:07 mein_server systemd[1]: Failed to start MySQL Community Server.
Mar 14 13:16:07 mein_server systemd[1]: mysql.service: Unit entered failed state.
Mar 14 13:16:07 mein_server systemd[1]: mysql.service: Failed with result 'exit-code'.
dpkg: error processing package mysql-server-5.7 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.7; however:
  Package mysql-server-5.7 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
Errors were encountered while processing:
 mysql-server-5.7
 mysql-server

root@mein_server:/home/ubuntu# systemctl status mysql
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: inactive (dead) (Result: exit-code) since Wed 2018-03-14 13:16:08 UTC; 10min ago
  Process: 3755 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)

Mar 14 13:16:08 mein_server systemd[1]: mysql.service: Control process exited, code=exited status=1
Mar 14 13:16:08 mein_server systemd[1]: Failed to start MySQL Community Server.
Mar 14 13:16:08 mein_server systemd[1]: mysql.service: Unit entered failed state.
Mar 14 13:16:08 mein_server systemd[1]: mysql.service: Failed with result 'exit-code'.
Mar 14 13:16:08 mein_server systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Mar 14 13:16:08 mein_server systemd[1]: Stopped MySQL Community Server.
Mar 14 13:16:08 mein_server systemd[1]: mysql.service: Start request repeated too quickly.
Mar 14 13:16:08 mein_server systemd[1]: Failed to start MySQL Community Server.

EDIT: Bei anderen komplett gleichen Servern, hab ich die Probleme nicht.

Wenn MySQL bei dir eh nicht verwendet wird, dann hau es doch einfach raus:

killall -9 mysql
apt-get remove --purge --auto-remove mysql-server-5.7