Jira Diagnostics & Troubleshooting

java.net.NoRouteToHostException: No route to host (Host unreachable)This is often caused by a removed cluster node. Jira still tries to connect to it even though it no longer exists.
WARN user@domain.co.uk [c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections: taken => count=3; marks=[2-3]; pool=5/20WARN user@domain.co.uk [c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections: replaced => count=2; marks=[1-3]; pool=2/20WARN user@domain.co.uk [c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections: replaced => count=1; marks=[0-3]; pool=1/20WARN anonymous [c.a.jira.ofbiz.ConnectionPoolHealthSqlInterceptor] Dangerous use of multiple connections: replaced => count=0; marks=[-1-3]; pool=0/20

insight_import.log

audit

/var/atlassian/application-data/jira/log/audit

{"affectedObjects":[{"name":"myoldadmingroup","type":"GROUP"},{"id":"JIRAUSER99999","name":"auser@mycompany.com","type":"USER"}],"auditType":{"action":"User removed from group","actionI18nKey":"jira.auditing.user.removed.from.group","area":"USER_MANAGEMENT","category":"group management","categoryI18nKey":"jira.auditing.category.groupmanagement","level":"BASE"},"author":{"id":"-2","name":"Anonymous","type":"user"},"changedValues":[],"extraAttributes":[{"name":"Load balancer/proxy IP address","nameI18nKey":"atlassian.audit.event.attribute.forwarder","value":"10.111.111.111"}],"method":"Browser","node":"i-0e971a3635a559df0","source":"49.111.111.111","system":"https://jiraservicedesk.mycompany.com","timestamp":{"epochSecond":1680012643,"nano":114000000},"version":"1.0"}{"affectedObjects":[{"name":"myadmingroup","type":"GROUP"},{"id":"JIRAUSER99999","name":"auser@mycompany.com","type":"USER"}],"auditType":{"action":"User added to group","actionI18nKey":"jira.auditing.user.added.to.group","area":"USER_MANAGEMENT","category":"group management","categoryI18nKey":"jira.auditing.category.groupmanagement","level":"BASE"},"author":{"id":"10401","name":"myuser@mycompany.com","type":"ApplicationUser","uri":"/secure/ViewProfile.jspa?name=myuser@mycompany.com"},"changedValues":[],"extraAttributes":[{"name":"Load balancer/proxy IP address","nameI18nKey":"atlassian.audit.event.attribute.forwarder","value":"10.111.111.111"}],"method":"Browser","node":"i-0e971a3635a559df0","source":"200.111.111.111","system":"https://jiraservicedesk.mycompany.com","timestamp":{"epochSecond":1680014507,"nano":830000000},"version":"1.0"}

epochconverter.com

In the example above we see that...

JIRAUSER99999 was removed from myoldadmingroup by an anonymous user with a source IP of 49.111.111.111 at 14:10:43 on 28-Mar-2023
JIRAUSER99999 was added to myadmingroup by myuser@mycompany.com from 200.111.111.111 at 14:41:47 GMT on 28-Mar-2023

Jira HealthCheck

HealthCheck: Shared Home

This is an issue related to /media/atl/jira/shared...

Are you sure the same EFS volume is mounted on all nodes?
Check cluster.properties in /var/atlassian/application-data/jira/
See: https://confluence.atlassian.com/jirakb/healthcheck-shared-home-738722489.html

HealthCheck: Cluster Index Replication

See: https://confluence.atlassian.com/jirakb/cluster-index-replication-health-check-fails-in-jira-data-center-738722192.html

Jira Index

Case Studies

Http error in catalina.out

Http error: Connection timed out (Connection timed out)Http error: Connection timed out (Connection timed out)Http error: myapp1.mydomain.comHttp error: myapp2.mydomain.comHttp error: myapp3.mydomain.com

Check whether any Assets/Insight objects have the URL Ping service enabled using this SQL...

SELECT "ID",

"NAME",

"OBJECT_TYPE_ID",

"ADDITIONAL_VALUE",

"DEFAULT_TYPE_ID"

FROM "AO_8542F1_IFJ_OBJ_TYPE_ATTR"

WHERE "DEFAULT_TYPE_ID"=7

AND "ADDITIONAL_VALUE"='ENABLED';

DEFAULT_TYPE_ID

0=Text
7=URL

If URL Ping is enabled but the URLs are not reachable from Assets/Insight, you might see the errors above.

Bibliography