error: migration failed: column "project_id" contains null values in line 0: ALTER TABLE log ALTER COLUMN project_id SET NOT NULL;

[SubratKumarTR]

Hi Team,

We are migrating from version 5.3.5 to 5.5.0,

we are getting the below errors -

wait-for-it.sh: waiting 15 seconds for cr-pg.1129.aws-int.thomsonreuters.com:5432
wait-for-it.sh: cr-pg.1129.aws-int.thomsonreuters.com:5432 is available after 0 seconds
26/u retries_lock_fix (51.063956ms)
27/u add_project_id_log (74.505076ms)
28/u create_log_project_idx (3m57.808965463s)
29/u create_table_item_project (3m57.836574973s)
30/u item_project_fill_part1 (9m43.901618664s)
31/u item_project_fill_part2 (14m29.453492235s)
32/u create_item_idx (15m13.179895606s)
33/u drop_log_message_trgm_idx (15m13.334376926s)
34/u fill_project_id_part1 (1h3m27.963954216s)
35/u fill_project_id_part2 (1h32m32.407603336s)
36/u drop_item_project (1h32m32.569538882s)
37/u create_log_message_trgm_idx (3h29m20.535242062s)
error: migration failed: column "project_id" contains null values in line 0: ALTER TABLE log ALTER COLUMN project_id SET NOT NULL; (details: pq: column "project_id" contains null values)
wait-for-it.sh: waiting 15 seconds for cr-pg.1129.aws-int.thomsonreuters.com:5432
wait-for-it.sh: cr-pg.1129.aws-int.thomsonreuters.com:5432 is available after 0 seconds
error: Dirty database version 38. Fix and force version.

Please let me know what need to done to fix this issues?
Thanks in Advance.

[englandprevails]

Is there any known solution for this issue?

[bgolke]

+1

I've got the same issue here with multiple instances and we have yet to find a solid solution. We've tried to rollback the version to 37 and re-run the migrations job, only to have it fail on error: Dirty database version 38. Fix and force version. We were partially successful when we had an instance with a dirty database version of 46; set version back to 45, re-run migrations, but only runs until 47 and not all the way to 50. However, it does not set dirty database back to true.

@evjlobanova could you please provide more guidance with this issue?

Thanks,

Brent