Jira Data Center sending request to Db even on idle stage

[Keny Jimenez]

Good morning everyone,

Has anyone experienced unexpected database activity in Jira Data Center where the application is making frequent requests to the Postgres database even when the system is in an idle state (no active users)?

In our case, we’ve observed noticeable spikes in DB requests going to our AWS RDS Postgres instance despite no one actively using Jira. Unfortunately, we cannot rely on pg_stat_statements since it’s not available in our RDS setup. I’ve heard about potential monitoring solutions with Route 53, but since I’m not the cloud developer and don’t have access to those resources, that’s not an option for me at the moment.

Has anyone in the community faced a similar scenario? If so:

• How did you identify the root cause of these idle-state database spikes?

• Were you able to stabilize DB performance through Jira configuration, database settings, or third-party tools?

• Any recommendations on tools or techniques for better tracking and diagnosing these spikes would be greatly appreciated.

Thanks in advance for your guidance!

[Matteo Vecchiato]

Hi @Keny Jimenez ,

Welcome to Atlassian community and thank you for your question.

I would recommend analyse the situation with Java melody monitoring tool, a traditional tool used for monitoring purpose, that works also with Data Center: https://marketplace.atlassian.com/apps/20909/javamelody-monitoring?hosting=server&tab=overview 

Try to identify which node is involved (if you have more than 1 node) and monitor the situation during few days, together with audit log and server file logs (https://confluence.atlassian.com/jirakb/useful-log-files-in-jira-data-center-1027120387.html ) 

It comes to my mind that the activity could be caused by automatic reindex, automatic xml backup planned.

I hope it helps

Kind regards

[Dick]

Hi @Keny Jimenez Welcome to the Atlassian Community

I can give you some pointers as where to find Jira activity in Jira Data Center even when there are no users connected. There are a number of automated scripts that fire-up regulary as these are cron based. Their function is to 'cleanup' your instance and keep it running smoothly.

You find them under:
Admin Cogwheel - System - Scheduler details

So don't be too alarmed if there's activity without users :)

Kind regards,
Dick