Fix to errors while upgrading from 0.190 to higher versions

Tips & Tricks
1

Faced an issue when upgrading from version 0.190 to the latest.
Upgrade was failing because of a particular workflow pinData value was set to “null” instead of null.
image
Fixed by removing the “null”

Not sure what caused it.

Information on your n8n setup

  • **n8n version: 0.190.0
  • **Database : Postgres
  • **Running n8n with the execution process [own(default), main]: own
  • **Running n8n via : Docker
1 Like
2

Thanks for writing this.
I just checked with the team and they said that it should actually not be required as a version with that problem got never released. Is it possible that you were using a nightly build in the past or built n8n from master yourself?

3

HI @jan, no, no nightly builds were used. out of the 3 instances of our project on ECS, this problem somehow ended up on only one. all instances used the same image. The migration for AddJsonKeyPinData1659902242948 was failing cause of the pinData in the workflow_entity table.
I suspect the issue might have occurred during the import of workflows
Anyways, this was to help others in case they ever get stuck up on the same when upgrading.