From: | postgann2020 s <postgann2020(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | proc state as "Idle_in_transaction" in pg_stat_activity |
Date: | 2020-04-12 12:37:15 |
Message-ID: | CANynezPQezxg3nr1OJ6FitwQbfCjny-T7t48461PQpFATg1B1w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi All,
Good Evening.
Could someone please suggest the process to resolve the issue.
Issue : proc state as "Idle_in_transaction"
Env: Postgres 9.5.15
Job Schedulers : Tomcat ( For running procs).
We are using tomcat as scheduler for running few jobs.we are observing one
of the proc state as "Idle_in_transaction" and due to this remaining other
dependent procs get stucked and causing waiting for ever.
If we ran same proc from psql and pgadmin we could able to run successfully
and able to get response and no "Idle_in_transaction" state.
proc: select msg,rescode from schema.proc_name('arg1','arg2');
We are not sure from where we have to start troubleshooting.
Thanks & Regards,
Postgadm.
From | Date | Subject | |
---|---|---|---|
Next Message | David G. Johnston | 2020-04-12 16:15:38 | Re: proc state as "Idle_in_transaction" in pg_stat_activity |
Previous Message | postgann2020 s | 2020-04-10 16:36:20 | Need help to resolve plprofiler error "Exception: No profiling data found" |