2025-12-12 13:28:41,401 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-12-12 13:28:41,403 - INFO - ya.test - pytest_runtest_setup: test_precompute_with_pg_binding[v1-pg_types-pg_syntax-client0]
2025-12-12 13:28:41,404 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-12-12 13:28:41,404 - INFO - ya.test - pytest_runtest_setup: Test setup
2025-12-12 13:28:41,462 - 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-12-12 13:28:41,463 - DEBUG - botocore.hooks - _emit: Event choose-service-name: calling handler <function handle_service_name_alias at 0x7f3738f31010>
2025-12-12 13:28:41,466 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_post at 0x7f373903cd10>
2025-12-12 13:28:41,466 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function lazy_call.<locals>._handler at 0x7f3737981610>
2025-12-12 13:28:41,466 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_url at 0x7f373903ca10>
2025-12-12 13:28:41,470 - DEBUG - botocore.endpoint - create_endpoint: Setting s3 timeout as (60, 60)
2025-12-12 13:28:41,475 - DEBUG - botocore.client - _register_legacy_retries: Registering retry handlers for service: s3
2025-12-12 13:28:41,476 - DEBUG - botocore.utils - register: Registering S3 region redirector handler
2025-12-12 13:28:41,477 - DEBUG - boto3.resources.factory - load_from_definition: Loading s3:s3
2025-12-12 13:28:41,479 - DEBUG - boto3.resources.factory - load_from_definition: Loading s3:Bucket
2025-12-12 13:28:41,480 - DEBUG - boto3.resources.model - _load_name_with_category: Renaming Bucket attribute name
2025-12-12 13:28:41,481 - DEBUG - botocore.hooks - _emit: Event creating-resource-class.s3.Bucket: calling handler <function lazy_call.<locals>._handler at 0x7f3737982090>
2025-12-12 13:28:41,482 - DEBUG - boto3.resources.action - __call__: Calling s3:create_bucket with {'Bucket': 'precompute_with_pg_binding_1_1', 'ACL': 'public-read'}
2025-12-12 13:28:41,483 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function validate_bucket_name at 0x7f3738f32ed0>
2025-12-12 13:28:41,483 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function remove_bucket_from_url_paths_from_model at 0x7f3738f59790>
2025-12-12 13:28:41,483 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7f371ae34970>>
2025-12-12 13:28:41,483 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function generate_idempotent_uuid at 0x7f3738f32c90>
2025-12-12 13:28:41,484 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7f3738f599d0>
2025-12-12 13:28:41,484 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7f371ae34970>>
2025-12-12 13:28:41,484 - 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:24309', 'ForcePathStyle': True, 'Accelerate': False, 'UseGlobalEndpoint': False, 'DisableAccessPoints': True, 'DisableMultiRegionAccessPoints': False, 'UseArnRegion': True}
2025-12-12 13:28:41,486 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:24309/precompute_with_pg_binding_1_1
2025-12-12 13:28:41,486 - 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-12-12 13:28:41,486 - 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-12-12 13:28:41,487 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_expect_header at 0x7f3738f33350>
2025-12-12 13:28:41,487 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_recursion_detection_header at 0x7f3738f31250>
2025-12-12 13:28:41,488 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function inject_api_version_header_if_needed at 0x7f3738f58dd0>
2025-12-12 13:28:41,488 - 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:24309/precompute_with_pg_binding_1_1', 'context': {'client_region': 'yandex', 'client_config': <botocore.config.Config object at 0x7f371ae34060>, '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-12-12 13:28:41,488 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7f371ae34150>>
2025-12-12 13:28:41,489 - 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 0x7f3737b95280>>
2025-12-12 13:28:41,489 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.CreateBucket: calling handler <function set_operation_specific_signer at 0x7f3738f32b10>
2025-12-12 13:28:41,490 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.CreateBucket: calling handler <function remove_arn_from_signing_path at 0x7f3738f59910>
2025-12-12 13:28:41,490 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-12-12 13:28:41,490 - DEBUG - botocore.auth - add_auth: CanonicalRequest:
PUT
/precompute_with_pg_binding_1_1

host:localhost:24309
x-amz-acl:public-read
x-amz-content-sha256:e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
x-amz-date:20251212T132841Z

host;x-amz-acl;x-amz-content-sha256;x-amz-date
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
2025-12-12 13:28:41,491 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251212T132841Z
20251212/yandex/s3/aws4_request
04ee892c2738aeb9bd644ebdfef911197c2440d5a1ad7b0acfb981176d97ae88
2025-12-12 13:28:41,491 - DEBUG - botocore.auth - add_auth: Signature:
afad748a39d8187a201f9a9d0e1db45584e276d8015c9541549367d1288e9514
2025-12-12 13:28:41,491 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <function add_retry_headers at 0x7f3738f596d0>
2025-12-12 13:28:41,492 - DEBUG - botocore.endpoint - _do_get_response: Sending http request: <AWSPreparedRequest stream_output=False, method=PUT, url=http://localhost:24309/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'20251212T132841Z', 'X-Amz-Content-SHA256': b'e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855', 'Authorization': b'AWS4-HMAC-SHA256 Credential=key/20251212/yandex/s3/aws4_request, SignedHeaders=host;x-amz-acl;x-amz-content-sha256;x-amz-date, Signature=afad748a39d8187a201f9a9d0e1db45584e276d8015c9541549367d1288e9514', 'amz-sdk-invocation-id': b'dcd21933-bda8-4cda-a2e3-ce9b31d33294', 'amz-sdk-request': b'attempt=1', 'Content-Length': '0'}>
2025-12-12 13:28:41,504 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.9', 'Date': 'Fri, 12 Dec 2025 13:28:41 GMT', 'x-amzn-requestid': 'Qz2HjIr6I0kjcf69yVjcomWFODN0B4UyuyRkuPfNeOJewF13dCJg', 'Content-Type': 'text/html; charset=utf-8', 'Content-Length': '184', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-12-12 13:28:41,504 - 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-12-12 13:28:41,505 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <botocore.retryhandler.RetryHandler object at 0x7f371ace2040>
2025-12-12 13:28:41,506 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-12-12 13:28:41,506 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7f371ae34970>>
2025-12-12 13:28:41,507 - DEBUG - boto3.resources.action - __call__: Response: {'ResponseMetadata': {'RequestId': 'Qz2HjIr6I0kjcf69yVjcomWFODN0B4UyuyRkuPfNeOJewF13dCJg', 'HTTPStatusCode': 200, 'HTTPHeaders': {'server': 'Werkzeug/2.2.3 Python/3.12.9', 'date': 'Fri, 12 Dec 2025 13:28:41 GMT', 'x-amzn-requestid': 'Qz2HjIr6I0kjcf69yVjcomWFODN0B4UyuyRkuPfNeOJewF13dCJg', 'content-type': 'text/html; charset=utf-8', 'content-length': '184', 'access-control-allow-origin': '*', 'connection': 'close'}, 'RetryAttempts': 0}}
2025-12-12 13:28:41,508 - DEBUG - botocore.hooks - _emit: Event choose-service-name: calling handler <function handle_service_name_alias at 0x7f3738f31010>
2025-12-12 13:28:41,510 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_post at 0x7f373903cd10>
2025-12-12 13:28:41,511 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function lazy_call.<locals>._handler at 0x7f3737981610>
2025-12-12 13:28:41,511 - DEBUG - botocore.hooks - _emit: Event creating-client-class.s3: calling handler <function add_generate_presigned_url at 0x7f373903ca10>
2025-12-12 13:28:41,514 - DEBUG - botocore.endpoint - create_endpoint: Setting s3 timeout as (60, 60)
2025-12-12 13:28:41,519 - DEBUG - botocore.client - _register_legacy_retries: Registering retry handlers for service: s3
2025-12-12 13:28:41,520 - DEBUG - botocore.utils - register: Registering S3 region redirector handler
2025-12-12 13:28:41,522 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function validate_ascii_metadata at 0x7f3738f33f50>
2025-12-12 13:28:41,522 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function sse_md5 at 0x7f3738f32f90>
2025-12-12 13:28:41,523 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function convert_body_to_file_like_object at 0x7f3738f58c50>
2025-12-12 13:28:41,523 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function validate_bucket_name at 0x7f3738f32ed0>
2025-12-12 13:28:41,523 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function remove_bucket_from_url_paths_from_model at 0x7f3738f59790>
2025-12-12 13:28:41,523 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7f371ace3440>>
2025-12-12 13:28:41,524 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function generate_idempotent_uuid at 0x7f3738f32c90>
2025-12-12 13:28:41,524 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7f3738f599d0>
2025-12-12 13:28:41,524 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7f371ace3440>>
2025-12-12 13:28:41,525 - 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:24309', 'ForcePathStyle': True, 'Accelerate': False, 'UseGlobalEndpoint': False, 'DisableMultiRegionAccessPoints': False, 'UseArnRegion': True}
2025-12-12 13:28:41,527 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:24309/precompute_with_pg_binding_1_1
2025-12-12 13:28:41,527 - 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-12-12 13:28:41,528 - 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-12-12 13:28:41,529 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function conditionally_calculate_md5 at 0x7f373914fe90>
2025-12-12 13:28:41,529 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function add_expect_header at 0x7f3738f33350>
2025-12-12 13:28:41,529 - DEBUG - botocore.handlers - add_expect_header: Adding expect 100 continue header to request.
2025-12-12 13:28:41,529 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function add_recursion_detection_header at 0x7f3738f31250>
2025-12-12 13:28:41,530 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function inject_api_version_header_if_needed at 0x7f3738f58dd0>
2025-12-12 13:28:41,530 - 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 0x7f371aecaf20>, 'auth_path': '/precompute_with_pg_binding_1_1/ids.json', 'url': 'http://localhost:24309/precompute_with_pg_binding_1_1/ids.json', 'context': {'client_region': 'yandex', 'client_config': <botocore.config.Config object at 0x7f371ae44ab0>, 'has_streaming_input': True, 'auth_type': 'v4', 's3_redirect': {'redirected': False, 'bucket': 'precompute_with_pg_binding_1_1', 'params': {'Body': <_io.BytesIO object at 0x7f371aecaf20>, 'Bucket': 'precompute_with_pg_binding_1_1', 'Key': 'ids.json', 'ContentType': 'text/json'}}, 'signing': {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}}}
2025-12-12 13:28:41,532 - DEBUG - botocore.hooks - _emit: Event request-created.s3.PutObject: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7f371ae45f50>>
2025-12-12 13:28:41,532 - 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 0x7f371b94f170>>
2025-12-12 13:28:41,532 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.PutObject: calling handler <function set_operation_specific_signer at 0x7f3738f32b10>
2025-12-12 13:28:41,533 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.PutObject: calling handler <function remove_arn_from_signing_path at 0x7f3738f59910>
2025-12-12 13:28:41,533 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-12-12 13:28:41,534 - DEBUG - botocore.auth - add_auth: CanonicalRequest:
PUT
/precompute_with_pg_binding_1_1/ids.json

content-md5:F5QO4ir2kM5lJMQThGj6zg==
content-type:text/json
host:localhost:24309
x-amz-content-sha256:23d5479ba1b41412f1ca61194390157f97254b967a2edac8f0f72e50cdca59eb
x-amz-date:20251212T132841Z

content-md5;content-type;host;x-amz-content-sha256;x-amz-date
23d5479ba1b41412f1ca61194390157f97254b967a2edac8f0f72e50cdca59eb
2025-12-12 13:28:41,534 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251212T132841Z
20251212/yandex/s3/aws4_request
acd97ccf979077e126b64e465a59b1556f58a1aa162ae99d31fcf6d747382f46
2025-12-12 13:28:41,534 - DEBUG - botocore.auth - add_auth: Signature:
ba1f9baf12eb0635fe25bfbaeb55bb037dc473ab5ff531aac0fd2e713e196d4e
2025-12-12 13:28:41,535 - DEBUG - botocore.hooks - _emit: Event request-created.s3.PutObject: calling handler <function add_retry_headers at 0x7f3738f596d0>
2025-12-12 13:28:41,535 - DEBUG - botocore.endpoint - _do_get_response: Sending http request: <AWSPreparedRequest stream_output=False, method=PUT, url=http://localhost:24309/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'20251212T132841Z', 'X-Amz-Content-SHA256': b'23d5479ba1b41412f1ca61194390157f97254b967a2edac8f0f72e50cdca59eb', 'Authorization': b'AWS4-HMAC-SHA256 Credential=key/20251212/yandex/s3/aws4_request, SignedHeaders=content-md5;content-type;host;x-amz-content-sha256;x-amz-date, Signature=ba1f9baf12eb0635fe25bfbaeb55bb037dc473ab5ff531aac0fd2e713e196d4e', 'amz-sdk-invocation-id': b'0cd87129-fd2a-4a34-8bc5-b940992ac979', 'amz-sdk-request': b'attempt=1', 'Content-Length': '10'}>
2025-12-12 13:28:41,537 - DEBUG - botocore.awsrequest - _send_output: Waiting for 100 Continue response.
2025-12-12 13:28:41,539 - DEBUG - botocore.awsrequest - _handle_expect_response: 100 Continue response seen, now sending request body.
2025-12-12 13:28:41,542 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.9', 'Date': 'Fri, 12 Dec 2025 13:28:41 GMT', 'ETag': '"17940ee22af690ce6524c4138468face"', 'last-modified': 'Fri, 12 Dec 2025 13:28:41 GMT', 'Content-Length': '0', 'x-amzn-requestid': 'imZLK8GbyUhyfoMQEKHhYJGeInM3SWQP0EAnMzBOufarwWaDOjr5', 'Content-Type': 'text/html; charset=utf-8', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-12-12 13:28:41,543 - DEBUG - botocore.parsers - parse: Response body:
b''
2025-12-12 13:28:41,544 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.PutObject: calling handler <botocore.retryhandler.RetryHandler object at 0x7f371ae789c0>
2025-12-12 13:28:41,544 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-12-12 13:28:41,544 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.PutObject: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7f371ace3440>>
2025-12-12 13:28:41,597 - DEBUG - boto3.resources.action - __call__: Calling s3:create_bucket with {'Bucket': 'precompute_with_pg_binding_1_1', 'ACL': 'public-read'}
2025-12-12 13:28:41,598 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function validate_bucket_name at 0x7f3738f32ed0>
2025-12-12 13:28:41,598 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function remove_bucket_from_url_paths_from_model at 0x7f3738f59790>
2025-12-12 13:28:41,598 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7f371ae34970>>
2025-12-12 13:28:41,598 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function generate_idempotent_uuid at 0x7f3738f32c90>
2025-12-12 13:28:41,599 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7f3738f599d0>
2025-12-12 13:28:41,599 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7f371ae34970>>
2025-12-12 13:28:41,599 - 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:24309', 'ForcePathStyle': True, 'Accelerate': False, 'UseGlobalEndpoint': False, 'DisableAccessPoints': True, 'DisableMultiRegionAccessPoints': False, 'UseArnRegion': True}
2025-12-12 13:28:41,599 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:24309/precompute_with_pg_binding_1_1
2025-12-12 13:28:41,600 - 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-12-12 13:28:41,600 - 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-12-12 13:28:41,600 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_expect_header at 0x7f3738f33350>
2025-12-12 13:28:41,601 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_recursion_detection_header at 0x7f3738f31250>
2025-12-12 13:28:41,601 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function inject_api_version_header_if_needed at 0x7f3738f58dd0>
2025-12-12 13:28:41,601 - 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:24309/precompute_with_pg_binding_1_1', 'context': {'client_region': 'yandex', 'client_config': <botocore.config.Config object at 0x7f371ae34060>, '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-12-12 13:28:41,601 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7f371ae34150>>
2025-12-12 13:28:41,602 - 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 0x7f3737b95280>>
2025-12-12 13:28:41,602 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.CreateBucket: calling handler <function set_operation_specific_signer at 0x7f3738f32b10>
2025-12-12 13:28:41,602 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.CreateBucket: calling handler <function remove_arn_from_signing_path at 0x7f3738f59910>
2025-12-12 13:28:41,602 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-12-12 13:28:41,603 - DEBUG - botocore.auth - add_auth: CanonicalRequest:
PUT
/precompute_with_pg_binding_1_1

host:localhost:24309
x-amz-acl:public-read
x-amz-content-sha256:e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
x-amz-date:20251212T132841Z

host;x-amz-acl;x-amz-content-sha256;x-amz-date
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
2025-12-12 13:28:41,603 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251212T132841Z
20251212/yandex/s3/aws4_request
04ee892c2738aeb9bd644ebdfef911197c2440d5a1ad7b0acfb981176d97ae88
2025-12-12 13:28:41,603 - DEBUG - botocore.auth - add_auth: Signature:
afad748a39d8187a201f9a9d0e1db45584e276d8015c9541549367d1288e9514
2025-12-12 13:28:41,603 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <function add_retry_headers at 0x7f3738f596d0>
2025-12-12 13:28:41,604 - DEBUG - botocore.endpoint - _do_get_response: Sending http request: <AWSPreparedRequest stream_output=False, method=PUT, url=http://localhost:24309/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'20251212T132841Z', 'X-Amz-Content-SHA256': b'e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855', 'Authorization': b'AWS4-HMAC-SHA256 Credential=key/20251212/yandex/s3/aws4_request, SignedHeaders=host;x-amz-acl;x-amz-content-sha256;x-amz-date, Signature=afad748a39d8187a201f9a9d0e1db45584e276d8015c9541549367d1288e9514', 'amz-sdk-invocation-id': b'4a3a1ad8-76d7-4085-82af-3130dd9ba770', 'amz-sdk-request': b'attempt=1', 'Content-Length': '0'}>
2025-12-12 13:28:41,616 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.9', 'Date': 'Fri, 12 Dec 2025 13:28:41 GMT', 'x-amzn-requestid': 'jyxUyV7oBX8yq2rqj9SZ283FSo0t4gd8IAErU9DSjkwuaXuqyNE2', 'Content-Type': 'text/html; charset=utf-8', 'Content-Length': '184', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-12-12 13:28:41,618 - 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-12-12 13:28:41,619 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <botocore.retryhandler.RetryHandler object at 0x7f371ace2040>
2025-12-12 13:28:41,620 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-12-12 13:28:41,620 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7f371ae34970>>
2025-12-12 13:28:41,620 - DEBUG - boto3.resources.action - __call__: Response: {'ResponseMetadata': {'RequestId': 'jyxUyV7oBX8yq2rqj9SZ283FSo0t4gd8IAErU9DSjkwuaXuqyNE2', 'HTTPStatusCode': 200, 'HTTPHeaders': {'server': 'Werkzeug/2.2.3 Python/3.12.9', 'date': 'Fri, 12 Dec 2025 13:28:41 GMT', 'x-amzn-requestid': 'jyxUyV7oBX8yq2rqj9SZ283FSo0t4gd8IAErU9DSjkwuaXuqyNE2', 'content-type': 'text/html; charset=utf-8', 'content-length': '184', 'access-control-allow-origin': '*', 'connection': 'close'}, 'RetryAttempts': 0}}
2025-12-12 13:28:41,620 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function validate_ascii_metadata at 0x7f3738f33f50>
2025-12-12 13:28:41,621 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function sse_md5 at 0x7f3738f32f90>
2025-12-12 13:28:41,621 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function convert_body_to_file_like_object at 0x7f3738f58c50>
2025-12-12 13:28:41,621 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function validate_bucket_name at 0x7f3738f32ed0>
2025-12-12 13:28:41,621 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function remove_bucket_from_url_paths_from_model at 0x7f3738f59790>
2025-12-12 13:28:41,621 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7f371ace3440>>
2025-12-12 13:28:41,621 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.PutObject: calling handler <function generate_idempotent_uuid at 0x7f3738f32c90>
2025-12-12 13:28:41,621 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7f3738f599d0>
2025-12-12 13:28:41,622 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7f371ace3440>>
2025-12-12 13:28:41,622 - 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:24309', 'ForcePathStyle': True, 'Accelerate': False, 'UseGlobalEndpoint': False, 'DisableMultiRegionAccessPoints': False, 'UseArnRegion': True}
2025-12-12 13:28:41,622 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:24309/precompute_with_pg_binding_1_1
2025-12-12 13:28:41,622 - 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-12-12 13:28:41,622 - 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-12-12 13:28:41,623 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function conditionally_calculate_md5 at 0x7f373914fe90>
2025-12-12 13:28:41,623 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function add_expect_header at 0x7f3738f33350>
2025-12-12 13:28:41,623 - DEBUG - botocore.handlers - add_expect_header: Adding expect 100 continue header to request.
2025-12-12 13:28:41,623 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function add_recursion_detection_header at 0x7f3738f31250>
2025-12-12 13:28:41,623 - DEBUG - botocore.hooks - _emit: Event before-call.s3.PutObject: calling handler <function inject_api_version_header_if_needed at 0x7f3738f58dd0>
2025-12-12 13:28:41,624 - 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 0x7f37381dcec0>, 'auth_path': '/precompute_with_pg_binding_1_1/names.json', 'url': 'http://localhost:24309/precompute_with_pg_binding_1_1/names.json', 'context': {'client_region': 'yandex', 'client_config': <botocore.config.Config object at 0x7f371ae44ab0>, 'has_streaming_input': True, 'auth_type': 'v4', 's3_redirect': {'redirected': False, 'bucket': 'precompute_with_pg_binding_1_1', 'params': {'Body': <_io.BytesIO object at 0x7f37381dcec0>, 'Bucket': 'precompute_with_pg_binding_1_1', 'Key': 'names.json', 'ContentType': 'text/json'}}, 'signing': {'region': 'yandex', 'signing_name': 's3', 'disableDoubleEncoding': True}}}
2025-12-12 13:28:41,624 - DEBUG - botocore.hooks - _emit: Event request-created.s3.PutObject: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7f371ae45f50>>
2025-12-12 13:28:41,625 - 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 0x7f371b94f170>>
2025-12-12 13:28:41,626 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.PutObject: calling handler <function set_operation_specific_signer at 0x7f3738f32b10>
2025-12-12 13:28:41,626 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.PutObject: calling handler <function remove_arn_from_signing_path at 0x7f3738f59910>
2025-12-12 13:28:41,627 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-12-12 13:28:41,627 - DEBUG - botocore.auth - add_auth: CanonicalRequest:
PUT
/precompute_with_pg_binding_1_1/names.json

content-md5:dcOx6i4z718cLyXeAvp2aA==
content-type:text/json
host:localhost:24309
x-amz-content-sha256:1914cdbd73317565253f9702d35f1dc337d2e1d90ecb8a398a9a2e3486922633
x-amz-date:20251212T132841Z

content-md5;content-type;host;x-amz-content-sha256;x-amz-date
1914cdbd73317565253f9702d35f1dc337d2e1d90ecb8a398a9a2e3486922633
2025-12-12 13:28:41,628 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251212T132841Z
20251212/yandex/s3/aws4_request
d8e1b6d7e199c621b404152945a87b03bee95f783e75135ed781d16e0737ba5b
2025-12-12 13:28:41,628 - DEBUG - botocore.auth - add_auth: Signature:
e940607118fb2076767ab7925445987ed182061047db3107c0415e0981c081e7
2025-12-12 13:28:41,628 - DEBUG - botocore.hooks - _emit: Event request-created.s3.PutObject: calling handler <function add_retry_headers at 0x7f3738f596d0>
2025-12-12 13:28:41,628 - DEBUG - botocore.endpoint - _do_get_response: Sending http request: <AWSPreparedRequest stream_output=False, method=PUT, url=http://localhost:24309/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'20251212T132841Z', 'X-Amz-Content-SHA256': b'1914cdbd73317565253f9702d35f1dc337d2e1d90ecb8a398a9a2e3486922633', 'Authorization': b'AWS4-HMAC-SHA256 Credential=key/20251212/yandex/s3/aws4_request, SignedHeaders=content-md5;content-type;host;x-amz-content-sha256;x-amz-date, Signature=e940607118fb2076767ab7925445987ed182061047db3107c0415e0981c081e7', 'amz-sdk-invocation-id': b'71157272-7cb5-4c4a-bde3-7e8607119309', 'amz-sdk-request': b'attempt=1', 'Content-Length': '64'}>
2025-12-12 13:28:41,630 - DEBUG - botocore.awsrequest - _send_output: Waiting for 100 Continue response.
2025-12-12 13:28:41,631 - DEBUG - botocore.awsrequest - _handle_expect_response: 100 Continue response seen, now sending request body.
2025-12-12 13:28:41,635 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.9', 'Date': 'Fri, 12 Dec 2025 13:28:41 GMT', 'ETag': '"75c3b1ea2e33ef5f1c2f25de02fa7668"', 'last-modified': 'Fri, 12 Dec 2025 13:28:41 GMT', 'Content-Length': '0', 'x-amzn-requestid': 'kqSVjvGrI3toYz5yr3Hm6HqOBBRuLX3wnTuGIilSQYQ9vo2fOIEg', 'Content-Type': 'text/html; charset=utf-8', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-12-12 13:28:41,635 - DEBUG - botocore.parsers - parse: Response body:
b''
2025-12-12 13:28:41,635 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.PutObject: calling handler <botocore.retryhandler.RetryHandler object at 0x7f371ae789c0>
2025-12-12 13:28:41,636 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-12-12 13:28:41,636 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.PutObject: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7f371ace3440>>
2025-12-12 13:28:41,663 - DEBUG - root - wait_bootstrap: Wait for node 1 to bootstrap
2025-12-12 13:28:41,693 - DEBUG - root - wait_bootstrap: Node 1 has been bootstrapped
2025-12-12 13:28:41,694 - DEBUG - root - create_query_impl: Request: content {
  type: ANALYTICS
  name: "simple"
  acl {
    visibility: PRIVATE
  }
  limits {
    execution_timeout {
    }
  }
  text: "\n            SELECT *\n            FROM bindings.h3687295385890048602_test_precompute_with_pg_bindingbinding_for_names_1_1\n            WHERE id IN (\n                SELECT\n                    id\n                FROM bindings.h3687295385890048602_test_precompute_with_pg_bindingbinding_for_ids_1_1\n            )\n            "
  syntax: PG
}
execute_mode: RUN
idempotency_key: "6cbf3daf-bb36-440c-88d0-7e6b509cb895"

2025-12-12 13:28:41,718 - DEBUG - root - create_query_impl: Result: query_id: "ptqudq7r199nahis1gjh"

2025-12-12 13:28:41,733 - DEBUG - root - describe_query: Result: query {
  meta {
    common {
      id: "ptqudq7r199nahis1gjh"
      created_by: "root@builtin"
      modified_by: "root@builtin"
      created_at {
        seconds: 1765546121
        nanos: 700002000
      }
      modified_at {
        seconds: 1765546121
        nanos: 700002000
      }
      revision: 1
    }
    execute_mode: RUN
    status: STARTING
    last_job_query_revision: 1
    last_job_id: "ptjudq7r199n92fmbd5k-ptqudq7r199nahis1gjh"
    started_by: "root@builtin"
    submitted_at {
      seconds: 1765546121
      nanos: 700002000
    }
  }
  content {
    type: ANALYTICS
    name: "simple"
    acl {
      visibility: PRIVATE
    }
    limits {
      execution_timeout {
      }
    }
    text: "\n            SELECT *\n            FROM bindings.h3687295385890048602_test_precompute_with_pg_bindingbinding_for_names_1_1\n            WHERE id IN (\n                SELECT\n                    id\n                FROM bindings.h3687295385890048602_test_precompute_with_pg_bindingbinding_for_ids_1_1\n            )\n            "
    syntax: PG
  }
}

2025-12-12 13:28:42,246 - DEBUG - root - describe_query: Result: query {
  meta {
    common {
      id: "ptqudq7r199nahis1gjh"
      created_by: "root@builtin"
      modified_by: "root@builtin"
      created_at {
        seconds: 1765546121
        nanos: 700002000
      }
      modified_at {
        seconds: 1765546121
        nanos: 700002000
      }
      revision: 1
    }
    started_at {
      seconds: 1765546122
      nanos: 66000000
    }
    execute_mode: RUN
    status: RUNNING
    last_job_query_revision: 1
    last_job_id: "ptjudq7r199n92fmbd5k-ptqudq7r199nahis1gjh"
    started_by: "root@builtin"
    submitted_at {
      seconds: 1765546121
      nanos: 700002000
    }
  }
  content {
    type: ANALYTICS
    name: "simple"
    acl {
      visibility: PRIVATE
    }
    limits {
      execution_timeout {
      }
    }
    text: "\n            SELECT *\n            FROM bindings.h3687295385890048602_test_precompute_with_pg_bindingbinding_for_names_1_1\n            WHERE id IN (\n                SELECT\n                    id\n                FROM bindings.h3687295385890048602_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}]}}"
  }
  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 (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 \'\"h3687295385890048602_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_h3687295385890048602_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-12-12 13:28:42,763 - DEBUG - root - describe_query: Result: query {
  meta {
    common {
      id: "ptqudq7r199nahis1gjh"
      created_by: "root@builtin"
      modified_by: "root@builtin"
      created_at {
        seconds: 1765546121
        nanos: 700002000
      }
      modified_at {
        seconds: 1765546121
        nanos: 700002000
      }
      revision: 1
    }
    started_at {
      seconds: 1765546122
      nanos: 66000000
    }
    finished_at {
      seconds: 1765546122
      nanos: 261000000
    }
    execute_mode: RUN
    status: COMPLETED
    last_job_query_revision: 1
    last_job_id: "ptjudq7r199n92fmbd5k-ptqudq7r199nahis1gjh"
    result_expire_at {
      seconds: 1765632522
      nanos: 40293000
    }
    started_by: "root@builtin"
    submitted_at {
      seconds: 1765546121
      nanos: 700002000
    }
  }
  content {
    type: ANALYTICS
    name: "simple"
    acl {
      visibility: PRIVATE
    }
    limits {
      execution_timeout {
      }
    }
    text: "\n            SELECT *\n            FROM bindings.h3687295385890048602_test_precompute_with_pg_bindingbinding_for_names_1_1\n            WHERE id IN (\n                SELECT\n                    id\n                FROM bindings.h3687295385890048602_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.17s\",\"count\":5,\"avg\":\"35ms\",\"max\":\"78ms\",\"min\":\"1ms\"},\"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 \'\"h3687295385890048602_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_h3687295385890048602_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-12-12 13:28:42,776 - 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-12-12 13:28:42,778 - INFO - ya.test - pytest_runtest_teardown: Test teardown
2025-12-12 13:31:28,729 - 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-12-12 13:31:28,729 - DEBUG - ya.test - verify: Test test_format_setting.TestS3.test_precompute_with_pg_binding[v1-pg_types-pg_syntax-client0] status: good
