Current CLOBBER_CACHE_ALWAYS failures

Поиск
Список
Период
Сортировка
От Christian Ullrich
Тема Current CLOBBER_CACHE_ALWAYS failures
Дата
Msg-id kp70ik$tql$1@ger.gmane.org
обсуждение исходный текст
Ответы Re: Current CLOBBER_CACHE_ALWAYS failures  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
The CLOBBER_CACHE_ALWAYS animals (friarbird and jaguarundi) have been 
failing persistently for about 36 hours now. The error is in a test 
added by Tom's recent commit a4424c5:

Expected:

-- Check row comparisons with IN
select * from int8_tbl i8 where i8 in (row(123,456));  -- fail, type 
mismatch
ERROR:  cannot compare dissimilar column types bigint and integer at 
record column 1

Actual:

select * from int8_tbl i8 where i8 in (row(123,456));  -- fail, type 
mismatch
connection to server was lost

Backtrace, as good as I can make it:

(gdb) bt
#0  0x0000000000743fcf in cache_record_field_properties 
(typentry=0x8031c06f8)    at typcache.c:658
#1  0x0000000000744053 in record_fields_have_compare (typentry=0x8031c06f8)    at typcache.c:625
#2  0x0000000000743983 in lookup_type_cache (type_id=16446, flags=8)    at typcache.c:375
#3  0x000000000074287c in op_mergejoinable (opno=Variable "opno" is not 
available.
) at lsyscache.c:1188
#4  0x0000000000605b0c in check_mergejoinable (restrictinfo=0x803064e18)    at initsplan.c:1876
#5  0x00000000006062d8 in distribute_qual_to_rels (root=0x8031ce4e0,    clause=0x8031cea48, is_deduced=Variable
"is_deduced"is not available.
 
) at initsplan.c:1364
#6  0x0000000000606aa4 in deconstruct_recurse (root=0x8031ce4e0,    jtnode=0x803063d30, below_outer_join=0 '\0',
qualscope=0x7fffffffbbb0,   inner_join_rels=0x7fffffffbba8) at initsplan.c:645
 
#7  0x0000000000607429 in deconstruct_jointree (root=Variable "root" is 
not available.
) at initsplan.c:547
#8  0x0000000000608554 in query_planner (root=0x8031ce4e0, 
tlist=0x8031ce470,    tuple_fraction=0, limit_tuples=-1,    qp_callback=0x60c570 <standard_qp_callback>,
qp_extra=0x7fffffffbe50,   cheapest_path=0x7fffffffbe90, sorted_path=0x7fffffffbe88,    num_groups=0x7fffffffbea0) at
planmain.c:176
#9  0x0000000000609edc in grouping_planner (root=0x8031ce4e0, 
tuple_fraction=0)    at planner.c:1203
#10 0x000000000060c014 in subquery_planner (glob=0x803064f30,    parse=0x803054338, parent_root=0x803054450,
hasRecursion=Variable
 
"hasRecursion" is not available.
) at planner.c:558
#11 0x000000000060c318 in standard_planner (parse=0x803054338,    cursorOptions=0, boundParams=0x0) at planner.c:209
#12 0x000000000067ce0d in pg_plan_query (querytree=0x803054338,    cursorOptions=0, boundParams=0x0) at postgres.c:753
#13 0x000000000067ceee in pg_plan_queries (querytrees=Variable 
"querytrees" is not available.
) at postgres.c:812
#14 0x000000000067d1ca in exec_simple_query (    query_string=0x803053038 "select * from int8_tbl i8 where i8 in 
(row(123,456));") at postgres.c:977
#15 0x000000000067e88a in PostgresMain (argc=1, argv=Variable "argv" is 
not available.
) at postgres.c:3985
#16 0x000000000063137c in ServerLoop () at postmaster.c:3987
#17 0x0000000000634702 in PostmasterMain (argc=6, argv=0x7fffffffd728)    at postmaster.c:1246
#18 0x00000000005ca98f in main (argc=6, argv=0x7fffffffd728) at main.c:196


(gdb) l
653                                             TCFLAGS_HAVE_FIELD_COMPARE);
654                     for (i = 0; i < tupdesc->natts; i++)
655                     {
656                             TypeCacheEntry *fieldentry;
657
658                             if (tupdesc->attrs[i]->attisdropped)
659                                     continue;
660
661                             fieldentry = 
lookup_type_cache(tupdesc->attrs[i]->atttypid,
662                    TYPECACHE_EQ_OPR |


(gdb) p i
$5 = 1
(gdb) p typentry
$6 = (TypeCacheEntry *) 0x8031c06f8
(gdb) p typentry->tupDesc
$7 = 0x0
(gdb) p *typentry
$8 = {type_id = 16446, typlen = -1, typbyval = 0 '\0', typalign = 100 'd',  typstorage = 120 'x', typtype = 99 'c',
typrelid= 16429, btree_opf = 
 
2994,  btree_opintype = 2249, hash_opf = 0, hash_opintype = 0, eq_opr = 0,  lt_opr = 0, gt_opr = 0, cmp_proc = 0,
hash_proc= 0, eq_opr_finfo = {    fn_addr = 0, fn_oid = 0, fn_nargs = 0, fn_strict = 0 '\0',    fn_retset = 0 '\0',
fn_stats= 0 '\0', fn_extra = 0x0, fn_mcxt = 0x0,    fn_expr = 0x0}, cmp_proc_finfo = {fn_addr = 0, fn_oid = 0, fn_nargs

= 0,    fn_strict = 0 '\0', fn_retset = 0 '\0', fn_stats = 0 '\0', fn_extra 
= 0x0,    fn_mcxt = 0x0, fn_expr = 0x0}, hash_proc_finfo = {fn_addr = 0, 
fn_oid = 0,    fn_nargs = 0, fn_strict = 0 '\0', fn_retset = 0 '\0', fn_stats = 0 
'\0',    fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0}, tupDesc = 0x0,  rngelemtype = 0x0, rng_collation = 0,
rng_cmp_proc_finfo= {fn_addr = 0,    fn_oid = 0, fn_nargs = 0, fn_strict = 0 '\0', fn_retset = 0 '\0',    fn_stats = 0
'\0',fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0},  rng_canonical_finfo = {fn_addr = 0, fn_oid = 0, fn_nargs = 0,
fn_strict= 0 '\0', fn_retset = 0 '\0', fn_stats = 0 '\0', fn_extra 
 
= 0x0,    fn_mcxt = 0x0, fn_expr = 0x0}, rng_subdiff_finfo = {fn_addr = 0,    fn_oid = 0, fn_nargs = 0, fn_strict = 0
'\0',fn_retset = 0 '\0',    fn_stats = 0 '\0', fn_extra = 0x0, fn_mcxt = 0x0, fn_expr = 0x0},  flags = 0, enumData =
0x0}


type_id 16446 is int8_tbl.

-- 
Christian




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: DO ... RETURNING
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: erroneous restore into pg_catalog schema