Problems - "Table not found."

hanneskeller · January 2, 2025, 9:21am

Good morning together,
since the update to I got the sometimes this massage:

# Table not found.

Die Seite, die Sie suchen, wurde nicht gefunden. Dies könnte daran liegen, dass die URL nicht korrekt ist oder dass Sie keine Berechtigung haben, diese Seite anzuzeigen.

what can I di to avoid this?
Thanks for your help.
Hannes

Details:
Self-Hosted - Version on an Synology 923+ with ssd Cache and 32 GB Ram
Portainer Configuration: (For Security reason some Sencetiv data etc. are replaced with *)

version: "3.9"
services:
  redis:
    image: redis
    command:
      - /bin/sh
      - -c
      - redis-server --requirepass redispass
    container_name: Baserow-REDIS
    hostname: baserow-redis
    mem_limit: 512m
    mem_reservation: 50m
    cpu_shares: 768
    security_opt:
      - no-new-privileges:true
    read_only: true
    user: 1026:100
    healthcheck:
      test: ["CMD-SHELL", "redis-cli ping || exit 1"]
    volumes:
      - /volume*/AK_baserow/redis:/data:rw
    environment:
      TZ: Europe/Berlin
    restart: on-failure:5

  db:
    image: postgres:16
    container_name: Baserow-DB
    hostname: baserow-db
    mem_limit: 1024m
    cpu_shares: 768
    security_opt:
      - no-new-privileges:true
    healthcheck:
      test: ["CMD", "pg_isready", "-q", "-d", "baserow", "-U", "baserowuser"]
      timeout: 45s
      interval: 10s
      retries: 10
    volumes:
      - /volume*/AK_baserow/db:/var/lib/postgresql/data:rw
    environment:
      POSTGRES_DB: baserow
      POSTGRES_USER: baserowuser
      POSTGRES_PASSWORD: ****
    restart: on-failure:5
    ports:
      - 2665:5432
  baserow:
    image: baserow/baserow:1.30.0
    container_name: Baserow
    hostname: baserow
    mem_limit: 7g
    read_only: true
    cpu_shares: 768

    security_opt:
      - no-new-privileges:true
    ports:
      - 3888:80
    volumes:
      - /volume*/AK_baserow/data:/baserow/data:rw
    environment:
      BASEROW_PUBLIC_URL: https://****
      BASEROW_MAX_IMPORT_FILE_SIZE_MB: 10000 
      DATABASE_USER: baserowuser
      DATABASE_PASSWORD: ****
      DATABASE_NAME: baserow
      DATABASE_HOST: ****
      DATABASE_PORT: 5432
      REDIS_HOST: baserow-redis
      REDIS_PORT: 6379
      REDIS_PROTOCOL: redis
      REDIS_USER: default
      REDIS_PASSWORD: redispass
      EMAIL_SMTP: info@agentur-keller.com
      EMAIL_SMTP_HOST: ****
      EMAIL_SMTP_PORT: 465
      EMAIL_SMTP_USER: ****
      EMAIL_SMTP_PASSWORD:****
      EMAIL_SMTP_USE_SSL: true
      FROM_EMAIL: ****
    restart: on-failure:5
    depends_on:
      redis:
        condition: service_healthy
      db:
        condition: service_healthy

cezary · January 3, 2025, 8:20am

Hi!

Could you show backend logs from your deployment?

hanneskeller · January 3, 2025, 10:44am

Thanks for your answer.
Here is the Log while this error happened. Meanwhile I moved all the folders to another Volume. But this happened again around 11:35 and 11:19

 [BACKEND][2025-01-03 10:42:32]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/query.py", line 1772, in names_to_path  
 [BACKEND][2025-01-03 10:42:32]     raise FieldError(  
 [BACKEND][2025-01-03 10:42:32] django.core.exceptions.FieldError: Cannot resolve keyword 'profile' into field. Choices are: action, auth_providers, date_joined, email, exportjob, first_name, formview, groups, id, importexportresource, is_active, is_staff, is_superuser, job, last_login, last_name, licenseuser, localbaserowintegration, localbaserowtabledatasync, notificationrecipient, notifications, password, private_trash_entries, profile, row_comment_mentions, rowcomment, rowcommentsnotificationmode, sent_notifications, snapshot, token, trashentry, user_permissions, userfile, userlogentry, username, view, workspace, workspaceinvitation, workspaceuser  
 [BACKEND][2025-01-03 10:42:33] 127.0.0.1:33816 - "POST /api/user/token-refresh/ HTTP/1.1" 500  
 [BACKEND][2025-01-03 10:42:33] 127.0.0.1:33838 - "GET /api/_health/ HTTP/1.1" 200  
 [BACKEND][2025-01-03 10:42:33] 127.0.0.1:33816 - "GET /api/settings/ HTTP/1.1" 200  
 [BACKEND][2025-01-03 10:42:36] 127.0.0.1:33816 - "GET /api/auth-provider/login-options/ HTTP/1.1" 200  
 [BACKEND][2025-01-03 10:42:36] 192.168.80.1:0 - "POST /api/user/token-auth/ HTTP/1.1" 200  
 [BACKEND][2025-01-03 10:42:36] 192.168.80.1:0 - "GET /api/workspaces/ HTTP/1.1" 200  
 [BACKEND][2025-01-03 10:42:36] 192.168.80.1:0 - "GET /api/workspaces/20/permissions/ HTTP/1.1" 200  
 [BACKEND][2025-01-03 10:42:36] 192.168.80.1:0 - "GET /api/applications/ HTTP/1.1" 200  
 [BACKEND][2025-01-03 10:42:37] 192.168.80.1:0 - "GET /api/jobs/?states=%21finished%2C%21failed%2C%21cancelled HTTP/1.1" 200  
 [BACKEND][2025-01-03 10:42:37] 192.168.80.1:0 - "GET /api/database/views/table/1149/?include=filters,sortings,group_bys,decorations HTTP/1.1" 200  
 [BACKEND][2025-01-03 10:42:37] 192.168.80.1:0 - "GET /api/database/fields/table/1149/ HTTP/1.1" 200  
 [BACKEND][2025-01-03 10:42:37] 192.168.80.1:0 - "GET /api/database/views/grid/4511/?limit=80&offset=0&include=field_options%2Crow_metadata HTTP/1.1" 200  
 [BACKEND][2025-01-03 10:42:37] [2025-01-03 10:42:37 +0000] [305] [ERROR] Exception in ASGI application  
 [BACKEND][2025-01-03 10:42:37] Traceback (most recent call last):  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/uvicorn/protocols/websockets/websockets_impl.py", line 240, in run_asgi  
 [BACKEND][2025-01-03 10:42:37]     result = await self.app(self.scope, self.asgi_receive, self.asgi_send)  
 [BACKEND][2025-01-03 10:42:37]              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/uvicorn/middleware/proxy_headers.py", line 69, in __call__  
 [BACKEND][2025-01-03 10:42:37]     return await self.app(scope, receive, send)  
 [BACKEND][2025-01-03 10:42:37]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/channels/routing.py", line 62, in __call__  
 [BACKEND][2025-01-03 10:42:37]     return await application(scope, receive, send)  
 [BACKEND][2025-01-03 10:42:37]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/backend/src/baserow/ws/auth.py", line 62, in __call__  
 [BACKEND][2025-01-03 10:42:37]     scope["user"] = await get_user(jwt_token[0])  
 [BACKEND][2025-01-03 10:42:37]                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/asgiref/sync.py", line 468, in __call__  
 [BACKEND][2025-01-03 10:42:37]     ret = await asyncio.shield(exec_coro)  
 [BACKEND][2025-01-03 10:42:37]           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/usr/lib/python3.11/concurrent/futures/thread.py", line 58, in run  
 [BACKEND][2025-01-03 10:42:37]     result = self.fn(*self.args, **self.kwargs)  
 [BACKEND][2025-01-03 10:42:37]              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/channels/db.py", line 13, in thread_handler  
 [BACKEND][2025-01-03 10:42:37]     return super().thread_handler(loop, *args, **kwargs)  
 [BACKEND][2025-01-03 10:42:37]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/asgiref/sync.py", line 522, in thread_handler  
 [BACKEND][2025-01-03 10:42:37]     return func(*args, **kwargs)  
 [BACKEND][2025-01-03 10:42:37]            ^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/backend/src/baserow/ws/auth.py", line 39, in get_user  
 [BACKEND][2025-01-03 10:42:37]     return get_user_from_token(token)  
 [BACKEND][2025-01-03 10:42:37]            ^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/backend/src/baserow/api/user/jwt.py", line 46, in get_user_from_token  
 [BACKEND][2025-01-03 10:42:37]     user = UserHandler().get_active_user(  
 [BACKEND][2025-01-03 10:42:37]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/backend/src/baserow/core/telemetry/utils.py", line 72, in _wrapper  
 [BACKEND][2025-01-03 10:42:37]     raise ex  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/backend/src/baserow/core/telemetry/utils.py", line 68, in _wrapper  
 [BACKEND][2025-01-03 10:42:37]     result = wrapped_func(*args, **kwargs)  
 [BACKEND][2025-01-03 10:42:37]              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/backend/src/baserow/core/user/handler.py", line 109, in get_active_user  
 [BACKEND][2025-01-03 10:42:37]     query = query.filter(profile__to_be_deleted=False)  
 [BACKEND][2025-01-03 10:42:37]             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/query.py", line 1476, in filter  
 [BACKEND][2025-01-03 10:42:37]     return self._filter_or_exclude(False, args, kwargs)  
 [BACKEND][2025-01-03 10:42:37]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/query.py", line 1494, in _filter_or_exclude  
 [BACKEND][2025-01-03 10:42:37]     clone._filter_or_exclude_inplace(negate, args, kwargs)  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/query.py", line 1501, in _filter_or_exclude_inplace  
 [BACKEND][2025-01-03 10:42:37]     self._query.add_q(Q(*args, **kwargs))  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/query.py", line 1613, in add_q  
 [BACKEND][2025-01-03 10:42:37]     clause, _ = self._add_q(q_object, self.used_aliases)  
 [BACKEND][2025-01-03 10:42:37]                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/query.py", line 1645, in _add_q  
 [BACKEND][2025-01-03 10:42:37]     child_clause, needed_inner = self.build_filter(  
 [BACKEND][2025-01-03 10:42:37]                                  ^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/query.py", line 1495, in build_filter  
 [BACKEND][2025-01-03 10:42:37]     lookups, parts, reffed_expression = self.solve_lookup_type(arg, summarize)  
 [BACKEND][2025-01-03 10:42:37]                                         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/query.py", line 1307, in solve_lookup_type  
 [BACKEND][2025-01-03 10:42:37]     _, field, _, lookup_parts = self.names_to_path(lookup_splitted, self.get_meta())  
 [BACKEND][2025-01-03 10:42:37]                                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/query.py", line 1772, in names_to_path  
 [BACKEND][2025-01-03 10:42:37]     raise FieldError(  
 [BACKEND][2025-01-03 10:42:37] django.core.exceptions.FieldError: Cannot resolve keyword 'profile' into field. Choices are: action, auth_providers, date_joined, email, exportjob, first_name, formview, groups, id, importexportresource, is_active, is_staff, is_superuser, job, last_login, last_name, licenseuser, localbaserowintegration, localbaserowtabledatasync, notificationrecipient, notifications, password, private_trash_entries, profile, row_comment_mentions, rowcomment, rowcommentsnotificationmode, sent_notifications, snapshot, token, trashentry, user_permissions, userfile, userlogentry, username, view, workspace, workspaceinvitation, workspaceuser  
 [BACKEND][2025-01-03 10:42:37] [2025-01-03 10:42:37 +0000] [305] [INFO] connection open  
 [BACKEND][2025-01-03 10:42:37] [2025-01-03 10:42:37 +0000] [305] [INFO] connection closed  
 [BACKEND][2025-01-03 10:42:37] [2025-01-03 10:42:37 +0000] [305] [ERROR] Exception in ASGI application  
 [BACKEND][2025-01-03 10:42:37] Traceback (most recent call last):  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/uvicorn/protocols/websockets/websockets_impl.py", line 240, in run_asgi  
 [BACKEND][2025-01-03 10:42:37]     result = await self.app(self.scope, self.asgi_receive, self.asgi_send)  
 [BACKEND][2025-01-03 10:42:37]              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/uvicorn/middleware/proxy_headers.py", line 69, in __call__  
 [BACKEND][2025-01-03 10:42:37]     return await self.app(scope, receive, send)  
 [BACKEND][2025-01-03 10:42:37]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/channels/routing.py", line 62, in __call__  
 [BACKEND][2025-01-03 10:42:37]     return await application(scope, receive, send)  
 [BACKEND][2025-01-03 10:42:37]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/backend/src/baserow/ws/auth.py", line 62, in __call__  
 [BACKEND][2025-01-03 10:42:37]     scope["user"] = await get_user(jwt_token[0])  
 [BACKEND][2025-01-03 10:42:37]                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/asgiref/sync.py", line 468, in __call__  
 [BACKEND][2025-01-03 10:42:37]     ret = await asyncio.shield(exec_coro)  
 [BACKEND][2025-01-03 10:42:37]           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/usr/lib/python3.11/concurrent/futures/thread.py", line 58, in run  
 [BACKEND][2025-01-03 10:42:37]     result = self.fn(*self.args, **self.kwargs)  
 [BACKEND][2025-01-03 10:42:37]              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/channels/db.py", line 13, in thread_handler  
 [BACKEND][2025-01-03 10:42:37]     return super().thread_handler(loop, *args, **kwargs)  
 [BACKEND][2025-01-03 10:42:37]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/asgiref/sync.py", line 522, in thread_handler  
 [BACKEND][2025-01-03 10:42:37]     return func(*args, **kwargs)  
 [BACKEND][2025-01-03 10:42:37]            ^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/backend/src/baserow/ws/auth.py", line 39, in get_user  
 [BACKEND][2025-01-03 10:42:37]     return get_user_from_token(token)  
 [BACKEND][2025-01-03 10:42:37]            ^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/backend/src/baserow/api/user/jwt.py", line 46, in get_user_from_token  
 [BACKEND][2025-01-03 10:42:37]     user = UserHandler().get_active_user(  
 [BACKEND][2025-01-03 10:42:37]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/backend/src/baserow/core/telemetry/utils.py", line 72, in _wrapper  
 [BACKEND][2025-01-03 10:42:37]     raise ex  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/backend/src/baserow/core/telemetry/utils.py", line 68, in _wrapper  
 [BACKEND][2025-01-03 10:42:37]     result = wrapped_func(*args, **kwargs)  
 [BACKEND][2025-01-03 10:42:37]              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/backend/src/baserow/core/user/handler.py", line 109, in get_active_user  
 [BACKEND][2025-01-03 10:42:37]     query = query.filter(profile__to_be_deleted=False)  
 [BACKEND][2025-01-03 10:42:37]             ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/query.py", line 1476, in filter  
 [BACKEND][2025-01-03 10:42:37]     return self._filter_or_exclude(False, args, kwargs)  
 [BACKEND][2025-01-03 10:42:37]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/query.py", line 1494, in _filter_or_exclude  
 [BACKEND][2025-01-03 10:42:37]     clone._filter_or_exclude_inplace(negate, args, kwargs)  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/query.py", line 1501, in _filter_or_exclude_inplace  
 [BACKEND][2025-01-03 10:42:37]     self._query.add_q(Q(*args, **kwargs))  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/query.py", line 1613, in add_q  
 [BACKEND][2025-01-03 10:42:37]     clause, _ = self._add_q(q_object, self.used_aliases)  
 [BACKEND][2025-01-03 10:42:37]                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/query.py", line 1645, in _add_q  
 [BACKEND][2025-01-03 10:42:37]     child_clause, needed_inner = self.build_filter(  
 [BACKEND][2025-01-03 10:42:37]                                  ^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/query.py", line 1495, in build_filter  
 [BACKEND][2025-01-03 10:42:37]     lookups, parts, reffed_expression = self.solve_lookup_type(arg, summarize)  
 [BACKEND][2025-01-03 10:42:37]                                         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/query.py", line 1307, in solve_lookup_type  
 [BACKEND][2025-01-03 10:42:37]     _, field, _, lookup_parts = self.names_to_path(lookup_splitted, self.get_meta())  
 [BACKEND][2025-01-03 10:42:37]                                 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:37]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/query.py", line 1772, in names_to_path  
 [BACKEND][2025-01-03 10:42:37]     raise FieldError(  
 [BACKEND][2025-01-03 10:42:37] django.core.exceptions.FieldError: Cannot resolve keyword 'profile' into field. Choices are: action, auth_providers, date_joined, email, exportjob, first_name, formview, groups, id, importexportresource, is_active, is_staff, is_superuser, job, last_login, last_name, licenseuser, localbaserowintegration, localbaserowtabledatasync, notificationrecipient, notifications, password, private_trash_entries, profile, row_comment_mentions, rowcomment, rowcommentsnotificationmode, sent_notifications, snapshot, token, trashentry, user_permissions, userfile, userlogentry, username, view, workspace, workspaceinvitation, workspaceuser  
 [BACKEND][2025-01-03 10:42:37] [2025-01-03 10:42:37 +0000] [305] [INFO] connection open  
 [BACKEND][2025-01-03 10:42:38] [2025-01-03 10:42:37 +0000] [305] [INFO] connection closed  
 [BACKEND][2025-01-03 10:42:38] 192.168.80.1:0 - "GET /api/database/views/table/1151/?include=filters,sortings,group_bys,decorations HTTP/1.1" 200  
 [BACKEND][2025-01-03 10:42:38] 192.168.80.1:0 - "GET /api/database/fields/table/1151/ HTTP/1.1" 200  
 [BACKEND][2025-01-03 10:42:40] 192.168.80.1:0 - "GET /api/database/views/grid/4513/?limit=80&offset=0&include=field_options%2Crow_metadata HTTP/1.1" 200  
 [BACKEND][2025-01-03 10:42:40] 192.168.80.1:0 - "GET /api/database/fields/table/1154/ HTTP/1.1" 200  
 [BACKEND][2025-01-03 10:42:40] 192.168.80.1:0 - "GET /api/database/views/table/1154/?include=filters,sortings,group_bys,decorations HTTP/1.1" 200  
 [BACKEND][2025-01-03 10:42:42] 192.168.80.1:0 - "GET /api/database/views/grid/4516/?limit=80&offset=0&include=field_options%2Crow_metadata HTTP/1.1" 200  
 [BACKEND][2025-01-03 10:42:42] ERROR 2025-01-03 10:42:42,343 django.request.log_response:241- Internal Server Error: /api/database/fields/table/758/   
 [BACKEND][2025-01-03 10:42:42] Traceback (most recent call last):  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/asgiref/sync.py", line 518, in thread_handler  
 [BACKEND][2025-01-03 10:42:42]     raise exc_info[1]  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/django/core/handlers/exception.py", line 42, in inner  
 [BACKEND][2025-01-03 10:42:42]     response = await get_response(request)  
 [BACKEND][2025-01-03 10:42:42]                ^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/asgiref/sync.py", line 518, in thread_handler  
 [BACKEND][2025-01-03 10:42:42]     raise exc_info[1]  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/django/core/handlers/base.py", line 253, in _get_response_async  
 [BACKEND][2025-01-03 10:42:42]     response = await wrapped_callback(  
 [BACKEND][2025-01-03 10:42:42]                ^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/asgiref/sync.py", line 468, in __call__  
 [BACKEND][2025-01-03 10:42:42]     ret = await asyncio.shield(exec_coro)  
 [BACKEND][2025-01-03 10:42:42]           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/asgiref/current_thread_executor.py", line 40, in run  
 [BACKEND][2025-01-03 10:42:42]     result = self.fn(*self.args, **self.kwargs)  
 [BACKEND][2025-01-03 10:42:42]              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/asgiref/sync.py", line 522, in thread_handler  
 [BACKEND][2025-01-03 10:42:42]     return func(*args, **kwargs)  
 [BACKEND][2025-01-03 10:42:42]            ^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/django/views/decorators/csrf.py", line 65, in _view_wrapper  
 [BACKEND][2025-01-03 10:42:42]     return view_func(request, *args, **kwargs)  
 [BACKEND][2025-01-03 10:42:42]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/django/views/generic/base.py", line 104, in view  
 [BACKEND][2025-01-03 10:42:42]     return self.dispatch(request, *args, **kwargs)  
 [BACKEND][2025-01-03 10:42:42]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/rest_framework/views.py", line 509, in dispatch  
 [BACKEND][2025-01-03 10:42:42]     response = self.handle_exception(exc)  
 [BACKEND][2025-01-03 10:42:42]                ^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/rest_framework/views.py", line 469, in handle_exception  
 [BACKEND][2025-01-03 10:42:42]     self.raise_uncaught_exception(exc)  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/rest_framework/views.py", line 480, in raise_uncaught_exception  
 [BACKEND][2025-01-03 10:42:42]     raise exc  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/rest_framework/views.py", line 497, in dispatch  
 [BACKEND][2025-01-03 10:42:42]     self.initial(request, *args, **kwargs)  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/rest_framework/views.py", line 414, in initial  
 [BACKEND][2025-01-03 10:42:42]     self.perform_authentication(request)  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/rest_framework/views.py", line 324, in perform_authentication  
 [BACKEND][2025-01-03 10:42:42]     request.user  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/rest_framework/request.py", line 231, in user  
 [BACKEND][2025-01-03 10:42:42]     self._authenticate()  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/rest_framework/request.py", line 384, in _authenticate  
 [BACKEND][2025-01-03 10:42:42]     user_auth_tuple = authenticator.authenticate(self)  
 [BACKEND][2025-01-03 10:42:42]                       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/backend/src/baserow/api/authentication.py", line 48, in authenticate  
 [BACKEND][2025-01-03 10:42:42]     auth_response = super().authenticate(request)  
 [BACKEND][2025-01-03 10:42:42]                     ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/rest_framework_simplejwt/authentication.py", line 51, in authenticate  
 [BACKEND][2025-01-03 10:42:42]     return self.get_user(validated_token), validated_token  
 [BACKEND][2025-01-03 10:42:42]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/backend/src/baserow/api/authentication.py", line 28, in get_user  
 [BACKEND][2025-01-03 10:42:42]     user = self.user_model.objects.select_related("profile").get(  
 [BACKEND][2025-01-03 10:42:42]            ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/query.py", line 645, in get  
 [BACKEND][2025-01-03 10:42:42]     num = len(clone)  
 [BACKEND][2025-01-03 10:42:42]           ^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/query.py", line 382, in __len__  
 [BACKEND][2025-01-03 10:42:42]     self._fetch_all()  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/query.py", line 1928, in _fetch_all  
 [BACKEND][2025-01-03 10:42:42]     self._result_cache = list(self._iterable_class(self))  
 [BACKEND][2025-01-03 10:42:42]                          ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/query.py", line 91, in __iter__  
 [BACKEND][2025-01-03 10:42:42]     results = compiler.execute_sql(  
 [BACKEND][2025-01-03 10:42:42]               ^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/compiler.py", line 1549, in execute_sql  
 [BACKEND][2025-01-03 10:42:42]     sql, params = self.as_sql()  
 [BACKEND][2025-01-03 10:42:42]                   ^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/compiler.py", line 736, in as_sql  
 [BACKEND][2025-01-03 10:42:42]     extra_select, order_by, group_by = self.pre_sql_setup(  
 [BACKEND][2025-01-03 10:42:42]                                        ^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/compiler.py", line 84, in pre_sql_setup  
 [BACKEND][2025-01-03 10:42:42]     self.setup_query(with_col_aliases=with_col_aliases)  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/compiler.py", line 73, in setup_query  
 [BACKEND][2025-01-03 10:42:42]     self.select, self.klass_info, self.annotation_col_map = self.get_select(  
 [BACKEND][2025-01-03 10:42:42]                                                             ^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/compiler.py", line 279, in get_select  
 [BACKEND][2025-01-03 10:42:42]     related_klass_infos = self.get_related_selections(select, select_mask)  
 [BACKEND][2025-01-03 10:42:42]                           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^  
 [BACKEND][2025-01-03 10:42:42]   File "/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/compiler.py", line 1367, in get_related_selections  
 [BACKEND][2025-01-03 10:42:42]     raise FieldError(  
 [BACKEND][2025-01-03 10:42:42] django.core.exceptions.FieldError: Invalid field name(s) given in select_related: 'profile'. Choices are: (none)  
 [BACKEND][2025-01-03 10:42:42] 192.168.80.1:0 - "GET /api/database/fields/table/758/ HTTP/1.1" 500  
 [BACKEND][2025-01-03 10:42:53] 192.168.80.1:0 - "GET /api/database/views/table/758/?include=filters,sortings,group_bys,decorations HTTP/1.1" 200

cezary · January 3, 2025, 11:57am

Thanks. Could you also show logs from container’s startup?

hanneskeller · January 3, 2025, 6:51pm

Here is a Link you can download the Log File

cezary · January 8, 2025, 2:00pm

Thanks!

Those errors are quite strange. I’m not sure what could be the cause.
As far as I understood, those errors are quite occasional, but maybe there’s some regularity. Do they happen after some time of inactivity in UI, or in some more-or-less regular time intervals? Any specific views/urls are affected more often than other?

cezary · January 8, 2025, 2:03pm

Also, could you check if those errors will happen if you comment read_only setting in your compose config?

cezary · January 8, 2025, 5:29pm

Another idea how to diagnose this: could you downgrade Baserow image to 1.29.3 and see if the error occurs?

hanneskeller · January 8, 2025, 7:45pm

Thanks cezary for your help. This error came after some time and I wasn’t able to use Baserow any more. No table or view is than accessible.
Right now it was provided over the baserow.my-domyin.com via cname thrue the Synology Proxy to the localhost. This way I used with several container and until 1.30.0 it als works for baserow. Bur now there is coming this problems. I also checked the read_only and every time the error happened. Monday night I changed baserow.my-domyin.com to the Synology dyndns and since this this there is no Problem. With 1.29.3 is no error there.

cezary · January 9, 2025, 9:16am

One more idea: did you tried to clean your cookies for the site after this error?

hanneskeller · January 9, 2025, 2:23pm

Yes, I did. I also tried to switch the browser. Same Problem with Safari, Chrome and Firefox. I also Tried it on Windows and Mac. The good thing is that it’s running now. Not under the Domain it should be, but it is running.

cezary · January 9, 2025, 2:40pm

Thanks.

We’re investigating this, but it’s very likely it’s a know problem with multi-threading used in the deployment.

Could you describe a bit more your deployment? How much data (more-or-less) you host (databases/tables)? How many users are using Baserow instance? Any API integrations/clients in use?

hanneskeller · January 9, 2025, 3:56pm

Shure. The whole deployment I did with the description of Mariushosting.
I only adjusted some of the password and som variables what fit better for may setup. Aswell I changed the path. But as I sad it worked from June with noch Problems.
There is only me as Database user, normally logged in with up to 4 windows. Ant through the Applications there are around 10 fixed user and several only via link .
There are running 5 active Workspaces and one Testworkspace. In this 6 Workspaces there are 18 databases ans 12 Aplications. And in total there are 103 tables.
I only had one api connection to a self hosted n8n version to sync my Accounting data.
Does this help you? If you need more details please let me know.

cezary · January 10, 2025, 12:22pm

Thanks for the info.

I’ve created an issue for this: Possible race condition in asgi (#3346) · Issues · Baserow / baserow · GitLab.