2024-07-01 12:23:11,861 - INFO - ya.test - pytest_runtest_setup: #################################################################################################### 2024-07-01 12:23:11,861 - INFO - ya.test - pytest_runtest_setup: test[join-left_only_semi_and_other-] 2024-07-01 12:23:11,862 - INFO - ya.test - pytest_runtest_setup: #################################################################################################### 2024-07-01 12:23:11,862 - INFO - ya.test - pytest_runtest_setup: Test setup 2024-07-01 12:23:11,863 - INFO - ya.test - pytest_runtest_call: Test call (class_name: test.py, test_name: test[join-left_only_semi_and_other-]) 2024-07-01 12:23:11,865 - DEBUG - ya.test - get_binary: Binary was found by /home/runner/.ya/build/build_root/vf44/002d67/ydb/library/yql/tests/common/test_framework/udfs_deps 2024-07-01 12:23:11,865 - DEBUG - ya.test - get_binary: Binary was found by /home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/tools/kqprun/kqprun 2024-07-01 12:23:11,866 - DEBUG - ya.test - _get_command_output_file: Command out will be placed to kqprun.out.40 2024-07-01 12:23:11,868 - DEBUG - ya.test - _get_command_output_file: Command err will be placed to kqprun.err.40 2024-07-01 12:23:11,868 - DEBUG - ya.test - execute: Executing '['/home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/tools/kqprun/kqprun', '--emulate-yt', '--exclude-linked-udfs', '--execution-case', 'query', '--app-config=/home/runner/.ya/build/build_root/vf44/002d67/environment/arcadia/ydb/tests/fq/yt/cfg/kqprun_config.conf', '--script-query=/home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/fq/yt/kqp_yt_file/part19/test-results/pytest/testing_out_stuff/yql/kqprun_nf9MHQ/program.sql', '--scheme-query=/home/runner/.ya/build/build_root/vf44/002d67/environment/arcadia/ydb/tests/fq/yt/cfg/kqprun_scheme.sql', '--result-file=/home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/fq/yt/kqp_yt_file/part19/test-results/pytest/testing_out_stuff/yql/kqprun_nf9MHQ/results.txt', '--log-file=/home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/fq/yt/kqp_yt_file/part19/test-results/pytest/testing_out_stuff/yql/kqprun_nf9MHQ/log.txt', '--udfs-dir=/home/runner/.ya/build/build_root/vf44/002d67/ydb/library/yql/tests/common/test_framework/udfs_deps', '--result-format', 'full-proto', '--result-rows-limit', '0', '--table=yt.Root/plato.Input@/home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/fq/yt/kqp_yt_file/part19/test-results/pytest/testing_out_stuff/yql/table_hv_E2w/Input.yqlrun.txt', '--table=yt.Root/plato.Input1@/home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/fq/yt/kqp_yt_file/part19/test-results/pytest/testing_out_stuff/yql/table_hv_E2w/Input1.yqlrun.txt', '--table=yt.Root/plato.Input2@/home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/fq/yt/kqp_yt_file/part19/test-results/pytest/testing_out_stuff/yql/table_hv_E2w/Input2.yqlrun.txt', '--table=yt.Root/plato.Input3@/home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/fq/yt/kqp_yt_file/part19/test-results/pytest/testing_out_stuff/yql/table_hv_E2w/Input3.yqlrun.txt', '--table=yt.Root/plato.Input4@/home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/fq/yt/kqp_yt_file/part19/test-results/pytest/testing_out_stuff/yql/table_hv_E2w/Input4.yqlrun.txt']' in '/home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/fq/yt/kqp_yt_file/part19/test-results/pytest/testing_out_stuff/yql/kqprun_nf9MHQ' (waiting) 2024-07-01 12:23:11,875 - DEBUG - ya.test - execute: Command pid: 1310304 2024-07-01 12:23:13,568 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) rc: 1 2024-07-01 12:23:13,568 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) elapsed time (sec): 1.69270896912 2024-07-01 12:23:13,569 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) majflt: 0 2024-07-01 12:23:13,569 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) maxrss: 369600 2024-07-01 12:23:13,569 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) minflt: 35061 2024-07-01 12:23:13,569 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) inblock: 0 2024-07-01 12:23:13,569 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) nsignals: 0 2024-07-01 12:23:13,569 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) wtime: 1.699 2024-07-01 12:23:13,569 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) nivcsw: 58 2024-07-01 12:23:13,569 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) idrss: 0 2024-07-01 12:23:13,569 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) msgrcv: 0 2024-07-01 12:23:13,569 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) ixrss: 0 2024-07-01 12:23:13,569 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) isrss: 0 2024-07-01 12:23:13,570 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) nvcsw: 93969 2024-07-01 12:23:13,570 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) stime: 0.428288 2024-07-01 12:23:13,570 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) oublock: 56 2024-07-01 12:23:13,570 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) msgsnd: 0 2024-07-01 12:23:13,570 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) nswap: 0 2024-07-01 12:23:13,570 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) utime: 0.846257 2024-07-01 12:23:13,570 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) output: 2024-07-01T12:23:12.017820Z Fetching udfs... 2024-07-01T12:23:12.084356Z Initialization of kqp runner... Status: 1 FlatTxId { TxId: 281474976715657 SchemeShardTabletId: 72057594046644480 PathId: 1 } 2024-07-01T12:23:13.229094Z Executing scheme query... 2024-07-01T12:23:13.252836Z Executing script... 2024-07-01 12:23:13,570 - DEBUG - ya.test - _save_outputs: Command (pid 1310304) errors: test_client.cpp: SetPath # /home/runner/.ya/build/build_root/vf44/002d67/r3tmp/tmpG46Ohd/pdisk_1.dat TClient is connected to server localhost:6562 WaitRootIsUp 'Root'... TClient::Ls request: Root TClient::Ls response: Status: 1 StatusCode: SUCCESS SchemeStatus: 0 PathDescription { Self { Name: "Root" PathId: 1 SchemeshardId: 72057594046644480 PathType: EPathTypeDir CreateFinished: true CreateTxId: 1 CreateStep: 0 ParentPathId: 1 PathState: EPathStateNoChanges Owner: "root@builtin" ACL: "" EffectiveACL: "" PathVersion: 2 PathSubType: EPathSubTypeEmpty Version { GeneralVersion: 2 ACLVersion: 0 EffectiveACLVersion: 0 UserAttrsVersion: 1 ChildrenVersion: 1 SubDomainVersion: 0 SecurityStateVersion: 0 } } Children { Name: ".sys" PathId: 18446744073709551615 SchemeshardId: 72057594046644480 PathType: EPathTypeDir CreateFinished: true CreateTxId: 0 CreateStep: 0 ParentPathId: 18446744073709551615 } DomainDescription { SchemeShardId_Depricated: 72057594046644480 PathId_Depricated: 1 ProcessingParams { Version: 0 PlanResolution: 7 Coo... (TRUNCATED) WaitRootIsUp 'Root' success. waiting... Failed to execute query, reason: Request finished with status: GENERIC_ERROR Issues:
: Error: Execution, code: 1060
:11:16: Error: At function: KqpProgram
:9:1: Error: At function: FromFlow, At function: Sort
:11:16: Error: At function: ExtractMembers, At function: ExtractMembers, At function: ExtractMembers
:11:16: Error: Member not found: i1.subkey. Did you mean i4.subkey?
:11:16: Error: Peephole optimization failed for KQP transaction (yexception) ydb/tests/tools/kqprun/kqprun.cpp:115: 2024-07-01T12:23:13.298428Z Query execution failed 2024-07-01 12:23:13,594 - ERROR - ya.test - logreport: ydb/tests/fq/yt/kqp_yt_file/part19/test.py:14: in test return run_test(suite, case, cfg) ../../../../../../../../environment/arcadia/ydb/tests/fq/yt/kqp_yt_file.py:160: in run_test run_file_kqp(suite, case, cfg) ../../../../../../../../environment/arcadia/ydb/tests/fq/yt/kqp_yt_file.py:189: in run_file_kqp run_file_kqp.cache[(suite, case, cfg)] = run_file_kqp_no_cache(suite, case, cfg) ../../../../../../../../environment/arcadia/ydb/tests/fq/yt/kqp_yt_file.py:184: in run_file_kqp_no_cache return kqprun.yql_exec(program=sql_query, verbose=True, check_error=True, tables=in_tables) ../../../../../../../../environment/arcadia/ydb/tests/fq/yt/kqprun.py:66: in yql_exec 'log_file': yql_utils.read_res_file(log_file)[1], E AssertionError: Command E /home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/tools/kqprun/kqprun --emulate-yt --exclude-linked-udfs --execution-case query --app-config=/home/runner/.ya/build/build_root/vf44/002d67/environment/arcadia/ydb/tests/fq/yt/cfg/kqprun_config.conf --script-query=/home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/fq/yt/kqp_yt_file/part19/test-results/pytest/testing_out_stuff/yql/kqprun_nf9MHQ/program.sql --scheme-query=/home/runner/.ya/build/build_root/vf44/002d67/environment/arcadia/ydb/tests/fq/yt/cfg/kqprun_scheme.sql --result-file=/home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/fq/yt/kqp_yt_file/part19/test-results/pytest/testing_out_stuff/yql/kqprun_nf9MHQ/results.txt --log-file=/home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/fq/yt/kqp_yt_file/part19/test-results/pytest/testing_out_stuff/yql/kqprun_nf9MHQ/log.txt --udfs-dir=/home/runner/.ya/build/build_root/vf44/002d67/ydb/library/yql/tests/common/test_framework/udfs_deps --result-format full-proto --result-rows-limit 0 --table=yt.Root/plato.Input@/home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/fq/yt/kqp_yt_file/part19/test-results/pytest/testing_out_stuff/yql/table_hv_E2w/Input.yqlrun.txt --table=yt.Root/plato.Input1@/home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/fq/yt/kqp_yt_file/part19/test-results/pytest/testing_out_stuff/yql/table_hv_E2w/Input1.yqlrun.txt --table=yt.Root/plato.Input2@/home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/fq/yt/kqp_yt_file/part19/test-results/pytest/testing_out_stuff/yql/table_hv_E2w/Input2.yqlrun.txt --table=yt.Root/plato.Input3@/home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/fq/yt/kqp_yt_file/part19/test-results/pytest/testing_out_stuff/yql/table_hv_E2w/Input3.yqlrun.txt --table=yt.Root/plato.Input4@/home/runner/.ya/build/build_root/vf44/002d67/ydb/tests/fq/yt/kqp_yt_file/part19/test-results/pytest/testing_out_stuff/yql/table_hv_E2w/Input4.yqlrun.txt E finished with exit code 1, stderr: E E test_client.cpp: SetPath # /home/runner/.ya/build/build_root/vf44/002d67/r3tmp/tmpG46Ohd/pdisk_1.dat E TClient is connected to server localhost:6562 E WaitRootIsUp 'Root'... E TClient::Ls request: Root E TClient::Ls response: Status: 1 E StatusCode: SUCCESS E SchemeStatus: 0 E PathDescription { E Self { E Name: "Root" E PathId: 1 E SchemeshardId: 72057594046644480 E PathType: EPathTypeDir E CreateFinished: true E CreateTxId: 1 E CreateStep: 0 E ParentPathId: 1 E PathState: EPathStateNoChanges E Owner: "root@builtin" E ACL: "" E EffectiveACL: "" E PathVersion: 2 E PathSubType: EPathSubTypeEmpty E Version { E GeneralVersion: 2 E ACLVersion: 0 E EffectiveACLVersion: 0 E UserAttrsVersion: 1 E ChildrenVersion: 1 E SubDomainVersion: 0 E SecurityStateVersion: 0 E } E } E Children { E Name: ".sys" E PathId: 18446744073709551615 E SchemeshardId: 72057594046644480 E PathType: EPathTypeDir E CreateFinished: true E CreateTxId: 0 E CreateStep: 0 E ParentPathId: 18446744073709551615 E } E DomainDescription { E SchemeShardId_Depricated: 72057594046644480 E PathId_Depricated: 1 E ProcessingParams { E Version: 0 E PlanResolution: 7 E Coo... E (TRUNCATED) E E WaitRootIsUp 'Root' success. E waiting... E Failed to execute query, reason: E Request finished with status: GENERIC_ERROR E Issues: E
: Error: Execution, code: 1060 E
:11:16: Error: At function: KqpProgram E
:9:1: Error: At function: FromFlow, At function: Sort E
:11:16: Error: At function: ExtractMembers, At function: ExtractMembers, At function: ExtractMembers E
:11:16: Error: Member not found: i1.subkey. Did you mean i4.subkey? E
:11:16: Error: Peephole optimization failed for KQP transaction E E E (yexception) ydb/tests/tools/kqprun/kqprun.cpp:115: 2024-07-01T12:23:13.298428Z Query execution failed E E E log file: E 2024-07-01T12:23:12.110284Z node 1 :KQP_EXECUTER ERROR: kqp_predictor.cpp:134 :user pool is undefined for executer tasks construction E 2024-07-01T12:23:12.110636Z node 1 :METADATA_PROVIDER WARN: fline=table_exists.cpp:54;actor=TTableExistsActor;event=undelivered;self_id=[1:7386641919839463808:4098];send_to=[0:7307199536658146131:7762515]; E 2024-07-01T12:23:12.110659Z node 1 :KQP_EXECUTER ERROR: kqp_predictor.cpp:134 :user pool is undefined for executer tasks construction E 2024-07-01T12:23:12.110784Z node 1 :KQP_EXECUTER ERROR: kqp_predictor.cpp:134 :user pool is undefined for executer tasks construction E 2024-07-01T12:23:12.110838Z node 1 :METADATA_PROVIDER ERROR: fline=accessor_snapshot_base.cpp:68;action=cannot detect path existence;path=//Root/.metadata/initialization/migrations;error=scheme_cache_undelivered_message; E 2024-07-01T12:23:12.157335Z node 1 :IMPORT WARN: Table profiles were not loaded E 2024-07-01T12:23:12.209738Z node 1 :HIVE WARN: HIVE#72057594037968897 Node(1, (0,0,0,0)) VolatileState: Unknown -> Disconnected E 2024-07-01T12:23:12.209756Z node 1 :HIVE WARN: HIVE#72057594037968897 Node(1, (0,0,0,0)) VolatileState: Disconnected -> Connecting E 2024-07-01T12:23:12.214265Z node 1 :HIVE WARN: HIVE#72057594037968897 Node(1, (0,0,0,0)) VolatileState: Connecting -> Connected E 2024-07-01T12:23:12.235674Z node 1 :FLAT_TX_SCHEMESHARD WARN: NotifyTxCompletion, unknown transaction, txId: 281474976715657, at schemeshard: 72057594046644480 E 2024-07-01T12:23:13.298122Z node 1 :KQP_COMPILE_ACTOR ERROR: Compilation failed, self: [1:7386641924134431648:4270], status: GENERIC_ERROR, issues:
: Error: Execution, code: 1060 E
:11:16: Error: At function: KqpProgram E
:9:1: Error: At function: FromFlow, At function: Sort E
:11:16: Error: At function: ExtractMembers, At function: ExtractMembers, At function: ExtractMembers E
:11:16: Error: Member not found: i1.subkey. Did you mean i4.subkey? E
:11:16: Error: Peephole optimization failed for KQP transaction E E 2024-07-01T12:23:13.298253Z node 1 :KQP_SESSION WARN: SessionId: ydb://session/3?node_id=1&id=ODhlYzMxYjQtZGIzM2YzNWMtZjkyZGIyYTYtYjA3OWEyNQ==, ActorId: [1:7386641924134431646:4269], ActorState: ExecuteState, TraceId: kqprun_7b21334e-7292aec0-392c9392-58bb9a04, ReplyQueryCompileError, status GENERIC_ERROR remove tx with tx_id: 2024-07-01 12:23:13,605 - INFO - ya.test - pytest_runtest_teardown: Test teardown