Bug 868121 - sss_cache says 'Wrong DB version'
sss_cache says 'Wrong DB version'
Product: Fedora
Classification: Fedora
Component: sssd (Show other bugs)
Unspecified Unspecified
unspecified Severity unspecified
: ---
: ---
Assigned To: Jakub Hrozek
Fedora Extras Quality Assurance
Depends On:
  Show dependency treegraph
Reported: 2012-10-19 01:40 EDT by Stef Walter
Modified: 2013-01-11 19:10 EST (History)
4 users (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed: 2013-01-11 19:10:40 EST
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Stef Walter 2012-10-19 01:40:49 EDT
Description of problem:

sss_cache fails to clear the cache:

$ sudo sss_cache -UG
(Fri Oct 19 07:38:23:724827 2012) [sss_cache] [sysdb_domain_init_internal] (0x0010): Wrong DB version (got 0.13 expected 0.11)
Could not open available domains

Version-Release number of selected component (if applicable):

$ rpm -q sssd

How reproducible:

Every time

sssd is running

[stef@stef-rawhide realmd]$ ps -xa | grep sss
 7521 ?        Ss     0:00 /usr/sbin/sssd -D -f
 7522 ?        S      0:00 /usr/libexec/sssd/sssd_be --domain ipa.thewalter.lan --debug-to-files
 7523 ?        S      0:00 /usr/libexec/sssd/sssd_be --domain AD --debug-to-files
 7524 ?        S      0:00 /usr/libexec/sssd/sssd_be --domain RADI08 --debug-to-files
 7525 ?        S      0:00 /usr/libexec/sssd/sssd_nss --debug-to-files
 7526 ?        S      0:00 /usr/libexec/sssd/sssd_pam --debug-to-files
Comment 1 Dmitri Pal 2012-10-19 08:58:12 EDT
Upstream ticket:
Comment 2 Jakub Hrozek 2012-10-19 09:53:56 EDT
The domains are upgraded automatically when the SSSD is started after being upgraded to a package version that uses a newer internal DB version.

Is it possible that you had a domain configured with an old SSSD version, then unconfigured it while the cache was still on the dist, upgraded the SSSD and then ran the sss_cache tool?
Comment 3 Jakub Hrozek 2012-10-19 12:24:12 EDT
btw if you can still reproduce the bug, here's how you can inspect which database has the wrong db version:

for db in /var/lib/sss/db/cache_*; do echo === DB: $db ===; ldbsearch -H $db cn=sysdb version; done

ldbsearch is a part of ldb-tools.
Comment 4 Jakub Hrozek 2012-10-25 05:49:42 EDT
The other reason might be that the cache upgrade really failed -- that would be indicated by a very loud DEBUG message in the logs.
Comment 5 Jakub Hrozek 2012-10-25 06:00:39 EDT
AH, sorry, I was reading the error backwards. The sss_cache was complaining that the database was NEWER than expected.

The 0.11 version is pre-1.9. Can you check what version of sssd-tools you had that produced the error? (sss_cache is still part of sssd-tools, not sssd even though there is a bug to change it)
Comment 6 Stef Walter 2012-10-26 15:50:58 EDT
Here you go:

Name        : sssd-tools
Arch        : x86_64
Version     : 1.9.2
Release     : 1.fc18
Size        : 560 k

It's likely that I did alternate old and new sssd versions, although don't ask me when and which ones :)
Comment 7 Jakub Hrozek 2012-10-28 15:07:23 EDT
OK, I was playing with sss_cache and trying to break it, but couldn't along my colleague Michal who is fixing and breaking the command line tools all the time :-).

Given that the only way we could reproduce the error message was by really trying to load a newer db version with an old version of the SSSD, we're going to just improve the error message upstream. Currently it's cryptic and scary.
Comment 8 Fedora Update System 2012-12-06 14:32:58 EST
sssd-1.9.3-1.fc18 has been submitted as an update for Fedora 18.
Comment 9 Fedora Update System 2012-12-07 15:46:22 EST
Package sssd-1.9.3-1.fc18:
* should fix your issue,
* was pushed to the Fedora 18 testing repository,
* should be available at your local mirror within two days.
Update it with:
# su -c 'yum update --enablerepo=updates-testing sssd-1.9.3-1.fc18'
as soon as you are able to.
Please go to the following url:
then log in and leave karma (feedback).
Comment 10 Fedora Update System 2013-01-11 19:10:42 EST
sssd-1.9.3-1.fc18 has been pushed to the Fedora 18 stable repository.  If problems still persist, please make note of it in this bug report.

Note You need to log in before you can comment on or make changes to this bug.