Julio Venegas
05/23/2021, 7:30 PMusername@server-name
. In order to get hasura running I have to escape the @
in the username with %40
but that leads to the following graphql error
graphql_1 | Could not upgrade the database!
graphql_1 | Error: invalid interpolation syntax in '<postgres://prefectpgadmin>%40sql-dev-prefect:REDACTED_PSWD@sql-dev-prefect.postgres.database.azure.com:5432/sqldb-dev-prefect' at position 25
Any suggestions about what I can to avoid the graphql interpolation issue?Chris White
05/23/2021, 7:43 PM@
for running the migrations, but escape it for hasuraJulio Venegas
05/23/2021, 7:47 PM@
for the migrations intact?Chris White
05/23/2021, 7:49 PMPREFECT_SERVER__DATABASE__CONNECTION_URL
with the @
in the process that you intend to run the upgrade CLI command from, and all your other services should run with the escaped env var setJulio Venegas
05/23/2021, 8:03 PMPREFECT_SERVER__DATABASE__CONNECTION_URL
with the @
in the username, followed by prefect server start --external-postgres
. In this case, Hasura parsed the connection string wrong, throwing an error. Then I exported PREFECT_SERVER__DATABASE__CONNECTION_URL
changing the @ for %40
In this case graphql raised the error I originally mentioned. I have not ran any upgrade commands in the CLI, I’ve only ran prefect server start --external-postgres
Chris White
05/23/2021, 8:07 PM%40
, run prefect server start --external-postgres --no-upgrade
• install Prefect Server and then set the environment variable with the @
sign; now you can run prefect-server database upgrade
to upgrade the DB separatelyJulio Venegas
05/23/2021, 8:08 PMChris White
05/23/2021, 8:25 PMJulio Venegas
05/23/2021, 8:27 PMtowel_1 | {"severity": "ERROR", "name": "prefect-server.ZombieKiller", "message": "Unexpected error: ValueError([{'extensions': {'path': '$.selectionSet.task_run', 'code': 'validation-failed'}, 'message': 'field \"task_run\" not found in type: \\'query_root\\''}])"}
Chris White
05/23/2021, 8:41 PMJulio Venegas
05/23/2021, 8:42 PM(py38) adminuser@vmdataorchestration:~$ prefect-server database upgrade
Are you sure you want to upgrade the database? [y/N]: y
Running Alembic migrations...
INFO [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO [alembic.runtime.migration] Will assume transactional DDL.
Applied Hasura metadata from /home/adminuser/Code/server/services/hasura/migrations/metadata.yaml
Database upgraded!
Chris White
05/23/2021, 8:44 PMprefect-server start
commandJulio Venegas
05/23/2021, 8:47 PMprefect server start
did it ❤️Chris White
05/23/2021, 8:47 PMJulio Venegas
05/23/2021, 8:48 PM@
in user names, their support team must hate that decisionChris White
05/23/2021, 8:49 PMJulio Venegas
05/23/2021, 8:54 PMprefect-server database upgrade
I get the following error even though I’ve changed the config.toml with the export and I can see the external host in the config.
Error: (psycopg2.OperationalError) could not connect to server: Connection refused
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5432?
export PREFECT__SERVER
instead of export PREFECT_SERVER
and I see that in the server repo, there’s a config.toml that is accessed under perfect_server
i.e single underscore not double.