Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

Confluence hammers SQL Server with thousands of queries

Hi,

I recently checked SQL Server that houses Confluence DB and was puzzled to find several Confluence v6.4.3 queries that literally run 3-4 thousand times (!) per minute each in our log. Needless to say this results in CPU performance drain.

Here's one such query for example:

select this_.id as id1_30_0_, this_.user_name as user_nam2_30_0_, this_.lower_user_name as lower_us3_30_0_, this_.active as active4_30_0_, this_.created_date as created_5_30_0_, this_.updated_date as updated_6_30_0_, this_.first_name as first_na7_30_0_, this_.lower_first_name as lower_fi8_30_0_, this_.last_name as last_nam9_30_0_, this_.lower_last_name as lower_l10_30_0_, this_.display_name as display11_30_0_, this_.lower_display_name as lower_d12_30_0_, this_.email_address as email_a13_30_0_, this_.lower_email_address as lower_e14_30_0_, this_.external_id as externa15_30_0_, this_.directory_id as directo16_30_0_, this_.credential as credent17_30_0_ from cwd_user this_ where this_.directory_id=@P0 and this_.lower_user_name=@P1

Given we're talking about an instance that's only used from time to time by 5 folks in total, I'm baffled and bugged by this finding.

Any tips and ideas on troubleshooting or at least throttling this crazy Confluence activity down would be highly appreciated.

Thanks!

1 answer

1 accepted

0 votes
Answer accepted
Daniel Ebers Community Leader Nov 15, 2020

Hi Alexander,

this will be hard to diagnose from remote without access to the server but in the first step you could dig deeper by, for example, enabling a slow query log and stuff to get a better idea to see what is going on.

In case you are using Apps it would also be worth to have a look at them.

Here you find more general information - please make sure to select the right guide according to the database you have installed:

https://confluence.atlassian.com/kb/database-troubleshooting-and-how-to-guides-744326149.html

Cheers,
Daniel

Hi Daniel,

I've come across this article before, however, there isn't anything relevant to the issue contained in it.

have however found more details on SQL logging and have enabled it in Confluence ( https://confluence.atlassian.com/doc/enabling-detailed-sql-logging-179030.html ). Can you please advise where is this log located? This isn't mentioned in the article itself.

Thanks!

Alexander 

Daniel Ebers Community Leader Nov 16, 2020

So far, so good!
The log file is in the "logs" directory. This is stored in the Confluence home directory.

https://confluence.atlassian.com/doc/confluence-home-and-other-important-directories-590259707.html

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Announcing Team Calendars in Confluence Data Center

Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond.  A long time favorite,  Team Cale...

107 views 0 3
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