Thread: Segmentation fault

Segmentation fault

From
"Campbell, Lance"
Date:
Postgres 9.0.4
I installed from the visual linux installer
Redhat 6 newest updates

I keep getting the following message when logging into the command psql:

psql (9.0.4)
Type "help" for help.

Segmentation fault (core dumped)


It then kicks me out.  I uninstalled the application completely even deleting the data.  I then reinstalled using the visual install for Postgres 9.0.4.  I used all of the defaults.  Everything works fine through PGAdmin.  But I need to be able to do things from a command line.

Any help you could provide would be appreciated.

Thanks,

Lance

Re: Segmentation fault

From
"Kevin Grittner"
Date:
"Campbell, Lance" <lance@illinois.edu> wrote:
> Postgres 9.0.4
> I installed from the visual linux installer
> Redhat 6 newest updates
>
> I keep getting the following message when logging into the command
psql:
>
> psql (9.0.4)
> Type "help" for help.
>
> Segmentation fault (core dumped)
>
>
> It then kicks me out.  I uninstalled the application completely even

> deleting the data.  I then reinstalled using the visual install for
Postgres
> 9.0.4.  I used all of the defaults.  Everything works fine through
PGAdmin.

Did you check for a "~/.psqlrc" file?

-Kevin

Re: Segmentation fault

From
"Campbell, Lance"
Date:
I just checked and the below file does not exist.  I recreated the problem then checked again.  No such file.

Lance
________________________________________
From: Kevin Grittner [Kevin.Grittner@wicourts.gov]
Sent: Wednesday, August 31, 2011 11:59 AM
To: Campbell, Lance; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Segmentation fault

"Campbell, Lance" <lance@illinois.edu> wrote:
> Postgres 9.0.4
> I installed from the visual linux installer
> Redhat 6 newest updates
>
> I keep getting the following message when logging into the command
psql:
>
> psql (9.0.4)
> Type "help" for help.
>
> Segmentation fault (core dumped)
>
>
> It then kicks me out.  I uninstalled the application completely even

> deleting the data.  I then reinstalled using the visual install for
Postgres
> 9.0.4.  I used all of the defaults.  Everything works fine through
PGAdmin.

Did you check for a "~/.psqlrc" file?

-Kevin

Re: Segmentation fault

From
pasman pasmański
Date:
Which version of libreadline you have installed?

--
------------
pasman

Re: Segmentation fault

From
"Kevin Grittner"
Date:
"Campbell, Lance" <lance@illinois.edu> wrote:
> From: Kevin Grittner [Kevin.Grittner@wicourts.gov]

> Did you check for a "~/.psqlrc" file?

> I just checked and the below file does not exist.  I recreated the
> problem then checked again.  No such file.

Is anything showing in the server log?

Can you get a core file from psql?

-Kevin

Re: Segmentation fault

From
"Campbell, Lance"
Date:
Kevin,
The postgres log just shows lines like this:

2011-08-31 16:22:17 CDT LOG:  unexpected EOF on client connection

I don't know how to get a core dump.  What do I do?

Thanks,

Lance
________________________________________
From: Kevin Grittner [Kevin.Grittner@wicourts.gov]
Sent: Wednesday, August 31, 2011 1:49 PM
To: Campbell, Lance; pgsql-admin@postgresql.org
Subject: RE: [ADMIN] Segmentation fault

"Campbell, Lance" <lance@illinois.edu> wrote:
> From: Kevin Grittner [Kevin.Grittner@wicourts.gov]

> Did you check for a "~/.psqlrc" file?

> I just checked and the below file does not exist.  I recreated the
> problem then checked again.  No such file.

Is anything showing in the server log?

Can you get a core file from psql?

-Kevin

Re: Segmentation fault

From
"Campbell, Lance"
Date:
When I did the command:

yum info readline

I got the following back:

Installed Packages
Name        : readline
Arch        : i686
Version     : 6.0
Release     : 3.el6
Size        : 386 k
Repo        : installed
From repo   : rhel-x86_64-workstation-6
Summary     : A library for editing typed command lines
URL         : http://cnswww.cns.cwru.edu/php/chet/readline/rltop.html
License     : GPLv3+
Description : The Readline library provides a set of functions that allow users to
            : edit command lines. Both Emacs and vi editing modes are available. The
            : Readline library includes additional functions for maintaining a list
            : of previously-entered command lines for recalling or editing those
            : lines, and for performing csh-like history expansion on previous
            : commands.

Name        : readline
Arch        : x86_64
Version     : 6.0
Release     : 3.el6
Size        : 424 k
Repo        : installed
From repo   : anaconda-RedHatEnterpriseLinux-201009221801.x86_64
Summary     : A library for editing typed command lines
URL         : http://cnswww.cns.cwru.edu/php/chet/readline/rltop.html
License     : GPLv3+
Description : The Readline library provides a set of functions that allow users to
            : edit command lines. Both Emacs and vi editing modes are available. The
            : Readline library includes additional functions for maintaining a list
            : of previously-entered command lines for recalling or editing those
            : lines, and for performing csh-like history expansion on previous
            : commands.

Does that help at all?
________________________________________
From: pgsql-admin-owner@postgresql.org [pgsql-admin-owner@postgresql.org] on behalf of pasman pasmański
[pasman.p@gmail.com]
Sent: Wednesday, August 31, 2011 1:31 PM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Segmentation fault

Which version of libreadline you have installed?

--
------------
pasman

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

Re: Segmentation fault

From
"Kevin Grittner"
Date:
"Campbell, Lance" <lance@illinois.edu> wrote:
> From: Kevin Grittner [Kevin.Grittner@wicourts.gov]

>> Can you get a core file from psql?

> I don't know how to get a core dump.  What do I do?

If running this shows a limit (especially zero):

ulimit -c

then run this in your shell before running psql:

ulimit -c unlimited

Look for a core file in your current directory after the failure.
If you get one, try running:

gdb --core=YOURCOREFILENAME

Once gdb is running, type:

bt

and post the results.

-Kevin

Re: Segmentation fault

From
"Campbell, Lance"
Date:
Kevin,
That did it.  Doing the command ulimit -c unlimited worked!

Thanks,

Lance
________________________________________
From: Kevin Grittner [Kevin.Grittner@wicourts.gov]
Sent: Wednesday, August 31, 2011 4:42 PM
To: Campbell, Lance; pgsql-admin@postgresql.org
Subject: RE: [ADMIN] Segmentation fault

"Campbell, Lance" <lance@illinois.edu> wrote:
> From: Kevin Grittner [Kevin.Grittner@wicourts.gov]

>> Can you get a core file from psql?

> I don't know how to get a core dump.  What do I do?

If running this shows a limit (especially zero):

ulimit -c

then run this in your shell before running psql:

ulimit -c unlimited

Look for a core file in your current directory after the failure.
If you get one, try running:

gdb --core=YOURCOREFILENAME

Once gdb is running, type:

bt

and post the results.

-Kevin