2025-11-14 10:14:08,692 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-14 10:14:08,692 - INFO - ya.test - pytest_runtest_setup: test_precompute_with_pg_binding[v1-pg_types-yql_syntax-client0]
2025-11-14 10:14:08,692 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-14 10:14:08,693 - INFO - ya.test - pytest_runtest_setup: Test setup
2025-11-14 10:14:08,818 - INFO - ya.test - pytest_runtest_call: Test call (class_name: test_format_setting.py::TestS3, test_name: test_precompute_with_pg_binding[v1-pg_types-yql_syntax-client0])
2025-11-14 10:14:08,820 - DEBUG - botocore.hooks - _emit: Event choose-service-name: calling handler <function handle_service_name_alias at 0x7facac218dd0>
2025-11-14 10:14:08,823 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_post at 0x7facac324ad0>
2025-11-14 10:14:08,823 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function lazy_call.<locals>._handler at 0x7facaab71250>
2025-11-14 10:14:08,823 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_url at 0x7facac3247d0>
2025-11-14 10:14:08,827 - DEBUG - botocore.endpoint - create_endpoint: Setting s3 timeout as (60, 60)
2025-11-14 10:14:08,832 - DEBUG - botocore.client - _register_legacy_retries: Registering retry handlers for service: s3
2025-11-14 10:14:08,833 - DEBUG - botocore.utils - register: Registering S3 region redirector handler
2025-11-14 10:14:08,835 - DEBUG - boto3.resources.factory - load_from_definition: Loading s3:s3
2025-11-14 10:14:08,836 - DEBUG - boto3.resources.factory - load_from_definition: Loading s3:Bucket
2025-11-14 10:14:08,837 - DEBUG - boto3.resources.model - _load_name_with_category: Renaming Bucket attribute name
2025-11-14 10:14:08,838 - DEBUG - botocore.hooks - _emit: Event creating-resource-class.s3.Bucket: calling handler <function lazy_call.<locals>._handler at 0x7facaab71cd0>
2025-11-14 10:14:08,839 - DEBUG - boto3.resources.action - __call__: Calling s3:create_bucket with {'Bucket': 'precompute_with_pg_binding_0_1', 'ACL': 'public-read'}
2025-11-14 10:14:08,840 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function validate_bucket_name at 0x7facac21ac90>
2025-11-14 10:14:08,840 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function remove_bucket_from_url_paths_from_model at 0x7facac23d550>
2025-11-14 10:14:08,840 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8d44b800>>
2025-11-14 10:14:08,840 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function generate_idempotent_uuid at 0x7facac21aa50>
2025-11-14 10:14:08,841 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7facac23d790>
2025-11-14 10:14:08,841 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8d44b800>>
2025-11-14 10:14:08,841 - DEBUG - botocore.regions - construct_endpoint: Calling endpoint provider with parameters: {'Bucket': 'precompute_with_pg_binding_0_1', 'Region': 'yandex', 'UseFIPS': False, 'UseDualStack': False, 'Endpoint': 'http://localhost:20364', 'ForcePathStyle': True, 'Accelerate': False, 'UseGlobalEndpoint': False, 'DisableAccessPoints': True, 'DisableMultiRegionAccessPoints': False, 'UseArnRegion': True}
2025-11-14 10:14:08,843 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:20364/precompute_with_pg_binding_0_1
2025-11-14 10:14:08,843 - DEBUG - botocore.regions - auth_schemes_to_signing_ctx: Selecting from endpoint provider's list of auth schemes: "sigv4". User selected auth scheme is: "None"
2025-11-14 10:14:08,843 - DEBUG - botocore.regions - auth_schemes_to_signing_ctx: Selected auth type "v4" as "v4" with signing context params: {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}
2025-11-14 10:14:08,845 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_expect_header at 0x7facac21b110>
2025-11-14 10:14:08,845 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_recursion_detection_header at 0x7facac219010>
2025-11-14 10:14:08,845 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function inject_api_version_header_if_needed at 0x7facac23cb90>
2025-11-14 10:14:08,846 - DEBUG - botocore.endpoint - make_request: Making request for OperationModel(name=CreateBucket) with params: {'url_path': '', 'query_string': {}, 'method': 'PUT', 'headers': {'x-amz-acl': 'public-read', 'User-Agent': 'Boto3/1.29.6 md/Botocore#1.31.80 ua/2.0 os/linux#5.15.0-157-generic md/arch#x86_64 lang/python#3.12.9 md/pyimpl#CPython cfg/retry-mode#legacy Botocore/1.31.80 Resource'}, 'body': b'', 'auth_path': '/precompute_with_pg_binding_0_1/', 'url': 'http://localhost:20364/precompute_with_pg_binding_0_1', 'context': {'client_region': 'yandex', 'client_config': <botocore.config.Config object at 0x7fac8dbc24f0>, 'has_streaming_input': False, 'auth_type': 'v4', 's3_redirect': {'redirected': False, 'bucket': 'precompute_with_pg_binding_0_1', 'params': {'Bucket': 'precompute_with_pg_binding_0_1', 'ACL': 'public-read'}}, 'signing': {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}}}
2025-11-14 10:14:08,846 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7fac8dbc19b0>>
2025-11-14 10:14:08,847 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.CreateBucket: calling handler <bound method ClientCreator._default_s3_presign_to_sigv2 of <botocore.client.ClientCreator object at 0x7fac8dafb3a0>>
2025-11-14 10:14:08,847 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.CreateBucket: calling handler <function set_operation_specific_signer at 0x7facac21a8d0>
2025-11-14 10:14:08,847 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.CreateBucket: calling handler <function remove_arn_from_signing_path at 0x7facac23d6d0>
2025-11-14 10:14:08,848 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-11-14 10:14:08,848 - DEBUG - botocore.auth - add_auth: CanonicalRequest:
PUT
/precompute_with_pg_binding_0_1

host:localhost:20364
x-amz-acl:public-read
x-amz-content-sha256:e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
x-amz-date:20251114T101408Z

host;x-amz-acl;x-amz-content-sha256;x-amz-date
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
2025-11-14 10:14:08,848 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251114T101408Z
20251114/yandex/s3/aws4_request
a2cbbc471a2b22d038d19bdd84359672c3f085b201ba73d392afc8f28769c5d0
2025-11-14 10:14:08,849 - DEBUG - botocore.auth - add_auth: Signature:
df0d7925a3b62509fc8a842d1efebd955239428aa4b92e7df16470ac9e6c6256
2025-11-14 10:14:08,849 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <function add_retry_headers at 0x7facac23d490>
2025-11-14 10:14:08,850 - DEBUG - botocore.endpoint - _do_get_response: Sending http request: <AWSPreparedRequest stream_output=False, method=PUT, url=http://localhost:20364/precompute_with_pg_binding_0_1, headers={'x-amz-acl': b'public-read', 'User-Agent': b'Boto3/1.29.6 md/Botocore#1.31.80 ua/2.0 os/linux#5.15.0-157-generic md/arch#x86_64 lang/python#3.12.9 md/pyimpl#CPython cfg/retry-mode#legacy Botocore/1.31.80 Resource', 'X-Amz-Date': b'20251114T101408Z', 'X-Amz-Content-SHA256': b'e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855', 'Authorization': b'AWS4-HMAC-SHA256 Credential=key/20251114/yandex/s3/aws4_request, SignedHeaders=host;x-amz-acl;x-amz-content-sha256;x-amz-date, Signature=df0d7925a3b62509fc8a842d1efebd955239428aa4b92e7df16470ac9e6c6256', 'amz-sdk-invocation-id': b'ffb6de4f-ff05-45c3-a7f2-13276b958045', 'amz-sdk-request': b'attempt=1', 'Content-Length': '0'}>
2025-11-14 10:14:08,867 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.9', 'Date': 'Fri, 14 Nov 2025 10:14:08 GMT', 'x-amzn-requestid': 'UtTdPhoXXPIbcVvmV2mpM6Gm4lwQ5myNV5xVA03g0PbdGiFRomgR', 'Content-Type': 'text/html; charset=utf-8', 'Content-Length': '184', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-11-14 10:14:08,868 - DEBUG - botocore.parsers - parse: Response body:
b'<CreateBucketResponse xmlns="http://s3.amazonaws.com/doc/2006-03-01"><CreateBucketResponse><Bucket>precompute_with_pg_binding_0_1</Bucket></CreateBucketResponse></CreateBucketResponse>'
2025-11-14 10:14:08,869 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <botocore.retryhandler.RetryHandler object at 0x7fac8d44a090>
2025-11-14 10:14:08,870 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-11-14 10:14:08,870 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8d44b800>>
2025-11-14 10:14:08,871 - DEBUG - boto3.resources.action - __call__: Response: {'ResponseMetadata': {'RequestId': 'UtTdPhoXXPIbcVvmV2mpM6Gm4lwQ5myNV5xVA03g0PbdGiFRomgR', 'HTTPStatusCode': 200, 'HTTPHeaders': {'server': 'Werkzeug/2.2.3 Python/3.12.9', 'date': 'Fri, 14 Nov 2025 10:14:08 GMT', 'x-amzn-requestid': 'UtTdPhoXXPIbcVvmV2mpM6Gm4lwQ5myNV5xVA03g0PbdGiFRomgR', 'content-type': 'text/html; charset=utf-8', 'content-length': '184', 'access-control-allow-origin': '*', 'connection': 'close'}, 'RetryAttempts': 0}}
2025-11-14 10:14:08,873 - DEBUG - botocore.hooks - _emit: Event choose-service-name: calling handler <function handle_service_name_alias at 0x7facac218dd0>
2025-11-14 10:14:08,877 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_post at 0x7facac324ad0>
2025-11-14 10:14:08,877 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function lazy_call.<locals>._handler at 0x7facaab71250>
2025-11-14 10:14:08,878 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_url at 0x7facac3247d0>
2025-11-14 10:14:08,883 - DEBUG - botocore.endpoint - create_endpoint: Setting s3 timeout as (60, 60)
2025-11-14 10:14:08,889 - DEBUG - botocore.client - _register_legacy_retries: Registering retry handlers for service: s3
2025-11-14 10:14:08,890 - DEBUG - botocore.utils - register: Registering S3 region redirector handler
2025-11-14 10:14:08,893 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function validate_ascii_metadata at 0x7facac21bd10>
2025-11-14 10:14:08,895 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function sse_md5 at 0x7facac21ad50>
2025-11-14 10:14:08,896 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function convert_body_to_file_like_object at 0x7facac23ca10>
2025-11-14 10:14:08,897 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function validate_bucket_name at 0x7facac21ac90>
2025-11-14 10:14:08,898 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function remove_bucket_from_url_paths_from_model at 0x7facac23d550>
2025-11-14 10:14:08,898 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8e0ac830>>
2025-11-14 10:14:08,900 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function generate_idempotent_uuid at 0x7facac21aa50>
2025-11-14 10:14:08,908 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7facac23d790>
2025-11-14 10:14:08,909 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8e0ac830>>
2025-11-14 10:14:08,910 - DEBUG - botocore.regions - construct_endpoint: Calling endpoint provider with parameters: {'Bucket': 'precompute_with_pg_binding_0_1', 'Region': 'yandex', 'UseFIPS': False, 'UseDualStack': False, 'Endpoint': 'http://localhost:20364', 'ForcePathStyle': True, 'Accelerate': False, 'UseGlobalEndpoint': False, 'DisableMultiRegionAccessPoints': False, 'UseArnRegion': True}
2025-11-14 10:14:08,912 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:20364/precompute_with_pg_binding_0_1
2025-11-14 10:14:08,913 - DEBUG - botocore.regions - auth_schemes_to_signing_ctx: Selecting from endpoint provider's list of auth schemes: "sigv4". User selected auth scheme is: "None"
2025-11-14 10:14:08,913 - DEBUG - botocore.regions - auth_schemes_to_signing_ctx: Selected auth type "v4" as "v4" with signing context params: {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}
2025-11-14 10:14:08,914 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function conditionally_calculate_md5 at 0x7facac42fc50>
2025-11-14 10:14:08,915 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function add_expect_header at 0x7facac21b110>
2025-11-14 10:14:08,915 - DEBUG - botocore.handlers - add_expect_header: Adding expect 100 continue header to request.
2025-11-14 10:14:08,916 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function add_recursion_detection_header at 0x7facac219010>
2025-11-14 10:14:08,916 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function inject_api_version_header_if_needed at 0x7facac23cb90>
2025-11-14 10:14:08,917 - DEBUG - botocore.endpoint - make_request: Making request for OperationModel(name=PutObject) with params: {'url_path': '/ids.json', 'query_string': {}, 'method': 'PUT', 'headers': {'Content-Type': 'text/json', 'User-Agent': 'Boto3/1.29.6 md/Botocore#1.31.80 ua/2.0 os/linux#5.15.0-157-generic md/arch#x86_64 lang/python#3.12.9 md/pyimpl#CPython cfg/retry-mode#legacy Botocore/1.31.80', 'Content-MD5': 'F5QO4ir2kM5lJMQThGj6zg==', 'Expect': '100-continue'}, 'body': <_io.BytesIO object at 0x7fac8d515550>, 'auth_path': '/precompute_with_pg_binding_0_1/ids.json', 'url': 'http://localhost:20364/precompute_with_pg_binding_0_1/ids.json', 'context': {'client_region': 'yandex', 'client_config': <botocore.config.Config object at 0x7fac8e0ac150>, 'has_streaming_input': True, 'auth_type': 'v4', 's3_redirect': {'redirected': False, 'bucket': 'precompute_with_pg_binding_0_1', 'params': {'Body': <_io.BytesIO object at 0x7fac8d515550>, 'Bucket': 'precompute_with_pg_binding_0_1', 'Key': 'ids.json', 'ContentType': 'text/json'}}, 'signing': {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}}}
2025-11-14 10:14:08,919 - DEBUG - botocore.hooks - _emit: Event request-created.s3.PutObject: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7fac8e0ad410>>
2025-11-14 10:14:08,920 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.PutObject: calling handler <bound method ClientCreator._default_s3_presign_to_sigv2 of <botocore.client.ClientCreator object at 0x7fac8d77c740>>
2025-11-14 10:14:08,921 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.PutObject: calling handler <function set_operation_specific_signer at 0x7facac21a8d0>
2025-11-14 10:14:08,922 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.PutObject: calling handler <function remove_arn_from_signing_path at 0x7facac23d6d0>
2025-11-14 10:14:08,923 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-11-14 10:14:08,923 - DEBUG - botocore.auth - add_auth: CanonicalRequest:
PUT
/precompute_with_pg_binding_0_1/ids.json

content-md5:F5QO4ir2kM5lJMQThGj6zg==
content-type:text/json
host:localhost:20364
x-amz-content-sha256:23d5479ba1b41412f1ca61194390157f97254b967a2edac8f0f72e50cdca59eb
x-amz-date:20251114T101408Z

content-md5;content-type;host;x-amz-content-sha256;x-amz-date
23d5479ba1b41412f1ca61194390157f97254b967a2edac8f0f72e50cdca59eb
2025-11-14 10:14:08,923 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251114T101408Z
20251114/yandex/s3/aws4_request
124d58255e52e07d5717f873cce38f3cc075f288b766d0ac67381822c594e144
2025-11-14 10:14:08,924 - DEBUG - botocore.auth - add_auth: Signature:
897bc6cdd3fb8b39e839daf884091d7dfc2dcf58c4b04b5a401aa13a08fb445b
2025-11-14 10:14:08,925 - DEBUG - botocore.hooks - _emit: Event request-created.s3.PutObject: calling handler <function add_retry_headers at 0x7facac23d490>
2025-11-14 10:14:08,926 - DEBUG - botocore.endpoint - _do_get_response: Sending http request: <AWSPreparedRequest stream_output=False, method=PUT, url=http://localhost:20364/precompute_with_pg_binding_0_1/ids.json, headers={'Content-Type': b'text/json', 'User-Agent': b'Boto3/1.29.6 md/Botocore#1.31.80 ua/2.0 os/linux#5.15.0-157-generic md/arch#x86_64 lang/python#3.12.9 md/pyimpl#CPython cfg/retry-mode#legacy Botocore/1.31.80', 'Content-MD5': b'F5QO4ir2kM5lJMQThGj6zg==', 'Expect': b'100-continue', 'X-Amz-Date': b'20251114T101408Z', 'X-Amz-Content-SHA256': b'23d5479ba1b41412f1ca61194390157f97254b967a2edac8f0f72e50cdca59eb', 'Authorization': b'AWS4-HMAC-SHA256 Credential=key/20251114/yandex/s3/aws4_request, SignedHeaders=content-md5;content-type;host;x-amz-content-sha256;x-amz-date, Signature=897bc6cdd3fb8b39e839daf884091d7dfc2dcf58c4b04b5a401aa13a08fb445b', 'amz-sdk-invocation-id': b'd5ef5dfb-601d-42e3-ae35-c1bb0d594093', 'amz-sdk-request': b'attempt=1', 'Content-Length': '10'}>
2025-11-14 10:14:08,929 - DEBUG - botocore.awsrequest - _send_output: Waiting for 100 Continue response.
2025-11-14 10:14:08,931 - DEBUG - botocore.awsrequest - _handle_expect_response: 100 Continue response seen, now sending request body.
2025-11-14 10:14:08,939 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.9', 'Date': 'Fri, 14 Nov 2025 10:14:08 GMT', 'ETag': '"17940ee22af690ce6524c4138468face"', 'last-modified': 'Fri, 14 Nov 2025 10:14:08 GMT', 'Content-Length': '0', 'x-amzn-requestid': 'pS8hZBTbpuPALRnkxbgat3bfeYH1hvoUqY8kQKRqd021c1qYYVu8', 'Content-Type': 'text/html; charset=utf-8', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-11-14 10:14:08,941 - DEBUG - botocore.parsers - parse: Response body:
b''
2025-11-14 10:14:08,942 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.PutObject: calling handler <botocore.retryhandler.RetryHandler object at 0x7fac8d4aeea0>
2025-11-14 10:14:08,943 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-11-14 10:14:08,943 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.PutObject: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8e0ac830>>
2025-11-14 10:14:09,011 - DEBUG - boto3.resources.action - __call__: Calling s3:create_bucket with {'Bucket': 'precompute_with_pg_binding_0_1', 'ACL': 'public-read'}
2025-11-14 10:14:09,012 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function validate_bucket_name at 0x7facac21ac90>
2025-11-14 10:14:09,012 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function remove_bucket_from_url_paths_from_model at 0x7facac23d550>
2025-11-14 10:14:09,012 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8d44b800>>
2025-11-14 10:14:09,013 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function generate_idempotent_uuid at 0x7facac21aa50>
2025-11-14 10:14:09,014 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7facac23d790>
2025-11-14 10:14:09,015 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8d44b800>>
2025-11-14 10:14:09,015 - DEBUG - botocore.regions - construct_endpoint: Calling endpoint provider with parameters: {'Bucket': 'precompute_with_pg_binding_0_1', 'Region': 'yandex', 'UseFIPS': False, 'UseDualStack': False, 'Endpoint': 'http://localhost:20364', 'ForcePathStyle': True, 'Accelerate': False, 'UseGlobalEndpoint': False, 'DisableAccessPoints': True, 'DisableMultiRegionAccessPoints': False, 'UseArnRegion': True}
2025-11-14 10:14:09,015 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:20364/precompute_with_pg_binding_0_1
2025-11-14 10:14:09,019 - DEBUG - botocore.regions - auth_schemes_to_signing_ctx: Selecting from endpoint provider's list of auth schemes: "sigv4". User selected auth scheme is: "None"
2025-11-14 10:14:09,020 - DEBUG - botocore.regions - auth_schemes_to_signing_ctx: Selected auth type "v4" as "v4" with signing context params: {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}
2025-11-14 10:14:09,021 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_expect_header at 0x7facac21b110>
2025-11-14 10:14:09,021 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_recursion_detection_header at 0x7facac219010>
2025-11-14 10:14:09,022 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function inject_api_version_header_if_needed at 0x7facac23cb90>
2025-11-14 10:14:09,022 - DEBUG - botocore.endpoint - make_request: Making request for OperationModel(name=CreateBucket) with params: {'url_path': '', 'query_string': {}, 'method': 'PUT', 'headers': {'x-amz-acl': 'public-read', 'User-Agent': 'Boto3/1.29.6 md/Botocore#1.31.80 ua/2.0 os/linux#5.15.0-157-generic md/arch#x86_64 lang/python#3.12.9 md/pyimpl#CPython cfg/retry-mode#legacy Botocore/1.31.80 Resource'}, 'body': b'', 'auth_path': '/precompute_with_pg_binding_0_1/', 'url': 'http://localhost:20364/precompute_with_pg_binding_0_1', 'context': {'client_region': 'yandex', 'client_config': <botocore.config.Config object at 0x7fac8dbc24f0>, 'has_streaming_input': False, 'auth_type': 'v4', 's3_redirect': {'redirected': False, 'bucket': 'precompute_with_pg_binding_0_1', 'params': {'Bucket': 'precompute_with_pg_binding_0_1', 'ACL': 'public-read'}}, 'signing': {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}}}
2025-11-14 10:14:09,023 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7fac8dbc19b0>>
2025-11-14 10:14:09,024 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.CreateBucket: calling handler <bound method ClientCreator._default_s3_presign_to_sigv2 of <botocore.client.ClientCreator object at 0x7fac8dafb3a0>>
2025-11-14 10:14:09,024 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.CreateBucket: calling handler <function set_operation_specific_signer at 0x7facac21a8d0>
2025-11-14 10:14:09,024 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.CreateBucket: calling handler <function remove_arn_from_signing_path at 0x7facac23d6d0>
2025-11-14 10:14:09,025 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-11-14 10:14:09,025 - DEBUG - botocore.auth - add_auth: CanonicalRequest:
PUT
/precompute_with_pg_binding_0_1

host:localhost:20364
x-amz-acl:public-read
x-amz-content-sha256:e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
x-amz-date:20251114T101409Z

host;x-amz-acl;x-amz-content-sha256;x-amz-date
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
2025-11-14 10:14:09,026 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251114T101409Z
20251114/yandex/s3/aws4_request
ccaacb4506c1d4020cce5e2a88a6022f5ebdd749f308ae09c610956ab83b742a
2025-11-14 10:14:09,026 - DEBUG - botocore.auth - add_auth: Signature:
a49af4074084c0ecf76b2b4c0aa80be3f885341ca4804751453777d8fd7f0f22
2025-11-14 10:14:09,027 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <function add_retry_headers at 0x7facac23d490>
2025-11-14 10:14:09,028 - DEBUG - botocore.endpoint - _do_get_response: Sending http request: <AWSPreparedRequest stream_output=False, method=PUT, url=http://localhost:20364/precompute_with_pg_binding_0_1, headers={'x-amz-acl': b'public-read', 'User-Agent': b'Boto3/1.29.6 md/Botocore#1.31.80 ua/2.0 os/linux#5.15.0-157-generic md/arch#x86_64 lang/python#3.12.9 md/pyimpl#CPython cfg/retry-mode#legacy Botocore/1.31.80 Resource', 'X-Amz-Date': b'20251114T101409Z', 'X-Amz-Content-SHA256': b'e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855', 'Authorization': b'AWS4-HMAC-SHA256 Credential=key/20251114/yandex/s3/aws4_request, SignedHeaders=host;x-amz-acl;x-amz-content-sha256;x-amz-date, Signature=a49af4074084c0ecf76b2b4c0aa80be3f885341ca4804751453777d8fd7f0f22', 'amz-sdk-invocation-id': b'e5a091f6-a518-45d0-810b-52ccaa482f8d', 'amz-sdk-request': b'attempt=1', 'Content-Length': '0'}>
2025-11-14 10:14:09,045 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.9', 'Date': 'Fri, 14 Nov 2025 10:14:09 GMT', 'x-amzn-requestid': 'xJ2ENtch6BaYgZ2STTZFl94Pf7CJzzMR3BJZxQ9jzwobZfrjQbpd', 'Content-Type': 'text/html; charset=utf-8', 'Content-Length': '184', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-11-14 10:14:09,045 - DEBUG - botocore.parsers - parse: Response body:
b'<CreateBucketResponse xmlns="http://s3.amazonaws.com/doc/2006-03-01"><CreateBucketResponse><Bucket>precompute_with_pg_binding_0_1</Bucket></CreateBucketResponse></CreateBucketResponse>'
2025-11-14 10:14:09,047 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <botocore.retryhandler.RetryHandler object at 0x7fac8d44a090>
2025-11-14 10:14:09,047 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-11-14 10:14:09,048 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8d44b800>>
2025-11-14 10:14:09,049 - DEBUG - boto3.resources.action - __call__: Response: {'ResponseMetadata': {'RequestId': 'xJ2ENtch6BaYgZ2STTZFl94Pf7CJzzMR3BJZxQ9jzwobZfrjQbpd', 'HTTPStatusCode': 200, 'HTTPHeaders': {'server': 'Werkzeug/2.2.3 Python/3.12.9', 'date': 'Fri, 14 Nov 2025 10:14:09 GMT', 'x-amzn-requestid': 'xJ2ENtch6BaYgZ2STTZFl94Pf7CJzzMR3BJZxQ9jzwobZfrjQbpd', 'content-type': 'text/html; charset=utf-8', 'content-length': '184', 'access-control-allow-origin': '*', 'connection': 'close'}, 'RetryAttempts': 0}}
2025-11-14 10:14:09,049 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function validate_ascii_metadata at 0x7facac21bd10>
2025-11-14 10:14:09,049 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function sse_md5 at 0x7facac21ad50>
2025-11-14 10:14:09,050 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function convert_body_to_file_like_object at 0x7facac23ca10>
2025-11-14 10:14:09,050 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function validate_bucket_name at 0x7facac21ac90>
2025-11-14 10:14:09,050 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function remove_bucket_from_url_paths_from_model at 0x7facac23d550>
2025-11-14 10:14:09,050 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8e0ac830>>
2025-11-14 10:14:09,051 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function generate_idempotent_uuid at 0x7facac21aa50>
2025-11-14 10:14:09,051 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7facac23d790>
2025-11-14 10:14:09,051 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8e0ac830>>
2025-11-14 10:14:09,052 - DEBUG - botocore.regions - construct_endpoint: Calling endpoint provider with parameters: {'Bucket': 'precompute_with_pg_binding_0_1', 'Region': 'yandex', 'UseFIPS': False, 'UseDualStack': False, 'Endpoint': 'http://localhost:20364', 'ForcePathStyle': True, 'Accelerate': False, 'UseGlobalEndpoint': False, 'DisableMultiRegionAccessPoints': False, 'UseArnRegion': True}
2025-11-14 10:14:09,052 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:20364/precompute_with_pg_binding_0_1
2025-11-14 10:14:09,052 - DEBUG - botocore.regions - auth_schemes_to_signing_ctx: Selecting from endpoint provider's list of auth schemes: "sigv4". User selected auth scheme is: "None"
2025-11-14 10:14:09,052 - DEBUG - botocore.regions - auth_schemes_to_signing_ctx: Selected auth type "v4" as "v4" with signing context params: {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}
2025-11-14 10:14:09,053 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function conditionally_calculate_md5 at 0x7facac42fc50>
2025-11-14 10:14:09,053 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function add_expect_header at 0x7facac21b110>
2025-11-14 10:14:09,054 - DEBUG - botocore.handlers - add_expect_header: Adding expect 100 continue header to request.
2025-11-14 10:14:09,054 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function add_recursion_detection_header at 0x7facac219010>
2025-11-14 10:14:09,054 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function inject_api_version_header_if_needed at 0x7facac23cb90>
2025-11-14 10:14:09,054 - DEBUG - botocore.endpoint - make_request: Making request for OperationModel(name=PutObject) with params: {'url_path': '/names.json', 'query_string': {}, 'method': 'PUT', 'headers': {'Content-Type': 'text/json', 'User-Agent': 'Boto3/1.29.6 md/Botocore#1.31.80 ua/2.0 os/linux#5.15.0-157-generic md/arch#x86_64 lang/python#3.12.9 md/pyimpl#CPython cfg/retry-mode#legacy Botocore/1.31.80', 'Content-MD5': 'dcOx6i4z718cLyXeAvp2aA==', 'Expect': '100-continue'}, 'body': <_io.BytesIO object at 0x7fac8d5141a0>, 'auth_path': '/precompute_with_pg_binding_0_1/names.json', 'url': 'http://localhost:20364/precompute_with_pg_binding_0_1/names.json', 'context': {'client_region': 'yandex', 'client_config': <botocore.config.Config object at 0x7fac8e0ac150>, 'has_streaming_input': True, 'auth_type': 'v4', 's3_redirect': {'redirected': False, 'bucket': 'precompute_with_pg_binding_0_1', 'params': {'Body': <_io.BytesIO object at 0x7fac8d5141a0>, 'Bucket': 'precompute_with_pg_binding_0_1', 'Key': 'names.json', 'ContentType': 'text/json'}}, 'signing': {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}}}
2025-11-14 10:14:09,055 - DEBUG - botocore.hooks - _emit: Event request-created.s3.PutObject: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7fac8e0ad410>>
2025-11-14 10:14:09,055 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.PutObject: calling handler <bound method ClientCreator._default_s3_presign_to_sigv2 of <botocore.client.ClientCreator object at 0x7fac8d77c740>>
2025-11-14 10:14:09,055 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.PutObject: calling handler <function set_operation_specific_signer at 0x7facac21a8d0>
2025-11-14 10:14:09,056 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.PutObject: calling handler <function remove_arn_from_signing_path at 0x7facac23d6d0>
2025-11-14 10:14:09,056 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-11-14 10:14:09,057 - DEBUG - botocore.auth - add_auth: CanonicalRequest:
PUT
/precompute_with_pg_binding_0_1/names.json

content-md5:dcOx6i4z718cLyXeAvp2aA==
content-type:text/json
host:localhost:20364
x-amz-content-sha256:1914cdbd73317565253f9702d35f1dc337d2e1d90ecb8a398a9a2e3486922633
x-amz-date:20251114T101409Z

content-md5;content-type;host;x-amz-content-sha256;x-amz-date
1914cdbd73317565253f9702d35f1dc337d2e1d90ecb8a398a9a2e3486922633
2025-11-14 10:14:09,057 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251114T101409Z
20251114/yandex/s3/aws4_request
c524d70212d744d5ef1710c83acd52eaa0f79fd659cd0f7fd2b4ffbc344af162
2025-11-14 10:14:09,057 - DEBUG - botocore.auth - add_auth: Signature:
593202e32e6759997a5b557dbb24447966c6202d3ef4affbc7ce545cb2d67331
2025-11-14 10:14:09,059 - DEBUG - botocore.hooks - _emit: Event request-created.s3.PutObject: calling handler <function add_retry_headers at 0x7facac23d490>
2025-11-14 10:14:09,060 - DEBUG - botocore.endpoint - _do_get_response: Sending http request: <AWSPreparedRequest stream_output=False, method=PUT, url=http://localhost:20364/precompute_with_pg_binding_0_1/names.json, headers={'Content-Type': b'text/json', 'User-Agent': b'Boto3/1.29.6 md/Botocore#1.31.80 ua/2.0 os/linux#5.15.0-157-generic md/arch#x86_64 lang/python#3.12.9 md/pyimpl#CPython cfg/retry-mode#legacy Botocore/1.31.80', 'Content-MD5': b'dcOx6i4z718cLyXeAvp2aA==', 'Expect': b'100-continue', 'X-Amz-Date': b'20251114T101409Z', 'X-Amz-Content-SHA256': b'1914cdbd73317565253f9702d35f1dc337d2e1d90ecb8a398a9a2e3486922633', 'Authorization': b'AWS4-HMAC-SHA256 Credential=key/20251114/yandex/s3/aws4_request, SignedHeaders=content-md5;content-type;host;x-amz-content-sha256;x-amz-date, Signature=593202e32e6759997a5b557dbb24447966c6202d3ef4affbc7ce545cb2d67331', 'amz-sdk-invocation-id': b'3d1dda4f-502f-47ef-a837-843717c484ca', 'amz-sdk-request': b'attempt=1', 'Content-Length': '64'}>
2025-11-14 10:14:09,068 - DEBUG - botocore.awsrequest - _send_output: Waiting for 100 Continue response.
2025-11-14 10:14:09,074 - DEBUG - botocore.awsrequest - _handle_expect_response: 100 Continue response seen, now sending request body.
2025-11-14 10:14:09,080 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.9', 'Date': 'Fri, 14 Nov 2025 10:14:09 GMT', 'ETag': '"75c3b1ea2e33ef5f1c2f25de02fa7668"', 'last-modified': 'Fri, 14 Nov 2025 10:14:09 GMT', 'Content-Length': '0', 'x-amzn-requestid': 'QbTxZAW28cdXtdx4Apb6fzIsvIXK588lzTD2LwdBLn0S26qeBCgB', 'Content-Type': 'text/html; charset=utf-8', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-11-14 10:14:09,081 - DEBUG - botocore.parsers - parse: Response body:
b''
2025-11-14 10:14:09,082 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.PutObject: calling handler <botocore.retryhandler.RetryHandler object at 0x7fac8d4aeea0>
2025-11-14 10:14:09,083 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-11-14 10:14:09,083 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.PutObject: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8e0ac830>>
2025-11-14 10:14:09,122 - DEBUG - root - wait_bootstrap: Wait for node 1 to bootstrap
2025-11-14 10:14:09,175 - DEBUG - root - wait_bootstrap: Node 1 has been bootstrapped
2025-11-14 10:14:09,175 - DEBUG - root - create_query_impl: Request: content {
  type: ANALYTICS
  name: "simple"
  acl {
    visibility: PRIVATE
  }
  limits {
    execution_timeout {
    }
  }
  text: "\n            SELECT *\n            FROM bindings.h5891467351756735416_test_precompute_with_pg_bindingbinding_for_names_0_1\n            WHERE id IN (\n                SELECT\n                    id\n                FROM bindings.h5891467351756735416_test_precompute_with_pg_bindingbinding_for_ids_0_1\n            )\n            "
  syntax: YQL_V1
}
execute_mode: RUN
idempotency_key: "f96ad230-69d6-49da-84af-93634e7fc485"

2025-11-14 10:14:09,207 - DEBUG - root - create_query_impl: Result: query_id: "ptqudseiutvlnuolhg1e"

2025-11-14 10:14:09,226 - DEBUG - root - describe_query: Result: query {
  meta {
    common {
      id: "ptqudseiutvlnuolhg1e"
      created_by: "root@builtin"
      modified_by: "root@builtin"
      created_at {
        seconds: 1763115249
        nanos: 182966000
      }
      modified_at {
        seconds: 1763115249
        nanos: 182966000
      }
      revision: 1
    }
    execute_mode: RUN
    status: STARTING
    last_job_query_revision: 1
    last_job_id: "ptjudseiutvlm774cbtg-ptqudseiutvlnuolhg1e"
    started_by: "root@builtin"
    submitted_at {
      seconds: 1763115249
      nanos: 182966000
    }
  }
  content {
    type: ANALYTICS
    name: "simple"
    acl {
      visibility: PRIVATE
    }
    limits {
      execution_timeout {
      }
    }
    text: "\n            SELECT *\n            FROM bindings.h5891467351756735416_test_precompute_with_pg_bindingbinding_for_names_0_1\n            WHERE id IN (\n                SELECT\n                    id\n                FROM bindings.h5891467351756735416_test_precompute_with_pg_bindingbinding_for_ids_0_1\n            )\n            "
    syntax: YQL_V1
  }
}

2025-11-14 10:14:09,747 - DEBUG - root - describe_query: Result: ... (repeated, see above) ...
2025-11-14 10:14:10,274 - DEBUG - root - describe_query: Result: query {
  meta {
    common {
      id: "ptqudseiutvlnuolhg1e"
      created_by: "root@builtin"
      modified_by: "root@builtin"
      created_at {
        seconds: 1763115249
        nanos: 182966000
      }
      modified_at {
        seconds: 1763115249
        nanos: 182966000
      }
      revision: 1
    }
    started_at {
      seconds: 1763115249
      nanos: 984000000
    }
    execute_mode: RUN
    status: RUNNING
    last_job_query_revision: 1
    last_job_id: "ptjudseiutvlm774cbtg-ptqudseiutvlnuolhg1e"
    started_by: "root@builtin"
    submitted_at {
      seconds: 1763115249
      nanos: 182966000
    }
  }
  content {
    type: ANALYTICS
    name: "simple"
    acl {
      visibility: PRIVATE
    }
    limits {
      execution_timeout {
      }
    }
    text: "\n            SELECT *\n            FROM bindings.h5891467351756735416_test_precompute_with_pg_bindingbinding_for_names_0_1\n            WHERE id IN (\n                SELECT\n                    id\n                FROM bindings.h5891467351756735416_test_precompute_with_pg_bindingbinding_for_ids_0_1\n            )\n            "
    syntax: YQL_V1
  }
  plan {
    json: "{\"Detailed\":{\"Operations\":[{\"Id\":10,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[{\"Name\":\"DqSourceWideWrap\"},{\"Name\":\"NarrowMap\"}]}},{\"Id\":19,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[{\"Name\":\"DqSourceWideWrap\"},{\"Name\":\"NarrowMap\"}]}},{\"Id\":17,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[]},\"DependsOn\":[19]},{\"Id\":8,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[{\"Name\":\"DqPhyMapJoin\"},{\"Name\":\"FlatMap\"}]},\"DependsOn\":[10,17]},{\"Id\":6,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[]},\"DependsOn\":[8]},{\"Id\":3,\"Name\":\"ResPull!\",\"DependsOn\":[6]},{\"Id\":1,\"Name\":\"Commit!\",\"DependsOn\":[3]}],\"OperationRoot\":1,\"Providers\":[],\"OperationStats\":{\"Commit!\":1,\"DqStage\":5,\"ResPull!\":1}},\"Basic\":{\"nodes\":[{\"id\":10,\"level\":1,\"name\":\"DqStage #10\",\"type\":\"op\"},{\"id\":19,\"level\":1,\"name\":\"DqStage #19\",\"type\":\"op\"},{\"id\":17,\"level\":2,\"name\":\"DqStage #17\",\"type\":\"op\"},{\"id\":8,\"level\":3,\"name\":\"DqStage #8\",\"type\":\"op\"},{\"id\":6,\"level\":4,\"name\":\"DqStage #6\",\"type\":\"op\"},{\"id\":3,\"level\":5,\"name\":\"ResPull!\",\"type\":\"op\"},{\"id\":1,\"level\":6,\"name\":\"Commit!\",\"type\":\"op\"}],\"links\":[{\"source\":19,\"target\":17},{\"source\":10,\"target\":8},{\"source\":17,\"target\":8},{\"source\":8,\"target\":6},{\"source\":6,\"target\":3},{\"source\":3,\"target\":1}]}}"
  }
  result_set_meta {
    column {
      name: "id"
      type {
        pg_type {
          oid: 23
          typlen: 4
          typmod: -1
          type_name: "pgint4"
        }
      }
    }
    column {
      name: "name"
      type {
        pg_type {
          oid: 25
          typlen: -1
          typmod: -1
          type_name: "pgtext"
        }
      }
    }
  }
  ast {
    data: "(\n(let $1 (Configure! world (DataSource \'\"config\") \'\"DqEngine\" \'\"force\"))\n(let $2 (DataSink \'result))\n(let $3 \'\"h5891467351756735416_test_precompute_with_pg_bindingprecompute_with_pg_0_1\")\n(let $4 (DataSource \'\"s3\" $3))\n(let $5 (Bool \'true))\n(let $6 \'\"cluster:default_h5891467351756735416_test_precompute_with_pg_bindingprecompute_with_pg_0_1\")\n(let $7 (SecureParam $6))\n(let $8 \'(\'\"id\" (PgType \'int4)))\n(let $9 (StructType $8 \'(\'\"name\" (PgType \'text))))\n(let $10 (S3ParseSettings world \'(\'((String \'\"Paths {\\n  Name: \\\"names.json\\\"\\n  Size: 64\\n  Read: true\\n}\\n\") $5 (AsStruct))) $7 \'\"\" \'\"names.json \" \'\"json_each_row\" $9 (lambda \'($20) $5) \'()))\n(let $11 \'(\'(\'format \'\"json_each_row\")))\n(let $12 (DqStage \'((DqSource $4 $10)) (lambda \'($21) (block \'(\n  (let $22 (DqSourceWideWrap $21 $4 $9 $11))\n  (return (NarrowMap $22 (lambda \'($23 $24) (AsStruct \'(\'\"id\" $23) \'(\'\"name\" $24)))))\n))) \'(\'(\'\"_logical_id\" \'200482))))\n(let $13 (StructType $8))\n(let $14 (S3ParseSettings world \'(\'((String \'\"Paths {\\n  Name: \\\"ids.json\\\"\\n  Size: 10\\n  Read: true\\n}\\n\") $5 (AsStruct))) $7 \'\"\" \'\"ids.json \" \'\"json_each_row\" $13 (lambda \'($25) $5) \'()))\n(let $15 (DqStage \'((DqSource $4 $14)) (lambda \'($26) (block \'(\n  (let $27 (DqSourceWideWrap $26 $4 $13 $11))\n  (return (NarrowMap $27 (lambda \'($28) (AsStruct \'(\'\"id\" $28)))))\n))) \'(\'(\'\"_logical_id\" \'200504))))\n(let $16 (DqStage \'((DqCnUnionAll (TDqOutput $15 \'\"0\"))) (lambda \'($29) $29) \'(\'(\'\"_logical_id\" \'200610))))\n(let $17 (DqStage \'((DqCnMap (TDqOutput $12 \'\"0\")) (DqCnBroadcast (TDqOutput $16 \'\"0\"))) (lambda \'($30 $31) (block \'(\n  (let $32 \'\"_yql_injoin_input.id\")\n  (let $33 (DqPhyMapJoin $30 $31 \'_yql_injoin_input \'_yql_injoin_0 \'LeftSemi \'(\'(\'_yql_injoin_input \'\"id\" \'_yql_injoin_0 \'\"id\")) \'($32) \'(\'\"_yql_injoin_0.id\")))\n  (return (FlatMap $33 (lambda \'($34) (Just (AsStruct \'(\'\"id\" (Member $34 $32)) \'(\'\"name\" (Member $34 \'\"_yql_injoin_input.name\")))))))\n))) \'(\'(\'\"_logical_id\" \'200686))))\n(let $18 (DqStage \'((DqCnUnionAll (TDqOutput $17 \'\"0\"))) (lambda \'($35) $35) \'(\'(\'\"_logical_id\" \'200758))))\n(let $19 (ResPull! $1 $2 (Key) (DqCnResult (TDqOutput $18 \'\"0\") \'()) \'(\'(\'type) \'(\'autoref)) \'\"dq\"))\n(return (Commit! (Commit! $19 $2) (DataSink \'\"s3\" $3)))\n)\n"
  }
}

2025-11-14 10:14:10,787 - DEBUG - root - describe_query: Result: query {
  meta {
    common {
      id: "ptqudseiutvlnuolhg1e"
      created_by: "root@builtin"
      modified_by: "root@builtin"
      created_at {
        seconds: 1763115249
        nanos: 182966000
      }
      modified_at {
        seconds: 1763115249
        nanos: 182966000
      }
      revision: 1
    }
    started_at {
      seconds: 1763115249
      nanos: 984000000
    }
    finished_at {
      seconds: 1763115250
      nanos: 281000000
    }
    execute_mode: RUN
    status: COMPLETED
    last_job_query_revision: 1
    last_job_id: "ptjudseiutvlm774cbtg-ptqudseiutvlnuolhg1e"
    result_expire_at {
      seconds: 1763201649
      nanos: 961832000
    }
    started_by: "root@builtin"
    submitted_at {
      seconds: 1763115249
      nanos: 182966000
    }
  }
  content {
    type: ANALYTICS
    name: "simple"
    acl {
      visibility: PRIVATE
    }
    limits {
      execution_timeout {
      }
    }
    text: "\n            SELECT *\n            FROM bindings.h5891467351756735416_test_precompute_with_pg_bindingbinding_for_names_0_1\n            WHERE id IN (\n                SELECT\n                    id\n                FROM bindings.h5891467351756735416_test_precompute_with_pg_bindingbinding_for_ids_0_1\n            )\n            "
    syntax: YQL_V1
  }
  plan {
    json: "{\"Detailed\":{\"Operations\":[{\"Id\":10,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[{\"Name\":\"DqSourceWideWrap\"},{\"Name\":\"NarrowMap\"}]}},{\"Id\":19,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[{\"Name\":\"DqSourceWideWrap\"},{\"Name\":\"NarrowMap\"}]}},{\"Id\":17,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[]},\"DependsOn\":[19]},{\"Id\":8,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[{\"Name\":\"DqPhyMapJoin\"},{\"Name\":\"FlatMap\"}]},\"DependsOn\":[10,17]},{\"Id\":6,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[]},\"DependsOn\":[8]},{\"Id\":3,\"Name\":\"ResPull!\",\"DependsOn\":[6]},{\"Id\":1,\"Name\":\"Commit!\",\"DependsOn\":[3]}],\"OperationRoot\":1,\"Providers\":[],\"OperationStats\":{\"Commit!\":1,\"DqStage\":5,\"ResPull!\":1}},\"Basic\":{\"nodes\":[{\"id\":10,\"level\":1,\"name\":\"DqStage #10\",\"type\":\"op\"},{\"id\":19,\"level\":1,\"name\":\"DqStage #19\",\"type\":\"op\"},{\"id\":17,\"level\":2,\"name\":\"DqStage #17\",\"type\":\"op\"},{\"id\":8,\"level\":3,\"name\":\"DqStage #8\",\"type\":\"op\"},{\"id\":6,\"level\":4,\"name\":\"DqStage #6\",\"type\":\"op\"},{\"id\":3,\"level\":5,\"name\":\"ResPull!\",\"type\":\"op\"},{\"id\":1,\"level\":6,\"name\":\"Commit!\",\"type\":\"op\"}],\"links\":[{\"source\":19,\"target\":17},{\"source\":10,\"target\":8},{\"source\":17,\"target\":8},{\"source\":8,\"target\":6},{\"source\":6,\"target\":3},{\"source\":3,\"target\":1}]}}"
  }
  statistics {
    json: "{\"Graph=0\":{\"Tasks\":{\"sum\":5,\"count\":5,\"avg\":1,\"max\":1,\"min\":1},\"CpuTimeUs\":{\"sum\":\"0.25s\",\"count\":5,\"avg\":\"51ms\",\"max\":\"0.11s\",\"min\":\"2ms\"},\"IngressBytes\":{\"sum\":74,\"count\":2,\"avg\":37,\"max\":64,\"min\":10},\"IngressRows\":{\"sum\":3,\"count\":2,\"avg\":1,\"max\":2,\"min\":1},\"InputBytes\":{\"sum\":43,\"count\":3,\"avg\":14,\"max\":26,\"min\":4},\"InputRows\":{\"sum\":5,\"count\":3,\"avg\":1,\"max\":3,\"min\":1},\"OutputBytes\":{\"sum\":56,\"count\":5,\"avg\":11,\"max\":22,\"min\":4},\"OutputRows\":{\"sum\":6,\"count\":5,\"avg\":1,\"max\":2,\"min\":1},\"ResultBytes\":{\"sum\":13,\"count\":1,\"avg\":13,\"max\":13,\"min\":13},\"ResultRows\":{\"sum\":1,\"count\":1,\"avg\":1,\"max\":1,\"min\":1},\"MaxMemoryUsage\":{\"sum\":786432,\"count\":5,\"avg\":157286,\"max\":262144,\"min\":131072},\"IngressQueuedBytes\":{\"sum\":0,\"count\":5,\"avg\":0,\"max\":0,\"min\":0},\"IngressQueuedRows\":{\"sum\":0,\"count\":5,\"avg\":0,\"max\":0,\"min\":0}}}"
  }
  result_set_meta {
    column {
      name: "id"
      type {
        pg_type {
          oid: 23
          typlen: 4
          typmod: -1
          type_name: "pgint4"
        }
      }
    }
    column {
      name: "name"
      type {
        pg_type {
          oid: 25
          typlen: -1
          typmod: -1
          type_name: "pgtext"
        }
      }
    }
    rows_count: 1
  }
  ast {
    data: "(\n(let $1 (Configure! world (DataSource \'\"config\") \'\"DqEngine\" \'\"force\"))\n(let $2 (DataSink \'result))\n(let $3 \'\"h5891467351756735416_test_precompute_with_pg_bindingprecompute_with_pg_0_1\")\n(let $4 (DataSource \'\"s3\" $3))\n(let $5 (Bool \'true))\n(let $6 \'\"cluster:default_h5891467351756735416_test_precompute_with_pg_bindingprecompute_with_pg_0_1\")\n(let $7 (SecureParam $6))\n(let $8 \'(\'\"id\" (PgType \'int4)))\n(let $9 (StructType $8 \'(\'\"name\" (PgType \'text))))\n(let $10 (S3ParseSettings world \'(\'((String \'\"Paths {\\n  Name: \\\"names.json\\\"\\n  Size: 64\\n  Read: true\\n}\\n\") $5 (AsStruct))) $7 \'\"\" \'\"names.json \" \'\"json_each_row\" $9 (lambda \'($20) $5) \'()))\n(let $11 \'(\'(\'format \'\"json_each_row\")))\n(let $12 (DqStage \'((DqSource $4 $10)) (lambda \'($21) (block \'(\n  (let $22 (DqSourceWideWrap $21 $4 $9 $11))\n  (return (NarrowMap $22 (lambda \'($23 $24) (AsStruct \'(\'\"id\" $23) \'(\'\"name\" $24)))))\n))) \'(\'(\'\"_logical_id\" \'200482))))\n(let $13 (StructType $8))\n(let $14 (S3ParseSettings world \'(\'((String \'\"Paths {\\n  Name: \\\"ids.json\\\"\\n  Size: 10\\n  Read: true\\n}\\n\") $5 (AsStruct))) $7 \'\"\" \'\"ids.json \" \'\"json_each_row\" $13 (lambda \'($25) $5) \'()))\n(let $15 (DqStage \'((DqSource $4 $14)) (lambda \'($26) (block \'(\n  (let $27 (DqSourceWideWrap $26 $4 $13 $11))\n  (return (NarrowMap $27 (lambda \'($28) (AsStruct \'(\'\"id\" $28)))))\n))) \'(\'(\'\"_logical_id\" \'200504))))\n(let $16 (DqStage \'((DqCnUnionAll (TDqOutput $15 \'\"0\"))) (lambda \'($29) $29) \'(\'(\'\"_logical_id\" \'200610))))\n(let $17 (DqStage \'((DqCnMap (TDqOutput $12 \'\"0\")) (DqCnBroadcast (TDqOutput $16 \'\"0\"))) (lambda \'($30 $31) (block \'(\n  (let $32 \'\"_yql_injoin_input.id\")\n  (let $33 (DqPhyMapJoin $30 $31 \'_yql_injoin_input \'_yql_injoin_0 \'LeftSemi \'(\'(\'_yql_injoin_input \'\"id\" \'_yql_injoin_0 \'\"id\")) \'($32) \'(\'\"_yql_injoin_0.id\")))\n  (return (FlatMap $33 (lambda \'($34) (Just (AsStruct \'(\'\"id\" (Member $34 $32)) \'(\'\"name\" (Member $34 \'\"_yql_injoin_input.name\")))))))\n))) \'(\'(\'\"_logical_id\" \'200686))))\n(let $18 (DqStage \'((DqCnUnionAll (TDqOutput $17 \'\"0\"))) (lambda \'($35) $35) \'(\'(\'\"_logical_id\" \'200758))))\n(let $19 (ResPull! $1 $2 (Key) (DqCnResult (TDqOutput $18 \'\"0\") \'()) \'(\'(\'type) \'(\'autoref)) \'\"dq\"))\n(return (Commit! (Commit! $19 $2) (DataSink \'\"s3\" $3)))\n)\n"
  }
}

2025-11-14 10:14:10,802 - DEBUG - root - test_precompute_with_pg_binding: columns {
  name: "id"
  type {
    pg_type {
      oid: 23
      typlen: 4
      typmod: -1
      type_name: "pgint4"
    }
  }
}
columns {
  name: "name"
  type {
    pg_type {
      oid: 25
      typlen: -1
      typmod: -1
      type_name: "pgtext"
    }
  }
}
rows {
  items {
    text_value: "42"
  }
  items {
    text_value: "hello"
  }
}

2025-11-14 10:14:10,806 - INFO - ya.test - pytest_runtest_teardown: Test teardown
2025-11-14 10:17:41,864 - DEBUG - ya.test - _verify_test: Verifying [test_format_setting.TestS3.test_precompute_with_pg_binding[v1-pg_types-yql_syntax-client0] in ydb/tests/fq/s3] canonical results
2025-11-14 10:17:41,864 - DEBUG - ya.test - verify: Test test_format_setting.TestS3.test_precompute_with_pg_binding[v1-pg_types-yql_syntax-client0] status: good
