apt-get установить проблему с MySQL Ubuntu 12.04
У меня есть рабочая система с Ubuntu 12.04 и LAMP
По какой-то причине я не могу установить любое новое программное обеспечение в системе. Каждый раз, когда я пытаюсь использовать apt-get install, я получаю следующую ошибку:
Пример:
apt-get install bzip2
Reading package lists... Done
Building dependency tree
Reading state information... Done
bzip2 is already the newest version.
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
mysql-server-5.5 : Depends: mysql-server-core-5.5 (= 5.5.35-0ubuntu0.12.04.2) but 5.5.41-0ubuntu0.12.04.1 is to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).
apt-get -f install возвращает следующее:
apt-get -f install
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following packages were automatically installed and are no longer required:
linux-image-3.8.0-31-generic linux-headers-3.8.0-31 linux-headers-3.8.0-31-generic
Use 'apt-get autoremove' to remove them.
The following extra packages will be installed:
mysql-client mysql-client-5.5 mysql-common mysql-server mysql-server-5.5 mysql-server-core-5.5
Suggested packages:
tinyca mailx
The following packages will be upgraded:
mysql-client mysql-client-5.5 mysql-common mysql-server mysql-server-5.5 mysql-server-core-5.5
6 upgraded, 0 newly installed, 0 to remove and 164 not upgraded.
2 not fully installed or removed.
Need to get 23.3 MB of archives.
After this operation, 77.8 kB of additional disk space will be used.
Do you want to continue [Y/n]? Y
Get:1 http://mirror.hetzner.de/ubuntu/packages/ precise-updates/main mysql-common all 5.5.41-0ubuntu0.12.04.1 [13.0 kB]
Get:2 http://mirror.hetzner.de/ubuntu/packages/ precise-updates/main mysql-server all 5.5.41-0ubuntu0.12.04.1 [11.2 kB]
Get:3 http://mirror.hetzner.de/ubuntu/packages/ precise-updates/main mysql-server-5.5 amd64 5.5.41-0ubuntu0.12.04.1 [8,840 kB]
Get:4 http://mirror.hetzner.de/ubuntu/packages/ precise-updates/main mysql-client all 5.5.41-0ubuntu0.12.04.1 [11.1 kB]
Get:5 http://mirror.hetzner.de/ubuntu/packages/ precise-updates/main mysql-client-5.5 amd64 5.5.41-0ubuntu0.12.04.1 [8,312 kB]
Get:6 http://mirror.hetzner.de/ubuntu/packages/ precise-updates/main mysql-server-core-5.5 amd64 5.5.41-0ubuntu0.12.04.1 [6,094 kB]
Fetched 23.3 MB in 1s (14.6 MB/s)
Traceback (most recent call last):
File "/usr/bin/apt-listchanges", line 237, in <module>
main()
File "/usr/bin/apt-listchanges", line 48, in main
debs = apt_listchanges.read_apt_pipeline(config)
File "/usr/share/apt-listchanges/apt_listchanges.py", line 83, in read_apt_pipeline
return map(lambda pkg: filenames[pkg], order)
File "/usr/share/apt-listchanges/apt_listchanges.py", line 83, in <lambda>
return map(lambda pkg: filenames[pkg], order)
KeyError: 'mysql-server-5.5'
(Reading database ... 137429 files and directories currently installed.)
Preparing to replace mysql-common 5.5.38-0ubuntu0.12.04.1 (using .../mysql-common_5.5.41- 0ubuntu0.12.04.1_all.deb) ...
Unpacking replacement mysql-common ...
Setting up mysql-common (5.5.41-0ubuntu0.12.04.1) ...
(Reading database ... 137429 files and directories currently installed.)
Preparing to replace mysql-client 5.5.38-0ubuntu0.12.04.1 (using .../mysql-client_5.5.41-0ubuntu0.12.04.1_all.deb) ...
Unpacking replacement mysql-client ...
Preparing to replace mysql-client-5.5 5.5.38-0ubuntu0.12.04.1 (using .../mysql-client-5.5_5.5.41-0ubuntu0.12.04.1_amd64.deb) ...
Unpacking replacement mysql-client-5.5 ...
Preparing to replace mysql-server-core-5.5 5.5.38-0ubuntu0.12.04.1 (using .../mysql-server-core-5.5_5.5.41-0ubuntu0.12.04.1_amd64.deb) ...
Unpacking replacement mysql-server-core-5.5 ...
Processing triggers for man-db ...
Setting up mysql-client-5.5 (5.5.41-0ubuntu0.12.04.1) ...
Setting up mysql-server-core-5.5 (5.5.41-0ubuntu0.12.04.1) ...
dpkg: dependency problems prevent configuration of mysql-server-5.5:
mysql-server-5.5 depends on mysql-server-core-5.5 (= 5.5.35-0ubuntu0.12.04.2); however:
Version of mysql-server-core-5.5 on system is 5.5.41-0ubuntu0.12.04.1.
dpkg: error processing mysql-server-5.5 (--configure):
dependency problems - leaving unconfigured
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.5; however:
Package mysql-server-5.5 is not configured yet.
dpkg: error processing mysql-server (--configure):
dependency problems - leaving unconfigured
Setting up mysql-client (5.5.41-0ubuntu0.12.04.1) ...
No apport report written because the error message indicates its a followup error from a previous failure.
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.5
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
apt-cache policy mysql-server-5.5 mysql-server-core-5.5возвращает следующее:
mysql-server-5.5:
Installed: 5.5.35-0ubuntu0.12.04.2
Candidate: 5.5.41-0ubuntu0.12.04.1
Version table:
5.5.41-0ubuntu0.12.04.1 0
500 http://mirror.hetzner.de/ubuntu/packages/ precise-updates/main amd64 Packages
500 http://mirror.hetzner.de/ubuntu/security/ precise-security/main amd64 Packages
*** 5.5.35-0ubuntu0.12.04.2 0
100 /var/lib/dpkg/status
5.5.22-0ubuntu1 0
500 http://mirror.hetzner.de/ubuntu/packages/ precise/main amd64 Packages
mysql-server-core-5.5:
Installed: 5.5.41-0ubuntu0.12.04.1
Candidate: 5.5.41-0ubuntu0.12.04.1
Version table:
*** 5.5.41-0ubuntu0.12.04.1 0
500 http://mirror.hetzner.de/ubuntu/packages/ precise-updates/main amd64 Packages
500 http://mirror.hetzner.de/ubuntu/security/ precise-security/main amd64 Packages
100 /var/lib/dpkg/status
5.5.22-0ubuntu1 0
500 http://mirror.hetzner.de/ubuntu/packages/ precise/main amd64 Packages
dpkg -l |grep MySQL
ii dovecot-mysql 1:2.0.19-0ubuntu2.1 MySQL support for Dovecot
ii libdbd-mysql-perl 4.020-1build2 Perl5 database interface to the MySQL database
ii libmysqlclient-dev 5.5.38-0ubuntu0.12.04.1 MySQL database development files
ii libmysqlclient18 5.5.38-0ubuntu0.12.04.1 MySQL database client library
ii mysql-client 5.5.41-0ubuntu0.12.04.1 MySQL database client (metapackage depending on the latest version)
ii mysql-client-5.5 5.5.41-0ubuntu0.12.04.1 MySQL database client binaries
ii mysql-client-core-5.5 5.5.38-0ubuntu0.12.04.1 MySQL database core client binaries
ii mysql-common 5.5.41-0ubuntu0.12.04.1 MySQL database common files, e.g. /etc/mysql/my.cnf
iU mysql-server 5.5.35-0ubuntu0.12.04.2 MySQL database server (metapackage depending on the latest version)
iF mysql-server-5.5 5.5.35-0ubuntu0.12.04.2 MySQL database server binaries and system database setup
ii mysql-server-core-5.5 5.5.41-0ubuntu0.12.04.1 MySQL database server binaries
ii php-mdb2-driver-mysql 1.5.0b2-1 PHP PEAR module to provide a MySQL driver for MDB2
ii php5-mysql 5.3.10-1ubuntu3.14 MySQL module for php5
ii phpmyadmin 4:3.4.10.1-1 MySQL web administration tool
ii postfix-mysql 2.9.6-1~12.04.2 MySQL map support for Postfix
ii pure-ftpd-mysql 1.0.35-1 Secure and efficient FTP server with MySQL user authentication
ii roundcube-mysql 0.7.1-2 metapackage providing MySQL dependencies for RoundCube
cat /etc/apt/sources.list
#######################################################################################
# Hetzner APT-Mirror
deb http://mirror.hetzner.de/ubuntu/packages precise main restricted universe multiverse
deb http://mirror.hetzner.de/ubuntu/packages precise-backports main restricted universe multiverse
deb http://mirror.hetzner.de/ubuntu/packages precise-updates main restricted universe multiverse
deb http://mirror.hetzner.de/ubuntu/security precise-security main restricted universe multiverse
deb-src http://rs.archive.ubuntu.com/ubuntu precise main
Единственное решение, которое я смог найти, это полностью очистить MySQL, а затем выполнить переустановку. Поскольку это Live сервер с более чем 100 базами данных и настройкой репликации, я хотел бы попробовать другое, не столь радикальное решение.
Любые идеи, как необходимые компоненты могут быть обновлены или понижены без длительного простоя?
С наилучшими пожеланиями, Марио
Я думаю, что основная проблема заключается в этих линиях:
dpkg -l | grep MySQL
ii mysql-client 5.5.41-0ubuntu0.12.04.1 MySQL database client (metapackage depending on the latest version)
ii mysql-client-5.5 5.5.41-0ubuntu0.12.04.1 MySQL database client binaries
ii mysql-client-core-5.5 5.5.38-0ubuntu0.12.04.1 MySQL database core client binaries
ii mysql-common 5.5.41-0ubuntu0.12.04.1 MySQL database common files, e.g. /etc/mysql/my.cnf
iU mysql-server 5.5.35-0ubuntu0.12.04.2 MySQL database server (metapackage depending on the latest version)
iF mysql-server-5.5 5.5.35-0ubuntu0.12.04.2 MySQL database server binaries and system database setup
ii mysql-server-core-5.5 5.5.41-0ubuntu0.12.04.1 MySQL database server binaries
Я думаю, что несоответствие версий во время обновления произошло.