python-psycopg: Missing dependencies? (libc6, libpq4)

Bug #74906 reported by .:. brainsik
16
Affects Status Importance Assigned to Milestone
psycopg (Debian)
Fix Released
Unknown
psycopg (Ubuntu)
Fix Released
Undecided
Unassigned
Dapper
Invalid
Undecided
Unassigned
Edgy
Fix Released
Medium
John Dong

Bug Description

Package: python-psycopg
Version: 1.1.21-7
Severity: grave
Justification: renders package unusable

It seems there are a couple of serious missing dependencies: libc6 and
libpq4. Though libc6 will already be availble due to other package
dependencies, libpq4 may not.

This leads to an import error like:

    import psycopg
    ImportError: libpq.so.4: cannot open shared object file: No such file or directory

Probably related, python-psycopg's description says:

    Description: Python module for PostgreSQL [dummy package]

But this is NOT a dummy package. This package contains the module!

It seems like there was an incomplete package migration.

This can also cause an upgrade from Dapper to Edgy to break an existing
system's psycopg support. For example, if 'aptitude dist-upgrade' is
used to upgrade from Dapper to Edgy and libpq4 is marked as
"automatically installed" (from being automatically installed when
python2.4-psycopg was installed), then libq4 will be *removed* as being
no longer in use. Afterwards, the import error above will happen and the
applications using it will fail.

-- System Information:
Debian Release: testing/unstable
  APT prefers edgy-updates
  APT policy: (500, 'edgy-updates'), (500, 'edgy-security'), (500, 'edgy')
Architecture: i386 (i686)
Shell: /bin/sh linked to /bin/dash
Kernel: Linux 2.6.17-10-server
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)

Versions of packages python-psycopg depends on:
ii python 2.4.3-11ubuntu3 An interactive high-level object-o
ii python-egenix-mxda 2.0.6ubuntu1-1ubuntu5 date and time handling routines fo

python-psycopg recommends no packages.

-- no debconf information

LaserJock (laserjock)
Changed in psycopg:
assignee: nobody → mantha
Revision history for this message
Kai Kasurinen (kai-kasurinen) wrote :

Fixed in Feisty:

psycopg (1.1.21-10) unstable; urgency=medium
 .
   * debian/control: added ${shlibs:Depends} to the python-psycopg Depends
     fields. (Closes: #386997)

Revision history for this message
Kai Kasurinen (kai-kasurinen) wrote :

psycopg (1.1.21-9) unstable; urgency=low

  * debian/control: removed "dummy package" from short description.

Changed in psycopg:
status: Unknown → Fix Released
Revision history for this message
.:. brainsik (brainsik) wrote :

oops. this was supposed to be edgy. closing.

Changed in psycopg:
status: Unconfirmed → Rejected
Revision history for this message
LaserJock (laserjock) wrote :

fixed in Feisty

Changed in psycopg:
assignee: mantha → nobody
status: Unconfirmed → Fix Released
Revision history for this message
LaserJock (laserjock) wrote :

working on SRU

Changed in psycopg:
assignee: nobody → mantha
status: Unconfirmed → Confirmed
Revision history for this message
.:. brainsik (brainsik) wrote :

Without libpq4, the python-psycopg module can't even be imported:

suki2:~$ python
Python 2.4.4c1 (#2, Oct 11 2006, 21:51:02)
[GCC 4.1.2 20060928 (prerelease) (Ubuntu 4.1.1-13ubuntu5)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import psycopg
>>>
suki2:~$ sudo dpkg -r libpq4
(Reading database ... 22108 files and directories currently installed.)
Removing libpq4 ...
suki2:~$ python
Python 2.4.4c1 (#2, Oct 11 2006, 21:51:02)
[GCC 4.1.2 20060928 (prerelease) (Ubuntu 4.1.1-13ubuntu5)] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import psycopg
Traceback (most recent call last):
  File "<stdin>", line 1, in ?
ImportError: libpq.so.4: cannot open shared object file: No such file or directory
>>>

Revision history for this message
John Dong (jdong) wrote :

Attached debdiff for edgy-proposed.

Tested and verified dependencies are properly picked up.

Changed in psycopg:
assignee: laserjock → jdong
Emmet Hikory (persia)
Changed in psycopg:
importance: Undecided → Medium
Revision history for this message
Daniel T Chen (crimsun) wrote :

Format: 1.7
Date: Sat, 28 Apr 2007 23:45:36 -0400
Source: psycopg
Binary: python-psycopg zope-psycopgda
Architecture: source
Version: 1.1.21-7ubuntu0.1
Distribution: edgy-proposed
Urgency: low
Maintainer: Fabio Tranchitella <email address hidden>
Changed-By: John Dong <email address hidden>
Description:
 python-psycopg - Python module for PostgreSQL
 zope-psycopgda - Zope database adapter based on python-psycopg
Launchpad-Bugs-Fixed: 74906
Changes:
 psycopg (1.1.21-7ubuntu0.1) edgy-proposed; urgency=low
 .
   * SRU: (LP: #74906)
     - Remove [Dummy Package] from description. It is not.
     - Add ${shlibs:Depends} to dependencies.
Files:
 bfa2902ebe4e34a0f4b4eade22a28164 844 python optional psycopg_1.1.21-7ubuntu0.1.dsc
 7af6fb3f63b4bdf0ab81b2e829f64576 6846 python optional psycopg_1.1.21-7ubuntu0.1.diff.gz

Changed in psycopg:
status: Confirmed → In Progress
Revision history for this message
Martin Pitt (pitti) wrote :

Accepted into edgy-proposed, please go ahead with QA testing.

Changed in psycopg:
status: In Progress → Fix Committed
Revision history for this message
John Dong (jdong) wrote :

psycopg (1.1.21-7ubuntu0.1) edgy-proposed; urgency=low

  * SRU: (LP: #74906)
    - Remove [Dummy Package] from description. It is not.
    - Add ${shlibs:Depends} to dependencies.

 -- John Dong <email address hidden> Sat, 28 Apr 2007 23:45:36 -0400

Changed in psycopg:
status: Fix Committed → Fix Released
Emmet Hikory (persia)
Changed in psycopg:
status: Fix Released → Fix Committed
Revision history for this message
Martin Pitt (pitti) wrote :

SRU verification team, this seems trivial to validate. Can you please give this a test?

Revision history for this message
Leann Ogasawara (leannogasawara) wrote :

Test completed successfully.

On and Edgy installation, with python-psycopg version 1.1.21-7 the error is reproducible:

import psycopg
ImportError: libpq.so.4: cannot open shared object file: No such file or directory

With python-psycopg version 1.1.21-7ubuntu0.1 there is no error.

Revision history for this message
Martin Pitt (pitti) wrote :

Copied to edgy-updates.

Changed in psycopg:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.