Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Confluence stopped for the 3rd time after 14 days - MSSQL transaction log filled up harddisk in 1d

Hello,

we are running on confluence 7.12.2 and are experiencing since mid december 2021 (nothing changed on the configuration since about 6 months) a strange effect.

Every about 10-16 days it happens that the MSSQL Transaction logs starts to grow very fast and to fill up the complete harddisk in about 1,5 days.

When the harddisk is full, confluence stopps working with different error message. (no surprise)

We than can shrink the transaction log manually again and the confluence will work for another 10-16 days...

We have no idea what could cause the behaviour?

We checked scheduled tasks but could not find any coinciedence. The time range until the next "growing event" is always a bit different...

Any ideas about what to check is welcome!

As a workaround we could switch the database mode to "Simple" - so no transaction log would be created any more. But doing this, we would rely completely on a daily backup of the database. Is this save? What is the recommended mode?

Thanks,

Sven

NB: Our support ran out in summer 2021. Hopefully there is a solution :)

1 answer

0 votes
Pramodh M Community Leader Jan 14, 2022

Hi @Sven 

You may want to disable SQL logging

Please find the reference here

https://confluence.atlassian.com/doc/enabling-detailed-sql-logging-179030.html

Let me know if this works for you!!

Thanks,
Pramodh

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7.12.2
TAGS
Community showcase
Published in Confluence Cloud

🏠 Say hello to the new Confluence Home!

Hi Atlassian Community, My name is DJ Chung, and I’m a Product Manager on the Confluence Cloud team. Today, I’m excited to share a new and improved version of Home. The new Home helps you ...

43,379 views 32 135
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you