JIRA Upgrade 8.6.1 to 8.18.1. Will not start FATAL : Startup check failed. Jira will be locked.

[geoffbland]

I have upgraded from JIRA 8.6.1 to 8.18.1 and now JIRA will not start up.

I followed the normal installation instructions from the atlassian-jira-core-8.18.1-x64.bin file and this gave no errors. Previous similar upgrades have worked fine.

The only error I have is the following in catalina.out 

2021-07-28 19:12:45,322+0100 JIRA-Bootstrap FATAL [c.a.jira.startup.JiraStartupLogger] Startup check failed. Jira will be locked.

No other log files show any errors. I do have a warning about not using SSL for MySQL connection but I am pretty sure this was present before the upgrade and is not the problem.

This is running on Lubuntu 18.04LTS, using a MySQL database with the mysql driver mysql-connector-java-5.1.46-bin.jar installed in the lib directory.

What can I do to investigate and resolve this issue?

[Rodrigo Girardi Adami]

Hi Christian,

You can achieve that by checking the cwd_user_attribute table in JIRA and checking if that user id is located there with the lastAuthenitcated row.

In case some user does not have the attribute lastAuthenticated, then it means he/she never logged to the app.

This query should work for you. I've tested it for Confluence database but JIRA user tables are very similar and should work as well, if not at least you have the idea on how to retrieve this data. 

The query below will show you all users that have logged to the app so it means the users that are not returned have not logged to the app yet.

select cu.id, cu.lower_user_name, cua.attribute_name, cua.attribute_value
from cwd_user cu
join cwd_user_attribute cua on cu.id = cua.user_id
where cua.attribute_name = 'lastAuthenticated';

EDIT.

Improving the query, it now shows the users who didn't logged as results.

select cu.id, cu.lower_user_name, cua.attribute_name, cua.attribute_value
from cwd_user cu, cwd_user_attribute cua
where cu.id not in
(select cu.id
from cwd_user cu
join cwd_user_attribute cua on cu.id = cua.user_id)
and cua.attribute_name = 'lastAuthenticated';

I hope this helps!

Cheers,

Rodrigo

[C]

does anyone know how to do this with Script Runner?

[C]

PS>>>> with Script Runner