We recently upgraded our postgres db from 9.6 to 11.12.
Everything seemed good all through the weekend until we noticed that thumbnails and preview files were not appearing on new versions.
Shotgun version is 184.108.40.20663 (serving ourselves from a Docker container on Amazon EC2 instance).
Postgres db via Amazon RDS instance.
Transcoderserver version 6.5.0
Transcoderworker version 10.7.0
I started noticing this in the transcoderworker logs:
"/home/shotgun/app/src/operations/lib/database_operation.rb:35:in 'exec': ERROR: relation \"part_jobs\" does not exist (PG::UndefinedTable)"
The containers themselves seem to be running fine.
This seems like a migration error. I modified the docker-compose.yml database image portion from postgres:9.6 to postgres11 figuring that’s all that was required.
Should there be some intermediary migration step for Docker to handle this or is this something specifically to do with the transcoder server/worker containers themselves that needs addressing?
Hope someone out there ran into similar issues in the past because I’m at a loss with this one.