2025-11-05 14:39:58,126 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-05 14:39:58,127 - INFO - ya.test - pytest_runtest_setup: test_tpch[17]
2025-11-05 14:39:58,127 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-05 14:39:58,127 - INFO - ya.test - pytest_runtest_setup: Test setup
2025-11-05 14:39:58,128 - INFO - ya.test - pytest_runtest_call: Test call (class_name: test_tpch.py::TestTpchS1, test_name: test_tpch[17])
2025-11-05 14:39:58,131 - DEBUG - urllib3.connectionpool - _new_conn: Starting new HTTP connection (1): localhost:27467
2025-11-05 14:39:58,133 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /viewer/json/nodes?database=/local/test_db HTTP/1.1" 307 0
2025-11-05 14:39:58,140 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /node/50000/viewer/json/nodes?database=/local/test_db HTTP/1.1" 200 551
2025-11-05 14:39:58,141 - DEBUG - root - check_if_ydb_alive: Expected nodes count: 1
2025-11-05 14:39:58,142 - INFO - root - _get_tables: get_tables /local/test_db/olap_yatests/tpch/s1
2025-11-05 14:39:58,142 - INFO - root - _describe_path_impl: describe /local/test_db/olap_yatests/tpch/s1
2025-11-05 14:39:58,142 - DEBUG - ydb.connection - _prepare_call: RpcState(DescribePath, c01636c4-9ab3-49fc-9fcb-4cde3f11f8c1, ghrun-uqiopzyque.auto.internal:29254): creating call state
2025-11-05 14:39:58,143 - DEBUG - ydb.connection - _log_request: RpcState(DescribePath, c01636c4-9ab3-49fc-9fcb-4cde3f11f8c1, ghrun-uqiopzyque.auto.internal:29254): request = { operation_params { operation_timeout { seconds: 600 } cancel_after { seconds: 600 } } path: "/local/test_db/olap_yatests/tpch/s1" }
2025-11-05 14:39:58,147 - DEBUG - ydb.connection - _log_response: RpcState(DescribePath, c01636c4-9ab3-49fc-9fcb-4cde3f11f8c1, ghrun-uqiopzyque.auto.internal:29254): response = { operation { ready: true status: SUCCESS result { [type.googleapis.com/Ydb.Scheme.DescribePathResult] { self { name: "s1" owner: "root@builtin" type: DIRECTORY effective_permissions { subject: "USERS" permission_names: "ydb.database.connect" } effective_permissions { subject: "METADATA-READERS" permission_names: "ydb.generic.list" } effective_permissions { subject: "DATA-READERS" permission_names: "ydb.granular.select_row" } effective_permissions { subject: "DATA-WRITERS" permission_names: "ydb.tables.modify" } effective_permissions { subject: "DDL-ADMINS" permission_names: "ydb.granular.create_directory" permission_names: "ydb.granular.write_attributes" permission_names: "ydb.granular.create_table" permission_names: "ydb.granular.remove_schema" permission_names: "ydb.granular.create_queue" permission_names: "ydb.granular.alter_schema" } effective_permissions { subject: "ACCESS-ADMINS" permission_names: "ydb.access.grant" } effective_permissions { subject: "DATABASE-ADMINS" permission_names: "ydb.generic.manage" } created_at { plan_step: 1762353016410 tx_id: 281474976720659 } } } } } }
2025-11-05 14:39:58,147 - INFO - root - list_directory: list /local/test_db/olap_yatests/tpch/s1
2025-11-05 14:39:58,148 - DEBUG - ydb.connection - _prepare_call: RpcState(ListDirectory, 7d885d76-a3ba-4566-b2b2-727abf710ead, ghrun-uqiopzyque.auto.internal:29254): creating call state
2025-11-05 14:39:58,148 - DEBUG - ydb.connection - _log_request: RpcState(ListDirectory, 7d885d76-a3ba-4566-b2b2-727abf710ead, ghrun-uqiopzyque.auto.internal:29254): request = { operation_params { operation_timeout { seconds: 600 } cancel_after { seconds: 600 } } path: "/local/test_db/olap_yatests/tpch/s1" }
2025-11-05 14:39:58,152 - DEBUG - ydb.connection - _log_response: RpcState(ListDirectory, 7d885d76-a3ba-4566-b2b2-727abf710ead, ghrun-uqiopzyque.auto.internal:29254): response = { operation { ready: true status: SUCCESS result { [type.googleapis.com/Ydb.Scheme.ListDirectoryResult] { self { name: "s1" owner: "root@builtin" type: DIRECTORY effective_permissions { subject: "USERS" permission_names: "ydb.database.connect" } effective_permissions { subject: "METADATA-READERS" permission_names: "ydb.generic.list" } effective_permissions { subject: "DATA-READERS" permission_names: "ydb.granular.select_row" } effective_permissions { subject: "DATA-WRITERS" permission_names: "ydb.tables.modify" } effective_permissions { subject: "DDL-ADMINS" permission_names: "ydb.granular.create_directory" permission_names: "ydb.granular.write_attributes" permission_names: "ydb.granular.create_table" permission_names: "ydb.granular.remove_schema" permission_names: "ydb.granular.create_queue" permission_names: "ydb.granular.alter_schema" } effective_permissions { subject: "ACCESS-ADMINS" permission_names: "ydb.access.grant" } effective_permissions { subject: "DATABASE-ADMINS" permission_names: "ydb.generic.manage" } created_at { plan_step: 1762353016410 tx_id: 281474976720659 } } children { name: "customer" owner: "root@builtin" type: COLUMN_TABLE created_at { plan_step: 1762353016410 tx_id: 281474976720659 } } children { name: "lineitem" owner: "root@builtin" type: COLUMN_TABLE created_at { plan_step: 1762353018580 tx_id: 281474976720660 } } children { name: "nation" owner: "root@builtin" type: COLUMN_TABLE created_at { plan_step: 1762353018910 tx_id: 281474976720661 } } children { name: "orders" owner: "root@builtin" type: COLUMN_TABLE created_at { plan_step: 1762353020600 tx_id: 281474976720662 } } children { name: "part" owner: "root@builtin" type: COLUMN_TABLE created_at { plan_step: 1762353022550 tx_id: 281474976720663 } } children { name: "partsupp" owner: "root@builtin" type: COLUMN_TABLE created_at { plan_step: 1762353024180 tx_id: 281474976720664 } } children { name: "region" owner: "root@builtin" type: COLUMN_TABLE created_at { plan_step: 1762353024440 tx_id: 281474976720665 } } children { name: "supplier" owner: "root@builtin" type: COLUMN_TABLE created_at { plan_step: 1762353026120 tx_id: 281474976720666 } } } } } }
2025-11-05 14:39:58,155 - DEBUG - urllib3.connectionpool - _new_conn: Starting new HTTP connection (1): localhost:27467
2025-11-05 14:39:58,157 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /viewer/json/nodes?database=/local/test_db&path=/local/test_db/olap_yatests/tpch/s1/customer&tablets=true HTTP/1.1" 307 0
2025-11-05 14:39:58,165 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /node/50000/viewer/json/nodes?database=/local/test_db&path=/local/test_db/olap_yatests/tpch/s1/customer&tablets=true HTTP/1.1" 200 580
2025-11-05 14:39:58,167 - INFO - root - check_if_ydb_alive: Table /local/test_db/olap_yatests/tpch/s1/customer balance: 64-64 shards.
2025-11-05 14:39:58,169 - DEBUG - urllib3.connectionpool - _new_conn: Starting new HTTP connection (1): localhost:27467
2025-11-05 14:39:58,171 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /viewer/json/nodes?database=/local/test_db&path=/local/test_db/olap_yatests/tpch/s1/lineitem&tablets=true HTTP/1.1" 307 0
2025-11-05 14:39:58,178 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /node/50000/viewer/json/nodes?database=/local/test_db&path=/local/test_db/olap_yatests/tpch/s1/lineitem&tablets=true HTTP/1.1" 200 580
2025-11-05 14:39:58,179 - INFO - root - check_if_ydb_alive: Table /local/test_db/olap_yatests/tpch/s1/lineitem balance: 64-64 shards.
2025-11-05 14:39:58,181 - DEBUG - urllib3.connectionpool - _new_conn: Starting new HTTP connection (1): localhost:27467
2025-11-05 14:39:58,183 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /viewer/json/nodes?database=/local/test_db&path=/local/test_db/olap_yatests/tpch/s1/nation&tablets=true HTTP/1.1" 307 0
2025-11-05 14:39:58,190 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /node/50000/viewer/json/nodes?database=/local/test_db&path=/local/test_db/olap_yatests/tpch/s1/nation&tablets=true HTTP/1.1" 200 578
2025-11-05 14:39:58,191 - INFO - root - check_if_ydb_alive: Table /local/test_db/olap_yatests/tpch/s1/nation balance: 1-1 shards.
2025-11-05 14:39:58,193 - DEBUG - urllib3.connectionpool - _new_conn: Starting new HTTP connection (1): localhost:27467
2025-11-05 14:39:58,195 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /viewer/json/nodes?database=/local/test_db&path=/local/test_db/olap_yatests/tpch/s1/orders&tablets=true HTTP/1.1" 307 0
2025-11-05 14:39:58,201 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /node/50000/viewer/json/nodes?database=/local/test_db&path=/local/test_db/olap_yatests/tpch/s1/orders&tablets=true HTTP/1.1" 200 580
2025-11-05 14:39:58,203 - INFO - root - check_if_ydb_alive: Table /local/test_db/olap_yatests/tpch/s1/orders balance: 64-64 shards.
2025-11-05 14:39:58,205 - DEBUG - urllib3.connectionpool - _new_conn: Starting new HTTP connection (1): localhost:27467
2025-11-05 14:39:58,206 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /viewer/json/nodes?database=/local/test_db&path=/local/test_db/olap_yatests/tpch/s1/part&tablets=true HTTP/1.1" 307 0
2025-11-05 14:39:58,213 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /node/50000/viewer/json/nodes?database=/local/test_db&path=/local/test_db/olap_yatests/tpch/s1/part&tablets=true HTTP/1.1" 200 580
2025-11-05 14:39:58,214 - INFO - root - check_if_ydb_alive: Table /local/test_db/olap_yatests/tpch/s1/part balance: 64-64 shards.
2025-11-05 14:39:58,216 - DEBUG - urllib3.connectionpool - _new_conn: Starting new HTTP connection (1): localhost:27467
2025-11-05 14:39:58,218 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /viewer/json/nodes?database=/local/test_db&path=/local/test_db/olap_yatests/tpch/s1/partsupp&tablets=true HTTP/1.1" 307 0
2025-11-05 14:39:58,224 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /node/50000/viewer/json/nodes?database=/local/test_db&path=/local/test_db/olap_yatests/tpch/s1/partsupp&tablets=true HTTP/1.1" 200 580
2025-11-05 14:39:58,226 - INFO - root - check_if_ydb_alive: Table /local/test_db/olap_yatests/tpch/s1/partsupp balance: 64-64 shards.
2025-11-05 14:39:58,228 - DEBUG - urllib3.connectionpool - _new_conn: Starting new HTTP connection (1): localhost:27467
2025-11-05 14:39:58,229 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /viewer/json/nodes?database=/local/test_db&path=/local/test_db/olap_yatests/tpch/s1/region&tablets=true HTTP/1.1" 307 0
2025-11-05 14:39:58,236 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /node/50000/viewer/json/nodes?database=/local/test_db&path=/local/test_db/olap_yatests/tpch/s1/region&tablets=true HTTP/1.1" 200 578
2025-11-05 14:39:58,238 - INFO - root - check_if_ydb_alive: Table /local/test_db/olap_yatests/tpch/s1/region balance: 1-1 shards.
2025-11-05 14:39:58,239 - DEBUG - urllib3.connectionpool - _new_conn: Starting new HTTP connection (1): localhost:27467
2025-11-05 14:39:58,241 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /viewer/json/nodes?database=/local/test_db&path=/local/test_db/olap_yatests/tpch/s1/supplier&tablets=true HTTP/1.1" 307 0
2025-11-05 14:39:58,248 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /node/50000/viewer/json/nodes?database=/local/test_db&path=/local/test_db/olap_yatests/tpch/s1/supplier&tablets=true HTTP/1.1" 200 580
2025-11-05 14:39:58,250 - INFO - root - check_if_ydb_alive: Table /local/test_db/olap_yatests/tpch/s1/supplier balance: 64-64 shards.
2025-11-05 14:39:58,251 - DEBUG - ydb.connection - _prepare_call: RpcState(StreamExecuteScanQuery, b8e57acf-2c32-4508-b061-05842ef4a23d, ghrun-uqiopzyque.auto.internal:29254): creating call state
2025-11-05 14:39:58,251 - DEBUG - ydb.connection - _log_request: RpcState(StreamExecuteScanQuery, b8e57acf-2c32-4508-b061-05842ef4a23d, ghrun-uqiopzyque.auto.internal:29254): request = { query { yql_text: "select 1" } mode: MODE_EXEC collect_stats: STATS_COLLECTION_NONE }
2025-11-05 14:39:58,252 - DEBUG - ydb.connection - _log_response: RpcState(StreamExecuteScanQuery, b8e57acf-2c32-4508-b061-05842ef4a23d, ghrun-uqiopzyque.auto.internal:29254): response = { <_MultiThreadedRendezvous object> }
2025-11-05 14:39:58,310 - DEBUG - urllib3.connectionpool - _new_conn: Starting new HTTP connection (1): localhost:27467
2025-11-05 14:39:58,313 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /viewer/json/nodes?database=/local/test_db HTTP/1.1" 307 0
2025-11-05 14:39:58,321 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /node/50000/viewer/json/nodes?database=/local/test_db HTTP/1.1" 200 551
2025-11-05 14:39:58,322 - DEBUG - ya.test - get_binary: Binary was found by /home/runner/.ya/build/build_root/j3ko/001b3d/ydb/apps/ydb/ydb
2025-11-05 14:39:58,324 - DEBUG - ya.test - _get_command_output_file: Command out will be placed to ydb.out.17
2025-11-05 14:39:58,325 - DEBUG - ya.test - _get_command_output_file: Command err will be placed to ydb.err.17
2025-11-05 14:39:58,325 - DEBUG - ya.test - execute: Executing '['/home/runner/.ya/build/build_root/j3ko/001b3d/ydb/apps/ydb/ydb', '-e', 'grpc://localhost:6357', '-d', '/local/test_db', 'workload', 'tpch', '--path', 'olap_yatests/tpch/s1', 'run', '--json', '/home/runner/.ya/build/build_root/j3ko/001b3d/ydb/tests/functional/tpc/medium/test-results/py3test/testing_out_stuff/test_tpch/testing_out_stuff/test_tpch.py.TestTpchS1.test_tpch.17/q17.json', '--output', '/home/runner/.ya/build/build_root/j3ko/001b3d/ydb/tests/functional/tpc/medium/test-results/py3test/testing_out_stuff/test_tpch/testing_out_stuff/test_tpch.py.TestTpchS1.test_tpch.17/q17.out', '--executer', 'generic', '--include', '17', '--iterations', '1', '--plan', '/home/runner/.ya/build/build_root/j3ko/001b3d/ydb/tests/functional/tpc/medium/test-results/py3test/testing_out_stuff/test_tpch/testing_out_stuff/test_tpch.py.TestTpchS1.test_tpch.17/q17.plan', '--global-timeout', '1800.0s', '--verbose', '--check-canonical', '--scale', '1']' in 'None' (waiting)
2025-11-05 14:39:58,326 - DEBUG - ya.test - execute: Command pid: 1057859
2025-11-05 14:40:11,943 - DEBUG - ya.test - _kill_process_tree: Killing process 1057859
2025-11-05 14:40:11,943 - DEBUG - ya.test - _nix_kill_process_tree: Killing process tree for pid 1057859 (bin:'error([Errno 2] No such file or directory: '/proc/1057859/exe')')
2025-11-05 14:40:11,943 - DEBUG - ya.test - try_to_send_signal: Error while sending signal 19 to pid 1057859: [Errno 3] No such process
2025-11-05 14:40:11,956 - DEBUG - ya.test - try_to_send_signal: Error while sending signal 9 to pid 1057859: [Errno 3] No such process
2025-11-05 14:40:11,956 - DEBUG - ya.test - try_to_send_signal: Error while sending signal 18 to pid 1057859: [Errno 3] No such process
2025-11-05 14:40:11,956 - DEBUG - ya.test - _wait: Process resource usage is not available as process finished before wait4 was called
2025-11-05 14:40:11,956 - DEBUG - ya.test - wait: Command exception: Graceful shutdown requested
2025-11-05 14:40:11,957 - DEBUG - ya.test - _save_outputs: Command (pid 1057859) rc: 0
2025-11-05 14:40:11,957 - DEBUG - ya.test - _save_outputs: Command (pid 1057859) elapsed time (sec): 13.63021206855774
2025-11-05 14:40:11,957 - DEBUG - ya.test - _save_outputs: Command (pid 1057859) wtime: 13.631
2025-11-05 14:40:11,958 - DEBUG - ya.test - _save_outputs: Command (pid 1057859) output:
Query17:
Query text:
$z7_35 = 7.;
$z0_2_12 = 0.2;
$p = select p_partkey from `olap_yatests/tpch/s1/part`
where
    p_brand = 'Brand#23'
    and p_container = 'MED BOX'
;
$threshold = (
select
    $z0_2_12 * avg(l_quantity) as threshold,
    l.l_partkey as l_partkey
from
    `olap_yatests/tpch/s1/lineitem` as l
left semi join
    $p as p
on  
    p.p_partkey = l.l_partkey
group by
    l.l_partkey
);
$l = select l.l_partkey as l_partkey, l.l_quantity as l_quantity, l.l_extendedprice as l_extendedprice
from
    `olap_yatests/tpch/s1/lineitem` as l
join
    $p as p
on  
    p.p_partkey = l.l_partkey;
select
    sum(l.l_extendedprice) / $z7_35 as avg_yearly
from
    $l as l
join
    $threshold as t
on  
    t.l_partkey = l.l_partkey
where
    l.l_quantity < t.threshold;

	iteration 0:	ok	10.711453s seconds

Results for 1 iterations
┌─────────┬──────────┬─────────┬─────────┬─────────┬─────────┬───────────┬─────────┬─────────┬─────────┬─────────┬──────────────┬────────────┬────────────┐
│ Query # │ ColdTime │ Min     │ Max     │ Mean    │ Median  │ UnixBench │ Std     │ RttMin  │ RttMax  │ RttAvg  │ SuccessCount │ FailsCount │ DiffsCount │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼──────────────┼────────────┼────────────┤
│ Query17 │  10.376  │  10.376 │  10.376 │  10.375 │  10.375 │  10.376   │   0.000 │   0.336 │   0.336 │   0.335 │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼──────────────┼────────────┼────────────┤
│ Sum     │  10.376  │  10.376 │  10.376 │  10.375 │  10.375 │  10.376   │   0.000 │   0.336 │   0.336 │   0.335 │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼──────────────┼────────────┼────────────┤
│ Avg     │  10.376  │  10.376 │  10.376 │  10.375 │  10.375 │  10.376   │   0.000 │   0.336 │   0.336 │   0.335 │ 1            │            │            │
├─────────┼──────────┼─────────┼─────────┼─────────┼─────────┼───────────┼─────────┼─────────┼─────────┼─────────┼──────────────┼────────────┼────────────┤
│ GAvg    │  10.376  │  10.376 │  10.376 │  10.375 │  10.375 │  10.376   │   0.000 │   0.336 │   0.336 │   0.001 │ 1            │            │            │
└─────────┴──────────┴─────────┴─────────┴─────────┴─────────┴───────────┴─────────┴─────────┴─────────┴─────────┴──────────────┴────────────┴────────────┘

Results saved to /home/runner/.ya/build/build_root/j3ko/001b3d/ydb/tests/functional/tpc/medium/test-results/py3test/testing_out_stuff/test_tpch/testing_out_stuff/test_tpch.py.TestTpchS1.test_tpch.17/q17.out
Json report saved to /home/runner/.ya/build/build_root/j3ko/001b3d/ydb/tests/functional/tpc/medium/test-results/py3test/testing_out_stuff/test_tpch/testing_out_stuff/test_tpch.py.TestTpchS1.test_tpch.17/q17.json

2025-11-05 14:40:11,958 - DEBUG - ya.test - _save_outputs: Command (pid 1057859) errors:
(!) New version of YDB CLI is available. Run 'ydb update' command for update. You can also disable further version checks with 'ydb version --disable-checks' command

[K|Progress: 0 rows read, 0 B read.
[K
[K|Progress: 0 rows read, 0 B read.
[K/Progress: 5.94M rows read, 190M B read.
[K-Progress: 9.44M rows read, 302M B read.
[K\Progress: 12M rows read, 384M B read.
[K
2025-11-05 14:40:11,960 - DEBUG - urllib3.connectionpool - _new_conn: Starting new HTTP connection (1): localhost:27467
2025-11-05 14:40:11,965 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:27467 "GET /viewer/json/nodes HTTP/1.1" 200 798
2025-11-05 14:40:12,712 - ERROR - ya.test - logreport: ydb/tests/olap/load/lib/tpch.py:45: in test_tpch
    self.run_workload_test(self._get_path(), query_num)
ydb/tests/olap/load/lib/conftest.py:297: in run_workload_test
    self.process_query_result(result, query_num, qparams.iterations, True)
ydb/tests/olap/load/lib/conftest.py:245: in process_query_result
    raise exc
ydb/tests/olap/lib/ydb_cli.py:286: in process
    self._exec_cli()
ydb/tests/olap/lib/ydb_cli.py:273: in _exec_cli
    process = yatest.common.process.execute(self._get_cmd(), check_exit_code=False)
library/python/testing/yatest_common/yatest/common/process.py:656: in execute
    res.wait(check_exit_code, timeout, on_timeout)
library/python/testing/yatest_common/yatest/common/process.py:400: in wait
    _wait()
library/python/testing/yatest_common/yatest/common/process.py:335: in _wait
    pid, sts, rusage = os.wait4(self._process.pid, 0)
library/python/pytest/plugins/ya.py:347: in _graceful_shutdown
    _graceful_shutdown_on_log(not capman.is_globally_capturing())
library/python/pytest/plugins/ya.py:321: in _graceful_shutdown_on_log
    pytest.exit("Graceful shutdown requested")
E   Failed: Graceful shutdown requested
