Re: server closed connection on a select query

From: Larry Rosenman <ler(at)lerctr(dot)org>
To: Guillaume Lelarge <guillaume(dot)lelarge(at)gmail(dot)com>
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: server closed connection on a select query
Date: 2005-11-22 23:41:11
Message-ID: 3379B134-BF10-4D61-9320-3CF2EC34BAF4@lerctr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Sorry for the top post. If you can get a UDK license, that will work
better.

LER

On Nov 22, 2005, at 12:02 PM, Guillaume Lelarge wrote:

> Sorry for answering this late.
>
> 2005/11/16, Larry Rosenman <ler(at)lerctr(dot)org>:
>> Bruce Momjian wrote:
>>> The SCO compiler is so buggy (and for so many years) I see no reason
>>> to even look at a bug report from someone using it.
>>>
>>
>> I **REALLY** wish you would STOP saying that, Bruce. The current
>> OpenServer
>> Compiler (UDK), is the same as on UnixWare, and is **MUCH** better
>> than the
>> Old SVR3 compiler.
>>
>> We **REALLY** **SHOULD** look at it.
>>
>> I'll take the bug report directly to SCO if I get enough detail.
>>
>
> I was using cc, exactly "SCO UNIX Development System Release 5.1.2A
> 27Jul00". Last week, I tried with "UX:i386cc: INFO: SCO UNIX
> Development System Release 5.2.0A 07Oct05" but I had the same
> results. I think I'm doing something wrong but I don't know what.
>
> I launched postgres in standalone mode and a core file is created. I
> used gdb on it to see the backtrace :
> (gdb) bt
> #0 0x081bf5fd in booltestsel ()
> #1 0x08141125 in clause_selectivity ()
> #2 0x081409d2 in clauselist_selectivity ()
> #3 0x0814295b in set_baserel_size_estimates ()
> #4 0x0813ff42 in set_plain_rel_pathlist ()
> #5 0x0813ff12 in set_base_rel_pathlists ()
> #6 0x0813fe1d in make_one_rel ()
> #7 0x0814b455 in query_planner ()
> #8 0x0814bfa0 in grouping_planner ()
> #9 0x0814ba11 in subquery_planner ()
> #10 0x0814b6c7 in planner ()
> #11 0x08181e07 in pg_plan_query ()
> #12 0x08181ea0 in pg_plan_queries ()
> #13 0x081820ce in exec_simple_query ()
> #14 0x081849dd in PostgresMain ()
> #15 0x08161d92 in BackendRun ()
> #16 0x081616c9 in BackendStartup ()
> #17 0x0815fba8 in ServerLoop ()
> #18 0x0815f67c in PostmasterMain ()
> #19 0x08127d91 in main ()
> #20 0x08074d1a in _start ()
>

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 214-351-4152 E-Mail: ler(at)lerctr(dot)org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jim C. Nasby 2005-11-23 00:07:03 Re: Improving count(*)
Previous Message Petr Jelinek 2005-11-22 23:24:24 Re: MERGE vs REPLACE