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

1-Click Deploy - App Crashing #112

Open
shrimpynuts opened this issue Aug 4, 2022 · 2 comments
Open

1-Click Deploy - App Crashing #112

shrimpynuts opened this issue Aug 4, 2022 · 2 comments

Comments

@shrimpynuts
Copy link

shrimpynuts commented Aug 4, 2022

Attempted to use "Deploy to Heroku" button several times today.
(https://heroku.com/deploy?template=https://github.com/hasura/graphql-engine-heroku)
I continue to get "Application Error", with the server crashing.

I checked the logs with heroku logs --tail -a [app-name], getting this:

2022-08-04T23:11:43.006177+00:00 app[web.1]: {"detail":{"info":{"admin_secret_set":false,"auth_hook":null,"auth_hook_mode":null,"console_assets_dir":null,"cors_config":{"allowed_origins":"*","disabled":false,"ws_read_cookie":null},"enable_allowlist":false,"enable_console":true,"enable_maintenance_mode":false,"enable_metadata_query_logging":false,"enable_telemetry":true,"enabled_apis":["config","pgdump","graphql","metadata"],"enabled_log_types":["startup","webhook-log","websocket-log","http-log"],"events_fetch_batch_size":100,"experimental_features":[],"graceful_shutdown_timeout":60,"infer_function_permissions":true,"jwt_secret":[],"live_query_options":{"batch_size":100,"refetch_delay":1},"log_level":"info","port":40462,"remote_schema_permissions":false,"server_host":"HostAny","stringify_numeric_types":false,"transaction_isolation":"ISOLATION LEVEL READ COMMITTED","unauth_role":null,"use_prepared_statements":true,"v1-boolean-null-collapse":false,"websocket_compression_options":"NoCompression","websocket_connection_init_timeout":"WSConnectionInitTimeout {unWSConnectionInitTimeout = Seconds {seconds = 3s}}","websocket_keep_alive":"KeepAliveDelay {unKeepAliveDelay = Seconds {seconds = 5s}}"},"kind":"server_configuration"},"level":"info","timestamp":"2022-08-04T23:11:43.003+0000","type":"startup"}
2022-08-04T23:11:43.006185+00:00 app[web.1]: {"detail":{"info":{"database_url":"postgres://eavsbuwcdjkxdi:[email protected]:5432/d2fu2qakftai2n","retries":1},"kind":"postgres_connection"},"level":"info","timestamp":"2022-08-04T23:11:43.003+0000","type":"startup"}
2022-08-04T23:11:43.198475+00:00 app[web.1]: {"detail":{"info":{"code":"postgres-error","error":"pgcrypto extension is required, but it could not be created; encountered unknown postgres error","internal":{"arguments":[],"error":{"description":null,"exec_status":"FatalError","hint":null,"message":"extension \"pgcrypto\" must be installed in schema \"heroku_ext\"","status_code":"0A000"},"prepared":false,"statement":"CREATE EXTENSION IF NOT EXISTS pgcrypto SCHEMA public"},"path":"$"},"kind":"catalog_migrate"},"level":"error","timestamp":"2022-08-04T23:11:43.003+0000","type":"startup"}
2022-08-04T23:11:43.198553+00:00 app[web.1]: {"code":"postgres-error","error":"pgcrypto extension is required, but it could not be created; encountered unknown postgres error","internal":{"arguments":[],"error":{"description":null,"exec_status":"FatalError","hint":null,"message":"extension \"pgcrypto\" must be installed in schema \"heroku_ext\"","status_code":"0A000"},"prepared":false,"statement":"CREATE EXTENSION IF NOT EXISTS pgcrypto SCHEMA public"},"path":"$"}
2022-08-04T23:11:43.322838+00:00 heroku[web.1]: Process exited with status 1
2022-08-04T23:11:43.372902+00:00 heroku[web.1]: State changed from starting to crashed
2022-08-04T23:11:50.100147+00:00 heroku[router]: at=error code=H10 desc="App crashed" method=GET path="/" host=stage-exitweb2.herokuapp.com request_id=70c09e30-7670-4e70-812a-e39a09e23afa fwd="76.21.127.10" dyno= connect= service= status=503 bytes= protocol=https
2022-08-04T23:11:50.581709+00:00 heroku[router]: at=error code=H10 desc="App crashed" method=GET path="/favicon.ico" host=stage-exitweb2.herokuapp.com request_id=7be5826b-0a2a-4de5-9374-9498d59ad5a8 fwd="76.21.127.10" dyno= connect= service= status=503 bytes= protocol=https

Seems like it might have something to do with the postgres extension "pgcrypto"?

Any guidance here would be greatly appreciated.

@rikinsk
Copy link
Member

rikinsk commented Aug 5, 2022

Hey, this seems to be due to a recent change in the way Heroku Postgres DBs handle extensions now.

We are working on a fix for this.

@treyhuffine
Copy link

@rikinsk is there an update on this? It seems like a pretty bad blocker for getting started with Hasura.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants