Dear All,

We see one critical issue in Odoo16 while fetchmail service is running.

It throws the following error each time the scheduled action calls the fetch mail service.

ERROR:  could not obtain lock on row in relation "ir_cron"

2025-01-21 08:29:23.708 UTC [3255822] odoo@ws16ce_live STATEMENT:  

                          SELECT id

                          FROM "ir_cron"

                          WHERE id IN (5)

                          FOR NO KEY UPDATE NOWAIT

Due to this reason, it throws the below error

2025-01-21 08:29:21.593 UTC [3473035] odoo@postgres FATAL:  sorry, too many clients already

2025-01-21 08:29:24.451 UTC [3473040] odoo@postgres FATAL:  sorry, too many clients already

the Postgres service connection stopped over a period of time due to above error occurs frequently

Any solution to solve this will be higly appricated. 

If I need to do modify any odoo.conf or postgres conf files, please let us know the changes to be applied, will configure and check

Please let me know if any more info required

Thanks

Odoo@TenthPlanet