hit "temp file size exceeded limit" in Capella n1ql tests

In our Capella run using 7.1.4 MP3 build, we hit the issue. We will collect logs and upload them.

{{Function: n1ql_query, error: <RC=0xCD[LCB_ERR_INTERNAL_SERVER_FAILURE (205)], HTTP Request failed. Examine 'objextra' for full result, Results=1, C Source=(src/pycbc_http.c,203), OBJ=ViewResult<rc=0xCD[LCB_ERR_INTERNAL_SERVER_FAILURE (205)], value={'requestID': '65935e55-acda-48d5-853b-f737f75df7bd', 'clientContextID': 'f3fb540d8c3424db', 'signature':

Unknown macro: {'*'}

, 'results': [], 'errors': [{'code': 5000, 'msg': '"65935e55-acda-48d5-853b-f737f75df7bd" temp file size exceeded limit 5120, 5485 - cause: "65935e55-acda-48d5-853b-f737f75df7bd" temp file size exceeded limit 5120, 5485'},

Unknown macro: {'code'}

], 'status': 'errors', 'profile': {'phaseTimes':

Unknown macro: {'authorize'}

, 'phaseCounts': {'fetch': 127044, 'filter': 127044, 'indexScan': 127044, 'sort': 127169}, 'phaseOperators': {'authorize': 1, 'fetch': 1, 'filter': 1, 'indexScan': 1, 'project': 1, 'sort': 2, 'stream': 1}, 'requestTime': '2023-05-08T02:44:29.349Z', 'servicingHost': 'svc-qi-node-007.wtojndtbkrqm-k4d.sandbox.nonprod-project-avengers.com:8091', 'executionTimings': {'#operator': 'Authorize', '#stats':

Unknown macro: {'#phaseSwitches'}

, 'privileges': {'List': [

Unknown macro: {'Target'}

]}, '~child': {'#operator': 'Sequence', '#stats':

Unknown macro: {'#phaseSwitches'}

, '~children': [{'#operator': 'IndexScan3', '#stats':

Unknown macro: {'#heartbeatYields'}

, 'as': 'b', 'bucket': 'bucket-1', 'index': 'views_partitioned_uid', 'index_id': '7995d1ab12ce79a0', 'index_partition_by': '[`uid`]', 'index_projection': {'primary_key': True}, 'keyspace': 'views', 'namespace': 'default', 'scope': 'users', 'spans': [{'exact': True, 'range': [

Unknown macro: {'inclusion'}

]}], 'using': 'gsi'}, {'#operator': 'Fetch', '#stats':

Unknown macro: {'#heartbeatYields'}

, 'as': 'b', 'bucket': 'bucket-1', 'keyspace': 'views', 'namespace': 'default', 'scope': 'users'}, {'#operator': 'Sequence', '#stats':

Unknown macro: {'#phaseSwitches'}

, '~children': [{'#operator': 'Filter', '#stats':

Unknown macro: {'#heartbeatYields'}

, 'condition': '($1 <= (`b`.`uid`))'}, {'#operator': 'InitialProject', '#stats':

Unknown macro: {'#itemsIn'}

, 'result_terms': [\{'expr': 'self', 'star': True}]}]}, {'#operator': 'Order', '#stats':

Unknown macro: {'#itemsIn'}

, 'limit': '125', 'sort_terms': [\{'expr': '(`b`.`uid`)'}, \{'desc': '"desc"', 'expr': '(`b`.`swipe_date`)'}]}, {'#operator': 'Limit', '#stats':

Unknown macro: {'#itemsIn'}

, 'expr': '125'}, {'#operator': 'Stream', '#stats': {'#itemsIn': 125, '#itemsOut': 125, '#phaseSwitches': 254, 'execTime': '517.1µs', 'kernTime': '34.28102905s'}}]}, '~versions': ['7.1.4-N1QL', '7.1.4-3632-enterprise']}}, 'controls': {'positionalArgs': ['79b22ada-8c23-4649-a92e-73ea020120e7'], 'scan_consistency': 'unbounded', 'use_cbo': 'true', 'n1ql_feat_ctrl': '76', 'stmtType': 'SELECT'}}, http_status=0, tracing_context=0, tracing_output=None>, Context={'first_error_code': 5000, 'http_response_code': 200, 'first_error_message': '"65935e55-acda-48d5-853b-f737f75df7bd" temp file size exceeded limit 5120, 5485 - cause: "65935e55-acda-48d5-853b-f737f75df7bd" temp file size exceeded limit 5120, 5485', 'statement': 'SELECT * FROM `bucket-1`.`users`.`views` AS b WHERE uid >= $1 ORDER BY uid, swipe_date DESC LIMIT 125;', 'client_context_id': 'f3fb540d8c3424db', 'query_params': '', 'http_response_body': '', 'endpoint': 'svc-qi-node-007.wtojndtbkrqm-k4d.sandbox.nonprod-project-avengers.com:18093', 'type': 'QueryErrorContext', 'error_response_body': {'errors': [

Unknown macro: {'code'}

,

Unknown macro: {'code'}

]}}, Tracing Output={":nokey:0": null}>}}