Re: Problems with genetic optimizer - Mailing list pgsql-general

> > The result of the query if I set the sequential search on is this:
>
> > convert=# select * from box_tmp where ebre &&
> > box('(470758.555,354028.145),(470758.525,354028.115)'::box);
> > pqReadData() -- backend closed the channel unexpectedly.
>
> Urk.  That's not supposed to happen.  There should be a core file
> left in your PGDATA/base/dbname/ directory --- can you provide a
> backtrace from that file using gdb?
>
>                         regards, tom lane

No, I'm sorry, but there is no core file. I tried to debug the query and
this are the relults:

/opt/local/DWH/bin/postmaster: ServerLoop:         handling reading 5
/opt/local/DWH/bin/postmaster: ServerLoop:         handling reading 5
/opt/local/DWH/bin/postmaster: ServerLoop:         handling writing 5
/opt/local/DWH/bin/postmaster: BackendStartup: pid 679 user postgres db
convert
socket 5
/opt/local/DWH/bin/postmaster child[679]: starting with
(/opt/local/DWH/bin/post
gres -d2 -v131072 -p convert )
FindExec: found "/opt/local/DWH/bin/postgres" using argv[0]
started: host=localhost user=postgres database=convert
InitPostgres
StartTransactionCommand
query: SELECT usesuper FROM pg_user WHERE usename = 'postgres'
ProcessQuery
CommitTransactionCommand
StartTransactionCommand
query: select * from box_tmp where ebre &&
('(470758.555,354028.145),(470758.525
,354028.115)'::box);
ProcessQuery
/opt/local/DWH/bin/postmaster: reaping dead processes...
/opt/local/DWH/bin/postmaster: CleanupProc: pid 679 exited with status
11
Server process (pid 679) exited with status 11 at Wed Oct 25 09:04:25
2000
Terminating any active server processes...
Server processes were terminated at Wed Oct 25 09:04:25 2000
Reinitializing shared memory and semaphores
shmem_exit(0)
binding ShmemCreate(key=52e325, size=1104896)
/opt/local/DWH/bin/postmaster: ServerLoop:         handling reading 5
/opt/local/DWH/bin/postmaster: ServerLoop:         handling reading 5
/opt/local/DWH/bin/postmaster: ServerLoop:         handling writing 5
The Data Base System is starting up
/opt/local/DWH/bin/postmaster: ServerLoop:         handling writing 5
DEBUG:  Data Base System is starting up at Wed Oct 25 09:04:25 2000
DEBUG:  Data Base System was interrupted being in production at Wed Oct
25 09:03
:52 2000
DEBUG:  Data Base System is in production state at Wed Oct 25 09:04:25
2000
proc_exit(0)
shmem_exit(0)
exit(0)
/opt/local/DWH/bin/postmaster: reaping dead processes...

Don't know if this is helping you
Peter


--
        Bezirksfinanzdirektion Muenchen
              Vermessungsabteilung
.........................................................
 Peter Keller        :  Tel: (+49) 089-2190-2594
 Vermessungsrat     :  Fax: (+49) 089-2190-2459
 Alexandrastr. 3    :  mailto:Peter.Keller@bvv.bayern.de
 80538 Muenchen        :  web: http://www.bayern.de/vermessung