Hi there 👋 I have a question about the postgres service in the 'test' github workflow action in https://github.com/Netflix/metaflow-service . The tests seem to be not hitting the service correctly, for example this run in the "stop container" section. Here is a part of the errors:

2023-04-13 16:16:32.470 UTC [166] FATAL:  role "root" does not exist
 2023-04-13 16:16:38.409 UTC [170] ERROR:  relation "goose_db_version" does not exist at character 36
 2023-04-13 16:16:38.409 UTC [170] STATEMENT:  SELECT version_id, is_applied from goose_db_version ORDER BY id DESC
 2023-04-13 16:16:38.540 UTC [173] ERROR:  duplicate key value violates unique constraint "artifact_v3_pkey"
 2023-04-13 16:16:38.540 UTC [173] DETAIL:  Key (flow_id, run_number, step_name, task_id, attempt_id, name)=(HelloFlow, 1, step, 1, 0, artifact-A) already exists.
 2023-04-13 16:16:38.540 UTC [173] STATEMENT:  
 	                    INSERT INTO artifact_v3(flow_id, run_number, run_id, step_name, task_id, task_name, name, location, ds_type, sha, type, content_type, user_name, attempt_id, tags, system_tags, ts_epoch) VALUES('HelloFlow', '1', NULL, 'step', '1', NULL, 'artifact-A', '/test-location-a', 'local', '1234abcd', 'test-artifact', 'text/plain', 'test_user', '0', '["a_tag", "b_tag"]', '["runtime:test"]', '1681402598540')
 	                    RETURNING *

Is this fine?

Thanks for pointing out! We will address this asap

some notes on the behavior: • The errors regarding the root role are not intended but not a cause for concern, only related to the postgres service healthchecks failing. Fix for this is on the way 🙂 • the other errors you see in the Stop Containers part are due to that log consisting of the whole test lifetime logs of the docker containers. We perform a lot of tests on the existence of foreign key constraints on the DB as part of the integration tests, so the DB is simply logging the collisions during its lifetime. As long as the actual test cases pass, there should be no issues regarding how the db is being hit as no mocking of the db responses was used if I recall correctly

Thank you for looking into this 🙏