Bitbucket (6.2.0) Global Permissions Group Fails

[Jonathan Valliere]

When attempting to add a group to Global Permissions I get what looks like a Postgres corruption error.  This is a Bitbucket server which has been upgraded over and over from Stash 1.X.  I just exported it from one server to another a month ago and everything looked fine.  The bitbucket backup utility said everything was fine and the schema was recreated on the new Postgres.  Bitbucket currently shows "stash-users" as the only group with access.

What can be done to fix this?  Is it an error with Bitbucket not upgrading the schema?

2019-05-12 15:21:46,342 ERROR [http-nio-7990-exec-9] username @84DDITx921x89x0 1vfegxd address,0:0:0:0:0:0:0:1 "PUT /admin/permissions/groups HTTP/1.1" o.h.e.j.batch.internal.BatchingBatch HHH000315: Exception executing batch [java.sql.BatchUpdateException: Batch entry 0 insert into sta_global_permission (group_name, perm_id, user_id, id) values ('stash-admin', 7, NULL, 83) was aborted: ERROR: could not open file "base/29444/30215.1" (target block 1411409261): previous segment is only 2 blocks  Call getNextException to see other errors in the batch.], SQL: insert into sta_global_permission (grouaddressp_name, perm_id, user_id, id) values (?, ?, ?, ?)

2019-05-12 15:21:46,345 WARN  [http-nio-7990-exec-9] address @84DDITx921x89x0 1vfegxd address,0:0:0:0:0:0:0:1 "PUT /admin/permissions/groups HTTP/1.1" o.h.e.jdbc.spi.SqlExceptionHelper SQL Error: 0, SQLState: 58P01

2019-05-12 15:21:46,345 ERROR [http-nio-7990-exec-9] username @84DDITx921x89x0 1vfegxd address,0:0:0:0:0:0:0:1 "PUT /admin/permissions/groups HTTP/1.1" o.h.e.jdbc.spi.SqlExceptionHelper Batch entry 0 insert into sta_global_permission (group_name, perm_id, user_id, id) values ('stash-admin', 7, NULL, 83) was aborted: ERROR: could not open file "base/29444/30215.1" (target block 1411409261): previous segment is only 2 blocks  Call getNextException to see other errors in the batch.

2019-05-12 15:21:46,345 ERROR [http-nio-7990-exec-9] username @84DDITx921x89x0 1vfegxd address,0:0:0:0:0:0:0:1 "PUT /admin/permissions/groups HTTP/1.1" o.h.e.jdbc.spi.SqlExceptionHelper ERROR: could not open file "base/29444/30215.1" (target block 1411409261): previous segment is only 2 blocks

2019-05-12 15:21:46,349 ERROR [http-nio-7990-exec-9] username @84DDITx921x89x0 1vfegxd address,0:0:0:0:0:0:0:1 "PUT /admin/permissions/groups HTTP/1.1" o.h.i.ExceptionMapperStandardImpl HHH000346: Error during managed flush [org.hibernate.exception.GenericJDBCException: could not execute batch]

2019-05-12 15:22:51,978 ERROR [http-nio-7990-exec-8] username @84DDITx922x120x0 1vfegxd address,0:0:0:0:0:0:0:1 "PUT /admin/permissions/groups HTTP/1.1" o.h.e.j.batch.internal.BatchingBatch HHH000315: Exception executing batch [java.sql.BatchUpdateException: Batch entry 0 insert into sta_global_permission (group_name, perm_id, user_id, id) values ('stash-users', 7, NULL, 84) was aborted: ERROR: could not open file "base/29444/30215.1" (target block 1411409261): previous segment is only 2 blocks  Call getNextException to see other errors in the batch.], SQL: insert into sta_global_permission (group_name, perm_id, user_id, id) values (?, ?, ?, ?)

2019-05-12 15:22:51,979 WARN  [http-nio-7990-exec-8] username @84DDITx922x120x0 1vfegxd address,0:0:0:0:0:0:0:1 "PUT /admin/permissions/groups HTTP/1.1" o.h.e.jdbc.spi.SqlExceptionHelper SQL Error: 0, SQLState: XX000

2019-05-12 15:22:51,979 ERROR [http-nio-7990-exec-8] username @84DDITx922x120x0 1vfegxd address,0:0:0:0:0:0:0:1 "PUT /admin/permissions/groups HTTP/1.1" o.h.e.jdbc.spi.SqlExceptionHelper Batch entry 0 insert into sta_global_permission (group_name, perm_id, user_id, id) values ('stash-users', 7, NULL, 84) was aborted: ERROR: could not open file "base/29444/30215.1" (target block 1411409261): previous segment is only 2 blocks  Call getNextException to see other errors in the batch.