Non clustered confluence database is being updated by another confluence instance

페이레터 POQ February 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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 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 February 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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 18, 2018

Do both Confluence servers use the same DB?

페이레터 POQ February 19, 2018

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

Guilherme V.
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 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 February 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
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 20, 2018

That looks fine, they should be completely separated.

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

페이레터 POQ February 20, 2018

thank you for your interest, Nic. 

how can I check database log ?

Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
February 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
TAGS
AUG Leaders

Atlassian Community Events