Bug 179547
Summary: | python-sqlite breaks yum (after update to the sqlite-3.3.3-1) | ||||||
---|---|---|---|---|---|---|---|
Product: | [Fedora] Fedora | Reporter: | Harald Hoyer <harald> | ||||
Component: | python-sqlite | Assignee: | Paul Nasrat <nobody+pnasrat> | ||||
Status: | CLOSED RAWHIDE | QA Contact: | |||||
Severity: | high | Docs Contact: | |||||
Priority: | medium | ||||||
Version: | rawhide | CC: | a.kurtz, alan.krause, ask, caillon, dm, dravet, justin.conover, katzj, k.georgiou, lsof, milan.kerslager, mlists, netllama, redhat, sangu.fedora, sundaram, xraoul | ||||
Target Milestone: | --- | ||||||
Target Release: | --- | ||||||
Hardware: | All | ||||||
OS: | Linux | ||||||
Whiteboard: | |||||||
Fixed In Version: | Doc Type: | Bug Fix | |||||
Doc Text: | Story Points: | --- | |||||
Clone Of: | Environment: | ||||||
Last Closed: | 2006-02-06 15:58:27 UTC | Type: | --- | ||||
Regression: | --- | Mount Type: | --- | ||||
Documentation: | --- | CRM: | |||||
Verified Versions: | Category: | --- | |||||
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||
Cloudforms Team: | --- | Target Upstream Version: | |||||
Embargoed: | |||||||
Attachments: |
|
Description
Harald Hoyer
2006-02-01 10:57:44 UTC
Had to remove beagle and f-spot rpm -e beagle f-spot rpm -Uvh --oldpackage sqlite-3.2.8-1.i386.rpm *** Bug 179554 has been marked as a duplicate of this bug. *** Thanks for the report - replicated here, and seen in the installer too. Chris did you test yum with updated sqlite? Actually, yes. I yum updated yesterday with the new package I built, so I don't see the issue. Since harald said that 3.3.2 worked, I just posted that RPM here since it never was released: http://people.redhat.com/caillon/RPMS/rawhide/sqlite-3.3.2-1.i386.rpm My reproducer that Chris has confirmed: yum update sqlite yum clean all yum list updates I'm confirming the bug in sqlite too. Downgrading yum did not help. Downgrading sqlite fixed the problem: sqlite-3.2.7-2.1.i386.rpm (from FCtest2) yum works sqlite-3.3.2-1.i386.rpm (from comment #4) yum works Another reproducer: python /usr/share/doc/python-sqlite-1.1.6/examples/converters.py It fails at cu.execute("create table test(p point, n int)") Kostas - Thanks for the pointer to the smaller reproducer Milan - Thanks for the confirmation of working status. import sqlite db = sqlite.connect("test") cur = db.cursor() cur.execute("""CREATE TABLE db_info ( dbversion TEXT, checksum TEXT) """) This works: sqlite> .schema db_info CREATE TABLE db_info ( foo TEXT, bar TEXT); sqlite> python-sqlite fails to create tables. Root cause by this changeset: http://www.sqlite.org/cvstrac/tktview?tn=1554 python-sqlite was using 0 for nBytes. Changing to -1 in python-sqlite fixes. python-sqlite-1.1.6-3 *** Bug 179587 has been marked as a duplicate of this bug. *** *** Bug 179648 has been marked as a duplicate of this bug. *** first issue [root@goorah ~]# rpm -qa | grep sqlite -bash: grep: No such file or directory [root@goorah ~]# rpm -q sqlite sqlite-3.3.3-1 [root@goorah ~]# rpm -e sqlite-3.3.3-1 error: Failed dependencies: libsqlite3.so.0 is needed by (installed) python-sqlite-1.1.6-1.1.i386 libsqlite3.so.0 is needed by (installed) rpm-libs-4.4.2-13.i386 libsqlite3.so.0 is needed by (installed) rpm-4.4.2-13.i386 libsqlite3.so.0 is needed by (installed) rpm-devel-4.4.2-13.i386 libsqlite3.so.0 is needed by (installed) rpm-build-4.4.2-13.i386 libsqlite3.so.0 is needed by (installed) apr-util-1.2.2-4.i386 sqlite = 3.3.3-1 is needed by (installed) sqlite-devel-3.3.3-1.i386 sqlite is needed by (installed) mono-data-sqlite-1.1.13.2-1.i386 ive just removed digikam and its dependencies. Isn't there any other solution than downgrading? Grab the version from test2 and rpm -ivh --oldpackage and you'll be fine. (In reply to comment #16) > Grab the version from test2 and rpm -ivh --oldpackage and you'll be fine. rpm -Uvh --oldpackage sqlite-3.2.8-1.i386.rpm Created attachment 124021 [details] patch for python-sqlite Thanks to Paul Nasrat for finding the bug (comment #11). yum is working fine after installing python-sqlite recompiled with this patch. By the way, newer versions of python-sqlite are available at http://pysqlite.org/ *** Bug 176492 has been marked as a duplicate of this bug. *** *** Bug 180072 has been marked as a duplicate of this bug. *** *** Bug 180399 has been marked as a duplicate of this bug. *** Can someone clue me in on where I can get this 3.2.8-1 older version of sqlite? I just scoured the FC ftp server, and I don't see sqlite-3.2.8-1 anywhere. All I've found is 3.3.3-1 (bad) and 3.2.7-2.1 (old). sqlite 3.3.3-1 is not bad, python-sqlite is. get the version from comment 12 or later Install python-sqlite-1.1.6-3 and you should be fine with sqlite-3.3.3-1: http://download.fedora.redhat.com/pub/fedora/linux/core/development/i386/Fedora/RPMS/python-sqlite-1.1.6-3.i386.rpm Thanks, that worked for me as a workaround. *** Bug 179648 has been marked as a duplicate of this bug. *** |