Bug 297627

Summary: Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database
Product: [openSUSE] openSUSE 10.3 Reporter: Nikolay Derkach <nderkach>
Component: libzyppAssignee: Duncan Mac-Vicar <dmacvicar>
Status: RESOLVED FIXED QA Contact: Klaus Kämpf <kkaempf>
Severity: Critical    
Priority: P5 - None CC: chrubis, forgotten_CxVz4LpaB5, funtasyspace, hi-du, kairo, meissner, mrmazda, nospamm, rccj
Version: Beta 1   
Target Milestone: ---   
Hardware: Other   
OS: Other   
Whiteboard:
Found By: --- Services Priority:
Business Priority: Blocker: ---
Marketing QA Status: --- IT Deployment: ---

Description Nikolay Derkach 2007-08-05 17:50:35 UTC
I get this error trying to refresh factory repository:

Refreshing factory
Downloading: 
ftp://ftp.gwdg.de/pub/opensuse/distribution/SL-OSS-factory/inst-source/content 
to /var/adm/mount/AP_0x000000db/content
* Downloading [100%]
Creating repository cache...
* Cleaning repository 'factory' cache
* Building repository 'factory' cache
Error reading repository 'factory':
Cache exception
Skipping repository 'factory' because of the above error.

zypper.log revealed the following error:

2007-08-04 21:55:57 <1> tau(5404) [zypp] RepoManager.cc(cleanCache):613 
factory cleaning cache...
2007-08-04 21:55:58 <5> tau(5404) [zypp] Exception.cc(log):119 
sqlite3x_reader.cpp(read):71 THROW:    sqlite3x_reader.cpp(read):71: SQL log
ic error or missing database
2007-08-04 21:55:58 <5> tau(5404) [zypp] Exception.cc(log):119 
CacheStore.cc(cleanRepository):780 THROW:    CacheStore.cc(cleanRepository):
780: Cache exception
2007-08-04 21:55:58 <1> tau(5404) [zypp] CacheStore.cc(~Impl):140 name cache 
hits: 0 | cache size: 0
2007-08-04 21:55:58 <1> tau(5404) [zypp] CacheStore.cc(~Impl):140 name cache 
hits: 0 | cache size: 0
2007-08-04 21:55:58 <3> tau(5404) [zypper] 
zypper-sources.cc(refresh_repos):192 Error reading repository 'factory':
2007-08-04 21:55:58 <3> tau(5404) [zypper] 
zypper-sources.cc(refresh_repos):192 Cache exception
2007-08-04 21:55:58 <3> tau(5404) [zypper] 
zypper-sources.cc(refresh_repos):194 Skipping repository 'factory' because of 
the above error.

I should mention that I couldn't reproduce this on download.opensuse.org repository. I'm not sure if it's an issue of a certain repository or libzypp bug.
Comment 1 Nikolay Derkach 2007-08-08 09:53:32 UTC
Correction to the previous comment, no I'm also able to reproduce it on download.opensuse.org. So, this is likely not a certain repository issue.
Comment 2 Nikolay Derkach 2007-08-08 10:14:24 UTC
*** Bug 298350 has been marked as a duplicate of this bug. ***
Comment 3 Duncan Mac-Vicar 2007-08-08 12:32:52 UTC
-------------------------------------------------------------------
Fri Aug  3 14:13:36 CEST 2007 - dmacvicar@suse.de

- Fixed cache schema upgrade
Comment 4 Nikolay Derkach 2007-08-08 16:47:01 UTC
*** Bug 298506 has been marked as a duplicate of this bug. ***
Comment 5 Richard Creighton 2007-08-08 17:55:15 UTC
(In reply to comment #3 from Duncan Mac-Vicar Prett)
> -------------------------------------------------------------------
> Fri Aug  3 14:13:36 CEST 2007 - dmacvicar@suse.de
> 
> - Fixed cache schema upgrade
> 

It works for the FACTORY repos BUT:


asus:/usr/src/linux-2.6.22.1-14/drivers/md # zypper ref
Refreshing FACTORY Non OSS
* Building repository 'FACTORY Non OSS' cache
Refreshing openSUSE-10.3-Updates
* Building repository 'openSUSE-10.3-Updates' cache
Refreshing 20070807-100738
* Building repository '20070807-100738' cache
All repositories have been refreshed.
asus:/usr/src/linux-2.6.22.1-14/drivers/md # zypper -V
zypper 0.8.7
asus:/usr/src/linux-2.6.22.1-14/drivers/md # rpm -q zypper
zypper-0.8.7-2
asus:/usr/src/linux-2.6.22.1-14/drivers/md # zypper ref
Refreshing FACTORY Non OSS
* Building repository 'FACTORY Non OSS' cache
Refreshing Guru-RPMs
Not found: Media Exception
Error reading repository 'Guru-RPMs':
Valid metadata not found at specified URL(s)
Skipping repository 'Guru-RPMs' because of the above error.
Refreshing openSUSE-10.3-Updates
* Building repository 'openSUSE-10.3-Updates' cache
Refreshing 20070807-100738
* Building repository '20070807-100738' cache
Refreshing Packman_10.2_1
Not found: Media Exception
Error reading repository 'Packman_10.2_1':
Valid metadata not found at specified URL(s)
Skipping repository 'Packman_10.2_1' because of the above error.
Some of the repositories have not been refreshed because of error.

It should not be considered resolved.
Comment 6 Jan Kupec 2007-08-09 08:18:44 UTC
Nikolay, Richard, i've tested with latest zypper 0.8.9 with these urls:

http://ftp.gwdg.de/pub/linux/misc/suser-guru/rpm/10.2/
http://ftp.gwdg.de/pub/linux/misc/suser-guru/rpm/10.2/RPMS/
http://packman.iu-bremen.de/suse/10.3/

Please retest and if you encounter problems with these third party repos, open a NEW bug report. Please, attach also zypper.log then.
Comment 7 Nikolay Derkach 2007-08-09 08:33:11 UTC
After update to libzypp-3.13.13-1.1 everything is fine, including above repos.
Comment 8 Richard Creighton 2007-08-09 11:36:34 UTC
(In reply to comment #6 from Ján Kupec)
> Nikolay, Richard, i've tested with latest zypper 0.8.9 with these urls:
> 
> http://ftp.gwdg.de/pub/linux/misc/suser-guru/rpm/10.2/
> http://ftp.gwdg.de/pub/linux/misc/suser-guru/rpm/10.2/RPMS/
> http://packman.iu-bremen.de/suse/10.3/
> 
> Please retest and if you encounter problems with these third party repos, open
> a NEW bug report. Please, attach also zypper.log then.
> 

Thank you.   It is not yet available on FACTORY, but when it is, be assured I will test it and if there is a problem I will open an new report with logs.   In the meantime, thank you all for working this issue.  
Comment 9 Nikolay Derkach 2007-08-09 16:05:42 UTC
The problem appeared again after today factory sync, though no packages have been updated since my last message.
Comment 10 Duncan Mac-Vicar 2007-08-09 21:22:10 UTC
Error reading repository 'Packman_10.2_1':
Valid metadata not found at specified URL(s)

is related to file download. Can you attach zypper logs?
Comment 11 Jan Kupec 2007-08-10 08:18:16 UTC
Duncan, Nikolay, let's stick here with the 'SQL logic error or missing database', for another problems open a new bug as i suggested before. We are starting to have a pretty bad mess here.

This one still appears in latest libzypp.
Comment 12 Jan Kupec 2007-08-10 08:18:37 UTC
*** Bug 299136 has been marked as a duplicate of this bug. ***
Comment 13 Duncan Mac-Vicar 2007-08-10 12:22:28 UTC
Fixed in svn. Will close after submiting. rev6573
Comment 14 Duncan Mac-Vicar 2007-08-10 14:31:22 UTC
*** Bug 298350 has been marked as a duplicate of this bug. ***
Comment 15 Jan Kupec 2007-08-10 19:09:58 UTC
submitted in libzypp 3.14.0
Comment 16 Stefan Schubert 2007-08-13 12:01:24 UTC
*** Bug 298897 has been marked as a duplicate of this bug. ***
Comment 17 Ladislav Slezák 2007-08-16 08:11:29 UTC
*** Bug 300230 has been marked as a duplicate of this bug. ***
Comment 18 Stanislav Visnovsky 2007-08-17 08:59:42 UTC
*** Bug 297647 has been marked as a duplicate of this bug. ***
Comment 19 Matej Horvath 2007-08-23 13:33:33 UTC
*** Bug 301661 has been marked as a duplicate of this bug. ***