LexoRanking DataAccessException when showing issues

Question

Hello community,

I am currently running into following error in my logs:

2018-02-23 15:14:22,172 lexorank-executor-thread-0 ERROR [c.a.g.s.lexorank.balance.LexoRankBalancingService] org.postgresql.util.PSQLException: UnzulÃ¤ssiger Wert fÃ¼r den Typ int : 0|000000:.
com.atlassian.jira.exception.DataAccessException: org.postgresql.util.PSQLException: UnzulÃ¤ssiger Wert fÃ¼r den Typ int : 0|000000:.
 at com.atlassian.greenhopper.manager.lexorank.LexoRankDaoImpl.find(LexoRankDaoImpl.java:1328)
 at com.atlassian.greenhopper.manager.lexorank.LexoRankDaoImpl.findMinimumMarkerRow(LexoRankDaoImpl.java:324)
 at com.atlassian.greenhopper.manager.lexorank.LexoRankDaoImpl.getMinimumMarkerRow(LexoRankDaoImpl.java:343)
 at com.atlassian.greenhopper.service.lexorank.balance.LexoRankBalancer.balanceFieldId(LexoRankBalancer.java:207)
 at com.atlassian.greenhopper.service.lexorank.balance.LexoRankBalancer.balanceFieldIds(LexoRankBalancer.java:104)
 at com.atlassian.greenhopper.service.lexorank.balance.LexoRankScheduledBalanceHandler.run(LexoRankScheduledBalanceHandler.java:60)
 at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
 at java.lang.Thread.run(Thread.java:748)
Caused by: org.postgresql.util.PSQLException: UnzulÃ¤ssiger Wert fÃ¼r den Typ int : 0|000000:.
 at org.postgresql.jdbc2.AbstractJdbc2ResultSet.toInt(AbstractJdbc2ResultSet.java:2747)
 at org.postgresql.jdbc2.AbstractJdbc2ResultSet.getInt(AbstractJdbc2ResultSet.java:1991)
 at org.apache.commons.dbcp2.DelegatingResultSet.getInt(DelegatingResultSet.java:215)
 at org.apache.commons.dbcp2.DelegatingResultSet.getInt(DelegatingResultSet.java:215)
 at com.atlassian.greenhopper.manager.lexorank.LexoRankDaoImpl.getLexoRankRows(LexoRankDaoImpl.java:1347)

The error message translates to the following:

Invalid value for type int : 0|000000

In addition to that, I get a rendering error in my tickets, showing me

Error rendering 'com.pyxis.greenhopper.jira:greenhopper-epics-issue-web-panel'. Please contact your JIRA administrators.

Following the steps mentioned in https://confluence.atlassian.com/jirakb/issue-screen-displays-error-rendering-greenhopper-epics-issue-web-panel-779158857.html yielded no result, as I had no corrupt data.

I assume this is also caused by the LexoRanking error, but I am not sure how to fix this issue.

Someone here experienced this one yet?

Emre Aslan · Answer

Hi, I am using the following versions:

Jira v7.3.1
Postgresql 9.4.15

There was indeed a problem with the collation. I fixed that issue. The problem still persists, even though the message is a little bit different now:

2018-03-23 13:07:08,713 ajp-nio-8009-exec-6 ERROR testuser 787x2027x1 1e80rno 192.168.21.130 /browse/TMP-2569 [c.a.j.web.component.ModuleWebComponentImpl] An exception occured while rendering the web panel: com.pyxis.greenhopper.jira:greenhopper-epics-issue-web-panel (null)
com.atlassian.greenhopper.manager.lexorank.LexoRankIntegrityException: Expected exactly 2 rows; the maximum marker row and the lowest ranked row for rank field[id=11060]

Executing your provided queries did not yield any results for the first two. Here is the output for the third:

somethingblue · Answer

Hi Emre,

* What version of JIRA are you using?
* What version of Postgres are you using?

I have seen this before and it was due to a collation issue.  Please verify the version of Postgres you are using is supported by the version of JIRA by using the Supported Platforms knowledge base article for the version of JIRA you are using.

In addition, take a look in the JIRA logs and search for "unsupported" or look at the logs shortly after startup to see if there is an error regarding the collation.

You can fix this by referring to How to fix the collation of a Postgres JIRA database.

If the problem persist, please attach the following data provide the output of the SQL query below:

SELECT * FROM "AO_60DB71_LEXORANK" ORDER BY "RANK";

SELECT * FROM "AO_60DB71_LEXORANK" WHERE "TYPE" in (0,2);

\d+ "AO_60DB71_LEXORANK"

Cheers,

Branden