Our team has an internal tool which was working as normal, but is now showing an error for any Firebase Firestore Raw Mode queries. Any Firebase Firestore Raw Mode query I make in old or new tools is returning "The code terminated for an unknown reason. Potentially, the memory limit 256 Mibs was breached.".
Recreating the query in GUI mode is successful. No changes have been made to the tool. The last known successful use of this query from our audit logs was at 2025-01-29T21:08:11.466Z. As GUI mode works, utilizing the resource outside of Retool works, and everything worked up until this afternoon I am really hoping the Retool team has a solution to help out here as this is a critical internal tool.
Hi @Jack_T - Yes I am! This started happening on July 30th without any changes on our end. We had to switch all of our functions back to GUI mode and then they worked.
However, there are performance gains from using RAW mode so that is our preference.
Just got some details and a potential explanation back from the engineering team.
They told me that "If the number of documents being returned by that query has increased over time then they could have started hitting the memory limit without any changes in our code or their query. They'll have to break it up into smaller paginated queries. "
I asked them about how GUI mode differs from Raw mode and they told me that " GUI mode does not have any memory limits. The reason is that in 'Raw' mode we are executing arbitrary user code and in GUI mode we are not. So in 'Raw' mode we use a code execution sandbox for security and that sandbox has hard memory limits."
Given this info, I would recommend if you want to run Raw queries that you use pagination. And if you want to avoid memory limit issues to continue to use the GUI mode.
Apologies for the inconvenience and hope this helps!
