### Author:  [@bram](https://community.baserow.io/u/bram)
#### Post date: [October 16, 2023, 8:21am UTC](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573/3 "2023-10-16T08:21:51Z")
Hi @Rob192, I’m sorry to hear that you’re having some problems with your Baserow instance.
> do you know what could render baserow slow ?
There could be various reasons why your Baserow environment is slow. Do you have any insights in the CPU and memory usage of your server? Do you have any insights in how many API requests you’re making per second?
> The problem is that when I tried to import the biggest csv file, the importation never ended.
Did you see the import percentage going up, or did it remain stuck at 0%? If so, would you mind checking if the real-time collaboration works? Just open two browser tabs, change a cell in one tab, and see it being updated in the other? The reason I’m asking is that I want to make sure async jobs are working. Although judging from your logs, it does sound like they it works.
> Do you know how to kill a csv import job to try to chunk the file in smallest files ?
1500 lines doesn’t seem like that much, and you should be able to import that quickly in any environment. Out of curiosity, how many columns does the CSV have? It’s not easily possible to cancel the job, but restarting the Baserow Docker container should kill the execution of it. The job itself might remain pending in the PostgreSQL database, but if I’m correct, that will automatically be cleaned up within 24 hours. Is it already possible to start the job again?
> Do you think there is a risk for the database if I just restart the docker to cancel the operation ?
It should normally not be a problem to restart your Docker container.
Separately, can you share an overview of all the environment variables you’ve set?
---
### Author:  [@Rob192](https://community.baserow.io/u/Rob192)
#### Post date: [October 24, 2023, 7:48am UTC](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573/4 "2023-10-24T07:48:54Z")
Hello @bram ,
Thanks for reaching out to me ! I had a hard time restarting the Baserow instance on my end (with Panic mode activated because we use it for our business).
I had issues for the Baserow instance not being able to restart because the database could not start. I ended up using this [Investigate, document and prevent or fix postgres database corruption when two all-in-one images run at the same time with same volume (#1524) · Issues · Baserow / baserow · GitLab](https://gitlab.com/baserow/baserow/-/issues/1524) and it worked 🫡 I think it would be good to add this to the documentation for the backup of the database.
> [@bram](#):
>
> Separately, can you share an overview of all the environment variables you’ve set?
Unfortunately they are all described in the docker compose file I sent 😕
environment:
- BASEROW\_PUBLIC\_URL=[https://xxx](https://xxx)
- BASEROW\_CADDY\_ADDRESSES=[https://xxx](https://xxx)
I realized it’s poorly configurated 😬
> [@bram](#):
>
> Do you have any insights in the CPU and memory usage of your server? Do you have any insights in how many API requests you’re making per second?
We were making approx 1 api call per sec with a filter on the mac address on the 256k row table.
> [@bram](#):
>
> Did you see the import percentage going up, or did it remain stuck at 0%? If so, would you mind checking if the real-time collaboration works? Just open two browser tabs, change a cell in one tab, and see it being updated in the other?
It remained stuck at 50%. I was still unable to import csv after the restart of the instance. However, after the manipulation outlined in there : [Investigate, document and prevent or fix postgres database corruption when two all-in-one images run at the same time with same volume (#1524) · Issues · Baserow / baserow · GitLab](https://gitlab.com/baserow/baserow/-/issues/1524) I was able to start again the import.
BUT, it is now stuck again although I used a small file (212Ko) .
Also, now one of my table displays this error message 😬
# View not found.
The page you are looking for has not been found. This might be because URL is incorrect or that you don’t have permission to view this page.
(I should have permissions as I am the only user 😕 )
I feel like the database has issue but this is a bit of a black box to me.
Please help 🙏
---
### Author:  [@Rob192](https://community.baserow.io/u/Rob192)
#### Post date: [October 24, 2023, 8:29am UTC](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573/5 "2023-10-24T08:29:39Z")
Regarding the error for the table 323 that I cannot reach anymore, I have the following log when I try to send data to it :
```auto
[POSTGRES][2023-10-24 08:24:31] 2023-10-24 08:23:01.866 UTC [61836] baserow@baserow STATEMENT: INSERT INTO "database_table_323" ("created_on", "updated_on", "trashed", "field_2668", "field_2672", "field_2673", "field_2674", "field_2675", "field_2676", "field_2677", "field_2678", "field_2679", "field_2693", "field_2835", "order", "tsv_field_2668", "tsv_field_2672", "tsv_field_2673", "tsv_field_2674", "tsv_field_2675", "tsv_field_2676", "tsv_field_2677", "tsv_field_2678", "tsv_field_2679", "tsv_field_2693", "tsv_field_2835", "needs_background_update") VALUES ('2023-10-24T08:23:01.612979+00:00'::timestamptz, '2023-10-24T08:23:01.612979+00:00'::timestamptz, false, NULL, '2023-10-24T08:22:54.079972+00:00'::timestamptz, 1698135774.079972, 'E5:45:E0:B8:5E:EE', '{''result'': [''7.59'', ''37.16'', ''19.81'', ''97.99'', ''27.22'', ''171.15'', ''5.19'', ''60.30'', ''26.40'', ''236.92'', ''13.89'', ''334.53''], ''data'': [[0.011255025863647461, 0.033661842346191406, 0.04976391792297363, 0.07225799560546875, **.... BIG CHUNK OF DATA**
[BACKEND][2023-10-24 08:24:31] 113.118.233.239:0 - "POST /api/database/rows/table/317/?user_field_names=true HTTP/1.1" 200
[BACKEND][2023-10-24 08:24:31] ERROR 2023-10-24 08:24:31,170 django.request.log_response:224- Internal Server Error: /api/database/views/grid/1213/
[BACKEND][2023-10-24 08:24:31] Traceback (most recent call last):
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[BACKEND][2023-10-24 08:24:31] return self.cursor.execute(sql, params)
[BACKEND][2023-10-24 08:24:31] psycopg2.errors.InternalError_: missing chunk number 32 for toast value 378150 in pg_toast_31140
[BACKEND][2023-10-24 08:24:31]
[BACKEND][2023-10-24 08:24:31]
[BACKEND][2023-10-24 08:24:31] The above exception was the direct cause of the following exception:
[BACKEND][2023-10-24 08:24:31]
[BACKEND][2023-10-24 08:24:31] Traceback (most recent call last):
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 486, in thread_handler
[BACKEND][2023-10-24 08:24:31] raise exc_info[1]
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/core/handlers/exception.py", line 38, in inner
[BACKEND][2023-10-24 08:24:31] response = await get_response(request)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/core/handlers/base.py", line 233, in _get_response_async
[BACKEND][2023-10-24 08:24:31] response = await wrapped_callback(request, *callback_args, **callback_kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 448, in __call__
[BACKEND][2023-10-24 08:24:31] ret = await asyncio.wait_for(future, timeout=None)
[BACKEND][2023-10-24 08:24:31] File "/usr/lib/python3.9/asyncio/tasks.py", line 442, in wait_for
[BACKEND][2023-10-24 08:24:31] return await fut
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/asgiref/current_thread_executor.py", line 22, in run
[BACKEND][2023-10-24 08:24:31] result = self.fn(*self.args, **self.kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 490, in thread_handler
[BACKEND][2023-10-24 08:24:31] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/views/decorators/csrf.py", line 54, in wrapped_view
[BACKEND][2023-10-24 08:24:31] return view_func(*args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/views/generic/base.py", line 70, in view
[BACKEND][2023-10-24 08:24:31] return self.dispatch(request, *args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 509, in dispatch
[BACKEND][2023-10-24 08:24:31] response = self.handle_exception(exc)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 469, in handle_exception
[BACKEND][2023-10-24 08:24:31] self.raise_uncaught_exception(exc)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 480, in raise_uncaught_exception
[BACKEND][2023-10-24 08:24:31] raise exc
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 506, in dispatch
[BACKEND][2023-10-24 08:24:31] response = handler(request, *args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/backend/src/baserow/api/decorators.py", line 107, in func_wrapper
[BACKEND][2023-10-24 08:24:31] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/backend/src/baserow/api/decorators.py", line 340, in func_wrapper
[BACKEND][2023-10-24 08:24:31] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/backend/src/baserow/api/decorators.py", line 172, in func_wrapper
[BACKEND][2023-10-24 08:24:31] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/backend/src/baserow/contrib/database/api/views/grid/views.py", line 289, in get
[BACKEND][2023-10-24 08:24:31] page = paginator.paginate_queryset(queryset, request, self)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/pagination.py", line 395, in paginate_queryset
[BACKEND][2023-10-24 08:24:31] return list(queryset[self.offset:self.offset + self.limit])
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/query.py", line 262, in __len__
[BACKEND][2023-10-24 08:24:31] self._fetch_all()
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/query.py", line 1324, in _fetch_all
[BACKEND][2023-10-24 08:24:31] self._result_cache = list(self._iterable_class(self))
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/query.py", line 51, in __iter__
[BACKEND][2023-10-24 08:24:31] results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1175, in execute_sql
[BACKEND][2023-10-24 08:24:31] cursor.execute(sql, params)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 66, in execute
[BACKEND][2023-10-24 08:24:31] return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
[BACKEND][2023-10-24 08:24:31] return executor(sql, params, many, context)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[BACKEND][2023-10-24 08:24:31] return self.cursor.execute(sql, params)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
[BACKEND][2023-10-24 08:24:31] raise dj_exc_value.with_traceback(traceback) from exc_value
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[BACKEND][2023-10-24 08:24:31] return self.cursor.execute(sql, params)
[BACKEND][2023-10-24 08:24:31] django.db.utils.InternalError: missing chunk number 32 for toast value 378150 in pg_toast_31140
[BACKEND][2023-10-24 08:24:31]
[BACKEND][2023-10-24 08:24:31] ERROR 2023-10-24 08:24:31,170 django.request.log_response:224- Internal Server Error: /api/database/views/grid/1213/
[BACKEND][2023-10-24 08:24:31] Traceback (most recent call last):
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[BACKEND][2023-10-24 08:24:31] return self.cursor.execute(sql, params)
[BACKEND][2023-10-24 08:24:31] psycopg2.errors.InternalError_: missing chunk number 32 for toast value 378150 in pg_toast_31140
[BACKEND][2023-10-24 08:24:31]
[BACKEND][2023-10-24 08:24:31]
[BACKEND][2023-10-24 08:24:31] The above exception was the direct cause of the following exception:
[BACKEND][2023-10-24 08:24:31]
[BACKEND][2023-10-24 08:24:31] Traceback (most recent call last):
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 486, in thread_handler
[BACKEND][2023-10-24 08:24:31] raise exc_info[1]
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/core/handlers/exception.py", line 38, in inner
[BACKEND][2023-10-24 08:24:31] response = await get_response(request)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/core/handlers/base.py", line 233, in _get_response_async
[BACKEND][2023-10-24 08:24:31] response = await wrapped_callback(request, *callback_args, **callback_kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 448, in __call__
[BACKEND][2023-10-24 08:24:31] ret = await asyncio.wait_for(future, timeout=None)
[BACKEND][2023-10-24 08:24:31] File "/usr/lib/python3.9/asyncio/tasks.py", line 442, in wait_for
[BACKEND][2023-10-24 08:24:31] return await fut
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/asgiref/current_thread_executor.py", line 22, in run
[BACKEND][2023-10-24 08:24:31] result = self.fn(*self.args, **self.kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 490, in thread_handler
[BACKEND][2023-10-24 08:24:31] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/views/decorators/csrf.py", line 54, in wrapped_view
[BACKEND][2023-10-24 08:24:31] return view_func(*args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/views/generic/base.py", line 70, in view
[BACKEND][2023-10-24 08:24:31] return self.dispatch(request, *args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 509, in dispatch
[BACKEND][2023-10-24 08:24:31] response = self.handle_exception(exc)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 469, in handle_exception
[BACKEND][2023-10-24 08:24:31] self.raise_uncaught_exception(exc)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 480, in raise_uncaught_exception
[BACKEND][2023-10-24 08:24:31] raise exc
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 506, in dispatch
[BACKEND][2023-10-24 08:24:31] response = handler(request, *args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/backend/src/baserow/api/decorators.py", line 107, in func_wrapper
[BACKEND][2023-10-24 08:24:31] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/backend/src/baserow/api/decorators.py", line 340, in func_wrapper
[BACKEND][2023-10-24 08:24:31] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/backend/src/baserow/api/decorators.py", line 172, in func_wrapper
[BACKEND][2023-10-24 08:24:31] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/backend/src/baserow/contrib/database/api/views/grid/views.py", line 289, in get
[BACKEND][2023-10-24 08:24:31] page = paginator.paginate_queryset(queryset, request, self)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/pagination.py", line 395, in paginate_queryset
[BACKEND][2023-10-24 08:24:31] return list(queryset[self.offset:self.offset + self.limit])
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/query.py", line 262, in __len__
[BACKEND][2023-10-24 08:24:31] self._fetch_all()
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/query.py", line 1324, in _fetch_all
[BACKEND][2023-10-24 08:24:31] self._result_cache = list(self._iterable_class(self))
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/query.py", line 51, in __iter__
[BACKEND][2023-10-24 08:24:31] results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1175, in execute_sql
[BACKEND][2023-10-24 08:24:31] cursor.execute(sql, params)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 66, in execute
[BACKEND][2023-10-24 08:24:31] return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
[BACKEND][2023-10-24 08:24:31] return executor(sql, params, many, context)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[BACKEND][2023-10-24 08:24:31] return self.cursor.execute(sql, params)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
[BACKEND][2023-10-24 08:24:31] raise dj_exc_value.with_traceback(traceback) from exc_value
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[BACKEND][2023-10-24 08:24:31] return self.cursor.execute(sql, params)
[BACKEND][2023-10-24 08:24:31] django.db.utils.InternalError: missing chunk number 32 for toast value 378150 in pg_toast_31140
[BACKEND][2023-10-24 08:24:31]
[BACKEND][2023-10-24 08:24:31] ERROR 2023-10-24 08:24:31,170 django.request.log_response:224- Internal Server Error: /api/database/views/grid/1213/
[BACKEND][2023-10-24 08:24:31] Traceback (most recent call last):
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[BACKEND][2023-10-24 08:24:31] return self.cursor.execute(sql, params)
[BACKEND][2023-10-24 08:24:31] psycopg2.errors.InternalError_: missing chunk number 32 for toast value 378150 in pg_toast_31140
[BACKEND][2023-10-24 08:24:31]
[BACKEND][2023-10-24 08:24:31]
[BACKEND][2023-10-24 08:24:31] The above exception was the direct cause of the following exception:
[BACKEND][2023-10-24 08:24:31]
[BACKEND][2023-10-24 08:24:31] Traceback (most recent call last):
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 486, in thread_handler
[BACKEND][2023-10-24 08:24:31] raise exc_info[1]
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/core/handlers/exception.py", line 38, in inner
[BACKEND][2023-10-24 08:24:31] response = await get_response(request)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/core/handlers/base.py", line 233, in _get_response_async
[BACKEND][2023-10-24 08:24:31] response = await wrapped_callback(request, *callback_args, **callback_kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 448, in __call__
[BACKEND][2023-10-24 08:24:31] ret = await asyncio.wait_for(future, timeout=None)
[BACKEND][2023-10-24 08:24:31] File "/usr/lib/python3.9/asyncio/tasks.py", line 442, in wait_for
[BACKEND][2023-10-24 08:24:31] return await fut
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/asgiref/current_thread_executor.py", line 22, in run
[BACKEND][2023-10-24 08:24:31] result = self.fn(*self.args, **self.kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 490, in thread_handler
[BACKEND][2023-10-24 08:24:31] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/views/decorators/csrf.py", line 54, in wrapped_view
[BACKEND][2023-10-24 08:24:31] return view_func(*args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/views/generic/base.py", line 70, in view
[BACKEND][2023-10-24 08:24:31] return self.dispatch(request, *args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 509, in dispatch
[BACKEND][2023-10-24 08:24:31] response = self.handle_exception(exc)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 469, in handle_exception
[BACKEND][2023-10-24 08:24:31] self.raise_uncaught_exception(exc)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 480, in raise_uncaught_exception
[BACKEND][2023-10-24 08:24:31] raise exc
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 506, in dispatch
[BACKEND][2023-10-24 08:24:31] response = handler(request, *args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/backend/src/baserow/api/decorators.py", line 107, in func_wrapper
[BACKEND][2023-10-24 08:24:31] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/backend/src/baserow/api/decorators.py", line 340, in func_wrapper
[BACKEND][2023-10-24 08:24:31] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/backend/src/baserow/api/decorators.py", line 172, in func_wrapper
[BACKEND][2023-10-24 08:24:31] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:24:31] File "/baserow/backend/src/baserow/contrib/database/api/views/grid/views.py", line 289, in get
[BACKEND][2023-10-24 08:24:31] page = paginator.paginate_queryset(queryset, request, self)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/pagination.py", line 395, in paginate_queryset
[BACKEND][2023-10-24 08:24:31] return list(queryset[self.offset:self.offset + self.limit])
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/query.py", line 262, in __len__
[BACKEND][2023-10-24 08:24:31] self._fetch_all()
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/query.py", line 1324, in _fetch_all
[BACKEND][2023-10-24 08:24:31] self._result_cache = list(self._iterable_class(self))
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/query.py", line 51, in __iter__
[BACKEND][2023-10-24 08:24:31] results = compiler.execute_sql(chunked_fetch=self.chunked_fetch, chunk_size=self.chunk_size)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1175, in execute_sql
[BACKEND][2023-10-24 08:24:31] cursor.execute(sql, params)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 66, in execute
[BACKEND][2023-10-24 08:24:31] return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
[BACKEND][2023-10-24 08:24:31] return executor(sql, params, many, context)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[BACKEND][2023-10-24 08:24:31] return self.cursor.execute(sql, params)
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
[BACKEND][2023-10-24 08:24:31] raise dj_exc_value.with_traceback(traceback) from exc_value
[BACKEND][2023-10-24 08:24:31] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[BACKEND][2023-10-24 08:24:31] return self.cursor.execute(sql, params)
[BACKEND][2023-10-24 08:24:31] django.db.utils.InternalError: missing chunk number 32 for toast value 378150 in pg_toast_31140
[POSTGRES][2023-10-24 08:24:31] 2023-10-24 08:24:31.169 UTC [62012] baserow@baserow ERROR: missing chunk number 32 for toast value 378150 in pg_toast_31140
**BIG CHUNK OF DATA CONTINUES** 3.313476821129692]], ''param'': {''T05_pressure'': [[0, 20], [25, 65], [0, 40], [75, 125], [0, 50], [135, 200], [0, 20], [35, 80], [0, 50], [190, 265], [0, 40], [320, 380]], ''T30_pressure'': [[0, 20], [35, 60], [0, 35], [80, 100], [0, 45], [135, 160], [0, 20], [55, 80], [0, 35], [150, 175], [0, 45], [280, 310]], ''T10_board_info'': {''board_version'': ''S00P00'', ''board'': 0, ''batch'': 11}, ''Serial_port'': {}, ''pump_cycles'': {''initial_cycles_nb'': 5, ''test_cycles_nb'': 5, ''nb_peaks_to_avg'': 5}, ''JFlash'': {''macos_path'': ''/Applications/SEGGER/JLink_V780c/JFlash.app'', ''win_path'': ''C:\\Program Files\\SEGGER\\JLink\\JFlash.exe''}, ''opto_calibration_distance'': 40, ''opto_xtalk_calib_value'': 0, ''serial_port'': {''port_breast_pump'': ''COM8'', ''port_bench'': ''COM6''}}}', 'V41', 'PerifitPump_V32', '2310b00113573', 334.530000, true, '0011', 26719.00000000000000000000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, true) RETURNING "database_table_323"."id"
```
---
### Author:  [@Rob192](https://community.baserow.io/u/Rob192)
#### Post date: [October 24, 2023, 8:37am UTC](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573/6 "2023-10-24T08:37:03Z")
And also this log
```auto
POSTGRES][2023-10-24 08:35:15] 2023-10-24 08:33:27.424 UTC [63099] baserow@baserow STATEMENT: SELECT "database_table_323"."id", "database_table_323"."created_on", "database_table_323"."updated_on", "database_table_323"."trashed", "database_table_323"."field_2668", "database_table_323"."field_2672", "database_table_323"."field_2673", "database_table_323"."field_2674", "database_table_323"."field_2675", "database_table_323"."field_2676", "database_table_323"."field_2677", "database_table_323"."field_2678", "database_table_323"."field_2679", "database_table_323"."field_2693", "database_table_323"."field_2835", "database_table_323"."order", "database_table_323"."needs_background_update" FROM "database_table_323" WHERE NOT "database_table_323"."trashed" ORDER BY "database_table_323"."field_2672" DESC NULLS LAST, "database_table_323"."order" ASC NULLS FIRST, "database_table_323"."id" ASC NULLS FIRST LIMIT 80
[POSTGRES][2023-10-24 08:35:15] 2023-10-24 08:35:15.772 UTC [63344] baserow@baserow ERROR: failed to re-find parent key in index "pg_toast_31140_index" for split pages 5094/5095
[BACKEND][2023-10-24 08:35:15] 127.0.0.1:51612 - "GET /api/_health/ HTTP/1.1" 200
[BACKEND][2023-10-24 08:35:15] ERROR 2023-10-24 08:35:15,777 django.request.log_response:224- Internal Server Error: /api/database/rows/table/323/
[BACKEND][2023-10-24 08:35:15] Traceback (most recent call last):
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[BACKEND][2023-10-24 08:35:15] return self.cursor.execute(sql, params)
[BACKEND][2023-10-24 08:35:15] psycopg2.errors.InternalError_: failed to re-find parent key in index "pg_toast_31140_index" for split pages 5094/5095
[BACKEND][2023-10-24 08:35:15]
[BACKEND][2023-10-24 08:35:15]
[BACKEND][2023-10-24 08:35:15] The above exception was the direct cause of the following exception:
[BACKEND][2023-10-24 08:35:15]
[BACKEND][2023-10-24 08:35:15] Traceback (most recent call last):
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 486, in thread_handler
[BACKEND][2023-10-24 08:35:15] raise exc_info[1]
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/core/handlers/exception.py", line 38, in inner
[BACKEND][2023-10-24 08:35:15] response = await get_response(request)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/core/handlers/base.py", line 233, in _get_response_async
[BACKEND][2023-10-24 08:35:15] response = await wrapped_callback(request, *callback_args, **callback_kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 448, in __call__
[BACKEND][2023-10-24 08:35:15] ret = await asyncio.wait_for(future, timeout=None)
[BACKEND][2023-10-24 08:35:15] File "/usr/lib/python3.9/asyncio/tasks.py", line 442, in wait_for
[BACKEND][2023-10-24 08:35:15] return await fut
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/asgiref/current_thread_executor.py", line 22, in run
[BACKEND][2023-10-24 08:35:15] result = self.fn(*self.args, **self.kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 490, in thread_handler
[BACKEND][2023-10-24 08:35:15] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/views/decorators/csrf.py", line 54, in wrapped_view
[BACKEND][2023-10-24 08:35:15] return view_func(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/views/generic/base.py", line 70, in view
[BACKEND][2023-10-24 08:35:15] return self.dispatch(request, *args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 509, in dispatch
[BACKEND][2023-10-24 08:35:15] response = self.handle_exception(exc)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 469, in handle_exception
[BACKEND][2023-10-24 08:35:15] self.raise_uncaught_exception(exc)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 480, in raise_uncaught_exception
[BACKEND][2023-10-24 08:35:15] raise exc
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 506, in dispatch
[BACKEND][2023-10-24 08:35:15] response = handler(request, *args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/usr/lib/python3.9/contextlib.py", line 79, in inner
[BACKEND][2023-10-24 08:35:15] return func(*args, **kwds)
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/api/decorators.py", line 107, in func_wrapper
[BACKEND][2023-10-24 08:35:15] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/api/decorators.py", line 172, in func_wrapper
[BACKEND][2023-10-24 08:35:15] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/contrib/database/api/rows/views.py", line 491, in post
[BACKEND][2023-10-24 08:35:15] row = action_type_registry.get_by_type(CreateRowActionType).do(
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/contrib/database/rows/actions.py", line 73, in do
[BACKEND][2023-10-24 08:35:15] row = RowHandler().create_row(
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/core/telemetry/utils.py", line 72, in _wrapper
[BACKEND][2023-10-24 08:35:15] raise ex
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/core/telemetry/utils.py", line 68, in _wrapper
[BACKEND][2023-10-24 08:35:15] result = wrapped_func(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/contrib/database/rows/handler.py", line 715, in create_row
[BACKEND][2023-10-24 08:35:15] return self.force_create_row(
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/core/telemetry/utils.py", line 72, in _wrapper
[BACKEND][2023-10-24 08:35:15] raise ex
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/core/telemetry/utils.py", line 68, in _wrapper
[BACKEND][2023-10-24 08:35:15] result = wrapped_func(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/contrib/database/rows/handler.py", line 762, in force_create_row
[BACKEND][2023-10-24 08:35:15] instance = model.objects.create(**row_values)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/manager.py", line 85, in manager_method
[BACKEND][2023-10-24 08:35:15] return getattr(self.get_queryset(), name)(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/query.py", line 453, in create
[BACKEND][2023-10-24 08:35:15] obj.save(force_insert=True, using=self.db)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/base.py", line 739, in save
[BACKEND][2023-10-24 08:35:15] self.save_base(using=using, force_insert=force_insert,
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/base.py", line 776, in save_base
[BACKEND][2023-10-24 08:35:15] updated = self._save_table(
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/base.py", line 881, in _save_table
[BACKEND][2023-10-24 08:35:15] results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/base.py", line 919, in _do_insert
[BACKEND][2023-10-24 08:35:15] return manager._insert(
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/manager.py", line 85, in manager_method
[BACKEND][2023-10-24 08:35:15] return getattr(self.get_queryset(), name)(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/query.py", line 1270, in _insert
[BACKEND][2023-10-24 08:35:15] return query.get_compiler(using=using).execute_sql(returning_fields)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1416, in execute_sql
[BACKEND][2023-10-24 08:35:15] cursor.execute(sql, params)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 66, in execute
[BACKEND][2023-10-24 08:35:15] return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
[BACKEND][2023-10-24 08:35:15] return executor(sql, params, many, context)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[BACKEND][2023-10-24 08:35:15] return self.cursor.execute(sql, params)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
[BACKEND][2023-10-24 08:35:15] raise dj_exc_value.with_traceback(traceback) from exc_value
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[BACKEND][2023-10-24 08:35:15] return self.cursor.execute(sql, params)
[BACKEND][2023-10-24 08:35:15] django.db.utils.InternalError: failed to re-find parent key in index "pg_toast_31140_index" for split pages 5094/5095
[BACKEND][2023-10-24 08:35:15]
[BACKEND][2023-10-24 08:35:15] ERROR 2023-10-24 08:35:15,777 django.request.log_response:224- Internal Server Error: /api/database/rows/table/323/
[BACKEND][2023-10-24 08:35:15] Traceback (most recent call last):
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[BACKEND][2023-10-24 08:35:15] return self.cursor.execute(sql, params)
[BACKEND][2023-10-24 08:35:15] psycopg2.errors.InternalError_: failed to re-find parent key in index "pg_toast_31140_index" for split pages 5094/5095
[BACKEND][2023-10-24 08:35:15]
[BACKEND][2023-10-24 08:35:15]
[BACKEND][2023-10-24 08:35:15] The above exception was the direct cause of the following exception:
[BACKEND][2023-10-24 08:35:15]
[BACKEND][2023-10-24 08:35:15] Traceback (most recent call last):
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 486, in thread_handler
[BACKEND][2023-10-24 08:35:15] raise exc_info[1]
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/core/handlers/exception.py", line 38, in inner
[BACKEND][2023-10-24 08:35:15] response = await get_response(request)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/core/handlers/base.py", line 233, in _get_response_async
[BACKEND][2023-10-24 08:35:15] response = await wrapped_callback(request, *callback_args, **callback_kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 448, in __call__
[BACKEND][2023-10-24 08:35:15] ret = await asyncio.wait_for(future, timeout=None)
[BACKEND][2023-10-24 08:35:15] File "/usr/lib/python3.9/asyncio/tasks.py", line 442, in wait_for
[BACKEND][2023-10-24 08:35:15] return await fut
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/asgiref/current_thread_executor.py", line 22, in run
[BACKEND][2023-10-24 08:35:15] result = self.fn(*self.args, **self.kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 490, in thread_handler
[BACKEND][2023-10-24 08:35:15] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/views/decorators/csrf.py", line 54, in wrapped_view
[BACKEND][2023-10-24 08:35:15] return view_func(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/views/generic/base.py", line 70, in view
[BACKEND][2023-10-24 08:35:15] return self.dispatch(request, *args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 509, in dispatch
[BACKEND][2023-10-24 08:35:15] response = self.handle_exception(exc)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 469, in handle_exception
[BACKEND][2023-10-24 08:35:15] self.raise_uncaught_exception(exc)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 480, in raise_uncaught_exception
[BACKEND][2023-10-24 08:35:15] raise exc
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 506, in dispatch
[BACKEND][2023-10-24 08:35:15] response = handler(request, *args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/usr/lib/python3.9/contextlib.py", line 79, in inner
[BACKEND][2023-10-24 08:35:15] return func(*args, **kwds)
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/api/decorators.py", line 107, in func_wrapper
[BACKEND][2023-10-24 08:35:15] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/api/decorators.py", line 172, in func_wrapper
[BACKEND][2023-10-24 08:35:15] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/contrib/database/api/rows/views.py", line 491, in post
[BACKEND][2023-10-24 08:35:15] row = action_type_registry.get_by_type(CreateRowActionType).do(
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/contrib/database/rows/actions.py", line 73, in do
[BACKEND][2023-10-24 08:35:15] row = RowHandler().create_row(
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/core/telemetry/utils.py", line 72, in _wrapper
[BACKEND][2023-10-24 08:35:15] raise ex
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/core/telemetry/utils.py", line 68, in _wrapper
[BACKEND][2023-10-24 08:35:15] result = wrapped_func(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/contrib/database/rows/handler.py", line 715, in create_row
[BACKEND][2023-10-24 08:35:15] return self.force_create_row(
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/core/telemetry/utils.py", line 72, in _wrapper
[BACKEND][2023-10-24 08:35:15] raise ex
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/core/telemetry/utils.py", line 68, in _wrapper
[BACKEND][2023-10-24 08:35:15] result = wrapped_func(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/contrib/database/rows/handler.py", line 762, in force_create_row
[BACKEND][2023-10-24 08:35:15] instance = model.objects.create(**row_values)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/manager.py", line 85, in manager_method
[BACKEND][2023-10-24 08:35:15] return getattr(self.get_queryset(), name)(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/query.py", line 453, in create
[BACKEND][2023-10-24 08:35:15] obj.save(force_insert=True, using=self.db)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/base.py", line 739, in save
[BACKEND][2023-10-24 08:35:15] self.save_base(using=using, force_insert=force_insert,
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/base.py", line 776, in save_base
[BACKEND][2023-10-24 08:35:15] updated = self._save_table(
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/base.py", line 881, in _save_table
[BACKEND][2023-10-24 08:35:15] results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/base.py", line 919, in _do_insert
[BACKEND][2023-10-24 08:35:15] return manager._insert(
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/manager.py", line 85, in manager_method
[BACKEND][2023-10-24 08:35:15] return getattr(self.get_queryset(), name)(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/query.py", line 1270, in _insert
[BACKEND][2023-10-24 08:35:15] return query.get_compiler(using=using).execute_sql(returning_fields)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1416, in execute_sql
[BACKEND][2023-10-24 08:35:15] cursor.execute(sql, params)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 66, in execute
[BACKEND][2023-10-24 08:35:15] return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
[BACKEND][2023-10-24 08:35:15] return executor(sql, params, many, context)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[BACKEND][2023-10-24 08:35:15] return self.cursor.execute(sql, params)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
[BACKEND][2023-10-24 08:35:15] raise dj_exc_value.with_traceback(traceback) from exc_value
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[BACKEND][2023-10-24 08:35:15] return self.cursor.execute(sql, params)
[BACKEND][2023-10-24 08:35:15] django.db.utils.InternalError: failed to re-find parent key in index "pg_toast_31140_index" for split pages 5094/5095
[BACKEND][2023-10-24 08:35:15]
[BACKEND][2023-10-24 08:35:15] ERROR 2023-10-24 08:35:15,777 django.request.log_response:224- Internal Server Error: /api/database/rows/table/323/
[BACKEND][2023-10-24 08:35:15] Traceback (most recent call last):
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[BACKEND][2023-10-24 08:35:15] return self.cursor.execute(sql, params)
[BACKEND][2023-10-24 08:35:15] psycopg2.errors.InternalError_: failed to re-find parent key in index "pg_toast_31140_index" for split pages 5094/5095
[BACKEND][2023-10-24 08:35:15]
[BACKEND][2023-10-24 08:35:15]
[BACKEND][2023-10-24 08:35:15] The above exception was the direct cause of the following exception:
[BACKEND][2023-10-24 08:35:15]
[BACKEND][2023-10-24 08:35:15] Traceback (most recent call last):
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 486, in thread_handler
[BACKEND][2023-10-24 08:35:15] raise exc_info[1]
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/core/handlers/exception.py", line 38, in inner
[BACKEND][2023-10-24 08:35:15] response = await get_response(request)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/core/handlers/base.py", line 233, in _get_response_async
[BACKEND][2023-10-24 08:35:15] response = await wrapped_callback(request, *callback_args, **callback_kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 448, in __call__
[BACKEND][2023-10-24 08:35:15] ret = await asyncio.wait_for(future, timeout=None)
[BACKEND][2023-10-24 08:35:15] File "/usr/lib/python3.9/asyncio/tasks.py", line 442, in wait_for
[BACKEND][2023-10-24 08:35:15] return await fut
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/asgiref/current_thread_executor.py", line 22, in run
[BACKEND][2023-10-24 08:35:15] result = self.fn(*self.args, **self.kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/asgiref/sync.py", line 490, in thread_handler
[BACKEND][2023-10-24 08:35:15] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/views/decorators/csrf.py", line 54, in wrapped_view
[BACKEND][2023-10-24 08:35:15] return view_func(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/views/generic/base.py", line 70, in view
[BACKEND][2023-10-24 08:35:15] return self.dispatch(request, *args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 509, in dispatch
[BACKEND][2023-10-24 08:35:15] response = self.handle_exception(exc)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 469, in handle_exception
[BACKEND][2023-10-24 08:35:15] self.raise_uncaught_exception(exc)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 480, in raise_uncaught_exception
[BACKEND][2023-10-24 08:35:15] raise exc
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/rest_framework/views.py", line 506, in dispatch
[BACKEND][2023-10-24 08:35:15] response = handler(request, *args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/usr/lib/python3.9/contextlib.py", line 79, in inner
[BACKEND][2023-10-24 08:35:15] return func(*args, **kwds)
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/api/decorators.py", line 107, in func_wrapper
[BACKEND][2023-10-24 08:35:15] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/api/decorators.py", line 172, in func_wrapper
[BACKEND][2023-10-24 08:35:15] return func(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/contrib/database/api/rows/views.py", line 491, in post
[BACKEND][2023-10-24 08:35:15] row = action_type_registry.get_by_type(CreateRowActionType).do(
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/contrib/database/rows/actions.py", line 73, in do
[BACKEND][2023-10-24 08:35:15] row = RowHandler().create_row(
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/core/telemetry/utils.py", line 72, in _wrapper
[BACKEND][2023-10-24 08:35:15] raise ex
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/core/telemetry/utils.py", line 68, in _wrapper
[BACKEND][2023-10-24 08:35:15] result = wrapped_func(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/contrib/database/rows/handler.py", line 715, in create_row
[BACKEND][2023-10-24 08:35:15] return self.force_create_row(
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/core/telemetry/utils.py", line 72, in _wrapper
[BACKEND][2023-10-24 08:35:15] raise ex
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/core/telemetry/utils.py", line 68, in _wrapper
[BACKEND][2023-10-24 08:35:15] result = wrapped_func(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/backend/src/baserow/contrib/database/rows/handler.py", line 762, in force_create_row
[BACKEND][2023-10-24 08:35:15] instance = model.objects.create(**row_values)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/manager.py", line 85, in manager_method
[BACKEND][2023-10-24 08:35:15] return getattr(self.get_queryset(), name)(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/query.py", line 453, in create
[BACKEND][2023-10-24 08:35:15] obj.save(force_insert=True, using=self.db)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/base.py", line 739, in save
[BACKEND][2023-10-24 08:35:15] self.save_base(using=using, force_insert=force_insert,
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/base.py", line 776, in save_base
[BACKEND][2023-10-24 08:35:15] updated = self._save_table(
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/base.py", line 881, in _save_table
[BACKEND][2023-10-24 08:35:15] results = self._do_insert(cls._base_manager, using, fields, returning_fields, raw)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/base.py", line 919, in _do_insert
[BACKEND][2023-10-24 08:35:15] return manager._insert(
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/manager.py", line 85, in manager_method
[BACKEND][2023-10-24 08:35:15] return getattr(self.get_queryset(), name)(*args, **kwargs)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/query.py", line 1270, in _insert
[BACKEND][2023-10-24 08:35:15] return query.get_compiler(using=using).execute_sql(returning_fields)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/models/sql/compiler.py", line 1416, in execute_sql
[BACKEND][2023-10-24 08:35:15] cursor.execute(sql, params)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 66, in execute
[BACKEND][2023-10-24 08:35:15] return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 75, in _execute_with_wrappers
[BACKEND][2023-10-24 08:35:15] return executor(sql, params, many, context)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[BACKEND][2023-10-24 08:35:15] return self.cursor.execute(sql, params)
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/utils.py", line 90, in __exit__
[BACKEND][2023-10-24 08:35:15] raise dj_exc_value.with_traceback(traceback) from exc_value
[BACKEND][2023-10-24 08:35:15] File "/baserow/venv/lib/python3.9/site-packages/django/db/backends/utils.py", line 84, in _execute
[BACKEND][2023-10-24 08:35:15] return self.cursor.execute(sql, params)
[BACKEND][2023-10-24 08:35:15] django.db.utils.InternalError: failed to re-find parent key in index "pg_toast_31140_index" for split pages 5094/5095
[BACKEND][2023-10-24 08:35:15]
[BACKEND][2023-10-24 08:35:16] 78.202.149.100:0 - "POST /api/database/rows/table/323/?user_field_names=true HTTP/1.1" 500
[BACKEND][2023-10-24 08:35:22] 219.133.67.244:0 - "GET /api/database/rows/table/333/?user_field_names=true&filter __field_2740__ equal=C0:AF:C6:1C:28:E4&filter __field_2741__ equal=autoTestPressure&order_by=-Date&include=Date,Mac%20adresse,Test%20name,Pump&size=1 HTTP/1.1" 200
```
---
### Author:  [@Rob192](https://community.baserow.io/u/Rob192)
#### Post date: [October 24, 2023, 8:39am UTC](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573/7 "2023-10-24T08:39:14Z")
There might be something to do with this post : [Postgresql error: failed to re-find parent key in index - Database Administrators Stack Exchange](https://dba.stackexchange.com/questions/135881/postgresql-error-failed-to-re-find-parent-key-in-index)
```auto
REINDEX SYSTEM; -- run once
REINDEX DATABASE ; -- run for each database
VACUUM (FULL VERBOSE ANALYZE); -- also run for each database after reindexing
```
How can I do that with the baserow database ?
---
### Author:  [@bram](https://community.baserow.io/u/bram)
#### Post date: [October 25, 2023, 8:01am UTC](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573/8 "2023-10-25T08:01:08Z")
Hey @Rob192, I’m sorry to hear that things are not working as expected for you. I’ve looked into everything you said, and responded to your questions.
Separately, if you want to self-host Baserow worry free, I recommend looking into Cloudron ([Installation on Cloudron // Baserow](https://baserow.io/docs/installation%2Finstall-on-cloudron)). It will allow you to easily install application, Baserow as well, make backups, do automated updates, etc.
> We were making approx 1 api call per sec with a filter on the mac address on the 256k row table.
A 256k table can be quite a lot for a no-code database. The performance depends on how many fields that table, but also what kind of hardware you are running. Is there anything you can share about the type of CPU cores you’re using, how many fields you have in that table. Any insights in how your database is structured in Baserow could be useful.
> It remained stuck at 50%. I was still unable to import csv after the restart of the instance. However, after the manipulation outlined in there : Investigate, document and prevent or fix postgres database corruption when two all-in-one images run at the same time with same volume (#1524) · Issues · Baserow / baserow · GitLab 2 I was able to start again the import.
How many minutes did the import already run for? By default, background jobs can’t run longer than 30 minutes. You can try to set the `BASEROW_JOB_SOFT_TIME_LIMIT=3600` to increase it to 60 minutes.
> Regarding the error for the table 323 that I cannot reach anymore, I have the following log when I try to send data to it :
Judging from the error message, it seems like your PostgreSQL database is somehow currupted. Maybe this resource can be of use to you: [Postgres error: Missing chunk 0 for toast value in pg\_toast · GitHub](https://gist.github.com/supix/80f9a6111dc954cf38ee99b9dedf187a)?
> There might be something to do with this post : Postgresql error: failed to re-find parent key in index - Database Administrators Stack Exchange How can I do that with the baserow database ?
It depends a bit on how you’re self hosting, but this is something you would have to execute on the underlying PostgreSQL database. You would have to connect to it using a PostgreSQL client, and then execute those queries. More about that can be found here: [database - Run PostgreSQL queries from the command line - Stack Overflow](https://stackoverflow.com/questions/19674456/run-postgresql-queries-from-the-command-line).
I hope this will help you with fixing your environment.
---
### Author:  [@Rob192](https://community.baserow.io/u/Rob192)
#### Post date: [October 30, 2023, 8:52am UTC](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573/9 "2023-10-30T08:52:25Z")
> Is there anything you can share about the type of CPU cores you’re using, how many fields you have in that table. Any insights in how your database is structured in Baserow could be useful.
I am using a t2-medium instance (2 CPU, 4 GB RAM) with Ubuntu in AWS. My databases have approx 12 fields. One of them is used to store approx 100 Ko of text.
I am trying to move this data out of Baserow by doing API calls and storing the data in s3 bucket but it takes very long. Baserow often becomes “unhealthy”.
I am a bit lost in my options, when I am trying to do something it either takes for ages or does not improve the speed of my instance.
The reason I chose to self host was because I did not want to have the limitation on the number of rows. Is there a procedure to move the existing data of my instance to cloudtron ?
---
### Author:  [@bram](https://community.baserow.io/u/bram)
#### Post date: [October 30, 2023, 9:45am UTC](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573/10 "2023-10-30T09:45:38Z")
It almost seems like your server can’t handle the load. 2CPU cores and 4GB of RAM should be enough to run a table with 12 fields and 256k rows. Are there any other applications running on the same server, or do you have any resource constraints defined? I don’t have any insights in your server, but it might be worth upgrading the hardware.
- When making an API request, how long does it take for the server to respond?
- How do you know it becomes unhealthy?
- Can you share some of your access logs with me?
- What happens if you set add the following environment variables?
- `BASEROW_AMOUNT_OF_GUNICORN_WORKERS=5`
- `BASEROW_AMOUNT_OF_WORKERS=2`
There is a procedure to migrate your data from your current instance to Cloudron. Depending on whether you want to keep your data structured or not, I’d first like to know the answers to the questions above. 🙂
---
### Author:  [@Rob192](https://community.baserow.io/u/Rob192)
#### Post date: [October 30, 2023, 10:09am UTC](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573/11 "2023-10-30T10:09:27Z")
Hello Bram,
- Are there any other applications running on the same server, or do you have any resource constraints defined? → nothing else running (although I occasionally connect with vscode in ssh but remove the pid afterwards)
- When making an API request, how long does it take for the server to respond? depends, usually 1 sec but for exemple while trying to send this request:
update\_response = requests.patch(f"{API\_ENDPOINT}{row\_id}/?user\_field\_names=true",
headers=headers,
json=updated\_row\_data,
timeout=10)
the timeout is often hit!
- How do you know it becomes unhealthy? I read the docker logs and it states “[BASEROW-WATCHER][2023-10-30 02:53:28] [32mWARNING: Baserow has become unhealthy.”
This is when I launch my script to update the rows and remove data (I have a sleep time of 5 sec between patch requests!)
- Can you share some of your access logs with me? of course !
Here are some errors I recently noticed.
[POSTGRES][2023-10-30 09:51:23] 2023-10-30 09:44:47.163 UTC [87609] LOG: failed to re-find parent key in index “database\_table\_734\_trashed\_756d6321” for deletion target page 4
[POSTGRES][2023-10-30 09:51:23] 2023-10-30 09:51:23.047 UTC [88055] LOG: right sibling’s left-link doesn’t match: right sibling 30 of target 25 with leafblkno 25 and scanblkno 25 spuriously links to non-target 31 on level 0 of index “core\_action\_user\_id\_eed182ff”
[POSTGRES][2023-10-30 09:52:18] 2023-10-30 09:51:23.056 UTC [88055] LOG: no left sibling (concurrent deletion?) of block 31 in “core\_action\_user\_id\_eed182ff”
[POSTGRES][2023-10-30 09:52:18] 2023-10-30 09:52:18.901 UTC [86619] ERROR: right sibling of GIN page is of different type
[link to log](https://backupbaserow.s3.eu-west-1.amazonaws.com/logbaserow.log?response-content-disposition=inline&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKj%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMyJGMEQCICyz6W1nUmz4JcS7RxWabH03I63yvFg8zjasqRWAqt9LAiAQc0fkGG8xR%2Bt0cK2gewNzLg2eBSzLrWClDnzQs85xtCqIAwjR%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F8BEAMaDDE4NzY3NTM5Mjg4NiIMSzPIKo%2BmYx0E6E83KtwCynYbYRObGNzab9J0V6VIdlubUB0%2BqZ12P40n1jeWmgqrU%2FXXZEdGFtCVliEYbZL5NsJ2KJ1c2ijpbcAZf41EehJRfPcNuVEOOHYBX%2BmHYI1tZN%2FnxMiXfQ8oSk5bgJlkE%2BEKNM55aQ%2FuKtw1A%2BS10DM0bkgq6XAYVb%2B%2FckxBoUeLOAbxw9CuCrf%2BAIY4ednvqO%2F5JfUPoBACLjObbRg%2FrwVVNco3fyJ0b0VXNioCgeP%2BtoAmp%2FU8Sca67LrJ%2Fa9iPAVTlYBxnBfqCebRCbH1QDgHwbNKa5bx7y%2BTY88JOrgoMKyYEyzY8yQ2LK0R1rOd9XBLEap6yGZy8pltpMj4nXP503cxLuVt37GZL7mOxlV0so%2BLd7qQ0O51o42OP8XApP9P4PuhCcE8nvrG20fRbq%2FNCIzyeiHAa0rWaTMthpJgkqHgtkoqIVn5VcwnI4q7JirwjXktNMILDWwDMIfB%2FakGOrQCsjBqVQc6bztXXEjnEhy2RrDqTbrojvkcaQTN3HLqNeVi3yl6LSH2duN%2BH%2F1D10eK6MmKAzdbbiLECJjYMPtjE52HCpLDN%2BsSeM83mwLsVqKABNLEcGbpp2MyD0uhxNoytV6MsMV9h%2BtFo9xg%2FNj0XZxJte%2F5hXyVyo%2B6%2F4y44T1BGJLRavdIRUizlmhyEh4bjdJY%2B853Ydf0EshoAN5DcsDXu%2BoNr8wpOsVRO6jreaOjjavlKIYTIrzB3I%2FnrbsqmuHOU72OH04S3bGtlRUmyngCZ%2FIE2%2ByDxKNKYLkl5D0V2ReaD86kNooWEZ4Vs%2FvCuWBmAky%2FJaJhPuBnPDz0F0nyc0Uyrisnl94xZROULnYcw8CBQLidljH39oBgfd4eJKrpTeQpdMHk1smfPDComcc%2BX5Y%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20231030T100516Z&X-Amz-SignedHeaders=host&X-Amz-Expires=3600&X-Amz-Credential=ASIASXMSTHN3OSJFHCGW%2F20231030%2Feu-west-1%2Fs3%2Faws4_request&X-Amz-Signature=6bd54e2654553f1b5116bfb7ebac366e27572692b7bef7f4e4266a111b5a7865)
- What happens if you set add the following environment variables?
- `BASEROW_AMOUNT_OF_GUNICORN_WORKERS=5`
- `BASEROW_AMOUNT_OF_WORKERS=2`
→ I just changed that I will monitor !!
---
### Author:  [@Rob192](https://community.baserow.io/u/Rob192)
#### Post date: [October 30, 2023, 10:52am UTC](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573/12 "2023-10-30T10:52:00Z")
Hello ! I changed the env values but got the same issue:
[see the logs :](https://backupbaserow.s3.eu-west-1.amazonaws.com/logbaserowwithworkerconstraints.log?response-content-disposition=inline&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKj%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMyJGMEQCICyz6W1nUmz4JcS7RxWabH03I63yvFg8zjasqRWAqt9LAiAQc0fkGG8xR%2Bt0cK2gewNzLg2eBSzLrWClDnzQs85xtCqIAwjR%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F8BEAMaDDE4NzY3NTM5Mjg4NiIMSzPIKo%2BmYx0E6E83KtwCynYbYRObGNzab9J0V6VIdlubUB0%2BqZ12P40n1jeWmgqrU%2FXXZEdGFtCVliEYbZL5NsJ2KJ1c2ijpbcAZf41EehJRfPcNuVEOOHYBX%2BmHYI1tZN%2FnxMiXfQ8oSk5bgJlkE%2BEKNM55aQ%2FuKtw1A%2BS10DM0bkgq6XAYVb%2B%2FckxBoUeLOAbxw9CuCrf%2BAIY4ednvqO%2F5JfUPoBACLjObbRg%2FrwVVNco3fyJ0b0VXNioCgeP%2BtoAmp%2FU8Sca67LrJ%2Fa9iPAVTlYBxnBfqCebRCbH1QDgHwbNKa5bx7y%2BTY88JOrgoMKyYEyzY8yQ2LK0R1rOd9XBLEap6yGZy8pltpMj4nXP503cxLuVt37GZL7mOxlV0so%2BLd7qQ0O51o42OP8XApP9P4PuhCcE8nvrG20fRbq%2FNCIzyeiHAa0rWaTMthpJgkqHgtkoqIVn5VcwnI4q7JirwjXktNMILDWwDMIfB%2FakGOrQCsjBqVQc6bztXXEjnEhy2RrDqTbrojvkcaQTN3HLqNeVi3yl6LSH2duN%2BH%2F1D10eK6MmKAzdbbiLECJjYMPtjE52HCpLDN%2BsSeM83mwLsVqKABNLEcGbpp2MyD0uhxNoytV6MsMV9h%2BtFo9xg%2FNj0XZxJte%2F5hXyVyo%2B6%2F4y44T1BGJLRavdIRUizlmhyEh4bjdJY%2B853Ydf0EshoAN5DcsDXu%2BoNr8wpOsVRO6jreaOjjavlKIYTIrzB3I%2FnrbsqmuHOU72OH04S3bGtlRUmyngCZ%2FIE2%2ByDxKNKYLkl5D0V2ReaD86kNooWEZ4Vs%2FvCuWBmAky%2FJaJhPuBnPDz0F0nyc0Uyrisnl94xZROULnYcw8CBQLidljH39oBgfd4eJKrpTeQpdMHk1smfPDComcc%2BX5Y%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20231030T105118Z&X-Amz-SignedHeaders=host&X-Amz-Expires=21600&X-Amz-Credential=ASIASXMSTHN3OSJFHCGW%2F20231030%2Feu-west-1%2Fs3%2Faws4_request&X-Amz-Signature=f9d7491f4566196b82f70a45a4545fdd47eb1303145f508edaf5b5b4a39dda9e)
---
### Author:  [@bram](https://community.baserow.io/u/bram)
#### Post date: [October 30, 2023, 1:41pm UTC](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573/13 "2023-10-30T13:41:09Z")
Hey @Rob192, I think I know what might be causing your problems. Would you mind adding this environment variable: `BASEROW_USE_PG_FULLTEXT_SEARCH=false`? Since version 1.19 we’ve introduced an automatic full-text search index. You have a table with quite some rows, and after updating, Baserow tries to create the full-text search index for you in one query. This probably slows down your PostgreSQL so much that it doesn’t work anymore. I suspect it even times out, so it doesn’t complete the task.
---
### Author:  [@Rob192](https://community.baserow.io/u/Rob192)
#### Post date: [October 30, 2023, 2:15pm UTC](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573/14 "2023-10-30T14:15:50Z")
Hey @bram !
thanks a lot for your fast support 🫡
I did change that but I am still getting some PATCH requests not sent 😕
See for exemple [this log](https://backupbaserow.s3.eu-west-1.amazonaws.com/logbaserowwithouttextsearch.log?response-content-disposition=inline&X-Amz-Security-Token=IQoJb3JpZ2luX2VjEKj%2F%2F%2F%2F%2F%2F%2F%2F%2F%2FwEaCWV1LXdlc3QtMyJGMEQCICyz6W1nUmz4JcS7RxWabH03I63yvFg8zjasqRWAqt9LAiAQc0fkGG8xR%2Bt0cK2gewNzLg2eBSzLrWClDnzQs85xtCqIAwjR%2F%2F%2F%2F%2F%2F%2F%2F%2F%2F8BEAMaDDE4NzY3NTM5Mjg4NiIMSzPIKo%2BmYx0E6E83KtwCynYbYRObGNzab9J0V6VIdlubUB0%2BqZ12P40n1jeWmgqrU%2FXXZEdGFtCVliEYbZL5NsJ2KJ1c2ijpbcAZf41EehJRfPcNuVEOOHYBX%2BmHYI1tZN%2FnxMiXfQ8oSk5bgJlkE%2BEKNM55aQ%2FuKtw1A%2BS10DM0bkgq6XAYVb%2B%2FckxBoUeLOAbxw9CuCrf%2BAIY4ednvqO%2F5JfUPoBACLjObbRg%2FrwVVNco3fyJ0b0VXNioCgeP%2BtoAmp%2FU8Sca67LrJ%2Fa9iPAVTlYBxnBfqCebRCbH1QDgHwbNKa5bx7y%2BTY88JOrgoMKyYEyzY8yQ2LK0R1rOd9XBLEap6yGZy8pltpMj4nXP503cxLuVt37GZL7mOxlV0so%2BLd7qQ0O51o42OP8XApP9P4PuhCcE8nvrG20fRbq%2FNCIzyeiHAa0rWaTMthpJgkqHgtkoqIVn5VcwnI4q7JirwjXktNMILDWwDMIfB%2FakGOrQCsjBqVQc6bztXXEjnEhy2RrDqTbrojvkcaQTN3HLqNeVi3yl6LSH2duN%2BH%2F1D10eK6MmKAzdbbiLECJjYMPtjE52HCpLDN%2BsSeM83mwLsVqKABNLEcGbpp2MyD0uhxNoytV6MsMV9h%2BtFo9xg%2FNj0XZxJte%2F5hXyVyo%2B6%2F4y44T1BGJLRavdIRUizlmhyEh4bjdJY%2B853Ydf0EshoAN5DcsDXu%2BoNr8wpOsVRO6jreaOjjavlKIYTIrzB3I%2FnrbsqmuHOU72OH04S3bGtlRUmyngCZ%2FIE2%2ByDxKNKYLkl5D0V2ReaD86kNooWEZ4Vs%2FvCuWBmAky%2FJaJhPuBnPDz0F0nyc0Uyrisnl94xZROULnYcw8CBQLidljH39oBgfd4eJKrpTeQpdMHk1smfPDComcc%2BX5Y%3D&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Date=20231030T141019Z&X-Amz-SignedHeaders=host&X-Amz-Expires=21600&X-Amz-Credential=ASIASXMSTHN3OSJFHCGW%2F20231030%2Feu-west-1%2Fs3%2Faws4_request&X-Amz-Signature=d956127bc889578ebcd08e4b16e4d87fac6e3e5884e07687682522488b835c27) where the last api call I am able to successfully send is : “PATCH /api/database/rows/table/333/1006/?user\_field\_names=true HTTP/1.1”
Then I try to send “PATCH /api/database/rows/table/333/1009/?user\_field\_names=true HTTP/1.1”
but the 10s timeout of my request was triggered.
I am seeing a lot of these :
django.db.utils.InternalError: missing chunk number 32 for toast value 378150 in pg\_toast\_31140
so it may be my broken database again 🤕
---
### Author:  [@bram](https://community.baserow.io/u/bram)
#### Post date: [October 31, 2023, 11:16am UTC](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573/15 "2023-10-31T11:16:05Z")
Hey @Rob192, I’m sorry to hear that you still have corrupted database problems. Unfortunately, this is a bit outside the scope of Baserow, as that could have been caused by hardware failure, or many other unrelated things. There are a couple of things you can do:
- Reach out in a PostgreSQL community, and see if someone can help you.
- Try to dump and restore your database.
- Migrate to a different server.
- Search online for solutions to that problem.
---
### Author:  [@Rob192](https://community.baserow.io/u/Rob192)
#### Post date: [October 31, 2023, 1:13pm UTC](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573/16 "2023-10-31T13:13:30Z")
Ok @bram,
Could you please point me to the procedure to migrate your data from your current instance to Cloudron ?
thanks
---
### Author:  [@bram](https://community.baserow.io/u/bram)
#### Post date: [November 1, 2023, 1:59pm UTC](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573/17 "2023-11-01T13:59:33Z")
We don’t have a ready step-by-step procedure for this at the moment, but in your case it’s important that you can make a PostgreSQL database dump. The reason I’m asking is that your database is corrupted, and maybe this is not possible. Would you mind checking if you can do a `pg_dump` of your PostgreSQL database before I write the next steps out for you?
---
### Author:  [@Rob192](https://community.baserow.io/u/Rob192)
#### Post date: [November 7, 2023, 9:55pm UTC](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573/18 "2023-11-07T21:55:44Z")
Thanks for your answer Bram,
Yes I can do this pg\_dump !
---
### Author:  [@bram](https://community.baserow.io/u/bram)
#### Post date: [November 8, 2023, 9:45am UTC](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573/19 "2023-11-08T09:45:20Z")
That’s great, then it actually means you can actually move all your data into a Cloudron instance. This also means you don’t have to worry about your corrupted data. What I recommend doing is the following:
1. Create a pg\_dump of the PostgreSQL database of your Baserow instance. Copy the exported file to your local machine.
2. Setup a new server, and install Cloudron on it: [Cloudron - Install Cloudron](https://www.cloudron.io/get.html).
3. Install Baserow on your Cloudron server: [Baserow on Cloudron](https://www.cloudron.io/store/io.baserow.cloudronapp.html).
4. Use these instructions to import the PostgreSQL database into your Baserow instance running on Cloudron: [Import PostgresSQL - Cloudron Docs](https://docs.cloudron.io/guides/import-postgresql/).
All should then work as expected. 🚀
---
### Author:  [@Rob192](https://community.baserow.io/u/Rob192)
#### Post date: [November 27, 2023, 12:51pm UTC](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573/20 "2023-11-27T12:51:11Z")
Hello,
I managed to remove the errors in T05 with the [script you shared](https://gist.github.com/supix/80f9a6111dc954cf38ee99b9dedf187a) to find the corrupted lines
Also some issues and delays where actually coming from the long data I was storing in one column type “Long Text”. In Baserow, are you planning to add for the jsonb field type ?
[Next page](https://community.baserow.io/t/import-csv-is-stuck-in-importing/3573.md?page=2)