[Bug 207150] New: zmd-backend broken,
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 Summary: zmd-backend broken, Product: openSUSE 10.2 Version: Alpha 4 plus Platform: Other OS/Version: Other Status: NEW Severity: Critical Priority: P5 - None Component: libzypp AssignedTo: kkaempf@novell.com ReportedBy: aj@novell.com QAContact: kkaempf@novell.com zmd-backend.log shows: 2006-09-20 22:17:37 <3> x40(4846) [dbsource] DbSourceImpl.cc(create_select_handl e):126 Can not prepare selection clause: 2006-09-20 22:17:37 <3> x40(4846) [dbsource] DbSourceImpl.cc(create_select_handl e):126 SELECT id, media_nr, location, checksum, download_size, build_time, base version_version, baseversion_release, baseversion_epoch, baseversion_checksum, b aseversion_build_time , baseversion_sequence_info FROM delta_packages WHERE pack age_id = ? 2006-09-20 22:17:37 <3> x40(4846) [dbsource] DbSourceImpl.cc(create_select_handl e):126 no such column: build_time this is an update from Alpha4 to Alpha4plus. -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 kkaempf@novell.com changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |tambet@ximian.com, dmacvicar@novell.com AssignedTo|kkaempf@novell.com |jtariq@novell.com QAContact|kkaempf@novell.com |visnov@novell.com Summary|zmd-backend broken, |Inconsistent sql table layout between zmd and | |libzypp-zmd-backend ------- Comment #1 from kkaempf@novell.com 2006-09-21 01:23 MST ------- It seems like ZMD submitted for openSUSE 10.2 didn't implement all table changes as discussed between Tambet and Duncan -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 ------- Comment #2 from tambet@ximian.com 2006-09-21 02:03 MST ------- There's two possibilities why this problem exists: This field (delta_packages.built_time) wasn't in the initial sql schema Duncan sent me. Later on, on Sept 12th, has asked me on IRC to add that field and I did, on the same day. If the package is built after 12th, it's not a problem. Since we didn't think anyone is using that branch, I did not update DBVERSION, so if you had a recent build of zmd, you have to manually delete the zmd.db so it'll get re-generated on zmd startup. (Since I'm asked to not close fixed or invalid bugs, well.. I'm not doing it :) -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 jtariq@novell.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO Info Provider| |visnov@novell.com ------- Comment #3 from jtariq@novell.com 2006-09-21 10:54 MST ------- Stano, Is there anything else that needs to be done here? -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 aj@novell.com changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |aj@novell.com Status|NEEDINFO |ASSIGNED Info Provider|visnov@novell.com | ------- Comment #4 from aj@novell.com 2006-09-21 14:42 MST ------- The package was built on the 12th - and before your change went in. Jawaad, we need a new libzypp submission with that fix from SVN. -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 aj@novell.com changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|Critical |Blocker -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 ------- Comment #5 from jtariq@novell.com 2006-09-25 08:25 MST ------- Andreas, simply deleting zmd.db and restarting zmd should resolve this. -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 ------- Comment #6 from aj@novell.com 2006-09-25 09:31 MST ------- It did not help at all. I tried that already. -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 ------- Comment #9 from flucifredi@novell.com 2006-09-27 13:50 MST ------- mike has submitted a new build yesterday after returning from FTO. -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 ------- Comment #10 from aj@novell.com 2006-09-29 12:52 MST ------- Thanks for the submission. But there's something still broken: aj@x40:~> rug --no-abbrev sl # | Status | Type | Name | URI --+--------+------+-----------------+------------------------------------------- 1 | Active | ZYPP | factory-extra | ftp://dist.suse.de/factory/FACTORY-E/inst-source-extra/suse 2 | Active | ZYPP | 20060921-192838 | ftp://dist.suse.de/factory/FACTORY/inst-source/suse aj@x40:~> rug packages factory-extra No packages found. aj@x40:~> rug ca Sub'd? | Name | Service -------+-----------------+---------------- Yes | factory-extra | factory-extra Yes | 20060921-192838 | 20060921-192838 rug packages returns just the installed packages but I do not see any packages in a subscribed catalog. The zmd-messages.log file says: 29 Sep 2006 20:47:06 INFO PackageManagementModule Using ZYPP backend 29 Sep 2006 20:47:07 INFO Database Incompatible database schema version detected. 29 Sep 2006 20:47:10 INFO RPMBackend Loading installed packages Duncan, Tambet, any ideas? -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 ------- Comment #11 from dmacvicar@novell.com 2006-10-02 08:25 MST ------- The incompatible database schema is ok. It means there is no database and it is creating one. The bug is actually when resyincing the souces (it happens even if you add a source from scratch), it seems parse-metadata is not called. I called parse-metadata manually and I got piscola(21305) [parse-metadata] parse-metadata.cc(sync_source):108 Source provides 1549 resolvables However, there is a small problem in parse-metadata I am now fixing. -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 ------- Comment #12 from tambet@ximian.com 2006-10-02 08:33 MST ------- parse-metadata isn't called if the database has catalogs.checksum which matches the current checksum. So if parse-metadata runs once with an error, but doesn't report it back to zmd, it will not get called until the metadata changes. I _really_ doubt it's a bug in zmd, it works fine with libredcarpet backend. -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 ------- Comment #13 from dmacvicar@novell.com 2006-10-02 11:22 MST ------- There is a memory bug where I get a corrupted meda number, I disabled writing patch and delta rpm information in the database, I will enable it later as I find why this happens. Also, I am not sure we are handling the checksum correcty yet. -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 flucifredi@novell.com changed: What |Removed |Added ---------------------------------------------------------------------------- AssignedTo|jtariq@novell.com |dmacvicar@novell.com Status|ASSIGNED |NEW -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 dmacvicar@novell.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |NEEDINFO Info Provider| |aj@novell.com ------- Comment #14 from dmacvicar@novell.com 2006-10-04 10:04 MST ------- Ok, update the checksum in the catalogs now. Q: Does I need to update the checksum and timestamp when updating the @system table to o does zmd takes care of it? I still have the problem that when I delete zmd.db by hand, and start zmd, zmd adds zypp sources, but does not call parse-metadata, so the checksum, timestamp are not set the first time! and of course resolvables are not loaded. Only update-status is called. Another bug: the schema does not seem to include a trigger to delete the patch and delta rpms when you remove the resolvables. So baseversions should be removed when removing patch rpms, patch rpms should be removed when removing its package. -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 aj@novell.com changed: What |Removed |Added ---------------------------------------------------------------------------- Info Provider|aj@novell.com |tambet@ximian.com ------- Comment #15 from aj@novell.com 2006-10-04 12:20 MST ------- I guess you wanted to ask Tambet... -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 tambet@ximian.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |ASSIGNED Info Provider|tambet@ximian.com | ------- Comment #16 from tambet@ximian.com 2006-10-05 01:44 MST ------- "Ok, update the checksum in the catalogs now. Q: Does I need to update the checksum and timestamp when updating the @system table to o does zmd takes care of it?" parse-metadata should update catalog.checksum and catalog.timestamp only in case of out of band services, or in other words, for zypp service only. For all other service types zmd has all the needed information to know if a call to parse-metadata is necessary and it updates the checksum and timestamp as well. There was a bug that zmd doesn't touch catalog.timestamp, I've fixed it now. "I still have the problem that when I delete zmd.db by hand, and start zmd, zmd adds zypp sources, but does not call parse-metadata, so the checksum, timestamp are not set the first time! and of course resolvables are not loaded. Only update-status is called." Ah, you should have said it happens only with zypp service. I found a bug about it - since zmd doesn't know it's checksums, it used an empty string which matches what empty catalogs have. I've fixed it now. "Another bug: the schema does not seem to include a trigger to delete the patch and delta rpms when you remove the resolvables. So baseversions should be removed when removing patch rpms, patch rpms should be removed when removing its package." I asked you to give me the full schema for patch and delta rpms, and triggers were not included there. The schema does not make sense to me, so please give me the schema snippet for triggers. Note that we have one way triggers only - removing a child never removes it's parent (eg, removing a package dependency doesn't remove it's package, or, removing a package doesn't remove it's catalog) for obvious reasons. -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 ------- Comment #17 from tambet@ximian.com 2006-10-05 01:51 MST ------- Maybe the last sentence wasn't as clear as it could. What I meant was, there can't be a trigger that executes on removal of a row from patch_packages, patch_packages_baseversions or delta_packages tables and triggers a removal in resolvables (and thus a bunch of other) table(s). A valid trigger would be executed when a row gets removed from resolvables table and for example, removes rows from delta_packages table where delta_packages.package_id == resolvables.id. -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150
------- Comment #18 from aj@novell.com 2006-10-05 02:12 MST -------
Tambet, #16 means that we need a new zmd package with these changes, correct?
2006-10-05 Tambet Ingo
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 ------- Comment #19 from tambet@ximian.com 2006-10-05 04:41 MST ------- Comment #18 - yes. -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 ------- Comment #20 from dmacvicar@novell.com 2006-10-05 04:54 MST ------- Let me send Tambet the triggers -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 tambet@ximian.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |ASSIGNED Info Provider|tambet@ximian.com | ------- Comment #22 from tambet@ximian.com 2006-10-09 03:00 MST ------- Committed to svn. -- 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, or are watching someone who is.
![](https://seccdn.libravatar.org/avatar/3035b38ff33cf86f480bb169b8500b80.jpg?s=120&d=mm&r=g)
https://bugzilla.novell.com/show_bug.cgi?id=207150 dmacvicar@novell.com changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |RESOLVED Resolution| |FIXED ------- Comment #23 from dmacvicar@novell.com 2006-10-09 05:23 MST ------- Ok. Seems to be all in place. -- 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, or are watching someone who is.
participants (1)
-
bugzilla_noreply@novell.com