# Query analytics not working **URL:** \ **Category:** PMM 1.x\ **Created:** [July 27, 2017, 10:45am UTC](https://forums.percona.com/t/query-analytics-not-working/5766 "2017-07-27T10:45:33Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![kumargsvn](https://avatars.discourse-cdn.com/v4/letter/k/94ad74/32.png) [@kumargsvn](https://forums.percona.com/u/kumargsvn)\ **Post date:** [July 27, 2017, 10:45am UTC](https://forums.percona.com/t/query-analytics-not-working/5766/1 "2017-07-27T10:45:33Z")
slow query log enabled in db, however still getting below error in PMM- Query\_analytics QAN API error: “qh.Profile: No query classes for selected instance and time range. Please check whether your MySQL settings match the recommended.”. Check the /var/log/qan-api.log file in docker container for more information. ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [July 31, 2017, 7:06am UTC](https://forums.percona.com/t/query-analytics-not-working/5766/2 "2017-07-31T07:06:56Z")
Hi [kumargsvn](https://percona.vanillacommunities.com/profile/x/x/27272), The root of the issue: no queries for analyzing. please configure mysql settings according to this page [url][Percona Monitoring and Management](https://www.percona.com/doc/percona-monitoring-and-management/conf-mysql.html%5B/url%5D) ---
**Author:** ![kumargsvn](https://avatars.discourse-cdn.com/v4/letter/k/94ad74/32.png) [@kumargsvn](https://forums.percona.com/u/kumargsvn)\ **Post date:** [August 1, 2017, 8:48am UTC](https://forums.percona.com/t/query-analytics-not-working/5766/3 "2017-08-01T08:48:52Z")
Hi [Mykola](https://www.percona.com/forums/) Thanks for your help. Going through the variables mentioned in the above page, the log\_slow\_slave\_statements variables should be set in the slave instance, right? or can we set in master side also? ---
**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\ **Post date:** [August 1, 2017, 12:57pm UTC](https://forums.percona.com/t/query-analytics-not-working/5766/4 "2017-08-01T12:57:01Z")
Hi [kumargsvn](https://percona.vanillacommunities.com/profile/x/x/27272) , apply it on your master as well, but it would have no effect. [url][https://dev.mysql.com/doc/refman/5.7/en/replication-options-slave.html#sysvar\_log\_slow\_slave\_statements[/url]](https://dev.mysql.com/doc/refman/5.7/en/replication-options-slave.html#sysvar_log_slow_slave_statements%5B/url%5D) ---
**Author:** ![kumargsvn](https://avatars.discourse-cdn.com/v4/letter/k/94ad74/32.png) [@kumargsvn](https://forums.percona.com/u/kumargsvn)\ **Post date:** [August 1, 2017, 1:58pm UTC](https://forums.percona.com/t/query-analytics-not-working/5766/5 "2017-08-01T13:58:17Z")
ok, got it. thanks for the info, Michael. ---
**Author:** ![kumargsvn](https://avatars.discourse-cdn.com/v4/letter/k/94ad74/32.png) [@kumargsvn](https://forums.percona.com/u/kumargsvn)\ **Post date:** [August 1, 2017, 1:59pm UTC](https://forums.percona.com/t/query-analytics-not-working/5766/6 "2017-08-01T13:59:59Z")
And one question regarding upgrade, I have upgraded the pmm server from 1.1.1 to 1.2.0 However the pmm-data still showing as 1.1.1 [root@inttltmysql01 docker]# docker ps -a CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 1aaff75d9412 percona/pmm-server:1.2.0 “/opt/entrypoint.sh” 8 minutes ago Up 46 seconds 443/tcp, 0.0.0.0:8080-\>80/tcp pmm-server 7df251682e28 percona/pmm-server:1.1.1 “/bin/true” 5 months ago pmm-data I have used below commands to upgrade: docker ps -a docker stop pmm-server && docker rm pmm-server docker run -d -p 8080:80 –volumes-from pmm-data –name pmm-server –restart always percona/pmm-server:1.2.0 ---
**Author:** ![kumargsvn](https://avatars.discourse-cdn.com/v4/letter/k/94ad74/32.png) [@kumargsvn](https://forums.percona.com/u/kumargsvn)\ **Post date:** [August 1, 2017, 2:14pm UTC](https://forums.percona.com/t/query-analytics-not-working/5766/7 "2017-08-01T14:14:21Z")
And also I have upgraded the client using yum update, When I opened query analytics page, it is giving below error. QAN API error: “qh.Profile: No query classes for selected instance and time range. Please check whether your MySQL settings match the recommended.”. Check the /var/log/qan-api.log file in docker container for more information. ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [August 2, 2017, 3:26am UTC](https://forums.percona.com/t/query-analytics-not-working/5766/8 "2017-08-02T03:26:53Z")
Hi [kumargsvn](https://percona.vanillacommunities.com/profile/x/x/27272) > [@](#): > > And one question regarding upgrade, I have upgraded the pmm server from 1.1.1 to 1.2.0 > However the pmm-data still showing as 1.1.1 it is expected, pmm-data container save all your data. so if you remove/update it - you lose your data. 1.2.0 is fully compatible with all pmm-data versions \>= 1.0.7 > [@](#): > > QAN API error: “qh.Profile: No query classes for selected instance and time range. Please check whether your MySQL settings match the recommended.”. It is absolutely the same issue as before: no queries for analyzing. you have two ways: [LIST=1] [_]use recommended settings for slowlog from documentation [https://www.percona.com/doc/percona-monitoring-and-management/conf-mysql.html](https://www.percona.com/doc/percona-monitoring-and-management/conf-mysql.html) please note that mysql restart is needed. [_]you can use performance schema as query source. please find screenshot below [/LIST] ![query_source.png](https://us1.discourse-cdn.com/flex019/uploads/percona1/original/2X/c/c232506e4a35743d6378aab55910f53f49a1c9b5.png) ---
**Author:** ![kumargsvn](https://avatars.discourse-cdn.com/v4/letter/k/94ad74/32.png) [@kumargsvn](https://forums.percona.com/u/kumargsvn)\ **Post date:** [August 2, 2017, 11:44am UTC](https://forums.percona.com/t/query-analytics-not-working/5766/9 "2017-08-02T11:44:49Z")
Thanks Mykola, Thanks for the your help. Before upgrade as suggested I have updated/changed the variables dynamically and it worked fine with slowlog option. However after upgrade it is giving the error which I had reported. ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [August 3, 2017, 9:17am UTC](https://forums.percona.com/t/query-analytics-not-working/5766/10 "2017-08-03T09:17:36Z")
do you see queries in slow log? if yes, can you find query date/time in log and choose this time period in QAN interface? can you try to use performance schema as query source? ---
**Author:** ![kumargsvn](https://avatars.discourse-cdn.com/v4/letter/k/94ad74/32.png) [@kumargsvn](https://forums.percona.com/u/kumargsvn)\ **Post date:** [August 3, 2017, 2:01pm UTC](https://forums.percona.com/t/query-analytics-not-working/5766/11 "2017-08-03T14:01:58Z")
yes, I have selected 3h, 12h and 5d interval. I have tried to change the query source as “performance schema” but no luck… ---
**Author:** ![Mykola](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/mykola/32/30_2.png) [@Mykola](https://forums.percona.com/u/Mykola)\ **Post date:** [August 4, 2017, 3:25am UTC](https://forums.percona.com/t/query-analytics-not-working/5766/12 "2017-08-04T03:25:50Z")
[kumargsvn](https://percona.vanillacommunities.com/profile/x/x/27272) can you share the following logs? [LIST=1] [_] from docker [_]from pmm-client [/LIST] also can you restart qan-agent on pmm-client? ```auto pmm-admin restart mysql:queries ``` ---
**Author:** ![kumargsvn](https://avatars.discourse-cdn.com/v4/letter/k/94ad74/32.png) [@kumargsvn](https://forums.percona.com/u/kumargsvn)\ **Post date:** [September 14, 2017, 2:17pm UTC](https://forums.percona.com/t/query-analytics-not-working/5766/13 "2017-09-14T14:17:51Z")
Hi Mykola, pmm-admin restart mysql:queries worked. Thank you. Is there a way to upgrade pmm-data container to latest version to match with pmm-server, without losing the data ?