2024-07-01 12:28:20,199 - INFO - ya.test - pytest_runtest_setup: #################################################################################################### 2024-07-01 12:28:20,200 - INFO - ya.test - pytest_runtest_setup: test_simple[v2-1-fq_client0-mvp_external_ydb_endpoint0] 2024-07-01 12:28:20,200 - INFO - ya.test - pytest_runtest_setup: #################################################################################################### 2024-07-01 12:28:20,200 - INFO - ya.test - pytest_runtest_setup: Test setup 2024-07-01 12:28:20,695 - DEBUG - library.python.filelock - acquire: Acquiring filelock (blocking=False): /home/runner/.ya/build/port_sync_dir/5019 2024-07-01 12:28:20,695 - DEBUG - library.python.filelock - acquire: Acquiring filelock (blocking=False): /home/runner/.ya/build/port_sync_dir/7970 2024-07-01 12:28:20,750 - DEBUG - library.python.filelock - acquire: Acquiring filelock (blocking=False): /home/runner/.ya/build/port_sync_dir/10425 2024-07-01 12:28:20,804 - DEBUG - library.python.filelock - acquire: Acquiring filelock (blocking=False): /home/runner/.ya/build/port_sync_dir/2981 2024-07-01 12:28:20,805 - DEBUG - library.python.filelock - acquire: Acquiring filelock (blocking=False): /home/runner/.ya/build/port_sync_dir/14995 2024-07-01 12:28:20,805 - DEBUG - ydb.connection - channel_factory: Channel options: [('grpc.max_receive_message_length', 64000000), ('grpc.max_send_message_length', 64000000), ('grpc.primary_user_agent', 'python-library'), ('grpc.lb_policy_name', 'round_robin')] 2024-07-01 12:28:20,806 - DEBUG - ydb.resolver.DiscoveryEndpointsResolver - context_resolve: Preparing initial endpoint to resolve endpoints 2024-07-01 12:28:20,807 - DEBUG - ydb.connection - channel_factory: Channel options: [('grpc.max_receive_message_length', 64000000), ('grpc.max_send_message_length', 64000000), ('grpc.primary_user_agent', 'python-library'), ('grpc.lb_policy_name', 'round_robin')] 2024-07-01 12:28:20,810 - DEBUG - ydb.resolver.DiscoveryEndpointsResolver - context_resolve: Resolving endpoints for database local 2024-07-01 12:28:20,811 - DEBUG - ydb.connection - _prepare_call: RpcState(ListEndpoints, d156cfff-87d2-4389-a461-379d2d819325, localhost:62132): creating call state 2024-07-01 12:28:20,811 - DEBUG - ydb.connection - _log_request: RpcState(ListEndpoints, d156cfff-87d2-4389-a461-379d2d819325, localhost:62132): request = { database: "local" } 2024-07-01 12:28:20,813 - DEBUG - ydb.connection - _log_response: RpcState(ListEndpoints, d156cfff-87d2-4389-a461-379d2d819325, localhost:62132): response = { operation { ready: true status: SUCCESS result { [type.googleapis.com/Ydb.Discovery.ListEndpointsResult] { endpoints { address: "fv4578birt7rdb95oc7v.auto.internal" port: 62132 service: "legacy" service: "yql" service: "discovery" service: "cms" service: "locking" service: "kesus" service: "pq" service: "pqcd" service: "pqv1" service: "topic" service: "datastreams" service: "scripting" service: "clickhouse_internal" service: "rate_limiter" service: "analytics" service: "export" service: "import" service: "yq" service: "keyvalue" service: "monitoring" service: "auth" service: "query_service" location: "1" node_id: 1 } self_location: "1" } } } } 2024-07-01 12:28:20,814 - DEBUG - ydb.resolver.DiscoveryEndpointsResolver - _add_debug_details: Resolved endpoints for database local: DiscoveryResult ]> 2024-07-01 12:28:20,814 - DEBUG - ydb.connection - channel_factory: Channel options: [('grpc.max_receive_message_length', 64000000), ('grpc.max_send_message_length', 64000000), ('grpc.primary_user_agent', 'python-library'), ('grpc.lb_policy_name', 'round_robin')] 2024-07-01 12:28:20,816 - INFO - ydb.connection - close: Closing channel for endpoint localhost:62132 2024-07-01 12:28:20,817 - DEBUG - ydb.table.SessionPool - subscribe: Active session queue is empty, subscribe waiter for a session 2024-07-01 12:28:20,817 - DEBUG - ydb.table.SessionPool - subscribe: Subscribe waiter 2024-07-01 12:28:20,818 - DEBUG - ydb.table.SessionPool - subscribe: Session pool is not large enough (active_count < size: 0 < 1). will create a new session. 2024-07-01 12:28:20,818 - DEBUG - ydb.table.SessionPool - _create: Created session 2024-07-01 12:28:20,818 - DEBUG - ydb.table.SessionPool - _prepare: Preparing session 2024-07-01 12:28:20,818 - DEBUG - ydb.connection - _prepare_call: RpcState(CreateSession, 75b42a52-3438-4a8c-8cd6-7a799ccf19a6, fv4578birt7rdb95oc7v.auto.internal:62132): creating call state 2024-07-01 12:28:20,818 - DEBUG - ydb.connection - _log_request: RpcState(CreateSession, 75b42a52-3438-4a8c-8cd6-7a799ccf19a6, fv4578birt7rdb95oc7v.auto.internal:62132): request = { operation_params { operation_timeout { seconds: 3 } cancel_after { seconds: 3 } } } 2024-07-01 12:28:20,820 - DEBUG - ydb.connection - _on_response_callback: RpcState(CreateSession, 75b42a52-3438-4a8c-8cd6-7a799ccf19a6, fv4578birt7rdb95oc7v.auto.internal:62132): on response callback started 2024-07-01 12:28:20,821 - DEBUG - ydb.connection - _log_response: RpcState(CreateSession, 75b42a52-3438-4a8c-8cd6-7a799ccf19a6, fv4578birt7rdb95oc7v.auto.internal:62132): response = { operation { ready: true status: SUCCESS result { [type.googleapis.com/Ydb.Table.CreateSessionResult] { session_id: "ydb://session/3?node_id=1&id=YTY3ZjgxM2ItNDBmOTg5ZTEtOWE2ZGQ3NzktN2ZiM2Q0M2U=" } } } } 2024-07-01 12:28:20,821 - DEBUG - ydb.table.SessionPool - put: Put on session 2024-07-01 12:28:20,821 - DEBUG - ydb.table.SessionPool - put: Replying to waiter with a session 2024-07-01 12:28:20,821 - DEBUG - ydb.connection - _prepare_call: RpcState(CreateTable, 5d369d41-d893-49f0-8016-f821a2310c37, fv4578birt7rdb95oc7v.auto.internal:62132): creating call state 2024-07-01 12:28:20,822 - DEBUG - ydb.connection - _on_response_callback: RpcState(CreateSession, 75b42a52-3438-4a8c-8cd6-7a799ccf19a6, fv4578birt7rdb95oc7v.auto.internal:62132): on response callback success 2024-07-01 12:28:20,823 - DEBUG - ydb.connection - _log_request: RpcState(CreateTable, 5d369d41-d893-49f0-8016-f821a2310c37, fv4578birt7rdb95oc7v.auto.internal:62132): request = { session_id: "ydb://session/3?node_id=1&id=YTY3ZjgxM2ItNDBmOTg5ZTEtOWE2ZGQ3NzktN2ZiM2Q0M2U=" path: "local/DbPoolStorage_4a8cd6bc-f2c2-49d6-b6b9-436461a45894/tenants" columns { name: "tenant" type { optional_type { item { type_id: STRING } } } } columns { name: "vtenant" type { optional_type { item { type_id: STRING } } } } columns { name: "common" type { optional_type { item { type_id: BOOL } } } } columns { name: "state" type { optional_type { item { type_id: UINT32 } } } } columns { name: "state_time" type { optional_type { item { type_id: TIMESTAMP } } } } primary_key: "tenant" operation_params { operation_timeout { seconds: 600 } cancel_after { seconds: 600 } } } 2024-07-01 12:28:20,837 - DEBUG - ydb.connection - _log_response: RpcState(CreateTable, 5d369d41-d893-49f0-8016-f821a2310c37, fv4578birt7rdb95oc7v.auto.internal:62132): response = { operation { ready: true status: SUCCESS } } 2024-07-01 12:28:20,837 - DEBUG - ydb.table.SessionPool - put: Put on session 2024-07-01 12:28:20,838 - DEBUG - ydb.connection - _prepare_call: RpcState(CreateTable, 4d51f96d-43f2-427e-acd9-1a5c160ab905, fv4578birt7rdb95oc7v.auto.internal:62132): creating call state 2024-07-01 12:28:20,838 - DEBUG - ydb.connection - _log_request: RpcState(CreateTable, 4d51f96d-43f2-427e-acd9-1a5c160ab905, fv4578birt7rdb95oc7v.auto.internal:62132): request = { session_id: "ydb://session/3?node_id=1&id=YTY3ZjgxM2ItNDBmOTg5ZTEtOWE2ZGQ3NzktN2ZiM2Q0M2U=" path: "local/DbPoolStorage_4a8cd6bc-f2c2-49d6-b6b9-436461a45894/mappings" columns { name: "subject_type" type { optional_type { item { type_id: STRING } } } } columns { name: "subject_id" type { optional_type { item { type_id: STRING } } } } columns { name: "vtenant" type { optional_type { item { type_id: STRING } } } } primary_key: "subject_type" primary_key: "subject_id" operation_params { operation_timeout { seconds: 600 } cancel_after { seconds: 600 } } } 2024-07-01 12:28:20,852 - DEBUG - ydb.connection - _log_response: RpcState(CreateTable, 4d51f96d-43f2-427e-acd9-1a5c160ab905, fv4578birt7rdb95oc7v.auto.internal:62132): response = { operation { ready: true status: SUCCESS } } 2024-07-01 12:28:20,852 - DEBUG - ydb.table.SessionPool - put: Put on session 2024-07-01 12:28:20,853 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteDataQuery, c59fc1e1-3823-40ee-81be-109ab62ba0e5, fv4578birt7rdb95oc7v.auto.internal:62132): creating call state 2024-07-01 12:28:20,854 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteDataQuery, c59fc1e1-3823-40ee-81be-109ab62ba0e5, fv4578birt7rdb95oc7v.auto.internal:62132): request = { session_id: "ydb://session/3?node_id=1&id=YTY3ZjgxM2ItNDBmOTg5ZTEtOWE2ZGQ3NzktN2ZiM2Q0M2U=" tx_control { begin_tx { serializable_read_write { } } commit_tx: true } query { yql_text: "--!syntax_v1\n PRAGMA TablePathPrefix(\"local/DbPoolStorage_4a8cd6bc-f2c2-49d6-b6b9-436461a45894\");\n UPSERT INTO tenants (tenant, vtenant, common, state, state_time) values(\"/cp\", \"/cp\", true, 0, CurrentUtcTimestamp());\n UPSERT INTO tenants (tenant, vtenant, common, state, state_time) values(\"/compute\", \"/compute\", true, 0, CurrentUtcTimestamp());\n " } operation_params { operation_timeout { seconds: 600 } cancel_after { seconds: 600 } } } 2024-07-01 12:28:20,872 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteDataQuery, c59fc1e1-3823-40ee-81be-109ab62ba0e5, fv4578birt7rdb95oc7v.auto.internal:62132): response = { operation { ready: true status: SUCCESS result { [type.googleapis.com/Ydb.Table.ExecuteQueryResult] { tx_meta { } } } } } 2024-07-01 12:28:20,872 - DEBUG - ydb.table.SessionPool - put: Put on session 2024-07-01 12:28:20,873 - DEBUG - library.python.filelock - acquire: Acquiring filelock (blocking=False): /home/runner/.ya/build/port_sync_dir/23567 2024-07-01 12:28:20,930 - DEBUG - library.python.filelock - acquire: Acquiring filelock (blocking=False): /home/runner/.ya/build/port_sync_dir/19059 2024-07-01 12:28:20,931 - DEBUG - library.python.filelock - acquire: Acquiring filelock (blocking=False): /home/runner/.ya/build/port_sync_dir/28974 2024-07-01 12:28:20,931 - DEBUG - ya.test - get_binary: Binary was found by /home/runner/.ya/build/build_root/vf44/002461/ydb/apps/ydbd/ydbd 2024-07-01 12:28:20,932 - INFO - ydb.tests.library.harness.kikimr_runner - __make_run_command: CFG_DIR_PATH="/home/runner/.ya/build/build_root/vf44/002461/ydb/tests/fq/generic/test-results/py3test/testing_out_stuff/test_join.py__TestJoin__test_simple[v2-1-fq_client0-mvp_external_ydb_endpoint0]/cp/kikimr_configs" 2024-07-01 12:28:20,932 - INFO - ydb.tests.library.harness.kikimr_runner - __make_run_command: Final command: /home/runner/.ya/build/build_root/vf44/002461/ydb/apps/ydbd/ydbd server --suppress-version-check --node=1 --tenant=/cp --node-kind=yq --log-file-name=/home/runner/.ya/build/build_root/vf44/002461/ydb/tests/fq/generic/test-results/py3test/testing_out_stuff/test_join.py__TestJoin__test_simple[v2-1-fq_client0-mvp_external_ydb_endpoint0]/cp/node_1/logfile_x85yyztu.log --yaml-config=$CFG_DIR_PATH/config.yaml --grpc-port=14995 --mon-port=19059 --ic-port=10425 2024-07-01 12:28:20,933 - DEBUG - ya.test - execute: Executing '('/home/runner/.ya/build/build_root/vf44/002461/ydb/apps/ydbd/ydbd', 'server', '--suppress-version-check', '--node=1', '--tenant=/cp', '--node-kind=yq', '--log-file-name=/home/runner/.ya/build/build_root/vf44/002461/ydb/tests/fq/generic/test-results/py3test/testing_out_stuff/test_join.py__TestJoin__test_simple[v2-1-fq_client0-mvp_external_ydb_endpoint0]/cp/node_1/logfile_x85yyztu.log', '--yaml-config=/home/runner/.ya/build/build_root/vf44/002461/ydb/tests/fq/generic/test-results/py3test/testing_out_stuff/test_join.py__TestJoin__test_simple[v2-1-fq_client0-mvp_external_ydb_endpoint0]/cp/kikimr_configs/config.yaml', '--grpc-port=14995', '--mon-port=19059', '--ic-port=10425')' with input '/home/runner/.ya/build/build_root/vf44/002461/ydb/tests/fq/generic/test-results/py3test/stdin' in '/home/runner/.ya/build/build_root/vf44/002461/ydb/tests/fq/generic/test-results/py3test/testing_out_stuff/test_join.py__TestJoin__test_simple[v2-1-fq_client0-mvp_external_ydb_endpoint0]/cp/node_1' (no wait) 2024-07-01 12:28:20,934 - DEBUG - ya.test - execute: Command pid: 1340835 2024-07-01 12:28:20,935 - INFO - ydb.tests.library.harness.kikimr_runner - start: Started node localhost:14995/1 2024-07-01 12:28:20,935 - INFO - ydb.tests.library.harness.kikimr_runner - __run: Cluster started and initialized 2024-07-01 12:28:20,983 - DEBUG - library.python.filelock - acquire: Acquiring filelock (blocking=False): /home/runner/.ya/build/port_sync_dir/17024 2024-07-01 12:28:20,984 - DEBUG - library.python.filelock - acquire: Acquiring filelock (blocking=False): /home/runner/.ya/build/port_sync_dir/25602 2024-07-01 12:28:20,984 - DEBUG - ya.test - get_binary: Binary was found by /home/runner/.ya/build/build_root/vf44/002461/ydb/apps/ydbd/ydbd 2024-07-01 12:28:20,984 - INFO - ydb.tests.library.harness.kikimr_runner - __make_run_command: CFG_DIR_PATH="/home/runner/.ya/build/build_root/vf44/002461/ydb/tests/fq/generic/test-results/py3test/testing_out_stuff/test_join.py__TestJoin__test_simple[v2-1-fq_client0-mvp_external_ydb_endpoint0]/compute/kikimr_configs" 2024-07-01 12:28:20,985 - INFO - ydb.tests.library.harness.kikimr_runner - __make_run_command: Final command: /home/runner/.ya/build/build_root/vf44/002461/ydb/apps/ydbd/ydbd server --suppress-version-check --node=1 --log-file-name=/home/runner/.ya/build/build_root/vf44/002461/ydb/tests/fq/generic/test-results/py3test/testing_out_stuff/test_join.py__TestJoin__test_simple[v2-1-fq_client0-mvp_external_ydb_endpoint0]/compute/node_1/logfile_kaivzlsz.log --yaml-config=$CFG_DIR_PATH/config.yaml --grpc-port=23567 --mon-port=17024 --ic-port=2981 2024-07-01 12:28:20,985 - DEBUG - ya.test - execute: Executing '('/home/runner/.ya/build/build_root/vf44/002461/ydb/apps/ydbd/ydbd', 'server', '--suppress-version-check', '--node=1', '--log-file-name=/home/runner/.ya/build/build_root/vf44/002461/ydb/tests/fq/generic/test-results/py3test/testing_out_stuff/test_join.py__TestJoin__test_simple[v2-1-fq_client0-mvp_external_ydb_endpoint0]/compute/node_1/logfile_kaivzlsz.log', '--yaml-config=/home/runner/.ya/build/build_root/vf44/002461/ydb/tests/fq/generic/test-results/py3test/testing_out_stuff/test_join.py__TestJoin__test_simple[v2-1-fq_client0-mvp_external_ydb_endpoint0]/compute/kikimr_configs/config.yaml', '--grpc-port=23567', '--mon-port=17024', '--ic-port=2981')' with input '/home/runner/.ya/build/build_root/vf44/002461/ydb/tests/fq/generic/test-results/py3test/stdin' in '/home/runner/.ya/build/build_root/vf44/002461/ydb/tests/fq/generic/test-results/py3test/testing_out_stuff/test_join.py__TestJoin__test_simple[v2-1-fq_client0-mvp_external_ydb_endpoint0]/compute/node_1' (no wait) 2024-07-01 12:28:20,987 - DEBUG - ya.test - execute: Command pid: 1340836 2024-07-01 12:28:20,987 - INFO - ydb.tests.library.harness.kikimr_runner - start: Started node localhost:23567/1 2024-07-01 12:28:21,790 - DEBUG - ydb.resolver.DiscoveryEndpointsResolver - context_resolve: Preparing initial endpoint to resolve endpoints 2024-07-01 12:28:21,790 - DEBUG - ydb.connection - channel_factory: Channel options: [('grpc.max_receive_message_length', 64000000), ('grpc.max_send_message_length', 64000000), ('grpc.primary_user_agent', 'python-library'), ('grpc.lb_policy_name', 'round_robin')] 2024-07-01 12:28:21,794 - DEBUG - ydb.resolver.DiscoveryEndpointsResolver - context_resolve: Resolving endpoints for database local 2024-07-01 12:28:21,795 - DEBUG - ydb.connection - _prepare_call: RpcState(ListEndpoints, ecd907ba-b75d-4a29-9e56-98a1f7b85185, localhost:62132): creating call state 2024-07-01 12:28:21,796 - DEBUG - ydb.connection - _log_request: RpcState(ListEndpoints, ecd907ba-b75d-4a29-9e56-98a1f7b85185, localhost:62132): request = { database: "local" } 2024-07-01 12:28:21,798 - DEBUG - ydb.connection - _log_response: RpcState(ListEndpoints, ecd907ba-b75d-4a29-9e56-98a1f7b85185, localhost:62132): response = { operation { ready: true status: SUCCESS result { [type.googleapis.com/Ydb.Discovery.ListEndpointsResult] { endpoints { address: "fv4578birt7rdb95oc7v.auto.internal" port: 62132 service: "legacy" service: "yql" service: "discovery" service: "cms" service: "locking" service: "kesus" service: "pq" service: "pqcd" service: "pqv1" service: "topic" service: "datastreams" service: "scripting" service: "clickhouse_internal" service: "rate_limiter" service: "analytics" service: "export" service: "import" service: "yq" service: "keyvalue" service: "monitoring" service: "auth" service: "query_service" location: "1" node_id: 1 } self_location: "1" } } } } 2024-07-01 12:28:21,798 - DEBUG - ydb.resolver.DiscoveryEndpointsResolver - _add_debug_details: Resolved endpoints for database local: DiscoveryResult ]> 2024-07-01 12:28:21,798 - INFO - ydb.connection - close: Closing channel for endpoint localhost:62132 2024-07-01 12:28:22,734 - DEBUG - ya.test - get_binary: Binary was found by /home/runner/.ya/build/build_root/vf44/002461/ydb/apps/ydbd/ydbd 2024-07-01 12:28:22,735 - DEBUG - ya.test - _get_command_output_file: Command out will be placed to ydbd.out.2 2024-07-01 12:28:22,735 - DEBUG - ya.test - _get_command_output_file: Command err will be placed to ydbd.err.2 2024-07-01 12:28:22,736 - DEBUG - ya.test - execute: Executing '['/home/runner/.ya/build/build_root/vf44/002461/ydb/apps/ydbd/ydbd', '--server=grpc://localhost:23567', 'admin', 'blobstorage', 'config', 'invoke', '--proto=Command {\n DefineHostConfig {\n HostConfigId: 1\n Drive {\n Path: "SectorMap:1:64"\n }\n }\n}\nCommand {\n DefineBox {\n BoxId: 1\n Host {\n Key {\n Fqdn: "localhost"\n IcPort: 2981\n }\n HostConfigId: 1\n }\n }\n}\n']' in 'None' (waiting) 2024-07-01 12:28:22,736 - DEBUG - ya.test - execute: Command pid: 1341154 2024-07-01 12:28:22,900 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) rc: 0 2024-07-01 12:28:22,901 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) elapsed time (sec): 0.16319990158081055 2024-07-01 12:28:22,901 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) idrss: 0 2024-07-01 12:28:22,901 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) inblock: 0 2024-07-01 12:28:22,901 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) isrss: 0 2024-07-01 12:28:22,901 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) ixrss: 0 2024-07-01 12:28:22,901 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) majflt: 0 2024-07-01 12:28:22,901 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) maxrss: 181452 2024-07-01 12:28:22,902 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) minflt: 7944 2024-07-01 12:28:22,902 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) msgrcv: 0 2024-07-01 12:28:22,902 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) msgsnd: 0 2024-07-01 12:28:22,902 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) nivcsw: 0 2024-07-01 12:28:22,902 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) nsignals: 0 2024-07-01 12:28:22,902 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) nswap: 0 2024-07-01 12:28:22,902 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) nvcsw: 142 2024-07-01 12:28:22,903 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) oublock: 8 2024-07-01 12:28:22,903 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) stime: 0.025838 2024-07-01 12:28:22,903 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) utime: 0.09473999999999999 2024-07-01 12:28:22,903 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) wtime: 0.164 2024-07-01 12:28:22,903 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) output: Status { Success: true } Status { Success: true } Success: true ConfigTxSeqNo: 4 2024-07-01 12:28:22,905 - DEBUG - ya.test - _save_outputs: Command (pid 1341154) errors: 2024-07-01 12:28:22,906 - DEBUG - ya.test - get_binary: Binary was found by /home/runner/.ya/build/build_root/vf44/002461/ydb/apps/ydbd/ydbd 2024-07-01 12:28:22,907 - DEBUG - ya.test - _get_command_output_file: Command out will be placed to ydbd.out.3 2024-07-01 12:28:22,908 - DEBUG - ya.test - _get_command_output_file: Command err will be placed to ydbd.err.3 2024-07-01 12:28:22,908 - DEBUG - ya.test - execute: Executing '['/home/runner/.ya/build/build_root/vf44/002461/ydb/apps/ydbd/ydbd', '--server=grpc://localhost:23567', 'admin', 'blobstorage', 'config', 'invoke', '--proto=Command {\n DefineStoragePool {\n BoxId: 1\n StoragePoolId: 1\n Name: "dynamic_storage_pool:1"\n ErasureSpecies: "none"\n VDiskKind: "Default"\n Kind: "hdd"\n NumGroups: 2\n PDiskFilter {\n Property {\n Type: ROT\n }\n Property {\n Kind: 0\n }\n }\n }\n}\n']' in 'None' (waiting) 2024-07-01 12:28:22,909 - DEBUG - ya.test - execute: Command pid: 1341193 2024-07-01 12:28:23,080 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) rc: 0 2024-07-01 12:28:23,080 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) elapsed time (sec): 0.17064499855041504 2024-07-01 12:28:23,080 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) idrss: 0 2024-07-01 12:28:23,081 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) inblock: 0 2024-07-01 12:28:23,081 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) isrss: 0 2024-07-01 12:28:23,081 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) ixrss: 0 2024-07-01 12:28:23,081 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) majflt: 0 2024-07-01 12:28:23,081 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) maxrss: 181204 2024-07-01 12:28:23,081 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) minflt: 7950 2024-07-01 12:28:23,081 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) msgrcv: 0 2024-07-01 12:28:23,082 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) msgsnd: 0 2024-07-01 12:28:23,082 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) nivcsw: 0 2024-07-01 12:28:23,082 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) nsignals: 0 2024-07-01 12:28:23,082 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) nswap: 0 2024-07-01 12:28:23,082 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) nvcsw: 142 2024-07-01 12:28:23,082 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) oublock: 8 2024-07-01 12:28:23,082 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) stime: 0.039719 2024-07-01 12:28:23,083 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) utime: 0.087382 2024-07-01 12:28:23,083 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) wtime: 0.172 2024-07-01 12:28:23,083 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) output: Status { Success: true } Success: true ConfigTxSeqNo: 5 2024-07-01 12:28:23,083 - DEBUG - ya.test - _save_outputs: Command (pid 1341193) errors: 2024-07-01 12:28:23,084 - DEBUG - ya.test - get_binary: Binary was found by /home/runner/.ya/build/build_root/vf44/002461/ydb/apps/ydbd/ydbd 2024-07-01 12:28:23,085 - DEBUG - ya.test - _get_command_output_file: Command out will be placed to ydbd.out.4 2024-07-01 12:28:23,085 - DEBUG - ya.test - _get_command_output_file: Command err will be placed to ydbd.err.4 2024-07-01 12:28:23,085 - DEBUG - ya.test - execute: Executing '['/home/runner/.ya/build/build_root/vf44/002461/ydb/apps/ydbd/ydbd', '--server=grpc://localhost:23567', 'admin', 'blobstorage', 'config', 'invoke', '--proto=Command {\n DefineStoragePool {\n BoxId: 1\n StoragePoolId: 2\n Name: "dynamic_storage_pool:2"\n ErasureSpecies: "none"\n VDiskKind: "Default"\n Kind: "ssd"\n NumGroups: 2\n PDiskFilter {\n Property {\n Type: ROT\n }\n Property {\n Kind: 0\n }\n }\n }\n}\n']' in 'None' (waiting) 2024-07-01 12:28:23,086 - DEBUG - ya.test - execute: Command pid: 1341329 2024-07-01 12:28:23,264 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) rc: 0 2024-07-01 12:28:23,264 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) elapsed time (sec): 0.17748141288757324 2024-07-01 12:28:23,264 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) idrss: 0 2024-07-01 12:28:23,265 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) inblock: 0 2024-07-01 12:28:23,265 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) isrss: 0 2024-07-01 12:28:23,265 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) ixrss: 0 2024-07-01 12:28:23,265 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) majflt: 0 2024-07-01 12:28:23,265 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) maxrss: 181176 2024-07-01 12:28:23,265 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) minflt: 7947 2024-07-01 12:28:23,265 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) msgrcv: 0 2024-07-01 12:28:23,266 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) msgsnd: 0 2024-07-01 12:28:23,266 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) nivcsw: 0 2024-07-01 12:28:23,266 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) nsignals: 0 2024-07-01 12:28:23,266 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) nswap: 0 2024-07-01 12:28:23,266 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) nvcsw: 127 2024-07-01 12:28:23,266 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) oublock: 8 2024-07-01 12:28:23,266 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) stime: 0.034406 2024-07-01 12:28:23,267 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) utime: 0.099395 2024-07-01 12:28:23,267 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) wtime: 0.178 2024-07-01 12:28:23,267 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) output: Status { Success: true } Success: true ConfigTxSeqNo: 6 2024-07-01 12:28:23,267 - DEBUG - ya.test - _save_outputs: Command (pid 1341329) errors: 2024-07-01 12:28:23,275 - INFO - ydb.tests.library.harness.kikimr_runner - __run: Cluster started and initialized 2024-07-01 12:28:23,283 - INFO - ya.test - pytest_runtest_call: Test call (class_name: test_join.py::TestJoin, test_name: test_simple[v2-1-fq_client0-mvp_external_ydb_endpoint0]) 2024-07-01 12:28:24,914 - DEBUG - root - create_query_impl: Request: content { type: ANALYTICS name: "query_join_table" acl { visibility: PRIVATE } limits { execution_timeout { } } text: "\n SELECT pg.data AS data_pg, ch.data AS data_ch, ydb.data AS data_ydb\n FROM pg_conn_join_table.join_table AS pg\n JOIN ch_conn_join_table.join_table AS ch\n ON pg.id = ch.id\n JOIN ydb_conn_join_table.join_table AS ydb\n ON pg.id = ydb.id;\n " syntax: YQL_V1 } execute_mode: RUN idempotency_key: "85e34d23-8424-4b66-81c7-6b6e089344cc" 2024-07-01 12:28:25,053 - DEBUG - root - create_query_impl: Result: query_id: "ptquf3q523bs5ivabe2f" 2024-07-01 12:28:25,089 - DEBUG - root - describe_query: Result: query { meta { common { id: "ptquf3q523bs5ivabe2f" created_by: "root@builtin" modified_by: "root@builtin" created_at { seconds: 1719836904 nanos: 918843000 } modified_at { seconds: 1719836904 nanos: 918843000 } revision: 1 } execute_mode: RUN status: STARTING last_job_query_revision: 1 last_job_id: "ptjuf3q523bs47l8p3i8-ptquf3q523bs5ivabe2f" started_by: "root@builtin" submitted_at { seconds: 1719836904 nanos: 918843000 } } content { type: ANALYTICS name: "query_join_table" acl { visibility: PRIVATE } limits { execution_timeout { } } text: "\n SELECT pg.data AS data_pg, ch.data AS data_ch, ydb.data AS data_ydb\n FROM pg_conn_join_table.join_table AS pg\n JOIN ch_conn_join_table.join_table AS ch\n ON pg.id = ch.id\n JOIN ydb_conn_join_table.join_table AS ydb\n ON pg.id = ydb.id;\n " syntax: YQL_V1 } } 2024-07-01 12:28:25,596 - DEBUG - root - describe_query: Result: query { meta { common { id: "ptquf3q523bs5ivabe2f" created_by: "root@builtin" modified_by: "root@builtin" created_at { seconds: 1719836904 nanos: 918843000 } modified_at { seconds: 1719836904 nanos: 918843000 } revision: 1 } started_at { seconds: 1719836905 nanos: 486000000 } execute_mode: RUN status: STARTING last_job_query_revision: 1 last_job_id: "ptjuf3q523bs47l8p3i8-ptquf3q523bs5ivabe2f" started_by: "root@builtin" submitted_at { seconds: 1719836904 nanos: 918843000 } } content { type: ANALYTICS name: "query_join_table" acl { visibility: PRIVATE } limits { execution_timeout { } } text: "\n SELECT pg.data AS data_pg, ch.data AS data_ch, ydb.data AS data_ydb\n FROM pg_conn_join_table.join_table AS pg\n JOIN ch_conn_join_table.join_table AS ch\n ON pg.id = ch.id\n JOIN ydb_conn_join_table.join_table AS ydb\n ON pg.id = ydb.id;\n " syntax: YQL_V1 } } 2024-07-01 12:28:26,103 - DEBUG - root - describe_query: Result: query { meta { common { id: "ptquf3q523bs5ivabe2f" created_by: "root@builtin" modified_by: "root@builtin" created_at { seconds: 1719836904 nanos: 918843000 } modified_at { seconds: 1719836904 nanos: 918843000 } revision: 1 } started_at { seconds: 1719836905 nanos: 486000000 } execute_mode: RUN status: FAILING last_job_query_revision: 1 last_job_id: "ptjuf3q523bs47l8p3i8-ptquf3q523bs5ivabe2f" started_by: "root@builtin" submitted_at { seconds: 1719836904 nanos: 918843000 } } content { type: ANALYTICS name: "query_join_table" acl { visibility: PRIVATE } limits { execution_timeout { } } text: "\n SELECT pg.data AS data_pg, ch.data AS data_ch, ydb.data AS data_ydb\n FROM pg_conn_join_table.join_table AS pg\n JOIN ch_conn_join_table.join_table AS ch\n ON pg.id = ch.id\n JOIN ydb_conn_join_table.join_table AS ydb\n ON pg.id = ydb.id;\n " syntax: YQL_V1 } plan { json: "{}" } issue { message: "Query failed with code GENERIC_ERROR at 2024-07-01T12:28:26.050568Z" severity: 1 issues { message: "Execution" issue_code: 1060 severity: 1 issues { position { row: 3 column: 18 } message: "At function: KqpProgram" end_position { row: 3 column: 18 } severity: 1 issues { position { row: 3 column: 51 } message: "At function: FromFlow, At function: FlatMap, At function: ExtractMembers, At function: DqPhyMapJoin, At function: DqPhyMapJoin" end_position { row: 3 column: 51 } severity: 1 issues { position { row: 3 column: 51 } message: "Not comparable keys: pg.id and ydb.id, Optional != Block" end_position { row: 3 column: 51 } severity: 1 } } } issues { position { row: 3 column: 18 } message: "Peephole optimization failed for KQP transaction" end_position { row: 3 column: 18 } severity: 1 } } } statistics { json: "{}" } ast { data: "(\n(let $1 (DataSink \'\"kikimr\" \'\"db\"))\n(let $2 (Bool \'\"true\"))\n(let $3 (lambda \'($21) $2))\n(let $4 \'(\'\"pg\" \'\"id\"))\n(let $5 \'(\'Inner \'\"pg\" \'\"ch\" $4 \'(\'\"ch\" \'\"id\") \'()))\n(let $6 \'(\'Inner $5 \'\"ydb\" $4 \'(\'\"ydb\" \'\"id\") \'()))\n(let $7 \'(\'\"rename\" \'\"ch.data\" \'\"data_ch\"))\n(let $8 \'(\'\"rename\" \'\"ch.id\" \'\"\"))\n(let $9 \'(\'\"rename\" \'\"pg.data\" \'\"data_pg\"))\n(let $10 \'(\'\"rename\" \'\"pg.id\" \'\"\"))\n(let $11 \'(\'\"rename\" \'\"ydb.data\" \'\"data_ydb\"))\n(let $12 \'(\'\"rename\" \'\"ydb.id\" \'\"\"))\n(let $13 \'($7 $8 $9 $10 $11 $12))\n(let $14 (EquiJoin \'((Right! (GenReadTable! world (DataSource \'\"generic\" \'\"/local/pg_conn_join_table\") \'\"join_table\" (Void) $3)) \'\"pg\") \'((Right! (GenReadTable! world (DataSource \'\"generic\" \'\"/local/ch_conn_join_table\") \'\"join_table\" (Void) (lambda \'($22) $2))) \'\"ch\") \'((Right! (GenReadTable! world (DataSource \'\"generic\" \'\"/local/ydb_conn_join_table\") \'\"join_table\" (Void) $3)) \'\"ydb\") $6 $13))\n(let $15 \'(\'\"data_pg\" \'\"data_ch\" \'\"data_ydb\"))\n(let $16 \'(\'(\'\"mode\" \'\"flush\")))\n(let $17 (KiExecDataQuery! world $1 (DataQueryBlocks (TKiDataQueryBlock \'(\'($14 $15 \'0)) (KiEffects) \'() \'())) $16 (Void)))\n(let $18 (DataSink \'result))\n(let $19 \'(\'(\'type) \'(\'autoref) \'(\'columns $15)))\n(let $20 (ResPull! (Left! $17) $18 (Key) (Nth (Right! $17) \'0) $19 \'\"kikimr\"))\n(return (Commit! (Commit! $20 $18) $1 $16))\n)\n" } } 2024-07-01 12:28:26,609 - DEBUG - root - describe_query: Result: query { meta { common { id: "ptquf3q523bs5ivabe2f" created_by: "root@builtin" modified_by: "root@builtin" created_at { seconds: 1719836904 nanos: 918843000 } modified_at { seconds: 1719836904 nanos: 918843000 } revision: 1 } started_at { seconds: 1719836905 nanos: 486000000 } finished_at { seconds: 1719836906 nanos: 424000000 } execute_mode: RUN status: FAILED last_job_query_revision: 1 last_job_id: "ptjuf3q523bs47l8p3i8-ptquf3q523bs5ivabe2f" started_by: "root@builtin" submitted_at { seconds: 1719836904 nanos: 918843000 } } content { type: ANALYTICS name: "query_join_table" acl { visibility: PRIVATE } limits { execution_timeout { } } text: "\n SELECT pg.data AS data_pg, ch.data AS data_ch, ydb.data AS data_ydb\n FROM pg_conn_join_table.join_table AS pg\n JOIN ch_conn_join_table.join_table AS ch\n ON pg.id = ch.id\n JOIN ydb_conn_join_table.join_table AS ydb\n ON pg.id = ydb.id;\n " syntax: YQL_V1 } plan { json: "{}" } issue { message: "Query failed with code GENERIC_ERROR at 2024-07-01T12:28:26.050568Z" severity: 1 issues { message: "Execution" issue_code: 1060 severity: 1 issues { position { row: 3 column: 18 } message: "At function: KqpProgram" end_position { row: 3 column: 18 } severity: 1 issues { position { row: 3 column: 51 } message: "At function: FromFlow, At function: FlatMap, At function: ExtractMembers, At function: DqPhyMapJoin, At function: DqPhyMapJoin" end_position { row: 3 column: 51 } severity: 1 issues { position { row: 3 column: 51 } message: "Not comparable keys: pg.id and ydb.id, Optional != Block" end_position { row: 3 column: 51 } severity: 1 } } } issues { position { row: 3 column: 18 } message: "Peephole optimization failed for KQP transaction" end_position { row: 3 column: 18 } severity: 1 } } } statistics { json: "{}" } ast { data: "(\n(let $1 (DataSink \'\"kikimr\" \'\"db\"))\n(let $2 (Bool \'\"true\"))\n(let $3 (lambda \'($21) $2))\n(let $4 \'(\'\"pg\" \'\"id\"))\n(let $5 \'(\'Inner \'\"pg\" \'\"ch\" $4 \'(\'\"ch\" \'\"id\") \'()))\n(let $6 \'(\'Inner $5 \'\"ydb\" $4 \'(\'\"ydb\" \'\"id\") \'()))\n(let $7 \'(\'\"rename\" \'\"ch.data\" \'\"data_ch\"))\n(let $8 \'(\'\"rename\" \'\"ch.id\" \'\"\"))\n(let $9 \'(\'\"rename\" \'\"pg.data\" \'\"data_pg\"))\n(let $10 \'(\'\"rename\" \'\"pg.id\" \'\"\"))\n(let $11 \'(\'\"rename\" \'\"ydb.data\" \'\"data_ydb\"))\n(let $12 \'(\'\"rename\" \'\"ydb.id\" \'\"\"))\n(let $13 \'($7 $8 $9 $10 $11 $12))\n(let $14 (EquiJoin \'((Right! (GenReadTable! world (DataSource \'\"generic\" \'\"/local/pg_conn_join_table\") \'\"join_table\" (Void) $3)) \'\"pg\") \'((Right! (GenReadTable! world (DataSource \'\"generic\" \'\"/local/ch_conn_join_table\") \'\"join_table\" (Void) (lambda \'($22) $2))) \'\"ch\") \'((Right! (GenReadTable! world (DataSource \'\"generic\" \'\"/local/ydb_conn_join_table\") \'\"join_table\" (Void) $3)) \'\"ydb\") $6 $13))\n(let $15 \'(\'\"data_pg\" \'\"data_ch\" \'\"data_ydb\"))\n(let $16 \'(\'(\'\"mode\" \'\"flush\")))\n(let $17 (KiExecDataQuery! world $1 (DataQueryBlocks (TKiDataQueryBlock \'(\'($14 $15 \'0)) (KiEffects) \'() \'())) $16 (Void)))\n(let $18 (DataSink \'result))\n(let $19 \'(\'(\'type) \'(\'autoref) \'(\'columns $15)))\n(let $20 (ResPull! (Left! $17) $18 (Key) (Nth (Right! $17) \'0) $19 \'\"kikimr\"))\n(return (Commit! (Commit! $20 $18) $1 $16))\n)\n" } } 2024-07-01 12:28:26,880 - ERROR - ya.test - logreport: ydb/tests/fq/generic/test_join.py:54: in test_simple fq_client.wait_query_status(query_id, fq.QueryMeta.COMPLETED) ydb/tests/tools/fq_runner/fq_client.py:308: in wait_query_status return self.wait_query(query_id, timeout, statuses=statuses).query.meta.status ydb/tests/tools/fq_runner/fq_client.py:293: in wait_query assert time.time() < deadline and status not in final_statuses, \ E AssertionError: Query ptquf3q523bs5ivabe2f is not in expected status (['COMPLETED']) for already 1.5553905963897705 seconds. Query status: FAILED. Issues: [message: "Query failed with code GENERIC_ERROR at 2024-07-01T12:28:26.050568Z" E severity: 1 E issues { E message: "Execution" E issue_code: 1060 E severity: 1 E issues { E position { E row: 3 E column: 18 E } E message: "At function: KqpProgram" E end_position { E row: 3 E column: 18 E } E severity: 1 E issues { E position { E row: 3 E column: 51 E } E message: "At function: FromFlow, At function: FlatMap, At function: ExtractMembers, At function: DqPhyMapJoin, At function: DqPhyMapJoin" E end_position { E row: 3 E column: 51 E } E severity: 1 E issues { E position { E row: 3 E column: 51 E } E message: "Not comparable keys: pg.id and ydb.id, Optional != Block" E end_position { E row: 3 E column: 51 E } E severity: 1 E } E } E } E issues { E position { E row: 3 E column: 18 E } E message: "Peephole optimization failed for KQP transaction" E end_position { E row: 3 E column: 18 E } E severity: 1 E } E } E ]. Transient issues: [] 2024-07-01 12:28:26,883 - INFO - ya.test - pytest_runtest_teardown: Test teardown 2024-07-01 12:29:03,884 - INFO - ydb.tests.library.harness.kikimr_runner - stop: Stopped node localhost:14995/1 2024-07-01 12:29:03,885 - DEBUG - library.python.filelock - release: Ensuring filelock released: /home/runner/.ya/build/port_sync_dir/28974 2024-07-01 12:29:03,885 - DEBUG - library.python.filelock - release: Ensuring filelock released: /home/runner/.ya/build/port_sync_dir/19059 2024-07-01 12:29:03,885 - DEBUG - library.python.filelock - release: Ensuring filelock released: /home/runner/.ya/build/port_sync_dir/14995 2024-07-01 12:29:03,886 - DEBUG - library.python.filelock - release: Ensuring filelock released: /home/runner/.ya/build/port_sync_dir/10425 2024-07-01 12:29:03,886 - DEBUG - library.python.filelock - release: Ensuring filelock released: /home/runner/.ya/build/port_sync_dir/7970 2024-07-01 12:29:15,887 - INFO - ydb.tests.library.harness.kikimr_runner - stop: Stopped node localhost:23567/1 2024-07-01 12:29:15,887 - DEBUG - library.python.filelock - release: Ensuring filelock released: /home/runner/.ya/build/port_sync_dir/25602 2024-07-01 12:29:15,887 - DEBUG - library.python.filelock - release: Ensuring filelock released: /home/runner/.ya/build/port_sync_dir/17024 2024-07-01 12:29:15,888 - DEBUG - library.python.filelock - release: Ensuring filelock released: /home/runner/.ya/build/port_sync_dir/23567 2024-07-01 12:29:15,888 - DEBUG - library.python.filelock - release: Ensuring filelock released: /home/runner/.ya/build/port_sync_dir/2981