pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
issue in postgresql 9.1.3 in using arrow key in Solaris platform
4+ messages / 4 participants
[nested] [flat]

* issue in postgresql 9.1.3 in using arrow key in Solaris platform
@ 2014-11-26 10:16 M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
  2014-11-26 14:37 ` Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform Adrian Klaver <adrian.klaver@aklaver.com>
  2014-11-26 15:27 ` Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform Tom Lane <tgl@sss.pgh.pa.us>
  2014-12-04 19:10 ` Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform Josh Berkus <josh@agliodbs.com>
  0 siblings, 3 replies; 4+ messages in thread

From: M Tarkeshwar Rao @ 2014-11-26 10:16 UTC (permalink / raw)
  To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>; pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>; pgsql-performance

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform
  2014-11-26 10:16 issue in postgresql 9.1.3 in using arrow key in Solaris platform M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
@ 2014-11-26 14:37 ` Adrian Klaver <adrian.klaver@aklaver.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Adrian Klaver @ 2014-11-26 14:37 UTC (permalink / raw)
  To: M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>; pgsql-general@postgresql.org <pgsql-general@postgresql.org>; pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>; pgsql-performance

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform
  2014-11-26 10:16 issue in postgresql 9.1.3 in using arrow key in Solaris platform M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
@ 2014-11-26 15:27 ` Tom Lane <tgl@sss.pgh.pa.us>
  2 siblings, 0 replies; 4+ messages in thread

From: Tom Lane @ 2014-11-26 15:27 UTC (permalink / raw)
  To: M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>; +Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: issue in postgresql 9.1.3 in using arrow key in Solaris platform
  2014-11-26 10:16 issue in postgresql 9.1.3 in using arrow key in Solaris platform M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
@ 2014-12-04 19:10 ` Josh Berkus <josh@agliodbs.com>
  2 siblings, 0 replies; 4+ messages in thread

From: Josh Berkus @ 2014-12-04 19:10 UTC (permalink / raw)
  To: M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>; pgsql-performance

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



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2014-12-04 19:10 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-11-26 10:16 issue in postgresql 9.1.3 in using arrow key in Solaris platform M Tarkeshwar Rao <m.tarkeshwar.rao@ericsson.com>
2014-11-26 14:37 ` Adrian Klaver <adrian.klaver@aklaver.com>
2014-11-26 15:27 ` Tom Lane <tgl@sss.pgh.pa.us>
2014-12-04 19:10 ` Josh Berkus <josh@agliodbs.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox