Обсуждение: issue in postgresql 9.1.3 in using arrow key in Solaris platform

Поиск
Список
Период
Сортировка

issue in postgresql 9.1.3 in using arrow key in Solaris platform

От
M Tarkeshwar Rao
Дата:

Hi all,

 

We are facing following issue in postgresql 9.1.3 in using arrow key in Solaris platform.

Can you please help us to resolve it or any new release has fix for this or any workaround for this?

 

issue: psql client generates a core when up arrow is used twice.

============

Platfrom: Solaris X86

 

Steps to  reproduce:

=====================

1. Login to any postgres database

2. execute any quer say  "\list"

3. press up arrow twice.

4. segmentation fault occurs and core is generated. Also session is terminated.

 

PLease find example below

 

# ./psql -U super -d mgrdb

Password for user super:

psql (9.1.3)

Type "help" for help.

 

mgrdb=# \l

                                  List of databases

   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileg

es

-----------+----------+----------+-------------+-------------+------------------

-----

mgrdb     | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |

postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |

template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres

    +

           |          |          |             |             | postgres=CTc/post

gres

template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres

    +

           |          |          |             |             | postgres=CTc/post

gres

(4 rows)

 

mgrdb=#

mgrdb=# select count(1) from operator_msm;Segmentation Fault (core dumped)

 

Regards

Tarkeshwar

Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform

От
Adrian Klaver
Дата:
On 11/26/2014 02:16 AM, M Tarkeshwar Rao wrote:
> Hi all,
>
> We are facing following issue in postgresql 9.1.3 in using arrow key in
> Solaris platform.
>
> *Can you please help us to resolve it or any new release has fix for
> this or any workaround for this?*

Would seem to me to be an interaction between Postgres and readline. Not
sure exactly what, but some information would be helpful for those that
might know:

1) What version of Solaris?

2) How was Postgres installed and from what source?

3) What version of readline is installed?

4) Are you using a psql client that is the same version as the server?


>
> issue: psql client generates a core when up arrow is used twice.
>

>
> Regards
>
> Tarkeshwar
>


--
Adrian Klaver
adrian.klaver@aklaver.com

Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform

От
Tom Lane
Дата:
M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com> writes:
> We are facing following issue in postgresql 9.1.3 in using arrow key in Solaris platform.
> Can you please help us to resolve it or any new release has fix for this or any workaround for this?
> issue: psql client generates a core when up arrow is used twice.

Almost certainly, this is not psql's fault, but rather a bug in the
readline or libedit library it's using for command history.

If you're using libedit, I can't say that I'm astonished, as we've
seen a depressingly large number of bugs reported in various versions
of libedit.

In any case, try to get a newer version of that library; or if you've
linked psql to libedit, consider rebuilding against libreadline.

            regards, tom lane

PS: this was cross-posted inappropriately.  I've trimmed the cc
list to just pgsql-general.