{"action":"created","issue":{"url":"https://api.github.com/repos/psycopg/psycopg2/issues/426","repository_url":"https://api.github.com/repos/psycopg/psycopg2","labels_url":"https://api.github.com/repos/psycopg/psycopg2/issues/426/labels{/name}","comments_url":"https://api.github.com/repos/psycopg/psycopg2/issues/426/comments","events_url":"https://api.github.com/repos/psycopg/psycopg2/issues/426/events","html_url":"https://github.com/psycopg/psycopg2/issues/426","id":152499836,"number":426,"title":"Exception undefined symbol lo_truncate64. But symbol is defined and _psycopg.so linked correctly","user":{"login":"do3cc","id":147512,"avatar_url":"https://avatars.githubusercontent.com/u/147512?v=3","gravatar_id":"","url":"https://api.github.com/users/do3cc","html_url":"https://github.com/do3cc","followers_url":"https://api.github.com/users/do3cc/followers","following_url":"https://api.github.com/users/do3cc/following{/other_user}","gists_url":"https://api.github.com/users/do3cc/gists{/gist_id}","starred_url":"https://api.github.com/users/do3cc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/do3cc/subscriptions","organizations_url":"https://api.github.com/users/do3cc/orgs","repos_url":"https://api.github.com/users/do3cc/repos","events_url":"https://api.github.com/users/do3cc/events{/privacy}","received_events_url":"https://api.github.com/users/do3cc/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-05-02T08:08:46Z","updated_at":"2016-12-27T00:44:45Z","closed_at":"2016-12-27T00:44:45Z","body":"This is happening on centos 6.7\n\npgsql is installed in version\n\n```\npostgresql94-devel.x86_64            9.4.7-1PGDG.rhel6                 @pgdg94\n```\n\npgdg94 is a reference to postgresql owns yum source repos.\n\npgconfig output:\n\n```\nBINDIR = /usr/pgsql-9.4/bin\nDOCDIR = /usr/pgsql-9.4/doc\nHTMLDIR = /usr/pgsql-9.4/doc/html\nINCLUDEDIR = /usr/pgsql-9.4/include\nPKGINCLUDEDIR = /usr/pgsql-9.4/include\nINCLUDEDIR-SERVER = /usr/pgsql-9.4/include/server\nLIBDIR = /usr/pgsql-9.4/lib\nPKGLIBDIR = /usr/pgsql-9.4/lib\nLOCALEDIR = /usr/pgsql-9.4/share/locale\nMANDIR = /usr/pgsql-9.4/share/man\nSHAREDIR = /usr/pgsql-9.4/share\nSYSCONFDIR = /etc/sysconfig/pgsql\nPGXS = /usr/pgsql-9.4/lib/pgxs/src/makefiles/pgxs.mk\nCONFIGURE = '--disable-rpath' '--prefix=/usr/pgsql-9.4' '--includedir=/usr/pgsql-9.4/include' '--mandir=/usr/pgsql-9.4/share/man' '--datadir=/usr/pgsql-9.4/share' '--with-perl' '--with-python' '--with-tcl' '--with-tclconfig=/usr/lib64' '--with-openssl' '--with-pam' '--with-gssapi' '--with-includes=/usr/include' '--with-libraries=/usr/lib64' '--enable-nls' '--with-uuid=e2fs' '--with-libxml' '--with-libxslt' '--with-ldap' '--with-system-tzdata=/usr/share/zoneinfo' '--sysconfdir=/etc/sysconfig/pgsql' '--docdir=/usr/pgsql-9.4/doc' '--htmldir=/usr/pgsql-9.4/doc/html' 'CFLAGS=-O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -I/usr/include/et' 'CPPFLAGS= -I/usr/include/et'\nCC = gcc\nCPPFLAGS = -I/usr/include/et -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include\nCFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -I/usr/include/et\nCFLAGS_SL = -fpic\nLDFLAGS = -L../../../src/common -L/usr/lib64 -Wl,--as-needed\nLDFLAGS_EX =\nLDFLAGS_SL =\nLIBS = -lpgcommon -lpgport -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lrt -lcrypt -ldl -lm\nVERSION = PostgreSQL 9.4.7\n```\n\nI run buildout on the very machine, that downloads the psycopg2 egg and compiles it.\nThen I try to start the app using psycpg2 2.6.1 results in the following error:\n\n```\nError was: /home/sentry/sentry_psql/eggs/psycopg2-2.6.1-py2.7-linux-x86_64.egg/psycopg2/_psycopg.so: undefined symbol: lo_truncate64\n```\n\nThe full traceback I got was misleading, it seemed to catch the above exception and then believes that it meant, I selected an unknown database type.\n\n```\n$ ldd /home/sentry/sentry_psql/eggs/psycopg2-2.6.1-py2.7-linux-x86_64.egg/psycopg2/_psycopg.so | grep libpq\n    libpq.so.5 => /usr/pgsql-9.4/lib/libpq.so.5 (0x00007f5d5ee4d000)\n$ readelf -Ws /usr/pgsql-9.4/lib/libpq.so.5 | grep lo_truncate\n   181: 00000000000171a0   287 FUNC    GLOBAL DEFAULT   11 lo_truncate64\n   196: 00000000000172c0   297 FUNC    GLOBAL DEFAULT   11 lo_truncate\n```\n\nFrom my understanding, the right so psycopg2 package with the right so file is chosen. This is linked to the right libpq.so, whihc contains lo_truncate64\nStill, psycopg2 thinks otherwise and bails out.\n\nShould I look for something else maybe?\n"},"comment":{"url":"https://api.github.com/repos/psycopg/psycopg2/issues/comments/269252355","html_url":"https://github.com/psycopg/psycopg2/issues/426#issuecomment-269252355","issue_url":"https://api.github.com/repos/psycopg/psycopg2/issues/426","id":269252355,"user":{"login":"dvarrazzo","id":199429,"avatar_url":"https://avatars.githubusercontent.com/u/199429?v=3","gravatar_id":"","url":"https://api.github.com/users/dvarrazzo","html_url":"https://github.com/dvarrazzo","followers_url":"https://api.github.com/users/dvarrazzo/followers","following_url":"https://api.github.com/users/dvarrazzo/following{/other_user}","gists_url":"https://api.github.com/users/dvarrazzo/gists{/gist_id}","starred_url":"https://api.github.com/users/dvarrazzo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/dvarrazzo/subscriptions","organizations_url":"https://api.github.com/users/dvarrazzo/orgs","repos_url":"https://api.github.com/users/dvarrazzo/repos","events_url":"https://api.github.com/users/dvarrazzo/events{/privacy}","received_events_url":"https://api.github.com/users/dvarrazzo/received_events","type":"User","site_admin":false},"created_at":"2016-12-27T00:44:45Z","updated_at":"2016-12-27T00:44:45Z","body":"Closing for lack of info"}}
{"actor":{"display_login":"dvarrazzo"}}