Unable to snapshot thread local operations (implementation of OpTimerFactory is not a ThreadLocalOpT

[Karthikeyan_Rajagopal]

Hi, 

I want to configure Jira with external database(Mysql) so I cloned(AMI) the existing Jira with H2 and created new ec2 instance then I stop new Jira instance changed the dbconfig.xml to point to newly created Mysql db  and restart the Jira. then I observed in atlassian-jira.log got this following error.

http-nio-8080-exec-1 ERROR anonymous 424x1x1 - 10.212.255.245 / [c.atlassian.instrumentation.Instrument] Unable to snapshot thread local operations (implementation of OpTimerFactory is not a ThreadLocalOpTimerFactory): null
2023-09-06 07:04:34,067+0000 http-nio-8080-exec-2 WARN anonymous 424x2x1 - 10.212.255.245 /secure/errors.jsp [c.a.jira.security.JiraSecurityFilter] Rejecting security-sensitive request that bypassed Johnson filter: /secure/errors.jsp

Searched in the internet no solutions so how to resolve this? Please help..

[Sayed Bares _ServiceRocket_ · Accepted solution]

@Karthikeyan_Rajagopal welcome to the community!

What do you see at the end of <jira home>/logs/atlassian-jira.log and the tomcat log <jira install>/log/catalina.out ?

Did you follow https://confluence.atlassian.com/jirakb/migrate-from-hsql-embedded-database-to-external-database-in-jira-server-295308246.html to switch from H2 to external?

[Karthikeyan_Rajagopal]

Hi Sayed,  Thanks for the response I am not using configuration tool I manually edit dbconfig.xml to point to Mysql database. 

below is what I found in the requested logs

attlassian-jira.log
----------------------

2023-09-06 13:04:29,782+0000 http-nio-8080-exec-1 ERROR anonymous 784x1x1 - 10.212.255.245 / [c.atlassian.instrumentation.Instrument] Unable to snapshot thread local operations (implementation of OpTimerFactory is not a ThreadLocalOpTimerFactory): null
2023-09-06 13:04:30,083+0000 http-nio-8080-exec-2 WARN anonymous 784x2x1 - 10.212.255.245 /secure/errors.jsp [c.a.jira.security.JiraSecurityFilter] Rejecting security-sensitive request that bypassed Johnson filter: /secure/errors.jsp
2023-09-06 13:04:31,000+0000 http-nio-8080-exec-4 WARN anonymous 784x4x1 - 10.212.255.245 /secure/errors.jsp [c.a.jira.security.JiraSecurityFilter] Rejecting security-sensitive request that bypassed Johnson filter: /secure/errors.jsp

Catalina.out log
-----------------

com.atlassian.jira.exception.DataAccessException: java.sql.SQLSyntaxErrorException: Table 'jiradb.MOVED_ISSUE_KEY' doesn't exist
at com.atlassian.jira.startup.DatabaseLauncher.cleanupDatabaseTableName(DatabaseLauncher.java:254)
at com.atlassian.jira.startup.DatabaseLauncher.cleanupDatabaseTableNames(DatabaseLauncher.java:210)
at com.atlassian.jira.startup.DatabaseLauncher.start(DatabaseLauncher.java:73)
at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDbLaunch$2(DefaultJiraLauncher.java:139)
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:307)
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:202)
at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:135)
at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$start$0(DefaultJiraLauncher.java:102)
at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:31)
at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:100)
at com.atlassian.jira.startup.LauncherContextListener.initSlowStuff(LauncherContextListener.java:154)
at java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLSyntaxErrorException: Table 'jiradb.MOVED_ISSUE_KEY' doesn't exist
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at com.mysql.cj.jdbc.StatementImpl.executeQuery(StatementImpl.java:1200)
at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
... 11 more
2023-09-06 10:50:07,226+0000 JIRA-Bootstrap INFO [c.a.jira.startup.LauncherContextListener] Startup is complete. Jira is ready to serve.
2023-09-06 10:50:07,227+0000 JIRA-Bootstrap INFO [c.a.jira.startup.LauncherContextListener] Memory Usage:
---------------------------------------------------------------------------------
Heap memory : Used: 141 MiB. Committed: 384 MiB. Max: 2048 MiB
Non-heap memory : Used: 84 MiB. Committed: 136 MiB. Max: 1536 MiB
---------------------------------------------------------------------------------