Problem with Postgresql base after update.

Question

Hi

I have problem after upgrade from Bitbucket ver 4.14.5 to 5.1.1.

My base was not migrated successfully.

Logs:

2017-06-27 13:27:29,286 WARN  [active-objects-init-compatibility-tenant-0]  n.j.ao.db.PostgreSQLDatabaseProvider Error in schema creation: ERROR: column "RESOURCE_ID" contains null values; attempting to roll back last partially generated table
2017-06-27 13:27:30,003 ERROR [active-objects-init-compatibility-tenant-0]  net.java.ao.sql Exception executing SQL update <ALTER TABLE "AO_9DEC2A_PR_CONDITION" ADD COLUMN "SCOPE_TYPE" VARCHAR(255) NOT NULL>

Any help? Do i need to create a new dump from production and try again?

What could went wrong?

Thomas Buchhorn · Answer

If you still have the problem, better open a support ticket at atlassian.

Also you should to upgrade to 5.1.3 now.

Pawel Bohdal · Answer

I'm using psql (PostgreSQL) 9.5.7

Thomas Buchhorn · Answer

I'm planning to do an upgrade from 4.14.x to 5.1.2 as well so this scares me.

But maybe you can provide more info? Which version of postgres are you using?

BTW: I found a similar issue about the warning in another project:

https://ecosystem.atlassian.net/browse/AO-490