# Query Analytics : Interval out of sequence
**URL:** https://forums.percona.com/t/query-analytics-interval-out-of-sequence/5137
**Category:** PMM 1.x
**Created:** [October 10, 2016, 4:35am UTC](https://forums.percona.com/t/query-analytics-interval-out-of-sequence/5137 "2016-10-10T04:35:25Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@manseuk](https://forums.percona.com/u/manseuk)
#### Post date: [October 10, 2016, 4:35am UTC](https://forums.percona.com/t/query-analytics-interval-out-of-sequence/5137/1 "2016-10-10T04:35:25Z")
I cannot get query analytics to be processed from a node :
[TABLE]
[TR]
[TD]2016-10-10T09:59:00.001140141Z[/TD]
[TD]qan-analyzer-3fba67e0[/TD]
[TD]warning[/TD]
[TD]Skipping interval ‘194 2016-10-10 09:58:00 UTC to 2016-10-10 09:59:00 UTC (0-0)’ because interval ‘193 2016-10-10 09:57:00 UTC to 2016-10-10 09:58:00 UTC (0-0)’ is still being parsed[/TD]
[/TR]
[TR]
[TD]2016-10-10T09:58:38.017831004Z[/TD]
[TD]data-sender[/TD]
[TD]info[/TD]
[TD]at 2016-10-10 09:58:38 UTC: 0 files, 0, 2ms, 0.00 Mbps net util, 0.00 Mbps net speed[/TD]
[/TR]
[TR]
[TD]2016-10-10T09:58:14.991883367Z[/TD]
[TD]agent[/TD]
[TD]info[/TD]
[TD]Cmd ok: Reply[Cmd:Version Error:‘’ Id:b8a20c79-905d-4b35-66d0-1aaf8e20f5f7][/TD]
[/TR]
[TR]
[TD]2016-10-10T09:58:14.986035177Z[/TD]
[TD]agent[/TD]
[TD]info[/TD]
[TD]Cmd begin: Cmd[Service:agent Cmd:Version Ts:‘2016-10-10 09:58:14.986477595 +0000 UTC’ User:api AgentUUID: Id:b8a20c79-905d-4b35-66d0-1aaf8e20f5f7][/TD]
[/TR]
[TR]
[TD]2016-10-10T09:58:00.001775856Z[/TD]
[TD]qan-analyzer-3fba67e0-worker[/TD]
[TD]warning[/TD]
[TD]Interval out of sequence: got 193, expected 192[/TD]
[/TR]
[TR]
[TD]2016-10-10T09:57:35.017027378Z[/TD]
[TD]data-sender[/TD]
[TD]info[/TD]
[TD]at 2016-10-10 09:57:35 UTC: 0 files, 0, 2ms, 0.00 Mbps net util, 0.00 Mbps net speed[/TD]
[/TR]
[TR]
[TD]2016-10-10T09:57:14.992363352Z[/TD]
[TD]agent[/TD]
[TD]info[/TD]
[TD]Cmd ok: Reply[Cmd:Version Error:‘’ Id:2f93b7fd-1369-456c-553b-d88127ab9659][/TD]
[/TR]
[TR]
[TD]2016-10-10T09:57:14.986084264Z[/TD]
[TD]agent[/TD]
[TD]info[/TD]
[TD]Cmd begin: Cmd[Service:agent Cmd:Version Ts:‘2016-10-10 09:57:14.986502808 +0000 UTC’ User:api AgentUUID: Id:2f93b7fd-1369-456c-553b-d88127ab9659][/TD]
[/TR]
[/TABLE]
Any ideas ?
---
### Author:  [@weber](https://forums.percona.com/u/weber)
#### Post date: [October 10, 2016, 5:49am UTC](https://forums.percona.com/t/query-analytics-interval-out-of-sequence/5137/2 "2016-10-10T05:49:58Z")
What do you have in /var/log/pmm-mysql-queries\*.log? What’s the query source slowlog or perfschema?
---
### Author:  [@manseuk](https://forums.percona.com/u/manseuk)
#### Post date: [October 10, 2016, 11:26am UTC](https://forums.percona.com/t/query-analytics-interval-out-of-sequence/5137/3 "2016-10-10T11:26:49Z")
from the log →
2016/10/10 17:55:00.001738 WARNING qan-analyzer-3fba67e0 Skipping interval ‘610 2016-10-10 16:54:00 UTC to 2016-10-10 16:55:00 UTC (0-0)’ because interval ‘609 2016-10-10 16:53:00 UTC to 2016-10-10 16:54:00 UTC (0-0)’ is still being parsed
2016/10/10 17:56:00.001728 WARNING qan-analyzer-3fba67e0-worker Interval out of sequence: got 611, expected 610
Using performance schema
---
### Author:  [@manseuk](https://forums.percona.com/u/manseuk)
#### Post date: [October 11, 2016, 4:41am UTC](https://forums.percona.com/t/query-analytics-interval-out-of-sequence/5137/4 "2016-10-11T04:41:18Z")
Same kind of issue in the logs
2016/10/10 19:42:00.002049 WARNING qan-analyzer-3fba67e0-worker Interval out of sequence: got 717, expected 716
2016/10/10 19:43:00.001290 WARNING qan-analyzer-3fba67e0 Skipping interval ‘718 2016-10-10 18:42:00 UTC to 2016-10-10 18:43:00 UTC (0-0)’ because interval ‘717 2016-10-10 18:41:00 UTC to 2016-10-10 18:42:00 UTC (0-0)’ is still being parsed
2016/10/10 19:44:00.018866 WARNING qan-analyzer-3fba67e0-worker Interval out of sequence: got 719, expected 718
2016/10/10 19:45:00.001248 WARNING qan-analyzer-3fba67e0 Skipping interval ‘720 2016-10-10 18:44:00 UTC to 2016-10-10 18:45:00 UTC (0-0)’ because interval ‘719 2016-10-10 18:43:00 UTC to 2016-10-10 18:44:00 UTC (0-0)’ is still being parsed
And we are using Performance Schema - its set to automatic in the settings.
It was working - but we had an outage on the server - is there some way i can reset things ? im happy to lose any previous data - i guess i could reinstall server and client ?
---
### Author:  [@weber](https://forums.percona.com/u/weber)
#### Post date: [October 11, 2016, 9:34am UTC](https://forums.percona.com/t/query-analytics-interval-out-of-sequence/5137/5 "2016-10-11T09:34:58Z")
May be system time is out of sync?