Logging and monitoring

Reading odoo.log, log levels and handlers, what to monitor, alerting, and analysing errors.

In this lesson

Reading odoo.log
Levels, handlers, rotation and shipping
What to monitor and alert on

Key points

timestamp pid LEVEL db logger: message; HTTP lines with query counts/timings
Find the first error near the reported time
log_handler per logger; rotate; centralise
Monitor uptime, latency, errors, worker kills, crons, mail queue, disk, PG, certs, backups

Real-world example

Customers stopped receiving invoices and nobody noticed for three days. The mail queue had 1,200 messages in exception because the SMTP password expired. A monitor on mail_mail exceptions plus a daily cron check now alerts the support channel within an hour.

Questions and answers

Which table shows failed emails?

mail_mail (state = 'exception').

Name three things to alert on.

Site down, overdue crons, mail exceptions (also disk, backups, certs, error spikes).

Read the full lesson, worked example and quiz