Closed
Description
проблема при прерывании запроса, который ооочень долго выполняется
version: 19ac1f8
Priority high - result of the same query are unstable
iteration 0: ok 2491.411385s seconds
iteration 1: failed 859.931304s seconds (ColumnShard scanner timeout: HAS_ACK=1, code: 2013)
<main>: Error: Scan failed at tablet 72075186224039604, reason: ColumnShard scanner timeout: HAS_ACK=1, code: 2013
Query text:
$z1_12 = 1;
$c = (
select
c_custkey
from
`dt64/column/tpch/s10000/customer`
where
c_mktsegment = 'BUILDING'
);
$o = (
select
o_orderdate,
o_shippriority,
o_orderkey
from
`dt64/column/tpch/s10000/orders` as o
left semi join
$c as c
on
c.c_custkey = o.o_custkey
where
o_orderdate < Date('1995-03-15')
);
$join2 = (
select
o.o_orderdate as o_orderdate,
o.o_shippriority as o_shippriority,
l.l_orderkey as l_orderkey,
l.l_discount as l_discount,
l.l_extendedprice as l_extendedprice
from
`dt64/column/tpch/s10000/lineitem` as l
join
$o as o
on
l.l_orderkey = o.o_orderkey
where
l_shipdate > Date('1995-03-15')
);
select
l_orderkey,
sum(l_extendedprice * ($z1_12 - l_discount)) as revenue,
o_orderdate,
o_shippriority
from
$join2
group by
l_orderkey,
o_orderdate,
o_shippriority
order by
revenue desc,
o_orderdate
limit 10;
2025-02-19T22:10:37.407822Z 1 5038221671882488851 ERROR ua_0/0 max inflight of [100000000] bytes reached, [616] bytes dropped
2025-02-19T22:10:37.407831Z 1 5038221671882488851 ERROR ua_0/0 max inflight of [100000000] bytes reached, [592] bytes dropped
2025-02-19T22:10:37.407845Z 1 5038221671882488851 ERROR ua_0/0 max inflight of [100000000] bytes reached, [960] bytes dropped
2025-02-19T22:10:37.407854Z 1 5038221671882488851 ERROR ua_0/0 max inflight of [100000000] bytes reached, [630] bytes dropped
2025-02-19T22:10:37.407863Z 1 5038221671882488851 ERROR ua_0/0 max inflight of [100000000] bytes reached, [616] bytes dropped