Confluence 4.3.3 performance issue

Hi,

I upgraded confluence from 3.5.3 to 4.3.3

After update, I faced with serious performance problem.

All User cant't operate.

My environments are

* MySQL 5.1

* Java 1.7

* Linux

* Cluster Confluence edition but one server

* DB Access with datasource

Sudenlly, Database connection pool is max. It seem that queries are not slow because there are no slow query log.

I can't find out on condition.

It seem that cache statics in 4.3 are ineffective than 3.5.3.

So, amount of queries are increase.

Anyone faced with same problem?

Please help me!!!

Regards

Niku

6 answers

1 accepted

0 vote

I have had this consistently too since upgrade to 4.3.1. There is a known issue with the mywork (notifications) plugin, which is exacerbated by the calendar plugin if you have a large user base, but I doubt that's your problem.

Anyway, I still have the problem since applying the fix for that. Been with Atlassian support for about 2 weeks :-(

Hi, Jamie

Thank you for your reply.

I would like to know your resolution.

What kind of plugins did you ivalid?

I think

Notifications and Tasks - Common Plugin

Notifications and Tasks - Host Plugin

Notifications and Tasks - Confluence Provider Plugin


And

I hope your problem will be fixed.

Thanks

I updated the host plugin, but I think the bug only applied to oracle.

How big is your database connection pool? I doubled the size but still getting regular outages.

I tried increase connection, tomcat and yapache and DB.

Now DB thread is 500. But issue in not fixed.

Thanks

Niku

Hi Niku,

I believe the two things you will need to do here are increase your database connection pool, because the addition of Active Objects means more calls to the database, and increase your Heap memory allocation because you will probably find that Confluence consumes more memory in newer versions due to the new features.

Database connections: https://confluence.atlassian.com/display/CONFKB/Confluence+Slows+and+Times+Out+During+Periods+of+High+Load+Due+to+DB+Connection+Pool

Increase memory: https://confluence.atlassian.com/display/CONFKB/How+to+Fix+Out+of+Memory+Errors+by+Increasing+Available+Memory#HowtoFixOutofMemoryErrorsbyIncreasingAvailableMemory-Step2:IncreaseAvailableMemory

However, I believe that once you have done this then it should resolve your issue.

All the best,
John

Hi Niku,

Is there any relevant error message being logged in your <confluence-home>/logs/atlassian-confluence.log?

You can start enabling Safe Mode in Confluence Admin > Plugins to see if there's any third party plugin interference.

Cheers.

I faced with strange situation.

I changed setting of confluence with admin function.

ex) changed security setting , invalid plugin

Sometimes, after that same issues has occured.(increase Database connections)

I wonder if changed setting makes cleare aplication cache or invalid it.

But it is occured without changed setting.

Maybe, some operations makes cache invalid.

It's so, all access execute SQL query not via cache.

It makes DB connection increased suddenly.

Now I found out that all most of caches are expired every hours.

Surely, issue has occured every hours.

Thanks

I found below.

https://jira.atlassian.com/browse/CONF-26823

My environment is cluster. Function of Cache is deffrent from stand alone.

I afraid this ticket effects on this matter.

Thanks

Maybe, I fixed this issue.

The reason is Java 7.

Confluence cluster edition inclued Oracle Coherence.

The version of cohrence is 3.3.

It is not supported Java 7.

I tried downgrade java from 7 to 6.

Issue has not occured.

Thanks

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published yesterday in Confluence

Three common content challenges + how to manage them

An efficient enterprise content management system, or ECM, is a must-have for companies that create work online (cough   cough, all companies). If content calendars, marketing plans, and bu...

70 views 0 4
Read article

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