pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSegmentation fault
11+ messages / 5 participants
[nested] [flat]
* Segmentation fault
@ 2011-08-31 15:17 Campbell, Lance <lance@illinois.edu>
0 siblings, 1 reply; 11+ messages in thread
From: Campbell, Lance @ 2011-08-31 15:17 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Segmentation fault
@ 2011-08-31 16:59 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Campbell, Lance <lance@illinois.edu>
0 siblings, 1 reply; 11+ messages in thread
From: Kevin Grittner @ 2011-08-31 16:59 UTC (permalink / raw)
To: Lance Campbell <lance@illinois.edu>; pgsql-admin
"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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Segmentation fault
@ 2011-08-31 17:40 Campbell, Lance <lance@illinois.edu>
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 2 replies; 11+ messages in thread
From: Campbell, Lance @ 2011-08-31 17:40 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; pgsql-admin
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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Segmentation fault
@ 2011-08-31 18:31 =?ISO-8859-2?Q?pasman_pasma=F1ski?= <pasman.p@gmail.com>
parent: Campbell, Lance <lance@illinois.edu>
1 sibling, 1 reply; 11+ messages in thread
From: pasman pasmański @ 2011-08-31 18:31 UTC (permalink / raw)
To: pgsql-admin
Which version of libreadline you have installed?
--
------------
pasman
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Segmentation fault
@ 2011-08-31 18:49 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Campbell, Lance <lance@illinois.edu>
1 sibling, 1 reply; 11+ messages in thread
From: Kevin Grittner @ 2011-08-31 18:49 UTC (permalink / raw)
To: Lance Campbell <lance@illinois.edu>; pgsql-admin
"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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Segmentation fault
@ 2011-08-31 21:23 Campbell, Lance <lance@illinois.edu>
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 1 reply; 11+ messages in thread
From: Campbell, Lance @ 2011-08-31 21:23 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; pgsql-admin
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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Segmentation fault
@ 2011-08-31 21:30 Campbell, Lance <lance@illinois.edu>
parent: =?ISO-8859-2?Q?pasman_pasma=F1ski?= <pasman.p@gmail.com>
0 siblings, 0 replies; 11+ messages in thread
From: Campbell, Lance @ 2011-08-31 21:30 UTC (permalink / raw)
To: pasman pasmański <pasman.p@gmail.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Segmentation fault
@ 2011-08-31 21:42 Kevin Grittner <Kevin.Grittner@wicourts.gov>
parent: Campbell, Lance <lance@illinois.edu>
0 siblings, 1 reply; 11+ messages in thread
From: Kevin Grittner @ 2011-08-31 21:42 UTC (permalink / raw)
To: Lance Campbell <lance@illinois.edu>; pgsql-admin
"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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Segmentation fault
@ 2011-09-01 13:42 Campbell, Lance <lance@illinois.edu>
parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
0 siblings, 0 replies; 11+ messages in thread
From: Campbell, Lance @ 2011-09-01 13:42 UTC (permalink / raw)
To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; pgsql-admin
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
^ permalink raw reply [nested|flat] 11+ messages in thread
* Segmentation fault
@ 2022-07-26 13:51 abbas alizadeh <ramkly@yahoo.com>
0 siblings, 1 reply; 11+ messages in thread
From: abbas alizadeh @ 2022-07-26 13:51 UTC (permalink / raw)
To: pgsql-admin <pgsql-admin@lists.postgresql.org>
Hi all.
I got “terminated by signal 11, segmentation falt” error in my database.
I’m using pg v13.7
Query causing that error: “set client_encoding= utf-8”
There is no core file in data folder.
Any idea how can I find the root case for this error?
Command execute for 1000times, but only some times cuz this error
Regards
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: Segmentation fault
@ 2022-07-26 15:40 Tom Lane <tgl@sss.pgh.pa.us>
parent: abbas alizadeh <ramkly@yahoo.com>
0 siblings, 0 replies; 11+ messages in thread
From: Tom Lane @ 2022-07-26 15:40 UTC (permalink / raw)
To: abbas alizadeh <ramkly@yahoo.com>; +Cc: pgsql-admin <pgsql-admin@lists.postgresql.org>
abbas alizadeh <ramkly@yahoo.com> writes:
> I got “terminated by signal 11, segmentation falt” error in my database.
> I’m using pg v13.7
> Query causing that error: “set client_encoding= utf-8”
Hmm, that is pretty well-tested code.
> There is no core file in data folder.
Maybe you are starting the server under "ulimit -c 0"? See also
the advice at
https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
> Any idea how can I find the root case for this error?
With only this amount of information, there's not much to be done.
If you could get a stack trace maybe we'd have some ideas.
regards, tom lane
^ permalink raw reply [nested|flat] 11+ messages in thread
end of thread, other threads:[~2022-07-26 15:40 UTC | newest]
Thread overview: 11+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-08-31 15:17 Segmentation fault Campbell, Lance <lance@illinois.edu>
2011-08-31 16:59 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-08-31 17:40 ` Campbell, Lance <lance@illinois.edu>
2011-08-31 18:31 ` =?ISO-8859-2?Q?pasman_pasma=F1ski?= <pasman.p@gmail.com>
2011-08-31 21:30 ` Campbell, Lance <lance@illinois.edu>
2011-08-31 18:49 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-08-31 21:23 ` Campbell, Lance <lance@illinois.edu>
2011-08-31 21:42 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2011-09-01 13:42 ` Campbell, Lance <lance@illinois.edu>
2022-07-26 13:51 Segmentation fault abbas alizadeh <ramkly@yahoo.com>
2022-07-26 15:40 ` Tom Lane <tgl@sss.pgh.pa.us>
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