[Psycopg] Psycopg2-2.0.6 freezes when imported under FreeBSD-7.0

[Dragos Petre]

Hi!

Complete newbie question here - I would appreciate your help a lot!

I have installed psycopg2-2.0.6 under FreeBSD-7.0 (both under python-2.4 and
python-2.5 - results are similar). When I try to import psycopg2 my python
prompt freezes (if i try it from a module the result is the same). At the
bottom of the message is the output when running it in python's verbose
mode. The interactive shell freezes at the last line so I have to kill it.

Other information of interest may be:

[root at nass /var/tmp]# gcc -v
Using built-in specs.
Target: i386-undermydesk-freebsd
Configured with: FreeBSD/i386 system compiler
Thread model: posix
gcc version 4.2.1 20070719  [FreeBSD]

[root at nass /var/tmp]# su pgsql
[pgsql at nass /var/tmp]$ postgres --version
postgres (PostgreSQL) 8.2.6
[pgsql at nass /var/tmp]$ exit

[root at nass /var/tmp]# ldd /usr/local/lib/python2.5/site-packages/pg
y sycopg2/_psycop
pg.so
/usr/local/lib/python2.5/site-packages/psycopg2/_psycopg.so:
    libpq.so.5 => /usr/local/lib/libpq.so.5 (0x281aa000)
    libc.so.7 => /lib/libc.so.7 (0x28080000)
    libintl.so.8 => /usr/local/lib/libintl.so.8 (0x281cc000)
    libssl.so.5 => /usr/local/lib/libssl.so.5 (0x28300000)
    libcrypto.so.5 => /usr/local/lib/libcrypto.so.5 (0x28340000)
    libcrypt.so.4 => /lib/libcrypt.so.4 (0x281d5000)
    libthr.so.3 => /lib/libthr.so.3 (0x28480000)
    libiconv.so.3 => /usr/local/lib/libiconv.so.3 (0x28493000)

Please let me know if I missed any relevant info. Any pointers would be very
much appreciated.

Thanks a lot,
Dragos.

[root at nass /var/tmp]# python -v
# installing zipimport hook
import zipimport # builtin
# installed zipimport hook
# /usr/local/lib/python2.5/site.pyc matches /usr/local/lib/python2.5/site.py
import site # precompiled from /usr/local/lib/python2.5/site.pyc
# /usr/local/lib/python2.5/os.pyc matches /usr/local/lib/python2.5/os.py
import os # precompiled from /usr/local/lib/python2.5/os.pyc
import errno # builtin
import posix # builtin
# /usr/local/lib/python2.5/posixpath.pyc matches
/usr/local/lib/python2.5/posixpath.py
import posixpath # precompiled from /usr/local/lib/python2.5/posixpath.pyc
# /usr/local/lib/python2.5/stat.pyc matches /usr/local/lib/python2.5/stat.py
import stat # precompiled from /usr/local/lib/python2.5/stat.pyc
# /usr/local/lib/python2.5/UserDict.pyc matches
/usr/local/lib/python2.5/UserDict.py
import UserDict # precompiled from /usr/local/lib/python2.5/UserDict.pyc
# /usr/local/lib/python2.5/copy_reg.pyc matches
/usr/local/lib/python2.5/copy_reg.py
import copy_reg # precompiled from /usr/local/lib/python2.5/copy_reg.pyc
# /usr/local/lib/python2.5/types.pyc matches
/usr/local/lib/python2.5/types.py
import types # precompiled from /usr/local/lib/python2.5/types.pyc
import _types # builtin
# /usr/local/lib/python2.5/warnings.pyc matches
/usr/local/lib/python2.5/warnings.py
import warnings # precompiled from /usr/local/lib/python2.5/warnings.pyc
# /usr/local/lib/python2.5/linecache.pyc matches
/usr/local/lib/python2.5/linecache.py
import linecache # precompiled from /usr/local/lib/python2.5/linecache.pyc
import encodings # directory /usr/local/lib/python2.5/encodings
# /usr/local/lib/python2.5/encodings/__init__.pyc matches
/usr/local/lib/python2.5/encodings/__init__.py
import encodings # precompiled from
/usr/local/lib/python2.5/encodings/__init__.pyc
# /usr/local/lib/python2.5/codecs.pyc matches
/usr/local/lib/python2.5/codecs.py
import codecs # precompiled from /usr/local/lib/python2.5/codecs.pyc
import _codecs # builtin
# /usr/local/lib/python2.5/encodings/aliases.pyc matches
/usr/local/lib/python2.5/encodings/aliases.py
import encodings.aliases # precompiled from
/usr/local/lib/python2.5/encodings/aliases.pyc
# /usr/local/lib/python2.5/encodings/ascii.pyc matches
/usr/local/lib/python2.5/encodings/ascii.py
import encodings.ascii # precompiled from
/usr/local/lib/python2.5/encodings/ascii.pyc
Python 2.5.2 (r252:60911, Mar 11 2008, 08:36:29)
[GCC 4.2.1 20070719  [FreeBSD]] on freebsd7
Type "help", "copyright", "credits" or "license" for more information.
dlopen("/usr/local/lib/python2.5/lib-dynload/readline.so", 2);
import readline # dynamically loaded from
/usr/local/lib/python2.5/lib-dynload/readline.so
>>> import psycopg2
import psycopg2 # directory /usr/local/lib/python2.5/site-packages/psycopg2
# /usr/local/lib/python2.5/site-packages/psycopg2/__init__.pyc matches
/usr/local/lib/python2.5/site-packages/psycopg2/__init__.py
import psycopg2 # precompiled from
/usr/local/lib/python2.5/site-packages/psycopg2/__init__.pyc
dlopen("/usr/local/lib/python2.5/lib-dynload/datetime.so", 2);
import datetime # dynamically loaded from
/usr/local/lib/python2.5/lib-dynload/datetime.so
# /usr/local/lib/python2.5/decimal.pyc matches
/usr/local/lib/python2.5/decimal.py
import decimal # precompiled from /usr/local/lib/python2.5/decimal.pyc
# /usr/local/lib/python2.5/copy.pyc matches /usr/local/lib/python2.5/copy.py
import copy # precompiled from /usr/local/lib/python2.5/copy.pyc
# /usr/local/lib/python2.5/threading.pyc matches
/usr/local/lib/python2.5/threading.py
import threading # precompiled from /usr/local/lib/python2.5/threading.pyc
import thread # builtin
dlopen("/usr/local/lib/python2.5/lib-dynload/time.so", 2);
import time # dynamically loaded from
/usr/local/lib/python2.5/lib-dynload/time.so
# /usr/local/lib/python2.5/traceback.pyc matches
/usr/local/lib/python2.5/traceback.py
import traceback # precompiled from /usr/local/lib/python2.5/traceback.pyc
dlopen("/usr/local/lib/python2.5/lib-dynload/collections.so", 2);
import collections # dynamically loaded from
/usr/local/lib/python2.5/lib-dynload/collections.so
# /usr/local/lib/python2.5/re.pyc matches /usr/local/lib/python2.5/re.py
import re # precompiled from /usr/local/lib/python2.5/re.pyc
# /usr/local/lib/python2.5/sre_compile.pyc matches
/usr/local/lib/python2.5/sre_compile.py
import sre_compile # precompiled from
/usr/local/lib/python2.5/sre_compile.pyc
import _sre # builtin
# /usr/local/lib/python2.5/sre_constants.pyc matches
/usr/local/lib/python2.5/sre_constants.py
import sre_constants # precompiled from
/usr/local/lib/python2.5/sre_constants.pyc
# /usr/local/lib/python2.5/sre_parse.pyc matches
/usr/local/lib/python2.5/sre_parse.py
import sre_parse # precompiled from /usr/local/lib/python2.5/sre_parse.pyc
# /usr/local/lib/python2.5/site-packages/psycopg2/tz.pyc matches
/usr/local/lib/python2.5/site-packages/psycopg2/tz.py
import psycopg2.tz # precompiled from
/usr/local/lib/python2.5/site-packages/psycopg2/tz.pyc
dlopen("/usr/local/lib/python2.5/site-packages/psycopg2/_psycopg.so", 2);
Killed: 9
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.initd.org/pipermail/psycopg/attachments/20080311/f26e232d/attachment.htm