Jira update from 9.9.1 to 9.10.0

[Fabian GUERIF]

Hello,

After updating jira from 9.9.1 to 9.10.0, I have the following error message.

logs/catalina.out

2023-07-20 15:33:54,701+0200 main ERROR [c.a.jira.startup.LauncherContextListener] Unable to start JIRA.
java.lang.IllegalStateException: Duplicate key com.atlassian.pats.pats-plugin (attempted merging values com.atlassian.jira.plugin.PluginVersionImpl@50643e7c[id=12811,key=com.atlassian.pats.pats-plugin,name=Personal Access Tokens plugin,version=1.4.4,created=Wed Jun 08 09:46:27 CEST 2022] and com.atlassian.jira.plugin.PluginVersionImpl@328143ba[id=12911,key=com.atlassian.pats.pats-plugin,name=Personal Access Tokens plugin,version=1.4.5,created=Wed Jul 06 08:46:37 CEST 2022])
at java.base/java.util.stream.Collectors.duplicateKeyException(Collectors.java:133)

if anyone can help me?

Thanks in advance.

Regards.

Fabian GUERIF. 

[Fabian GUERIF · Accepted solution]

the SQL queries are as follows.

Selection.

SELECT
pluginkey,
COUNT( pluginkey )
FROM
pluginversion
GROUP BY
pluginkey
HAVING
COUNT( pluginkey )> 1
ORDER BY
pluginkey;

Deletion.

DELETE FROM
pluginversion a
USING pluginversion b
WHERE
a.id < b.id
AND a.pluginkey = b.pluginkey;

[Dan Breyen · Accepted solution]

Hi Fabian, I found this article, it's a little old, but might be applicable: Duplicate Keys 

Hope it helps.

[Fabian GUERIF]

Hi Dan,

Thank you for your help.

To solve the problem (There's probably a simpler way, but I did it as soon as possible).

Databases → jiradb → Schemas → public → Tables → pluginversion
For each duplicate pluginname, delete the oldest version.

Restart jira service.

There's probably a simpler way, but I did it as soon as possible.

Regards.