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

Поиск
Список
Период
Сортировка
От postgann2020 s
Тема Need help to resolve plprofiler error "Exception: No profiling data found"
Дата
Msg-id CANynezOxz3xb3w4jmUg94ZFxQyoxP5SFmsyZFGfLzE3Gqm3XQA@mail.gmail.com
обсуждение исходный текст
Список 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@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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: postgann2020 s
Дата:
Сообщение: Re: Significance of backend_xmin in pg_stat_activity view
Следующее
От: postgann2020 s
Дата:
Сообщение: proc state as "Idle_in_transaction" in pg_stat_activity