-
Notifications
You must be signed in to change notification settings - Fork 190
[BUG] Some queries failing with code 500: all shards failed | Failed to compile inline script #273
Copy link
Copy link
Closed as not planned
Closed as not planned
Copy link
Labels
enhancementNew feature or requestNew feature or requesttdvtTableau test frameworkTableau test framework
Description
Describe the bug
I started TDVT test suite using JDBC driver 5 times and got 5 different results:
test-1 315 passed
test-2 312 passed
test-3 311
test-4 321
test-5 251
To Reproduce
Steps to reproduce the behavior:
- Install TDVT, see links: one, two, three.
- Unpack connector to
C:\Users\%username%\Documents\My Tableau Repository\Connectors - Launch an instance of OpenSearch
- Load test data into it using files in test-tables.zip
- Create tds files as it described in links above or use attached ones: tds.zip. Note, they works only with OS running on http://localhost:9200 without authentication
- Run tests:
python -m tdvt.tdvt run OpenSearchfew times
Expected result
Tests would produce the same result all times
Actual result
214 tests failed at the 5th run with the following error:
Shard[0]: GeneralScriptException[Failed to compile inline script [rO0ABXNyADRvcmcub3B ... <omitted>] using lang [opensearch_query_expression]]; nested: CircuitBreakingException[[script] Too many dynamic script compilations within, max: [75/5m]; please use indexed, or scripts with parameters instead; this limit can be changed by the [script.context.aggs.max_compilations_rate] setting];\n\nFor more details, please send request for Json format to see the raw response from OpenSearch engine.
Additional context
The connector forces driver to produce log at %temp%\TableauTemp\jdbc-driver-log.txt
See logs attached:
test-5.zip
test-1.zip
test-2.zip
test-3.zip
test-4.zip
tests-3-4-5-result-compare.csv
test-5-jdbc-driver-log.txt
test-5-part-of-server-log.txt
Reactions are currently unavailable
Metadata
Metadata
Assignees
Labels
enhancementNew feature or requestNew feature or requesttdvtTableau test frameworkTableau test framework