# PMM Query Analytics does not add new awsRDS instances

**URL:** <https://forums.percona.com/t/pmm-query-analytics-does-not-add-new-awsrds-instances/8458>\
**Category:** PMM 2.x\
**Created:** [December 29, 2020, 11:23am UTC](https://forums.percona.com/t/pmm-query-analytics-does-not-add-new-awsrds-instances/8458 "2020-12-29T11:23:35Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![NazarD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nazard/32/2423_2.png) [@NazarD](https://forums.percona.com/u/NazarD)\
**Post date:** [December 29, 2020, 11:23am UTC](https://forums.percona.com/t/pmm-query-analytics-does-not-add-new-awsrds-instances/8458/1 "2020-12-29T11:23:35Z")

</div>

PMM instalation from AWS IAM

after add new aws rds instance ( pmm - pmm add instance ) they displayed in the home dashboard ( with all metrics ) but not added to PMM QA.

 ![зображення.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/1X/469658a729e7e17b41208a1353923ccbeb335cdf.png)

 ![зображення.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/1X/50afe0c71163ee135d6a6a3294703028e721249f.png)

 ![зображення.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/1X/be4a5eb4c03ac197c0ce7729bf854726c1ee62a9.png)

 ![зображення.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/1X/09939f088f60b38e985fcf01f881680a5255afa7.png)

![зображення.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/1X/e956a6696c04c2f133d8f2b3a7fba877d325065a.png)

Can you assist ?

---

<div class="post-metadata">

**Author:** ![NazarD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nazard/32/2423_2.png) [@NazarD](https://forums.percona.com/u/NazarD)\
**Post date:** [December 29, 2020, 11:26am UTC](https://forums.percona.com/t/pmm-query-analytics-does-not-add-new-awsrds-instances/8458/2 "2020-12-29T11:26:04Z")

</div>

also try to add with mysql - pmm user and aws rds db super-user = the result is the same

---

<div class="post-metadata">

**Author:** ![steve.hoffman](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/steve.hoffman/32/66_2.png) [@steve.hoffman](https://forums.percona.com/u/steve.hoffman)\
**Post date:** [January 4, 2021, 8:41pm UTC](https://forums.percona.com/t/pmm-query-analytics-does-not-add-new-awsrds-instances/8458/3 "2021-01-04T20:41:41Z")

</div>

Sorry for delay in replies (holidays!). Is this still an issue? It does typically take time for QAN data to start populating. Also after scanning AWS for instances and selecting the instance to add did you check the box (or it leave it checked) for “Use performance schema”?

---

<div class="post-metadata">

**Author:** ![NazarD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nazard/32/2423_2.png) [@NazarD](https://forums.percona.com/u/NazarD)\
**Post date:** [January 5, 2021, 5:26pm UTC](https://forums.percona.com/t/pmm-query-analytics-does-not-add-new-awsrds-instances/8458/4 "2021-01-05T17:26:24Z")

</div>

Hi Steve! thank you for reply  
i tried different options and i got localize the problem.  
If i add mysql-server (aws rds ( like rds or externalMysql) or mysql server via externalMysql = all works perfect  
If i try tu add amazon aurora instance - the no to be avavible in tthe QAN

PMM server installed from AWS IAM and from Docker, same result.

---

<div class="post-metadata">

**Author:** ![nurlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nurlan/32/1523_2.png) [@nurlan](https://forums.percona.com/u/nurlan)\
**Post date:** [January 7, 2021, 11:49am UTC](https://forums.percona.com/t/pmm-query-analytics-does-not-add-new-awsrds-instances/8458/5 "2021-01-07T11:49:33Z")

</div>

Hi @NazarD,

Could you check PMM Inventory page / Agents Tab?  
Can you see QAN agent there and what is the status of QAN agent?

Thank you.

---

<div class="post-metadata">

**Author:** ![NazarD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nazard/32/2423_2.png) [@NazarD](https://forums.percona.com/u/NazarD)\
**Post date:** [January 8, 2021, 10:33am UTC](https://forums.percona.com/t/pmm-query-analytics-does-not-add-new-awsrds-instances/8458/6 "2021-01-08T10:33:57Z")

</div>

Hi Nurlan,

 ![зображення](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/9/9657395c7b790068d2ff38e0dde57a7916dd8fbe.png)  
 ![зображення](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/7/7b6d5723c123b9fb9fe0384b5e022edb55698020.png)  
 ![зображення](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/b/b817f24e7586ef3b61a5cd155175c02f577f3ac9.png)  
 ![зображення](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/3/30784cca191c8796e8f2cc078c41756d08c1fd90.png)  
 ![зображення](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/a/a110b7008d2789eb1a518428d231109955dfac2b.png)  
 ![зображення](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/b/bb4086da1a1153a1288e3a64c92da7e5761ea5d1.png)

---

<div class="post-metadata">

**Author:** ![nurlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nurlan/32/1523_2.png) [@nurlan](https://forums.percona.com/u/nurlan)\
**Post date:** [January 8, 2021, 11:20am UTC](https://forums.percona.com/t/pmm-query-analytics-does-not-add-new-awsrds-instances/8458/7 "2021-01-08T11:20:34Z")

</div>

Thank you @NazarD ,

Could you execute following query on Aurora instance and check if you have any value there?  
`Select * from performance_schema.events_statements_summary_by_digest`

Also could you check logs of pmm-agent for errors? Can be downloaded by calling PMM\_SERVER\_URL/logs.zip

Thank you

---

<div class="post-metadata">

**Author:** ![NazarD](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nazard/32/2423_2.png) [@NazarD](https://forums.percona.com/u/NazarD)\
**Post date:** [January 8, 2021, 11:44am UTC](https://forums.percona.com/t/pmm-query-analytics-does-not-add-new-awsrds-instances/8458/8 "2021-01-08T11:44:12Z")

</div>

Nurlan,

> Select \* from performance\_schema.events\_statements\_summary\_by\_digest ;  
> Empty set  
> I se error with aws aurora instances. like " Error 1054: Unknown column ’ . Probably is the aws bug?  
> [pmm-agent.log](https://forums.percona.com/uploads/short-url/1yjsUjGWm172lKmvtC5TzelkGQy.log) (335.9 KB)

---

<div class="post-metadata">

**Author:** ![nurlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/nurlan/32/1523_2.png) [@nurlan](https://forums.percona.com/u/nurlan)\
**Post date:** [January 8, 2021, 12:28pm UTC](https://forums.percona.com/t/pmm-query-analytics-does-not-add-new-awsrds-instances/8458/9 "2021-01-08T12:28:02Z")

</div>

Yeah looks like something wrong with aurora configuration.  
Unknown column is not related to QAN as far as I see.