Community resources
Community resources
Community resources
Bitbucket (6.2.0) Global Permissions Group Fails
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.
