I have a table with 65k records that contains several formula fields with lookup formulas to other tables.
I can’t manage to delete these formula fields (getting error 502 with code: ef0ed2a.js:2)
It’s quite a bummer because I also get timeout errors as soon as I try to edit the lookedup fields in the other tables.
I’ve tried editing the formulas to remove the lookups but I am getting the same errors.
What’s the best way to proceed to delete these fields?
Thank you!
Using Baserow self-hosted on Cloudron with the latest update and enough risk space + enough memory given to Postgresql.
Hey @gabrielle, I’m sorry to hear that you’re running into problems. It sounds like the API request to update or delete a field, is timing out. What are the server specifications you’re running Baserow on? It would also be useful to know how much of that is assigned to Baserow in Cloudron.
How many API requests are being made to Baserow? We’ve seen situations with other users where many update row API requests are being made, causing rows to be locked in the PostgreSQL database, and preventing certain fields from being updated within the maximum time.
2 Core “Intel(R) Xeon(R) Platinum 8259CL CPU @ 2.50GHz”
4.04 GB RAM & 4.03 GB Swap
Do you need more info?
Regarding the API calls requests, right now it’s very few from external sources (max 100/day).
If asking Baserow to delete a field that is referenced in many tables and records through lookups and formulas effectively means making API calls to every “cell” the values are referenced, it’s +100k.
I’d love to understand the constraints of the system as it would help me plan better in terms of data architecture.
Is it bad practice to reference a value in many locations? How many is too many?
If it’s just a 100 API requests per day, then that should definitely not be a problem. If it was 10 per second, then it could have been a problem, but that’s too far off.
Can you share how the resources of your Baserow app in Cloudron are allocated? That can be found under this tab:
Can you also provide me with the output logs Baserow, and an export of the structure of your database? This can be made by going to your workspace homepage, click on the workspace name, export, and then make sure it doesn’t export your data because we don’t need that.
