[Bug]: FilePicker - Remove upload xlsx file with macros makes all queries slow

[honeybifredriklofstedt]

Is there an existing issue for this?

• I have searched the existing issues

Description

I have created a file upload application that pare an uploaded excel file and insert rows into a database table followed by code to start a job in backend. This works fine but when the user clears the FilePicker component and upload an other file all subsequent queries becomes a lot slower. An extra 30 seconds are added before and after every query. When user refresh the page, things starts to work well again.

Steps To Reproduce

1. create a we page with FilePicker component : Any File, Array of objects
2. create two queries to a database
3. For event FilePicker onFilesSelected call a js object function that fist call query 1 and .then call query 2
4. add a button to the page and call same object function as in step 3 onClick event
   Now:
5. With the app, upload the xlsm file in attached zip-file
   Planning Lokal.xlsm.zip
6. Notice that queries run fast
7. Click on button and queries should still run fast.
8. Click on File picker and remove file that was uploaded
9. Click on button to run queries, notice long time before and after each query

Public Sample App

No response

Environment

Production

Severity

Critical (Broken Production apps)

Issue video log

No response

Version

Self hosted 1.46.1

[honeybifredriklofstedt]

Hi,
Anything new on this?

[sneha122]

@honeybifredriklofstedt Thank you for reporting this issue! Is it possible for you to share the console error if any that indicates why queries might be slow after removing file? If you can attach a video explaining the problem with dev tools console open, that would also be very helpful in debugging the issue further.

[honeybifredriklofstedt]

Can you please test it on your side instead.