Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iSLyK-0001GV-4T for pgsql-bugs@arkaria.postgresql.org; Wed, 06 Nov 2019 14:07:44 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iSLyI-0003AT-Qe for pgsql-bugs@arkaria.postgresql.org; Wed, 06 Nov 2019 14:07:42 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iSLyI-00036H-Dl for pgsql-bugs@lists.postgresql.org; Wed, 06 Nov 2019 14:07:42 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1iSLy7-00088C-Q4 for pgsql-bugs@lists.postgresql.org; Wed, 06 Nov 2019 14:07:41 +0000 Received: from bruce by momjian.us with local (Exim 4.92) (envelope-from ) id 1iSLy6-0007HX-Pg; Wed, 06 Nov 2019 09:07:30 -0500 Date: Wed, 6 Nov 2019 09:07:30 -0500 From: Bruce Momjian To: git@jjerphan.xyz, pgsql-bugs@lists.postgresql.org Cc: Devrim Gunduz Subject: Re: BUG #16085: Potential missing version information available for /usr/pgsql-12/lib/libpq.so.5 Message-ID: <20191106140730.GC1843@momjian.us> References: <16085-99b864314bf49697@postgresql.org> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <16085-99b864314bf49697@postgresql.org> User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Devrim, can you comment on this? I am confused by this report. --------------------------------------------------------------------------- On Tue, Oct 29, 2019 at 07:12:01AM +0000, PG Bug reporting form wrote: > The following bug has been logged on the website: > > Bug reference: 16085 > Logged by: Julien Jerphanion > Email address: git@jjerphan.xyz > PostgreSQL version: 12.0 > Operating system: Fedora 30 > Description: > > Hello, > > I add linking problem when when trying to compile a project that is relying > on libpq, namely [ttk](https://github.com/topology-tool-kit/ttk). > > Here is a similar stack trace I got when compiling this project > ``` > /usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to > `PQfname@RHPG_9.6' > /usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to > `PQresStatus@RHPG_9.6' > /usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to > `PQftype@RHPG_9.6' > /usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to > `PQexec@RHPG_9.6' > /usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to > `PQfformat@RHPG_9.6' > /usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to > `PQclear@RHPG_9.6' > /usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to > `PQntuples@RHPG_9.6' > /usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to > `PQstatus@RHPG_9.6' > /usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to > `PQconnectdb@RHPG_9.6' > /usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to > `PQescapeStringConn@RHPG_9.6' > /usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to > `PQgetvalue@RHPG_9.6' > /usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to > `PQgetisnull@RHPG_9.6' > /usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to > `PQresultStatus@RHPG_9.6' > /usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to > `PQfinish@RHPG_9.6' > /usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to > `PQerrorMessage@RHPG_9.6' > /usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to > `PQnfields@RHPG_9.6' > /usr/bin/ld: /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: undefined reference to > `PQresultErrorMessage@RHPG_9.6' > ``` > > It seems that this was rather due to missing a library version within > `libpg`: > ```bash > $ ldd /usr/lib64/vtk/libvtkIOPostgreSQL.so.1 > /usr/lib64/vtk/libvtkIOPostgreSQL.so.1: /usr/pgsql-12/lib/libpq.so.5: no > version information available (required by > /usr/lib64/vtk/libvtkIOPostgreSQL.so.1) > # ... > libpq.so.5 => /usr/pgsql-12/lib/libpq.so.5 (0x00007fa9b39c0000) > # ... > ``` > > On my machine, this latter version was provided by several packages from > PostGreSQL 12, namely: > ```bash > $ dnf provides /usr/pgsql-12/lib/libpq.so > postgresql12-devel-12rc1-2PGDG.f30.x86_64 : PostgreSQL development header > files and libraries > Repo : pgdg12 > Matched from: > Filename : /usr/pgsql-12/lib/libpq.so > > postgresql12-devel-12.0-1PGDG.f30.x86_64 : PostgreSQL development header > files and libraries > Repo : @System > Matched from: > Filename : /usr/pgsql-12/lib/libpq.so > > postgresql12-devel-12.0-1PGDG.f30.x86_64 : PostgreSQL development header > files and libraries > Repo : pgdg12 > Matched from: > Filename : /usr/pgsql-12/lib/libpq.so > > # ... > ``` > I uninstalled them and it resolves my problem: > ``` > $ sudo dnf erase postgresql12-devel-12.0-1PGDG.f30.x86_64 > $ sudo dnf erase postgresql11-libs-11.5-1PGDG.f30.x86_64 > $ sudo dnf erase postgresql12-libs-12.0-1PGDG.f30.x86_64 > # ... > ``` > > I think that this is correlated to the release of PostGreSQL 12. > > Let me know if you need more information on this problem. > > Best regards, > Julien Jerphanion (@jjerphan) > -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Ancient Roman grave inscription +