Re: BUG #7667: Segmentation fault - Mailing list pgsql-bugs

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@entry=0x145b8d0, node=<optimized out>,
    varRelid=varRelid@entry=0, vardata=vardata@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@entry=0, arg1=arg1@entry=21346512,
    arg2=arg2@entry=419, arg3=arg3@entry=21490216, arg4=arg4@entry=0)
    at fmgr.c:1682
#6  0x0000000000606f54 in restriction_selectivity (root=root@entry=0x145b8d0,
    operatorid=419, args=0x147ea28, inputcollid=0, varRelid=varRelid@entry=0)
    at plancat.c:1026
#7  0x00000000005da2b0 in clause_selectivity (root=root@entry=0x145b8d0,
    clause=0x147eac8, clause@entry=0x1485490, varRelid=varRelid@entry=0,
    jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0)
    at clausesel.c:668
#8  0x00000000005da48c in clauselist_selectivity (root=root@entry=0x145b8d0,
    clauses=<optimized out>, varRelid=varRelid@entry=0,
    jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0)
    at clausesel.c:123
#9  0x00000000005d9ed5 in clause_selectivity (root=root@entry=0x145b8d0,
    clause=0x1485ec0, varRelid=varRelid@entry=0,
    jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0)
    at clausesel.c:623
#10 0x00000000005da177 in clause_selectivity (root=root@entry=0x145b8d0,
    clause=<optimized out>, clause@entry=0x1485f40, varRelid=varRelid@entry=0,
    jointype=jointype@entry=JOIN_INNER, sjinfo=sjinfo@entry=0x0)
    at clausesel.c:642
#11 0x00000000005e73a6 in create_or_index_quals (root=root@entry=0x145b8d0,
    rel=rel@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@entry=0x145b8d0, rel=0x14803c0, rti=rti@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@entry=0x145b8d0, joinlist=joinlist@entry=0x14827c8)
    at allpaths.c:133
#16 0x00000000005f0b6e in query_planner (root=root@entry=0x145b8d0,
    tlist=tlist@entry=0x147ad68, tuple_fraction=0,
    tuple_fraction@entry=<error reading variable: Could not find type for
DW_OP_GNU_const_type>, limit_tuples=-1,
    cheapest_path=cheapest_path@entry=0x7fff864ec3c0,
    sorted_path=sorted_path@entry=0x7fff864ec3c8,
    num_groups=num_groups@entry=0x7fff864ec3b8) at planmain.c:259
#17 0x00000000005f2488 in grouping_planner (root=root@entry=0x145b8d0,
    tuple_fraction=0,
    tuple_fraction@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@entry=0x1399898,
    parse=parse@entry=0x1458a80, parent_root=parent_root@entry=0x0,
    hasRecursion=hasRecursion@entry=0 '\000', tuple_fraction=0,
    subroot=subroot@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@entry=0, boundParams=boundParams@entry=0x0)
    at postgres.c:751
#21 0x00000000006564b4 in pg_plan_queries (querytrees=<optimized out>,
    cursorOptions=cursorOptions@entry=0, boundParams=boundParams@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@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@entry=1,
    argv=argv@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