Confluence 4.3.3 performance issue

[kunitaka]

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

[JamieA · Accepted solution]

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 :-(

[kunitaka]

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

[JamieA]

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.

[kunitaka]

I tried increase connection, tomcat and yapache and DB.

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

Thanks

Niku

[kunitaka]

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

[kunitaka]

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

[kunitaka]

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

[AlysonA]

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.

[JohnA]

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