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.
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 |