Bug ID 756737: Decrease grooming interval for stats agent installation tasks

Last Modified: Nov 22, 2021

Bug Tracker

Affected Product:  See more info
BIG-IQ Platform(all modules)

Fixed In:
7.0.0

Opened: Jan 28, 2019
Severity: 3-Major

Symptoms

Logs include many info messages: [INFO]...[/shared/index/config StorageQueryWorker] toku failed sorting query '$orderby=lastUpdateMicros+desc&kind=cm:shared:stats-mgmt:agent-install-and-config-task:agentinstallandconfigtaskstate&parentContext... sending to legacy indexer (Query failed with error code 10128 and error message 'too much data for sort() with no index. add an index or specify a smaller limit' on server localhost:27017)

Impact

If there are a number of BIG-IP systems under management, this historical data might grow too large for the database to sort correctly. There might be database errors, log errors, CPU/memory pressure.

Conditions

Old task data retained in database.

Workaround

None.

Fix Information

Refined interval to a smaller value to prevent this from occurring.

Behavior Change