search

wix-incubator / quix

Quix Notebook Manager
https://wix-incubator.github.io/quix/
MIT License
267 stars 37 forks source link

Trino and Quix Docker - Queries don't run #503

Open ai-noahdolev opened 1 year ago

ai-noahdolev commented 1 year ago

Hi all,

I am running Quix successfully using docker compose with the following .env file:

MODULES=trino
MODULES_TRINO_ENGINE=presto
MODULES_TRINO_API=http://host.docker.internal:9080/v1
MODULES_TRINO_CATALOG=memory
MODULES_TRINO_SCHEMA=default
MODULES_TRINO_SOURCE=quix
MODULES_TRINO_DB_EMPTY_TIMEOUT=60000
MODULES_TRINO_DB_REQUEST_TIMEOUT=10000
MODULES_TRINO_HTTP_HEADERS_PREFIX=X-TRINO-

And my Trino DB is running locally on the same machine as the Quix Docker container. I added the 

    extra_hosts:
      host.docker.internal: host-gateway

to the docker-compose.yml and I can see my DB and it's tables in the DB Explorer. However my queries don't run.

Connection failed after (10) retries, please rerun your query manually.   
This is most likely a transient network error and not a problem with the Trino engine.

I can't see them being submitted in the Trino UI and I don't see anything happening when I docker attach quix-backend-1. When I use the TRINO CLI, queries run normally.

Any ideas where I've gone wrong?

ai-noahdolev commented 1 year ago

Actually, they don't seem to run for the example Preso server either. Querying the DB in the DB explorer seems to work but queries don't seem to actually submit.