Network Error - Can no longer access table

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

SaaS

What are the exact steps to reproduce this issue?

Context:

This table shows sales data, with some information linked to the product table using a product code.

As I am unable to update this table using a CSV import, I have to delete all the rows on and import a new CSV of sales data each week. And I use a formula to automatically link the product code back to the product information table.

Steps:

I had some CSV errors on import, with no context of what the error was (just that I didn’t import), so I edited the CSV file down to the rows with errors and tried to re-import it

The next import seemed to work, but now there were multiple rows with the same product code.

So I used the group function to group product codes together to show duplicates, and it seemed to work for a few seconds, and then the loading of the table stopped.

Subsequent attempts to reload the table gives me the following error screens in Safari and Chrome.

Attach screenshots, videos, or logs that demonstrate the issue.


Hi!

Can you DM me ID of the table (or URL on which you’re experiencing the problem)?

Hey @Derek, I was able to figure out which table this is related to, I don’t see anything out of the ordinary. We’re going to look into why this is happening.

It looks like there a performance related to the group by that you have applied on the Link to the Products table. Without the group it’s working fine, but with, the loading time increases significantly.

Hey @Derek, thank you for reporting this problem. We’ve implemented a fix for the performance bug here Improved group by ManyToMany performance by using CTE (!3441) · Merge requests · Baserow / baserow · GitLab. It’s expected that the fix is deployed later this week. Once that’s done, you should be able to use your table in combination with the group again.

Awesome, thanks Bram!

Hey @Derek, I wanted to let you know that we just deployed the performance fix to baserow.io. Would you mind letting me know if you can access the table now?

Hi Bram, yes, I can access the table now - thank you for fixing it.

Glad to hear that it’s working!