Re: PG Seg Faults Performing a Query

From: Bill Thoen <bthoen(at)gisnet(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Andrej Ricnik-Bay <andrej(dot)groups(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: PG Seg Faults Performing a Query
Date: 2007-08-22 19:37:56
Message-ID: 46CC9094.7030302@gisnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

As you requested, here's what bt in gbd reports:
(gdb) bt
#0 0x0000003054264571 in fputc () from /lib64/libc.so.6
#1 0x000000000040dbd2 in print_aligned_text ()
#2 0x000000000040f10b in printTable ()
#3 0x000000000041020b in printQuery ()
#4 0x0000000000407906 in SendQuery ()
#5 0x0000000000409153 in MainLoop ()
#6 0x000000000040b16e in main ()

Please tell me what it means if you can and if I can fix this problem.

Thanks,
- Bill Thoen

Alvaro Herrera wrote:
> Martijn van Oosterhout escribió:
>
>
>> That said, it would be nice if it returned an error instead of
>> crashing.
>>
>
> In my opinion it isn't just a matter of "would be nice". It is a
> possible bug that should be investigated.
>
> A look at a stack trace from the crashing process would be the first
> place to start. In order to do that, please set "ulimit -c unlimited"
> and rerun the query under psql. That should produce a core file. Then
> run
> gdb psql core
> and inside gdb, execute "bt". Please send that output our way.
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-08-22 19:41:04 Re: Adapter update.
Previous Message Oleg Bartunov 2007-08-22 19:33:04 Re: How to switch off Snowball stemmer for tsearch2?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2007-08-22 22:16:22 Re: [COMMITTERS] pgsql: Add configure option --with-system-tzdata to use operating system
Previous Message Josh Berkus 2007-08-22 18:50:04 Power outage on Sun buildfarm machines