Обсуждение: Undefined symbol error - psql CLI client
I have these packages installed.
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 priorityOn Wed, Dec 19, 2018 at 4:19 PM Pavel Stehule <pavel.stehule@gmail.com> wrote:Hist 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: PQsetErrorContextVisibilityMaybe you have a old libpq library. Do you have installed some older Postgres client on your comp?Operating system : Ubuntu 18.04LTSPostgreSQL version : 11.1Thanks.
--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.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 Wed, Dec 19, 2018 at 4:19 PM Pavel Stehule <pavel.stehule@gmail.com> wrote:Hist 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: PQsetErrorContextVisibilityMaybe you have a old libpq library. Do you have installed some older Postgres client on your comp?Operating system : Ubuntu 18.04LTSPostgreSQL version : 11.1Thanks.
--Regards,Srimal
--Regards,Srimal
--Regards,Srimal
Вложения
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.
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