2025-11-14 10:14:10,916 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-14 10:14:10,916 - INFO - ya.test - pytest_runtest_setup: test_precompute_with_pg_binding[v1-pg_types-pg_syntax-client0]
2025-11-14 10:14:10,916 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-14 10:14:10,916 - INFO - ya.test - pytest_runtest_setup: Test setup
2025-11-14 10:14:11,029 - 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-pg_syntax-client0])
2025-11-14 10:14:11,030 - DEBUG - botocore.hooks - _emit: Event choose-service-name: calling handler <function handle_service_name_alias at 0x7facac218dd0>
2025-11-14 10:14:11,033 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_post at 0x7facac324ad0>
2025-11-14 10:14:11,033 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function lazy_call.<locals>._handler at 0x7facaab71250>
2025-11-14 10:14:11,033 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_url at 0x7facac3247d0>
2025-11-14 10:14:11,037 - DEBUG - botocore.endpoint - create_endpoint: Setting s3 timeout as (60, 60)
2025-11-14 10:14:11,041 - DEBUG - botocore.client - _register_legacy_retries: Registering retry handlers for service: s3
2025-11-14 10:14:11,042 - DEBUG - botocore.utils - register: Registering S3 region redirector handler
2025-11-14 10:14:11,044 - DEBUG - boto3.resources.factory - load_from_definition: Loading s3:s3
2025-11-14 10:14:11,046 - DEBUG - boto3.resources.factory - load_from_definition: Loading s3:Bucket
2025-11-14 10:14:11,046 - DEBUG - boto3.resources.model - _load_name_with_category: Renaming Bucket attribute name
2025-11-14 10:14:11,048 - DEBUG - botocore.hooks - _emit: Event creating-resource-class.s3.Bucket: calling handler <function lazy_call.<locals>._handler at 0x7facaab71cd0>
2025-11-14 10:14:11,049 - DEBUG - boto3.resources.action - __call__: Calling s3:create_bucket with {'Bucket': 'precompute_with_pg_binding_1_1', 'ACL': 'public-read'}
2025-11-14 10:14:11,050 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function validate_bucket_name at 0x7facac21ac90>
2025-11-14 10:14:11,051 - 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:11,051 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8dacd690>>
2025-11-14 10:14:11,052 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function generate_idempotent_uuid at 0x7facac21aa50>
2025-11-14 10:14:11,052 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7facac23d790>
2025-11-14 10:14:11,053 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8dacd690>>
2025-11-14 10:14:11,054 - DEBUG - botocore.regions - construct_endpoint: Calling endpoint provider with parameters: {'Bucket': 'precompute_with_pg_binding_1_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:11,055 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:20364/precompute_with_pg_binding_1_1
2025-11-14 10:14:11,055 - 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:11,056 - 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:11,057 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_expect_header at 0x7facac21b110>
2025-11-14 10:14:11,057 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_recursion_detection_header at 0x7facac219010>
2025-11-14 10:14:11,058 - 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:11,058 - 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_1_1/', 'url': 'http://localhost:20364/precompute_with_pg_binding_1_1', 'context': {'client_region': 'yandex', 'client_config': <botocore.config.Config object at 0x7fac8d77cab0>, 'has_streaming_input': False, 'auth_type': 'v4', 's3_redirect': {'redirected': False, 'bucket': 'precompute_with_pg_binding_1_1', 'params': {'Bucket': 'precompute_with_pg_binding_1_1', 'ACL': 'public-read'}}, 'signing': {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}}}
2025-11-14 10:14:11,059 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7fac8d77c6a0>>
2025-11-14 10:14:11,060 - 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 0x7fac8dbae950>>
2025-11-14 10:14:11,061 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.CreateBucket: calling handler <function set_operation_specific_signer at 0x7facac21a8d0>
2025-11-14 10:14:11,062 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.CreateBucket: calling handler <function remove_arn_from_signing_path at 0x7facac23d6d0>
2025-11-14 10:14:11,063 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-11-14 10:14:11,063 - DEBUG - botocore.auth - add_auth: CanonicalRequest:
PUT
/precompute_with_pg_binding_1_1

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

host;x-amz-acl;x-amz-content-sha256;x-amz-date
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
2025-11-14 10:14:11,063 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251114T101411Z
20251114/yandex/s3/aws4_request
50dcc446db182b5b424257ec2309be7ce003066f506ed4c30b90de973372451c
2025-11-14 10:14:11,064 - DEBUG - botocore.auth - add_auth: Signature:
a7344df304702eff1a052954406a8b8ea11d17b6f274a719212a1d4ab8e1b23d
2025-11-14 10:14:11,065 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <function add_retry_headers at 0x7facac23d490>
2025-11-14 10:14:11,066 - DEBUG - botocore.endpoint - _do_get_response: Sending http request: <AWSPreparedRequest stream_output=False, method=PUT, url=http://localhost:20364/precompute_with_pg_binding_1_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'20251114T101411Z', '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=a7344df304702eff1a052954406a8b8ea11d17b6f274a719212a1d4ab8e1b23d', 'amz-sdk-invocation-id': b'2d7ccca5-6e63-41ed-ab07-e56db444b69b', 'amz-sdk-request': b'attempt=1', 'Content-Length': '0'}>
2025-11-14 10:14:11,081 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.9', 'Date': 'Fri, 14 Nov 2025 10:14:11 GMT', 'x-amzn-requestid': 'RW2gGxd1loCS1tO79BrqDxvQ5XHQS1QjVX0HX2WyCvXIqaRM7DzC', 'Content-Type': 'text/html; charset=utf-8', 'Content-Length': '184', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-11-14 10:14:11,082 - DEBUG - botocore.parsers - parse: Response body:
b'<CreateBucketResponse xmlns="http://s3.amazonaws.com/doc/2006-03-01"><CreateBucketResponse><Bucket>precompute_with_pg_binding_1_1</Bucket></CreateBucketResponse></CreateBucketResponse>'
2025-11-14 10:14:11,083 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <botocore.retryhandler.RetryHandler object at 0x7fac8d7c90f0>
2025-11-14 10:14:11,084 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-11-14 10:14:11,084 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8dacd690>>
2025-11-14 10:14:11,084 - DEBUG - boto3.resources.action - __call__: Response: {'ResponseMetadata': {'RequestId': 'RW2gGxd1loCS1tO79BrqDxvQ5XHQS1QjVX0HX2WyCvXIqaRM7DzC', 'HTTPStatusCode': 200, 'HTTPHeaders': {'server': 'Werkzeug/2.2.3 Python/3.12.9', 'date': 'Fri, 14 Nov 2025 10:14:11 GMT', 'x-amzn-requestid': 'RW2gGxd1loCS1tO79BrqDxvQ5XHQS1QjVX0HX2WyCvXIqaRM7DzC', 'content-type': 'text/html; charset=utf-8', 'content-length': '184', 'access-control-allow-origin': '*', 'connection': 'close'}, 'RetryAttempts': 0}}
2025-11-14 10:14:11,085 - DEBUG - botocore.hooks - _emit: Event choose-service-name: calling handler <function handle_service_name_alias at 0x7facac218dd0>
2025-11-14 10:14:11,087 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_post at 0x7facac324ad0>
2025-11-14 10:14:11,088 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function lazy_call.<locals>._handler at 0x7facaab71250>
2025-11-14 10:14:11,088 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_url at 0x7facac3247d0>
2025-11-14 10:14:11,091 - DEBUG - botocore.endpoint - create_endpoint: Setting s3 timeout as (60, 60)
2025-11-14 10:14:11,096 - DEBUG - botocore.client - _register_legacy_retries: Registering retry handlers for service: s3
2025-11-14 10:14:11,097 - DEBUG - botocore.utils - register: Registering S3 region redirector handler
2025-11-14 10:14:11,100 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function validate_ascii_metadata at 0x7facac21bd10>
2025-11-14 10:14:11,100 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function sse_md5 at 0x7facac21ad50>
2025-11-14 10:14:11,100 - 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:11,100 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function validate_bucket_name at 0x7facac21ac90>
2025-11-14 10:14:11,101 - 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:11,101 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8e321aa0>>
2025-11-14 10:14:11,101 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function generate_idempotent_uuid at 0x7facac21aa50>
2025-11-14 10:14:11,101 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7facac23d790>
2025-11-14 10:14:11,102 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8e321aa0>>
2025-11-14 10:14:11,102 - DEBUG - botocore.regions - construct_endpoint: Calling endpoint provider with parameters: {'Bucket': 'precompute_with_pg_binding_1_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:11,103 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:20364/precompute_with_pg_binding_1_1
2025-11-14 10:14:11,103 - 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:11,104 - 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:11,104 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function conditionally_calculate_md5 at 0x7facac42fc50>
2025-11-14 10:14:11,105 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function add_expect_header at 0x7facac21b110>
2025-11-14 10:14:11,105 - DEBUG - botocore.handlers - add_expect_header: Adding expect 100 continue header to request.
2025-11-14 10:14:11,106 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function add_recursion_detection_header at 0x7facac219010>
2025-11-14 10:14:11,107 - 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:11,107 - 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 0x7fac8d515c50>, 'auth_path': '/precompute_with_pg_binding_1_1/ids.json', 'url': 'http://localhost:20364/precompute_with_pg_binding_1_1/ids.json', 'context': {'client_region': 'yandex', 'client_config': <botocore.config.Config object at 0x7fac8e4e1a00>, 'has_streaming_input': True, 'auth_type': 'v4', 's3_redirect': {'redirected': False, 'bucket': 'precompute_with_pg_binding_1_1', 'params': {'Body': <_io.BytesIO object at 0x7fac8d515c50>, 'Bucket': 'precompute_with_pg_binding_1_1', 'Key': 'ids.json', 'ContentType': 'text/json'}}, 'signing': {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}}}
2025-11-14 10:14:11,109 - DEBUG - botocore.hooks - _emit: Event request-created.s3.PutObject: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7fac8e4e3c60>>
2025-11-14 10:14:11,109 - 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 0x7fac8e03c1f0>>
2025-11-14 10:14:11,110 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.PutObject: calling handler <function set_operation_specific_signer at 0x7facac21a8d0>
2025-11-14 10:14:11,110 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.PutObject: calling handler <function remove_arn_from_signing_path at 0x7facac23d6d0>
2025-11-14 10:14:11,110 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-11-14 10:14:11,111 - DEBUG - botocore.auth - add_auth: CanonicalRequest:
PUT
/precompute_with_pg_binding_1_1/ids.json

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

content-md5;content-type;host;x-amz-content-sha256;x-amz-date
23d5479ba1b41412f1ca61194390157f97254b967a2edac8f0f72e50cdca59eb
2025-11-14 10:14:11,111 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251114T101411Z
20251114/yandex/s3/aws4_request
5c8676cb75981f4e126da6ca6f6c70c448993566e32c6711d2c91003f98c2a00
2025-11-14 10:14:11,111 - DEBUG - botocore.auth - add_auth: Signature:
ebb43023f52b405778d19b30283dedfb880b554cfe81eefb63c8dc9f7dab0ec1
2025-11-14 10:14:11,111 - DEBUG - botocore.hooks - _emit: Event request-created.s3.PutObject: calling handler <function add_retry_headers at 0x7facac23d490>
2025-11-14 10:14:11,111 - DEBUG - botocore.endpoint - _do_get_response: Sending http request: <AWSPreparedRequest stream_output=False, method=PUT, url=http://localhost:20364/precompute_with_pg_binding_1_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'20251114T101411Z', '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=ebb43023f52b405778d19b30283dedfb880b554cfe81eefb63c8dc9f7dab0ec1', 'amz-sdk-invocation-id': b'eaab5766-f551-45a6-b276-2aa26541a0e7', 'amz-sdk-request': b'attempt=1', 'Content-Length': '10'}>
2025-11-14 10:14:11,114 - DEBUG - botocore.awsrequest - _send_output: Waiting for 100 Continue response.
2025-11-14 10:14:11,116 - DEBUG - botocore.awsrequest - _handle_expect_response: 100 Continue response seen, now sending request body.
2025-11-14 10:14:11,121 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.9', 'Date': 'Fri, 14 Nov 2025 10:14:11 GMT', 'ETag': '"17940ee22af690ce6524c4138468face"', 'last-modified': 'Fri, 14 Nov 2025 10:14:11 GMT', 'Content-Length': '0', 'x-amzn-requestid': 'rCMkaXXvwumZqh5nD07mZy5czTtREW3IHhAscXbD5WPCDMthM2cH', 'Content-Type': 'text/html; charset=utf-8', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-11-14 10:14:11,121 - DEBUG - botocore.parsers - parse: Response body:
b''
2025-11-14 10:14:11,122 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.PutObject: calling handler <botocore.retryhandler.RetryHandler object at 0x7facab2ad410>
2025-11-14 10:14:11,122 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-11-14 10:14:11,123 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.PutObject: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8e321aa0>>
2025-11-14 10:14:11,189 - DEBUG - boto3.resources.action - __call__: Calling s3:create_bucket with {'Bucket': 'precompute_with_pg_binding_1_1', 'ACL': 'public-read'}
2025-11-14 10:14:11,189 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function validate_bucket_name at 0x7facac21ac90>
2025-11-14 10:14:11,191 - 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:11,191 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8dacd690>>
2025-11-14 10:14:11,192 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function generate_idempotent_uuid at 0x7facac21aa50>
2025-11-14 10:14:11,192 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7facac23d790>
2025-11-14 10:14:11,192 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8dacd690>>
2025-11-14 10:14:11,193 - DEBUG - botocore.regions - construct_endpoint: Calling endpoint provider with parameters: {'Bucket': 'precompute_with_pg_binding_1_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:11,193 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:20364/precompute_with_pg_binding_1_1
2025-11-14 10:14:11,193 - 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:11,194 - 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:11,196 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_expect_header at 0x7facac21b110>
2025-11-14 10:14:11,197 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_recursion_detection_header at 0x7facac219010>
2025-11-14 10:14:11,197 - 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:11,197 - 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_1_1/', 'url': 'http://localhost:20364/precompute_with_pg_binding_1_1', 'context': {'client_region': 'yandex', 'client_config': <botocore.config.Config object at 0x7fac8d77cab0>, 'has_streaming_input': False, 'auth_type': 'v4', 's3_redirect': {'redirected': False, 'bucket': 'precompute_with_pg_binding_1_1', 'params': {'Bucket': 'precompute_with_pg_binding_1_1', 'ACL': 'public-read'}}, 'signing': {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}}}
2025-11-14 10:14:11,198 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7fac8d77c6a0>>
2025-11-14 10:14:11,198 - 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 0x7fac8dbae950>>
2025-11-14 10:14:11,198 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.CreateBucket: calling handler <function set_operation_specific_signer at 0x7facac21a8d0>
2025-11-14 10:14:11,199 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.CreateBucket: calling handler <function remove_arn_from_signing_path at 0x7facac23d6d0>
2025-11-14 10:14:11,199 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-11-14 10:14:11,200 - DEBUG - botocore.auth - add_auth: CanonicalRequest:
PUT
/precompute_with_pg_binding_1_1

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

host;x-amz-acl;x-amz-content-sha256;x-amz-date
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
2025-11-14 10:14:11,200 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251114T101411Z
20251114/yandex/s3/aws4_request
50dcc446db182b5b424257ec2309be7ce003066f506ed4c30b90de973372451c
2025-11-14 10:14:11,200 - DEBUG - botocore.auth - add_auth: Signature:
a7344df304702eff1a052954406a8b8ea11d17b6f274a719212a1d4ab8e1b23d
2025-11-14 10:14:11,200 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <function add_retry_headers at 0x7facac23d490>
2025-11-14 10:14:11,201 - DEBUG - botocore.endpoint - _do_get_response: Sending http request: <AWSPreparedRequest stream_output=False, method=PUT, url=http://localhost:20364/precompute_with_pg_binding_1_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'20251114T101411Z', '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=a7344df304702eff1a052954406a8b8ea11d17b6f274a719212a1d4ab8e1b23d', 'amz-sdk-invocation-id': b'db79f77e-e992-4cf8-a740-01067f788434', 'amz-sdk-request': b'attempt=1', 'Content-Length': '0'}>
2025-11-14 10:14:11,216 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.9', 'Date': 'Fri, 14 Nov 2025 10:14:11 GMT', 'x-amzn-requestid': '0pe5DmVk6KnmlSGeA2SDcRvePTQNZBtmqK96Q3qM5RNaPON6uCwB', 'Content-Type': 'text/html; charset=utf-8', 'Content-Length': '184', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-11-14 10:14:11,216 - DEBUG - botocore.parsers - parse: Response body:
b'<CreateBucketResponse xmlns="http://s3.amazonaws.com/doc/2006-03-01"><CreateBucketResponse><Bucket>precompute_with_pg_binding_1_1</Bucket></CreateBucketResponse></CreateBucketResponse>'
2025-11-14 10:14:11,217 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <botocore.retryhandler.RetryHandler object at 0x7fac8d7c90f0>
2025-11-14 10:14:11,217 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-11-14 10:14:11,217 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8dacd690>>
2025-11-14 10:14:11,218 - DEBUG - boto3.resources.action - __call__: Response: {'ResponseMetadata': {'RequestId': '0pe5DmVk6KnmlSGeA2SDcRvePTQNZBtmqK96Q3qM5RNaPON6uCwB', 'HTTPStatusCode': 200, 'HTTPHeaders': {'server': 'Werkzeug/2.2.3 Python/3.12.9', 'date': 'Fri, 14 Nov 2025 10:14:11 GMT', 'x-amzn-requestid': '0pe5DmVk6KnmlSGeA2SDcRvePTQNZBtmqK96Q3qM5RNaPON6uCwB', 'content-type': 'text/html; charset=utf-8', 'content-length': '184', 'access-control-allow-origin': '*', 'connection': 'close'}, 'RetryAttempts': 0}}
2025-11-14 10:14:11,218 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function validate_ascii_metadata at 0x7facac21bd10>
2025-11-14 10:14:11,219 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function sse_md5 at 0x7facac21ad50>
2025-11-14 10:14:11,219 - 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:11,219 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function validate_bucket_name at 0x7facac21ac90>
2025-11-14 10:14:11,219 - 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:11,219 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8e321aa0>>
2025-11-14 10:14:11,220 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function generate_idempotent_uuid at 0x7facac21aa50>
2025-11-14 10:14:11,220 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7facac23d790>
2025-11-14 10:14:11,220 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8e321aa0>>
2025-11-14 10:14:11,221 - DEBUG - botocore.regions - construct_endpoint: Calling endpoint provider with parameters: {'Bucket': 'precompute_with_pg_binding_1_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:11,221 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:20364/precompute_with_pg_binding_1_1
2025-11-14 10:14:11,221 - 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:11,222 - 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:11,222 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function conditionally_calculate_md5 at 0x7facac42fc50>
2025-11-14 10:14:11,223 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function add_expect_header at 0x7facac21b110>
2025-11-14 10:14:11,223 - DEBUG - botocore.handlers - add_expect_header: Adding expect 100 continue header to request.
2025-11-14 10:14:11,224 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function add_recursion_detection_header at 0x7facac219010>
2025-11-14 10:14:11,224 - 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:11,224 - 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 0x7fac8d515e10>, 'auth_path': '/precompute_with_pg_binding_1_1/names.json', 'url': 'http://localhost:20364/precompute_with_pg_binding_1_1/names.json', 'context': {'client_region': 'yandex', 'client_config': <botocore.config.Config object at 0x7fac8e4e1a00>, 'has_streaming_input': True, 'auth_type': 'v4', 's3_redirect': {'redirected': False, 'bucket': 'precompute_with_pg_binding_1_1', 'params': {'Body': <_io.BytesIO object at 0x7fac8d515e10>, 'Bucket': 'precompute_with_pg_binding_1_1', 'Key': 'names.json', 'ContentType': 'text/json'}}, 'signing': {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}}}
2025-11-14 10:14:11,226 - DEBUG - botocore.hooks - _emit: Event request-created.s3.PutObject: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7fac8e4e3c60>>
2025-11-14 10:14:11,226 - 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 0x7fac8e03c1f0>>
2025-11-14 10:14:11,226 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.PutObject: calling handler <function set_operation_specific_signer at 0x7facac21a8d0>
2025-11-14 10:14:11,226 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.PutObject: calling handler <function remove_arn_from_signing_path at 0x7facac23d6d0>
2025-11-14 10:14:11,227 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-11-14 10:14:11,227 - DEBUG - botocore.auth - add_auth: CanonicalRequest:
PUT
/precompute_with_pg_binding_1_1/names.json

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

content-md5;content-type;host;x-amz-content-sha256;x-amz-date
1914cdbd73317565253f9702d35f1dc337d2e1d90ecb8a398a9a2e3486922633
2025-11-14 10:14:11,228 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251114T101411Z
20251114/yandex/s3/aws4_request
74f973dd80c21ac403f60596fc9db305799aa1806905b90a1a23832ea8d481b4
2025-11-14 10:14:11,228 - DEBUG - botocore.auth - add_auth: Signature:
644f160f91e6af5e5c7a7fef57d1f4ab1a47589a9a1155669deac2b8f370a707
2025-11-14 10:14:11,228 - DEBUG - botocore.hooks - _emit: Event request-created.s3.PutObject: calling handler <function add_retry_headers at 0x7facac23d490>
2025-11-14 10:14:11,229 - DEBUG - botocore.endpoint - _do_get_response: Sending http request: <AWSPreparedRequest stream_output=False, method=PUT, url=http://localhost:20364/precompute_with_pg_binding_1_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'20251114T101411Z', '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=644f160f91e6af5e5c7a7fef57d1f4ab1a47589a9a1155669deac2b8f370a707', 'amz-sdk-invocation-id': b'518b43e2-757f-49d1-a8a2-a016131f381e', 'amz-sdk-request': b'attempt=1', 'Content-Length': '64'}>
2025-11-14 10:14:11,231 - DEBUG - botocore.awsrequest - _send_output: Waiting for 100 Continue response.
2025-11-14 10:14:11,233 - DEBUG - botocore.awsrequest - _handle_expect_response: 100 Continue response seen, now sending request body.
2025-11-14 10:14:11,238 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.9', 'Date': 'Fri, 14 Nov 2025 10:14:11 GMT', 'ETag': '"75c3b1ea2e33ef5f1c2f25de02fa7668"', 'last-modified': 'Fri, 14 Nov 2025 10:14:11 GMT', 'Content-Length': '0', 'x-amzn-requestid': 'X7QEiE61ljaW3ICSwez4rUITeq5OqpEbHZiHHU5fgdPCqTZ39oH9', 'Content-Type': 'text/html; charset=utf-8', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-11-14 10:14:11,238 - DEBUG - botocore.parsers - parse: Response body:
b''
2025-11-14 10:14:11,239 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.PutObject: calling handler <botocore.retryhandler.RetryHandler object at 0x7facab2ad410>
2025-11-14 10:14:11,239 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-11-14 10:14:11,239 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.PutObject: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7fac8e321aa0>>
2025-11-14 10:14:11,275 - DEBUG - root - wait_bootstrap: Wait for node 1 to bootstrap
2025-11-14 10:14:11,329 - DEBUG - root - wait_bootstrap: Node 1 has been bootstrapped
2025-11-14 10:14:11,330 - DEBUG - root - create_query_impl: Request: content {
  type: ANALYTICS
  name: "simple"
  acl {
    visibility: PRIVATE
  }
  limits {
    execution_timeout {
    }
  }
  text: "\n            SELECT *\n            FROM bindings.h4083742189646068154_test_precompute_with_pg_bindingbinding_for_names_1_1\n            WHERE id IN (\n                SELECT\n                    id\n                FROM bindings.h4083742189646068154_test_precompute_with_pg_bindingbinding_for_ids_1_1\n            )\n            "
  syntax: PG
}
execute_mode: RUN
idempotency_key: "5f7aff32-dccf-42e3-a018-c997bca2195e"

2025-11-14 10:14:11,359 - DEBUG - root - create_query_impl: Result: query_id: "ptqudseiurtu247qegam"

2025-11-14 10:14:11,376 - DEBUG - root - describe_query: Result: query {
  meta {
    common {
      id: "ptqudseiurtu247qegam"
      created_by: "root@builtin"
      modified_by: "root@builtin"
      created_at {
        seconds: 1763115251
        nanos: 337139000
      }
      modified_at {
        seconds: 1763115251
        nanos: 337139000
      }
      revision: 1
    }
    execute_mode: RUN
    status: STARTING
    last_job_query_revision: 1
    last_job_id: "ptjudseiurtu0nngb01l-ptqudseiurtu247qegam"
    started_by: "root@builtin"
    submitted_at {
      seconds: 1763115251
      nanos: 337139000
    }
  }
  content {
    type: ANALYTICS
    name: "simple"
    acl {
      visibility: PRIVATE
    }
    limits {
      execution_timeout {
      }
    }
    text: "\n            SELECT *\n            FROM bindings.h4083742189646068154_test_precompute_with_pg_bindingbinding_for_names_1_1\n            WHERE id IN (\n                SELECT\n                    id\n                FROM bindings.h4083742189646068154_test_precompute_with_pg_bindingbinding_for_ids_1_1\n            )\n            "
    syntax: PG
  }
}

2025-11-14 10:14:11,897 - DEBUG - root - describe_query: Result: ... (repeated, see above) ...
2025-11-14 10:14:12,424 - DEBUG - root - describe_query: Result: query {
  meta {
    common {
      id: "ptqudseiurtu247qegam"
      created_by: "root@builtin"
      modified_by: "root@builtin"
      created_at {
        seconds: 1763115251
        nanos: 337139000
      }
      modified_at {
        seconds: 1763115251
        nanos: 337139000
      }
      revision: 1
    }
    started_at {
      seconds: 1763115251
      nanos: 984000000
    }
    finished_at {
      seconds: 1763115252
      nanos: 260000000
    }
    execute_mode: RUN
    status: COMPLETED
    last_job_query_revision: 1
    last_job_id: "ptjudseiurtu0nngb01l-ptqudseiurtu247qegam"
    result_expire_at {
      seconds: 1763201651
      nanos: 959951000
    }
    started_by: "root@builtin"
    submitted_at {
      seconds: 1763115251
      nanos: 337139000
    }
  }
  content {
    type: ANALYTICS
    name: "simple"
    acl {
      visibility: PRIVATE
    }
    limits {
      execution_timeout {
      }
    }
    text: "\n            SELECT *\n            FROM bindings.h4083742189646068154_test_precompute_with_pg_bindingbinding_for_names_1_1\n            WHERE id IN (\n                SELECT\n                    id\n                FROM bindings.h4083742189646068154_test_precompute_with_pg_bindingbinding_for_ids_1_1\n            )\n            "
    syntax: PG
  }
  plan {
    json: "{\"Detailed\":{\"Operations\":[{\"Id\":11,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[{\"Name\":\"DqSourceWideWrap\"},{\"Name\":\"NarrowMap\"}]}},{\"Id\":20,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[{\"Name\":\"DqSourceWideWrap\"},{\"Name\":\"NarrowMap\"}]}},{\"Id\":18,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[]},\"DependsOn\":[20]},{\"Id\":9,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[{\"Name\":\"DqPhyMapJoin\"},{\"Name\":\"FlatMap\"}]},\"DependsOn\":[11,18]},{\"Id\":7,\"Name\":\"DqStage\",\"Streams\":{\"Program\":[]},\"DependsOn\":[9]},{\"Id\":3,\"Name\":\"ResPull!\",\"DependsOn\":[7]},{\"Id\":1,\"Name\":\"Commit!\",\"DependsOn\":[3]}],\"OperationRoot\":1,\"Providers\":[],\"OperationStats\":{\"Commit!\":1,\"DqStage\":5,\"ResPull!\":1}},\"Basic\":{\"nodes\":[{\"id\":11,\"level\":1,\"name\":\"DqStage #11\",\"type\":\"op\"},{\"id\":20,\"level\":1,\"name\":\"DqStage #20\",\"type\":\"op\"},{\"id\":18,\"level\":2,\"name\":\"DqStage #18\",\"type\":\"op\"},{\"id\":9,\"level\":3,\"name\":\"DqStage #9\",\"type\":\"op\"},{\"id\":7,\"level\":4,\"name\":\"DqStage #7\",\"type\":\"op\"},{\"id\":3,\"level\":5,\"name\":\"ResPull!\",\"type\":\"op\"},{\"id\":1,\"level\":6,\"name\":\"Commit!\",\"type\":\"op\"}],\"links\":[{\"source\":20,\"target\":18},{\"source\":11,\"target\":9},{\"source\":18,\"target\":9},{\"source\":9,\"target\":7},{\"source\":7,\"target\":3},{\"source\":3,\"target\":1}]}}"
  }
  statistics {
    json: "{\"Graph=0\":{\"Tasks\":{\"sum\":5,\"count\":5,\"avg\":1,\"max\":1,\"min\":1},\"CpuTimeUs\":{\"sum\":\"0.27s\",\"count\":5,\"avg\":\"55ms\",\"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 (DataSource \'config))\n(let $2 (Configure! world $1 \'OrderedColumns))\n(let $3 (Configure! $2 $1 \'DqEngine \'force))\n(let $4 (DataSink \'result))\n(let $5 \'\"h4083742189646068154_test_precompute_with_pg_bindingprecompute_with_pg_1_1\")\n(let $6 (DataSource \'\"s3\" $5))\n(let $7 (Bool \'true))\n(let $8 \'\"cluster:default_h4083742189646068154_test_precompute_with_pg_bindingprecompute_with_pg_1_1\")\n(let $9 (SecureParam $8))\n(let $10 \'(\'\"id\" (PgType \'int4)))\n(let $11 (StructType $10 \'(\'\"name\" (PgType \'text))))\n(let $12 (S3ParseSettings world \'(\'((String \'\"Paths {\\n  Name: \\\"names.json\\\"\\n  Size: 64\\n  Read: true\\n}\\n\") $7 (AsStruct))) $9 \'\"\" \'\"names.json \" \'json_each_row $11 (lambda \'($23) $7) \'()))\n(let $13 \'(\'(\'format \'json_each_row)))\n(let $14 (DqStage \'((DqSource $6 $12)) (lambda \'($24) (block \'(\n  (let $25 (DqSourceWideWrap $24 $6 $11 $13))\n  (return (NarrowMap $25 (lambda \'($26 $27) (AsStruct \'(\'\"id\" $26) \'(\'\"name\" $27)))))\n))) \'(\'(\'\"_logical_id\" \'201170))))\n(let $15 (StructType $10))\n(let $16 (S3ParseSettings world \'(\'((String \'\"Paths {\\n  Name: \\\"ids.json\\\"\\n  Size: 10\\n  Read: true\\n}\\n\") $7 (AsStruct))) $9 \'\"\" \'\"ids.json \" \'json_each_row $15 (lambda \'($28) $7) \'()))\n(let $17 (DqStage \'((DqSource $6 $16)) (lambda \'($29) (block \'(\n  (let $30 (DqSourceWideWrap $29 $6 $15 $13))\n  (return (NarrowMap $30 (lambda \'($31) (AsStruct \'(\'\"id\" $31)))))\n))) \'(\'(\'\"_logical_id\" \'201192))))\n(let $18 (DqStage \'((DqCnUnionAll (TDqOutput $17 \'\"0\"))) (lambda \'($32) $32) \'(\'(\'\"_logical_id\" \'201298))))\n(let $19 (DqStage \'((DqCnMap (TDqOutput $14 \'\"0\")) (DqCnBroadcast (TDqOutput $18 \'\"0\"))) (lambda \'($33 $34) (block \'(\n  (let $35 \'\"_yql_injoin_input.id\")\n  (let $36 (DqPhyMapJoin $33 $34 \'_yql_injoin_input \'_yql_injoin_0 \'LeftSemi \'(\'(\'_yql_injoin_input \'\"id\" \'_yql_injoin_0 \'\"id\")) \'($35) \'(\'\"_yql_injoin_0.id\")))\n  (return (FlatMap $36 (lambda \'($37) (Just (AsStruct \'(\'\"id\" (Member $37 $35)) \'(\'\"name\" (Member $37 \'\"_yql_injoin_input.name\")))))))\n))) \'(\'(\'\"_logical_id\" \'201376))))\n(let $20 (DqStage \'((DqCnUnionAll (TDqOutput $19 \'\"0\"))) (lambda \'($38) $38) \'(\'(\'\"_logical_id\" \'201452))))\n(let $21 \'(\'(\'type) \'(\'autoref) \'(\'\"columns\" \'(\'\"id\" \'\"name\")) \'(\'\"freezeColumns\")))\n(let $22 (ResPull! $3 $4 (Key) (DqCnResult (TDqOutput $20 \'\"0\") \'()) $21 \'\"dq\"))\n(return (Commit! (Commit! $22 $4) (DataSink \'\"s3\" $5)))\n)\n"
  }
}

2025-11-14 10:14:12,468 - 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:12,470 - INFO - ya.test - pytest_runtest_teardown: Test teardown
2025-11-14 10:17:41,865 - DEBUG - ya.test - _verify_test: Verifying [test_format_setting.TestS3.test_precompute_with_pg_binding[v1-pg_types-pg_syntax-client0] in ydb/tests/fq/s3] canonical results
2025-11-14 10:17:41,865 - DEBUG - ya.test - verify: Test test_format_setting.TestS3.test_precompute_with_pg_binding[v1-pg_types-pg_syntax-client0] status: good
