Failing ES Promotion: dashboard Reporting Download CSV Field Formatters and Scripted Fields Download CSV export of a saved search panel #96000
Description
The latest 8.0 and 7.x ES snapshots are failing when trying to create CSV exports with the following:
https://kibana-ci.elastic.co/job/elasticsearch+snapshots+verify/2533/execution/node/539/log/
[00:14:17] │ proc [kibana] log [20:53:50.132] [error][csv_searchsource_immediate][csv_searchsource_immediate][execute-job][plugins][reporting] KbnServerError: search_phase_execution_exception
[00:14:17] │ proc [kibana] at getKbnServerError (/dev/shm/workspace/kibana-build-xpack-23/src/plugins/kibana_utils/server/report_server_error.js:39:10)
[00:14:17] │ proc [kibana] at search (/dev/shm/workspace/kibana-build-xpack-23/src/plugins/data/server/search/es_search/es_search_strategy.js:62:45)
[00:14:17] │ proc [kibana] at runMicrotasks (<anonymous>)
[00:14:17] │ proc [kibana] at processTicksAndRejections (internal/process/task_queues.js:93:5) {
[00:14:17] │ proc [kibana] statusCode: 500,
[00:14:17] │ proc [kibana] errBody: {
[00:14:17] │ proc [kibana] error: {
[00:14:17] │ proc [kibana] root_cause: [Array],
[00:14:17] │ proc [kibana] type: 'search_phase_execution_exception',
[00:14:17] │ proc [kibana] reason: 'all shards failed',
[00:14:17] │ proc [kibana] phase: 'query',
[00:14:17] │ proc [kibana] grouped: true,
[00:14:17] │ proc [kibana] failed_shards: [Array],
[00:14:17] │ proc [kibana] caused_by: [Object]
[00:14:17] │ proc [kibana] },
[00:14:17] │ proc [kibana] status: 500
[00:14:17] │ proc [kibana] }
[00:14:17] │ proc [kibana] }
[00:14:17] │ proc [kibana] log [20:53:50.134] [warning][csv_searchsource_immediate][csv_searchsource_immediate][execute-job][plugins][reporting] No scrollId to clear!
[00:14:17] │ proc [kibana] log [20:53:50.135] [error][csv_searchsource_immediate][plugins][reporting] {"root_cause":[{"type":"unsupported_operation_exception","reason":"Cannot fetch values for internal field [_id]."}],"type":"search_phase_execution_exception","reason":"all shards failed","phase":"query","grouped":true,"failed_shards":[{"shard":0,"index":"babynames","node":"bZwEE_drSSCw4MQs9a0HHg","reason":{"type":"unsupported_operation_exception","reason":"Cannot fetch values for internal field [_id]."}}],"caused_by":{"type":"unsupported_operation_exception","reason":"Cannot fetch values for internal field [_id].","caused_by":{"type":"unsupported_operation_exception","reason":"Cannot fetch values for internal field [_id]."}}}
[00:14:17] │ proc [kibana] log [20:53:50.135] [error][http] {"root_cause":[{"type":"unsupported_operation_exception","reason":"Cannot fetch values for internal field [_id]."}],"type":"search_phase_execution_exception","reason":"all shards failed","phase":"query","grouped":true,"failed_shards":[{"shard":0,"index":"babynames","node":"bZwEE_drSSCw4MQs9a0HHg","reason":{"type":"unsupported_operation_exception","reason":"Cannot fetch values for internal field [_id]."}}],"caused_by":{"type":"unsupported_operation_exception","reason":"Cannot fetch values for internal field [_id].","caused_by":{"type":"unsupported_operation_exception","reason":"Cannot fetch values for internal field [_id]."}}}
[00:14:17] │ proc [kibana] Sending error to Elastic APM { id: '5b4b81450e2ea5e89f5b54af73bda3b6' }
[00:14:17] │ proc [kibana] error [20:53:50.014] Error: Internal Server Error
[00:14:17] │ proc [kibana] at HapiResponseAdapter.toInternalError (/dev/shm/workspace/kibana-build-xpack-23/src/core/server/http/router/response_adapter.js:61:19)
[00:14:17] │ proc [kibana] at Router.handle (/dev/shm/workspace/kibana-build-xpack-23/src/core/server/http/router/router.js:177:34)
[00:14:17] │ proc [kibana] at runMicrotasks (<anonymous>)
[00:14:17] │ proc [kibana] at processTicksAndRejections (internal/process/task_queues.js:93:5)
[00:14:17] │ proc [kibana] at handler (/dev/shm/workspace/kibana-build-xpack-23/src/core/server/http/router/router.js:124:50)
[00:14:17] │ proc [kibana] at exports.Manager.execute (/dev/shm/workspace/kibana-build-xpack-23/node_modules/@hapi/hapi/lib/toolkit.js:60:28)
[00:14:17] │ proc [kibana] at Object.internals.handler (/dev/shm/workspace/kibana-build-xpack-23/node_modules/@hapi/hapi/lib/handler.js:46:20)
[00:14:17] │ proc [kibana] at exports.execute (/dev/shm/workspace/kibana-build-xpack-23/node_modules/@hapi/hapi/lib/handler.js:31:20)
[00:14:17] │ proc [kibana] at Request._lifecycle (/dev/shm/workspace/kibana-build-xpack-23/node_modules/@hapi/hapi/lib/request.js:370:32)
[00:14:17] │ proc [kibana] at Request._execute (/dev/shm/workspace/kibana-build-xpack-23/node_modules/@hapi/hapi/lib/request.js:279:9)
[00:14:17] │ proc [kibana] Sending error to Elastic APM { id: '545f180f37e55716b988c7b00706fc2a' }
It's unclear which change in ES is causing this error but it's consistent across both versions so I'm pretty.
Skipped