We are using firestore and we have our retool pages for couple of months. Today we started getting The code terminated for an unknown reason. Potentially, the memory limit 256 Mibs was breached. for our firestore queries, and the error is not consistent. Im running one particular firestore query, and it returns this error 9 of the 10 runs, so in some cases it returns the requested value.
Today google cloud functions made node-18 deprecated and requests node-20, I dont know if thats related, and if retool needs to update their firebase-admin SDK accordingly.
EDIT: We have noticed this issue only occurs in the firestore queries with Raw mode. Other firestore queries with GUI mode works just fine. I'm thinking this about the memory allocation for the functions with "raw mode" firestore queries. We didnt change anything in these queries for a long time, and firestore works fine when GUI mode is used. So certainly retool changed something in the back, and a fix is needed urgently
Here is the query working (1 in 10 times):
Here is the error we get often, starting this morning (at least we noticed this issue couple of hours ago):
