When start quickstart.yml throw many error message #2738

leapit · 2021-09-10T07:30:28Z

leapit
Sep 10, 2021

I run Hydra via quickstart.yml and quickstart-postgres.yml,got below error message

Attaching to hydra_postgresd_1, hydra_hydra-migrate_1, hydra_consent_1, hydra_hydra_1
consent_1        | 
consent_1        | > [email protected] serve /usr/src/app
consent_1        | > node lib/app.js
consent_1        | 
hydra-migrate_1  | time=2021-09-09T09:50:53Z level=info msg=No tracer configured - skipping tracing setup audience=application service_name=ORY Hydra service_version=v1.10.6
consent_1        | Listening on http://0.0.0.0:3000
hydra-migrate_1  | The following migration is planned:
hydra-migrate_1  | 
postgresd_1      | The files belonging to this database system will be owned by user "postgres".
postgresd_1      | This user must also own the server process.
postgresd_1      | 
postgresd_1      | The database cluster will be initialized with locale "en_US.utf8".
postgresd_1      | The default database encoding has accordingly been set to "UTF8".
postgresd_1      | The default text search configuration will be set to "english".
postgresd_1      | 
postgresd_1      | Data page checksums are disabled.
postgresd_1      | 
postgresd_1      | fixing permissions on existing directory /var/lib/postgresql/data ... ok
hydra-migrate_1  | Could not get the migration status:
hydra-migrate_1  | failed to connect to `host=postgresd user=hydra database=hydra`: dial error (dial tcp 172.26.0.2:5432: connect: connection refused)
hydra-migrate_1  | problem with migration
hydra-migrate_1  | github.com/ory/x/popx.(*Migrator).Status
hydra-migrate_1  | 	/go/pkg/mod/github.com/ory/[email protected]/popx/migrator.go:466
hydra-migrate_1  | github.com/ory/hydra/persistence/sql.(*Persister).MigrationStatus
hydra-migrate_1  | 	/home/ory/persistence/sql/persister_migration.go:24
hydra-migrate_1  | github.com/ory/hydra/cmd/cli.(*MigrateHandler).MigrateSQL
hydra-migrate_1  | 	/home/ory/cmd/cli/handler_migrate.go:89
hydra-migrate_1  | github.com/spf13/cobra.(*Command).execute
hydra-migrate_1  | 	/go/pkg/mod/github.com/spf13/[email protected]/command.go:856
hydra-migrate_1  | github.com/spf13/cobra.(*Command).ExecuteC
hydra-migrate_1  | 	/go/pkg/mod/github.com/spf13/[email protected]/command.go:960
hydra-migrate_1  | github.com/spf13/cobra.(*Command).Execute
hydra-migrate_1  | 	/go/pkg/mod/github.com/spf13/[email protected]/command.go:897
hydra-migrate_1  | github.com/ory/hydra/cmd.Execute
hydra-migrate_1  | 	/home/ory/cmd/root.go:87
hydra-migrate_1  | main.main
hydra-migrate_1  | 	/home/ory/main.go:33
hydra-migrate_1  | runtime.main
hydra-migrate_1  | 	/usr/local/go/src/runtime/proc.go:225
hydra-migrate_1  | runtime.goexit
hydra-migrate_1  | 	/usr/local/go/src/runtime/asm_amd64.s:1371
postgresd_1      | creating subdirectories ... ok
postgresd_1      | selecting default max_connections ... 100
postgresd_1      | selecting default shared_buffers ... 128MB
postgresd_1      | selecting default timezone ... Etc/UTC
postgresd_1      | selecting dynamic shared memory implementation ... posix
postgresd_1      | creating configuration files ... ok
postgresd_1      | running bootstrap script ... ok
hydra_1          | time=2021-09-09T09:50:55Z level=info msg=No tracer configured - skipping tracing setup audience=application service_name=ORY Hydra service_version=v1.10.6
hydra_1          | time=2021-09-09T09:50:55Z level=fatal msg=Could not ensure that signing keys for "hydra.openid.id-token" exists. A network error occurred, see error for specific details. audience=application error=map[message:failed to connect to `host=postgresd user=hydra database=hydra`: dial error (dial tcp 172.26.0.2:5432: connect: connection refused)] service_name=ORY Hydra service_version=v1.10.6
postgresd_1      | performing post-bootstrap initialization ... ok
hydra_hydra-migrate_1 exited with code 1
postgresd_1      | syncing data to disk ... ok
postgresd_1      | 
postgresd_1      | Success. You can now start the database server using:
postgresd_1      | 
postgresd_1      |     pg_ctl -D /var/lib/postgresql/data -l logfile start
postgresd_1      | 
postgresd_1      | 
postgresd_1      | WARNING: enabling "trust" authentication for local connections
postgresd_1      | You can change this by editing pg_hba.conf or using the option -A, or
postgresd_1      | --auth-local and --auth-host, the next time you run initdb.
postgresd_1      | waiting for server to start....LOG:  database system was shut down at 2021-09-09 09:50:55 UTC
postgresd_1      | LOG:  MultiXact member wraparound protections are now enabled
postgresd_1      | LOG:  autovacuum launcher started
postgresd_1      | LOG:  database system is ready to accept connections
hydra-migrate_1  | time=2021-09-09T09:50:53Z level=info msg=No tracer configured - skipping tracing setup audience=application service_name=ORY Hydra service_version=v1.10.6
hydra-migrate_1  | The following migration is planned:
hydra-migrate_1  | 
hydra-migrate_1  | Could not get the migration status:
hydra-migrate_1  | failed to connect to `host=postgresd user=hydra database=hydra`: dial error (dial tcp 172.26.0.2:5432: connect: connection refused)
hydra-migrate_1  | problem with migration
hydra-migrate_1  | github.com/ory/x/popx.(*Migrator).Status
hydra-migrate_1  | 	/go/pkg/mod/github.com/ory/[email protected]/popx/migrator.go:466
hydra-migrate_1  | github.com/ory/hydra/persistence/sql.(*Persister).MigrationStatus
hydra-migrate_1  | 	/home/ory/persistence/sql/persister_migration.go:24
hydra-migrate_1  | github.com/ory/hydra/cmd/cli.(*MigrateHandler).MigrateSQL
hydra-migrate_1  | 	/home/ory/cmd/cli/handler_migrate.go:89
hydra-migrate_1  | github.com/spf13/cobra.(*Command).execute
hydra-migrate_1  | 	/go/pkg/mod/github.com/spf13/[email protected]/command.go:856
hydra-migrate_1  | github.com/spf13/cobra.(*Command).ExecuteC
hydra-migrate_1  | 	/go/pkg/mod/github.com/spf13/[email protected]/command.go:960
hydra-migrate_1  | github.com/spf13/cobra.(*Command).Execute
hydra-migrate_1  | 	/go/pkg/mod/github.com/spf13/[email protected]/command.go:897
hydra-migrate_1  | github.com/ory/hydra/cmd.Execute
hydra-migrate_1  | 	/home/ory/cmd/root.go:87
hydra-migrate_1  | main.main
hydra-migrate_1  | 	/home/ory/main.go:33
hydra-migrate_1  | runtime.main
hydra-migrate_1  | 	/usr/local/go/src/runtime/proc.go:225
hydra-migrate_1  | runtime.goexit
hydra-migrate_1  | 	/usr/local/go/src/runtime/asm_amd64.s:1371
hydra-migrate_1  | time=2021-09-09T09:50:55Z level=info msg=No tracer configured - skipping tracing setup audience=application service_name=ORY Hydra service_version=v1.10.6
hydra-migrate_1  | The following migration is planned:
hydra-migrate_1  | 
hydra-migrate_1  | Could not get the migration status:
hydra-migrate_1  | failed to connect to `host=postgresd user=hydra database=hydra`: dial error (dial tcp 172.26.0.2:5432: connect: connection refused)
hydra-migrate_1  | problem with migration
hydra-migrate_1  | github.com/ory/x/popx.(*Migrator).Status
hydra-migrate_1  | 	/go/pkg/mod/github.com/ory/[email protected]/popx/migrator.go:466
hydra-migrate_1  | github.com/ory/hydra/persistence/sql.(*Persister).MigrationStatus
hydra-migrate_1  | 	/home/ory/persistence/sql/persister_migration.go:24
hydra-migrate_1  | github.com/ory/hydra/cmd/cli.(*MigrateHandler).MigrateSQL
hydra-migrate_1  | 	/home/ory/cmd/cli/handler_migrate.go:89
hydra-migrate_1  | github.com/spf13/cobra.(*Command).execute
hydra-migrate_1  | 	/go/pkg/mod/github.com/spf13/[email protected]/command.go:856
hydra-migrate_1  | github.com/spf13/cobra.(*Command).ExecuteC
hydra-migrate_1  | 	/go/pkg/mod/github.com/spf13/[email protected]/command.go:960
hydra-migrate_1  | github.com/spf13/cobra.(*Command).Execute
hydra-migrate_1  | 	/go/pkg/mod/github.com/spf13/[email protected]/command.go:897
hydra-migrate_1  | github.com/ory/hydra/cmd.Execute
hydra-migrate_1  | 	/home/ory/cmd/root.go:87
hydra-migrate_1  | main.main
hydra-migrate_1  | 	/home/ory/main.go:33
hydra-migrate_1  | runtime.main
hydra-migrate_1  | 	/usr/local/go/src/runtime/proc.go:225
hydra-migrate_1  | runtime.goexit
hydra-migrate_1  | 	/usr/local/go/src/runtime/asm_amd64.s:1371
hydra-migrate_1  | time=2021-09-09T09:50:56Z level=info msg=No tracer configured - skipping tracing setup audience=application service_name=ORY Hydra service_version=v1.10.6
hydra-migrate_1  | The following migration is planned:
hydra-migrate_1  | 
hydra-migrate_1  | Could not get the migration status:
hydra-migrate_1  | failed to connect to `host=postgresd user=hydra database=hydra`: dial error (dial tcp 172.26.0.2:5432: connect: connection refused)
hydra-migrate_1  | problem with migration
hydra-migrate_1  | github.com/ory/x/popx.(*Migrator).Status
hydra-migrate_1  | 	/go/pkg/mod/github.com/ory/[email protected]/popx/migrator.go:466
hydra-migrate_1  | github.com/ory/hydra/persistence/sql.(*Persister).MigrationStatus
hydra-migrate_1  | 	/home/ory/persistence/sql/persister_migration.go:24
hydra-migrate_1  | github.com/ory/hydra/cmd/cli.(*MigrateHandler).MigrateSQL
hydra-migrate_1  | 	/home/ory/cmd/cli/handler_migrate.go:89
hydra-migrate_1  | github.com/spf13/cobra.(*Command).execute
hydra-migrate_1  | 	/go/pkg/mod/github.com/spf13/[email protected]/command.go:856
hydra-migrate_1  | github.com/spf13/cobra.(*Command).ExecuteC
hydra-migrate_1  | 	/go/pkg/mod/github.com/spf13/[email protected]/command.go:960
hydra-migrate_1  | github.com/spf13/cobra.(*Command).Execute
hydra-migrate_1  | 	/go/pkg/mod/github.com/spf13/[email protected]/command.go:897
hydra-migrate_1  | github.com/ory/hydra/cmd.Execute
hydra-migrate_1  | 	/home/ory/cmd/root.go:87
hydra-migrate_1  | main.main
hydra-migrate_1  | 	/home/ory/main.go:33
hydra-migrate_1  | runtime.main
hydra-migrate_1  | 	/usr/local/go/src/runtime/proc.go:225
hydra-migrate_1  | runtime.goexit
hydra-migrate_1  | 	/usr/local/go/src/runtime/asm_amd64.s:1371
hydra_hydra_1 exited with code 1
hydra_1          | time=2021-09-09T09:50:55Z level=info msg=No tracer configured - skipping tracing setup audience=application service_name=ORY Hydra service_version=v1.10.6
hydra_1          | time=2021-09-09T09:50:55Z level=fatal msg=Could not ensure that signing keys for "hydra.openid.id-token" exists. A network error occurred, see error for specific details. audience=application error=map[message:failed to connect to `host=postgresd user=hydra database=hydra`: dial error (dial tcp 172.26.0.2:5432: connect: connection refused)] service_name=ORY Hydra service_version=v1.10.6
hydra_1          | time=2021-09-09T09:50:56Z level=info msg=No tracer configured - skipping tracing setup audience=application service_name=ORY Hydra service_version=v1.10.6
hydra_1          | time=2021-09-09T09:50:56Z level=fatal msg=Could not ensure that signing keys for "hydra.openid.id-token" exists. A network error occurred, see error for specific details. audience=application error=map[message:failed to connect to `host=postgresd user=hydra database=hydra`: dial error (dial tcp 172.26.0.2:5432: connect: connection refused)] service_name=ORY Hydra service_version=v1.10.6
postgresd_1      |  done
postgresd_1      | server started
postgresd_1      | CREATE DATABASE
postgresd_1      | 
postgresd_1      | 
postgresd_1      | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
postgresd_1      | 
postgresd_1      | waiting for server to shut down....LOG:  received fast shutdown request
postgresd_1      | LOG:  aborting any active transactions
postgresd_1      | LOG:  autovacuum launcher shutting down
postgresd_1      | LOG:  shutting down
postgresd_1      | LOG:  database system is shut down
hydra-migrate_1  | time=2021-09-09T09:50:57Z level=info msg=No tracer configured - skipping tracing setup audience=application service_name=ORY Hydra service_version=v1.10.6
hydra_1          | time=2021-09-09T09:50:57Z level=info msg=No tracer configured - skipping tracing setup audience=application service_name=ORY Hydra service_version=v1.10.6
hydra-migrate_1  | The following migration is planned:
hydra-migrate_1  | 
hydra-migrate_1  | Could not get the migration status:
hydra-migrate_1  | failed to connect to `host=postgresd user=hydra database=hydra`: dial error (dial tcp 172.26.0.2:5432: connect: connection refused)
hydra-migrate_1  | problem with migration
hydra-migrate_1  | github.com/ory/x/popx.(*Migrator).Status
hydra-migrate_1  | 	/go/pkg/mod/github.com/ory/[email protected]/popx/migrator.go:466
hydra-migrate_1  | github.com/ory/hydra/persistence/sql.(*Persister).MigrationStatus
hydra-migrate_1  | 	/home/ory/persistence/sql/persister_migration.go:24
hydra-migrate_1  | github.com/ory/hydra/cmd/cli.(*MigrateHandler).MigrateSQL
hydra-migrate_1  | 	/home/ory/cmd/cli/handler_migrate.go:89
hydra-migrate_1  | github.com/spf13/cobra.(*Command).execute
hydra-migrate_1  | 	/go/pkg/mod/github.com/spf13/[email protected]/command.go:856
hydra-migrate_1  | github.com/spf13/cobra.(*Command).ExecuteC
hydra-migrate_1  | 	/go/pkg/mod/github.com/spf13/[email protected]/command.go:960
hydra-migrate_1  | github.com/spf13/cobra.(*Command).Execute
hydra-migrate_1  | 	/go/pkg/mod/github.com/spf13/[email protected]/command.go:897
hydra-migrate_1  | github.com/ory/hydra/cmd.Execute
hydra-migrate_1  | 	/home/ory/cmd/root.go:87
hydra-migrate_1  | main.main
hydra-migrate_1  | 	/home/ory/main.go:33
hydra-migrate_1  | runtime.main
hydra-migrate_1  | 	/usr/local/go/src/runtime/proc.go:225
hydra-migrate_1  | runtime.goexit
hydra-migrate_1  | 	/usr/local/go/src/runtime/asm_amd64.s:1371
hydra_1          | time=2021-09-09T09:50:57Z level=fatal msg=Could not ensure that signing keys for "hydra.openid.id-token" exists. A network error occurred, see error for specific details. audience=application error=map[message:failed to connect to `host=postgresd user=hydra database=hydra`: dial error (dial tcp 172.26.0.2:5432: connect: connection refused)] service_name=ORY Hydra service_version=v1.10.6
hydra_hydra-migrate_1 exited with code 1
hydra_hydra_1 exited with code 1
hydra_1          | time=2021-09-09T09:50:58Z level=info msg=No tracer configured - skipping tracing setup audience=application service_name=ORY Hydra service_version=v1.10.6
postgresd_1      |  done
postgresd_1      | server stopped
postgresd_1      | 
postgresd_1      | PostgreSQL init process complete; ready for start up.
postgresd_1      | 
hydra_1          | time=2021-09-09T09:50:58Z level=fatal msg=Could not ensure that signing keys for "hydra.openid.id-token" exists. A network error occurred, see error for specific details. audience=application error=map[message:failed to connect to `host=postgresd user=hydra database=hydra`: dial error (dial tcp 172.26.0.2:5432: connect: connection refused)] service_name=ORY Hydra service_version=v1.10.6
postgresd_1      | LOG:  database system was shut down at 2021-09-09 09:50:57 UTC
postgresd_1      | LOG:  MultiXact member wraparound protections are now enabled
postgresd_1      | LOG:  database system is ready to accept connections
postgresd_1      | LOG:  autovacuum launcher started
hydra_hydra_1 exited with code 1
hydra-migrate_1  | time=2021-09-09T09:50:58Z level=info msg=No tracer configured - skipping tracing setup audience=application service_name=ORY Hydra service_version=v1.10.6
postgresd_1      | ERROR:  relation "hydra_client_migration" does not exist at character 15
postgresd_1      | STATEMENT:  SELECT * FROM hydra_client_migration
hydra-migrate_1  | The following migration is planned:
hydra-migrate_1  | 
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
postgresd_1      | ERROR:  relation "schema_migration" does not exist at character 47
postgresd_1      | STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)

The Postgres error host=postgresd user=hydra database=hydra: dial error (dial tcp 172.26.0.2:5432: connect: connection refused) and migrate sql error.

Is this message by design?

Answered by aeneasr

Sep 10, 2021

Please wait a bit, it will come up eventually, or check the logs of your docker containers for errors.

View full answer

aeneasr · 2021-09-10T10:54:49Z

aeneasr
Sep 10, 2021
Maintainer

Please wait a bit, it will come up eventually, or check the logs of your docker containers for errors.

2 replies

leapit Sep 10, 2021
Author

Hydra logs

time=2021-09-10T13:55:53Z level=info msg=No tracer configured - skipping tracing setup audience=application service_name=ORY Hydra service_version=v1.10.6
time=2021-09-10T13:55:53Z level=fatal msg=Could not ensure that signing keys for "hydra.openid.id-token" exists. A network error occurred, see error for specific details. audience=application error=map[message:failed to connect to `host=postgresd user=hydra database=hydra`: dial error (dial tcp 172.26.0.4:5432: connect: connection refused)] service_name=ORY Hydra service_version=v1.10.6
time=2021-09-10T13:55:54Z level=info msg=No tracer configured - skipping tracing setup audience=application service_name=ORY Hydra service_version=v1.10.6
time=2021-09-10T13:55:54Z level=fatal msg=Could not ensure that signing keys for "hydra.openid.id-token" exists. A network error occurred, see error for specific details. audience=application error=map[message:failed to connect to `host=postgresd user=hydra database=hydra`: dial error (dial tcp 172.26.0.4:5432: connect: connection refused)] service_name=ORY Hydra service_version=v1.10.6
time=2021-09-10T13:55:55Z level=info msg=No tracer configured - skipping tracing setup audience=application service_name=ORY Hydra service_version=v1.10.6
time=2021-09-10T13:55:55Z level=fatal msg=Could not ensure that signing keys for "hydra.openid.id-token" exists. A network error occurred, see error for specific details. audience=application error=map[message:failed to connect to `host=postgresd user=hydra database=hydra`: dial error (dial tcp 172.26.0.4:5432: connect: connection refused)] service_name=ORY Hydra service_version=v1.10.6
time=2021-09-10T13:55:56Z level=info msg=No tracer configured - skipping tracing setup audience=application service_name=ORY Hydra service_version=v1.10.6
time=2021-09-10T13:55:56Z level=fatal msg=Could not ensure that signing keys for "hydra.openid.id-token" exists. A network error occurred, see error for specific details. audience=application error=map[message:failed to connect to `host=postgresd user=hydra database=hydra`: dial error (dial tcp 172.26.0.4:5432: connect: connection refused)] service_name=ORY Hydra service_version=v1.10.6
time=2021-09-10T13:55:57Z level=info msg=No tracer configured - skipping tracing setup audience=application service_name=ORY Hydra service_version=v1.10.6
time=2021-09-10T13:55:57Z level=fatal msg=Could not ensure that signing keys for "hydra.openid.id-token" exists. If you are running against a persistent SQL database this is most likely because your "secrets.system" ("SECRETS_SYSTEM" environment variable) is not set or changed. When running with an SQL database backend you need to make sure that the secret is set and stays the same, unless when doing key rotation. This may also happen when you forget to run "hydra migrate sql".. audience=application error=map[message:ERROR: relation "hydra_jwk" does not exist (SQLSTATE 42P01)] service_name=ORY Hydra service_version=v1.10.6
time=2021-09-10T13:55:59Z level=info msg=No tracer configured - skipping tracing setup audience=application service_name=ORY Hydra service_version=v1.10.6
time=2021-09-10T13:55:59Z level=warning msg=JSON Web Key Set "hydra.openid.id-token" does not exist yet, generating new key pair... audience=application service_name=ORY Hydra service_version=v1.10.6
time=2021-09-10T13:56:05Z level=warning msg=JSON Web Key Set "hydra.jwt.access-token" does not exist yet, generating new key pair... audience=application service_name=ORY Hydra service_version=v1.10.6
time=2021-09-10T13:56:08Z level=info msg=Software quality assurance features are enabled. Learn more at: https://www.ory.sh/docs/ecosystem/sqa audience=application service_name=ORY Hydra service_version=v1.10.6
Thank you for using ORY Hydra v1.10.6!

Take security seriously and subscribe to the ORY Security Newsletter. Stay on top of new patches and security insights.                                                                                                

>> Subscribe now: http://eepurl.com/di390P <<
time=2021-09-10T13:56:08Z level=warning msg=JSON Web Key Set "hydra.https-tls" does not exist yet, generating new key pair... audience=application service_name=ORY Hydra service_version=v1.10.6
time=2021-09-10T13:56:09Z level=info msg=Setting up http server on :4444 audience=application service_name=ORY Hydra service_version=v1.10.6
time=2021-09-10T13:56:09Z level=warning msg=HTTPS disabled. Never do this in production. audience=application service_name=ORY Hydra service_version=v1.10.6
time=2021-09-10T13:56:09Z level=info msg=Setting up http server on :4445 audience=application service_name=ORY Hydra service_version=v1.10.6

and postgres logs

The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default timezone ... Etc/UTC
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

Success. You can now start the database server using:

    pg_ctl -D /var/lib/postgresql/data -l logfile start


WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
waiting for server to start....LOG:  database system was shut down at 2021-09-10 13:55:53 UTC
LOG:  MultiXact member wraparound protections are now enabled
LOG:  autovacuum launcher started
LOG:  database system is ready to accept connections
 done
server started
CREATE DATABASE


/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*

waiting for server to shut down...LOG:  received fast shutdown request
LOG:  aborting any active transactions
LOG:  autovacuum launcher shutting down
.LOG:  shutting down
LOG:  database system is shut down
 done
server stopped

PostgreSQL init process complete; ready for start up.

LOG:  database system was shut down at 2021-09-10 13:55:55 UTC
LOG:  MultiXact member wraparound protections are now enabled
LOG:  autovacuum launcher started
LOG:  database system is ready to accept connections
ERROR:  relation "hydra_jwk" does not exist at character 116
STATEMENT:  SELECT hydra_jwk.created_at, hydra_jwk.keydata, hydra_jwk.kid, hydra_jwk.pk, hydra_jwk.sid, hydra_jwk.version FROM hydra_jwk AS hydra_jwk WHERE sid = $1 ORDER BY created_at DESC
ERROR:  relation "hydra_client_migration" does not exist at character 15
STATEMENT:  SELECT * FROM hydra_client_migration
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "schema_migration" does not exist at character 47
STATEMENT:  SELECT EXISTS (SELECT schema_migration.* FROM schema_migration AS schema_migration WHERE version = $1)
ERROR:  relation "hydra_client_migration" does not exist at character 15
STATEMENT:  SELECT * FROM hydra_client_migration
ERROR:  relation "schema_migration" does not exist at character 21
STATEMENT:  select version from schema_migration

aeneasr Sep 10, 2021
Maintainer

The system is coming live, you can ignore the Postres logs

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

When start quickstart.yml throw many error message #2738

Uh oh!

{{title}}

Uh oh!

Replies: 1 comment 2 replies

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Uh oh!

{{title}}

Uh oh!

Select a reply

Uh oh!

When start quickstart.yml throw many error message #2738

Uh oh!

leapit Sep 10, 2021

Replies: 1 comment · 2 replies

Uh oh!

aeneasr Sep 10, 2021 Maintainer

Uh oh!

leapit Sep 10, 2021 Author

Uh oh!

aeneasr Sep 10, 2021 Maintainer

leapit
Sep 10, 2021

Replies: 1 comment 2 replies

aeneasr
Sep 10, 2021
Maintainer

leapit Sep 10, 2021
Author

aeneasr Sep 10, 2021
Maintainer