1

Database Troubleshooting

HiranChaudhuri edited this page 2026-03-13 08:26:54 +01:00

Table of Contents

• Database Troubleshooting
• SQL Logging

Database Troubleshooting

SQL Logging

If you try to understand what paperless-ngx is doing to your database, one good shot is to turn on SQL logging. With that you will see all the SQL commands paperless sends to the database.

In settings.py find the location where logging is configured. It will look similar to this:

"loggers": {
    "paperless": {"handlers": ["file_paperless"], "level": "DEBUG"},
    "paperless_mail": {"handlers": ["file_mail"], "level": "DEBUG"},
    "ocrmypdf": {"handlers": ["file_paperless"], "level": "INFO"},
    "celery": {"handlers": ["file_celery"], "level": "DEBUG"},
    "kombu": {"handlers": ["file_celery"], "level": "DEBUG"},
    "_granian": {"handlers": ["file_paperless"], "level": "DEBUG"},
    "granian.access": {"handlers": ["file_paperless"], "level": "DEBUG"},
},

Add a line like

"django.db.backends": {"handlers": ["console"], "level": "DEBUG"},

So the whole section would look like this:

"loggers": {
    "paperless": {"handlers": ["file_paperless"], "level": "DEBUG"},
    "paperless_mail": {"handlers": ["file_mail"], "level": "DEBUG"},
    "ocrmypdf": {"handlers": ["file_paperless"], "level": "INFO"},
    "celery": {"handlers": ["file_celery"], "level": "DEBUG"},
    "kombu": {"handlers": ["file_celery"], "level": "DEBUG"},
    "_granian": {"handlers": ["file_paperless"], "level": "DEBUG"},
    "granian.access": {"handlers": ["file_paperless"], "level": "DEBUG"},
    "django.db.backends": {"handlers": ["console"], "level": "DEBUG"},
},

Restart paperless-ngx and watch it's console output.

• Home
• Lists
  • Related Projects
  • Hardware & Software Scanner
• Setup Help
  • Reverse Proxies
  • Security Tools
  • Email OAuth Apps
• Examples
  • Pre Consume Scripts
  • Post Consume Scripts
• Troubleshooting
  • Platform-Specific
  • Database

Feel free to contribute to the wiki pages - enhance and extend the content!

Also browse Discussions & connect in Matrix chat.