Hello Team,
I found the KB Article ID: 406236 which describes for only service_metrics and service_metrics_details tables.
This case includes not only the two tables, but also other tables.
What is a solution for this case?
Regards,
MARUBUN
=====================================================
Hello Team,
Could you reply any response?
Please let me know if I should create a case.
Thanks,
MARUBUN
======================================
Hello Team,
- Product: CA API Gateway v11.1.2 upgraded from 11.0
- MySQL: Multi-AZ Amazon RDS for MySQL 8.4.5 upgraded from 8.0.40
- Issue
After upgrading API Gateway in a production environment, we are facing the following warning in MySQL.
[Warning] [MY-015116] [Server] Background histogram update on
otk_db.oauth_initiate: Lock wait timeout exceeded; try restarting transaction
[Warning] [MY-015116] [Server] Background histogram update on
otk_db.oauth_token: Lock wait timeout exceeded; try restarting transaction
[Warning] [MY-015116] [Server] Background histogram update on
ssg.cluster_info: Lock wait timeout exceeded; try restarting transaction
[Warning] [MY-015116] [Server] Background histogram update on
ssg.cluster_master: Lock wait timeout exceeded; try restarting transaction
[Warning] [MY-015116] [Server] Background histogram update on
ssg.service_metrics: Lock wait timeout exceeded; try restarting transaction
[Warning] [MY-015116] [Server] Background histogram update on
ssg.service_metrics_details: Lock wait timeout exceeded; try restarting transaction
[Warning] [MY-015116] [Server] Background histogram update on
ssg.service_usage: Lock wait timeout exceeded; try restarting transaction
What is a solution to solve the above warning?
Please let me know if you have any document for this issue.
Regards,
MARUBUN