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

Non clustered confluence database is being updated by another confluence instance

페이레터 POQ Feb 18, 2018

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

0 votes
Edwin Kyalangalilwa Community Leader Feb 18, 2018

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

페이레터 POQ Feb 18, 2018

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.

Edwin Kyalangalilwa Community Leader Feb 18, 2018

Do both Confluence servers use the same DB?

페이레터 POQ Feb 19, 2018

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

Guilherme Viana Atlassian Team Feb 19, 2018

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.

페이레터 POQ Feb 20, 2018

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>

Nic Brough [Adaptavist] Community Leader Feb 20, 2018

That looks fine, they should be completely separated.

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

페이레터 POQ Feb 20, 2018

thank you for your interest, Nic. 

how can I check database log ?

Nic Brough [Adaptavist] Community Leader Feb 20, 2018

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

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Confluence

6 Awesome Ways to Apply Trello, JIRA and Confluence to your Project

I attended  Atlassian Summit 2019  and learned a lot from the presenters, attendees and knowledgeable Atlassian product managers. The presentations I attended focused on applying Agile, pla...

2,502 views 11 28
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