You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
It looks like an error caused by using deadbeef;
(gdb) print tbls[j]
$3 = (sql_table *) 0xbdbdbdbd0079656b
Thread 3212 "mserver5" received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7fffd45d4700 (LWP 7438)]
0x00007fffeecc3b18 in rel_reduce_groupby_exps (changes=0x7fffd45d3774, sql=0x7fffac130610, rel=0x7fffac8b7510)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:4787
4787 if (tbls[j]->pkey) {
0 0x00007fffeecc3b18 in rel_reduce_groupby_exps (changes=0x7fffd45d3774, sql=0x7fffac130610, rel=0x7fffac8b7510)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:4787
1 0x00007fffeecd35fa in rewrite (sql=0x7fffac130610, rel=0x7fffac8b7510, rewriter=0x7fffeecc36ad <rel_reduce_groupby_exps>,
has_changes=0x7fffd45d38f8) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8600
2 0x00007fffeecd362c in rewrite (sql=0x7fffac130610, rel=0x7fffac8b7510, rewriter=0x7fffeecc36ad <rel_reduce_groupby_exps>,
has_changes=0x7fffd45d38f8) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8603
3 0x00007fffeecd362c in rewrite (sql=0x7fffac130610, rel=0x7fffac8b7510, rewriter=0x7fffeecc36ad <rel_reduce_groupby_exps>,
has_changes=0x7fffd45d38f8) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8603
4 0x00007fffeecd34d1 in rewrite (sql=0x7fffac130610, rel=0x7fffac8c0650, rewriter=0x7fffeecc36ad <rel_reduce_groupby_exps>,
has_changes=0x7fffd45d38f8) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8578
5 0x00007fffeecd3524 in rewrite (sql=0x7fffac130610, rel=0x7fffac8c0b50, rewriter=0x7fffeecc36ad <rel_reduce_groupby_exps>,
has_changes=0x7fffd45d38f8) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8586
6 0x00007fffeecd3524 in rewrite (sql=0x7fffac130610, rel=0x7fffac8c0fa0, rewriter=0x7fffeecc36ad <rel_reduce_groupby_exps>,
has_changes=0x7fffd45d38f8) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8586
7 0x00007fffeecd3ebb in _rel_optimizer (sql=0x7fffac130610, rel=0x7fffac8c0fa0, level=0)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8777
8 0x00007fffeecd4236 in rel_optimizer (sql=0x7fffac130610, rel=0x7fffac8c0fa0)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8836
9 0x00007fffeebbba74 in sql_symbol2relation (c=0x7fffac130610, sym=0x7fffac5f20a0)
at /export/scratch1/home/mk/default//package/sql/backends/monet5/sql.c:121
10 0x00007fffeebe107b in SQLparser (c=0x7ffff098a328)
Reproducible: Always
Steps to Reproduce:
select
subq_0.c7 as c0,
ref_5.role_id as c1
from
sys.partsupp as ref_1
right join sys.user_role as ref_5
right join sys.netcdf_attrs as ref_6
on (ref_5.login_id = ref_6.file_id )
on (ref_1.ps_availqty = ref_6.file_id ),
lateral (select distinct
(select clk from sys.tracelog)
as c0,
ref_1.ps_availqty as c1,
ref_17.n_name as c2,
ref_17.n_comment as c3,
ref_17.n_nationkey as c4,
ref_5.role_id as c5,
ref_6.att_name as c6,
(select pg from bam.rg)
as c7,
ref_16.type as c8,
(select db_alias from sys.connections)
as c9
from
tmp.idxs as ref_15
left join sys.geometry_columns as ref_16
on (ref_15.name = ref_16.f_table_schema )
inner join sys.nation as ref_17
on (ref_16.srid = ref_17.n_nationkey )
right join sys.idxs as ref_18
on (ref_15.table_id = ref_18.id )
where 98 is NULL) as subq_0
where (select id from tmp.keys)
is not NULL
limit 104;
Date: 2017-03-07 11:55:07 +0100
From: @mlkersten
To: SQL devs <>
Version: 11.25.5 (Dec2016-SP1)
CC: @njnes
Last updated: 2017-03-31 13:28:21 +0200
Comment 25140
Date: 2017-03-07 11:55:07 +0100
From: @mlkersten
User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:51.0) Gecko/20100101 Firefox/51.0
Build Identifier:
UsingTPCH SF1 uncovered a segvault on Dec
It looks like an error caused by using deadbeef;
(gdb) print tbls[j]
$3 = (sql_table *) 0xbdbdbdbd0079656b
Thread 3212 "mserver5" received signal SIGSEGV, Segmentation fault.
[Switching to Thread 0x7fffd45d4700 (LWP 7438)]
0x00007fffeecc3b18 in rel_reduce_groupby_exps (changes=0x7fffd45d3774, sql=0x7fffac130610, rel=0x7fffac8b7510)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:4787
4787 if (tbls[j]->pkey) {
0 0x00007fffeecc3b18 in rel_reduce_groupby_exps (changes=0x7fffd45d3774, sql=0x7fffac130610, rel=0x7fffac8b7510)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:4787
1 0x00007fffeecd35fa in rewrite (sql=0x7fffac130610, rel=0x7fffac8b7510, rewriter=0x7fffeecc36ad <rel_reduce_groupby_exps>,
has_changes=0x7fffd45d38f8) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8600
2 0x00007fffeecd362c in rewrite (sql=0x7fffac130610, rel=0x7fffac8b7510, rewriter=0x7fffeecc36ad <rel_reduce_groupby_exps>,
has_changes=0x7fffd45d38f8) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8603
3 0x00007fffeecd362c in rewrite (sql=0x7fffac130610, rel=0x7fffac8b7510, rewriter=0x7fffeecc36ad <rel_reduce_groupby_exps>,
has_changes=0x7fffd45d38f8) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8603
4 0x00007fffeecd34d1 in rewrite (sql=0x7fffac130610, rel=0x7fffac8c0650, rewriter=0x7fffeecc36ad <rel_reduce_groupby_exps>,
has_changes=0x7fffd45d38f8) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8578
5 0x00007fffeecd3524 in rewrite (sql=0x7fffac130610, rel=0x7fffac8c0b50, rewriter=0x7fffeecc36ad <rel_reduce_groupby_exps>,
has_changes=0x7fffd45d38f8) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8586
6 0x00007fffeecd3524 in rewrite (sql=0x7fffac130610, rel=0x7fffac8c0fa0, rewriter=0x7fffeecc36ad <rel_reduce_groupby_exps>,
has_changes=0x7fffd45d38f8) at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8586
7 0x00007fffeecd3ebb in _rel_optimizer (sql=0x7fffac130610, rel=0x7fffac8c0fa0, level=0)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8777
8 0x00007fffeecd4236 in rel_optimizer (sql=0x7fffac130610, rel=0x7fffac8c0fa0)
at /export/scratch1/home/mk/default//package/sql/server/rel_optimizer.c:8836
9 0x00007fffeebbba74 in sql_symbol2relation (c=0x7fffac130610, sym=0x7fffac5f20a0)
at /export/scratch1/home/mk/default//package/sql/backends/monet5/sql.c:121
10 0x00007fffeebe107b in SQLparser (c=0x7ffff098a328)
Reproducible: Always
Steps to Reproduce:
select
subq_0.c7 as c0,
ref_5.role_id as c1
from
sys.partsupp as ref_1
right join sys.user_role as ref_5
right join sys.netcdf_attrs as ref_6
on (ref_5.login_id = ref_6.file_id )
on (ref_1.ps_availqty = ref_6.file_id ),
lateral (select distinct
(select clk from sys.tracelog)
as c0,
ref_1.ps_availqty as c1,
ref_17.n_name as c2,
ref_17.n_comment as c3,
ref_17.n_nationkey as c4,
ref_5.role_id as c5,
ref_6.att_name as c6,
(select pg from bam.rg)
as c7,
ref_16.type as c8,
(select db_alias from sys.connections)
as c9
from
tmp.idxs as ref_15
left join sys.geometry_columns as ref_16
on (ref_15.name = ref_16.f_table_schema )
inner join sys.nation as ref_17
on (ref_16.srid = ref_17.n_nationkey )
right join sys.idxs as ref_18
on (ref_15.table_id = ref_18.id )
where 98 is NULL) as subq_0
where (select id from tmp.keys)
is not NULL
limit 104;
Comment 25150
Date: 2017-03-15 14:53:14 +0100
From: @njnes
fixed a problem in the optimizer
The text was updated successfully, but these errors were encountered: