Attachment migration SQL Server

We're about to migrate attachments from a SQL Server to file system. For having a really large database (about 40GB), this procedure takes about 2 days. After it is finished the attachments are stored twice: in home folder of confluence and still inside the database. Confluence is also still storing attachments in database and not on the file system.

Do anybody has exceperience with that large database and SQL Server? We didn't find any exceptions or errors in both log files (tomcat&confluence), so what could be the problem?

2 answers

1 accepted

Hi Jarek,

Unfortunately https://jira.atlassian.com/browse/CONF-9888 doesn't have an ETA at this time. For now we suggest that you vote on the bug report to increase its popularity so it can hopefully be included to the bugfix roadmap in the near future. I have voted as well. =)

Please let us know if you have further questions!

0 vote

Hi Jarek,

We have a known bug regarding huge attachments migration: https://jira.atlassian.com/browse/CONF-9888

Unfortunately is still not fixed, however some improvements were made in the version 4.1 onwards:

https://jira.atlassian.com/browse/CONF-15937

https://jira.atlassian.com/browse/CONF-23783

You may want to upgrade to the newest Confluence version to attempt those improvements. (Assuming that you are in an older version of Confluence). Hope that helps you :)

Hi Rodrigo,

thanks for replay. Actually we're planning an upgrade next year. Which version will include this bugfix?

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Published yesterday in Confluence

Think you know shares vs. @mentions in Confluence? Take this collab quiz.

To anyone who doubts that Atlassians are a little too obsessed with collaboration, and tools related thereto, let me describe a recent discussion we had (which took place on our internal Confluence, ...

107 views 2 4
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you