Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
2643 Zobrazení

All odoo http workers stuck in the below query suddenly for a long time


SELECT "ir_mail_server"."id" as "id","ir_mail_server"."name" as "name","ir_mail_server"."smtp_host" as
"smtp_host","ir_mail_server"."smtp_port" as "smtp_port","ir_mail_server"."smtp_user" as "smtp_user","ir_mail_server"."smtp_pass" as "smtp_pass","ir_mail_server"."smtp_encryption" as "smtp_encryption","ir_mail_server"."smtp_debug" as
"smtp_debug","ir_mail_server"."sequence" as "sequence","ir_mail_server"."active" as "active","ir_mail_server"."smtp_from" as "smtp_from","ir_mail_server"."domain_whitelist" as "domain_whitelist","ir_mail_server"."company_id" as "company_id","ir_mail_server"."reply_to"
as "reply_to","ir_mail_server"."create_uid" as "create_uid","ir_mail_server"."create_date" as "create_date","ir_mail_server"."write_uid" as "write_uid","ir_mail_server"."write_date" as "write_date" FROM "ir_mail_server" WHERE "ir_mail_server".id IN (2)


PG logs shows that the query in ClientRead and it is idle in trans.

Webclient is not accesible during this. I had to restart odoo to get services resumed. Not sure about the right approach in fixing this issue.

I'd appreciate any help

Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
1
zář 25
1849
0
úno 25
2538
2
led 25
9457
2
led 24
10139
7
led 24
50362