[Bug 297627] New: Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

bugzilla_noreply＠novell.com

5 Aug 2007 5 Aug '07

17:50

https://bugzilla.novell.com/show_bug.cgi?id=297627 Summary: Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database Product: openSUSE 10.3 Version: Alpha 7 Platform: Other OS/Version: Other Status: NEW Severity: Critical Priority: P5 - None Component: libzypp AssignedTo: kkaempf@novell.com ReportedBy: nderkach@gmail.com QAContact: kkaempf@novell.com Found By: --- 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. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

Show replies by date

bugzilla_noreply＠novell.com

6 Aug 6 Aug

07:16

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627 Klaus Kämpf changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |visnov@novell.com AssignedTo|kkaempf@novell.com |dmacvicar@novell.com -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

8 Aug 8 Aug

09:53

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c1 --- Comment #1 from Nikolay Derkach 2007-08-08 03:53:32 MST --- 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. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

10:14

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c2 Nikolay Derkach changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |funtasyspace@yahoo.com --- Comment #2 from Nikolay Derkach 2007-08-08 04:14:24 MST --- *** Bug 298350 has been marked as a duplicate of this bug. *** https://bugzilla.novell.com/show_bug.cgi?id=298350 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

12:32

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c3 Duncan Mac-Vicar changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED --- Comment #3 from Duncan Mac-Vicar 2007-08-08 06:32:52 MST --- ------------------------------------------------------------------- Fri Aug 3 14:13:36 CEST 2007 - dmacvicar@suse.de - Fixed cache schema upgrade -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

16:47

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c4 Nikolay Derkach changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jblunck@novell.com --- Comment #4 from Nikolay Derkach 2007-08-08 10:47:01 MST --- *** Bug 298506 has been marked as a duplicate of this bug. *** https://bugzilla.novell.com/show_bug.cgi?id=298506 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

17:55

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c5 --- Comment #5 from Richard Creighton 2007-08-08 11:55:15 MST --- (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. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

9 Aug 9 Aug

08:18

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c6 --- Comment #6 from Ján Kupec 2007-08-09 02:18:44 MST --- 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. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

08:33

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c7 --- Comment #7 from Nikolay Derkach 2007-08-09 02:33:11 MST --- After update to libzypp-3.13.13-1.1 everything is fine, including above repos. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

11:36

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c8 --- Comment #8 from Richard Creighton 2007-08-09 05:36:34 MST --- (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. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

16:05

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c9 Nikolay Derkach changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|FIXED | Version|Alpha 7 |Beta 1 --- Comment #9 from Nikolay Derkach 2007-08-09 10:05:42 MST --- The problem appeared again after today factory sync, though no packages have been updated since my last message. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

21:22

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c10 --- Comment #10 from Duncan Mac-Vicar 2007-08-09 15:22:10 MST --- 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? -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

10 Aug 10 Aug

08:18

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c11 --- Comment #11 from Ján Kupec 2007-08-10 02:18:16 MST --- 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. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

08:18

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c12 Ján Kupec changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |hi-du@gmx.de --- Comment #12 from Ján Kupec 2007-08-10 02:18:37 MST --- *** Bug 299136 has been marked as a duplicate of this bug. *** https://bugzilla.novell.com/show_bug.cgi?id=299136 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

12:22

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c13 --- Comment #13 from Duncan Mac-Vicar 2007-08-10 06:22:28 MST --- Fixed in svn. Will close after submiting. rev6573 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

14:31

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c14 --- Comment #14 from Duncan Mac-Vicar 2007-08-10 08:31:22 MST --- *** Bug 298350 has been marked as a duplicate of this bug. *** https://bugzilla.novell.com/show_bug.cgi?id=298350 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

19:09

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c15 Ján Kupec changed: What |Removed |Added ---------------------------------------------------------------------------- Status|REOPENED |RESOLVED Resolution| |FIXED --- Comment #15 from Ján Kupec 2007-08-10 13:09:58 MST --- submitted in libzypp 3.14.0 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

13 Aug 13 Aug

12:01

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c16 Stefan Schubert changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |meissner@novell.com --- Comment #16 from Stefan Schubert 2007-08-13 06:01:24 MST --- *** Bug 298897 has been marked as a duplicate of this bug. *** https://bugzilla.novell.com/show_bug.cgi?id=298897 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

16 Aug 16 Aug

08:11

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c17 Ladislav Slezak changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |chrubis@novell.com --- Comment #17 from Ladislav Slezak 2007-08-16 02:11:29 MST --- *** Bug 300230 has been marked as a duplicate of this bug. *** https://bugzilla.novell.com/show_bug.cgi?id=300230 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

17 Aug 17 Aug

08:59

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c18 Stanislav Visnovsky changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |rccj@ricreig.com --- Comment #18 from Stanislav Visnovsky 2007-08-17 02:59:42 MST --- *** Bug 297647 has been marked as a duplicate of this bug. *** https://bugzilla.novell.com/show_bug.cgi?id=297647 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

bugzilla_noreply＠novell.com

23 Aug 23 Aug

13:33

New subject: [Bug 297627] Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

https://bugzilla.novell.com/show_bug.cgi?id=297627#c19 Matej Horvath changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |romain.pelissier@gmail.com --- Comment #19 from Matej Horvath 2007-08-23 07:33:33 MST --- *** Bug 301661 has been marked as a duplicate of this bug. *** https://bugzilla.novell.com/show_bug.cgi?id=301661 -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.

6093

Age (days ago)

6111

Last active (days ago)

List overview

Download

20 comments

1 participants

participants (1)

bugzilla_noreply＠novell.com

[Bug 297627] New: Cache exception: sqlite3x_reader.cpp(read):71: SQL logic error or missing database

tags

participants (1)