Confluence service goes down with Error 'Could not allocate space for object 'dbo.scheduler_run_details'
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
要約
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.環境
Confluence 7.12.5
診断
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.
[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.
原因
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.
ソリューション
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.