2024-07-01 12:19:45,838 - INFO - ya.test - pytest_runtest_setup: #################################################################################################### 2024-07-01 12:19:45,838 - INFO - ya.test - pytest_runtest_setup: test[join-lookupjoin_unused_keys-] 2024-07-01 12:19:45,838 - INFO - ya.test - pytest_runtest_setup: #################################################################################################### 2024-07-01 12:19:45,838 - INFO - ya.test - pytest_runtest_setup: Test setup 2024-07-01 12:19:45,839 - INFO - ya.test - pytest_runtest_call: Test call (class_name: test.py, test_name: test[join-lookupjoin_unused_keys-]) 2024-07-01 12:19:45,842 - DEBUG - ya.test - get_binary: Binary was found by /home/runner/.ya/build/build_root/vf44/002d69/ydb/library/yql/tests/common/test_framework/udfs_deps 2024-07-01 12:19:45,842 - DEBUG - ya.test - get_binary: Binary was found by /home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/tools/kqprun/kqprun 2024-07-01 12:19:45,843 - DEBUG - ya.test - _get_command_output_file: Command out will be placed to kqprun.out.31 2024-07-01 12:19:45,843 - DEBUG - ya.test - _get_command_output_file: Command err will be placed to kqprun.err.31 2024-07-01 12:19:45,844 - DEBUG - ya.test - execute: Executing '['/home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/tools/kqprun/kqprun', '--emulate-yt', '--exclude-linked-udfs', '--execution-case', 'query', '--app-config=/home/runner/.ya/build/build_root/vf44/002d69/environment/arcadia/ydb/tests/fq/yt/cfg/kqprun_config.conf', '--script-query=/home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/fq/yt/kqp_yt_file/part3/test-results/pytest/testing_out_stuff/yql/kqprun_s8IlyK/program.sql', '--scheme-query=/home/runner/.ya/build/build_root/vf44/002d69/environment/arcadia/ydb/tests/fq/yt/cfg/kqprun_scheme.sql', '--result-file=/home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/fq/yt/kqp_yt_file/part3/test-results/pytest/testing_out_stuff/yql/kqprun_s8IlyK/results.txt', '--log-file=/home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/fq/yt/kqp_yt_file/part3/test-results/pytest/testing_out_stuff/yql/kqprun_s8IlyK/log.txt', '--udfs-dir=/home/runner/.ya/build/build_root/vf44/002d69/ydb/library/yql/tests/common/test_framework/udfs_deps', '--result-format', 'full-proto', '--result-rows-limit', '0', '--table=yt.Root/plato.Input1@/home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/fq/yt/kqp_yt_file/part3/test-results/pytest/testing_out_stuff/yql/table_5GV4ss/Input1.yqlrun.txt', '--table=yt.Root/plato.Input2@/home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/fq/yt/kqp_yt_file/part3/test-results/pytest/testing_out_stuff/yql/table_5GV4ss/Input2.yqlrun.txt', '--table=yt.Root/plato.Input3@/home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/fq/yt/kqp_yt_file/part3/test-results/pytest/testing_out_stuff/yql/table_5GV4ss/Input3.yqlrun.txt', '--table=yt.Root/plato.Input4@/home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/fq/yt/kqp_yt_file/part3/test-results/pytest/testing_out_stuff/yql/table_5GV4ss/Input4.yqlrun.txt', '--table=yt.Root/plato.Input5@/home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/fq/yt/kqp_yt_file/part3/test-results/pytest/testing_out_stuff/yql/table_5GV4ss/Input5.yqlrun.txt']' in '/home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/fq/yt/kqp_yt_file/part3/test-results/pytest/testing_out_stuff/yql/kqprun_s8IlyK' (waiting) 2024-07-01 12:19:45,849 - DEBUG - ya.test - execute: Command pid: 1238801 2024-07-01 12:19:47,955 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) rc: 1 2024-07-01 12:19:47,956 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) elapsed time (sec): 2.10512804985 2024-07-01 12:19:47,956 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) majflt: 0 2024-07-01 12:19:47,956 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) maxrss: 369328 2024-07-01 12:19:47,956 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) minflt: 35126 2024-07-01 12:19:47,956 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) inblock: 0 2024-07-01 12:19:47,957 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) nsignals: 0 2024-07-01 12:19:47,957 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) wtime: 2.111 2024-07-01 12:19:47,957 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) nivcsw: 38 2024-07-01 12:19:47,957 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) idrss: 0 2024-07-01 12:19:47,957 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) msgrcv: 0 2024-07-01 12:19:47,957 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) ixrss: 0 2024-07-01 12:19:47,957 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) isrss: 0 2024-07-01 12:19:47,957 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) nvcsw: 146182 2024-07-01 12:19:47,957 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) stime: 0.541155 2024-07-01 12:19:47,957 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) oublock: 72 2024-07-01 12:19:47,957 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) msgsnd: 0 2024-07-01 12:19:47,958 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) nswap: 0 2024-07-01 12:19:47,958 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) utime: 1.23187 2024-07-01 12:19:47,958 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) output: 2024-07-01T12:19:45.997299Z Fetching udfs... 2024-07-01T12:19:46.065634Z Initialization of kqp runner... Status: 1 FlatTxId { TxId: 281474976715657 SchemeShardTabletId: 72057594046644480 PathId: 1 } 2024-07-01T12:19:47.612261Z Executing scheme query... 2024-07-01T12:19:47.636723Z Executing script... 2024-07-01 12:19:47,958 - DEBUG - ya.test - _save_outputs: Command (pid 1238801) errors: test_client.cpp: SetPath # /home/runner/.ya/build/build_root/vf44/002d69/r3tmp/tmpFQN6Rj/pdisk_1.dat TClient is connected to server localhost:22996 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
:10:16: Error: At function: KqpProgram
:6:1: Error: At function: FromFlow, At function: Sort
:10:16: Error: At function: FlatMap, At function: ExtractMembers, At function: DqPhyMapJoin, At function: SkipNullMembers, At function: SkipNullMembers, At function: SkipNullMembers
:10:16: Error: Unknown column: k3
:10:16: Error: Peephole optimization failed for KQP transaction (yexception) ydb/tests/tools/kqprun/kqprun.cpp:115: 2024-07-01T12:19:47.675410Z Query execution failed 2024-07-01 12:19:47,983 - ERROR - ya.test - logreport: ydb/tests/fq/yt/kqp_yt_file/part3/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/002d69/ydb/tests/tools/kqprun/kqprun --emulate-yt --exclude-linked-udfs --execution-case query --app-config=/home/runner/.ya/build/build_root/vf44/002d69/environment/arcadia/ydb/tests/fq/yt/cfg/kqprun_config.conf --script-query=/home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/fq/yt/kqp_yt_file/part3/test-results/pytest/testing_out_stuff/yql/kqprun_s8IlyK/program.sql --scheme-query=/home/runner/.ya/build/build_root/vf44/002d69/environment/arcadia/ydb/tests/fq/yt/cfg/kqprun_scheme.sql --result-file=/home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/fq/yt/kqp_yt_file/part3/test-results/pytest/testing_out_stuff/yql/kqprun_s8IlyK/results.txt --log-file=/home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/fq/yt/kqp_yt_file/part3/test-results/pytest/testing_out_stuff/yql/kqprun_s8IlyK/log.txt --udfs-dir=/home/runner/.ya/build/build_root/vf44/002d69/ydb/library/yql/tests/common/test_framework/udfs_deps --result-format full-proto --result-rows-limit 0 --table=yt.Root/plato.Input1@/home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/fq/yt/kqp_yt_file/part3/test-results/pytest/testing_out_stuff/yql/table_5GV4ss/Input1.yqlrun.txt --table=yt.Root/plato.Input2@/home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/fq/yt/kqp_yt_file/part3/test-results/pytest/testing_out_stuff/yql/table_5GV4ss/Input2.yqlrun.txt --table=yt.Root/plato.Input3@/home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/fq/yt/kqp_yt_file/part3/test-results/pytest/testing_out_stuff/yql/table_5GV4ss/Input3.yqlrun.txt --table=yt.Root/plato.Input4@/home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/fq/yt/kqp_yt_file/part3/test-results/pytest/testing_out_stuff/yql/table_5GV4ss/Input4.yqlrun.txt --table=yt.Root/plato.Input5@/home/runner/.ya/build/build_root/vf44/002d69/ydb/tests/fq/yt/kqp_yt_file/part3/test-results/pytest/testing_out_stuff/yql/table_5GV4ss/Input5.yqlrun.txt E finished with exit code 1, stderr: E E test_client.cpp: SetPath # /home/runner/.ya/build/build_root/vf44/002d69/r3tmp/tmpFQN6Rj/pdisk_1.dat E TClient is connected to server localhost:22996 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
:10:16: Error: At function: KqpProgram E
:6:1: Error: At function: FromFlow, At function: Sort E
:10:16: Error: At function: FlatMap, At function: ExtractMembers, At function: DqPhyMapJoin, At function: SkipNullMembers, At function: SkipNullMembers, At function: SkipNullMembers E
:10:16: Error: Unknown column: k3 E
:10:16: Error: Peephole optimization failed for KQP transaction E E E (yexception) ydb/tests/tools/kqprun/kqprun.cpp:115: 2024-07-01T12:19:47.675410Z Query execution failed E E E log file: E 2024-07-01T12:19:46.091823Z node 1 :KQP_EXECUTER ERROR: kqp_predictor.cpp:134 :user pool is undefined for executer tasks construction E 2024-07-01T12:19:46.092214Z node 1 :METADATA_PROVIDER WARN: fline=table_exists.cpp:54;actor=TTableExistsActor;event=undelivered;self_id=[1:7386641032987734860:4098];send_to=[0:7307199536658146131:7762515]; E 2024-07-01T12:19:46.092237Z node 1 :KQP_EXECUTER ERROR: kqp_predictor.cpp:134 :user pool is undefined for executer tasks construction E 2024-07-01T12:19:46.092426Z node 1 :KQP_EXECUTER ERROR: kqp_predictor.cpp:134 :user pool is undefined for executer tasks construction E 2024-07-01T12:19:46.092475Z 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:19:46.145958Z node 1 :IMPORT WARN: Table profiles were not loaded E 2024-07-01T12:19:46.191603Z node 1 :HIVE WARN: HIVE#72057594037968897 Node(1, (0,0,0,0)) VolatileState: Unknown -> Disconnected E 2024-07-01T12:19:46.191625Z node 1 :HIVE WARN: HIVE#72057594037968897 Node(1, (0,0,0,0)) VolatileState: Disconnected -> Connecting E 2024-07-01T12:19:46.196427Z node 1 :HIVE WARN: HIVE#72057594037968897 Node(1, (0,0,0,0)) VolatileState: Connecting -> Connected E 2024-07-01T12:19:47.675144Z node 1 :KQP_COMPILE_ACTOR ERROR: Compilation failed, self: [1:7386641037282702700:4270], status: GENERIC_ERROR, issues:
: Error: Execution, code: 1060 E
:10:16: Error: At function: KqpProgram E
:6:1: Error: At function: FromFlow, At function: Sort E
:10:16: Error: At function: FlatMap, At function: ExtractMembers, At function: DqPhyMapJoin, At function: SkipNullMembers, At function: SkipNullMembers, At function: SkipNullMembers E
:10:16: Error: Unknown column: k3 E
:10:16: Error: Peephole optimization failed for KQP transaction E E 2024-07-01T12:19:47.675256Z node 1 :KQP_SESSION WARN: SessionId: ydb://session/3?node_id=1&id=MzUzMjc3ODItYWEwYjE5YjgtZWU0MDQyOGUtZDNiMWI3NmU=, ActorId: [1:7386641037282702698:4269], ActorState: ExecuteState, TraceId: kqprun_a9e41ed2-c270508a-9b9b07f-8bbe5dd0, ReplyQueryCompileError, status GENERIC_ERROR remove tx with tx_id: 2024-07-01 12:19:47,994 - INFO - ya.test - pytest_runtest_teardown: Test teardown