Stash can't be started due to the transaction log for database is full

Troubleshooting Databases

On this page

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

Platform Notice: Server, Data Center, and Cloud By Request - This article was written for the Atlassian server and data center platforms but may also be useful for Atlassian Cloud customers. If completing instructions in this article would help you, please contact Atlassian Support and mention it.

Problem

Starting Stash fails with the following message on the UI:

SpringMVC dispatcher [springMvc] could not be started


The following is seen on atlassian-stash.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.stash.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 'stash' 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 Stash.

Last modified on Apr 6, 2016

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.