2025-11-11 20:51:59,783 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-11 20:51:59,790 - INFO - ya.test - pytest_runtest_setup: test_different_types_and_formats[bzip2-csv_with_names]
2025-11-11 20:51:59,792 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-11 20:51:59,799 - INFO - ya.test - pytest_runtest_setup: Test setup
2025-11-11 20:51:59,818 - INFO - ya.test - pytest_runtest_call: Test call (class_name: test_types_and_formats.py::TestTypesAndFormats, test_name: test_different_types_and_formats[bzip2-csv_with_names])
2025-11-11 20:51:59,821 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3
2025-11-11 20:51:59,834 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 3e37e348-c879-48d1-b86e-1a4d006d8937, ghrun-qykcqbcpue.auto.internal:20865): creating call state
2025-11-11 20:51:59,842 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 3e37e348-c879-48d1-b86e-1a4d006d8937, ghrun-qykcqbcpue.auto.internal:20865): request = { session_id: "ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "\n            CREATE TABLE olap_table_csv_with_names_bzip2 (\n                \n            c_int8 Int8,\n            c_int16 Int16,\n            c_int32 Int32 NOT NULL,\n            c_int64 Int64,\n            c_uint8 Uint8,\n            c_uint16 Uint16,\n            c_uint32 Uint32,\n            c_uint64 Uint64,\n            c_float Float,\n            c_double Double,\n            c_string String,\n            c_utf8 Utf8,\n            c_json Json,\n            c_date Date,\n            c_datetime Datetime,\n            c_timestamp Timestamp\n        ,\n                PRIMARY KEY (c_int32)\n            ) WITH (\n                STORE = COLUMN\n            );\n        " } stats_mode: STATS_MODE_NONE }
2025-11-11 20:51:59,846 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 3e37e348-c879-48d1-b86e-1a4d006d8937, ghrun-qykcqbcpue.auto.internal:20865): response = { <_MultiThreadedRendezvous object> }
2025-11-11 20:52:04,655 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3
2025-11-11 20:52:04,656 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3
2025-11-11 20:52:04,658 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, b72d5c1c-16b9-4317-8e84-e314f8fe9d99, ghrun-qykcqbcpue.auto.internal:20865): creating call state
2025-11-11 20:52:04,659 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, b72d5c1c-16b9-4317-8e84-e314f8fe9d99, ghrun-qykcqbcpue.auto.internal:20865): request = { session_id: "ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "\n            UPSERT INTO olap_table_csv_with_names_bzip2 (\n                c_int8, c_int16, c_int32, c_int64, c_uint8, c_uint16, c_uint32, c_uint64, c_float, c_double, c_string, c_utf8, c_json, c_date, c_datetime, c_timestamp\n            ) VALUES\n                (1, 1, 1, 1, 1, 1, 1, 1, Float(\"0.5\"), Double(\"-0.5\"), \"hello\", \"world\", Json(\"[10, 20, 30]\"), Date(\"2025-08-25\"), Datetime(\"2025-08-25T10:00:00Z\"), Timestamp(\"2025-08-25T10:00:00Z\")),\n                (NULL, NULL, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);\n        " } stats_mode: STATS_MODE_NONE }
2025-11-11 20:52:04,662 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, b72d5c1c-16b9-4317-8e84-e314f8fe9d99, ghrun-qykcqbcpue.auto.internal:20865): response = { <_MultiThreadedRendezvous object> }
2025-11-11 20:52:05,098 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3
2025-11-11 20:52:05,099 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function validate_bucket_name at 0x7c3539ede550>
2025-11-11 20:52:05,100 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function remove_bucket_from_url_paths_from_model at 0x7c3539ed8270>
2025-11-11 20:52:05,101 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7b953a30dff0>>
2025-11-11 20:52:05,102 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.CreateBucket: calling handler <function generate_idempotent_uuid at 0x7c3539ee05b0>
2025-11-11 20:52:05,103 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7c3539ed7d30>
2025-11-11 20:52:05,103 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7b953a30dff0>>
2025-11-11 20:52:05,105 - DEBUG - botocore.regions - construct_endpoint: Calling endpoint provider with parameters: {'Bucket': 'csv_with_names_bzip2_bucket', 'Region': 'us-east-1', 'UseFIPS': False, 'UseDualStack': False, 'Endpoint': 'http://localhost:26209', 'ForcePathStyle': True, 'Accelerate': False, 'UseGlobalEndpoint': True, 'DisableAccessPoints': True, 'DisableMultiRegionAccessPoints': False, 'UseArnRegion': True}
2025-11-11 20:52:05,107 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:26209/csv_with_names_bzip2_bucket
2025-11-11 20:52:05,107 - 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-11 20:52:05,108 - DEBUG - botocore.regions - auth_schemes_to_signing_ctx: Selected auth type "v4" as "v4" with signing context params: {'region': 'us-east-1', 'signing_name': 's3', 'disableDoubleEncoding': True}
2025-11-11 20:52:05,109 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_expect_header at 0x7c3539edd750>
2025-11-11 20:52:05,125 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function add_recursion_detection_header at 0x7c3539ee1ff0>
2025-11-11 20:52:05,126 - DEBUG - botocore.hooks - _emit: Event before-call.s3.CreateBucket: calling handler <function inject_api_version_header_if_needed at 0x7c3539ed87b0>
2025-11-11 20:52:05,127 - DEBUG - botocore.endpoint - make_request: Making request for OperationModel(name=CreateBucket) with params: {'url_path': '', 'query_string': {}, 'method': 'PUT', 'headers': {'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.11 md/pyimpl#CPython cfg/retry-mode#legacy Botocore/1.31.80'}, 'body': b'', 'auth_path': '/csv_with_names_bzip2_bucket/', 'url': 'http://localhost:26209/csv_with_names_bzip2_bucket', 'context': {'client_region': 'us-east-1', 'client_config': <botocore.config.Config object at 0x7b953a270230>, 'has_streaming_input': False, 'auth_type': 'v4', 's3_redirect': {'redirected': False, 'bucket': 'csv_with_names_bzip2_bucket', 'params': {'Bucket': 'csv_with_names_bzip2_bucket'}}, 'signing': {'region': 'us-east-1', 'signing_name': 's3', 'disableDoubleEncoding': True}}}
2025-11-11 20:52:05,129 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7b953a26fcb0>>
2025-11-11 20:52:05,130 - 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 0x7b953a2df0b0>>
2025-11-11 20:52:05,131 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.CreateBucket: calling handler <function set_operation_specific_signer at 0x7c3539edea90>
2025-11-11 20:52:05,136 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.CreateBucket: calling handler <function remove_arn_from_signing_path at 0x7c3539ed7ef0>
2025-11-11 20:52:05,138 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-11-11 20:52:05,138 - DEBUG - botocore.auth - add_auth: CanonicalRequest:
PUT
/csv_with_names_bzip2_bucket

host:localhost:26209
x-amz-content-sha256:e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
x-amz-date:20251111T205205Z

host;x-amz-content-sha256;x-amz-date
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
2025-11-11 20:52:05,139 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251111T205205Z
20251111/us-east-1/s3/aws4_request
2ac369592de97f96db85f158dd0f76fc9673175dbfc8003933276c498ef3f043
2025-11-11 20:52:05,139 - DEBUG - botocore.auth - add_auth: Signature:
4c322690ddcea51ed7ab5964a9ad4c3a33f44ffaedd1e823c475d934376c3ab0
2025-11-11 20:52:05,141 - DEBUG - botocore.hooks - _emit: Event request-created.s3.CreateBucket: calling handler <function add_retry_headers at 0x7c3539ed8430>
2025-11-11 20:52:05,141 - DEBUG - botocore.endpoint - _do_get_response: Sending http request: <AWSPreparedRequest stream_output=False, method=PUT, url=http://localhost:26209/csv_with_names_bzip2_bucket, headers={'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.11 md/pyimpl#CPython cfg/retry-mode#legacy Botocore/1.31.80', 'X-Amz-Date': b'20251111T205205Z', 'X-Amz-Content-SHA256': b'e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855', 'Authorization': b'AWS4-HMAC-SHA256 Credential=fake_key_id/20251111/us-east-1/s3/aws4_request, SignedHeaders=host;x-amz-content-sha256;x-amz-date, Signature=4c322690ddcea51ed7ab5964a9ad4c3a33f44ffaedd1e823c475d934376c3ab0', 'amz-sdk-invocation-id': b'6d366057-0567-4333-8632-7b1d8a6a274e', 'amz-sdk-request': b'attempt=1', 'Content-Length': '0'}>
2025-11-11 20:52:05,143 - DEBUG - urllib3.connectionpool - _get_conn: Resetting dropped connection: localhost
2025-11-11 20:52:05,168 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:26209 "PUT /csv_with_names_bzip2_bucket HTTP/1.1" 200 181
2025-11-11 20:52:05,169 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.11', 'Date': 'Tue, 11 Nov 2025 20:52:05 GMT', 'x-amzn-requestid': 'alOLDhAeVmFEtX4D1TrCiZH3SF7hNr3GcjZosjTjSA8c1aqmu671', 'Content-Type': 'text/html; charset=utf-8', 'Content-Length': '181', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-11-11 20:52:05,170 - DEBUG - botocore.parsers - parse: Response body:
b'<CreateBucketResponse xmlns="http://s3.amazonaws.com/doc/2006-03-01"><CreateBucketResponse><Bucket>csv_with_names_bzip2_bucket</Bucket></CreateBucketResponse></CreateBucketResponse>'
2025-11-11 20:52:05,176 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <botocore.retryhandler.RetryHandler object at 0x7b953a32b0b0>
2025-11-11 20:52:05,177 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-11-11 20:52:05,178 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.CreateBucket: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7b953a30dff0>>
2025-11-11 20:52:05,178 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3
2025-11-11 20:52:05,179 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, b7bdef95-d65f-4c92-87fb-44c689866d1e, ghrun-qykcqbcpue.auto.internal:20865): creating call state
2025-11-11 20:52:05,180 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, b7bdef95-d65f-4c92-87fb-44c689866d1e, ghrun-qykcqbcpue.auto.internal:20865): request = { session_id: "ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "CREATE OBJECT csv_with_names_bzip2_bucket_key_id (TYPE SECRET) WITH value=\'fake_key_id\'" } stats_mode: STATS_MODE_NONE }
2025-11-11 20:52:05,183 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, b7bdef95-d65f-4c92-87fb-44c689866d1e, ghrun-qykcqbcpue.auto.internal:20865): response = { <_MultiThreadedRendezvous object> }
2025-11-11 20:52:07,520 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3
2025-11-11 20:52:07,523 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3
2025-11-11 20:52:07,524 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, c540ea1f-2fc4-481e-8fe9-1fa840e1c13a, ghrun-qykcqbcpue.auto.internal:20865): creating call state
2025-11-11 20:52:07,532 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, c540ea1f-2fc4-481e-8fe9-1fa840e1c13a, ghrun-qykcqbcpue.auto.internal:20865): request = { session_id: "ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "CREATE OBJECT csv_with_names_bzip2_bucket_key_secret (TYPE SECRET) WITH value=\'fake_key_secret\'" } stats_mode: STATS_MODE_NONE }
2025-11-11 20:52:07,543 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, c540ea1f-2fc4-481e-8fe9-1fa840e1c13a, ghrun-qykcqbcpue.auto.internal:20865): response = { <_MultiThreadedRendezvous object> }
2025-11-11 20:52:09,759 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3
2025-11-11 20:52:09,760 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3
2025-11-11 20:52:09,761 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 75078d1d-c71e-4f1d-96ee-43fc81abfe38, ghrun-qykcqbcpue.auto.internal:20865): creating call state
2025-11-11 20:52:09,762 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 75078d1d-c71e-4f1d-96ee-43fc81abfe38, ghrun-qykcqbcpue.auto.internal:20865): request = { session_id: "ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "\n            CREATE EXTERNAL DATA SOURCE s3_source_csv_with_names_bzip2 WITH (\n                SOURCE_TYPE = \"ObjectStorage\",\n                LOCATION = \"http://localhost:26209/csv_with_names_bzip2_bucket\",\n                AUTH_METHOD=\"AWS\",\n                AWS_ACCESS_KEY_ID_SECRET_NAME=\"csv_with_names_bzip2_bucket_key_id\",\n                AWS_SECRET_ACCESS_KEY_SECRET_NAME=\"csv_with_names_bzip2_bucket_key_secret\",\n                AWS_REGION=\"us-east-1\"\n            );\n\n            CREATE EXTERNAL TABLE s3_table_csv_with_names_bzip2 (\n                \n            c_int8 Int8,\n            c_int16 Int16,\n            c_int32 Int32 NOT NULL,\n            c_int64 Int64,\n            c_uint8 Uint8,\n            c_uint16 Uint16,\n            c_uint32 Uint32,\n            c_uint64 Uint64,\n            c_float Float,\n            c_double Double,\n            c_string String,\n            c_utf8 Utf8,\n            c_json Json,\n            c_date Date,\n            c_datetime Datetime,\n            c_timestamp Timestamp\n        \n            ) WITH (\n                DATA_SOURCE=\"s3_source_csv_with_names_bzip2\",\n                LOCATION=\"/test_folder/\",\n                FORMAT=\"csv_with_names\",\n                COMPRESSION=\"bzip2\"\n            );\n        " } stats_mode: STATS_MODE_NONE }
2025-11-11 20:52:09,763 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 75078d1d-c71e-4f1d-96ee-43fc81abfe38, ghrun-qykcqbcpue.auto.internal:20865): response = { <_MultiThreadedRendezvous object> }
2025-11-11 20:52:10,414 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3
2025-11-11 20:52:10,414 - INFO - __tests__.test_types_and_formats - test_different_types_and_formats: Exporting into s3...
2025-11-11 20:52:10,415 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3
2025-11-11 20:52:10,417 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 4044bec8-2f6c-4830-95f0-56537f67f425, ghrun-qykcqbcpue.auto.internal:20865): creating call state
2025-11-11 20:52:10,418 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 4044bec8-2f6c-4830-95f0-56537f67f425, ghrun-qykcqbcpue.auto.internal:20865): request = { session_id: "ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO s3_table_csv_with_names_bzip2 SELECT * FROM olap_table_csv_with_names_bzip2" } stats_mode: STATS_MODE_NONE }
2025-11-11 20:52:10,419 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 4044bec8-2f6c-4830-95f0-56537f67f425, ghrun-qykcqbcpue.auto.internal:20865): response = { <_MultiThreadedRendezvous object> }
2025-11-11 20:52:11,242 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3
2025-11-11 20:52:11,243 - DEBUG - boto3.resources.factory - load_from_definition: Loading s3:Bucket
2025-11-11 20:52:11,244 - DEBUG - boto3.resources.model - _load_name_with_category: Renaming Bucket attribute name
2025-11-11 20:52:11,252 - DEBUG - botocore.hooks - _emit: Event creating-resource-class.s3.Bucket: calling handler <function lazy_call.<locals>._handler at 0x7c353abbfe10>
2025-11-11 20:52:11,254 - DEBUG - boto3.resources.collection - pages: Calling paginated s3:list_objects with {'Bucket': 'csv_with_names_bzip2_bucket'}
2025-11-11 20:52:11,254 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.ListObjects: calling handler <function set_list_objects_encoding_type_url at 0x7c3539ed9bd0>
2025-11-11 20:52:11,255 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.ListObjects: calling handler <function validate_bucket_name at 0x7c3539ede550>
2025-11-11 20:52:11,256 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.ListObjects: calling handler <function remove_bucket_from_url_paths_from_model at 0x7c3539ed8270>
2025-11-11 20:52:11,256 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.ListObjects: calling handler <bound method S3RegionRedirectorv2.annotate_request_context of <botocore.utils.S3RegionRedirectorv2 object at 0x7b953a2bfc30>>
2025-11-11 20:52:11,256 - DEBUG - botocore.hooks - _emit: Event before-parameter-build.s3.ListObjects: calling handler <function generate_idempotent_uuid at 0x7c3539ee05b0>
2025-11-11 20:52:11,257 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <function customize_endpoint_resolver_builtins at 0x7c3539ed7d30>
2025-11-11 20:52:11,257 - DEBUG - botocore.hooks - _emit: Event before-endpoint-resolution.s3: calling handler <bound method S3RegionRedirectorv2.redirect_from_cache of <botocore.utils.S3RegionRedirectorv2 object at 0x7b953a2bfc30>>
2025-11-11 20:52:11,258 - DEBUG - botocore.regions - construct_endpoint: Calling endpoint provider with parameters: {'Bucket': 'csv_with_names_bzip2_bucket', 'Region': 'us-east-1', 'UseFIPS': False, 'UseDualStack': False, 'Endpoint': 'http://localhost:26209', 'ForcePathStyle': True, 'Accelerate': False, 'UseGlobalEndpoint': True, 'DisableMultiRegionAccessPoints': False, 'UseArnRegion': True}
2025-11-11 20:52:11,261 - DEBUG - botocore.regions - construct_endpoint: Endpoint provider result: http://localhost:26209/csv_with_names_bzip2_bucket
2025-11-11 20:52:11,261 - 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-11 20:52:11,262 - DEBUG - botocore.regions - auth_schemes_to_signing_ctx: Selected auth type "v4" as "v4" with signing context params: {'region': 'us-east-1', 'signing_name': 's3', 'disableDoubleEncoding': True}
2025-11-11 20:52:11,263 - DEBUG - botocore.hooks - _emit: Event before-call.s3.ListObjects: calling handler <function add_expect_header at 0x7c3539edd750>
2025-11-11 20:52:11,263 - DEBUG - botocore.hooks - _emit: Event before-call.s3.ListObjects: calling handler <function add_recursion_detection_header at 0x7c3539ee1ff0>
2025-11-11 20:52:11,264 - DEBUG - botocore.hooks - _emit: Event before-call.s3.ListObjects: calling handler <function inject_api_version_header_if_needed at 0x7c3539ed87b0>
2025-11-11 20:52:11,264 - DEBUG - botocore.endpoint - make_request: Making request for OperationModel(name=ListObjects) with params: {'url_path': '', 'query_string': {'encoding-type': 'url'}, 'method': 'GET', 'headers': {'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.11 md/pyimpl#CPython cfg/retry-mode#legacy Botocore/1.31.80 Resource'}, 'body': b'', 'auth_path': '/csv_with_names_bzip2_bucket/', 'url': 'http://localhost:26209/csv_with_names_bzip2_bucket?encoding-type=url', 'context': {'client_region': 'us-east-1', 'client_config': <botocore.config.Config object at 0x7b953a1689b0>, 'has_streaming_input': False, 'auth_type': 'v4', 'encoding_type_auto_set': True, 's3_redirect': {'redirected': False, 'bucket': 'csv_with_names_bzip2_bucket', 'params': {'Bucket': 'csv_with_names_bzip2_bucket', 'EncodingType': 'url'}}, 'signing': {'region': 'us-east-1', 'signing_name': 's3', 'disableDoubleEncoding': True}}}
2025-11-11 20:52:11,266 - DEBUG - botocore.hooks - _emit: Event request-created.s3.ListObjects: calling handler <bound method RequestSigner.handler of <botocore.signers.RequestSigner object at 0x7b953a178bf0>>
2025-11-11 20:52:11,266 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.ListObjects: calling handler <bound method ClientCreator._default_s3_presign_to_sigv2 of <botocore.client.ClientCreator object at 0x7b953a20b570>>
2025-11-11 20:52:11,267 - DEBUG - botocore.hooks - _emit: Event choose-signer.s3.ListObjects: calling handler <function set_operation_specific_signer at 0x7c3539edea90>
2025-11-11 20:52:11,267 - DEBUG - botocore.hooks - _emit: Event before-sign.s3.ListObjects: calling handler <function remove_arn_from_signing_path at 0x7c3539ed7ef0>
2025-11-11 20:52:11,268 - DEBUG - botocore.auth - add_auth: Calculating signature using v4 auth.
2025-11-11 20:52:11,269 - DEBUG - botocore.auth - add_auth: CanonicalRequest:
GET
/csv_with_names_bzip2_bucket
encoding-type=url
host:localhost:26209
x-amz-content-sha256:e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
x-amz-date:20251111T205211Z

host;x-amz-content-sha256;x-amz-date
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855
2025-11-11 20:52:11,269 - DEBUG - botocore.auth - add_auth: StringToSign:
AWS4-HMAC-SHA256
20251111T205211Z
20251111/us-east-1/s3/aws4_request
53dd62c3078839adaf9777324626ce3d04bd067049171119a3e775ec29daad5a
2025-11-11 20:52:11,270 - DEBUG - botocore.auth - add_auth: Signature:
7b1eecccd39688f09deebf8708e917596d41e2a6bcc09a3d5d5fd668da48fed0
2025-11-11 20:52:11,270 - DEBUG - botocore.hooks - _emit: Event request-created.s3.ListObjects: calling handler <function add_retry_headers at 0x7c3539ed8430>
2025-11-11 20:52:11,271 - DEBUG - botocore.endpoint - _do_get_response: Sending http request: <AWSPreparedRequest stream_output=False, method=GET, url=http://localhost:26209/csv_with_names_bzip2_bucket?encoding-type=url, headers={'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.11 md/pyimpl#CPython cfg/retry-mode#legacy Botocore/1.31.80 Resource', 'X-Amz-Date': b'20251111T205211Z', 'X-Amz-Content-SHA256': b'e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855', 'Authorization': b'AWS4-HMAC-SHA256 Credential=fake_key_id/20251111/us-east-1/s3/aws4_request, SignedHeaders=host;x-amz-content-sha256;x-amz-date, Signature=7b1eecccd39688f09deebf8708e917596d41e2a6bcc09a3d5d5fd668da48fed0', 'amz-sdk-invocation-id': b'1c16676c-83b3-4b9c-b512-2d16150a8339', 'amz-sdk-request': b'attempt=1'}>
2025-11-11 20:52:11,272 - DEBUG - urllib3.connectionpool - _get_conn: Resetting dropped connection: localhost
2025-11-11 20:52:11,282 - DEBUG - urllib3.connectionpool - _make_request: http://localhost:26209 "GET /csv_with_names_bzip2_bucket?encoding-type=url HTTP/1.1" 200 984
2025-11-11 20:52:11,283 - DEBUG - botocore.parsers - parse: Response headers: {'Server': 'Werkzeug/2.2.3 Python/3.12.11', 'Date': 'Tue, 11 Nov 2025 20:52:11 GMT', 'x-amzn-requestid': 'jYY99Mj3AgD4c5zZReRpxr4zy3G8OS7WZ8vp2vakeuMEKjbMj8e8', 'Content-Type': 'text/html; charset=utf-8', 'Content-Length': '984', 'Access-Control-Allow-Origin': '*', 'Connection': 'close'}
2025-11-11 20:52:11,284 - DEBUG - botocore.parsers - parse: Response body:
b'<?xml version="1.0" encoding="UTF-8"?><ListBucketResult xmlns="http://s3.amazonaws.com/doc/2006-03-01/"><Name>csv_with_names_bzip2_bucket</Name><MaxKeys>1000</MaxKeys><EncodingType>url</EncodingType><IsTruncated>false</IsTruncated><Contents><Key>test_folder/4ILJWxCpnEmEBruOb9VzvL2YbElA13g5.csv.bz2</Key><LastModified>2025-11-11T20:52:11.000Z</LastModified><ETag>&#34;adc17d3d68be7f56a94b2af67ae8aeac&#34;</ETag><Size>184</Size><StorageClass>STANDARD</StorageClass><Owner><ID>75aa57f09aa0c8caeab4f8c24e99d10f8e7faeebf76c078efc7c6caea54ba06a</ID><DisplayName>webfile</DisplayName></Owner></Contents><Contents><Key>test_folder/n8YWaenFX0uZ_5RBdDXDkYWKrjGhk06p.csv.bz2</Key><LastModified>2025-11-11T20:52:11.000Z</LastModified><ETag>&#34;76a40454baf0de2adbbc308a52523b85&#34;</ETag><Size>131</Size><StorageClass>STANDARD</StorageClass><Owner><ID>75aa57f09aa0c8caeab4f8c24e99d10f8e7faeebf76c078efc7c6caea54ba06a</ID><DisplayName>webfile</DisplayName></Owner></Contents></ListBucketResult>'
2025-11-11 20:52:11,287 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.ListObjects: calling handler <botocore.retryhandler.RetryHandler object at 0x7b953a2ad2b0>
2025-11-11 20:52:11,288 - DEBUG - botocore.retryhandler - __call__: No retry needed.
2025-11-11 20:52:11,288 - DEBUG - botocore.hooks - _emit: Event needs-retry.s3.ListObjects: calling handler <bound method S3RegionRedirectorv2.redirect_from_error of <botocore.utils.S3RegionRedirectorv2 object at 0x7b953a2bfc30>>
2025-11-11 20:52:11,289 - DEBUG - botocore.hooks - _emit: Event after-call.s3.ListObjects: calling handler <function decode_list_object at 0x7c3539ed9cb0>
2025-11-11 20:52:11,290 - DEBUG - boto3.resources.factory - load_from_definition: Loading s3:ObjectSummary
2025-11-11 20:52:11,291 - DEBUG - boto3.resources.model - _load_name_with_category: Renaming ObjectSummary attribute key
2025-11-11 20:52:11,293 - DEBUG - botocore.hooks - _emit: Event creating-resource-class.s3.ObjectSummary: calling handler <function lazy_call.<locals>._handler at 0x7c353abc68d0>
2025-11-11 20:52:11,294 - INFO - __tests__.test_types_and_formats - test_different_types_and_formats: Exporting finished, bucket stats: (2, 315)
2025-11-11 20:52:11,294 - INFO - __tests__.test_types_and_formats - test_different_types_and_formats: Importing into ydb...
2025-11-11 20:52:11,295 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3
2025-11-11 20:52:11,296 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, c365ffbf-8a20-4e28-848f-787625eb109d, ghrun-qykcqbcpue.auto.internal:20865): creating call state
2025-11-11 20:52:11,296 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, c365ffbf-8a20-4e28-848f-787625eb109d, ghrun-qykcqbcpue.auto.internal:20865): request = { session_id: "ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "\n            CREATE TABLE from_s3_csv_with_names_bzip2 (\n                PRIMARY KEY (c_int32)\n            ) WITH (\n                STORE = COLUMN\n            ) AS SELECT * FROM s3_table_csv_with_names_bzip2\n        " } stats_mode: STATS_MODE_NONE }
2025-11-11 20:52:11,298 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, c365ffbf-8a20-4e28-848f-787625eb109d, ghrun-qykcqbcpue.auto.internal:20865): response = { <_MultiThreadedRendezvous object> }
2025-11-11 20:52:17,617 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3
2025-11-11 20:52:17,618 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3
2025-11-11 20:52:17,631 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, de65ac56-ba4d-4c5b-a964-ecbf02eae2a1, ghrun-qykcqbcpue.auto.internal:20865): creating call state
2025-11-11 20:52:17,683 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, de65ac56-ba4d-4c5b-a964-ecbf02eae2a1, ghrun-qykcqbcpue.auto.internal:20865): request = { session_id: "ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "\n            SELECT\n                String::Hex(Sum(Digest::MurMurHash32(Pickle(TableRow())))) AS check_hash,\n                COUNT(*) AS check_size\n            FROM from_s3_csv_with_names_bzip2;\n\n            SELECT\n                String::Hex(Sum(Digest::MurMurHash32(Pickle(TableRow())))) AS olap_hash,\n                COUNT(*) AS olap_size\n            FROM olap_table_csv_with_names_bzip2;\n        " } stats_mode: STATS_MODE_NONE }
2025-11-11 20:52:17,691 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, de65ac56-ba4d-4c5b-a964-ecbf02eae2a1, ghrun-qykcqbcpue.auto.internal:20865): response = { <_MultiThreadedRendezvous object> }
2025-11-11 20:52:20,960 - DEBUG - ydb.resolver.DiscoveryEndpointsResolver - context_resolve: Preparing initial endpoint to resolve endpoints
2025-11-11 20:52:20,982 - DEBUG - ydb.connection - channel_factory: Channel options: [('grpc.max_receive_message_length', 64000000), ('grpc.max_send_message_length', 64000000), ('grpc.primary_user_agent', 'python-library'), ('grpc.lb_policy_name', 'round_robin'), ('grpc.keepalive_time_ms', 1250), ('grpc.keepalive_timeout_ms', 10000), ('grpc.http2.max_pings_without_data', 0), ('grpc.keepalive_permit_without_calls', 0)]
2025-11-11 20:52:21,011 - DEBUG - ydb.resolver.DiscoveryEndpointsResolver - context_resolve: Resolving endpoints for database /Root
2025-11-11 20:52:21,012 - DEBUG - ydb.connection - _prepare_call: RpcState(ListEndpoints, f665ca6a-b0a0-46b5-aff9-79da41fa8e9b, localhost:20865): creating call state
2025-11-11 20:52:21,012 - DEBUG - ydb.connection - _log_request: RpcState(ListEndpoints, f665ca6a-b0a0-46b5-aff9-79da41fa8e9b, localhost:20865): request = { database: "/Root" }
2025-11-11 20:52:21,699 - DEBUG - ydb.connection - _log_response: RpcState(ListEndpoints, f665ca6a-b0a0-46b5-aff9-79da41fa8e9b, localhost:20865): response = { operation { ready: true status: SUCCESS result { [type.googleapis.com/Ydb.Discovery.ListEndpointsResult] { endpoints { address: "ghrun-qykcqbcpue.auto.internal" port: 20865 service: "legacy" service: "tablet_service" service: "yql" service: "discovery" service: "cms" service: "locking" service: "kesus" service: "pq" service: "pqcd" service: "pqv1" service: "topic" service: "datastreams" service: "scripting" service: "clickhouse_internal" service: "rate_limiter" service: "analytics" service: "export" service: "import" service: "yq" service: "keyvalue" service: "monitoring" service: "auth" service: "query_service" service: "view" location: "1" node_id: 1 } self_location: "1" } } } }
2025-11-11 20:52:21,707 - DEBUG - ydb.resolver.DiscoveryEndpointsResolver - _add_debug_details: Resolved endpoints for database /Root: DiscoveryResult <self_location: 1, endpoints [<Endpoint ghrun-qykcqbcpue.auto.internal:20865, location 1, ssl: False>]>
2025-11-11 20:52:21,716 - INFO - ydb.connection - close: Closing channel for endpoint localhost:20865
2025-11-11 20:52:22,187 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=OTQ3ZDljMGQtMjM3ZGU4LWEyZmZkNTRlLWJiNTM5NmY3
2025-11-11 20:52:22,209 - INFO - ya.test - pytest_runtest_teardown: Test teardown
