Re: BUG #7667: Segmentation fault

I can confirm that REL9_2_STABLE works fine. Thanks for quick help.

Regards/Pozdrawiam

Jacek Domagalski

-----Original Message-----
From: Euler Taveira [mailto:euler(at)timbira(dot)com]
Sent: Saturday, November 17, 2012 6:56 PM
To: Jacek Domagalski
Cc: PostgreSQL Bugs
Subject: Re: [BUGS] BUG #7667: Segmentation fault

On 17-11-2012 07:03, Jacek Domagalski wrote:

[keep the list CC'ed]

> Scenario to produce error.
>
> 1. OS - Windows 7 x64 PL, Regional settings in regional.jpg 2.
> Installation of postgres-server (postgresql-9.2.1-1-windows-x64.exe)
> with default settings 3. DB scheme in up.backup 4. Query in
> error_query.sql
>
I can confirm that that bug is in 9.2.1 but I couldn't reproduce it in REL9_2_STABLE. It seems a bug in the planner that what fixed a few days ago.
Could you test it in REL9_2_STABLE [1]?

Just to be archived the backtrace is:

Core was generated by `postgres: euler bug [local] SEL'.
Program terminated with signal 11, Segmentation fault.
#0 examine_simple_variable (vardata=0x7fff864ebaa0, root=<optimized out>,
var=<optimized out>) at selfuncs.c:4531
4531 selfuncs.c: Arquivo ou diretório não encontrado.
(gdb) bt
#0 examine_simple_variable (vardata=0x7fff864ebaa0, root=<optimized out>,
var=<optimized out>) at selfuncs.c:4531
#1 examine_variable (root=root(at)entry=0x145b8d0, node=<optimized out>,
varRelid=varRelid(at)entry=0, vardata=vardata(at)entry=0x7fff864ebaa0)
at selfuncs.c:4308
#2 0x00000000006c5d98 in get_restriction_variable (varonleft=<optimized out>,
other=<optimized out>, vardata=0x7fff864ebaa0, varRelid=0,
args=<optimized out>, root=0x145b8d0) at selfuncs.c:4173
#3 get_restriction_variable (root=0x145b8d0, args=<optimized out>,
varRelid=0, vardata=0x7fff864ebaa0, other=<optimized out>,
varonleft=<optimized out>) at selfuncs.c:4154
#4 0x00000000006c5edf in scalargtsel (fcinfo=<optimized out>)
at selfuncs.c:1050
#5 0x000000000072030d in OidFunctionCall4Coll (functionId=<optimized out>,
collation=collation(at)entry=0, arg1=arg1(at)entry=21346512,
arg2=arg2(at)entry=419, arg3=arg3(at)entry=21490216, arg4=arg4(at)entry=0)
at fmgr.c:1682
#6 0x0000000000606f54 in restriction_selectivity (root=root(at)entry=0x145b8d0,
operatorid=419, args=0x147ea28, inputcollid=0, varRelid=varRelid(at)entry=0)
at plancat.c:1026
#7 0x00000000005da2b0 in clause_selectivity (root=root(at)entry=0x145b8d0,
clause=0x147eac8, clause(at)entry=0x1485490, varRelid=varRelid(at)entry=0,
jointype=jointype(at)entry=JOIN_INNER, sjinfo=sjinfo(at)entry=0x0)
at clausesel.c:668
#8 0x00000000005da48c in clauselist_selectivity (root=root(at)entry=0x145b8d0,
clauses=<optimized out>, varRelid=varRelid(at)entry=0,
jointype=jointype(at)entry=JOIN_INNER, sjinfo=sjinfo(at)entry=0x0)
at clausesel.c:123
#9 0x00000000005d9ed5 in clause_selectivity (root=root(at)entry=0x145b8d0,
clause=0x1485ec0, varRelid=varRelid(at)entry=0,
jointype=jointype(at)entry=JOIN_INNER, sjinfo=sjinfo(at)entry=0x0)
at clausesel.c:623
#10 0x00000000005da177 in clause_selectivity (root=root(at)entry=0x145b8d0,
clause=<optimized out>, clause(at)entry=0x1485f40, varRelid=varRelid(at)entry=0,
jointype=jointype(at)entry=JOIN_INNER, sjinfo=sjinfo(at)entry=0x0)
at clausesel.c:642
#11 0x00000000005e73a6 in create_or_index_quals (root=root(at)entry=0x145b8d0,
rel=rel(at)entry=0x14803c0) at orindxpath.c:176
#12 0x00000000005d8bac in set_plain_rel_size (rel=0x14803c0, root=0x145b8d0,
rte=<optimized out>) at allpaths.c:364
#13 set_rel_size (root=root(at)entry=0x145b8d0, rel=0x14803c0, rti=rti(at)entry=1,
rte=0x1458b90) at allpaths.c:250
#14 0x00000000005d9c5a in set_base_rel_sizes (root=<optimized out>)
at allpaths.c:175
#15 make_one_rel (root=root(at)entry=0x145b8d0, joinlist=joinlist(at)entry=0x14827c8)
at allpaths.c:133
#16 0x00000000005f0b6e in query_planner (root=root(at)entry=0x145b8d0,
tlist=tlist(at)entry=0x147ad68, tuple_fraction=0,
tuple_fraction(at)entry=<error reading variable: Could not find type for DW_OP_GNU_const_type>, limit_tuples=-1,
cheapest_path=cheapest_path(at)entry=0x7fff864ec3c0,
sorted_path=sorted_path(at)entry=0x7fff864ec3c8,
num_groups=num_groups(at)entry=0x7fff864ec3b8) at planmain.c:259
#17 0x00000000005f2488 in grouping_planner (root=root(at)entry=0x145b8d0,
tuple_fraction=0,
tuple_fraction(at)entry=<error reading variable: Could not find type for
DW_OP_GNU_const_type>) at planner.c:1221
#18 0x00000000005f4421 in subquery_planner (glob=glob(at)entry=0x1399898,
parse=parse(at)entry=0x1458a80, parent_root=parent_root(at)entry=0x0,
hasRecursion=hasRecursion(at)entry=0 '\000', tuple_fraction=0,
subroot=subroot(at)entry=0x7fff864ec558) at planner.c:525
#19 0x00000000005f46d7 in standard_planner (parse=0x1458a80, cursorOptions=0,
boundParams=0x0) at planner.c:196
#20 0x00000000006563bc in pg_plan_query (querytree=<optimized out>,
cursorOptions=cursorOptions(at)entry=0, boundParams=boundParams(at)entry=0x0)
at postgres.c:751
#21 0x00000000006564b4 in pg_plan_queries (querytrees=<optimized out>,
cursorOptions=cursorOptions(at)entry=0, boundParams=boundParams(at)entry=0x0)
at postgres.c:810
#22 0x0000000000656cc2 in exec_simple_query (
query_string=0x141ac30
"SELECT\n\t\t\t\t\t\t\t\"hlpIssue\".*,\n\t\t\t\t\t\t\t\"LastModifyTimeSet\".\"LastModifyTime\"\n\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t\"hlpIssue\"
LEFT OUTER
JOIN\n\t\n\t\t\t\t\t\t(SELECT\n\t\t\t\t\t\t\t\"hlpIssueChange\".\"IdIssue\",\n\t\t\t\t\t\t\tMAX(\"hlpIssueChange\".\"Mod"...)
at postgres.c:975
#23 PostgresMain (argc=<optimized out>, argv=argv(at)entry=0x1373eb0,
username=<optimized out>) at postgres.c:3968
#24 0x00000000006184c0 in BackendRun (port=0x1399960) at postmaster.c:3619
#25 BackendStartup (port=0x1399960) at postmaster.c:3304
#26 ServerLoop () at postmaster.c:1367
#27 0x000000000061909c in PostmasterMain (argc=argc(at)entry=1,
argv=argv(at)entry=0x1371df0) at postmaster.c:1127
#28 0x0000000000464b9d in main (argc=1, argv=0x1371df0) at main.c:199

[1]
http://git.postgresql.org/gitweb/?p=postgresql.git;a=snapshot;h=refs/heads/REL9_2_STABLE;sf=tgz

--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento