Non clustered confluence database is being updated by another confluence instance

We've installed two confluence at one windows web server as a service, (use 8090, 8092 port)

one MSSQL DB server with two category .

Each confluence started without problem.

but sometimes one confluence occured fatal error during live service :

Non Clustered Confluence: Database is being updated by another Confluence instance. Please see http://confluence.atlassian.com/x/mwiyCg for more details.

We restart service when this error occured, but it happens again.

 

1 answer

Hi,

The error is related to not having a data center license for your Confluence and you're trying to cluster with the two instances. 

You'll have to get a data center license to run two Confluences. 

Confluence Data Center

Thank you for your answer Edwin.

We bought two server license for confluence because we run wiki at private network.

two confluence works well usually, but one broke down sometimes.

Do both Confluence servers use the same DB?

no, same DB server, seperated catalog (different DB)

Usually, that error can be one of the following options:

- Two instances connected to the same database schema.
- The database logs are full and are holding the connection.

I'd check the database connection in the confluence.cfg.xml just to ensure that each instance is connected to a specific schema.

same server, seperated db, but schema is same , 'dbo' . is it can occurs problem?

 

<property name="hibernate.connection.url">jdbc:sqlserver://10.10.10.10:7302;databaseName=CONFLUENCE_IMPAY_DB</property>

<property name="hibernate.connection.url">jdbc:sqlserver://10.10.10.10:7302;databaseName=CONFLUENCE_DB</property>

That looks fine, they should be completely separated.

You'll want to check the database logs as Guilherme mentioned.

thank you for your interest, Nic. 

how can I check database log ?

Go to the database server and find the logs for the database system.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Feb 06, 2019 in Confluence

Try out the new editing experience

Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...

933 views 47 7
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