* Christoph Thiel [01-01-70 12:34]:

We have already looked into this, but found it not to be usable so far, as the sqlite database schema turns out to be a plain represetation of the xml files, i.e. it's quite suboptimal for libzypp, which uses its own database schema. Duncan, could you please elaborate on the details -- I know you did some benchmarks already.

For yum uses it might still make sense to enable the sqlite db support (-d option of createrop > 0.4.8).

openSUSE 10.1 2.6.18.5-jen40-default SMP x86_64 Appears to be a dependency error in createrepo-0.4.7-3.1@noarch 14:53 wahoo:~ # createrepo /home/pat/Desktop/Downloads/. Traceback (most recent call last): File "/usr/share/createrepo/genpkgmetadata.py", line 32, in ? import dumpMetadata File "/usr/share/createrepo/dumpMetadata.py", line 32, in ? import sqlitecachec File "/usr/lib64/python2.4/site-packages/sqlitecachec.py", line 15, in ? import sqlite ImportError: No module named sqlite 10:51 wahoo:~ > rpm -qa |grep sqlite sqlite2-32bit-2.8.17-13 mono-data-sqlite-1.1.13.8-7 sqlite-3.3.5-9.1 sqlite-32bit-3.2.8-14 sqlite2-2.8.17-13 python-sqlite2-2.2.0-0.pm.0 I have reverted to createrepo-0.4.4-9.3.noarch.rpm and have no problem. tks, -- Patrick Shanahan Registered Linux User #207535 http://wahoo.no-ip.org @ http://counter.li.org HOG # US1244711 Photo Album: http://wahoo.no-ip.org/gallery2 OpenSUSE Linux http://en.opensuse.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org For additional commands, e-mail: opensuse-factory+help@opensuse.org

* Christoph Thiel [02-11-07 13:35]: [...]

What does "rpm -q --changelog python" tell you? It should include:

* Mo Jan 08 2007 - cthiel@suse.de - fix sqlite3 support (#228733)

14:27 wahoo:~ > rpm -q --changelog python |head -20 * Wed Sep 27 2006 - jmatejek@suse.cz - fix buffer overflow in built-in function repr() on UCS4 build (CVE 2006-4980, #208223) * Wed Mar 15 2006 - jmatejek@suse.cz - moved -doc and -doc-pdf into separate noarch specfile * Mon Feb 27 2006 - jmatejek@suse.cz - implemented /usr/local path schemes for bug #149809 - python now recognizes packages in /usr/local/lib/python2.4 - distutils install by default into /usr/local/lib/python2.4/site-packages - on 64bit systems that is of course lib64 * Wed Jan 25 2006 - mls@suse.de - converted neededforbuild to BuildRequires * Sat Jan 14 2006 - kukuk@suse.de - Add gmp-devel to nfb * Mon Nov 28 2005 - jmatejek@suse.cz - reenabled optimization on ppc64 * Fri Nov 11 2005 - nadvornik@suse.cz - fixed another bug in canonicalize patch [#133267] 14:27 wahoo:~ > rpm -q python python-2.4.2-18.5 tks, -- Patrick Shanahan Registered Linux User #207535 http://wahoo.no-ip.org @ http://counter.li.org HOG # US1244711 Photo Album: http://wahoo.no-ip.org/gallery2 OpenSUSE Linux http://en.opensuse.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org For additional commands, e-mail: opensuse-factory+help@opensuse.org

On Sun, Feb 11, 2007 at 02:42:09PM -0500, Patrick Shanahan wrote:

* Patrick Shanahan [02-11-07 14:31]: [...]

...

14:27 wahoo:~ > rpm -q python python-2.4.2-18.5

update reverted to: python-sqlite2-2.0.4-1.guru.suse101 upgraded createrepo: createrepo-0.4.7-3.1

Just failed to reproduce this on 10.1/SLED with stock python-sqlite package. Seems to be a problem in python-sqlite2 from Pascal? Best, Christoph -- Christoph Thiel, Tech. Project Management, Research & Development SUSE LINUX Products GmbH, GF: Markus Rex, HRB 16746 (AG Nürnberg) --------------------------------------------------------------------- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org For additional commands, e-mail: opensuse-factory+help@opensuse.org

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Patrick Shanahan wrote:

* Christoph Thiel [02-16-07 07:24]:

...

Just failed to reproduce this on 10.1/SLED with stock python-sqlite package. Seems to be a problem in python-sqlite2 from Pascal?

Have bounced thread to Pascal.

There is no problem in my python-sqlite2 package. No patches, no fancy stuff, and it works great with gajim. Maybe incompatible versions of createrepo vs python-sqlite2 ? - -- -o) Pascal Bleser http://linux01.gwdg.de/~pbleser/ /\\ _\_v The more things change, the more they stay insane. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.5 (GNU/Linux) iD8DBQFF1jk0r3NMWliFcXcRAqyfAJ9SX5fUicK4cxLhQzUxIHwfDppxPQCfYfcR y93LHORIfCiK06B/CsrVYMg= =XDVq -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org For additional commands, e-mail: opensuse-factory+help@opensuse.org

On Sunday 11 February 2007 15:07, you wrote:

For yum uses it might still make sense to enable the sqlite db support (-d option of createrop > 0.4.8).

ls -lah /var/cache/yum/stable total 348M drwxr-xr-x 4 root root 376 2007-02-08 12:23 . drwxr-xr-x 3 root root 72 2007-02-08 12:21 .. -rw-r--r-- 1 root root 0 2007-02-08 12:21 cachecookie -rw-r--r-- 1 root root 16M 2007-02-06 13:41 filelists.xml.gz -rw-r--r-- 1 root root 72M 2007-02-08 12:22 filelists.xml.gz.sqlite drwxr-xr-x 2 root root 48 2007-02-08 12:21 headers -rw-r--r-- 1 root root 45M 2007-02-06 13:41 other.xml.gz -rw-r--r-- 1 root root 172M 2007-02-08 12:23 other.xml.gz.sqlite drwxr-xr-x 2 root root 48 2007-02-08 12:21 packages -rw-r--r-- 1 root root 6.8M 2007-02-06 13:41 primary.xml.gz -rw-r--r-- 1 root root 37M 2007-02-08 12:21 primary.xml.gz.sqlite -rw-r--r-- 1 root root 951 2007-02-06 13:41 repomd.xml the .sqlite versions are the resulted "parsed" xml files. from stable (factory) tree. Duncan --------------------------------------------------------------------- To unsubscribe, e-mail: opensuse-factory+unsubscribe@opensuse.org For additional commands, e-mail: opensuse-factory+help@opensuse.org