1-Click Deploy - App Crashing

[shrimpynuts]

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:...@ec2-44-206-197-71.compute-1.amazonaws.com: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]

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]

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