Cannot access a repository after creating it: unknown table

[Bob]

I just installed Bitbucket Server.  I created a project, then under the project clicked "create repository".  That allowed me to name a new repository, and it appears when I display the project.  But if I click on the repository I get an internal server error.  In the log files, I see in part:

Caused by: java.sql.SQLSyntaxErrorException: Unknown table 'AO_92D5D5_REPO_NOTIFICATION' in information_schema

Have others seen this kind of error?

Thanks.

[Bob · Accepted solution]

Thanks for the answer.  The repository name is "chill", so pretty darn simple.

Does the repository get stored in the "shared" location?  If so, that is /var/atlassian/application-data/bitbucket/share and is owned by the user/group under which bitbucket runs.  If not I'm don't know how to determine the storage location..

[Bradley Moravek]

I will assume it is a linux distro and you have a valid license key.

Under storage tab - this shows some basic storage location....

http://10.10.250.5:7990/admin/storage - our bitbucket server is in a closed network.

real storage is located under

/var/atlassian/application-data/bitbucket/...

Once you hit 'bitbucket' sub directory the ownership changes from root:root to a bitbucket defined ID.

My current storage showing up when looking at the status webpage shows my usage of storage as 12.8 / 25GB

Note: I have had error messages when creating too large of storage for bitbucket. Once you hit 2 gig for a project things fail a lot. I thought that this limit was only for the cloud version of the sever, but received an error message when the baseline for one project jumped to 5+ gig.

-----------------------------------

So you will need to be doing this work as 'admin'.

User ID creating storage location was the ID you logged on with. So it has full admin via the web browser. I started off life with a simple 10 user license and when our group grew to 15 I bought a 25 seat license.

I created a deleteme project with key of "del"

under
Project permissions

The user accessing the web interface is the same as the user defined as "sys.admin".

My current version of Atlassian Bitbucket is v6.1.2 .

I have add real odd issues when I took a patch to java, the system rolled over and died. I decided to upgrade versions to 6.1.2 which re-installed bitbucket with java and all things was good.

Also check the Troubleshooting and support tools tab and check for errors. Bitbucket should auto run the Log analyzer and provide you with more insight. Not all errors or warnings need to be corrected. I have found that is always best to have a backup handy before making any system level changes.

Other problem areas that I had was running with a too old and new version of git for the version of bitbucket. You can see this error message during the bitbucket boot cycle by watching the web interface.

If the above does not help, I am out of ideas.

[Bob]

Thank you for the helpful information.  I ended up filing a support ticket with Atlassian, and they mentioned that the version of the mysql connector may need to be downgraded - see https://ecosystem.atlassian.net/browse/AO-3462.

I installed the "recommended" version (5.1.47), and that seems to have solved the problem.

[Bradley Moravek]

That is nice to know; I went with both the internal SQL when we had only 6 users.  Once the team jumped up to 15(ish) I upgraded my license and with with PostgreSQL 10.x.

[Bradley Moravek]

My wild guess is,

Verify that the name of the repository is "simple", and that the task running the server has write access to the storage location of where the repository will go.