Bitbucket Server can't be started due to the transaction log for database is full
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
Starting Bitbucket Server fails with the following message on the UI:
1
SpringMVC dispatcher [springMvc] could not be startedThe following is seen on atlassian-bitbucket.log:
1
2
3
4
5
6
7
8
09-Jun-2015 09:54:04.048 SEVERE [http-nio-7990-exec-1] org.apache.catalina.core.ApplicationDispatcher.invoke Servlet.service() for servlet springMvc threw exception
com.atlassian.bitbucket.exception.DataStoreException: A database error has occurred.
...
Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not execute batch; SQL [update cwd_user set user_name=?, lower_user_name=?, is_active=?, created_date=?, updated_date=?, first_name=?, lower_first_name=?, last_name=?, lower_last_name=?, display_name=?, lower_display_name=?, email_address=?, lower_email_address=?, external_id=?, directory_id=?, credential=? where id=?]; nested exception is org.hibernate.exception.SQLGrammarException: could not execute batch
...
Caused by: org.hibernate.exception.SQLGrammarException: could not execute batch
...
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The transaction log for database 'bitbucket' is full due to 'LOG_BACKUP'. Cause
The problem is on your Microsoft SQL database that contains a full table.
Resolution
Check the guide below for Microsoft SQL to fix your database and restart Bitbucket Server.
Was this helpful?