Technical Arsip milis


Troubleshooting loading/locking issue

- 25/03/2019 18:09:27
Howdy all.

I've been tracking down a loading / performance issue for weeks and am baffled. I can't seem to narrow it down. 

Odoo 11.

In this file, addons/web/static/src/js/core/misc.js , bolded messages are getting shown to the user (in a popup):

var messages_by_seconds = function() {
    return [
        [0, _t("Loading...")],
        [20, _t("Still loading...")],
        [60, _t("Still loading...<br />Please be patient.")],
        [120, _t("Don't leave yet,<br />it's still loading...")],
        [300, _t("You may not believe it,<br />but the application is actually loading...")],
        [420, _t("Take a minute to get a coffee,<br />because it's loading...")],
        [3600, _t("Maybe you should consider reloading the application by pressing F5...")]

This happened about 6 times this morning (which is the most we've seen in a while). Usually it's once a week or a few times a week... been happening for months. I've tried various solutions I thought might resolve it. No luck.

A few possible culprits based off comparing dozens of timestamps...

This odoo.modules.loading always happens around this time:

2019-03-25 13:41:03,420 29502 INFO db odoo.modules.loading: loading 1 modules...
2019-03-25 13:41:04,472 29502 INFO db odoo.modules.loading: 1 modules loaded in 1.02s, 0 queries
2019-03-25 13:41:05,429 29502 INFO db odoo.modules.loading: loading 48 modules...
2019-03-25 13:41:07,933 29502 INFO db odoo.modules.loading: 48 modules loaded in 2.46s, 0 queries
2019-03-25 13:41:12,536 29502 INFO db odoo.modules.loading: Modules loaded.

I can't tell if this is supposed to be happening or if Odoo is reloading because it crashed?

Email is always getting processed during locking (1 to many emails).

IMAP from Gmail, specifically. We do a bit of custom e-mail handling and I've removed / cleaned up / combed over the code a few times and can't find any issues that might be causing this there. Per the timestamps, everything there seems to be processing fine with no long gaps (I've added more verbosity here, too).

The database is growing. ~2.5GB.

# SELECT pg_size_pretty( pg_database_size('db') );
 2467 MB
(1 row)

We have it at AWS.
I have log_min_duration_statement = 3000 (previously 5000). Although it takes longer than this (per the error messages), no slow queries getting logged so I don't think this is it. 

It's possible there is some postgres locking issue but I think I'd see a slow query if that was the case.

A RAM issue? We have 1GB with 2GB swap.

# free -m
              total        used        free      shared  buff/cache   available
Mem:            996         654          92         133         249          80
Swap:          2011         630        1381

Odoo config issue?

workers = 3
max_cron_threads = 1
proxy_mode = True
longpolling_port = 8072
limit_time_cpu = 3600
limit_time_real = 3600

Does anyone have any pointers or ideas on what is causing this or things to try? Or further questions? We can increase RAM at AWS. I'm wondering if there is something else I can be doing to troubleshoot, too, if there is nothing obvious that jumps out.

Grateful for any time in helping to resolve this, thank you! 

Tindak lanjut