2024-07-01 12:26:28,047 - INFO - ya.test - pytest_runtest_setup: #################################################################################################### 2024-07-01 12:26:28,048 - INFO - ya.test - pytest_runtest_setup: test_join[join_ch_pg-kqprun] 2024-07-01 12:26:28,048 - INFO - ya.test - pytest_runtest_setup: #################################################################################################### 2024-07-01 12:26:28,048 - INFO - ya.test - pytest_runtest_setup: Test setup 2024-07-01 12:26:30,240 - DEBUG - ydb.library.yql.providers.generic.connector.tests.utils.clients.postgresql - __init__: initializing client 2024-07-01 12:26:30,242 - INFO - ya.test - pytest_runtest_call: Test call (class_name: test.py, test_name: test_join[join_ch_pg-kqprun]) 2024-07-01 12:26:30,280 - DEBUG - ydb.library.yql.providers.generic.connector.tests.utils.scenario.clickhouse - prepare_table: CREATE DATABASE IF NOT EXISTS join_ch_pg ENGINE = Memory 2024-07-01 12:26:30,283 - DEBUG - ydb.library.yql.providers.generic.connector.tests.utils.scenario.clickhouse - prepare_table: EXISTS TABLE join_ch_pg.example_1 2024-07-01 12:26:30,286 - DEBUG - ydb.library.yql.providers.generic.connector.tests.utils.clients.postgresql - _make_cursor: making cursor for database postgres 2024-07-01 12:26:30,287 - DEBUG - ydb.library.yql.providers.generic.connector.tests.utils.clients.postgresql - _make_cursor: trying to connect PostgreSQL: 0.0.0.0:32783 2024-07-01 12:26:30,374 - DEBUG - ydb.library.yql.providers.generic.connector.tests.utils.scenario.postgresql - debug_with_limit: SELECT 1 FROM pg_database WHERE datname = 'join_ch_pg' 2024-07-01 12:26:30,376 - DEBUG - ydb.library.yql.providers.generic.connector.tests.utils.clients.postgresql - _make_cursor: making cursor for database join_ch_pg 2024-07-01 12:26:30,377 - DEBUG - ydb.library.yql.providers.generic.connector.tests.utils.clients.postgresql - _make_cursor: trying to connect PostgreSQL: 0.0.0.0:32783 2024-07-01 12:26:30,465 - DEBUG - ydb.library.yql.providers.generic.connector.tests.utils.scenario.postgresql - prepare_table: SELECT EXISTS(SELECT * FROM information_schema.tables WHERE table_name='example_2') 2024-07-01 12:26:30,469 - DEBUG - ydb.library.yql.providers.generic.connector.tests.utils.run.kqprun - run: SELECT ch_example_1.id AS ch_example_1_id, ch_example_1.col1 AS ch_example_1_col1, ch_example_1.col2 AS ch_example_1_col2, pg_example_2.id AS pg_example_2_id, pg_example_2.col2 AS pg_example_2_col2, pg_example_2.col1 AS pg_example_2_col1 FROM clickhouse_integration_test.example_1 AS ch_example_1 JOIN postgresql_integration_test.example_2 AS pg_example_2 ON ch_example_1.id = pg_example_2.id ORDER BY ch_example_1_id 2024-07-01 12:26:33,528 - ERROR - ydb.library.yql.providers.generic.connector.tests.utils.run.kqprun - run: Execution failed: STDOUT: 2024-07-01T12:26:30.619268Z Fetching udfs... 2024-07-01T12:26:30.624797Z Initialization of kqp runner... 2024-07-01T12:26:30.650564Z node 1 :KQP_EXECUTER ERROR: kqp_predictor.cpp:134 :user pool is undefined for executer tasks construction 2024-07-01T12:26:30.650878Z node 1 :METADATA_PROVIDER WARN: fline=table_exists.cpp:54;actor=TTableExistsActor;event=undelivered;self_id=[1:7386642771601105146:4098];send_to=[0:7307199536658146131:7762515]; 2024-07-01T12:26:30.650894Z node 1 :KQP_EXECUTER ERROR: kqp_predictor.cpp:134 :user pool is undefined for executer tasks construction 2024-07-01T12:26:30.651003Z node 1 :KQP_EXECUTER ERROR: kqp_predictor.cpp:134 :user pool is undefined for executer tasks construction 2024-07-01T12:26:30.651196Z 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; test_client.cpp: SetPath # /home/runner/.ya/build/build_root/vf44/002d58/r3tmp/tmpC2Fqx6/pdisk_1.dat 2024-07-01T12:26:30.704516Z node 1 :IMPORT WARN: Table profiles were not loaded TClient is connected to server localhost:18007 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. 2024-07-01T12:26:30.750155Z node 1 :HIVE WARN: HIVE#72057594037968897 Node(1, (0,0,0,0)) VolatileState: Unknown -> Disconnected 2024-07-01T12:26:30.750176Z node 1 :HIVE WARN: HIVE#72057594037968897 Node(1, (0,0,0,0)) VolatileState: Disconnected -> Connecting 2024-07-01T12:26:30.754596Z node 1 :HIVE WARN: HIVE#72057594037968897 Node(1, (0,0,0,0)) VolatileState: Connecting -> Connected waiting... Status: 1 FlatTxId { TxId: 281474976715657 SchemeShardTabletId: 72057594046644480 PathId: 1 } 2024-07-01T12:26:31.239045Z Executing scheme query... 2024-07-01T12:26:32.163909Z Executing script... 2024-07-01T12:26:32.321864Z node 1 :KQP_COMPILE_ACTOR ERROR: Compilation failed, self: [1:7386642780191041336:4329], status: GENERIC_ERROR, issues:
: Error: Execution, code: 1060
:4:6: Error: At function: KqpProgram
:2:1: Error: At function: FromFlow, At function: TopSort
:4:47: Error: At function: DqPhyMapJoin, At function: DqPhyMapJoin
:4:47: Error: Not comparable keys: ch_example_1.id and pg_example_2.id, Int32 != Block
:4:6: Error: Peephole optimization failed for KQP transaction 2024-07-01T12:26:32.322416Z node 1 :KQP_SESSION WARN: SessionId: ydb://session/3?node_id=1&id=ZDQzNDk5MmQtYjRkNjBjZjMtYzgxNDU1ZjQtZDQwZmVjN2E=, ActorId: [1:7386642780191041330:4273], ActorState: ExecuteState, TraceId: kqprun_849668d4-611a6d0f-2e2761c1-d30b2a71, ReplyQueryCompileError, status GENERIC_ERROR remove tx with tx_id: Failed to execute script, invalid final status, reason: Request finished with status: GENERIC_ERROR Issues:
: Error: Execution, code: 1060
:4:6: Error: At function: KqpProgram
:2:1: Error: At function: FromFlow, At function: TopSort
:4:47: Error: At function: DqPhyMapJoin, At function: DqPhyMapJoin
:4:47: Error: Not comparable keys: ch_example_1.id and pg_example_2.id, Int32 != Block
:4:6: Error: Peephole optimization failed for KQP transaction (yexception) ydb/tests/tools/kqprun/kqprun.cpp:99: 2024-07-01T12:26:33.331900Z Script execution failed STDERR: None 2024-07-01 12:26:33,540 - ERROR - ya.test - logreport: ydb/library/yql/providers/generic/connector/tests/join/test.py:33: in test_join scenario.join( ../../../../../../../../../../environment/arcadia/ydb/library/yql/providers/generic/connector/tests/join/scenario.py:54: in join assert result.returncode == 0, result.stderr E AttributeError: 'Result' object has no attribute 'stderr' 2024-07-01 12:26:33,541 - INFO - ya.test - pytest_runtest_teardown: Test teardown