Side Effect of the ERROR: index row size 2784 exceeds maximum 2712 for index "appmap_id_mappings_idx
Article ID: 127095
Updated On:
Products
CA Application Performance Management Agent (APM / Wily / Introscope)
INTROSCOPE
Issue/Introduction
Continuously see the below errors in the logs of APM postgres DB.
[92527-cemdb-admin-2019-01-30 11:48:56.113 UTC]ERROR: index row size 2784 exceeds maximum 2712 for index "appmap_id_mappings_idx"
[92527-cemdb-admin-2019-01-30 11:48:56.113 UTC]HINT: Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text indexing.
[92527-cemdb-admin-2019-01-30 11:48:56.113 UTC]STATEMENT: INSERT INTO appmap_id_mappings (vertex_id, external_id, type) VALUES ($1, $2, $3)
What is the impact of this ERROR: index row size 2784 exceeds maximum 2712 for index "appmap_id_mappings_idx"?
[92527-cemdb-admin-2019-01-30 11:48:56.113 UTC]ERROR: index row size 2784 exceeds maximum 2712 for index "appmap_id_mappings_idx"
[92527-cemdb-admin-2019-01-30 11:48:56.113 UTC]HINT: Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use full text indexing.
[92527-cemdb-admin-2019-01-30 11:48:56.113 UTC]STATEMENT: INSERT INTO appmap_id_mappings (vertex_id, external_id, type) VALUES ($1, $2, $3)
What is the impact of this ERROR: index row size 2784 exceeds maximum 2712 for index "appmap_id_mappings_idx"?
Environment
CA APM 10.5.2
Resolution
Per Engineering, there are chances that may hit the DB performance as we are not able to do indexing on most of external_ids
Additional Information
This issue has been fixed in 10.7 by limiting the external_id to max 2048
Upgrade to CA APM 10.7
Or
Contact Broadcom Support to obtain a fix for CA APM 10.5.2
Upgrade to CA APM 10.7
Or
Contact Broadcom Support to obtain a fix for CA APM 10.5.2
Feedback
Yes
No
Powered by
