Need help, i unable to turn on JIRA.

[Romy T.]

JIRA-Bootstrap ERROR [c.atlassian.jira.ComponentManager] Error occurred while starting component 'com.atlassian.jira.monitoring.jmx.JmxMetricsExposerImpl'.
com.opensymphony.module.propertyset.PropertyImplementationException: Failed operation: SetOperation[entityName=jira.properties,entityId=1,propertyKey=jira.monitoring.jmx.enabled,newType=1,newMapper=TypeMapper[handler=NumberPropertyHandler,valueEntity=OSPropertyNumber]]
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.propEx(CachingOfBizPropertyEntryStore.java:349)

[Romy T. · Accepted solution]

we preformed below article and it recover the DB.

https://amlucaszz.wordpress.com/2017/12/17/detail-could-not-open-file-pg_clog-xxxx-no-such-file-or-directory/

[Andy Heinzer]

When did this problem start?  Is this a fresh install of Jira?  Did you recently attempt to upgrade your Jira? 

It feels like this kind of error is one that can happen when you try to upgrade Jira, but there appears to be a problem on the backend where the SQL data is stored. 

If this was an upgrade, let us know what version you were on, and what version you are going to,

Even if this is not an upgrade, please let us know what version of Jira this is, and what database type/version you are using,

[Romy T.]

this is not an upgrade.

we use postgresql 9.6.

we tried to delete a log in postgresql database, few hours later this things happen. do you have a solution for this kind of issue? @Andy Heinzer

[Mirek]

Please provide JIRA version on which you are working on.

[Romy T.]

its 7.9.2 server version. 

[Nic Brough -Adaptavist-]

Ouch!  You should never touch a Jira database unless you have it offline, and you know exactly what you are doing.

Your best option is likely to be to roll back to the backup you should have taken before you ran the SQL.

[Romy T.]

2018-10-08 21:21:50,904 JIRA-Bootstrap ERROR [c.atlassian.jira.ComponentManager] Error occurred while starting component 'com.atlassian.jira.monitoring.jmx.JmxMetricsExposerImpl'.
com.opensymphony.module.propertyset.PropertyImplementationException: Failed operation: SetOperation[entityName=jira.properties,entityId=1,propertyKey=jira.monitoring.jmx.enabled,newType=1,newMapper=TypeMapper[handler=NumberPropertyHandler,valueEntity=OSPropertyNumber]]
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.propEx(CachingOfBizPropertyEntryStore.java:349)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.retry(CachingOfBizPropertyEntryStore.java:335)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.setEntry(CachingOfBizPropertyEntryStore.java:155)
at com.atlassian.jira.propertyset.CachingOfBizPropertySet.setImpl(CachingOfBizPropertySet.java:183)
at com.opensymphony.module.propertyset.AbstractPropertySet.set(AbstractPropertySet.java:502)
at com.opensymphony.module.propertyset.AbstractPropertySet.setBoolean(AbstractPropertySet.java:147)
at com.atlassian.jira.config.properties.ApplicationPropertiesStore.setOption(ApplicationPropertiesStore.java:206)
at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.setOption(ApplicationPropertiesImpl.java:115)
at com.atlassian.jira.monitoring.jmx.JmxMetricsExposerImpl.startExposing(JmxMetricsExposerImpl.java:84)
at com.atlassian.jira.monitoring.jmx.JmxMetricsExposerImpl.refreshState(JmxMetricsExposerImpl.java:123)
at com.atlassian.jira.monitoring.jmx.JmxMetricsExposerImpl.init(JmxMetricsExposerImpl.java:113)
at com.atlassian.jira.monitoring.jmx.JmxMetricsExposerImpl.start(JmxMetricsExposerImpl.java:118)
at com.atlassian.jira.ComponentManager.runStartable(ComponentManager.java:311)
at com.atlassian.jira.ComponentManager.quickStart(ComponentManager.java:227)
at com.atlassian.jira.ComponentManager.start(ComponentManager.java:168)
at com.atlassian.jira.upgrade.PluginSystemLauncher.start(PluginSystemLauncher.java:45)
at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDbLaunch$2(DefaultJiraLauncher.java:143)
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:304)
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:199)
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.lang.Thread.run(Thread.java:745)
Caused by: com.querydsl.core.QueryException: Caught PSQLException for select O_S_PROPERTY_ENTRY.id, O_S_PROPERTY_ENTRY.propertytype
from public.propertyentry O_S_PROPERTY_ENTRY
where O_S_PROPERTY_ENTRY.entity_name = ? and O_S_PROPERTY_ENTRY.entity_id = ? and O_S_PROPERTY_ENTRY.property_key = ?
order by O_S_PROPERTY_ENTRY.id desc
for update
at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50)
at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:502)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore$SetOperation.upsert(CachingOfBizPropertyEntryStore.java:624)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.lambda$tx$6(CachingOfBizPropertyEntryStore.java:311)
at com.atlassian.jira.database.DefaultQueryDslAccessor$1.lambda$executeQuery$0(DefaultQueryDslAccessor.java:85)
at com.atlassian.jira.database.DatabaseAccessorImpl.executeQuery(DatabaseAccessorImpl.java:68)
at com.atlassian.jira.database.DefaultQueryDslAccessor$1.executeQuery(DefaultQueryDslAccessor.java:84)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.query(CachingOfBizPropertyEntryStore.java:301)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.tx(CachingOfBizPropertyEntryStore.java:309)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.access$300(CachingOfBizPropertyEntryStore.java:67)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore$SetOperation.perform(CachingOfBizPropertyEntryStore.java:612)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.retry(CachingOfBizPropertyEntryStore.java:321)
... 23 more
Caused by: org.postgresql.util.PSQLException: ERROR: could not access status of transaction 95631817
Detail: Could not open file "pg_clog/005B": No such file or directory.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:116)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:446)
... 33 more
2018-10-08 21:21:50,907 JIRA-Bootstrap ERROR [c.a.jira.upgrade.PluginSystemLauncher] A fatal error occured during initialisation. JIRA has been locked.
com.atlassian.jira.InfrastructureException: Error occurred while starting component 'com.atlassian.jira.monitoring.jmx.JmxMetricsExposerImpl'.
at com.atlassian.jira.ComponentManager.runStartable(ComponentManager.java:315)
at com.atlassian.jira.ComponentManager.quickStart(ComponentManager.java:227)
at com.atlassian.jira.ComponentManager.start(ComponentManager.java:168)
at com.atlassian.jira.upgrade.PluginSystemLauncher.start(PluginSystemLauncher.java:45)
at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDbLaunch$2(DefaultJiraLauncher.java:143)
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:304)
at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:199)
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.lang.Thread.run(Thread.java:745)
Caused by: com.opensymphony.module.propertyset.PropertyImplementationException: Failed operation: SetOperation[entityName=jira.properties,entityId=1,propertyKey=jira.monitoring.jmx.enabled,newType=1,newMapper=TypeMapper[handler=NumberPropertyHandler,valueEntity=OSPropertyNumber]]
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.propEx(CachingOfBizPropertyEntryStore.java:349)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.retry(CachingOfBizPropertyEntryStore.java:335)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.setEntry(CachingOfBizPropertyEntryStore.java:155)
at com.atlassian.jira.propertyset.CachingOfBizPropertySet.setImpl(CachingOfBizPropertySet.java:183)
at com.opensymphony.module.propertyset.AbstractPropertySet.set(AbstractPropertySet.java:502)
at com.atlassian.jira.config.properties.ApplicationPropertiesStore.setOption(ApplicationPropertiesStore.java:206)
at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.setOption(ApplicationPropertiesImpl.java:115)
at com.atlassian.jira.monitoring.jmx.JmxMetricsExposerImpl.startExposing(JmxMetricsExposerImpl.java:84)
at com.atlassian.jira.monitoring.jmx.JmxMetricsExposerImpl.refreshState(JmxMetricsExposerImpl.java:123)
at com.atlassian.jira.monitoring.jmx.JmxMetricsExposerImpl.init(JmxMetricsExposerImpl.java:113)
at com.atlassian.jira.monitoring.jmx.JmxMetricsExposerImpl.start(JmxMetricsExposerImpl.java:118)
at com.atlassian.jira.ComponentManager.runStartable(ComponentManager.java:311)
... 12 more
Caused by: com.querydsl.core.QueryException: Caught PSQLException for select O_S_PROPERTY_ENTRY.id, O_S_PROPERTY_ENTRY.propertytype
from public.propertyentry O_S_PROPERTY_ENTRY
where O_S_PROPERTY_ENTRY.entity_name = ? and O_S_PROPERTY_ENTRY.entity_id = ? and O_S_PROPERTY_ENTRY.property_key = ?
order by O_S_PROPERTY_ENTRY.id desc
for update
at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50)
at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:502)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore$SetOperation.upsert(CachingOfBizPropertyEntryStore.java:624)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.lambda$tx$6(CachingOfBizPropertyEntryStore.java:311)
at com.atlassian.jira.database.DefaultQueryDslAccessor$1.lambda$executeQuery$0(DefaultQueryDslAccessor.java:85)
at com.atlassian.jira.database.DatabaseAccessorImpl.executeQuery(DatabaseAccessorImpl.java:68)
at com.atlassian.jira.database.DefaultQueryDslAccessor$1.executeQuery(DefaultQueryDslAccessor.java:84)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.query(CachingOfBizPropertyEntryStore.java:301)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.tx(CachingOfBizPropertyEntryStore.java:309)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.access$300(CachingOfBizPropertyEntryStore.java:67)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore$SetOperation.perform(CachingOfBizPropertyEntryStore.java:612)
at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.retry(CachingOfBizPropertyEntryStore.java:321)
... 23 more
Caused by: org.postgresql.util.PSQLException: ERROR: could not access status of transaction 95631817
Detail: Could not open file "pg_clog/005B": No such file or directory.
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:116)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:446)
... 33 more
2018-10-08 21:21:50,934 JIRA-Bootstrap ERROR [c.a.jira.health.HealthChecks] We couldn't start JIRA
2018-10-08 21:21:50,934 JIRA-Bootstrap ERROR [c.a.jira.health.HealthChecks] An error occurred while trying to start JIRA. We can't give you any more detail right now, we suggest checking the logs for more detail and contacting our support team.
See our documentation for more information on contacting our support team and creating a support zip.
2018-10-08 21:21:51,209 JIRA-Bootstrap ERROR [c.a.jira.startup.DefaultJiraLauncher] JIRA has failed to start because of the following errors: [(Event: Level = (EventLevel: fatal) , Key = (EventType: startup-unexpected) , Desc = We couldn't start JIRA , Exception = An error occurred while trying to start JIRA. We can't give you any more detail right now, we suggest checking the logs for more detail and contacting our support team.<br/>See our documentation for more information on contacting our support team and creating a support zip.)]
2018-10-08 21:21:51,219 JIRA-Bootstrap INFO [c.a.jira.startup.LauncherContextListener] Memory Usage:
---------------------------------------------------------------------------------
Heap memory : Used: 382 MiB. Committed: 10240 MiB. Max: 10240 MiB
Non-heap memory : Used: 250 MiB. Committed: 271 MiB. Max: 1264 MiB
---------------------------------------------------------------------------------
TOTAL : Used: 632 MiB. Committed: 10511 MiB. Max: 11504 MiB
---------------------------------------------------------------------------------
2018-10-08 21:21:51,273 active-objects-init-JiraTenantImpl{id='system'}-0 DEBUG anonymous [c.a.activeobjects.osgi.TenantAwareActiveObjects] bundle [com.tuncaysenturk.jira.plugins.jira-enhancer-plugin] created ActiveObjects
2018-10-08 21:21:53,301 http-nio-8080-exec-21 INFO anonymous 1281x4x1 n52e81 172.22.13.135 /secure/errors.jsp [c.q.jira.fieldsecurity.FieldSecuritySettingsImpl] Using failFast setting = true

[Mirek]

You might be facing this problem - https://jira.atlassian.com/browse/JRASERVER-67614

Did you tried to start JIRA without JMX Monitoring tool?

[Romy T.]

how do we enable it?

[Romy T.]

i mean, disable it.

[Mirek]

I would guess that this would be the procedure

• Stop JIRA
• Open jira-config.properties file in JIRA Home root. If the file is not present create it.
• Add a new line that reads: "jira.monitoring.jmx.enabled=false"
• Start JIRA

[Romy T.]

hi @Mirek it doesnt work :)

[Mirek]

In that case looking at your more detailed looks I guess that it might be a bigger problem even a database corruption.

Did you change recently something on a database (or infrastructure side)? Any upgrades, patches?

[Romy T.]

yeah, i think we delete a wrong log in postgreSQL.