Arch Linux User Repository

Already tried, without success. Also tried to upgrade python-mysqlclient and some other related packages to version in testing repositories.

For a while I was thinking of migrating from mariadb to postgresql, so I guess it is time. I hope I will have time to do this over the weekend, and then I will take a look at the python-pillow issue.

Yes, running postgres (and redis). For your error, if your mariadb runs locally maybe consider a PAPERLESS_DBSSLMODE=disable in your paperelss.conf

@AlexBocken Funnily enough I cannot do a paperless database migration in my mariadb setup because of:

django.db.utils.NotSupportedError: MySQL client library does not support ssl_mode specification

Are you using postgres?

@atomicfs Thanks for the info, yes I've already done so for now. A friend of mine has the same issue so I doubt it's something about the peculiarities of my setup.Let me know if I can help you in triage in any way.

@AlexBocken pacman cannot pin versions, it is pacman design decision. So that is not going to work.

However you can prevent package from being upgraded by ignoring it with IgnorePkg=python-pillow in /etc/pacman.conf.

From upstream repository it seems like on master branch they are already using pillow 10.3.0 which was merged 3 weeks ago. Paperless-ngx 2.7.2 was releases 2 weeks ago. So I guess it should work. I will try to reproduce the issue.

Consumer does not work with latest python-pillow 10.3.0. 10.2.0 works fine. Please either investigate for patch or pin version for now to <=10.2.0.

Here's my journalctl -xeu paperless-task-queue.service when it fails consumption:

Apr 24 21:08:02 seenas celery[3457103]: [2024-04-24 21:08:02,424] [INFO] [paperless.consumer] Consuming Raiffeisen_Visa_Debitkarte.pdf
Apr 24 21:08:02 seenas celery[3457103]: [2024-04-24 21:08:02,449] [INFO] [paperless.parsing.tesseract] pdftotext exited 0
Apr 24 21:08:02 seenas celery[3457103]: [2024-04-24 21:08:02,737] [ERROR] [paperless.consumer] Unexpected error while consuming document Raiffeisen_Visa_Debitkarte.pdf: cannot import name 'Coords' from 'PIL._typing' (/usr/lib/python3.11/site-packages/PIL/_typing.py)
Apr 24 21:08:02 seenas celery[3457103]: Traceback (most recent call last):
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/lib/python3.11/site-packages/asgiref/sync.py", line 349, in main_wrap
Apr 24 21:08:02 seenas celery[3457103]:     raise exc_info[1]
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/share/paperless/src/documents/consumer.py", line 612, in try_consume_file
Apr 24 21:08:02 seenas celery[3457103]:     document_parser.parse(self.working_copy, mime_type, self.filename)
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/share/paperless/src/paperless_tesseract/parsers.py", line 351, in parse
Apr 24 21:08:02 seenas celery[3457103]:     import ocrmypdf
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/lib/python3.11/site-packages/ocrmypdf/__init__.py", line 13, in <module>
Apr 24 21:08:02 seenas celery[3457103]:     from ocrmypdf._pipelines._common import (
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/lib/python3.11/site-packages/ocrmypdf/_pipelines/_common.py", line 28, in <module>
Apr 24 21:08:02 seenas celery[3457103]:     from ocrmypdf._pipeline import (
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/lib/python3.11/site-packages/ocrmypdf/_pipeline.py", line 22, in <module>
Apr 24 21:08:02 seenas celery[3457103]:     from PIL import Image, ImageColor, ImageDraw
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/lib/python3.11/site-packages/PIL/ImageDraw.py", line 40, in <module>
Apr 24 21:08:02 seenas celery[3457103]:     from ._typing import Coords
Apr 24 21:08:02 seenas celery[3457103]: ImportError: cannot import name 'Coords' from 'PIL._typing' (/usr/lib/python3.11/site-packages/PIL/_typing.py)
Apr 24 21:08:02 seenas celery[3457103]: [2024-04-24 21:08:02,760] [ERROR] [celery.app.trace] Task documents.tasks.consume_file[0a736d3e-22fa-4210-b6a8-5f1a4dc7137a] raised unexpected: ConsumerError("Raiffeisen_Visa_Debitkarte.pdf: Unexpected error while consuming document Raiffeisen_Visa_Debitkarte.pdf: cannot import name 'Coords' from 'PIL._typing' (/usr/lib/python3.11/site-packages/PIL/_typing.py)")
Apr 24 21:08:02 seenas celery[3457103]: Traceback (most recent call last):
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/lib/python3.11/site-packages/asgiref/sync.py", line 349, in main_wrap
Apr 24 21:08:02 seenas celery[3457103]:     raise exc_info[1]
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/share/paperless/src/documents/consumer.py", line 612, in try_consume_file
Apr 24 21:08:02 seenas celery[3457103]:     document_parser.parse(self.working_copy, mime_type, self.filename)
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/share/paperless/src/paperless_tesseract/parsers.py", line 351, in parse
Apr 24 21:08:02 seenas celery[3457103]:     import ocrmypdf
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/lib/python3.11/site-packages/ocrmypdf/__init__.py", line 13, in <module>
Apr 24 21:08:02 seenas celery[3457103]:     from ocrmypdf._pipelines._common import (
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/lib/python3.11/site-packages/ocrmypdf/_pipelines/_common.py", line 28, in <module>
Apr 24 21:08:02 seenas celery[3457103]:     from ocrmypdf._pipeline import (
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/lib/python3.11/site-packages/ocrmypdf/_pipeline.py", line 22, in <module>
Apr 24 21:08:02 seenas celery[3457103]:     from PIL import Image, ImageColor, ImageDraw
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/lib/python3.11/site-packages/PIL/ImageDraw.py", line 40, in <module>
Apr 24 21:08:02 seenas celery[3457103]:     from ._typing import Coords
Apr 24 21:08:02 seenas celery[3457103]: ImportError: cannot import name 'Coords' from 'PIL._typing' (/usr/lib/python3.11/site-packages/PIL/_typing.py)
Apr 24 21:08:02 seenas celery[3457103]: The above exception was the direct cause of the following exception:
Apr 24 21:08:02 seenas celery[3457103]: Traceback (most recent call last):
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/lib/python3.11/site-packages/celery/app/trace.py", line 477, in trace_task
Apr 24 21:08:02 seenas celery[3457103]:     R = retval = fun(*args, **kwargs)
Apr 24 21:08:02 seenas celery[3457103]:                  ^^^^^^^^^^^^^^^^^^^^
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/lib/python3.11/site-packages/celery/app/trace.py", line 760, in __protected_call__
Apr 24 21:08:02 seenas celery[3457103]:     return self.run(*args, **kwargs)
Apr 24 21:08:02 seenas celery[3457103]:            ^^^^^^^^^^^^^^^^^^^^^^^^^
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/share/paperless/src/documents/tasks.py", line 166, in consume_file
Apr 24 21:08:02 seenas celery[3457103]:     document = Consumer().try_consume_file(
Apr 24 21:08:02 seenas celery[3457103]:                ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/share/paperless/src/documents/consumer.py", line 649, in try_consume_file
Apr 24 21:08:02 seenas celery[3457103]:     self._fail(
Apr 24 21:08:02 seenas celery[3457103]:   File "/usr/share/paperless/src/documents/consumer.py", line 292, in _fail
Apr 24 21:08:02 seenas celery[3457103]:     raise ConsumerError(f"{self.filename}: {log_message or message}") from exception
Apr 24 21:08:02 seenas celery[3457103]: documents.consumer.ConsumerError: Raiffeisen_Visa_Debitkarte.pdf: Unexpected error while consuming document Raiffeisen_Visa_Debitkarte.pdf: cannot import name 'Coords' from 'PIL._typing' (/usr/lib/python3.11/site-packages/PIL/_typing.py)

@amo did I just mess it up by trying to push a commit to master branch?

UPDATE: never-mind I guess, I think AUR had some hiccup and it took unusually long to push.

@amo yeah, sure. I should really fix my RSS aggregator to get notifications about new releases to make this as simple as possible :)

Awesome, @atomicfs ! Would you also be willing to take over my packaged python dependencies for paperless? You can find them by clicking on my user account. Maintaining them is pretty straight-forward. The packages need to be updated every once in a while but it's mostly just adapting the version number and checksum in the PKGBUILD.