we are using Mayan EDMS for quite some time now.
Our version is 4.0.15 which was upgraded from 3.x a while ago.
Just recently we notice that some documents cannot be opened.
Logs show irritating messages
Code: Select all
django.http.response.Http404: No Document found matching the query mayan.apps.logging.middleware.error_logging <6825> [ERROR] "process_exception() line 17 Exception caught by request middleware; <WSGIRequest: GET '/documents/documents/22672/preview/'>, No Document found matching the query" Traceback (most recent call last): File "/opt/mayan-edms/lib/python3.7/site-packages/django/views/generic/detail.py", line 52, in get_object obj = queryset.get() File "/opt/mayan-edms/lib/python3.7/site-packages/django/db/models/query.py", line 408, in get self.model._meta.object_name mayan.apps.documents.models.document_models.Document.DoesNotExist: Document matching query does not exist.
Searching the file system for that UUID, I can find preview images in "document_file_page_image_cache" but not the actual file itself.
What could possibly go wrong here?
Please help getting file UUID with psql in a docker-compose installation.
Somehow I cannot run a SQL query to get the file UUID to perform other searches.
Something like "select UUID from public.documents_document where id=22672".
This will allow me to search for the missing file in the file system. The error messages are unfortunately not very clear about which exact file was not found.
This problem affects multiple files and I have no idea what happend.
The backup of the system, 35 days ago, does not find the file either (this time everything was still running mayan edms 3.xx).
I don't think this is a problem caused by the update.
Thanks for your help and hints!