Undefined symbol error - psql CLI client

Hi

st 19. 12. 2018 v 9:44 odesílatel Srimal | PickMe <srimal@pickme.lk> napsal:

Hi,

psql returns the following error.

/usr/lib/postgresql/11/bin/psql: symbol lookup error:
/usr/lib/postgresql/11/bin/psql: undefined symbol:
PQsetErrorContextVisibility

Maybe you have a old libpq library. Do you have installed some older
Postgres client on your comp?

Hi,

The issue came after I upgrade Postgres from version 10 to 11. That may be
the reason.

On Wed, Dec 19, 2018 at 4:19 PM Pavel Stehule <pavel.stehule@gmail.com>
wrote:

Hi

st 19. 12. 2018 v 9:44 odesílatel Srimal | PickMe <srimal@pickme.lk>
napsal:

Hi,

psql returns the following error.

/usr/lib/postgresql/11/bin/psql: symbol lookup error:
/usr/lib/postgresql/11/bin/psql: undefined symbol:
PQsetErrorContextVisibility

Maybe you have a old libpq library. Do you have installed some older
Postgres client on your comp?

Operating system : Ubuntu 18.04LTS
PostgreSQL version : 11.1

Thanks.

--
*Regards,*

*Srimal*

--
*Regards,*

*Srimal*

st 19. 12. 2018 v 12:22 odesílatel Srimal | PickMe <srimal@pickme.lk>
napsal:

Hi,

The issue came after I upgrade Postgres from version 10 to 11. That may be
the reason.

maybe libpq was not updated, or there there are more libpq and older has
higher priority

I have these packages installed.

[image: image.png]

On Wed, Dec 19, 2018 at 4:54 PM Pavel Stehule <pavel.stehule@gmail.com>
wrote:

st 19. 12. 2018 v 12:22 odesílatel Srimal | PickMe <srimal@pickme.lk>
napsal:

Hi,

The issue came after I upgrade Postgres from version 10 to 11. That may
be the reason.

maybe libpq was not updated, or there there are more libpq and older has
higher priority

On Wed, Dec 19, 2018 at 4:19 PM Pavel Stehule <pavel.stehule@gmail.com>
wrote:

Hi

st 19. 12. 2018 v 9:44 odesílatel Srimal | PickMe <srimal@pickme.lk>
napsal:

Hi,

psql returns the following error.

/usr/lib/postgresql/11/bin/psql: symbol lookup error:
/usr/lib/postgresql/11/bin/psql: undefined symbol:
PQsetErrorContextVisibility

Maybe you have a old libpq library. Do you have installed some older
Postgres client on your comp?

Operating system : Ubuntu 18.04LTS
PostgreSQL version : 11.1

Thanks.

--
*Regards,*

*Srimal*

--
*Regards,*

*Srimal*

--
*Regards,*

*Srimal*

st 19. 12. 2018 v 12:33 odesílatel Srimal | PickMe <srimal@pickme.lk>
napsal:

I have these packages installed.

[image: image.png]

On Wed, Dec 19, 2018 at 4:54 PM Pavel Stehule <pavel.stehule@gmail.com>
wrote:

st 19. 12. 2018 v 12:22 odesílatel Srimal | PickMe <srimal@pickme.lk>
napsal:

Hi,

The issue came after I upgrade Postgres from version 10 to 11. That may
be the reason.

maybe libpq was not updated, or there there are more libpq and older has
higher priority

maybe there are broken dependency between releases, or some other

On 2018-Dec-19, Pavel Stehule wrote:

st 19. 12. 2018 v 12:33 odes�latel Srimal | PickMe <srimal@pickme.lk>
napsal:

maybe there are broken dependency between releases, or some other

/usr/lib/postgresql/11/bin/psql: symbol lookup error:
/usr/lib/postgresql/11/bin/psql: undefined symbol:
PQsetErrorContextVisibility

I bet there is another libpq that is being picked up.
PQsetErrorContextVisibility was added in 9.6. Maybe
ldd /usr/lib/postgresql/11/bin/psql
would give a clue.

--
�lvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Hi,

Yes, it was using an incorrect libpq version which comes with Pipelinedb
(See the attached screenshot). I have uninstalled Pipelinedb since I'm not
using that anymore. The issue is fixed now.

[image: image.png]

Thank you all for the great support.

On Wed, Dec 19, 2018 at 7:51 PM Alvaro Herrera <alvherre@2ndquadrant.com>
wrote:

On 2018-Dec-19, Pavel Stehule wrote:

st 19. 12. 2018 v 12:33 odesílatel Srimal | PickMe <srimal@pickme.lk>
napsal:

maybe there are broken dependency between releases, or some other

/usr/lib/postgresql/11/bin/psql: symbol lookup error:
/usr/lib/postgresql/11/bin/psql: undefined symbol:
PQsetErrorContextVisibility

I bet there is another libpq that is being picked up.
PQsetErrorContextVisibility was added in 9.6. Maybe
ldd /usr/lib/postgresql/11/bin/psql
would give a clue.

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

--
*Regards,*

*Srimal*