2.4.2: undefined symbol: lo_truncate

From: Matthew Robinson <matthew(dot)robinson(at)umassd(dot)edu>
To: psycopg(at)postgresql(dot)org
Subject: 2.4.2: undefined symbol: lo_truncate
Date: 2011-10-06 14:33:39
Message-ID: 62e6d6b2-6456-4267-a733-43617632fc41@zimbra-mb4.umassd.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

Warning, a python neophyte here so I am more than likely missing something.

I'm trying to use 2.4.2 (and also tried 2.4.1 with same error, 2.4.0 with a different error...) under Ubuntu with the intention of trying out ReviewBoard.

launching python and attempting to import psycopg2 yields:
--------
>>> import psycopg2
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/local/lib/python2.6/
dist-packages/psycopg2/__init_ _.py", line 67, in <module>
from psycopg2._psycopg import BINARY, NUMBER, STRING, DATETIME, ROWID
ImportError: /usr/local/lib/python2.6/dist- packages/psycopg2/_psycopg.so: undefined symbol: lo_truncate
>>>

My setup.cfg:
-------
[build_ext]
define=PSYCOPG_EXTENSIONS, PSYCOPG_NEW_BOOLEAN,HAVE_ PQFREEMEM
use_pydatetime=1
#static_libpq=1
pg_config=/usr/bin/pg_config

Output of /usr/bin/pg_config:
-----
# /usr/bin/pg_config
BINDIR = /usr/lib/postgresql/8.4/bin
DOCDIR = /usr/share/doc/postgresql
HTMLDIR = /usr/share/doc/postgresql
INCLUDEDIR = /usr/include/postgresql
PKGINCLUDEDIR = /usr/include/postgresql
INCLUDEDIR-SERVER = /usr/include/postgresql/8.4/ server
LIBDIR = /usr/lib
PKGLIBDIR = /usr/lib/postgresql/8.4/lib
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/postgresql/8.4/man
SHAREDIR = /usr/share/postgresql/8.4
SYSCONFDIR = /etc/postgresql-common
PGXS = /usr/lib/postgresql/8.4/lib/ pgxs/src/makefiles/ pgxs.mk
CONFIGURE = '--build=i486-linux-gnu' '--prefix=/usr' '--includedir=/usr/include' '--mandir=/usr/share/man' '--infodir=/usr/share/info' '--sysconfdir=/etc' '--localstatedir=/var' '--libexecdir=/usr/lib/ postgresql-8.4' '--disable-maintainer-mode' '--disable-dependency- tracking' '--disable-silent-rules' '--srcdir=.' '--mandir=/usr/share/ postgresql/8.4/man' '--with-docdir=/usr/share/doc/ postgresql-doc-8.4' '--sysconfdir=/etc/postgresql- common' '--datadir=/usr/share/ postgresql/8.4' '--bindir=/usr/lib/postgresql/ 8.4/bin' '--includedir=/usr/include/ postgresql/' '--enable-nls' '--enable-integer-datetimes' '--enable-thread-safety' '--enable-debug' '--disable-rpath' '--with-tcl' '--with-perl' '--with-python' '--with-pam' '--with-krb5' '--with-gssapi' '--with-openssl' '--with-libxml' '--with-libxslt' '--with-ldap' '--with-ossp-uuid' '--with-gnu-ld' '--with-tclconfig=/usr/lib/ tcl8.5' '--with-tkconfig=/usr/lib/tk8. 5' '--with-includes=/usr/include/ tcl8.5' '--with-system-tzdata=/usr/ share/zoneinfo' '--with-pgport=5432' 'CFLAGS=-g -O2 -g -Wall -O2 -fPIC' 'LDFLAGS=-Wl,-Bsymbolic- functions -Wl,--as-needed' 'build_alias=i486-linux-gnu' 'CPPFLAGS='
CC = gcc
CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include/tcl8.5
CFLAGS = -g -O2 -g -Wall -O2 -fPIC -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv -g
CFLAGS_SL = -fpic
LDFLAGS = -Wl,-Bsymbolic-functions -Wl,--as-needed -Wl,--as-needed
LDFLAGS_SL =
LIBS = -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lkrb5 -lcom_err -lgssapi_krb5 -lz -lreadline -lcrypt -ldl -lm
VERSION = PostgreSQL 8.4.8
----
Building (python setup.py install) this yields no warnings or errors.

The easy_install psycopg2 has the same error. If I attempt to install with static libraries, I can't even build it:
.....
running build_ext
Traceback (most recent call last):
File "setup.py", line 555, in <module>
ext_modules=ext)
File "/usr/lib/python2.6/distutils/ core.py", line 152, in setup
dist.run_commands()
File "/usr/lib/python2.6/distutils/ dist.py", line 975, in run_commands
self.run_command(cmd)
File "/usr/lib/python2.6/distutils/ dist.py", line 995, in run_command
cmd_obj.run()
File "/usr/lib/python2.6/distutils/ command/install.py", line 615, in run
self.run_command('build')
File "/usr/lib/python2.6/distutils/ cmd.py", line 333, in run_command
self.distribution.run_command( command)
File "/usr/lib/python2.6/distutils/ dist.py", line 995, in run_command
cmd_obj.run()
File "/usr/lib/python2.6/distutils/ command/build.py", line 135, in run
self.run_command(cmd_name)
File "/usr/lib/python2.6/distutils/ cmd.py", line 333, in run_command
self.distribution.run_command( command)
File "/usr/lib/python2.6/distutils/ dist.py", line 994, in run_command
cmd_obj.ensure_finalized()
File "/usr/lib/python2.6/distutils/ cmd.py", line 117, in ensure_finalized
self.finalize_options()
File "setup.py", line 367, in finalize_options
self.link_objects.append(
AttributeError: 'NoneType' object has no attribute 'append'

In case it matters:
# cat /proc/version
Linux version 2.6.32-32-generic-pae (buildd(at)roseapple) (gcc version 4.4.3 (Ubuntu 4.4.3-4ubuntu5) ) #62-Ubuntu SMP Wed Apr 20 22:10:33 UTC 2011
# python --version
Python 2.6.5
# python-config --libs
-lpthread -ldl -lutil -lm -lpython2.6

Any ideas?

Thanks in advance for any insight you can provide!

Matthew Robinson
Applications Engineer
Computing & Information Technology Services
University of Massachusetts Dartmouth

Claire T. Carney Library, Room 309
285 Old Westport Road
North Dartmouth, MA 02747
tel: 508.999.8119
fax: 508.999.8162
email/aim: mrobinson(at)umassd(dot)edu
----
CITS will never ask you for your password or other confidential information via email. Beware of phishing scams where email and/or malicious web sites try to trick users into entering their username and password. For more information about password security please visit: http://www.umassd.edu/cits/security/

Responses

Browse psycopg by date

  From Date Subject
Next Message Daniele Varrazzo 2011-10-06 15:04:15 Re: 2.4.2: undefined symbol: lo_truncate
Previous Message Raoul Duke 2011-10-06 12:36:39 Re: psycopg and gevent with pgbouncer