New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
In rare cases the same idarchive includes data from 2 different archives of different segments (edge case) #14379
Labels
Bug
For errors / faults / flaws / inconsistencies etc.
not-in-changelog
For issues or pull requests that should not be included in our release changelog on matomo.org.
Milestone
Comments
The same things: mysql> SELECT COUNT(*) AS `count`,idarchive,name,date1,date2,period FROM `matomo_archive_numeric_2019_05` WHERE idsite=1 GROUP BY name,idsite,date1,date2,period HAVING `count`>1;
+-------+-----------+----------------------------------------------------+------------+------------+--------+
| count | idarchive | name | date1 | date2 | period |
+-------+-----------+----------------------------------------------------+------------+------------+--------+
| 18 | 51164 | Actions_nb_downloads | 2019-05-01 | 2019-05-31 | 3 |
| 2 | 28538 | Actions_nb_downloads | 2019-05-05 | 2019-05-05 | 1 |
| 18 | 51164 | Actions_nb_hits_with_time_generation | 2019-05-01 | 2019-05-31 | 3 |
| 24 | 51080 | Actions_nb_hits_with_time_generation | 2019-05-13 | 2019-05-19 | 2 |
| 37 | 46046 | Actions_nb_hits_with_time_generation | 2019-05-16 | 2019-05-16 | 1 |
| 27 | 51075 | Actions_nb_hits_with_time_generation | 2019-05-17 | 2019-05-17 | 1 |
| 18 | 51164 | Actions_nb_keywords | 2019-05-01 | 2019-05-31 | 3 |
| 2 | 28538 | Actions_nb_keywords | 2019-05-05 | 2019-05-05 | 1 |
| 18 | 51164 | Actions_nb_outlinks | 2019-05-01 | 2019-05-31 | 3 |
| 24 | 51080 | Actions_nb_outlinks | 2019-05-13 | 2019-05-19 | 2 |
| 18 | 51164 | Actions_nb_pageviews | 2019-05-01 | 2019-05-31 | 3 |
| 2 | 28538 | Actions_nb_pageviews | 2019-05-05 | 2019-05-05 | 1 |
| 24 | 51080 | Actions_nb_pageviews | 2019-05-13 | 2019-05-19 | 2 |
| 37 | 46046 | Actions_nb_pageviews | 2019-05-16 | 2019-05-16 | 1 |
| 27 | 51075 | Actions_nb_pageviews | 2019-05-17 | 2019-05-17 | 1 |
| 18 | 51164 | Actions_nb_searches | 2019-05-01 | 2019-05-31 | 3 |
| 2 | 28538 | Actions_nb_searches | 2019-05-05 | 2019-05-05 | 1 |
| 18 | 51164 | Actions_nb_uniq_downloads | 2019-05-01 | 2019-05-31 | 3 |
| 2 | 28538 | Actions_nb_uniq_downloads | 2019-05-05 | 2019-05-05 | 1 |
| 18 | 51164 | Actions_nb_uniq_outlinks | 2019-05-01 | 2019-05-31 | 3 |
| 24 | 51080 | Actions_nb_uniq_outlinks | 2019-05-13 | 2019-05-19 | 2 |
| 18 | 51164 | Actions_nb_uniq_pageviews | 2019-05-01 | 2019-05-31 | 3 |
| 2 | 28538 | Actions_nb_uniq_pageviews | 2019-05-05 | 2019-05-05 | 1 |
| 24 | 51080 | Actions_nb_uniq_pageviews | 2019-05-13 | 2019-05-19 | 2 |
| 37 | 46046 | Actions_nb_uniq_pageviews | 2019-05-16 | 2019-05-16 | 1 |
| 27 | 51075 | Actions_nb_uniq_pageviews | 2019-05-17 | 2019-05-17 | 1 |
| 18 | 51164 | Actions_sum_time_generation | 2019-05-01 | 2019-05-31 | 3 |
| 24 | 51080 | Actions_sum_time_generation | 2019-05-13 | 2019-05-19 | 2 |
| 37 | 46046 | Actions_sum_time_generation | 2019-05-16 | 2019-05-16 | 1 |
| 27 | 51075 | Actions_sum_time_generation | 2019-05-17 | 2019-05-17 | 1 |
| 2 | 28801 | bounce_count | 2019-05-01 | 2019-05-01 | 1 |
| 108 | 51164 | bounce_count | 2019-05-01 | 2019-05-31 | 3 |
| 3 | 28806 | bounce_count | 2019-05-02 | 2019-05-02 | 1 |
| 3 | 28811 | bounce_count | 2019-05-03 | 2019-05-03 | 1 |
| 3 | 28826 | bounce_count | 2019-05-04 | 2019-05-04 | 1 |
| 4 | 28403 | bounce_count | 2019-05-05 | 2019-05-05 | 1 |
| 3 | 27849 | bounce_count | 2019-05-06 | 2019-05-06 | 1 |
| 3 | 27848 | bounce_count | 2019-05-06 | 2019-05-12 | 2 |
| 3 | 27321 | bounce_count | 2019-05-07 | 2019-05-07 | 1 |
| 3 | 26689 | bounce_count | 2019-05-08 | 2019-05-08 | 1 |
| 3 | 26400 | bounce_count | 2019-05-09 | 2019-05-09 | 1 |
| 3 | 25036 | bounce_count | 2019-05-10 | 2019-05-10 | 1 |
| 3 | 24970 | bounce_count | 2019-05-11 | 2019-05-11 | 1 |
| 3 | 24430 | bounce_count | 2019-05-12 | 2019-05-12 | 1 |
| 3 | 32284 | bounce_count | 2019-05-13 | 2019-05-13 | 1 |
| 207 | 51080 | bounce_count | 2019-05-13 | 2019-05-19 | 2 |
| 3 | 38912 | bounce_count | 2019-05-14 | 2019-05-14 | 1 |
| 3 | 44605 | bounce_count | 2019-05-15 | 2019-05-15 | 1 |
| 396 | 46046 | bounce_count | 2019-05-16 | 2019-05-16 | 1 |
| 184 | 51075 | bounce_count | 2019-05-17 | 2019-05-17 | 1 |
| 18 | 51164 | done | 2019-05-01 | 2019-05-31 | 3 |
| 2 | 28538 | done | 2019-05-05 | 2019-05-05 | 1 |
| 24 | 51080 | done | 2019-05-13 | 2019-05-19 | 2 |
| 37 | 46046 | done | 2019-05-16 | 2019-05-16 | 1 |
| 27 | 51075 | done | 2019-05-17 | 2019-05-17 | 1 |
| 59 | 46141 | done | 2019-05-18 | 2019-05-18 | 1 |
| 17 | 51222 | done | 2019-05-19 | 2019-05-19 | 1 |
| 12 | 51274 | done1f27eaa8663a6eabfa2d19a79aa36387.Goals | 2019-05-01 | 2019-05-31 | 3 |
| 2 | 28415 | done1f27eaa8663a6eabfa2d19a79aa36387.Goals | 2019-05-04 | 2019-05-04 | 1 |
| 2 | 26742 | done1f27eaa8663a6eabfa2d19a79aa36387.Goals | 2019-05-07 | 2019-05-07 | 1 |
| 3 | 24990 | done1f27eaa8663a6eabfa2d19a79aa36387.Goals | 2019-05-09 | 2019-05-09 | 1 |
| 30 | 51120 | done1f27eaa8663a6eabfa2d19a79aa36387.Goals | 2019-05-13 | 2019-05-19 | 2 |
| 72 | 46065 | done1f27eaa8663a6eabfa2d19a79aa36387.Goals | 2019-05-16 | 2019-05-16 | 1 |
| 54 | 51094 | done1f27eaa8663a6eabfa2d19a79aa36387.Goals | 2019-05-17 | 2019-05-17 | 1 |
| 12 | 51273 | done1f27eaa8663a6eabfa2d19a79aa36387.VisitsSummary | 2019-05-01 | 2019-05-31 | 3 |
| 30 | 51118 | done1f27eaa8663a6eabfa2d19a79aa36387.VisitsSummary | 2019-05-13 | 2019-05-19 | 2 |
| 73 | 46064 | done1f27eaa8663a6eabfa2d19a79aa36387.VisitsSummary | 2019-05-16 | 2019-05-16 | 1 |
| 55 | 51093 | done1f27eaa8663a6eabfa2d19a79aa36387.VisitsSummary | 2019-05-17 | 2019-05-17 | 1 |
| 84 | 46190 | done1f27eaa8663a6eabfa2d19a79aa36387.VisitsSummary | 2019-05-18 | 2019-05-18 | 1 |
| 27 | 51186 | done1f27eaa8663a6eabfa2d19a79aa36387.VisitsSummary | 2019-05-19 | 2019-05-19 | 1 |
| 15 | 51302 | done5aa0e3c4a2c285b80bcc0cd6e8a62f3e.Goals | 2019-05-01 | 2019-05-31 | 3 |
| 2 | 28503 | done5aa0e3c4a2c285b80bcc0cd6e8a62f3e.Goals | 2019-05-02 | 2019-05-02 | 1 |
| 4 | 28508 | done5aa0e3c4a2c285b80bcc0cd6e8a62f3e.Goals | 2019-05-03 | 2019-05-03 | 1 |
| 4 | 28292 | done5aa0e3c4a2c285b80bcc0cd6e8a62f3e.Goals | 2019-05-04 | 2019-05-04 | 1 |
| 2 | 26768 | done5aa0e3c4a2c285b80bcc0cd6e8a62f3e.Goals | 2019-05-07 | 2019-05-07 | 1 |
| 2 | 25005 | done5aa0e3c4a2c285b80bcc0cd6e8a62f3e.Goals | 2019-05-09 | 2019-05-09 | 1 |
| 48 | 51134 | done5aa0e3c4a2c285b80bcc0cd6e8a62f3e.Goals | 2019-05-13 | 2019-05-19 | 2 |
| 97 | 46075 | done5aa0e3c4a2c285b80bcc0cd6e8a62f3e.Goals | 2019-05-16 | 2019-05-16 | 1 |
| 73 | 51104 | done5aa0e3c4a2c285b80bcc0cd6e8a62f3e.Goals | 2019-05-17 | 2019-05-17 | 1 |
| 18 | 51301 | done5aa0e3c4a2c285b80bcc0cd6e8a62f3e.VisitsSummary | 2019-05-01 | 2019-05-31 | 3 |
| 48 | 51132 | done5aa0e3c4a2c285b80bcc0cd6e8a62f3e.VisitsSummary | 2019-05-13 | 2019-05-19 | 2 |
| 99 | 46074 | done5aa0e3c4a2c285b80bcc0cd6e8a62f3e.VisitsSummary | 2019-05-16 | 2019-05-16 | 1 |
| 73 | 51103 | done5aa0e3c4a2c285b80bcc0cd6e8a62f3e.VisitsSummary | 2019-05-17 | 2019-05-17 | 1 |
| 139 | 46214 | done5aa0e3c4a2c285b80bcc0cd6e8a62f3e.VisitsSummary | 2019-05-18 | 2019-05-18 | 1 |
| 45 | 51210 | done5aa0e3c4a2c285b80bcc0cd6e8a62f3e.VisitsSummary | 2019-05-19 | 2019-05-19 | 1 |
| 27 | 51170 | done90a5a511e1974bca37613b6daec137ba.Goals | 2019-05-01 | 2019-05-31 | 3 |
| 53 | 51090 | done90a5a511e1974bca37613b6daec137ba.Goals | 2019-05-13 | 2019-05-19 | 2 |
| 109 | 46048 | done90a5a511e1974bca37613b6daec137ba.Goals | 2019-05-16 | 2019-05-16 | 1 |
| 82 | 51077 | done90a5a511e1974bca37613b6daec137ba.Goals | 2019-05-17 | 2019-05-17 | 1 |
| 142 | 46154 | done90a5a511e1974bca37613b6daec137ba.Goals | 2019-05-18 | 2019-05-18 | 1 |
| 44 | 51183 | done90a5a511e1974bca37613b6daec137ba.Goals | 2019-05-19 | 2019-05-19 | 1 |
| 33 | 51165 | done90a5a511e1974bca37613b6daec137ba.VisitsSummary | 2019-05-01 | 2019-05-31 | 3 |
| 80 | 51087 | done90a5a511e1974bca37613b6daec137ba.VisitsSummary | 2019-05-13 | 2019-05-19 | 2 |
| 217 | 46047 | done90a5a511e1974bca37613b6daec137ba.VisitsSummary | 2019-05-16 | 2019-05-16 | 1 |
| 157 | 51076 | done90a5a511e1974bca37613b6daec137ba.VisitsSummary | 2019-05-17 | 2019-05-17 | 1 |
| 360 | 46145 | done90a5a511e1974bca37613b6daec137ba.VisitsSummary | 2019-05-18 | 2019-05-18 | 1 |
| 110 | 51169 | done90a5a511e1974bca37613b6daec137ba.VisitsSummary | 2019-05-19 | 2019-05-19 | 1 |
| 45 | 51193 | donefea44bece172bc9696ae57c26888bf8a.Goals | 2019-05-01 | 2019-05-31 | 3 |
| 2 | 28445 | donefea44bece172bc9696ae57c26888bf8a.Goals | 2019-05-05 | 2019-05-05 | 1 |
| 2 | 25011 | donefea44bece172bc9696ae57c26888bf8a.Goals | 2019-05-11 | 2019-05-11 | 1 |
| 119 | 51100 | donefea44bece172bc9696ae57c26888bf8a.Goals | 2019-05-13 | 2019-05-19 | 2 |
| 230 | 46050 | donefea44bece172bc9696ae57c26888bf8a.Goals | 2019-05-16 | 2019-05-16 | 1 |
| 171 | 51079 | donefea44bece172bc9696ae57c26888bf8a.Goals | 2019-05-17 | 2019-05-17 | 1 |
| 196 | 46168 | donefea44bece172bc9696ae57c26888bf8a.Goals | 2019-05-18 | 2019-05-18 | 1 |
| 62 | 51207 | donefea44bece172bc9696ae57c26888bf8a.Goals | 2019-05-19 | 2019-05-19 | 1 |
| 57 | 51188 | donefea44bece172bc9696ae57c26888bf8a.VisitsSummary | 2019-05-01 | 2019-05-31 | 3 |
| 103 | 51097 | donefea44bece172bc9696ae57c26888bf8a.VisitsSummary | 2019-05-13 | 2019-05-19 | 2 |
| 285 | 46049 | donefea44bece172bc9696ae57c26888bf8a.VisitsSummary | 2019-05-16 | 2019-05-16 | 1 |
| 190 | 51078 | donefea44bece172bc9696ae57c26888bf8a.VisitsSummary | 2019-05-17 | 2019-05-17 | 1 |
| 477 | 46158 | donefea44bece172bc9696ae57c26888bf8a.VisitsSummary | 2019-05-18 | 2019-05-18 | 1 |
| 145 | 51192 | donefea44bece172bc9696ae57c26888bf8a.VisitsSummary | 2019-05-19 | 2019-05-19 | 1 |
| 2 | 28801 | max_actions | 2019-05-01 | 2019-05-01 | 1 |
| 108 | 51164 | max_actions | 2019-05-01 | 2019-05-31 | 3 |
| 3 | 28806 | max_actions | 2019-05-02 | 2019-05-02 | 1 |
| 3 | 28811 | max_actions | 2019-05-03 | 2019-05-03 | 1 |
| 3 | 28826 | max_actions | 2019-05-04 | 2019-05-04 | 1 |
| 4 | 28403 | max_actions | 2019-05-05 | 2019-05-05 | 1 |
| 3 | 27849 | max_actions | 2019-05-06 | 2019-05-06 | 1 |
| 3 | 27848 | max_actions | 2019-05-06 | 2019-05-12 | 2 |
| 3 | 27321 | max_actions | 2019-05-07 | 2019-05-07 | 1 |
| 3 | 26689 | max_actions | 2019-05-08 | 2019-05-08 | 1 |
| 3 | 26400 | max_actions | 2019-05-09 | 2019-05-09 | 1 |
| 3 | 25036 | max_actions | 2019-05-10 | 2019-05-10 | 1 |
| 3 | 24970 | max_actions | 2019-05-11 | 2019-05-11 | 1 |
| 3 | 24430 | max_actions | 2019-05-12 | 2019-05-12 | 1 |
| 3 | 32284 | max_actions | 2019-05-13 | 2019-05-13 | 1 |
| 207 | 51080 | max_actions | 2019-05-13 | 2019-05-19 | 2 |
| 3 | 38912 | max_actions | 2019-05-14 | 2019-05-14 | 1 |
| 3 | 44605 | max_actions | 2019-05-15 | 2019-05-15 | 1 |
| 539 | 46046 | max_actions | 2019-05-16 | 2019-05-16 | 1 |
| 374 | 51075 | max_actions | 2019-05-17 | 2019-05-17 | 1 |
| 2 | 28801 | nb_actions | 2019-05-01 | 2019-05-01 | 1 |
| 108 | 51164 | nb_actions | 2019-05-01 | 2019-05-31 | 3 |
| 3 | 28806 | nb_actions | 2019-05-02 | 2019-05-02 | 1 |
| 3 | 28811 | nb_actions | 2019-05-03 | 2019-05-03 | 1 |
| 3 | 28826 | nb_actions | 2019-05-04 | 2019-05-04 | 1 |
| 4 | 28403 | nb_actions | 2019-05-05 | 2019-05-05 | 1 |
| 3 | 27849 | nb_actions | 2019-05-06 | 2019-05-06 | 1 |
| 3 | 27848 | nb_actions | 2019-05-06 | 2019-05-12 | 2 |
| 3 | 27321 | nb_actions | 2019-05-07 | 2019-05-07 | 1 |
| 3 | 26689 | nb_actions | 2019-05-08 | 2019-05-08 | 1 |
| 3 | 26400 | nb_actions | 2019-05-09 | 2019-05-09 | 1 |
| 3 | 25036 | nb_actions | 2019-05-10 | 2019-05-10 | 1 |
| 3 | 24970 | nb_actions | 2019-05-11 | 2019-05-11 | 1 |
| 3 | 24430 | nb_actions | 2019-05-12 | 2019-05-12 | 1 |
| 3 | 32284 | nb_actions | 2019-05-13 | 2019-05-13 | 1 |
| 207 | 51080 | nb_actions | 2019-05-13 | 2019-05-19 | 2 |
| 3 | 38912 | nb_actions | 2019-05-14 | 2019-05-14 | 1 |
| 3 | 44605 | nb_actions | 2019-05-15 | 2019-05-15 | 1 |
| 539 | 46046 | nb_actions | 2019-05-16 | 2019-05-16 | 1 |
| 374 | 51075 | nb_actions | 2019-05-17 | 2019-05-17 | 1 |
| 2 | 28801 | nb_uniq_visitors | 2019-05-01 | 2019-05-01 | 1 |
| 108 | 51164 | nb_uniq_visitors | 2019-05-01 | 2019-05-31 | 3 |
| 3 | 28806 | nb_uniq_visitors | 2019-05-02 | 2019-05-02 | 1 |
| 3 | 28811 | nb_uniq_visitors | 2019-05-03 | 2019-05-03 | 1 |
| 3 | 28826 | nb_uniq_visitors | 2019-05-04 | 2019-05-04 | 1 |
| 4 | 28403 | nb_uniq_visitors | 2019-05-05 | 2019-05-05 | 1 |
| 3 | 27849 | nb_uniq_visitors | 2019-05-06 | 2019-05-06 | 1 |
| 3 | 27848 | nb_uniq_visitors | 2019-05-06 | 2019-05-12 | 2 |
| 3 | 27321 | nb_uniq_visitors | 2019-05-07 | 2019-05-07 | 1 |
| 3 | 26689 | nb_uniq_visitors | 2019-05-08 | 2019-05-08 | 1 |
| 3 | 26400 | nb_uniq_visitors | 2019-05-09 | 2019-05-09 | 1 |
| 3 | 25036 | nb_uniq_visitors | 2019-05-10 | 2019-05-10 | 1 |
| 3 | 24970 | nb_uniq_visitors | 2019-05-11 | 2019-05-11 | 1 |
| 3 | 24430 | nb_uniq_visitors | 2019-05-12 | 2019-05-12 | 1 |
| 3 | 32284 | nb_uniq_visitors | 2019-05-13 | 2019-05-13 | 1 |
| 207 | 51080 | nb_uniq_visitors | 2019-05-13 | 2019-05-19 | 2 |
| 3 | 38912 | nb_uniq_visitors | 2019-05-14 | 2019-05-14 | 1 |
| 3 | 44605 | nb_uniq_visitors | 2019-05-15 | 2019-05-15 | 1 |
| 539 | 46046 | nb_uniq_visitors | 2019-05-16 | 2019-05-16 | 1 |
| 374 | 51075 | nb_uniq_visitors | 2019-05-17 | 2019-05-17 | 1 |
| 2 | 28801 | nb_visits | 2019-05-01 | 2019-05-01 | 1 |
| 108 | 51164 | nb_visits | 2019-05-01 | 2019-05-31 | 3 |
| 3 | 28806 | nb_visits | 2019-05-02 | 2019-05-02 | 1 |
| 3 | 28811 | nb_visits | 2019-05-03 | 2019-05-03 | 1 |
| 3 | 28826 | nb_visits | 2019-05-04 | 2019-05-04 | 1 |
| 4 | 28403 | nb_visits | 2019-05-05 | 2019-05-05 | 1 |
| 3 | 27849 | nb_visits | 2019-05-06 | 2019-05-06 | 1 |
| 3 | 27848 | nb_visits | 2019-05-06 | 2019-05-12 | 2 |
| 3 | 27321 | nb_visits | 2019-05-07 | 2019-05-07 | 1 |
| 3 | 26689 | nb_visits | 2019-05-08 | 2019-05-08 | 1 |
| 3 | 26400 | nb_visits | 2019-05-09 | 2019-05-09 | 1 |
| 3 | 25036 | nb_visits | 2019-05-10 | 2019-05-10 | 1 |
| 3 | 24970 | nb_visits | 2019-05-11 | 2019-05-11 | 1 |
| 3 | 24430 | nb_visits | 2019-05-12 | 2019-05-12 | 1 |
| 3 | 32284 | nb_visits | 2019-05-13 | 2019-05-13 | 1 |
| 207 | 51080 | nb_visits | 2019-05-13 | 2019-05-19 | 2 |
| 3 | 38912 | nb_visits | 2019-05-14 | 2019-05-14 | 1 |
| 3 | 44605 | nb_visits | 2019-05-15 | 2019-05-15 | 1 |
| 539 | 46046 | nb_visits | 2019-05-16 | 2019-05-16 | 1 |
| 374 | 51075 | nb_visits | 2019-05-17 | 2019-05-17 | 1 |
| 18 | 51164 | Referrers_distinctCampaigns | 2019-05-01 | 2019-05-31 | 3 |
| 2 | 28538 | Referrers_distinctCampaigns | 2019-05-05 | 2019-05-05 | 1 |
| 18 | 51164 | Referrers_distinctKeywords | 2019-05-01 | 2019-05-31 | 3 |
| 18 | 51164 | Referrers_distinctSearchEngines | 2019-05-01 | 2019-05-31 | 3 |
| 18 | 51164 | Referrers_distinctWebsites | 2019-05-01 | 2019-05-31 | 3 |
| 2 | 28538 | Referrers_distinctWebsites | 2019-05-05 | 2019-05-05 | 1 |
| 24 | 51080 | Referrers_distinctWebsites | 2019-05-13 | 2019-05-19 | 2 |
| 18 | 51164 | Referrers_distinctWebsitesUrls | 2019-05-01 | 2019-05-31 | 3 |
| 2 | 28538 | Referrers_distinctWebsitesUrls | 2019-05-05 | 2019-05-05 | 1 |
| 24 | 51080 | Referrers_distinctWebsitesUrls | 2019-05-13 | 2019-05-19 | 2 |
| 2 | 28801 | sum_visit_length | 2019-05-01 | 2019-05-01 | 1 |
| 108 | 51164 | sum_visit_length | 2019-05-01 | 2019-05-31 | 3 |
| 2 | 28806 | sum_visit_length | 2019-05-02 | 2019-05-02 | 1 |
| 3 | 28811 | sum_visit_length | 2019-05-03 | 2019-05-03 | 1 |
| 3 | 28826 | sum_visit_length | 2019-05-04 | 2019-05-04 | 1 |
| 4 | 28403 | sum_visit_length | 2019-05-05 | 2019-05-05 | 1 |
| 3 | 27849 | sum_visit_length | 2019-05-06 | 2019-05-06 | 1 |
| 3 | 27848 | sum_visit_length | 2019-05-06 | 2019-05-12 | 2 |
| 3 | 27321 | sum_visit_length | 2019-05-07 | 2019-05-07 | 1 |
| 3 | 26689 | sum_visit_length | 2019-05-08 | 2019-05-08 | 1 |
| 3 | 26400 | sum_visit_length | 2019-05-09 | 2019-05-09 | 1 |
| 3 | 25036 | sum_visit_length | 2019-05-10 | 2019-05-10 | 1 |
| 3 | 24970 | sum_visit_length | 2019-05-11 | 2019-05-11 | 1 |
| 3 | 24430 | sum_visit_length | 2019-05-12 | 2019-05-12 | 1 |
| 3 | 32284 | sum_visit_length | 2019-05-13 | 2019-05-13 | 1 |
| 207 | 51080 | sum_visit_length | 2019-05-13 | 2019-05-19 | 2 |
| 3 | 38912 | sum_visit_length | 2019-05-14 | 2019-05-14 | 1 |
| 3 | 44605 | sum_visit_length | 2019-05-15 | 2019-05-15 | 1 |
| 539 | 46046 | sum_visit_length | 2019-05-16 | 2019-05-16 | 1 |
| 374 | 51075 | sum_visit_length | 2019-05-17 | 2019-05-17 | 1 |
| 18 | 51164 | UserCountry_distinctCountries | 2019-05-01 | 2019-05-31 | 3 |
| 2 | 28538 | UserCountry_distinctCountries | 2019-05-05 | 2019-05-05 | 1 |
| 24 | 51080 | UserCountry_distinctCountries | 2019-05-13 | 2019-05-19 | 2 |
| 37 | 46046 | UserCountry_distinctCountries | 2019-05-16 | 2019-05-16 | 1 |
| 27 | 51075 | UserCountry_distinctCountries | 2019-05-17 | 2019-05-17 | 1 |
+-------+-----------+----------------------------------------------------+------------+------------+--------+
226 rows in set (0.08 sec) That wasted too much data space. |
Alot of same data has multi rows. mysql> SELECT * FROM `matomo_archive_numeric_2019_05` WHERE `idsite`=1 AND `name`='Actions_nb_pageviews' AND `date1`='2019-05-05' AND `date2`='2019-05-05' AND period=1;
+-----------+----------------------+--------+------------+------------+--------+---------------------+--------+
| idarchive | name | idsite | date1 | date2 | period | ts_archived | value |
+-----------+----------------------+--------+------------+------------+--------+---------------------+--------+
| 28538 | Actions_nb_pageviews | 1 | 2019-05-05 | 2019-05-05 | 1 | 2019-05-13 01:24:38 | 623730 |
| 28637 | Actions_nb_pageviews | 1 | 2019-05-05 | 2019-05-05 | 1 | 2019-05-13 01:29:57 | 623730 |
+-----------+----------------------+--------+------------+------------+--------+---------------------+--------+
2 rows in set (0.01 sec)
mysql> SELECT * from `matomo_archive_numeric_2019_05` WHERE idsite=1 AND `name`='Actions_nb_downloads' AND `date1`='2019-05-01' AND `date2`='2019-05-31' AND `period`=3;
+-----------+----------------------+--------+------------+------------+--------+---------------------+-------+
| idarchive | name | idsite | date1 | date2 | period | ts_archived | value |
+-----------+----------------------+--------+------------+------------+--------+---------------------+-------+
| 51164 | Actions_nb_downloads | 1 | 2019-05-01 | 2019-05-31 | 3 | 2019-05-17 00:16:11 | 2457 |
| 51214 | Actions_nb_downloads | 1 | 2019-05-01 | 2019-05-31 | 3 | 2019-05-17 00:17:59 | 2457 |
| 51325 | Actions_nb_downloads | 1 | 2019-05-01 | 2019-05-31 | 3 | 2019-05-17 00:20:32 | 2457 |
| 51409 | Actions_nb_downloads | 1 | 2019-05-01 | 2019-05-31 | 3 | 2019-05-17 00:22:06 | 2457 |
| 51567 | Actions_nb_downloads | 1 | 2019-05-01 | 2019-05-31 | 3 | 2019-05-17 00:25:13 | 2457 |
| 51771 | Actions_nb_downloads | 1 | 2019-05-01 | 2019-05-31 | 3 | 2019-05-17 00:29:26 | 2457 |
| 52015 | Actions_nb_downloads | 1 | 2019-05-01 | 2019-05-31 | 3 | 2019-05-17 02:08:58 | 2457 |
| 52100 | Actions_nb_downloads | 1 | 2019-05-01 | 2019-05-31 | 3 | 2019-05-17 02:10:49 | 2457 |
| 52211 | Actions_nb_downloads | 1 | 2019-05-01 | 2019-05-31 | 3 | 2019-05-17 02:13:14 | 2457 |
| 52295 | Actions_nb_downloads | 1 | 2019-05-01 | 2019-05-31 | 3 | 2019-05-17 02:14:51 | 2457 |
| 52457 | Actions_nb_downloads | 1 | 2019-05-01 | 2019-05-31 | 3 | 2019-05-17 02:18:19 | 2457 |
| 52661 | Actions_nb_downloads | 1 | 2019-05-01 | 2019-05-31 | 3 | 2019-05-17 02:22:37 | 2457 |
| 52914 | Actions_nb_downloads | 1 | 2019-05-01 | 2019-05-31 | 3 | 2019-05-17 04:22:33 | 2457 |
| 53003 | Actions_nb_downloads | 1 | 2019-05-01 | 2019-05-31 | 3 | 2019-05-17 04:27:34 | 2457 |
| 53114 | Actions_nb_downloads | 1 | 2019-05-01 | 2019-05-31 | 3 | 2019-05-17 04:33:32 | 2457 |
| 53198 | Actions_nb_downloads | 1 | 2019-05-01 | 2019-05-31 | 3 | 2019-05-17 04:37:22 | 2457 |
| 53354 | Actions_nb_downloads | 1 | 2019-05-01 | 2019-05-31 | 3 | 2019-05-17 04:42:58 | 2457 |
| 53538 | Actions_nb_downloads | 1 | 2019-05-01 | 2019-05-31 | 3 | 2019-05-17 04:50:24 | 2457 |
+-----------+----------------------+--------+------------+------------+--------+---------------------+-------+
18 rows in set (0.00 sec) |
It hasn't been an issue recently for us. Is anyone still experiencing this issue? |
Thank you for the report 👍 To likely fix the issue, could you upgrade to the latest Matomo version? if you still experience this issue afterwards, please re-open this and post a comment. Thanks! |
sgiehl
added
the
not-in-changelog
For issues or pull requests that should not be included in our release changelog on matomo.org.
label
Dec 11, 2023
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Labels
Bug
For errors / faults / flaws / inconsistencies etc.
not-in-changelog
For issues or pull requests that should not be included in our release changelog on matomo.org.
This issue occurs very rarely, but has been reported/seen multiple times already.
On the evolution graphs some days have 0 visits, but have pageviews:
Creating this bug report to document the workaround.
Example
Workaround
To fix this issue:
Reasons
Cause & root bug is still unknown... looking at the done flags, it looks like 2 totally different archives processed at different times yet having the same idarchive:
The text was updated successfully, but these errors were encountered: