Help with Tandoor Error when editing recipies #3210

Mad-at · 2024-07-09T10:53:58Z

Mad-at
Jul 9, 2024

Hi everybody!
I am a long time fan & user of Tandoor, but after the migration to postgres 16 everything went downwards. Maybe someone is willing to guide me through solving my problem: I can't edit recpies anymore, I get a quite general "Beim Aktualisieren einer Ressource ist ein Fehler aufgetreten!" - "An error occurred while updating a resource!".
This is happening on Tandoor v1.5.17.
The System panel in Tandoor says that everything is alright and all subsystems/connections work nominally.

Background:
I initially used this guide: https://github.com/vabene1111/recipes/files/6901601/Tandoor.on.a.Synology.Disk.Station.pdf to (years ago) install everything on my Synology using the Container manager. Then I had to migrate from Postgres 11 to Postgres 16 which took sime fumbling but I finally managed to get all data accross. Everything seemed to work fine, but editing seems to be a problem.
I found some Error discussions for synology but they all refer to deleting the user from the docker compose, which the Synology Container Manager" doesnt have (at least did not have when I did the initial install, so I can't use this for the current install).
Permissions on disc are read/write for everyone with exception of the database folder - but there access would be managed by the database backend, right?

There are discussions about installations where permissions seem to be a problem, but as far as I can tell, this should create a permissions error (see: https://forum.yunohost.org/t/permission-broken-after-tandoor-app-update-cant-edit-recipes-anymore/28308 and https://www.synology-forum.de/threads/tandoor-rezepte-lassen-sich-nicht-mehr-veraendern.130667/)

Thanks for reading through this!

Mad

smilerz · 2024-07-09T13:11:06Z

smilerz
Jul 9, 2024
Collaborator

please share the tandoor log as well as any console error messages.

0 replies

Mad-at · 2024-07-10T09:23:53Z

Mad-at
Jul 10, 2024
Author

Thanks!
There are no erromessages, this is the console log:


date	stream	content
08.07.2024 21:44	stdout	DEPRECATION WARNING: Environment var "TIMEZONE" is deprecated. Please use "TZ" instead.
		
08.07.2024 21:44	stdout	DEPRECATION WARNING: Environment var "REVERSE_PROXY_AUTH" is deprecated. Please use "REMOTE_USER_AUTH".
		
08.07.2024 21:44	stdout	DEPRECATION WARNING: Environment var "TIMEZONE" is deprecated. Please use "TZ" instead.
		
08.07.2024 21:44	stdout	DEPRECATION WARNING: Environment var "REVERSE_PROXY_AUTH" is deprecated. Please use "REMOTE_USER_AUTH".
		
08.07.2024 21:44	stdout	DEPRECATION WARNING: Environment var "TIMEZONE" is deprecated. Please use "TZ" instead.
		
08.07.2024 21:44	stdout	DEPRECATION WARNING: Environment var "REVERSE_PROXY_AUTH" is deprecated. Please use "REMOTE_USER_AUTH".
		
08.07.2024 21:44	stdout	[2024-07-08 19:44:46 +0000] [18] [INFO] Booting worker with pid: 18
		
08.07.2024 21:44	stdout	[2024-07-08 19:44:46 +0000] [17] [INFO] Booting worker with pid: 17
		
08.07.2024 21:44	stdout	[2024-07-08 19:44:46 +0000] [16] [INFO] Booting worker with pid: 16
		
08.07.2024 21:44	stdout	[2024-07-08 19:44:46 +0000] [1] [INFO] Using worker: gthread
		
08.07.2024 21:44	stdout	[2024-07-08 19:44:46 +0000] [1] [INFO] Listening at: http://[::]:8080 (1)
		
08.07.2024 21:44	stdout	[2024-07-08 19:44:46 +0000] [1] [INFO] Starting gunicorn 22.0.0
		
08.07.2024 21:44	stdout	Done
		
08.07.2024 21:44	stdout	"576 static files copied to '/opt/recipes/staticfiles', 1186 post-processed.
"
08.07.2024 21:44	stdout	
		
08.07.2024 21:44	stdout	DEPRECATION WARNING: Environment var "TIMEZONE" is deprecated. Please use "TZ" instead.
		
08.07.2024 21:44	stdout	DEPRECATION WARNING: Environment var "REVERSE_PROXY_AUTH" is deprecated. Please use "REMOTE_USER_AUTH".
		
08.07.2024 21:44	stdout	js-reverse file written to /opt/recipes/cookbook/static/django_js_reverse
		
08.07.2024 21:44	stdout	DEPRECATION WARNING: Environment var "TIMEZONE" is deprecated. Please use "TZ" instead.
		
08.07.2024 21:44	stdout	DEPRECATION WARNING: Environment var "REVERSE_PROXY_AUTH" is deprecated. Please use "REMOTE_USER_AUTH".
		
08.07.2024 21:44	stdout	"Collecting static files, this may take a while...
"
08.07.2024 21:44	stdout	  Applying cookbook.0218_alter_mealplan_from_date_alter_mealplan_to_date...�[32;1m OK�[0m
		
08.07.2024 21:44	stdout	  Applying authtoken.0004_alter_tokenproxy_options...�[32;1m OK�[0m
		
08.07.2024 21:44	stdout	�[36;1mRunning migrations:�[0m
		
08.07.2024 21:44	stdout	"�[1m  Apply all migrations: �[0maccount, admin, auth, authtoken, contenttypes, cookbook, oauth2_provider, sessions, sites, socialaccount
"
08.07.2024 21:44	stdout	�[36;1mOperations to perform:�[0m
		
08.07.2024 21:44	stdout	DEPRECATION WARNING: Environment var "TIMEZONE" is deprecated. Please use "TZ" instead.
		
08.07.2024 21:44	stdout	DEPRECATION WARNING: Environment var "REVERSE_PROXY_AUTH" is deprecated. Please use "REMOTE_USER_AUTH".
		
08.07.2024 21:44	stdout	Migrating database
		
08.07.2024 21:44	stdout	Database is ready
		
08.07.2024 21:44	stdout	Waiting for database to be ready...
		
08.07.2024 21:44	stdout	Checking configuration...

As for the tandoor logs, I am not sure what you mean - the debug output?

Gunicorn Media: False
Sqlite:  Falsch 
        PostgreSQL: 16 
        Debug: False

SERVER_PROTOCOL:HTTP/1.0
REMOTE_ADDR:::ffff:172.18.0.2
SERVER_PORT:8080

HTTP_HOST:X.X.X.X:xxxx
HTTP_CONNECTION:close
HTTP_USER_AGENT:Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:126.0) Gecko/20100101 Firefox/126.0
HTTP_ACCEPT:text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,*/*;q=0.8
HTTP_ACCEPT_LANGUAGE:de,en-US;q=0.7,en;q=0.3
HTTP_ACCEPT_ENCODING:gzip, deflate
HTTP_REFERER:http://X.X.X.X:xxx/search/
HTTP_COOKIE:io=qUl6KkAxo9VlPWH_AAAB; PHPSESSID=2c8f9c989f81972fd759fbd4bae2109d; _SSID=5j-gDpI6PCLIasGbyb9PJuJAkxU8MG81MfQD3LT_0mU; stay_login=0; did=5H41DFiijxVTFf2yEke8L9ngnXbCtXtPWezjMVBdUGO-j3Zvr9n1MZIFjJovzsSJFDKI1xQHPsiO3pnHxP-hMQ; _CrPoSt=cHJvdG9jb2w9aHR0cHM6OyBwb3J0PTE5NjQ1OyBwYXRobmFtZT0vOw%3D%3D; csrftoken=Okjj5iIHDhYlrtC8k6gEkz4CZWyn0yE1; sessionid=j5lhhmqf8j9cb2t36gyiidp8itij0hb8
HTTP_UPGRADE_INSECURE_REQUESTS:1
HTTP_PRIORITY:u=1

wsgi.errors:<gunicorn.http.wsgi.WSGIErrorsWrapper object at 0x7f08ca64c550>
wsgi.version:(1, 0)
wsgi.multithread:True
wsgi.multiprocess:True
wsgi.run_once:False
wsgi.file_wrapper:
wsgi.input_terminated:True
wsgi.input:<gunicorn.http.body.Body object at 0x7f08ca64ebd0>
wsgi.url_scheme:http

Edit:
When trying to create a recipe I get an error message after switching on Debug=1

Environment:



Request Method: POST
Request URL: http://X.X.X.X:xxxx/new/recipe/

Django Version: 4.2.11
Python Version: 3.12.4
Installed Applications:
['django.contrib.admin',
 'django.contrib.auth',
 'django.contrib.contenttypes',
 'django.contrib.sessions',
 'django.contrib.messages',
 'django.contrib.sites',
 'django.contrib.staticfiles',
 'django.contrib.postgres',
 'oauth2_provider',
 'django_tables2',
 'corsheaders',
 'crispy_forms',
 'crispy_bootstrap4',
 'rest_framework',
 'rest_framework.authtoken',
 'django_cleanup.apps.CleanupConfig',
 'webpack_loader',
 'django_js_reverse',
 'hcaptcha',
 'allauth',
 'allauth.account',
 'allauth.socialaccount',
 'cookbook.apps.CookbookConfig',
 'treebeard',
 'debug_toolbar']
Installed Middleware:
['corsheaders.middleware.CorsMiddleware',
 'django.middleware.security.SecurityMiddleware',
 'whitenoise.middleware.WhiteNoiseMiddleware',
 'django.contrib.sessions.middleware.SessionMiddleware',
 'django.middleware.common.CommonMiddleware',
 'django.middleware.csrf.CsrfViewMiddleware',
 'django.contrib.auth.middleware.AuthenticationMiddleware',
 'django.contrib.messages.middleware.MessageMiddleware',
 'django.middleware.locale.LocaleMiddleware',
 'django.middleware.clickjacking.XFrameOptionsMiddleware',
 'cookbook.helper.scope_middleware.ScopeMiddleware',
 'allauth.account.middleware.AccountMiddleware',
 'debug_toolbar.middleware.DebugToolbarMiddleware']



Traceback (most recent call last):
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

The above exception (function unaccent(character varying) does not exist
LINE 1: ...tweight(to_tsvector('german'::regconfig, COALESCE(UNACCENT("...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
) was the direct cause of the following exception:
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/core/handlers/exception.py", line 55, in inner
    response = get_response(request)
               ^^^^^^^^^^^^^^^^^^^^^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/core/handlers/base.py", line 197, in _get_response
    response = wrapped_callback(request, *callback_args, **callback_kwargs)
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/views/generic/base.py", line 104, in view
    return self.dispatch(request, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/recipes/cookbook/helper/permission_helper.py", line 179, in dispatch
    return super(GroupRequiredMixin, self).dispatch(request, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/views/generic/base.py", line 143, in dispatch
    return handler(request, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/views/generic/edit.py", line 184, in post
    return super().post(request, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/views/generic/edit.py", line 153, in post
    return self.form_valid(form)
           ^^^^^^^^^^^^^^^^^^^^^
  File "/opt/recipes/cookbook/views/new.py", line 30, in form_valid
    obj.save()
    ^^^^^^^^^^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/db/models/base.py", line 814, in save
    self.save_base(
    ^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/db/models/base.py", line 892, in save_base
    post_save.send(
    ^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/dispatch/dispatcher.py", line 177, in send
    (receiver, receiver(signal=self, sender=sender, **named))
               ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/recipes/cookbook/signals.py", line 31, in _decorator
    return signal_func(sender, instance, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/recipes/cookbook/signals.py", line 63, in update_recipe_search_vector
    instance.save()
    ^^^^^^^^^^^^^^^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/db/models/base.py", line 814, in save
    self.save_base(
    ^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/db/models/base.py", line 877, in save_base
    updated = self._save_table(
              
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/db/models/base.py", line 990, in _save_table
    updated = self._do_update(
              
  File "/opt/recipes/venv/lib/python3.12/site-packages/django_prometheus/models.py", line 47, in _do_update
    return super()._do_update(*args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/db/models/base.py", line 1054, in _do_update
    return filtered._update(values) > 0
           ^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/db/models/query.py", line 1231, in _update
    return query.get_compiler(self.db).execute_sql(CURSOR)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/db/models/sql/compiler.py", line 1984, in execute_sql
    cursor = super().execute_sql(result_type)
             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/db/models/sql/compiler.py", line 1562, in execute_sql
    cursor.execute(sql, params)
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/db/backends/utils.py", line 102, in execute
    return super().execute(sql, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/db/backends/utils.py", line 67, in execute
    return self._execute_with_wrappers(
           
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/db/backends/utils.py", line 80, in _execute_with_wrappers
    return executor(sql, params, many, context)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/db/backends/utils.py", line 84, in _execute
    with self.db.wrap_database_errors:
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/db/utils.py", line 91, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
    ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/opt/recipes/venv/lib/python3.12/site-packages/django/db/backends/utils.py", line 89, in _execute
    return self.cursor.execute(sql, params)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Exception Type: ProgrammingError at /new/recipe/
Exception Value: function unaccent(character varying) does not exist
LINE 1: ...tweight(to_tsvector('german'::regconfig, COALESCE(UNACCENT("...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

0 replies

smilerz · 2024-07-10T13:16:05Z

smilerz
Jul 10, 2024
Collaborator

Complete step 8:
https://docs.tandoor.dev/system/updating/#postgresql

0 replies

Mad-at · 2024-07-11T08:59:48Z

Mad-at
Jul 11, 2024
Author

Thanks! I did that, and restarted the database and the Tandoor container, but the problem prevails. Checking the db conatiner, it lists unaccent as extension

9 replies

smilerz Jul 11, 2024
Collaborator

can you use a blank db and see if you have the same issue

Mad-at Jul 14, 2024
Author

I am not sure how to do that without loosing my database, during the last days I tried the following: I did a copy of all the docker container configurations and reconfigured the containers to work on a new directory structure. But it does not work, I get a "relation "django_session" does not exist" Error.
Sorry I really am trying, but I am a little out of my depth here, especially as the Synology docker manager adds another layer of abstraction that doens't let me use the CLI examples that I find.

Edit: I deleted all persistance/static files on disk and started the conatainers anew. This time database initialization worked. Now I have a working system with a cleared database where I can create recipes. Export from the previous system worked, import to the new system worked as well. Editing recipes still works after that. So basically I have a working system now but no explanation what went wrong in the first place.

Thanks for your help!

smilerz Jul 14, 2024
Collaborator

Just change the db name to something else or create a new postgres container and point it at that.

Mad-at Jul 16, 2024
Author

With an empty db the old docker works as well.

smilerz Jul 16, 2024
Collaborator

Ok - we can confirm that the issue is the db.

You can try removing the extension and reinstalling it to see if that has any impact. Or try over with a new DB and restore the old dump or redo the dump/restore.

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Help with Tandoor Error when editing recipies #3210

{{title}}

Replies: 4 comments 9 replies

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

{{title}}

{{editor}}'s edit

{{editor}}'s edit

{{title}}

{{title}}

{{title}}

Select a reply

Help with Tandoor Error when editing recipies #3210

Mad-at Jul 9, 2024

Replies: 4 comments · 9 replies

smilerz Jul 9, 2024 Collaborator

Mad-at Jul 10, 2024 Author

smilerz Jul 10, 2024 Collaborator

Mad-at Jul 11, 2024 Author

smilerz Jul 11, 2024 Collaborator

Mad-at Jul 14, 2024 Author

smilerz Jul 14, 2024 Collaborator

Mad-at Jul 16, 2024 Author

smilerz Jul 16, 2024 Collaborator

Mad-at
Jul 9, 2024

Replies: 4 comments 9 replies

smilerz
Jul 9, 2024
Collaborator

Mad-at
Jul 10, 2024
Author

smilerz
Jul 10, 2024
Collaborator

Mad-at
Jul 11, 2024
Author

smilerz Jul 11, 2024
Collaborator

Mad-at Jul 14, 2024
Author

smilerz Jul 14, 2024
Collaborator

Mad-at Jul 16, 2024
Author

smilerz Jul 16, 2024
Collaborator