Records deleted from CWD_DIRECTORY_ATTRIBUTE and CWD_DIRECTORY_OPERATION

Hi,

Sometimes, records are deleted from tables CWD_DIRECTORY_ATTRIBUTE and CWD_DIRECTORY_OPERATION.

The data deleted concerns delegated LDAP authentification. We have to reinsert them manually and restart server. After a while (days or weeks), they are again deleted.

If someone can help to understand...

 

1 answer

0 vote
Ann Worley Atlassian Team Jan 17, 2018

Hi Phillipe,

What an interesting case.

Please let me know more:

  • What version of Confluence are you running?
  • How were the deletions discovered? (I am guessing from your database logs)
  • Do you have logs of the SQL that ran against the database to delete the records?
  • If you check the atlassian-confluence.log for the times the deletions are taking place, what is being recorded at that time? 
  • Were the records originally created by Confluence User Directory setup or were they inserted into the database some other way?
  • What is the impact to your delegated User Directory when the deletions occur? (Can users still log in using that Directory?)

Thank you for providing all these details, I look forward to a better understanding so I can see how to help.

Ann

  • What version of Confluence are you running?

5.5.2

  • How were the deletions discovered? (I am guessing from your database logs)

No, originally, little problems appeared:

The link to disable users disappeared.

When a space manager tries to grant rights to users on a space, the rights are not granted (without any error message).

After searching, we discovered that the records related to the ldap configuration in the 2 tables had disappeared (we saw that because we also have a test environment on which we have no problem).

After reinserting records and restart server, all worked fine.

  • Do you have logs of the SQL that ran against the database to delete the records?

No SQL logs.

  • If you check the atlassian-confluence.log for the times the deletions are taking place, what is being recorded at that time? 

There is nothing in atlasssian’s log that may explain the problem

  • Were the records originally created by Confluence User Directory setup or were they inserted into the database some other way?

I don't know.

  • What is the impact to your delegated User Directory when the deletions occur? (Can users still log in using that Directory?)

The users can still log in. and they experienced no problem.

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
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

2,939 views 27 12
Join discussion

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