TLDR:
What is this arbitrary RegExp execution time limit, how long is it, and when does it apply (because it does not apply equally in all Google Apps Script contexts)? Also, why does it apply when there are already execution time limits for the entire script?
Full Post:
I have suddenly hit the error
"Error: Regular expression operation exceeded execution time limit."
in Google Apps Script. I have hit this error while running a function using a custom menu on Google sheets that I created. This makes a brief UI which requests the use to input a spreadsheet url, and then runs a function using the provided url (and spreadsheet).
I have run this function before and it worked fine, but now I am getting this regular expression time limit error. To be clear this script comes nowhere near the maximum time limit for script execution, it is only apparently that my regular expression is too long. I have determined the line with the regular expression (which runs repeatedly and is usually fine and has worked up to this point) has no obvious flaws. It is a large regular expression, but the text is not very long. It failed on a 217 character text.
Furthermore, I have discovered that the error does NOT occur, when I run the function equivalent from the Google Apps Script Editor (without the UI, which simply calls this same function from a Google Apps Script Library I created). To be clear I am certain that the variables and environment in the working execution are the same. It completed in 8 seconds, parsed the same text, and used the same regular expression.
This leads me to believe that there is an arbitrary time limit that is applied to regular expressions which applies either because the function has been called from a custom menu, the function briefly uses UI, or the function calls a library (or some combination of these).
What is this arbitrary RegExp execution time limit, how long is it, and when does it apply (because it does not apply equally in all Google Apps Script contexts)? Also, why does it apply when there are already execution time limits for the entire script?
I haven't been able to find anything mentioning this specific error/time limit/quota on Google's documentation of Google Apps Script.
To be clear, I have checked that they are using the UI script is using the correct library version (and development mode is on anyway, so it is using the most up to date version). I have also confirmed that same functions are running with the same variables via console printing so I know the only difference is how the function is being called.
Here is the RegExp that breaks the time limit in one context but no the other, if you need it for some reason:
/[\s\<\>]*\d+\s*(?:(?:l\s*f|linear\s*feet|lin\s*feet|lin\s*ft)|(?:s\s*f|square\s*feet|sq\s*\ft|sq\s*feet|sq)|(?:ea|each))(?:[\s\,]*\S+){0,7}\s*\,\s*(?:(?:(?:(?:remove|removal|(?:(?:^|\s)+rem(?:\s|\.|\:|\-|$))|(?:(?:^|\s)+rmv(?:\s|\.|\:|\-|$))))|(?:(?:encapsulate|encapsulation|(?:^|\s)+encp?(?:ap)?(?:$|\s|\.|\-|\:)+|(?:^|\s)+cap(?:$|\s|\.|\-|\:)+|(?:^|\s)+enp(?:$|\s|\.|\-|\:)+|(?:^|\s)+seal(?:$|\s|\.|\-|\:)+))|(?:enclose)))/gi
MCVE:
Here is some text it failed on in one context but not in another:
Storage and Mechanical Room 6 adjacent to Stage- 6 month AHERA 15 EA ACPFI RMV <Category: 3> Note: Middle of ceiling, 5 damaged fittings. RMV all. 0 SF Fireproofing, Enclosure, Above ceiling tiles <Category: 3> See note
To reproduce the failing context, in a Google Sheets Spreadsheet, create a custom menu using the script editor (as a document bound script), and click the "Test" button.
Container-bound Script Code:
function onOpen(e) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var ui = SpreadsheetApp.getUi();
ui.createMenu('Test Menu').addItem('Test', 'testFun').addToUi();
}
function testFun() {
var regExp = /[\s\<\>]*\d+\s*(?:(?:l\s*f|linear\s*feet|lin\s*feet|lin\s*ft)|(?:s\s*f|square\s*feet|sq\s*\ft|sq\s*feet|sq)|(?:ea|each))(?:[\s\,]*\S+){0,7}\s*\,\s*(?:(?:(?:(?:remove|removal|(?:(?:^|\s)+rem(?:\s|\.|\:|\-|$))|(?:(?:^|\s)+rmv(?:\s|\.|\:|\-|$))))|(?:(?:encapsulate|encapsulation|(?:^|\s)+encp?(?:ap)?(?:$|\s|\.|\-|\:)+|(?:^|\s)+cap(?:$|\s|\.|\-|\:)+|(?:^|\s)+enp(?:$|\s|\.|\-|\:)+|(?:^|\s)+seal(?:$|\s|\.|\-|\:)+))|(?:enclose)))/gi;
var text = 'Storage and Mechanical Room 6 adjacent to Stage- 6 month AHERA 15 EA ACPFI RMV <Category: 3> Note: Middle of ceiling, 5 damaged fittings. RMV all. 0 SF Fireproofing, Enclosure, Above ceiling tiles <Category: 3> See note';
text.match(regExp);
Logger.log('This line will not be reached because of error');
}
It also fails when running testFun() from the container-bound script in the script editor.
To reproduce the successful execution context, create a standalone google apps script (not from the spreadsheet) and run testFun() in the script editor.
Standalone Script Code:
function testFun() {
var regExp = /[\s\<\>]*\d+\s*(?:(?:l\s*f|linear\s*feet|lin\s*feet|lin\s*ft)|(?:s\s*f|square\s*feet|sq\s*\ft|sq\s*feet|sq)|(?:ea|each))(?:[\s\,]*\S+){0,7}\s*\,\s*(?:(?:(?:(?:remove|removal|(?:(?:^|\s)+rem(?:\s|\.|\:|\-|$))|(?:(?:^|\s)+rmv(?:\s|\.|\:|\-|$))))|(?:(?:encapsulate|encapsulation|(?:^|\s)+encp?(?:ap)?(?:$|\s|\.|\-|\:)+|(?:^|\s)+cap(?:$|\s|\.|\-|\:)+|(?:^|\s)+enp(?:$|\s|\.|\-|\:)+|(?:^|\s)+seal(?:$|\s|\.|\-|\:)+))|(?:enclose)))/gi;
var text = 'Storage and Mechanical Room 6 adjacent to Stage- 6 month AHERA 15 EA ACPFI RMV <Category: 3> Note: Middle of ceiling, 5 damaged fittings. RMV all. 0 SF Fireproofing, Enclosure, Above ceiling tiles <Category: 3> See note';
text.match(regExp);
Logger.log('This line will be successfully reached');
}
