Re: server closed connection on a select query

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@lerctr.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@lerctr.org
US Mail: 3535 Gaspar Drive, Dallas, TX 75220-3611