There are foreign key constraint or dependency on any other tables between counters table on ssg database ?

Products

• CA API Gateway

Issue/Introduction

1. I was just checking the counters table and looks like there are no foreign key constraint or dependency on any other tables. See the table desc below

mysql> desc counters;

+-------------+--------------+------+-----+---------+-------+

| Field       | Type         | Null | Key | Default | Extra |

+-------------+--------------+------+-----+---------+-------+

| goid        | binary(16)   | NO   | PRI | NULL    |       |

| countername | varchar(255) | NO   | UNI | NULL    |       |

| cnt_sec     | bigint       | YES  |     | 0       |       |

| cnt_min     | bigint       | YES  |     | 0       |       |

| cnt_hr      | bigint       | YES  |     | 0       |       |

| cnt_day     | bigint       | YES  |     | 0       |       |

| cnt_mnt     | bigint       | YES  |     | 0       |       |

| last_update | bigint       | YES  |     | 0       |       |

+-------------+--------------+------+-----+---------+-------+

8 rows in set (0.00 sec)

 

2.From the below data how do I know which policy is inserting these records?

   There Relationship between counters table and others on ssg database ?

 

mysql> select * from counters;

+------------------------------------+---------------------------------------+---------+---------+--------+---------+---------+---------------+

| goid                               | countername                           | cnt_sec | cnt_min | cnt_hr | cnt_day | cnt_mnt | last_update   |

+------------------------------------+---------------------------------------+---------+---------+--------+---------+---------+---------------+

| 0x0DD22CF0C2C515AEDITED0202995755B8 | 0fEditede-baff-41bf-bb22-Editedd669b9e  |       1 |       1 |      8 |       8 |      22 | 1655114582645 |

| 0x152B706DD4E7A9EDITED11D97D9A61A28 | deEdited3c-573c-4932-8d2b-Edited1e42df4  |       1 |       1 |    100 |     100 |    1600 | 1655355566850 |

Environment

CA API Gateway 10.x, 11.x

mysql Database 5.x

Cause

goid column is just used as a unique id for the database row. 

Resolution

1. There is not dependency between counters table and other tables. goid column is just used as a unique id for the database row.

2. Alternative to know which service is using counters table , using this statement on ssg database :

 select name from ssg.policy where xml like "%<L7p:ThroughputQuota%"; 

note : Due the policy xml have the counter id on it  , you will need to match with counter's name output that shows which policies/service are using the assertion. 

3.  Counters table could have counters records inserted from several policies , it can share the same counters between multiple policies