Problem with Postgresql base after update.

[Pawel Bohdal]

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]

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

[Pawel Bohdal]

I'm using psql (PostgreSQL) 9.5.7

[Thomas Buchhorn]

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

Also you should to upgrade to 5.1.3 now.