Possible upgrade issue after upgrading from SE Classic to SE Docker

If you have migrated from SE Classic to SE Docker prior to July 2018, you may be affected by an issue with the functions ownership in the database. The next upgrade of Shotgun will fail if the ownership is not fixed in advance.

You will need to change the owner of the functions in the database. The database name and user should look like this: com_teststudio_shotgun.

How to check functions ownership

• Connect to the database with psql and run \df+.
• Check if the Owner of the functions is same as the database user. It's usually something like com_teststudio_shotgun.

How to fix

You will need to run the following command in psql shell connected to the Shotgun database using a user with SUPERUSER rights like shotgun user. This can be done anytime and will not affect the production database.

This will produce the list of commands to run. Replace the com_teststudio_shotgun placeholder with your database user:

select 'alter function '||nsp.nspname||'.'||p.proname||'('||oidvectortypes(p.proargtypes)||') owner to com_teststudio_shotgun;'
from pg_proc p 
join pg_namespace nsp ON p.pronamespace = nsp.oid
where nsp.nspname = 'public';

Copy and paste the result in the same psql shell to execute them.

Please contact support if you need additional information or assistance.