Error when upgrading MySQL

Shamli

Hi everyone.

On routine update/upgrade on every VPS I have. Suddenly I get an error and it's only on one server. I get error on MySQL dependencies. I have tried as shown below,but still failed.

I dont want to reinstall the VPS as it's the main server with DNS and many other stuff. It's Debian 6.

Can anyone help me..

232703:~# apt-get upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt-get -f install' to correct these.
The following packages have unmet dependencies:
 mysql-server-5.1 : Depends: mysql-client-5.1 (>= 5.1.63-0+squeeze1) but it is not installed
E: Unmet dependencies. Try using -f.
232703:~# apt-get -f install
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following package was automatically installed and is no longer required:
  mysql-client-core-5.5
Use 'apt-get autoremove' to remove them.
The following extra packages will be installed:
  mysql-client-5.1
Suggested packages:
  libterm-readkey-perl
The following NEW packages will be installed:
  mysql-client-5.1
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
Need to get 0 B/9587 kB of archives.
After this operation, 22.9 MB of additional disk space will be used.
Do you want to continue [Y/n]?
(Reading database ... 44662 files and directories currently installed.)
Unpacking mysql-client-5.1 (from .../mysql-client-5.1_5.1.63-0+squeeze1_i386.deb) ...
dpkg: error processing /var/cache/apt/archives/mysql-client-5.1_5.1.63-0+squeeze1_i386.deb (--unpack):
 trying to overwrite '/usr/bin/mysqlcheck', which is also in package mysql-client-core-5.5 5.5.25a-1~dotdeb.1
configured to not write apport reports
                                      dpkg-deb: subprocess paste killed by signal (Broken pipe)
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-client-5.1_5.1.63-0+squeeze1_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
232703:~#

Thanks in advance...

gbshouse

It look like you have newer client version already installed

mistert

already tried a dpgk-reconfigure ?

Shamli

yeah..i'm also think like that..but it seems I can do nothing to remove this error..unless someone can show me the way...

mysqld is running as normal,but cant be restart/reload...

Shamli

@mistert

232703:~# dpkg-reconfigure mysql
Package `mysql' is not installed and no info is available.
Use dpkg --info (= dpkg-deb --info) to examine archive files,
and dpkg --contents (= dpkg-deb --contents) to list their contents.
/usr/sbin/dpkg-reconfigure: mysql is not installed

mistert

@Shamli ofcourse you need the exact name of the package...f.e. mysql-server-5.1 or something... :-)

Shamli

here what i got...

232703:~# dpkg-reconfigure mysql-server-5.1
/usr/sbin/dpkg-reconfigure: mysql-server-5.1 is broken or not fully installed

edit:

and this I get when using force option...

232703:~# dpkg-reconfigure -f mysql-server-5.1
debconf: unable to initialize frontend: Mysql-server-5.1
debconf: (Can't locate Debconf/FrontEnd/Mysql.pm in @INC (@INC contains: /etc/perl /usr/local/lib/perl/5.10.1 /usr/local/share/perl/5.10.1 /usr/lib/perl5 /usr/share/perl5 /usr/lib/perl/5.10 /usr/share/perl/5.10 /usr/local/lib/site_perl .) at (eval 24) line 2.)

gbshouse

apt-get autoremove or apt-get purge mysql-client-core-5.5 apt-get upgrade

Shamli

still getting error...

232703:~# apt-get autoremove
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt-get -f install' to correct these.
The following packages have unmet dependencies:
 mysql-server-5.1 : Depends: mysql-client-5.1 (>= 5.1.63-0+squeeze1) but it is not installed
E: Unmet dependencies. Try using -f.
232703:~# apt-get purge mysql-client-core-5.5
Reading package lists... Done
Building dependency tree
Reading state information... Done
You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 mysql-server-5.1 : Depends: mysql-client-5.1 (>= 5.1.63-0+squeeze1) but it is not going to be installed
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).

gbshouse

apt-get install mysql-client-5.1 and then apt-get install mysql-server-5.1

you can also try cleaning packages first (but be careful) apt-get purge mysql* and apt-get install mysql-client-5.1 mysql-server-5.1

Shamli

also the same.

232703:~# apt-get install mysql-client-5.1
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following package was automatically installed and is no longer required:
  mysql-client-core-5.5
Use 'apt-get autoremove' to remove them.
Suggested packages:
  libterm-readkey-perl
The following NEW packages will be installed:
  mysql-client-5.1
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
Need to get 0 B/9587 kB of archives.
After this operation, 22.9 MB of additional disk space will be used.
(Reading database ... 44662 files and directories currently installed.)
Unpacking mysql-client-5.1 (from .../mysql-client-5.1_5.1.63-0+squeeze1_i386.deb) ...
dpkg: error processing /var/cache/apt/archives/mysql-client-5.1_5.1.63-0+squeeze1_i386.deb (--unpack):
 trying to overwrite '/usr/bin/mysqlcheck', which is also in package mysql-client-core-5.5 5.5.25a-1~dotdeb.1
configured to not write apport reports
                                      dpkg-deb: subprocess paste killed by signal (Broken pipe)
Errors were encountered while processing:
 /var/cache/apt/archives/mysql-client-5.1_5.1.63-0+squeeze1_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

edit:

cleaning also doesnt help... (apt-get purge mysql*)

You might want to run 'apt-get -f install' to correct these:
The following packages have unmet dependencies:
 phpmyadmin : Depends: php5-mysql but it is not going to be installed or
                       php5-mysqli but it is not installable
              Recommends: mysql-client
E: Unmet dependencies. Try 'apt-get -f install' with no packages (or specify a solution).

gbshouse

so run apt-get purge mysql* just remember to not remove the databases then make clean install apt-get install mysql-client-5.1 mysql-server-5.1

Shamli

apt-get purge mysql* does nothing...

gbshouse

hmmmm that's strange it should remove all packages starting with "mysql" are you sure that you need MySQL 5.1 not 5.5? You can also try to install Percona's version of MySQL

if you want you can PM me the access data and I can try to login to your box and fix this for you

Shamli

I'm trying to upgrade the server and the mysql to 5.5..then this happen...maybe it's time for me to clean up this server since it's initially installed with Debian 5....

thanks for your support...=)

gbshouse

if you are trying to upgrade to 5.5 why are you installing 5.1? Here you have Percona's documentation - their MySQL version is better then default one http://www.percona.com/doc/percona-server/5.5/installation.html just add the the repos to sources.list (http://www.percona.com/doc/percona-server/5.5/installation/apt_repo.html) and install apt-get update apt-get install percona-server-server-5.5

Shamli

before it's 5.1..then I upgrade it to 5.5,but something went wrong...and I dont know what's the wrong is....

after many unsuccessfull attempt to continue upgrade,I try to revert back to 5.1...

still,unsuccessfull...

percona is something new to me... so,I'll need to stick with mysql for the moment and backup current database and do OS reinstallation...and maybe adding manually about 10+ domain and 40+ records...

gbshouse

Percona is MySQL the only difference is that instead of default InnoDB they are using XtraDB. All configuration, management etc. is the same so don't be afraid