Thread: 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

From
M Tarkeshwar Rao
Date:

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: [GENERAL] issue in postgresql 9.1.3 in using arrow key in Solaris platform

From
Adrian Klaver
Date:
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

From
Josh Berkus
Date:
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?*

Mr. Rao:

1) Please do not cross-post to multiple mailing lists.  In the future,
this may cause you to be banned from the PostgreSQL mailing lists.

2) PostgreSQL 9.1.3 is 11 patch releases behind and contains multiple
published security holes.

3) Sounds like there's a bug in the readline or libedit libraries for
your platform.  How did you build PostgreSQL?

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com