[apport] package python-sqlite failed to install/upgrade:

[Daniel Elstner]

Binary package hint: python-sqlite

Just upgraded from Edgy to Feisty today running "gksu update-manager -d". Everything went smooth except for python-sqlite, which failed to install. Unfortunately I can't post the log here as the terminal window has already been closed. However, I recall that the error message was about some pkg file supposedly already existing.

ProblemType: Package
Date: Tue Feb 20 20:18:56 2007
ErrorMessage:
 ErrorMessage: Unterprozess post-installation script gab den Fehlerwert 1 zurück
Package: python-sqlite
SourcePackage: python-sqlite

[Andrew Mitchell (ajmitch)]

The error message is:

Setting up python-sqlite (1.0.1-5ubuntu1) ...
pycentral: pycentral pkginstall: already exists: /usr/lib/python2.4/site-packages/pysqlite.egg-info -> /usr/share/pycentral/python-pysqlite2/site-packages/pysqlite.egg-info
pycentral pkginstall: already exists: /usr/lib/python2.4/site-packages/pysqlite.egg-info -> /usr/share/pycentral/python-pysqlite2/site-packages/pysqlite.egg-info
dpkg: error processing python-sqlite (--configure):
 subprocess post-installation script returned error exit status 1
Errors were encountered while processing:
 python-sqlite

[Daniel Elstner (daniel-elstner)]

The problem goes away after uninstalling python-pysqlite2.

[Martin Pool (mbp)]

Confirmed. Maybe python-sqlite should Replace python-pysqlite2, if that is the intention?

[Daniel Elstner (daniel-elstner)]

Don't think so, as python-sqlite2 provides the Python interface to SQLite *3*, and e.g. gcompris depends on it. Seems they should be parallel-installable.

[Scott Kitterman (kitterman)]

Both python-sqlite and python-pysqlite2 have the Python module name pysqlite and so install of one will fail if the other is already installed.

[Ralf Nieuwenhuijsen (ralf-nieuwenhuijsen)]

Which is problematic because 'griffith' is dependend upon it.

[Piotr Ożarowski (piotr)]

python-sqlite is providing "sqlite" module (for SQLite2) and python-pysqlite2 - "pysqlite2" (for SQLite3). The only conflicting data is Egg info.

I suggest to remove Egg info from python-sqlite package (so that:
`python -c 'import pkg_resources; pkg_resources.require("pysqlite")'` will return pysqlite2 data.

btw: Griffith uses python-sqlite to convert databases from SQLite2 to SQLite3 while upgrading from 0.6.2

[Piotr Ożarowski (piotr)]

With attached patch all works fine. Please note that upstream author is not providing Egg support by default, it is added by new setuptools and since python-sqlite is obsolete, I dare to say that removing Egg support will not make any damage to the package

[Piotr Ożarowski (piotr)]

Another solution is versioned Egg file name (that is allowed), but in that case pkg_resources always detects only the older package (1.0.1) even if python-pysqlite2 is providing versioned Egg.

(I still recommend to remove Egg file from python-sqlite, see my previous patch)

[Piotr Ożarowski (piotr)]

OK, I change my recommendation to:
* leave this (python-sqlite) package untouched
* apply my patch from #87493 to python-pysqlite2

:-)

[Matthias Klose (doko)]

fixed in python-sqlite_1.0.1-5ubuntu2