LexoRanking DataAccessException when showing issues

[Emre Aslan]

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?

[somethingblue]

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

[Emre Aslan]

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:

\d+ "AO_60DB71_LEXORANK"
 Table "public.AO_60DB71_LEXORANK"
 Column | Type | Modifiers | Storage | Stats target | Description
-----------+------------------------+-------------------------------------------------------------------+----------+--------------+-------------
 FIELD_ID | bigint | not null default 0 | plain | |
 ID | bigint | not null default nextval('"AO_60DB71_LEXORANK_ID_seq"'::regclass) | plain | |
 ISSUE_ID | bigint | not null default 0 | plain | |
 LOCK_HASH | character varying(255) | | extended | |
 LOCK_TIME | bigint | | plain | |
 RANK | character varying(255) | not null | extended | |
 TYPE | integer | not null default 0 | plain | |
Indexes:
 "AO_60DB71_LEXORANK_pkey" PRIMARY KEY, btree ("ID")
 "index_ao_60db71_lex1632828616" btree ("LOCK_HASH")
 "index_ao_60db71_lex604083109" btree ("ISSUE_ID")
 "index_ao_60db71_lexorank_rank" btree ("RANK")