Skip site navigation (1) Skip section navigation (2)

backend crashes under 6.4beta

From: Marcus Mascari <mascarim(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: backend crashes under 6.4beta
Date: 1998-09-22 02:38:35
Message-ID: 19980922023835.2532.rocketmail@send1c.yahoomail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
I do not know if this is the correct place to post this
message but here goes...
I read the previous postings regarding the query 
optimizer crashing with regards to ANDS and ORS and 
apparently it is this same code which will crash the
following query:

select supply, location, chgdate from charges where
supply in ('111111', '222222') and location in ('4 EAST') 

because the optimizer is reducing the location in ('4 EAST') to
location = '4 EAST', and then hitting the 
bug in the optimizer.  Therefore, I have to always 
generate queries as follows:

select supply, location, chgdate from charges where
supply in ('111111', '222222') and location in 
('4 EAST', 'garbage to trick postgres')

and I receive the expected results.

Here is the backtrace:

Core was generated by `/usr/local/pgsql/bin/postgres localhost
mmsadmin m'.
Program terminated with signal 11, Segmentation fault.
Reading symbols from /lib/libdl.so.1...done.
Reading symbols from /lib/libm.so.5...done.
Reading symbols from /lib/libtermcap.so.2...done.
Reading symbols from /lib/libncurses.so.3.0...done.
Reading symbols from /lib/libc.so.5...done.
Reading symbols from /lib/ld-linux.so.1...done.
#0  0x80af4e0 in equal_path_path_ordering ()
(gdb) bt
#0  0x80af4e0 in equal_path_path_ordering ()
#1  0x80af6d3 in better_path ()
#2  0x80af648 in add_pathlist ()
#3  0x80a5618 in find_rel_paths ()
#4  0x80a5583 in find_paths ()
#5  0x80aa19d in subplanner ()
#6  0x80aa0d4 in query_planner ()
#7  0x80aa71f in union_planner ()
#8  0x80aa5d1 in planner ()
#9  0x80d5fc0 in pg_parse_and_plan ()
#10 0x80d60eb in pg_exec_query_dest ()
#11 0x80d60ac in pg_exec_query ()
#12 0x80d7114 in PostgresMain ()
#13 0x80c3580 in DoBackend ()
#14 0x80c30ce in BackendStartup ()
#15 0x80c2856 in ServerLoop ()
#16 0x80c2468 in PostmasterMain ()
#17 0x809bec0 in main ()
#18 0x80606fe in _start ()

I hope this helps.  I love postgres except for this 
single bug which rears its ugly head on one-to-many 
an occassion.

Marcus Mascari







_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com


pgsql-hackers by date

Next:From: Thomas G. LockhartDate: 1998-09-22 03:55:48
Subject: Re: NOT boolfield kills backend
Previous:From: The Hermit HackerDate: 1998-09-22 00:50:26
Subject: Re: [HACKERS] regress[ion].* files?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group