Test against PostgreSQL CI is failing because the database still exists from previous tests.
[ERROR] Tests run: 1, Failures: 0, Errors: 1, Skipped: 0, Time elapsed: 23.628 s <<< FAILURE! - in skills.intTests.DataMigrationDBIT
[ERROR] validate migration1(skills.intTests.DataMigrationDBIT) Time elapsed: 22.334 s <<< ERROR!
org.springframework.dao.DuplicateKeyException:
StatementCallback; SQL [INSERT INTO public.user_attrs (id, user_id, first_name, last_name, dn, email, nickname, user_id_for_display, created, updated) VALUES (1, '[email protected]', 'Skills', 'Test', null, '[email protected]', 'Skills Test', '[email protected]', '2020-07-08 21:18:39.684787', '2020-07-08 21:18:39.684787');]; ERROR: duplicate key value violates unique constraint "index_users_attrs_user_id"
Detail: Key (user_id)=([email protected]) already exists.; nested exception is org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "index_users_attrs_user_id"
Detail: Key (user_id)=([email protected]) already exists.
at skills.intTests.DataMigrationDBIT.insertPreMigration1TestData_closure1(DataMigrationDBIT.groovy:133)
at skills.intTests.DataMigrationDBIT.insertPreMigration1TestData(DataMigrationDBIT.groovy:132)
at skills.intTests.DataMigrationDBIT.validate migration1(DataMigrationDBIT.groovy:74)
Caused by: org.postgresql.util.PSQLException:
ERROR: duplicate key value violates unique constraint "index_users_attrs_user_id"
Detail: Key (user_id)=([email protected]) already exists.
at skills.intTests.DataMigrationDBIT.insertPreMigration1TestData_closure1(DataMigrationDBIT.groovy:133)
at skills.intTests.DataMigrationDBIT.insertPreMigration1TestData(DataMigrationDBIT.groovy:132)
at skills.intTests.DataMigrationDBIT.validate migration1(DataMigrationDBIT.groovy:74)