current mysql version? (Solved: It's a forced downgrade)

kuadhual · 2010-02-03 00:27:10

Yesterday I did an update, and it seems pacman want to update mysql to a previous version. (mysql was installed as dependency to kdemod).

my current package:

$ pacman -Qs mysql
local/libmysqlclient 5.1.43-1
    MySQL client libraries
local/mysql 5.1.43-1
    A fast SQL database server
local/mysql-clients 5.1.43-1
    MySQL client tools

cache:

$ ls /var/cache/pacman/pkg/ | grep mysql
libmysqlclient-5.1.42-1-i686.pkg.tar.gz
libmysqlclient-5.1.43-1-i686.pkg.tar.gz
mysql-5.1.42-1-i686.pkg.tar.gz
mysql-5.1.43-1-i686.pkg.tar.gz
mysql-clients-5.1.42-1-i686.pkg.tar.gz
mysql-clients-5.1.43-1-i686.pkg.tar.gz

here's pacman -Syu

$ pacman -Syu                  
:: Synchronizing package databases...         
--2010-02-03 07:16:21--  http://kdemod.iskrembilen.com/core/i686/kdemod-core.db.tar.gz
Resolving kdemod.iskrembilen.com... 129.241.93.105, 2001:700:300:1800:211:9ff:fe3d:c1fb
Connecting to kdemod.iskrembilen.com|129.241.93.105|:80... connected.                  
HTTP request sent, awaiting response... 200 OK                                         
Length: 61463 (60K) [application/octet-stream]                                         
Saving to: "/var/lib/pacman/kdemod-core.db.tar.gz.part"                                

100%[===========================================================================================================================================================>] 61,463      43.4K/s   in 1.4s    

2010-02-03 07:16:24 (43.4 KB/s) - "/var/lib/pacman/kdemod-core.db.tar.gz.part" saved [61463/61463]

--2010-02-03 07:16:24--  http://kdemod.iskrembilen.com/extragear/i686/kdemod-extragear.db.tar.gz
Resolving kdemod.iskrembilen.com... 129.241.93.105, 2001:700:300:1800:211:9ff:fe3d:c1fb         
Connecting to kdemod.iskrembilen.com|129.241.93.105|:80... connected.                           
HTTP request sent, awaiting response... 200 OK                                                  
Length: 17045 (17K) [application/octet-stream]                                                  
Saving to: "/var/lib/pacman/kdemod-extragear.db.tar.gz.part"                                    

100%[===========================================================================================================================================================>] 17,045      22.8K/s   in 0.7s    

2010-02-03 07:16:25 (22.8 KB/s) - "/var/lib/pacman/kdemod-extragear.db.tar.gz.part" saved [17045/17045]

--2010-02-03 07:16:25--  ftp://mirror.giantix-server.de/archlinux/core/os/i686/core.db.tar.gz
           => "/var/lib/pacman/core.db.tar.gz.part"                                          
Resolving mirror.giantix-server.de... 213.165.85.207                                         
Connecting to mirror.giantix-server.de|213.165.85.207|:21... connected.                      
Logging in as anonymous ... Logged in!                                                       
==> SYST ... done.    ==> PWD ... done.                                                      
==> TYPE I ... done.  ==> CWD (1) /archlinux/core/os/i686 ... done.                          
==> SIZE core.db.tar.gz ... 36979                                                            
==> PASV ... done.    ==> RETR core.db.tar.gz ... done.                                      
Length: 36979 (36K) (unauthoritative)                                                        

100%[===========================================================================================================================================================>] 36,979      46.4K/s   in 0.8s    

2010-02-03 07:16:30 (46.4 KB/s) - "/var/lib/pacman/core.db.tar.gz.part" saved [36979]

--2010-02-03 07:16:30--  ftp://mirror.giantix-server.de/archlinux/extra/os/i686/extra.db.tar.gz
           => "/var/lib/pacman/extra.db.tar.gz.part"                                           
Resolving mirror.giantix-server.de... 213.165.85.207                                           
Connecting to mirror.giantix-server.de|213.165.85.207|:21... connected.                        
Logging in as anonymous ... Logged in!                                                         
==> SYST ... done.    ==> PWD ... done.                                                        
==> TYPE I ... done.  ==> CWD (1) /archlinux/extra/os/i686 ... done.                           
==> SIZE extra.db.tar.gz ... 457268                                                            
==> PASV ... done.    ==> RETR extra.db.tar.gz ... done.                                       
Length: 457268 (447K) (unauthoritative)                                                        

100%[===========================================================================================================================================================>] 457,268      153K/s   in 2.9s    

2010-02-03 07:16:36 (153 KB/s) - "/var/lib/pacman/extra.db.tar.gz.part" saved [457268]

--2010-02-03 07:16:37--  ftp://mirror.giantix-server.de/archlinux/community/os/i686/community.db.tar.gz
           => "/var/lib/pacman/community.db.tar.gz.part"                                               
Resolving mirror.giantix-server.de... 213.165.85.207                                                   
Connecting to mirror.giantix-server.de|213.165.85.207|:21... connected.                                
Logging in as anonymous ... Logged in!                                                                 
==> SYST ... done.    ==> PWD ... done.                                                                
==> TYPE I ... done.  ==> CWD (1) /archlinux/community/os/i686 ... done.                               
==> SIZE community.db.tar.gz ... 372919                                                                
==> PASV ... done.    ==> RETR community.db.tar.gz ... done.                                           
Length: 372919 (364K) (unauthoritative)

100%[===========================================================================================================================================================>] 372,919      151K/s   in 2.4s

2010-02-03 07:16:43 (151 KB/s) - "/var/lib/pacman/community.db.tar.gz.part" saved [372919]

--2010-02-03 07:16:44--  http://xyne.archlinux.ca/repos/any/xyne-any.db.tar.gz
Resolving xyne.archlinux.ca... 69.89.25.172
Connecting to xyne.archlinux.ca|69.89.25.172|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 5496 (5.4K) [application/x-gzip]
Saving to: "/var/lib/pacman/xyne-any.db.tar.gz.part"

100%[===========================================================================================================================================================>] 5,496       23.0K/s   in 0.2s

2010-02-03 07:16:44 (23.0 KB/s) - "/var/lib/pacman/xyne-any.db.tar.gz.part" saved [5496/5496]

:: Starting full system upgrade...
resolving dependencies...
looking for inter-conflicts...

Targets (3): libmysqlclient-5.1.42-2  mysql-clients-5.1.42-2  mysql-5.1.42-2

Total Download Size:    40.73 MB
Total Installed Size:   95.52 MB

mirrorlist since (i think) 2 months ago:

Server = ftp://mirror.giantix-server.de/archlinux/$repo/os/i686
Server = http://archlinux.limun.org/$repo/os/i686
Server = http://schlunix.org/archlinux/$repo/os/i686
Server = http://mirrors.easynews.com/linux/archlinux/$repo/os/i686
Server = http://archlinux.unixheads.org/$repo/os/i686
Server = http://mirror.rit.edu/archlinux/$repo/os/i686
Server = http://ftp.uni-kl.de/pub/linux/archlinux/$repo/os/i686

I did wait until the next day just in case the mirror is out of sync.

What i don't understand is, even if I install mysql not from repo, it already have higher version number and should not be updated. Though?

edit: typo

Last edited by kuadhual (2010-02-03 07:08:50)

legolas558 · 2010-02-03 02:28:41

I've got the same issue...pacman can't find mysql-clients-5.1.42-2-i686.pkg.tar.gz, mysql-5.1.42-2-i686.pkg.tar.gz and libmysqlclient-5.1.42-2-i686.pkg.tar.gz ...why?

kermana · 2010-02-03 03:50:38

I have the same problem I guess ... Here is the relevant section of the pacman.log ...

[2010-02-02 02:40] starting full system upgrade
[2010-02-02 02:41] upgraded libmysqlclient (5.1.42-1 -> 5.1.43-1)
[2010-02-02 02:41] upgraded mysql-clients (5.1.42-1 -> 5.1.43-1)
[2010-02-02 02:41] upgraded mysql (5.1.42-1 -> 5.1.43-1)
[2010-02-02 02:41] upgraded perl-io-socket-ssl (1.30-1 -> 1.31-1)
[2010-02-02 13:51] synchronizing package lists
[2010-02-02 13:51] starting full system upgrade
[2010-02-02 13:53] upgraded libmysqlclient (5.1.43-1 -> 5.1.42-2)
[2010-02-02 13:53] upgraded mdadm (2.6.9-1 -> 3.1.1-1)
[2010-02-02 13:53] upgraded mysql-clients (5.1.43-1 -> 5.1.42-2)
[2010-02-02 13:53] warning: /etc/mysql/my.cnf installed as /etc/mysql/my.cnf.pacnew
[2010-02-02 13:53] upgraded mysql (5.1.43-1 -> 5.1.42-2)

Snowman · 2010-02-03 04:11:48

There was a problem with mysql 5.1.43 and akonadi. The mysql-5.1.42-2 packages force the downgrade.

kermana · 2010-02-03 04:18:45

That explains ... thanks for the info

kuadhual · 2010-02-03 07:08:08

Thanks for the info. I'll close this thread.
But this made me confuse of how pacman compares package version. (I mean how come mysql-5.1.42-2 can replace mysql-5.1.43-1)

Snowman · 2010-02-03 09:50:39

mysql-5.1.42-2 use the force option:

$ grep options /var/abs/extra/mysql/PKGBUILD
options=('!libtool' 'force')

Arch Linux

#1 2010-02-03 00:27:10

current mysql version? (Solved: It's a forced downgrade)

#2 2010-02-03 02:28:41

Re: current mysql version? (Solved: It's a forced downgrade)

#3 2010-02-03 03:50:38

Re: current mysql version? (Solved: It's a forced downgrade)

#4 2010-02-03 04:11:48

Re: current mysql version? (Solved: It's a forced downgrade)

#5 2010-02-03 04:18:45

Re: current mysql version? (Solved: It's a forced downgrade)

#6 2010-02-03 07:08:08

Re: current mysql version? (Solved: It's a forced downgrade)

#7 2010-02-03 09:50:39

Re: current mysql version? (Solved: It's a forced downgrade)

Board footer