fatal error: The database schema could not be updated. Details about the change that failed can be f

[joel Cruz]

upgraded from 4.14 to 5.16, and postgres from 9.3 to 9.6 upon startup i get this

A fatal error has occurred

The following problem occurred, which prevents Atlassian Bitbucket from starting:

• The database schema could not be updated. Details about the change that failed can be found in the logs.
  
  It may be necessary to create a ticket to resolve the error. When creating a ticket, please include the exception details from the logs, as well as the database type.

my db name and credentials haven't changed my thoughts are something with the schema changed

some info on the DB

encoding | Collate     | Ctype
UTF8     | en_US.UTF-8 | en_US.UTF-8 | 

, here's the log

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [stash-context.xml]: Invocation of init method failed; nested exception is liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/r5_0/upgrade.xml::BSERVDEV-8489-12::jpalacios:
     Reason: liquibase.exception.DatabaseException: ERROR: insert or update on table "bb_comment" violates foreign key constraint "fk_bb_comment_thread"
  Detail: Key (thread_id)=(5190) is not present in table "bb_comment_thread". [Failed SQL: insert into bb_comment (
                    id,
                    author_id,
                    comment_text,
                    created_timestamp,
                    entity_version,
                    thread_id,
                    updated_timestamp
            )
            select
                    id,
                    author_id,
                    comment_text,
                    created_timestamp,
                    entity_version,
                    id,
                    updated_timestamp
            from sta_comment
            where root_id is null]
        at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1631)
        ... 5 common frames omitted
Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/r5_0/upgrade.xml::BSERVDEV-8489-12::jpalacios:
     Reason: liquibase.exception.DatabaseException: ERROR: insert or update on table "bb_comment" violates foreign key constraint "fk_bb_comment_thread"
  Detail: Key (thread_id)=(5190) is not present in table "bb_comment_thread". [Failed SQL: insert into bb_comment (
                    id,
                    author_id,
                    comment_text,
                    created_timestamp,
                    entity_version,
                    thread_id,
                    updated_timestamp
            )
            select
                    id,
                    author_id,
                    comment_text,
                    created_timestamp,
                    entity_version,
                    id,
                    updated_timestamp
            from sta_comment
            where root_id is null]
        at liquibase.changelog.ChangeSet.execute(ChangeSet.java:637)
        at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:53)
        at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:78)
        at liquibase.Liquibase.update(Liquibase.java:202)
        at liquibase.Liquibase.update(Liquibase.java:179)
        at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:317)
        at liquibase.database.ExtendedSpringLiquibase.afterPropertiesSet(ExtendedSpringLiquibase.java:32)
        ... 5 common frames omitted
Caused by: liquibase.exception.DatabaseException: ERROR: insert or update on table "bb_comment" violates foreign key constraint "fk_bb_comment_thread"
  Detail: Key (thread_id)=(5190) is not present in table "bb_comment_thread". [Failed SQL: insert into bb_comment (
                    id,
                    author_id,
                    comment_text,
                    created_timestamp,
                    entity_version,
                    thread_id,
                    updated_timestamp
            )
            select
                    id,
                    author_id,
                    comment_text,
                    created_timestamp,
                    entity_version,
                    id,
                    updated_timestamp
            from sta_comment
            where root_id is null]
        at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:356)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:57)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:125)
        at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1229)
        at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1211)
        at liquibase.changelog.ChangeSet.execute(ChangeSet.java:600)
        ... 11 common frames omitted
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "bb_comment" violates foreign key constraint "fk_bb_comment_thread"
  Detail: Key (thread_id)=(5190) is not present in table "bb_comment_thread".
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2477)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2190)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
        at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
        at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:301)
        at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:287)
        at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:264)
        at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:260)
        at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
        at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
        at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:352)
        ... 16 common frames omitted
2019-01-12 23:04:51,476 WARN  [http-nio-7990-exec-9]  c.a.j.s.w.f.BypassableDelegatingFilterProxy Bypassing [hazelcastFilter]; no Spring WebApplicationContext is available
2019-01-12 23:04:51,487 WARN  [http-nio-7990-exec-9]  c.a.j.s.w.f.BypassableDelegatingFilterProxy Bypassing [requestAttributeFilter]; no Spring WebApplicationContext is available
2019-01-12 23:06:24,869 WARN  [http-nio-7990-exec-4]  c.a.j.s.w.f.BypassableDelegatingFilterProxy Bypassing [hazelcastFilter]; no Spring WebApplicationContext is available
2019-01-12 23:06:24,871 WARN  [http-nio-7990-exec-4]  c.a.j.s.w.f.BypassableDelegatingFilterProxy Bypassing [requestAttributeFilter]; no Spring WebApplicationContext is available
2019-01-12 23:07:06,233 WARN  [http-nio-7990-exec-7]  c.a.j.s.w.f.BypassableDelegatingFilterProxy Bypassing [hazelcastFilter]; no Spring WebApplicationContext is available