Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

Lost draft when truncate events table?

Hello, we wanted to know If we lost draft pages if we truncate this tables.

TRUNCATE TABLE "EVENTS";
TRUNCATE TABLE "SECRETS";
TRUNCATE TABLE "SNAPSHOTS";

 Our table events is very large and I would like reduce.

https://confluence.atlassian.com/confkb/how-to-reduce-the-size-of-synchrony-tables-858770831.html

1 answer

Hello,

Yes, truncating these tables will purge all drafts from the instance, make sure you test on a test environment first and disable Collaborative Editing before proceeding.

 

Regards,

Igor

Hi, I truncate this tables but not purge all drafts. I try on development environment.

I´m not sure to do in production environment.. :(

As I tested in a local environment, when turning collaborative editing off, Confluence switches to the old behavior of personal drafts. But the shared drafts still remain in the database. When you truncate the tables and switch on collaborative editing, Synchrony will recover from the existing shared drafts. So if no editing is done during collaborative editing is off, no shared drafts should be lost. Can anyone confirm this?

@Igor M_ Could you please confirm what happens to "Any data" in a Confluence Production instance, if we ('disable collaborative editing -> Truncate synchrony tables -> Enable Collaborative Editing) ??

Hello,

The impact is described in the above referenced KB:

Please note that turning Collaborative editing OFF and ON again may remove any unsaved drafts. You may refer to this page -How Do Drafts Work on Confluencefor detailed information regarding drafts. Please follow the steps below to identify and publish unpublished drafts.

That is the only impact on the data you should observe. Saying that, taking necessary backups before the action is always advised.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence Cloud

Please tell us how you use Confluence space settings

👋 Hi there, a few of us at Atlassian would love to learn about how you use "space settings" functionality in Confluence. A facelift to the space settings is long overdue and we want to start with im...

568 views 15 9
Join discussion

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