Segfault in 8.0.2beta1

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Segfault in 8.0.2beta1
Date: 2005-04-01 18:07:21
Message-ID: 20050401180721.GA86744@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PostgreSQL 8.0.2beta1 (REL8_0_STABLE updated this morning)
FreeBSD 4.11-STABLE
gcc 2.95.4

While investigating somebody's question I ran the following query,
which caused the backend to segfault:

SELECT * FROM foo WHERE first_date <= now() AND last_date >= now();

I have to run so I can't put together a test case right now, but
here's the stack trace:

#0 convert_timevalue_to_scalar (value=1913, typid=1184) at selfuncs.c:2816
#1 0x81aa3e5 in convert_to_scalar (value=138003712, valuetypid=1184, scaledvalue=0xbfbfea50,
lobound=1913, hibound=1951, boundstypid=1082, scaledlobound=0xbfbfea58,
scaledhibound=0xbfbfea60) at selfuncs.c:2393
#2 0x81a8774 in scalarineqsel (root=0x8348228, operator=2361, isgt=1 '\001', vardata=0xbfbfeb00,
constval=138003712, consttype=1184) at selfuncs.c:547
#3 0x81a8ab1 in scalargtsel (fcinfo=0xbfbfeb50) at selfuncs.c:794
#4 0x81d4fbb in OidFunctionCall4 (functionId=104, arg1=137658920, arg2=2361, arg3=138001936,
arg4=0) at fmgr.c:1514
#5 0x81472af in restriction_selectivity (root=0x8348228, operator=2361, args=0x839be10,
varRelid=0) at plancat.c:427
#6 0x81344d1 in clause_selectivity (root=0x8348228, clause=0x8348958, varRelid=0,
jointype=JOIN_INNER) at clausesel.c:601
#7 0x8133eb0 in clauselist_selectivity (root=0x8348228, clauses=0x839c178, varRelid=0,
jointype=JOIN_INNER) at clausesel.c:116
#8 0x81355f3 in set_baserel_size_estimates (root=0x8348228, rel=0x8348800) at costsize.c:1491
#9 0x8133514 in set_plain_rel_pathlist (root=0x8348228, rel=0x8348800, rte=0x83487a0)
at allpaths.c:152
#10 0x81334de in set_base_rel_pathlists (root=0x8348228) at allpaths.c:135
#11 0x813341f in make_one_rel (root=0x8348228) at allpaths.c:79
#12 0x813d491 in query_planner (root=0x8348228, tlist=0x839b988, tuple_fraction=0,
cheapest_path=0xbfbfeeb8, sorted_path=0xbfbfeebc) at planmain.c:154
#13 0x813e176 in grouping_planner (parse=0x8348228, tuple_fraction=0) at planner.c:940
#14 0x813d8ca in subquery_planner (parse=0x8348228, tuple_fraction=0) at planner.c:327
#15 0x813d616 in planner (parse=0x8348228, isCursor=0, cursorOptions=0, boundParams=0x0)
at planner.c:130
#16 0x816f33f in pg_plan_query (querytree=0x8348228, boundParams=0x0) at postgres.c:647
#17 0x816f3e1 in pg_plan_queries (querytrees=0x839b8f8, boundParams=0x0, needSnapshot=0 '\000')
at postgres.c:715
#18 0x816f5ef in exec_simple_query (
query_string=0x8348018 "select * from foo where first_date <= now() and last_date >= now();")
at postgres.c:874
#19 0x8171b87 in PostgresMain (argc=4, argv=0x82c8258, username=0x82c8238 "mfuhr")
at postgres.c:3007
#20 0x814d429 in BackendRun (port=0x82de600) at postmaster.c:2839
#21 0x814cc6a in BackendStartup (port=0x82de600) at postmaster.c:2475
#22 0x814b1f6 in ServerLoop () at postmaster.c:1222
#23 0x814abce in PostmasterMain (argc=3, argv=0xbfbffc88) at postmaster.c:918
#24 0x811ea8d in main (argc=3, argv=0xbfbffc88) at main.c:268

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-04-01 19:46:10 Re: Segfault in 8.0.2beta1
Previous Message Karl O. Pinc 2005-04-01 16:24:31 On line manual pages need easy access to TOC