I've got Percona DB 5.6 on several Ubuntu 12.04 servers. On a few of them, I've been able to successfully upgrade to the latest version (5.6.17) using
apt-get update
apt-get upgrade
On several others, apt-get update + upgrade tells me there's nothing to do, although the version installed there is only 5.6.15. Why isn't it finding the most recent version?
Up-to-date version from servers that did update: "Server version: 5.6.17-65.0-587.precise-log (Ubuntu)"
Version from servers that are not updating: "Server version: 5.6.15-63.0-log Percona Server (GPL), Release 63.0"
I have confirmed that the following lines are in /etc/apt/sources.list on all servers:
deb http://repo.percona.com/apt precise main
deb-src http://repo.percona.com/apt precise main
(and it had to work at some point, because they were all installed originally using apt-get)
EDIT: From estibordo's suggestion, I'm adding in the output of
apt-cache policy percona-server-server-5.6
(percona-server-common-5.6 & percona-server-client-5.6 are identical to this too)
From the servers that are not upgrading:
percona-server-server-5.6:
Installed: 1:5.6.15-rel63.0-519.precise
Candidate: 1:5.6.15-rel63.0-519.precise
Version table:
*** 1:5.6.15-rel63.0-519.precise 0
100 /var/lib/dpkg/status
5.6.17-65.0-587.precise 0
500 http://repo.percona.com/apt/ precise/main amd64 Packages
On my servers that did upgrade, this is the output:
percona-server-server-5.6:
Installed: 5.6.17-65.0-587.precise
Candidate: 5.6.17-65.0-587.precise
Version table:
*** 5.6.17-65.0-587.precise 0
500 http://repo.percona.com/apt/ precise/main amd64 Packages
100 /var/lib/dpkg/status
Why the difference, or more importantly, how do I fix the ones that are stuck on 5.6.15?
Thanks.
Best Answer
I think that
is what you need. It will provide the information about the installed version and if there are other candidates to install. It will also tell you from which repositories the packages came from.
You might use the same command with a wildcard, like: