2024-07-01 12:20:11,560 - INFO - ya.test - pytest_runtest_setup: #################################################################################################### 2024-07-01 12:20:11,560 - INFO - ya.test - pytest_runtest_setup: test[in-in_tablesource_to_equijoin-] 2024-07-01 12:20:11,560 - INFO - ya.test - pytest_runtest_setup: #################################################################################################### 2024-07-01 12:20:11,561 - INFO - ya.test - pytest_runtest_setup: Test setup 2024-07-01 12:20:11,561 - INFO - ya.test - pytest_runtest_call: Test call (class_name: test.py, test_name: test[in-in_tablesource_to_equijoin-]) 2024-07-01 12:20:11,564 - DEBUG - ya.test - get_binary: Binary was found by /home/runner/.ya/build/build_root/vf44/002d6e/ydb/library/yql/tests/common/test_framework/udfs_deps 2024-07-01 12:20:11,564 - DEBUG - ya.test - get_binary: Binary was found by /home/runner/.ya/build/build_root/vf44/002d6e/ydb/tests/tools/kqprun/kqprun 2024-07-01 12:20:11,565 - DEBUG - ya.test - _get_command_output_file: Command out will be placed to kqprun.out.48 2024-07-01 12:20:11,565 - DEBUG - ya.test - _get_command_output_file: Command err will be placed to kqprun.err.48 2024-07-01 12:20:11,566 - DEBUG - ya.test - execute: Executing '['/home/runner/.ya/build/build_root/vf44/002d6e/ydb/tests/tools/kqprun/kqprun', '--emulate-yt', '--exclude-linked-udfs', '--execution-case', 'query', '--app-config=/home/runner/.ya/build/build_root/vf44/002d6e/environment/arcadia/ydb/tests/fq/yt/cfg/kqprun_config.conf', '--script-query=/home/runner/.ya/build/build_root/vf44/002d6e/ydb/tests/fq/yt/kqp_yt_file/part8/test-results/pytest/testing_out_stuff/yql/kqprun_da27IP/program.sql', '--scheme-query=/home/runner/.ya/build/build_root/vf44/002d6e/environment/arcadia/ydb/tests/fq/yt/cfg/kqprun_scheme.sql', '--result-file=/home/runner/.ya/build/build_root/vf44/002d6e/ydb/tests/fq/yt/kqp_yt_file/part8/test-results/pytest/testing_out_stuff/yql/kqprun_da27IP/results.txt', '--log-file=/home/runner/.ya/build/build_root/vf44/002d6e/ydb/tests/fq/yt/kqp_yt_file/part8/test-results/pytest/testing_out_stuff/yql/kqprun_da27IP/log.txt', '--udfs-dir=/home/runner/.ya/build/build_root/vf44/002d6e/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/002d6e/ydb/tests/fq/yt/kqp_yt_file/part8/test-results/pytest/testing_out_stuff/yql/table_VPqeVf/Input.yqlrun.txt']' in '/home/runner/.ya/build/build_root/vf44/002d6e/ydb/tests/fq/yt/kqp_yt_file/part8/test-results/pytest/testing_out_stuff/yql/kqprun_da27IP' (waiting) 2024-07-01 12:20:11,571 - DEBUG - ya.test - execute: Command pid: 1247517 2024-07-01 12:20:13,476 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) rc: 1 2024-07-01 12:20:13,476 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) elapsed time (sec): 1.90416193008 2024-07-01 12:20:13,476 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) majflt: 0 2024-07-01 12:20:13,477 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) maxrss: 373092 2024-07-01 12:20:13,477 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) minflt: 35902 2024-07-01 12:20:13,477 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) inblock: 0 2024-07-01 12:20:13,477 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) nsignals: 0 2024-07-01 12:20:13,477 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) wtime: 1.91 2024-07-01 12:20:13,477 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) nivcsw: 33 2024-07-01 12:20:13,477 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) idrss: 0 2024-07-01 12:20:13,477 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) msgrcv: 0 2024-07-01 12:20:13,477 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) ixrss: 0 2024-07-01 12:20:13,477 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) isrss: 0 2024-07-01 12:20:13,477 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) nvcsw: 123086 2024-07-01 12:20:13,478 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) stime: 0.551459 2024-07-01 12:20:13,478 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) oublock: 40 2024-07-01 12:20:13,478 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) msgsnd: 0 2024-07-01 12:20:13,478 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) nswap: 0 2024-07-01 12:20:13,478 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) utime: 1.248028 2024-07-01 12:20:13,478 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) output: 2024-07-01T12:20:11.717431Z Fetching udfs... 2024-07-01T12:20:11.784451Z Initialization of kqp runner... Status: 1 FlatTxId { TxId: 281474976715657 SchemeShardTabletId: 72057594046644480 PathId: 1 } 2024-07-01T12:20:13.118927Z Executing scheme query... 2024-07-01T12:20:13.142879Z Executing script... 2024-07-01 12:20:13,478 - DEBUG - ya.test - _save_outputs: Command (pid 1247517) errors: test_client.cpp: SetPath # /home/runner/.ya/build/build_root/vf44/002d6e/r3tmp/tmprrzmy9/pdisk_1.dat TClient is connected to server localhost:29865 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
:17:4: Error: At function: KqpProgram
:23:37: Error: At function: FromFlow, At function: SkipNullMembers
:13:17: Error: At function: FlatMap, At function: ExtractMembers
:15:4: Error: At function: DqPhyMapJoin, At function: SkipNullMembers
:14:11: Error: At function: DqPhyMapJoin
:13:1: Error: At function: FlatMap
:17:4: Error: At function: FlatMap, At function: FlatMap
:13:1: Error: At function: SkipNullMembers, At function: SkipNullMembers, At function: SkipNullMembers
:5:31: Error: Unknown column: optkey
:17:4: Error: Peephole optimization failed for KQP transaction (yexception) ydb/tests/tools/kqprun/kqprun.cpp:115: 2024-07-01T12:20:13.366881Z Query execution failed 2024-07-01 12:20:13,592 - ERROR - ya.test - logreport: ydb/tests/fq/yt/kqp_yt_file/part8/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/002d6e/ydb/tests/tools/kqprun/kqprun --emulate-yt --exclude-linked-udfs --execution-case query --app-config=/home/runner/.ya/build/build_root/vf44/002d6e/environment/arcadia/ydb/tests/fq/yt/cfg/kqprun_config.conf --script-query=/home/runner/.ya/build/build_root/vf44/002d6e/ydb/tests/fq/yt/kqp_yt_file/part8/test-results/pytest/testing_out_stuff/yql/kqprun_da27IP/program.sql --scheme-query=/home/runner/.ya/build/build_root/vf44/002d6e/environment/arcadia/ydb/tests/fq/yt/cfg/kqprun_scheme.sql --result-file=/home/runner/.ya/build/build_root/vf44/002d6e/ydb/tests/fq/yt/kqp_yt_file/part8/test-results/pytest/testing_out_stuff/yql/kqprun_da27IP/results.txt --log-file=/home/runner/.ya/build/build_root/vf44/002d6e/ydb/tests/fq/yt/kqp_yt_file/part8/test-results/pytest/testing_out_stuff/yql/kqprun_da27IP/log.txt --udfs-dir=/home/runner/.ya/build/build_root/vf44/002d6e/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/002d6e/ydb/tests/fq/yt/kqp_yt_file/part8/test-results/pytest/testing_out_stuff/yql/table_VPqeVf/Input.yqlrun.txt E finished with exit code 1, stderr: E E test_client.cpp: SetPath # /home/runner/.ya/build/build_root/vf44/002d6e/r3tmp/tmprrzmy9/pdisk_1.dat E TClient is connected to server localhost:29865 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
:17:4: Error: At function: KqpProgram E
:23:37: Error: At function: FromFlow, At function: SkipNullMembers E
:13:17: Error: At function: FlatMap, At function: ExtractMembers E
:15:4: Error: At function: DqPhyMapJoin, At function: SkipNullMembers E
:14:11: Error: At function: DqPhyMapJoin E
:13:1: Error: At function: FlatMap E
:17:4: Error: At function: FlatMap, At function: FlatMap E
:13:1: Error: At function: SkipNullMembers, At function: SkipNullMembers, At function: SkipNullMembers E
:5:31: Error: Unknown column: optkey E
:17:4: Error: Peephole optimization failed for KQP transaction E E E (yexception) ydb/tests/tools/kqprun/kqprun.cpp:115: 2024-07-01T12:20:13.366881Z Query execution failed E E E log file: E 2024-07-01T12:20:11.809357Z node 1 :KQP_EXECUTER ERROR: kqp_predictor.cpp:134 :user pool is undefined for executer tasks construction E 2024-07-01T12:20:11.809724Z node 1 :METADATA_PROVIDER WARN: fline=table_exists.cpp:54;actor=TTableExistsActor;event=undelivered;self_id=[1:7386641141583140829:4098];send_to=[0:7307199536658146131:7762515]; E 2024-07-01T12:20:11.809749Z node 1 :KQP_EXECUTER ERROR: kqp_predictor.cpp:134 :user pool is undefined for executer tasks construction E 2024-07-01T12:20:11.809877Z node 1 :KQP_EXECUTER ERROR: kqp_predictor.cpp:134 :user pool is undefined for executer tasks construction E 2024-07-01T12:20:11.809907Z 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:20:11.857202Z node 1 :IMPORT WARN: Table profiles were not loaded E 2024-07-01T12:20:11.909150Z node 1 :HIVE WARN: HIVE#72057594037968897 Node(1, (0,0,0,0)) VolatileState: Unknown -> Disconnected E 2024-07-01T12:20:11.909172Z node 1 :HIVE WARN: HIVE#72057594037968897 Node(1, (0,0,0,0)) VolatileState: Disconnected -> Connecting E 2024-07-01T12:20:11.913643Z node 1 :HIVE WARN: HIVE#72057594037968897 Node(1, (0,0,0,0)) VolatileState: Connecting -> Connected E 2024-07-01T12:20:13.366611Z node 1 :KQP_COMPILE_ACTOR ERROR: Compilation failed, self: [1:7386641150173075963:4272], status: GENERIC_ERROR, issues:
: Error: Execution, code: 1060 E
:17:4: Error: At function: KqpProgram E
:23:37: Error: At function: FromFlow, At function: SkipNullMembers E
:13:17: Error: At function: FlatMap, At function: ExtractMembers E
:15:4: Error: At function: DqPhyMapJoin, At function: SkipNullMembers E
:14:11: Error: At function: DqPhyMapJoin E
:13:1: Error: At function: FlatMap E
:17:4: Error: At function: FlatMap, At function: FlatMap E
:13:1: Error: At function: SkipNullMembers, At function: SkipNullMembers, At function: SkipNullMembers E
:5:31: Error: Unknown column: optkey E
:17:4: Error: Peephole optimization failed for KQP transaction E E 2024-07-01T12:20:13.366718Z node 1 :KQP_SESSION WARN: SessionId: ydb://session/3?node_id=1&id=MTI0OTc4ZTQtY2I0ZGQ3NDctZjNiNmEzZDktZjIxMWI5MGQ=, ActorId: [1:7386641150173075961:4271], ActorState: ExecuteState, TraceId: kqprun_bb00a475-68f23fed-71c87c35-4bef8d61, ReplyQueryCompileError, status GENERIC_ERROR remove tx with tx_id: 2024-07-01 12:20:13,603 - INFO - ya.test - pytest_runtest_teardown: Test teardown