Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

After a pg_lakehouse error, subsequent queries crash with "there is no reactor running" #1136

Closed
neilyio opened this issue May 14, 2024 · 0 comments · Fixed by #1224
Closed
Labels
bug Something isn't working pg_lakehouse Issue related to `pg_lakehouse/` priority-1-high High priority issue

Comments

@neilyio
Copy link
Contributor

neilyio commented May 14, 2024

Bug Description
After a runtime error in a pg_lakehouse query, we're stuck with:

Query 1 ERROR at Line 1: : ERROR:  there is no reactor running, must be called from the context of a Tokio 1.x runtime

How To Reproduce
Follow quickstart to CREATE FOREIGN TABLE trips.

Turn off wifi, so that the extension cannot talk to AWS.

Run SELECT COUNT(*) FROM trips;, which should produce:

   error sending request for url (https://s3.us-east-1.amazonaws.com/paradedb-benchmarks/yellow_tripdata_2024-01.parquet): client error (Connect): dns error: failed to lookup address information: nodename nor servname provided, or not known: failed to lookup address information: nodename nor servname provided, or not known

Run SELECT COUNT(*) FROM trips; again, which produces:

Query 1 ERROR at Line 1: : ERROR:  there is no reactor running, must be called from the context of a Tokio 1.x runtime

The error persists until the extension is reloaded.

@neilyio neilyio added pg_lakehouse Issue related to `pg_lakehouse/` bug Something isn't working priority-1-high High priority issue labels May 14, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working pg_lakehouse Issue related to `pg_lakehouse/` priority-1-high High priority issue
Projects
None yet
1 participant