dalibo / temboard

PostgreSQL Remote Control
https://labs.dalibo.com/temboard
Other
459 stars 54 forks source link

Activity menu doesn't showing query with active state #1299

Open fathoniinsansilmi opened 1 year ago

fathoniinsansilmi commented 1 year ago

image

i've tried to restart the agent and the ui but it didn't solved the error

Ui v8.0 agent v8.1

please help

bersace commented 1 year ago

hi thanks for reaching,

can you show records with all states checked ? what is the content of pg_stat_activity ?

bsislow commented 2 months ago

@bersace - I'm having the exact same issue. I can reproduce with pg_sleep easily. Can I email you details due to sensitive screenshot information? I would consider this critical as the Activity screen is misleading with this issue.

$ temboard -V
temBoard 8.0 (/usr/bin/temboard)
System Red Hat Enterprise Linux 8.9 (Ootpa)
Python 3.6.8 (/usr/libexec/platform-python)
cryptography 3.2.1
Tornado 6.0.2
libpq 15.6
psycopg2 2.7.5 (dt dec pq3 ext lo64)
SQLAlchemy 1.3.2

$ temboard-agent -V
temBoard agent 8.2.1 (/usr/bin/temboard-agent)
System Red Hat Enterprise Linux 8.9 (Ootpa)
Python 3.6.8 (/usr/libexec/platform-python)
bottle 0.12.21
cryptography 3.2.1
libpq 15.5
psycopg2 2.7.5 (dt dec pq3 ext lo64)
bersace commented 2 months ago

@bersace - I'm having the exact same issue. I can reproduce with pg_sleep easily. Can I email you details due to sensitive screenshot information?

Yes, please.

Thanks.

bsislow commented 2 months ago

Sorry, can you provide your latest email for this? Thanks!

bersace commented 2 months ago

Sorry, can you provide your latest email for this? Thanks!

etienne dot bersac at dalibo dot com

bsislow commented 2 months ago

@bersace - email sent August 26th, do you have any update? I tried removing/cleaning and redeploying the agent and the same issue persists. This is a critical target as we need real-time monitoring and the blocking/waiting tabs are useful but do not function properly.

bersace commented 2 months ago

@bersace - email sent August 26th, do you have any update?

Thanks for the head-up. I found your mails in the spams ! Sorry !

bsislow commented 1 month ago

@bersace - any updates? Thank you. This is still an issue.