Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

Disable Lexo Rank (Balancing) Edited

Hello,

we have a Jira Software Instance that doesnt make use of boards and the ranking feature.

We are examining some issues with failing SQL statements and these problems always seem to be preceeded by this SQL failing (from the postgres log file):

2021-04-19 07:00:37.633 CEST [3323] jira@jiradb ERROR: canceling statement due to user request
2021-04-19 07:00:37.633 CEST [3323] jira@jiradb CONTEXT: while updating tuple (504,154) in relation "AO_60DB71_LEXORANK"
2021-04-19 07:00:37.633 CEST [3323] jira@jiradb STATEMENT: UPDATE public."AO_60DB71_LEXORANK" SET "LOCK_HASH" = $1, "LOCK_TIME" = $2 WHERE "ID" IN ($3, $4) AND ("LOCK_HASH" IS NULL OR "LOCK_TIME" < $5)
2021-04-19 07:00:37.679 CEST [3323] jira@jiradb ERROR: current transaction is aborted, commands ignored until end of transaction block

The docs state

"service status" will bet set to "Balancing disabled" when (among other things) "balancing has been explicitly suspended by Support or an administrator".

My questions:

  1. How can i disable balancing?
  2. How can i see when balancing takes place?
  3. Is there a way to disable the whole ranking system?
  4. Can maybe restrict balancing to certain hours?

Edit:
Im sure the cause is not in the rebalancing feature of Lexo Rank, its in what happens inside Jira Software when an issue is created and rank is applied to the new issue (even when a rebalance is not running)

I could also reproduce this for a case with only few issues being created.

 

Thanks in advance

Jens

2 answers

2 accepted

1 vote
Answer accepted

The answer to 1 and 2 is the same - go see Admin -> Lexorank, it will show you the current status.  You can't really do 2 real-time though - you could enable a bit more logging and see when it kicks off in the application log, but actually knowing when it is running isn't of much use - what would you be doing differently if you did know

3 is a "not really".  The only way to truly disable it is to remove it, which means removing Jira Software and all the other stuff it does, and going back to Core (or Core + JSM)

4.  No, the lexoranking is done when it is needed, and if you don't do it then, you will end up with ranking failures and an inability to use boards.

It would be worth chasing down the database transaction error, rather than blame lexoranking and hence disable Jira Software.

Hey Nic,

a big thank you for your reply!

The answer to 1 and 2 is the same - go see Admin -> Lexorank, it will show you the current status. 

Do you know of a way to monitor this?

How can i suspend / disable the balancing there? i dont see a button for this under admin > lexorank.

what would you be doing differently if you did know

I could stop pursuing the issue if i ruled this out as a source of the problem or we could consider removing jira software in favor of jira core

you could enable a bit more logging

im going by setting com.atlassian.greenhopper to debug, or is there a class specific to lexo ranking?

It would be worth chasing down the database transaction error

How could one trace that?

Cheers

Jens

The only way to "monitor" it would be log analysis or writing an app that can track it.  You used to be able to disable the automatic trigger from the admin screen, but that did go away a while ago, as all it did was break things more.

The thing you need to be doing differently here is tracking down the database errors that are causing the rebalancing to fail.  

To track it, yes, there are classes listed, but they vary by version.  Check the list in "logging and profiling", anything related to rank would be worth increasing logging on (then you'll need to do more log analysis).  On the database side, also enable/increase database logging in the same place.

0 votes
Answer accepted

Deinstalling Jira Software made this problem disapear.

Just deleting the license didnt help though.

Suggest an answer

Log in or Sign up to answer
TAGS

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