issue in postgresql 9.1.3 in using arrow key in Solaris platform

Started by M Tarkeshwar Raoabout 11 years ago4 messages
#1M Tarkeshwar Rao
m.tarkeshwar.rao@ericsson.com

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

#2Adrian Klaver
adrian.klaver@aklaver.com
In reply to: M Tarkeshwar Rao (#1)
Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: M Tarkeshwar Rao (#1)
Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform

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.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

#4Josh Berkus
josh@agliodbs.com
In reply to: M Tarkeshwar Rao (#1)
Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform

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

--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance