Self Hosted. Can't import Airtable base

I cant import base from AirTable
in 42% importing this error:

Same base success imported in host version.

There is docker-compose logs:
celery-export-worker_1 | [2022-12-25 15:51:32,449: ERROR/ForkPoolWorker-1] Task[f9225aa8-b89a-42a7-b3e9-493197e26c43] raised unexpected: KeyError(43)
celery-export-worker_1 | Traceback (most recent call last):
celery-export-worker_1 | File “/baserow/venv/lib/python3.9/site-packages/celery/app/”, line 451, in trace_task
celery-export-worker_1 | R = retval = fun(*args, **kwargs)
celery-export-worker_1 | File “/baserow/venv/lib/python3.9/site-packages/celery/app/”, line 734, in protected_call
celery-export-worker_1 | return*args, **kwargs)
celery-export-worker_1 | File “/baserow/backend/src/baserow/core/jobs/”, line 73, in run_async_job
celery-export-worker_1 | raise e
celery-export-worker_1 | File “/baserow/backend/src/baserow/core/jobs/”, line 36, in run_async_job
celery-export-worker_1 | JobHandler().run(job)
celery-export-worker_1 | File “/baserow/backend/src/baserow/core/jobs/”, line 62, in run
celery-export-worker_1 | return, progress)
celery-export-worker_1 | File “/baserow/backend/src/baserow/contrib/database/airtable/”, line 118, in run
celery-export-worker_1 | databases, id_mapping = AirtableHandler.import_from_airtable_to_group(
celery-export-worker_1 | File “/baserow/backend/src/baserow/contrib/database/airtable/”, line 609, in import_from_airtable_to_group
celery-export-worker_1 | databases, id_mapping = CoreHandler().import_applications_to_group(
celery-export-worker_1 | File “/baserow/backend/src/baserow/core/”, line 1344, in import_applications_to_group
celery-export-worker_1 | imported_application = application_type.import_serialized(
celery-export-worker_1 | File “/baserow/backend/src/baserow/contrib/database/”, line 445, in import_serialized
celery-export-worker_1 | self.import_tables_serialized(
celery-export-worker_1 | File “/baserow/backend/src/baserow/contrib/database/”, line 289, in import_tables_serialized
celery-export-worker_1 | view_type.import_serialized(
celery-export-worker_1 | File “/baserow/backend/src/baserow/contrib/database/views/”, line 131, in import_serialized
celery-export-worker_1 | grid_view = super().import_serialized(
celery-export-worker_1 | File “/baserow/backend/src/baserow/contrib/database/views/”, line 346, in import_serialized
celery-export-worker_1 | value_provider_type.set_import_serialized_value(
celery-export-worker_1 | File “/baserow/premium/backend/src/baserow_premium/views/”, line 127, in set_import_serialized_value
celery-export-worker_1 | new_field_id = id_mapping[“database_fields”][filter[“field”]]
celery-export-worker_1 | KeyError: 43

How many records and columns do you have? It looks like it is an issue with a column so maybe a type has been set that isn’t right or something.

I have many row and colomns. But same base was normaly import in standart host

That is odd, it may still be useful to know though as the error does seem to point towards a key.

Does it fail with other Airtable bases?

Hi @twicros, which version of Baserow are you self-hosting? The error seems like field id mapping error. I know we had some problems with that in the past, but it has all been fixed since. Could it be that you’re running an older version of Baserow? If so, then upgrading to the latest version will probably fix it.

My version is actual. I find reason.

I just run much faster server. 4 core CPU and 8 GB RAM. And it start working normaly. Thank you for your help!

That is interesting to hear, thanks for coming back with a solution. Would still be interested in knowing how many rows and columns just to get a rough benchmark feel on it.

Glad to hear that it now works @twicros!

1 Like

50 000 rows
~ 150 columns