Update 1.32.5 and 1.33.0

Dmitriy_Ural · May 5, 2025, 10:13am

Are you using our SaaS platform (Baserow.io) or self-hosting Baserow?

Self-hosted

If you are self-hosting, what version of Baserow are you running?

version 1.31.1 and update from version 1.32.5 and also 1.33.0

If you are self-hosting, which installation method do you use to run Baserow?

Docker version 20.10.24+dfsg1, build 297e128

What are the exact steps to reproduce this issue?

Good afternoon.
After updating Baserow from version 1.31.1 to version 1.32.5 and also 1.33.0 we encountered a problem.
When changing the data field, an error appears - Action not completed. The action couldn’t be completed because an unknown error has occurred.
The docker baserow logs indicate -
[EXPORT_WORKER][2025-05-05 06:41:00] [2025-05-05 06:41:00,155: INFO/ForkPoolWorker-1] Task baserow.core.trash.tasks.mark_old_trash_for_permanent_deletion[56612439-cbfd-4a30-9399-bde818ec70de] succeeded in 0.020461510051973164s: None
[EXPORT_WORKER][2025-05-05 06:41:00] [2025-05-05 06:41:00,181: WARNING/ForkPoolWorker-1] 308|2025-05-05 06:41:00.181|INFO|baserow.core.trash.handler:permanently_delete_marked_trash:305 - Successfully deleted 0 trash entries and their associated trashed items.
[BACKEND][2025-05-05 06:41:02] 172.17.0.1:0 - “GET /api/database/rows/table/823/?limit=10 HTTP/1.1” 200
[BACKEND][2025-05-05 06:41:13] 127.0.0.1:40794 - “GET /api/_health/ HTTP/1.1” 200
[BACKEND][2025-05-

cezary · May 5, 2025, 1:35pm

Hi!

Can you send a log excerpt from the moment you get this error? The excerpt you’ve sent seems not related.

Dmitriy_Ural · May 6, 2025, 7:18am

Here is the log from the moment the error was received.
We receive this message code in the field with the data parameter we indicate the date and time.

[BEAT_WORKER][2025-05-06 05:06:32] [2025-05-06 05:06:00,002: INFO/MainProcess] Scheduler: Sending due task baserow.core.notifications.tasks.beat_send_instant_notifications_summary_by_email() (baserow.core.notifications.tasks.beat_send_instant_notifications_summary_by_email)
[EXPORT_WORKER][2025-05-06 05:06:32] [2025-05-06 05:06:00,039: INFO/ForkPoolWorker-1] Task baserow.core.notifications.tasks.singleton_send_instant_notifications_summary_by_email[4582d7b7-5613-4273-b09c-762307d0ffb0] succeeded in 0.029187166946940124s: None
[EXPORT_WORKER][2025-05-06 05:06:32] [2025-05-06 05:06:32,318: INFO/MainProcess] Task baserow_enterprise.data_sync.tasks.call_periodic_data_sync_syncs_that_are_due[bb5ba463-d921-48bc-a65f-eb1e3f8ee8ad] received
[BACKEND][2025-05-06 05:06:33] 127.0.0.1:50390 - “GET /api/_health/ HTTP/1.1” 200
[BACKEND][2025-05-06 05:06:40] 172.17.0.1:0 - “GET /api/database/rows/table/823/?limit=10 HTTP/1.1” 200
[BACKEND][2025-05-06 05:06:44] 127.0.0.1:54956 - “GET /api/_health/ HTTP/1.1” 200
[BACKEND][2025-05-06 05:06:44] ERROR 2025-05-06 05:06:44,798 django.request.log_response:241- Internal Server Error: /api/database/rows/table/823/6334/
[BACKEND][2025-05-06 05:06:44] Traceback (most recent call last):
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/django/db/backends/utils.py”, line 105, in _execute
[BACKEND][2025-05-06 05:06:44] return self.cursor.execute(sql, params)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] psycopg2.errors.UndefinedFunction: ОШИБКА: оператор не существует: text = boolean
[BACKEND][2025-05-06 05:06:44] LINE 1: …‘)::text, (’‘)::text), (’}]‘)::text, (’‘)::text)) IS NOT DIS…
[BACKEND][2025-05-06 05:06:44] ^
[BACKEND][2025-05-06 05:06:44] HINT: Оператор с данными именем и типами аргументов не найден. Возможно, вам следует добавить явные приведения типов.
[BACKEND][2025-05-06 05:06:44]
[BACKEND][2025-05-06 05:06:44]
[BACKEND][2025-05-06 05:06:44] The above exception was the direct cause of the following exception:
[BACKEND][2025-05-06 05:06:44]
[BACKEND][2025-05-06 05:06:44] Traceback (most recent call last):
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/asgiref/sync.py”, line 518, in thread_handler
[BACKEND][2025-05-06 05:06:44] raise exc_info[1]
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/django/core/handlers/exception.py”, line 42, in inner
[BACKEND][2025-05-06 05:06:44] response = await get_response(request)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/asgiref/sync.py”, line 518, in thread_handler
[BACKEND][2025-05-06 05:06:44] raise exc_info[1]
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/django/core/handlers/base.py”, line 253, in _get_response_async
[BACKEND][2025-05-06 05:06:44] response = await wrapped_callback(
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/asgiref/sync.py”, line 468, in call
[BACKEND][2025-05-06 05:06:44] ret = await asyncio.shield(exec_coro)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/asgiref/current_thread_executor.py”, line 40, in run
[BACKEND][2025-05-06 05:06:44] result = self.fn(*self.args, **self.kwargs)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/asgiref/sync.py”, line 522, in thread_handler
[BACKEND][2025-05-06 05:06:44] return func(*args, **kwargs)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/django/views/decorators/csrf.py”, line 65, in _view_wrapper
[BACKEND][2025-05-06 05:06:44] return view_func(request, *args, **kwargs)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/django/views/generic/base.py”, line 104, in view
[BACKEND][2025-05-06 05:06:44] return self.dispatch(request, *args, **kwargs)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/rest_framework/views.py”, line 509, in dispatch
[BACKEND][2025-05-06 05:06:44] response = self.handle_exception(exc)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/rest_framework/views.py”, line 469, in handle_exception
[BACKEND][2025-05-06 05:06:44] self.raise_uncaught_exception(exc)
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/rest_framework/views.py”, line 480, in raise_uncaught_exception
[BACKEND][2025-05-06 05:06:44] raise exc
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/rest_framework/views.py”, line 506, in dispatch
[BACKEND][2025-05-06 05:06:44] response = handler(request, *args, **kwargs)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/api/decorators.py”, line 113, in func_wrapper
[BACKEND][2025-05-06 05:06:44] return func(*args, **kwargs)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/core/db.py”, line 842, in wrapper
[BACKEND][2025-05-06 05:06:44] return func(*args, **kwargs)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/api/decorators.py”, line 439, in _wrap
[BACKEND][2025-05-06 05:06:44] return f(_self, request, *args, **kwargs)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/contrib/database/api/rows/views.py”, line 914, in patch
[BACKEND][2025-05-06 05:06:44] row = action_type_registry.get_by_type(UpdateRowsActionType).do(
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/contrib/database/rows/actions.py”, line 825, in do
[BACKEND][2025-05-06 05:06:44] result = row_handler.update_rows(
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/core/telemetry/utils.py”, line 73, in _wrapper
[BACKEND][2025-05-06 05:06:44] raise ex
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/core/telemetry/utils.py”, line 69, in _wrapper
[BACKEND][2025-05-06 05:06:44] result = wrapped_func(*args, **kwargs)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/contrib/database/rows/handler.py”, line 2171, in update_rows
[BACKEND][2025-05-06 05:06:44] return self.force_update_rows(
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/core/telemetry/utils.py”, line 73, in _wrapper
[BACKEND][2025-05-06 05:06:44] raise ex
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/core/telemetry/utils.py”, line 69, in _wrapper
[BACKEND][2025-05-06 05:06:44] result = wrapped_func(*args, **kwargs)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/contrib/database/rows/handler.py”, line 2071, in force_update_rows
[BACKEND][2025-05-06 05:06:44] dependant_fields = self.update_dependencies_of_rows_updated(
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/core/telemetry/utils.py”, line 73, in _wrapper
[BACKEND][2025-05-06 05:06:44] raise ex
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/core/telemetry/utils.py”, line 69, in _wrapper
[BACKEND][2025-05-06 05:06:44] result = wrapped_func(*args, **kwargs)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/contrib/database/rows/handler.py”, line 1084, in update_dependencies_of_rows_updated
[BACKEND][2025-05-06 05:06:44] update_collector.apply_updates_and_get_updated_fields(
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/contrib/database/fields/dependencies/update_collector.py”, line 447, in apply_updates_and_get_updated_fields
[BACKEND][2025-05-06 05:06:44] updated_rows_count = self.apply_updates(field_cache)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/contrib/database/fields/dependencies/update_collector.py”, line 410, in apply_updates
[BACKEND][2025-05-06 05:06:44] updated_rows_count = self._update_statement_collector.execute_all(
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/contrib/database/fields/dependencies/update_collector.py”, line 147, in execute_all
[BACKEND][2025-05-06 05:06:44] updated_rows += sub_path.execute_all(
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/contrib/database/fields/dependencies/update_collector.py”, line 139, in execute_all
[BACKEND][2025-05-06 05:06:44] updated_rows += self._execute_pending_update_statements(
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/backend/src/baserow/contrib/database/fields/dependencies/update_collector.py”, line 217, in _execute_pending_update_statements
[BACKEND][2025-05-06 05:06:44] qs.annotate(**annotations)
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/django/db/models/query.py”, line 1253, in update
[BACKEND][2025-05-06 05:06:44] rows = query.get_compiler(self.db).execute_sql(CURSOR)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/compiler.py”, line 1990, in execute_sql
[BACKEND][2025-05-06 05:06:44] cursor = super().execute_sql(result_type)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/django/db/models/sql/compiler.py”, line 1562, in execute_sql
[BACKEND][2025-05-06 05:06:44] cursor.execute(sql, params)
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/django/db/backends/utils.py”, line 79, in execute
[BACKEND][2025-05-06 05:06:44] return self._execute_with_wrappers(
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/django/db/backends/utils.py”, line 92, in _execute_with_wrappers
[BACKEND][2025-05-06 05:06:44] return executor(sql, params, many, context)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/django/db/backends/utils.py”, line 100, in _execute
[BACKEND][2025-05-06 05:06:44] with self.db.wrap_database_errors:
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/django/db/utils.py”, line 91, in exit
[BACKEND][2025-05-06 05:06:44] raise dj_exc_value.with_traceback(traceback) from exc_value
[BACKEND][2025-05-06 05:06:44] File “/baserow/venv/lib/python3.11/site-packages/django/db/backends/utils.py”, line 105, in _execute
[BACKEND][2025-05-06 05:06:44] return self.cursor.execute(sql, params)
[BACKEND][2025-05-06 05:06:44] ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
[BACKEND][2025-05-06 05:06:44] django.db.utils.ProgrammingError: ОШИБКА: оператор не существует: text = boolean
[BACKEND][2025-05-06 05:06:44] LINE 1: …’)::text, (‘’)::text), (‘}]’)::text, (‘’)::text)) IS NOT DIS…
[BACKEND][2025-05-06 05:06:44] ^
[BACKEND][2025-05-06 05:06:44] HINT: Оператор с данными именем и типами аргументов не найден. Возможно, вам следует добавить явные приведения типов.
[BACKEND][2025-05-06 05:06:44]
[BACKEND][2025-05-06 05:06:54] 172.17.0.1:0 - “PATCH /api/database/rows/table/823/6334/ HTTP/1.1” 500
[BEAT_WORKER][2025-05-06 05:06:59] [2025-05-06 05:06:32,315: INFO/MainProcess] Scheduler: Sending due task baserow_enterprise.data_sync.tasks.call_periodic_data_sync_syncs_that_are_due() (baserow_enterprise.data_sync.tasks.call_periodic_data_sync_syncs_that_are_due)
[EXPORT_WORKER][2025-05-06 05:07:00] [2025-05-06 05:06:32,347: INFO/ForkPoolWorker-1] Task baserow_enterprise.data_sync.tasks.call_periodic_data_sync_syncs_that_are_due[bb5ba463-d921-48bc-a65f-eb1e3f8ee8ad] succeeded in 0.02870251308195293s: None
[EXPORT_WORKER][2025-05-06 05:07:00] [2025-05-06 05:07:00,005: INFO/MainProcess] Task baserow.core.notifications.tasks.beat_send_instant_notifications_summary_by_email[a6523286-f75e-4527-ad4b-b8f9a3a6df6b] received
[EXPORT_WORKER][2025-05-06 05:07:00] [2025-05-06 05:07:00,007: INFO/ForkPoolWorker-1] Task baserow.core.notifications.tasks.beat_send_instant_notifications_summary_by_email[a6523286-f75e-4527-ad4b-b8f9a3a6df6b] succeeded in 0.001756350975483656s: None
[EXPORT_WORKER][2025-05-06 05:07:00] [2025-05-06 05:07:00,008: INFO/MainProcess] Task baserow.core.notifications.tasks.singleton_send_instant_notifications_summary_by_email[6458852b-80fb-4f43-b561-47c71a65a871] received
[BACKEND][2025-05-06 05:07:00] 172.17.0.1:0 - “GET /api/database/rows/table/823/?limit=10 HTTP/1.1” 200

Dmitriy_Ural · May 22, 2025, 11:02am

Hello, is there anything known about this issue? Some columns are blocked when we work and we cannot make changes to them.

cezary · May 26, 2025, 12:20pm

Sorry for delay.

This error seems to be related to a formula field resolved to an invalid expression in sql. Can you provide field definition for a field that may be affected? Or database schema (without data) if possible. You can DM them to me.