jira 7: jira_total_attachments_gauge shows 0 as value

[AwraamFanariotis]

Hello everyone,

for jira 7 the total attachment size gauge shows 0 as value metrics page:

• HELP jira_total_attachment_size_gauge Total Attachments Size Gauge
• TYPE jira_total_attachment_size_gauge gauge jira_total_attachment_size_gauge 0.0

In the jira logs the following is shown: 2019-09-02 15:07:09,358 pool-67-thread-1 ERROR jira-internal-sysadmin 574x1815x1 1uvdfio 53.18.156.27:24648,127.0.0.1 /rest/plugins/1.0/ [r.a.a.p.promjiraexporter.service.ScheduledMetricEvaluator] Failed to resolve attachments size. com.microsoft.sqlserver.jdbc.SQLServerException: invalid object name "fileattachment".

Is this metric bugged or is it only availabe in jira 8 exporter? On older versions (1.0.27) this seems to work fine.

Jira is installed on a MS Server. Database is mssql.

BR

[AndreyVMarkelov]

Hi @AwraamFanariotis Please check what value is set here: https://filebin.ca/4ugetpW760iR/2019-09-120.03.33.png

[AwraamFanariotis]

Hi @AndreyVMarkelov The value is set to 1 Minute, just like in your picture. BR

[AndreyVMarkelov]

Could you check a log file please?

пн, 16 сент. 2019 г. в 9:38, AwraamFanariotis [email protected]:

Hi @AndreyVMarkelov https://github.com/AndreyVMarkelov The value is set to 1 Minute, just like in your picture. BR

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/AndreyVMarkelov/jira-prometheus-exporter/issues/56?email_source=notifications&email_token=AAPXM4E53Q3AMP3O4L7QTQ3QJ4ZZDA5CNFSM4ITD2NO2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD6YKTIY#issuecomment-531671459, or mute the thread https://github.com/notifications/unsubscribe-auth/AAPXM4HWXVCHMBULRB7YGELQJ4ZZDANCNFSM4ITD2NOQ .

-- -- Andrey Markelov

[AwraamFanariotis]

The jira logs show the following error: 2019-09-02 15:07:09,358 pool-67-thread-1 ERROR jira-internal-sysadmin 574x1815x1 1uvdfio 53.18.156.27:24648,127.0.0.1 /rest/plugins/1.0/ [r.a.a.p.promjiraexporter.service.ScheduledMetricEvaluator] Failed to resolve attachments size. com.microsoft.sqlserver.jdbc.SQLServerException: invalid object name "fileattachment".

BR

[AndreyVMarkelov]

Ah sqlserver Sorry I will fix it Which Jira is used?

вт, 17 сент. 2019 г. в 9:00, AwraamFanariotis [email protected]:

The jira logs show the following error: 2019-09-02 15:07:09,358 pool-67-thread-1 ERROR jira-internal-sysadmin 574x1815x1 1uvdfio 53.18.156.27:24648,127.0.0.1 /rest/plugins/1.0/ [r.a.a.p.promjiraexporter.service.ScheduledMetricEvaluator] Failed to resolve attachments size. com.microsoft.sqlserver.jdbc.SQLServerException: invalid object name "fileattachment".

BR

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/AndreyVMarkelov/jira-prometheus-exporter/issues/56?email_source=notifications&email_token=AAPXM4FKA5DP2AS5JCHI25TQKB6BFA5CNFSM4ITD2NO2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD63QRJA#issuecomment-532088996, or mute the thread https://github.com/notifications/unsubscribe-auth/AAPXM4EZE2RLNR6KEQLXWG3QKB6BFANCNFSM4ITD2NOQ .

-- -- Andrey Markelov

[AwraamFanariotis]

Hey no Problem :) Jiraversion 7.13.6

BR

[ricardoecore]

Hello, I'm getting same error on Jira Datacenter 7.13.9. How do we fix that?

ERROR [ru.andreymarkelov.atlas.plugins.promjiraexporter.service.ScheduledMetricEvaluator] Failed to resolve attachments size. ++++

[AndreyVMarkelov]

Hello mssql database?

пн, 28 окт. 2019 г. в 21:50, ricardoecore [email protected]:

Hello, I'm getting same error on Jira Datacenter 7.13.9. How do we fix that?

ERROR [ru.andreymarkelov.atlas.plugins.promjiraexporter.service.ScheduledMetricEvaluator] Failed to resolve attachments size. ++++

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/AndreyVMarkelov/jira-prometheus-exporter/issues/56?email_source=notifications&email_token=AAPXM4AQSWC36SJQDA7UOB3QQ4X7FA5CNFSM4ITD2NO2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOECN7XSI#issuecomment-547093449, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAPXM4GJATWK24RHZVWWZCTQQ4X7FANCNFSM4ITD2NOQ .

-- -- Andrey Markelov

[ricardoecore]

Hello mssql database? пн, 28 окт. 2019 г. в 21:50, ricardoecore [email protected]: Hello, I'm getting same error on Jira Datacenter 7.13.9. How do we fix that? ERROR [ru.andreymarkelov.atlas.plugins.promjiraexporter.service.ScheduledMetricEvaluator] Failed to resolve attachments size. ++++ — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#56?email_source=notifications&email_token=AAPXM4AQSWC36SJQDA7UOB3QQ4X7FA5CNFSM4ITD2NO2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOECN7XSI#issuecomment-547093449>, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAPXM4GJATWK24RHZVWWZCTQQ4X7FANCNFSM4ITD2NOQ . -- -- Andrey Markelov

No, it is a Jira DC on Azure, using AzureSQL (PAS - Platform As a Service).

[AndreyVMarkelov]

Aha Right know issue I will fix ASAP

пн, 28 окт. 2019 г. в 21:54, ricardoecore [email protected]:

Hello mssql database? пн, 28 окт. 2019 г. в 21:50, ricardoecore [email protected]: Hello, I'm getting same error on Jira Datacenter 7.13.9. How do we fix that? ERROR [ru.andreymarkelov.atlas.plugins.promjiraexporter.service.ScheduledMetricEvaluator] Failed to resolve attachments size. ++++ — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#56 https://github.com/AndreyVMarkelov/jira-prometheus-exporter/issues/56?email_source=notifications&email_token=AAPXM4AQSWC36SJQDA7UOB3QQ4X7FA5CNFSM4ITD2NO2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOECN7XSI#issuecomment-547093449>, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAPXM4GJATWK24RHZVWWZCTQQ4X7FANCNFSM4ITD2NOQ . -- -- Andrey Markelov

No, it is a Jira DC on Azure, using AzureSQL (PAS - Platform As a Service).

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/AndreyVMarkelov/jira-prometheus-exporter/issues/56?email_source=notifications&email_token=AAPXM4BL4FP2KXKRFAJBTPLQQ4YN7A5CNFSM4ITD2NO2YY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOECOAEFI#issuecomment-547095061, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAPXM4APPGSTOSNNZDTV2SLQQ4YN7ANCNFSM4ITD2NOQ .

-- -- Andrey Markelov

[saldor100]

Same error on mssql 2017 with jira dc 8.2.4 here and lastest version of the plugin.

Martin

[vetalka]

i have same issue on Jira Software 8.5.3

Vitaly