Thread: issue in postgresql 9.1.3 in using arrow key in Solaris platform
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
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
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.