Need help to resolve plprofiler error "Exception: No profiling data found"

From: postgann2020 s <postgann2020(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Need help to resolve plprofiler error "Exception: No profiling data found"
Date: 2020-04-10 16:36:20
Message-ID: CANynezOxz3xb3w4jmUg94ZFxQyoxP5SFmsyZFGfLzE3Gqm3XQA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Team
Good Evening

We are using plprofiler from very long time, I was working fine, but from
today morning onwards it is not working properly.

We are getting below issue.

[postgres(at)Host1 proc_testing]$sudo plprofiler run --command "select
create_proc_whole(22701)" -d proc_7feb_db -U postgres -p 5555 --output
tpcb1-proc_7feb_db1.html
select create_proc_whole(22701)
-- row1:
create_proc_whole: (SUCCESS,"Proc Data inserted successfully")
----
(1 rows)
SELECT 1 (0.275 seconds)
Traceback (most recent call last):
File "/bin/plprofiler", line 9, in <module>
load_entry_point('plprofiler==4.1', 'console_scripts', 'plprofiler')()
File
"/usr/lib/python2.7/site-packages/plprofiler-4.1-py2.7.egg/plprofiler/plprofiler_tool.py",
line 75, in main
return run_command(sys.argv[2:])
File
"/usr/lib/python2.7/site-packages/plprofiler-4.1-py2.7.egg/plprofiler/plprofiler_tool.py",
line 844, in run_command
report_data = plp.get_local_report_data(opt_name, opt_top, args)
File
"/usr/lib/python2.7/site-packages/plprofiler-4.1-py2.7.egg/plprofiler/plprofiler.py",
line 403, in get_local_report_data
raise Exception("No profiling data found")
Exception: No profiling data found

Could you please someone suggest,what might be the issues "Exception: No
profiling data found"
Until yesterday, we could able to get the HTML report for the same, from
today morning onwards we are getting above issue.

Thanks for your support.

Regards,
Postgann.

Browse pgsql-admin by date

  From Date Subject
Next Message postgann2020 s 2020-04-12 12:37:15 proc state as "Idle_in_transaction" in pg_stat_activity
Previous Message postgann2020 s 2020-04-08 17:50:54 Re: Significance of backend_xmin in pg_stat_activity view