Common Odoo Issues & Solutions

Odoo Overview → Troubleshooting

Database issues

Access Denied

# Check PostgreSQL connection
psql -h localhost -U odoo -d odoo_test

Database locked

# Clear locked records
DELETE FROM ir_attachment WHERE datas_fname IS NULL;

Performance issues

Slow search views

Enable proper indexes
Use LIMIT on search
Check [[Performance Tuning]]

Memory issues

# Worker configuration
workers = (CPU_COUNT * 2) + 1

Module installation

Dependency missing

# Check module dependencies
odoo -c odoo.conf -u module_name -d db_name --stop-after-init

XML parsing error

Check view inheritance references
Validate XML syntax
Ensure arch attribute correct

CRM automation issues

Batch read returns empty

Use batches of 5 max (not 20+)
Add active_test=False context flag

Email not sending

Add customer email as mail.followers
Odoo blocks sending if recipient not follower

Links