'Unable to dump schema' on initial migrate

[mig5]

Hi,

I am standing up a Hydra 1.10.7 docker instance in AWS ECS.

To get through the initial database seeding step, I ran the 'migrate sql --yes $DSN' as a separate docker run manually. I did this from an Amazon Linux machine that runs the containers normally.

I got the below output, which is not something I've seen in a 'vanilla' (non-ECS) Docker setup:

INFO[2022-01-12T00:55:37Z] No tracer configured - skipping tracing setup  audience=application service_name=ORY Hydra service_version=v1.10.7
The following migration is planned:

Version                Name                                              Status    
20190100000001000000   client                                            Pending   
20190100000002000000   client                                            Pending   
20190100000003000000   client                                            Pending   
20190100000004000000   client                                            Pending   
20190100000005000000   client                                            Pending   
20190100000006000000   client                                            Pending   
20190100000007000000   client                                            Pending   
20190100000008000000   client                                            Pending   
20190100000009000000   client                                            Pending   
20190100000010000000   client                                            Pending   
20190100000011000000   client                                            Pending   
20190100000012000000   client                                            Pending   
20190100000013000000   client                                            Pending   
20190100000014000000   client                                            Pending   
20190200000001000000   jwk                                               Pending   
20190200000002000000   jwk                                               Pending   
20190200000003000000   jwk                                               Pending   
20190200000004000000   jwk                                               Pending   
20190300000001000000   consent                                           Pending   
20190300000002000000   consent                                           Pending   
20190300000003000000   consent                                           Pending   
20190300000004000000   consent                                           Pending   
20190300000005000000   consent                                           Pending   
20190300000006000000   consent                                           Pending   
20190300000007000000   consent                                           Pending   
20190300000008000000   consent                                           Pending   
20190300000009000000   consent                                           Pending   
20190300000010000000   consent                                           Pending   
20190300000011000000   consent                                           Pending   
20190300000012000000   consent                                           Pending   
20190300000013000000   consent                                           Pending   
20190300000014000000   consent                                           Pending   
20190400000001000000   oauth2                                            Pending   
20190400000002000000   oauth2                                            Pending   
20190400000003000000   oauth2                                            Pending   
20190400000004000000   oauth2                                            Pending   
20190400000005000000   oauth2                                            Pending   
20190400000006000000   oauth2                                            Pending   
20190400000007000000   oauth2                                            Pending   
20190400000008000000   oauth2                                            Pending   
20190400000009000000   oauth2                                            Pending   
20190400000010000000   oauth2                                            Pending   
20190400000011000000   oauth2                                            Pending   
20200521071434000000   consent                                           Pending   
20200527215731000000   client                                            Pending   
20200527215732000000   client                                            Pending   
20200819163013000000   add_client_id_subject_idx_to_access_and_refresh   Pending   
20200913192340000000   initial_sqlite                                    Pending   
20201110104000000000   drop_uq_oauth2                                    Pending   
20201116133000000000   set_null_time                                     Pending   
20210928155900000000   support_amr_claim                                 Pending   
WARN[2022-01-12T00:55:43Z] Migrator: unable to dump schema               audience=application error=map[message:open schema.sql: permission denied] service_name=ORY Hydra service_version=v1.10.7
Successfully applied migrations!

Do you think it's a problem?

I verified that I have the relevant tables in the database after the above command ran:

+------------------------------------------------+
| Tables_in_hydra_dev                            |
+------------------------------------------------+
| hydra_client                                   |
| hydra_jwk                                      |
| hydra_oauth2_access                            |
| hydra_oauth2_authentication_request            |
| hydra_oauth2_authentication_request_handled    |
| hydra_oauth2_authentication_session            |
| hydra_oauth2_code                              |
| hydra_oauth2_consent_request                   |
| hydra_oauth2_consent_request_handled           |
| hydra_oauth2_jti_blacklist                     |
| hydra_oauth2_logout_request                    |
| hydra_oauth2_obfuscated_authentication_session |
| hydra_oauth2_oidc                              |
| hydra_oauth2_pkce                              |
| hydra_oauth2_refresh                           |
| schema_migration                               |
+------------------------------------------------+

Maybe it's just a quirk of RDS?

Is there anything else I should do to validate that the database integrity is ok? I can see 51 rows in the schema_migration table, all with version_self value of '0'

[mig5]

BTW, I re-ran the same command later, and I got this:

Version                Name                                              Status    
20190100000001000000   client                                            Applied   
20190100000002000000   client                                            Applied   
20190100000003000000   client                                            Applied   
20190100000004000000   client                                            Applied   
20190100000005000000   client                                            Applied   
20190100000006000000   client                                            Applied   
20190100000007000000   client                                            Applied   
20190100000008000000   client                                            Applied   
20190100000009000000   client                                            Applied   
20190100000010000000   client                                            Applied   
20190100000011000000   client                                            Applied   
20190100000012000000   client                                            Applied   
20190100000013000000   client                                            Applied   
20190100000014000000   client                                            Applied   
20190200000001000000   jwk                                               Applied   
20190200000002000000   jwk                                               Applied   
20190200000003000000   jwk                                               Applied   
20190200000004000000   jwk                                               Applied   
20190300000001000000   consent                                           Applied   
20190300000002000000   consent                                           Applied   
20190300000003000000   consent                                           Applied   
20190300000004000000   consent                                           Applied   
20190300000005000000   consent                                           Applied   
20190300000006000000   consent                                           Applied   
20190300000007000000   consent                                           Applied   
20190300000008000000   consent                                           Applied   
20190300000009000000   consent                                           Applied   
20190300000010000000   consent                                           Applied   
20190300000011000000   consent                                           Applied   
20190300000012000000   consent                                           Applied   
20190300000013000000   consent                                           Applied   
20190300000014000000   consent                                           Applied   
20190400000001000000   oauth2                                            Applied   
20190400000002000000   oauth2                                            Applied   
20190400000003000000   oauth2                                            Applied   
20190400000004000000   oauth2                                            Applied   
20190400000005000000   oauth2                                            Applied   
20190400000006000000   oauth2                                            Applied   
20190400000007000000   oauth2                                            Applied   
20190400000008000000   oauth2                                            Applied   
20190400000009000000   oauth2                                            Applied   
20190400000010000000   oauth2                                            Applied   
20190400000011000000   oauth2                                            Applied   
20200521071434000000   consent                                           Applied   
20200527215731000000   client                                            Applied   
20200527215732000000   client                                            Applied   
20200819163013000000   add_client_id_subject_idx_to_access_and_refresh   Applied   
20200913192340000000   initial_sqlite                                    Applied   
20201110104000000000   drop_uq_oauth2                                    Applied   
20201116133000000000   set_null_time                                     Applied   
20210928155900000000   support_amr_claim                                 Applied   
WARN[2022-01-12T04:59:42Z] Migrator: unable to dump schema               audience=application error=map[message:open schema.sql: permission denied] service_name=ORY Hydra service_version=v1.10.7
Successfully applied migrations!

As it shows, all migrations are Applied - I assume this implies 'Already Applied'.

I think things are ok.. I was able to create an oAuth2.0 Client at least... but I would appreciate some reassurance that the 'unable to dump schema' message here is a harmless message and perhaps from some sort of security precaution by AWS in either RDS or ECS that prevents it 'opening' a file.

[aeneasr]

All is good, the warning will be fixed in the upcoming versions!

[mig5]

Thanks!