問題

When navigating to a branch of a repository in Bitbucket Server a Server Error is displayed, or when trying to clone a repository the following error is returned on the console:

remote: Repository hook com.atlassian.bitbucket.server.bitbucket-ref-restriction:restrictionEnforcerHook failed
remote: bundle [com.atlassian.bitbucket.server.bitbucket-ref-restriction]

atlassian-bitbucket.log に次のメッセージが表示される。

Caused by: java.lang.IllegalStateException: Could not find column '<column_name>' in previously parsed query!

診断

Bitbucket Server is using Oracle as its backend database.

原因

The Oracle user that Bitbucket Server is configured to connect to the database with has too many permissions.

ソリューション

To resolve this problem, revoke extraneous permissions from the Oracle user that Bitbucket Server uses to connect to the database by running the following queries:

REVOKE SELECT ANY TABLE FROM <db_user>;
REVOKE DBA FROM <db_user>;

where <db_user> is the Oracle username that Bitbucket Server uses to connect to the database.