Import timed out after 60 seconds

App Building
1

I’m trying to execute a “Bulk upsert via a primary key” on a PostgreSQL and I get a timeout after 60 seconds even if I change Query Timing - query time out params to a higher number.
It is basically a CSV import with about 300 lines.
The column used as PK is not the table’s PK but a indexed column.
Error:
Import timed out after 60 seconds or
ROLLBACK - Client has encountered a connection error and is not queryable
Any idea how to solve this?

1 Like
2

I wonder what retool is doing under the hood. Is it using upsert (INSERT INTO table_name(column_list) VALUES(value_list) ON CONFLICT target action;)?

3

Instead of using “Bulk upsert” query I simply generated a string with INSERT ... ON CONFLICT DO UPDATE. Running this generated query directly against the database it takes about half second for 300 rows.
It may be a space for improvement in the future

1 Like
4

Thank you for sharing your workaround! It is an odd reaction to using the indexed column in place of the PK.

5

The data set that is getting uploaded, is that actually an uploaded CSV somehow?

6

The data set that is getting uploaded, is that actually an uploaded CSV somehow?
I’m using File Picker component to upload the CSV and parse it

7

I ran into this same issue. Is there a way to dynamically generate the string (based on the results of a query, for example)?

8