Hi Community,
I’m currently facing a critical issue with **Odoo 16 Enterprise Edition**, which we use as a **warehouse management solution** for stock and order synchronization across multiple third-party marketplaces.
For the past **three months**, Odoo has been consuming excessive memory, eventually leading to **Out of Memory (OOM) crashes** on our VM. Initially, this occurred once every **two to three weeks**, but now it happens **3–5 times per day**, severely disrupting operations.
### **Issue Details**
- **Symptoms:** Odoo's memory usage keeps increasing until the VM crashes due to OOM. Even after rebooting, the memory gradually climbs again until it crashes.
- **Current Workaround:** We set up an **Uptime Check on GCP**, which detects when the Odoo web service becomes unreachable and automatically restarts the VM.
- **Users:** Internal use only, with **60–75 concurrent users** at max.
- **Initial Suspicions:** I suspected that the **scheduled queue jobs** syncing to marketplaces every **10 minutes** were causing the issue. However, even when there’s low order activity, Odoo still crashes.
- **Scaling Attempt:** Upgraded the instance from **38GB RAM** to **50GB RAM**, but the issue persists with the same pattern.
### **Environment Details**
#### **Compute Engine (GCP)**
- **Original Spec:** N2 – **24 vCPUs, 38GB RAM**
- **Current Spec:** N2 – **24 vCPUs, 50GB RAM**
#### **CloudSQL (PostgreSQL for Odoo Database)**
- **PostgreSQL 14** – **40 vCPUs, 75GB RAM**
#### **Odoo Configuration (50GB RAM)**
```SCHEME
; === 18 Workers Config for 50GB RAM ===
workers = 18
max_cron_threads = 4
limit_memory_soft = 38654705664 ; 36GB (2048 MB × 18)
limit_memory_hard = 48318382080 ; 45GB (2560 MB × 18)
limit_request = 4096
limit_time_cpu = 3000
limit_time_real = 6000
```
### Questions
1. **What could be causing Odoo to keep consuming memory until it crashes?**
2. **How can I effectively debug and monitor which process or worker is using excessive memory?**
3. **Has anyone experienced similar OOM issues with Odoo, and what solutions worked for you?**
Any insights or recommendations would be greatly appreciated. Thanks!
If you're Indonesian, I suggest you to join a Telegram group named "Odoo - OpenERP Indonesia". There you can get a lot of helps and assistances from well-known Odoo contributors from Indonesia, like Akhmad Daniel Sembiring, Nendi Apriandy, and Jalaluddin, S.Kom, M.Kom.