Migration from 5.2.0 to 5.4.1

When upgrading to 5.4.1 the migration fails with:

Migration 'Up_1561558376' failed: pq: column "type" contains null values

This is most likely failing here: https://github.com/concourse/concourse/blob/master/atc/db/migration/migrations/1561558376_add_type_to_resources.up.go#L67

After inspecting our database we found a few resources where the config column is set to just “{}”. Therefore when the migration loops through the parsed json, it’s setting the type column to null, and hence can’t save.

We’ve also noticed that these resources seem to be old and inactive, would it be possible for us to just delete them so we can migrate to 5.4.1? Thanks for the help!

We’re tracking this as a bug here: https://github.com/concourse/concourse/issues/4139

Yeah, you should be able to just delete them. :+1:

1 Like