Bug 325599

Summary: Cannot Change Software Repositories
Product: [openSUSE] openSUSE 10.3 Reporter: Stephan Binner <stbinner>
Component: libzyppAssignee: Michael Andres <ma>
Status: RESOLVED FIXED QA Contact: Stanislav Visnovsky <visnov>
Severity: Critical    
Priority: P5 - None CC: bart.otten85, coolo, dimstar, dmacvicar, kkaempf
Version: Beta 3   
Target Milestone: ---   
Hardware: Other   
OS: Other   
Whiteboard:
Found By: Development Services Priority:
Business Priority: Blocker: ---
Marketing QA Status: --- IT Deployment: ---

Description Stephan Binner 2007-09-17 07:37:12 UTC
I updated to Factory this morning and just wanted to change a repository location. When clicking "Finish" a dialog box appears stating "Unable to save changes to the repository configuration. Details: table patch_packages has no column named name    Try again?"
Comment 2 Stephan Binner 2007-09-17 08:29:37 UTC
Such a warning now also appears when starting the "Software Management" module.
Comment 3 Stephan Binner 2007-09-17 08:37:12 UTC
Seems this "warning" prevents installation of any new software.
Comment 4 Bart Otten 2007-09-17 13:42:58 UTC
Yes, we are doomed since this early morning. Problems with building the cache-database cause a column is missing in the database so it seems.

Does NOT work:
* Refresh sources in YaST
* rpm -v --rebuilddb
* zypper refresh -f

Guess we have to wait for an proper database-model?
Comment 5 Bart Otten 2007-09-17 14:39:02 UTC
Guess the problem arised cause of using Package Manager to update and not Factory Update?

Anyway, you can fix the problem by entering these commands as root:

rm -R /var/cache/zypp/*

After that you can refresh sources:

zypper -v refresh -f
Comment 6 Stephan Kulow 2007-09-17 18:21:28 UTC
*** Bug 325727 has been marked as a duplicate of this bug. ***
Comment 7 Stephan Kulow 2007-09-17 18:26:55 UTC
Duncan, is this is a Factory problem or can it happen again?
Comment 8 Stanislav Visnovsky 2007-09-17 20:23:19 UTC
Michael, your fixes for patch & delta RPMs?
Comment 9 Jan Kupec 2007-09-18 06:34:06 UTC
(In reply to comment #7 from Stephan Kulow)
> Duncan, is this is a Factory problem or can it happen again?

No, it is a problem of changed cache db schema. I believe http://svn.opensuse.org/viewcvs/zypp?rev=7261&view=rev fixed it (?).
Comment 10 Stephan Kulow 2007-09-18 10:34:38 UTC
ok, fixed