Bitbucket Server can't be started due to the transaction log for database is full
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
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:
SpringMVC dispatcher [springMvc] could not be started
The following is seen on atlassian-bitbucket.log:
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.