Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

stable-24-4 + stable-25-1: Error: [Compute spilling][TEvError] Spilling Service not started #15500

Open
maximyurchuk opened this issue Mar 10, 2025 · 0 comments · May be fixed by #15605
Open
Assignees
Labels
area/runtime YDB runtime issues

Comments

@maximyurchuk
Copy link
Collaborator

TPC-H (row) scale 1 with mixed cluster 24-4 + 25-1

7:
iteration 0
<main>: Error: [Compute spilling][TEvError] Spilling Service not started
<main>: Error: Query invalidated on scheme/internal error during Data execution, code: 2019

Query text:
$z1_12 = 1;
$n = select n_name, n_nationkey from `olap_yatests/tpch/s1/nation` as n
    where n_name = 'FRANCE' or n_name = 'GERMANY';
$l = select 
    l_orderkey, l_suppkey,
    DateTime::GetYear(cast(l_shipdate as timestamp)) as l_year,
    l_extendedprice * ($z1_12 - l_discount) as volume
from 
    `olap_yatests/tpch/s1/lineitem` as l
where 
    l.l_shipdate between Date('1995-01-01') and Date('1996-12-31');
$j1 = select 
    n_name as supp_nation,
    s_suppkey
from 
    `olap_yatests/tpch/s1/supplier` as supplier
join 
    $n as n1
on 
    supplier.s_nationkey = n1.n_nationkey;
$j2 = select
    n_name as cust_nation,
    c_custkey
from 
    `olap_yatests/tpch/s1/customer` as customer
join 
    $n as n2
on 
    customer.c_nationkey = n2.n_nationkey;
$j3 = select
    cust_nation, o_orderkey
from 
    `olap_yatests/tpch/s1/orders` as orders
join 
    $j2 as customer
on 
    orders.o_custkey = customer.c_custkey;
$j4 = select
    cust_nation,
    l_orderkey, l_suppkey,
    l_year,
    volume
from 
    $l as lineitem
join 
    $j3 as orders
on 
    lineitem.l_orderkey = orders.o_orderkey;
$j5 = select
    supp_nation, cust_nation,
    l_year, volume
from 
    $j4 as lineitem
join 
    $j1 as supplier
on 
    lineitem.l_suppkey = supplier.s_suppkey
where (supp_nation = 'FRANCE' and cust_nation = 'GERMANY')
    OR (supp_nation = 'GERMANY' and cust_nation = 'FRANCE');
select
    supp_nation,
    cust_nation,
    l_year, 
    sum(volume) as revenue
from
    $j5 as shipping
group by
    supp_nation,
    cust_nation,
    l_year
order by
    supp_nation,
    cust_nation,
    l_year;

Without mixed cluster (24-4 only or 25-1 only works fine)

@maximyurchuk maximyurchuk changed the title 24-4 + 25-1: 24-4 + 25-1: Error: [Compute spilling][TEvError] Spilling Service not started Mar 10, 2025
@lll-phill-lll lll-phill-lll self-assigned this Mar 10, 2025
@lll-phill-lll lll-phill-lll added the area/runtime YDB runtime issues label Mar 10, 2025
@lll-phill-lll lll-phill-lll linked a pull request Mar 11, 2025 that will close this issue
@maximyurchuk maximyurchuk changed the title 24-4 + 25-1: Error: [Compute spilling][TEvError] Spilling Service not started stable-24-4 + stable-25-1: Error: [Compute spilling][TEvError] Spilling Service not started Mar 12, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/runtime YDB runtime issues
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants