Skip to Content
This question has been flagged
2 Replies
3494 Views
Avatar
Dax1900

Hi all,

When the fetchmail service starts we get errors:


odoo    | 2020-04-09 12:53:29,174 1 INFO Avunet13 werkzeug: 172.18.0.1 - - [09/Apr/2020 12:53:29] "POST /longpolling/poll HTTP/1.1" 200 - 8 0.003 50.017

odoo    | 2020-04-09 12:54:08,954 1 INFO Avunet13 odoo.addons.base.models.ir_cron: Starting job `Mail: Email Queue Manager`.

odoo    | 2020-04-09 12:54:08,973 1 INFO Avunet13 odoo.addons.base.models.ir_cron: Job `Mail: Email Queue Manager` done.

odoo    | 2020-04-09 12:54:20,210 1 INFO Avunet13 werkzeug: 172.18.0.1 - - [09/Apr/2020 12:54:20] "POST /longpolling/poll HTTP/1.1" 200 - 8 0.004 50.039

odoo    | 2020-04-09 12:55:09,013 1 INFO Avunet13 odoo.addons.base.models.ir_cron: Starting job `Mail: Fetchmail Service`.

odoo    | 2020-04-09 12:55:09,025 1 INFO Avunet13 odoo.addons.fetchmail.models.fetchmail: start checking for new emails on imap server expense@avunet

odoo    | 2020-04-09 12:55:09,233 1 INFO Avunet13 odoo.addons.fetchmail.models.fetchmail: Fetched 0 email(s) on imap server expense@avunet; 0 succeeded, 0 failed.

db      | 2020-04-09 12:55:09.244 UTC [94] ERROR:  could not obtain lock on row in relation "ir_cron"

db      | 2020-04-09 12:55:09.244 UTC [94] STATEMENT:  SELECT id FROM "ir_cron" WHERE id IN (8) FOR UPDATE NOWAIT

odoo    | 2020-04-09 12:55:09,247 1 INFO Avunet13 odoo.addons.fetchmail.models.fetchmail: start checking for new emails on imap server catchall@avunet

odoo    | 2020-04-09 12:55:09,410 1 INFO Avunet13 odoo.addons.fetchmail.models.fetchmail: Fetched 0 email(s) on imap server catchall@avunet; 0 succeeded, 0 failed.

db      | 2020-04-09 12:55:09.422 UTC [94] ERROR:  could not obtain lock on row in relation "ir_cron"

db      | 2020-04-09 12:55:09.422 UTC [94] STATEMENT:  SELECT id FROM "ir_cron" WHERE id IN (8) FOR UPDATE NOWAIT

odoo    | 2020-04-09 12:55:09,424 1 INFO Avunet13 odoo.addons.fetchmail.models.fetchmail: start checking for new emails on imap server sales@avunet

odoo    | 2020-04-09 12:55:09,594 1 INFO Avunet13 odoo.addons.fetchmail.models.fetchmail: Fetched 0 email(s) on imap server sales@avunet; 0 succeeded, 0 failed.

db      | 2020-04-09 12:55:09.604 UTC [94] ERROR:  could not obtain lock on row in relation "ir_cron"

db      | 2020-04-09 12:55:09.604 UTC [94] STATEMENT:  SELECT id FROM "ir_cron" WHERE id IN (8) FOR UPDATE NOWAIT

odoo    | 2020-04-09 12:55:09,606 1 INFO Avunet13 odoo.addons.fetchmail.models.fetchmail: start checking for new emails on imap server solar@avunet

odoo    | 2020-04-09 12:55:09,782 1 INFO Avunet13 odoo.addons.fetchmail.models.fetchmail: Fetched 0 email(s) on imap server solar@avunet; 0 succeeded, 0 failed.

db      | 2020-04-09 12:55:09.792 UTC [94] ERROR:  could not obtain lock on row in relation "ir_cron"

db      | 2020-04-09 12:55:09.792 UTC [94] STATEMENT:  SELECT id FROM "ir_cron" WHERE id IN (8) FOR UPDATE NOWAIT

odoo    | 2020-04-09 12:55:09,808 1 INFO Avunet13 odoo.addons.base.models.ir_cron: Job `Mail: Fetchmail Service` done.

odoo    | 2020-04-09 12:55:11,193 1 INFO Avunet13 werkzeug: 172.18.0.1 - - [09/Apr/2020 12:55:11] "POST /longpolling/poll HTTP/1.1" 200 - 8 0.002 50.017

odoo    | 2020-04-09 12:56:02,188 1 INFO Avunet13 werkzeug: 172.18.0.1 - - [09/Apr/2020 12:56:02] "POST /longpolling/poll HTTP/1.1" 200 - 8 0.003 50.018


Is there a way to allow more time between the fetch of the incoming mailservers?

Avatar
Discard
Avatar
Paresh Wagh
Best Answer

Hi:

You can control the time between fetch by going to Settings > Technical > Automation > Scheduled Actions and updating the Execute Every field of the Mail: Fetchmail Service scheduled action. You will need to activate developer mode to access this menu.

Avatar
Discard
Avatar
Dax1900
Author Best Answer

The Fetchmail server does all the incoming mailservers at once. I have 5 minutes time between each fetch run which should be enough for a single incoming server. However for 5 incoming mailservers we get the database errors as posted.

Avatar
Discard