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

Last Modified: Apr 28, 2025

Affected Product(s):
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

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips