Confluence service goes down with Error 'Could not allocate space for object 'dbo.scheduler_run_details'

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.

Summary


Confluence experiences performance issues or might completely become unresponsive. This following error might be noted in the atlassian-confluence.logs :

Could not allocate space for object 'dbo.scheduler_run_details'.'PK__schedule__3213E83F5638554A' in database 'conf_prod' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.


Environment

Confluence 7.12.5

Diagnosis

The full text of the error message might look like the one below from the atlassian-confluence.logs. The Confluence instance might become unresponsive or might crash completely.

Could not allocate space object
[scheduler.caesium.impl.SchedulerQueueWorker] executeJob Unhandled exception thrown by job QueuedJob[jobId=LastAccessedTimeBatcherJob,deadline=1636666495952]
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute statement; uncategorized SQLException; SQL state [S0002]; error code [1105]; Could not allocate space for object 'dbo.scheduler_run_details'.'PK__schedule__3213E83F5638554A' in database 'conf_prod' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Could not allocate space for object 'dbo.scheduler_run_details'.'PK__schedule__3213E83F5638554A' in database 'conf_prod' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.


Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Could not allocate space for object 'dbo.scheduler_run_details'.'PK__schedule__3213E83F5638554A' in database 'conf_prod' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
 


Cause


This pattern is normally caused by non-availability of space. This could also be connected to space issues in the machine where the db is currently running.

Solution

Increase the Xms and Xms values from the setevn.sh/setenv.bat file to a higher configuration and restart the instance. If Confluence is started as a service, the heap size increase should be applied to the service. 



Last modified on Jun 15, 2022

Was this helpful?

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