You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@iceberg.apache.org by "samueljackson92 (via GitHub)" <gi...@apache.org> on 2024/06/13 13:59:53 UTC
[I] Custom s3 endpoint: Unable to execute HTTP request: Remote host terminated the handshake [iceberg]
samueljackson92 opened a new issue, #10490:
URL: https://github.com/apache/iceberg/issues/10490
### Apache Iceberg version
1.5.2 (latest release)
### Query engine
None
### Please describe the bug 🐞
Hi,
I am experimenting with setting up Iceberg locally and I am trying to connect to a custom s3 endpoint to use as the backend for my project.
I am getting the following HTTP error when trying to create a new table:
```
Traceback (most recent call last):
File "/Users/rt2549/miniconda3/envs/iceberg/lib/python3.11/site-packages/pyiceberg/catalog/rest.py", line 470, in create_table
response.raise_for_status()
File "/Users/rt2549/miniconda3/envs/iceberg/lib/python3.11/site-packages/requests/models.py", line 1024, in raise_for_status
raise HTTPError(http_error_msg, response=self)
requests.exceptions.HTTPError: 500 Server Error: Server Error for url: http://localhost:8181/v1/namespaces/default/tables
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/Users/rt2549/projects/test-db/ingest.py", line 29, in <module>
main()
File "/Users/rt2549/projects/test-db/ingest.py", line 22, in main
table = catalog.create_table(
^^^^^^^^^^^^^^^^^^^^^
File "/Users/rt2549/miniconda3/envs/iceberg/lib/python3.11/site-packages/pyiceberg/catalog/rest.py", line 472, in create_table
self._handle_non_200_response(exc, {409: TableAlreadyExistsError})
File "/Users/rt2549/miniconda3/envs/iceberg/lib/python3.11/site-packages/pyiceberg/catalog/rest.py", line 382, in _handle_non_200_response
raise exception(response) from exc
pyiceberg.exceptions.ServerError: SdkClientException: Unable to execute HTTP request: Remote host terminated the handshake
```
My ingestion script looks like the following:
```python
from pyiceberg.catalog import load_catalog
import pyarrow as pa
import pyarrow.parquet as pq
def main():
s3_config = {
"uri": "http://localhost:8181",
"s3.endpoint": "https://s3.echo.stfc.ac.uk",
"s3.access-key-id": "<my-key>",
"s3.secret-access-key": "<my-secret>",
"s3.region": "us-east-1",
"py-io-impl": "pyiceberg.io.pyarrow.PyArrowFileIO",
}
catalog = load_catalog("default", **s3_config)
df: pa.Table = pq.read_table("signals.parquet")
df = df.drop_columns("description")
catalog.create_namespace("default")
table = catalog.create_table(
"default.signals",
schema=df.schema,
)
if __name__ == "__main__":
main()
```
My docker compose is copied from the iceberg tutorial:
```yaml
version: "3"
services:
rest:
image: tabulario/iceberg-rest
container_name: iceberg-rest
networks:
iceberg_net:
ports:
- 8181:8181
environment:
- AWS_ACCESS_KEY_ID=<access-key>
- AWS_SECRET_ACCESS_KEY=<access-secret>
- AWS_REGION=us-east-1
- CATALOG_WAREHOUSE=s3://mast/test/warehouse/
- CATALOG_IO__IMPL=org.apache.iceberg.aws.s3.S3FileIO
- CATALOG_S3_ENDPOINT=https://s3.echo.stfc.ac.uk
networks:
iceberg_net:
```
I can create and `ls` files with my s3 credentials at that endpoint with other tools with no problem.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] Custom s3 endpoint: Unable to execute HTTP request: Remote host terminated the handshake [iceberg]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed issue #10490: Custom s3 endpoint: Unable to execute HTTP request: Remote host terminated the handshake
URL: https://github.com/apache/iceberg/issues/10490
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] Custom s3 endpoint: Unable to execute HTTP request: Remote host terminated the handshake [iceberg]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #10490:
URL: https://github.com/apache/iceberg/issues/10490#issuecomment-2566766228
This issue has been closed because it has not received any activity in the last 14 days since being marked as 'stale'
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] Custom s3 endpoint: Unable to execute HTTP request: Remote host terminated the handshake [iceberg]
Posted by "nastra (via GitHub)" <gi...@apache.org>.
nastra commented on issue #10490:
URL: https://github.com/apache/iceberg/issues/10490#issuecomment-2168277444
It complains because it can't access `http://localhost:8181/v1/namespaces/default/tables`. Make sure that the REST server is accessible via that URI
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org
Re: [I] Custom s3 endpoint: Unable to execute HTTP request: Remote host terminated the handshake [iceberg]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #10490:
URL: https://github.com/apache/iceberg/issues/10490#issuecomment-2547212745
This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org