Skip to content
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.

Sign up for GitHub

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

Jump to bottom

Report archives have tripled in size since update to 2.10 #7181

Closed
skyhawk669 opened this issue Feb 11, 2015 · 118 comments
Closed

Report archives have tripled in size since update to 2.10 #7181

skyhawk669 opened this issue Feb 11, 2015 · 118 comments
Labels
Task Indicates an issue is neither a feature nor a bug and it's purely a "technical" change.
Milestone
2.16.0

Comments

@skyhawk669
Copy link

Since upgrading to 2.10 the archive blobs and archive numbers tables have tripled in size (blob tables usually between 30-40MB, now they are 140-500MB).

The archiving process is set in cron to run every hour and nothing else has changed in the system beyond upgrading from 2.9 to 2.10 (no drastic change in amount of visitors, or to the structure of the site).

The tables are reduced in size a bit by running core:run-scheduled-tasks --force, but they're still quite a bit bigger than they used to be.

More background info in the following thread: http://forum.piwik.org/read.php?2,123852

Running Piwik on:
Red Hat 5
apache 2.4
PHP 5.4.35
MySQL 5.0.45
@mattab mattab added the Bug For errors / faults / flaws / inconsistencies etc. label Feb 19, 2015
@mattab mattab added this to the Short term milestone Feb 19, 2015
@mattab
Copy link
Member

mattab commented Feb 19, 2015

Hi @skyhawk669 thanks for the report. Do you maybe notice any improvement in 2.11.0 ?

@PatrickChen PatrickChen mentioned this issue Feb 23, 2015
Closed
@PatrickChen
Copy link

i also seem to have this problem. in my case, the problem seems to be that, after an upgrade, the January and February archive_blob and archive_numeric aren't purging their duplicate data. i suspect it's the upgrade as that is a common thread between me, skyhawk669, and gaumondp's situations.

here's a comparison of mysql queries after running
SELECT idsite, date1, date2, period, name, COUNT(*) as count FROM piwik_archive_numeric_... GROUP BY idsite, date1, date2, period, name HAVING count > 1;
month comparison

i've tried upgrading (a clone of) our piwik to 2.11.1, ran all the archive and scheduled tasks, and the db is still not purging the duplicates. when doing run-scheduled-tasks, it says "Purging temporary archives: skipped" for the January and February archives.

@gaumondp
Copy link

As asked by Matt I repost here but I start adding something more from my previous report :

In case it could be a clue : Another thing changed in February on my server: The CLI command changed from numeric IP in "--url=" to real domain...

console core:archive --url=http://1.2.3.4/ >> piwik-console-cron.log
Became:
core:archive --url=http://my.website.com/ >> piwik-console-cron.log

And this was my initial post:

Piwik 2.11.b3
PHP 5.3.13
Updated from command line.

Single Piwik instance with 6 web sites, about 2.5 millions pageviews a month.

Since the update mid-January, my Reports Table has double :
image

@CanuckNick
Copy link

I'm seeing the same thing here after we updated from 2.8.3 to 2.10.0. That being said, I can't say for sure that I noticed how large the tables were before the update. I noticed this after investigating some other issues we seem to be having. We have been on 2.11.1 for 24 hours now and the tables are still quite large. I'll be more than happy to run any queries for further diagnosis.

piwik_db1
piwik_db2

@PatrickChen
Copy link

@CanuckNick and @gaumondp can you both try running this query:
SELECT idsite, date1, date2, period, name, COUNT(*) as count FROM piwik_archive_numeric_2015_02 GROUP BY idsite, date1, date2, period, name HAVING count > 1;

If you see my screenshot above, I ran this query for 2014_12, 2015_01, and 2015_02, then sorted by the "Count" column. My results showed that 2014_12 and prior, the tables had at most Count's of 4, while 2015_01 and 2015_02 have Count's as high as 76 so far.

According to capedfuzz on the forum (http://forum.piwik.org/read.php?2,123852,page=1#msg-123931), this indicates that "If the result isn't an empty set and there are a lot of rows, it means there are lots of duplicate archives that aren't being deleted for some reason."

@CanuckNick
Copy link

Sure. My counts from November and December are considerably lower than January and February. Here are some screenshots of the highest counts. These are in the order of 2014_11, 2014_12, 2015_01, 2015_02.
piwik-112014
piwik-122014
piwik-012015
piwik-022015

@gaumondp
Copy link

Far from 1 :(

image

@mattab
Copy link
Member

mattab commented Feb 25, 2015

Thanks everyone for the reports, that's really helpful. It looks like the issue is that duplicated archives are not deleted as suggested by @diosmosis - we will fix it in the next major release.

Please write a comment if you also experience this issue and haven't commented yet!

@mattab mattab modified the milestones: Piwik 2.12.0, Short term, Piwik 2.11.2 Feb 25, 2015
@rainyroads
Copy link

I've noticed the same thing after upgrading. Table sizes have been massive over the last two months.

MariaDB [analytics]> SELECT table_name AS "Tables",  round(((data_length + index_length) / 1024 / 1024), 2) "Size in MB"  FROM information_schema.TABLES  WHERE table_schema = "analytics" ORDER BY (data_length + index_length) DESC;
+-------------------------------+------------+
| Tables                        | Size in MB |
+-------------------------------+------------+
| piwik_archive_blob_2015_02    |    4133.88 |
| piwik_archive_blob_2015_01    |    2871.53 |
| piwik_archive_blob_2014_12    |     172.08 |
| piwik_archive_blob_2014_01    |     167.11 |
| piwik_archive_blob_2014_03    |     160.19 |
| piwik_archive_blob_2013_08    |     159.14 |

Please excuse the huge pastes.
February 2015:

+--------+------------+------------+--------+----------------------------------------------------+-------+
| idsite | date1      | date2      | period | name                                               | count |
+--------+------------+------------+--------+----------------------------------------------------+-------+
|      1 | 2015-02-01 | 2015-02-01 |      1 | Actions_nb_downloads                               |    29 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | Actions_nb_hits_with_time_generation               |    29 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | Actions_nb_outlinks                                |    29 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | Actions_nb_pageviews                               |    29 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | Actions_nb_uniq_downloads                          |    29 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | Actions_nb_uniq_outlinks                           |    29 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | Actions_nb_uniq_pageviews                          |    29 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | Actions_sum_time_generation                        |    29 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | bounce_count                                       |    58 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | done                                               |    45 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | max_actions                                        |    58 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | nb_actions                                         |    58 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | nb_uniq_visitors                                   |    58 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | nb_visits                                          |    58 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | Referrers_distinctCampaigns                        |    29 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | Referrers_distinctKeywords                         |    29 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | Referrers_distinctSearchEngines                    |    29 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | Referrers_distinctWebsites                         |    29 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | Referrers_distinctWebsitesUrls                     |    29 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | sum_visit_length                                   |    58 |
|      1 | 2015-02-01 | 2015-02-01 |      1 | UserCountry_distinctCountries                      |    29 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | Actions_nb_downloads                               |   470 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | Actions_nb_hits_with_time_generation               |   470 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | Actions_nb_outlinks                                |   470 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | Actions_nb_pageviews                               |   470 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | Actions_nb_uniq_downloads                          |   470 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | Actions_nb_uniq_outlinks                           |   470 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | Actions_nb_uniq_pageviews                          |   470 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | Actions_sum_time_generation                        |   470 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | bounce_count                                       |   939 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | done                                               |   486 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | max_actions                                        |   939 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | nb_actions                                         |   939 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | nb_uniq_visitors                                   |   939 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | nb_users                                           |   137 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | nb_visits                                          |   939 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | Referrers_distinctKeywords                         |   470 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | Referrers_distinctSearchEngines                    |   470 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | Referrers_distinctWebsites                         |   470 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | Referrers_distinctWebsitesUrls                     |   470 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | sum_visit_length                                   |   939 |
|      1 | 2015-02-01 | 2015-02-28 |      3 | UserCountry_distinctCountries                      |   470 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | Actions_nb_downloads                               |    30 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | Actions_nb_hits_with_time_generation               |    30 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | Actions_nb_outlinks                                |    30 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | Actions_nb_pageviews                               |    30 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | Actions_nb_uniq_downloads                          |    30 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | Actions_nb_uniq_outlinks                           |    30 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | Actions_nb_uniq_pageviews                          |    30 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | Actions_sum_time_generation                        |    30 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | bounce_count                                       |    60 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | done                                               |    46 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | max_actions                                        |    60 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | nb_actions                                         |    60 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | nb_uniq_visitors                                   |    60 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | nb_visits                                          |    60 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | Referrers_distinctCampaigns                        |    30 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | Referrers_distinctKeywords                         |    30 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | Referrers_distinctSearchEngines                    |    30 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | Referrers_distinctWebsites                         |    30 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | Referrers_distinctWebsitesUrls                     |    30 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | sum_visit_length                                   |    60 |
|      1 | 2015-02-02 | 2015-02-02 |      1 | UserCountry_distinctCountries                      |    30 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | Actions_nb_downloads                               |    99 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | Actions_nb_hits_with_time_generation               |    99 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | Actions_nb_outlinks                                |    99 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | Actions_nb_pageviews                               |    99 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | Actions_nb_uniq_downloads                          |    99 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | Actions_nb_uniq_outlinks                           |    99 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | Actions_nb_uniq_pageviews                          |    99 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | Actions_sum_time_generation                        |    99 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | bounce_count                                       |   198 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | done                                               |   100 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | max_actions                                        |   198 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | nb_actions                                         |   198 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | nb_uniq_visitors                                   |   198 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | nb_visits                                          |   198 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | Referrers_distinctKeywords                         |    99 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | Referrers_distinctSearchEngines                    |    99 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | Referrers_distinctWebsites                         |    99 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | Referrers_distinctWebsitesUrls                     |    99 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | sum_visit_length                                   |   198 |
|      1 | 2015-02-02 | 2015-02-08 |      2 | UserCountry_distinctCountries                      |    99 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | Actions_nb_downloads                               |    30 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | Actions_nb_hits_with_time_generation               |    30 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | Actions_nb_outlinks                                |    30 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | Actions_nb_pageviews                               |    30 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | Actions_nb_uniq_downloads                          |    30 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | Actions_nb_uniq_outlinks                           |    30 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | Actions_nb_uniq_pageviews                          |    30 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | Actions_sum_time_generation                        |    30 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | bounce_count                                       |    60 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | done                                               |    48 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | max_actions                                        |    60 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | nb_actions                                         |    60 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | nb_uniq_visitors                                   |    60 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | nb_visits                                          |    60 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | Referrers_distinctCampaigns                        |    30 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | Referrers_distinctKeywords                         |    30 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | Referrers_distinctSearchEngines                    |    30 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | Referrers_distinctWebsites                         |    30 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | Referrers_distinctWebsitesUrls                     |    30 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | sum_visit_length                                   |    60 |
|      1 | 2015-02-03 | 2015-02-03 |      1 | UserCountry_distinctCountries                      |    30 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | Actions_nb_downloads                               |    29 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | Actions_nb_hits_with_time_generation               |    29 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | Actions_nb_outlinks                                |    29 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | Actions_nb_pageviews                               |    29 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | Actions_nb_uniq_downloads                          |    29 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | Actions_nb_uniq_outlinks                           |    29 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | Actions_nb_uniq_pageviews                          |    29 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | Actions_sum_time_generation                        |    29 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | bounce_count                                       |    58 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | done                                               |    48 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | max_actions                                        |    58 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | nb_actions                                         |    58 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | nb_uniq_visitors                                   |    58 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | nb_visits                                          |    58 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | Referrers_distinctCampaigns                        |    29 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | Referrers_distinctKeywords                         |    29 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | Referrers_distinctSearchEngines                    |    29 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | Referrers_distinctWebsites                         |    29 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | Referrers_distinctWebsitesUrls                     |    29 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | sum_visit_length                                   |    58 |
|      1 | 2015-02-04 | 2015-02-04 |      1 | UserCountry_distinctCountries                      |    29 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | Actions_nb_downloads                               |    28 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | Actions_nb_hits_with_time_generation               |    28 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | Actions_nb_outlinks                                |    28 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | Actions_nb_pageviews                               |    28 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | Actions_nb_uniq_downloads                          |    28 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | Actions_nb_uniq_outlinks                           |    28 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | Actions_nb_uniq_pageviews                          |    28 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | Actions_sum_time_generation                        |    28 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | bounce_count                                       |    56 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | done                                               |    45 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | max_actions                                        |    56 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | nb_actions                                         |    56 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | nb_uniq_visitors                                   |    56 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | nb_visits                                          |    56 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | Referrers_distinctCampaigns                        |    28 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | Referrers_distinctKeywords                         |    28 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | Referrers_distinctSearchEngines                    |    28 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | Referrers_distinctWebsites                         |    28 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | Referrers_distinctWebsitesUrls                     |    28 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | sum_visit_length                                   |    56 |
|      1 | 2015-02-05 | 2015-02-05 |      1 | UserCountry_distinctCountries                      |    28 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | Actions_nb_downloads                               |    29 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | Actions_nb_hits_with_time_generation               |    29 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | Actions_nb_outlinks                                |    29 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | Actions_nb_pageviews                               |    29 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | Actions_nb_uniq_downloads                          |    29 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | Actions_nb_uniq_outlinks                           |    29 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | Actions_nb_uniq_pageviews                          |    29 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | Actions_sum_time_generation                        |    29 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | bounce_count                                       |    58 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | done                                               |    45 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | max_actions                                        |    58 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | nb_actions                                         |    58 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | nb_uniq_visitors                                   |    58 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | nb_visits                                          |    58 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | Referrers_distinctCampaigns                        |    29 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | Referrers_distinctKeywords                         |    29 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | Referrers_distinctSearchEngines                    |    29 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | Referrers_distinctWebsites                         |    29 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | Referrers_distinctWebsitesUrls                     |    29 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | sum_visit_length                                   |    58 |
|      1 | 2015-02-06 | 2015-02-06 |      1 | UserCountry_distinctCountries                      |    29 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | Actions_nb_downloads                               |    29 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | Actions_nb_hits_with_time_generation               |    29 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | Actions_nb_outlinks                                |    29 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | Actions_nb_pageviews                               |    29 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | Actions_nb_uniq_downloads                          |    29 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | Actions_nb_uniq_outlinks                           |    29 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | Actions_nb_uniq_pageviews                          |    29 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | Actions_sum_time_generation                        |    29 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | bounce_count                                       |    58 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | done                                               |    47 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | max_actions                                        |    58 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | nb_actions                                         |    58 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | nb_uniq_visitors                                   |    58 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | nb_visits                                          |    58 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | Referrers_distinctCampaigns                        |    29 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | Referrers_distinctKeywords                         |    29 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | Referrers_distinctSearchEngines                    |    29 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | Referrers_distinctWebsites                         |    29 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | Referrers_distinctWebsitesUrls                     |    29 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | sum_visit_length                                   |    58 |
|      1 | 2015-02-07 | 2015-02-07 |      1 | UserCountry_distinctCountries                      |    29 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | Actions_nb_downloads                               |    29 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | Actions_nb_hits_with_time_generation               |    29 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | Actions_nb_outlinks                                |    29 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | Actions_nb_pageviews                               |    29 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | Actions_nb_uniq_downloads                          |    29 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | Actions_nb_uniq_outlinks                           |    29 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | Actions_nb_uniq_pageviews                          |    29 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | Actions_sum_time_generation                        |    29 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | bounce_count                                       |    58 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | done                                               |    47 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | max_actions                                        |    58 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | nb_actions                                         |    58 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | nb_uniq_visitors                                   |    58 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | nb_visits                                          |    58 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | Referrers_distinctCampaigns                        |    29 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | Referrers_distinctKeywords                         |    29 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | Referrers_distinctSearchEngines                    |    29 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | Referrers_distinctWebsites                         |    29 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | Referrers_distinctWebsitesUrls                     |    29 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | sum_visit_length                                   |    58 |
|      1 | 2015-02-08 | 2015-02-08 |      1 | UserCountry_distinctCountries                      |    29 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | Actions_nb_downloads                               |    29 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | Actions_nb_hits_with_time_generation               |    29 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | Actions_nb_outlinks                                |    29 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | Actions_nb_pageviews                               |    29 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | Actions_nb_uniq_downloads                          |    29 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | Actions_nb_uniq_outlinks                           |    29 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | Actions_nb_uniq_pageviews                          |    29 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | Actions_sum_time_generation                        |    29 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | bounce_count                                       |    58 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | done                                               |    47 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | max_actions                                        |    58 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | nb_actions                                         |    58 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | nb_uniq_visitors                                   |    58 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | nb_visits                                          |    58 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | Referrers_distinctCampaigns                        |    29 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | Referrers_distinctKeywords                         |    29 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | Referrers_distinctSearchEngines                    |    29 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | Referrers_distinctWebsites                         |    29 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | Referrers_distinctWebsitesUrls                     |    29 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | sum_visit_length                                   |    58 |
|      1 | 2015-02-09 | 2015-02-09 |      1 | UserCountry_distinctCountries                      |    29 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | Actions_nb_downloads                               |    98 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | Actions_nb_hits_with_time_generation               |    98 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | Actions_nb_outlinks                                |    98 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | Actions_nb_pageviews                               |    98 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | Actions_nb_uniq_downloads                          |    98 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | Actions_nb_uniq_outlinks                           |    98 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | Actions_nb_uniq_pageviews                          |    98 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | Actions_sum_time_generation                        |    98 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | bounce_count                                       |   196 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | done                                               |    99 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | max_actions                                        |   196 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | nb_actions                                         |   196 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | nb_uniq_visitors                                   |   196 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | nb_visits                                          |   196 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | Referrers_distinctKeywords                         |    98 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | Referrers_distinctSearchEngines                    |    98 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | Referrers_distinctWebsites                         |    98 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | Referrers_distinctWebsitesUrls                     |    98 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | sum_visit_length                                   |   196 |
|      1 | 2015-02-09 | 2015-02-15 |      2 | UserCountry_distinctCountries                      |    98 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | Actions_nb_downloads                               |    28 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | Actions_nb_hits_with_time_generation               |    28 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | Actions_nb_outlinks                                |    28 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | Actions_nb_pageviews                               |    28 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | Actions_nb_uniq_downloads                          |    28 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | Actions_nb_uniq_outlinks                           |    28 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | Actions_nb_uniq_pageviews                          |    28 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | Actions_sum_time_generation                        |    28 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | bounce_count                                       |    56 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | done                                               |    46 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | max_actions                                        |    56 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | nb_actions                                         |    56 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | nb_uniq_visitors                                   |    56 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | nb_visits                                          |    56 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | Referrers_distinctCampaigns                        |    28 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | Referrers_distinctKeywords                         |    28 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | Referrers_distinctSearchEngines                    |    28 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | Referrers_distinctWebsites                         |    28 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | Referrers_distinctWebsitesUrls                     |    28 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | sum_visit_length                                   |    56 |
|      1 | 2015-02-10 | 2015-02-10 |      1 | UserCountry_distinctCountries                      |    28 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | Actions_nb_downloads                               |    29 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | Actions_nb_hits_with_time_generation               |    29 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | Actions_nb_outlinks                                |    29 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | Actions_nb_pageviews                               |    29 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | Actions_nb_uniq_downloads                          |    29 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | Actions_nb_uniq_outlinks                           |    29 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | Actions_nb_uniq_pageviews                          |    29 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | Actions_sum_time_generation                        |    29 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | bounce_count                                       |    58 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | done                                               |    46 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | max_actions                                        |    58 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | nb_actions                                         |    58 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | nb_uniq_visitors                                   |    58 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | nb_visits                                          |    58 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | Referrers_distinctCampaigns                        |    29 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | Referrers_distinctKeywords                         |    29 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | Referrers_distinctSearchEngines                    |    29 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | Referrers_distinctWebsites                         |    29 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | Referrers_distinctWebsitesUrls                     |    29 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | sum_visit_length                                   |    58 |
|      1 | 2015-02-11 | 2015-02-11 |      1 | UserCountry_distinctCountries                      |    29 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | Actions_nb_downloads                               |    31 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | Actions_nb_hits_with_time_generation               |    31 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | Actions_nb_outlinks                                |    31 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | Actions_nb_pageviews                               |    31 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | Actions_nb_uniq_downloads                          |    31 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | Actions_nb_uniq_outlinks                           |    31 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | Actions_nb_uniq_pageviews                          |    31 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | Actions_sum_time_generation                        |    31 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | bounce_count                                       |    62 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | done                                               |    48 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | max_actions                                        |    62 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | nb_actions                                         |    62 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | nb_uniq_visitors                                   |    62 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | nb_visits                                          |    62 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | Referrers_distinctCampaigns                        |    31 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | Referrers_distinctKeywords                         |    31 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | Referrers_distinctSearchEngines                    |    31 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | Referrers_distinctWebsites                         |    31 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | Referrers_distinctWebsitesUrls                     |    31 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | sum_visit_length                                   |    62 |
|      1 | 2015-02-12 | 2015-02-12 |      1 | UserCountry_distinctCountries                      |    31 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | Actions_nb_downloads                               |    29 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | Actions_nb_hits_with_time_generation               |    29 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | Actions_nb_outlinks                                |    29 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | Actions_nb_pageviews                               |    29 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | Actions_nb_uniq_downloads                          |    29 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | Actions_nb_uniq_outlinks                           |    29 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | Actions_nb_uniq_pageviews                          |    29 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | Actions_sum_time_generation                        |    29 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | bounce_count                                       |    58 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | done                                               |    48 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | max_actions                                        |    58 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | nb_actions                                         |    58 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | nb_uniq_visitors                                   |    58 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | nb_visits                                          |    58 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | Referrers_distinctCampaigns                        |    29 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | Referrers_distinctKeywords                         |    29 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | Referrers_distinctSearchEngines                    |    29 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | Referrers_distinctWebsites                         |    29 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | Referrers_distinctWebsitesUrls                     |    29 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | sum_visit_length                                   |    58 |
|      1 | 2015-02-13 | 2015-02-13 |      1 | UserCountry_distinctCountries                      |    29 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | Actions_nb_downloads                               |    29 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | Actions_nb_hits_with_time_generation               |    29 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | Actions_nb_outlinks                                |    29 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | Actions_nb_pageviews                               |    29 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | Actions_nb_uniq_downloads                          |    29 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | Actions_nb_uniq_outlinks                           |    29 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | Actions_nb_uniq_pageviews                          |    29 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | Actions_sum_time_generation                        |    29 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | bounce_count                                       |    58 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | done                                               |    47 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | max_actions                                        |    58 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | nb_actions                                         |    58 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | nb_uniq_visitors                                   |    58 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | nb_visits                                          |    58 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | Referrers_distinctCampaigns                        |    29 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | Referrers_distinctKeywords                         |    29 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | Referrers_distinctSearchEngines                    |    29 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | Referrers_distinctWebsites                         |    29 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | Referrers_distinctWebsitesUrls                     |    29 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | sum_visit_length                                   |    58 |
|      1 | 2015-02-14 | 2015-02-14 |      1 | UserCountry_distinctCountries                      |    29 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | Actions_nb_downloads                               |    30 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | Actions_nb_hits_with_time_generation               |    30 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | Actions_nb_outlinks                                |    30 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | Actions_nb_pageviews                               |    30 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | Actions_nb_uniq_downloads                          |    30 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | Actions_nb_uniq_outlinks                           |    30 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | Actions_nb_uniq_pageviews                          |    30 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | Actions_sum_time_generation                        |    30 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | bounce_count                                       |    60 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | done                                               |    47 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | max_actions                                        |    60 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | nb_actions                                         |    60 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | nb_uniq_visitors                                   |    60 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | nb_visits                                          |    60 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | Referrers_distinctCampaigns                        |    30 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | Referrers_distinctKeywords                         |    30 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | Referrers_distinctSearchEngines                    |    30 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | Referrers_distinctWebsites                         |    30 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | Referrers_distinctWebsitesUrls                     |    30 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | sum_visit_length                                   |    60 |
|      1 | 2015-02-15 | 2015-02-15 |      1 | UserCountry_distinctCountries                      |    30 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | Actions_nb_downloads                               |    30 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | Actions_nb_hits_with_time_generation               |    30 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | Actions_nb_outlinks                                |    30 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | Actions_nb_pageviews                               |    30 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | Actions_nb_uniq_downloads                          |    30 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | Actions_nb_uniq_outlinks                           |    30 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | Actions_nb_uniq_pageviews                          |    30 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | Actions_sum_time_generation                        |    30 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | bounce_count                                       |    59 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | done                                               |    47 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | max_actions                                        |    59 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | nb_actions                                         |    59 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | nb_uniq_visitors                                   |    59 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | nb_visits                                          |    59 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | Referrers_distinctCampaigns                        |    30 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | Referrers_distinctKeywords                         |    30 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | Referrers_distinctSearchEngines                    |    30 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | Referrers_distinctWebsites                         |    30 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | Referrers_distinctWebsitesUrls                     |    29 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | sum_visit_length                                   |    59 |
|      1 | 2015-02-16 | 2015-02-16 |      1 | UserCountry_distinctCountries                      |    30 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | Actions_nb_downloads                               |   101 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | Actions_nb_hits_with_time_generation               |   101 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | Actions_nb_outlinks                                |   101 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | Actions_nb_pageviews                               |   101 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | Actions_nb_uniq_downloads                          |   101 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | Actions_nb_uniq_outlinks                           |   101 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | Actions_nb_uniq_pageviews                          |   101 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | Actions_sum_time_generation                        |   101 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | bounce_count                                       |   201 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | done                                               |   101 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | max_actions                                        |   201 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | nb_actions                                         |   201 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | nb_uniq_visitors                                   |   201 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | nb_users                                           |    30 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | nb_visits                                          |   201 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | Referrers_distinctKeywords                         |   101 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | Referrers_distinctSearchEngines                    |   101 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | Referrers_distinctWebsites                         |   100 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | Referrers_distinctWebsitesUrls                     |   100 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | sum_visit_length                                   |   201 |
|      1 | 2015-02-16 | 2015-02-22 |      2 | UserCountry_distinctCountries                      |   101 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | Actions_nb_downloads                               |    29 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | Actions_nb_hits_with_time_generation               |    29 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | Actions_nb_outlinks                                |    29 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | Actions_nb_pageviews                               |    29 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | Actions_nb_uniq_downloads                          |    29 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | Actions_nb_uniq_outlinks                           |    29 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | Actions_nb_uniq_pageviews                          |    29 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | Actions_sum_time_generation                        |    29 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | bounce_count                                       |    58 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | done                                               |    47 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | max_actions                                        |    58 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | nb_actions                                         |    58 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | nb_uniq_visitors                                   |    58 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | nb_visits                                          |    58 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | Referrers_distinctCampaigns                        |    29 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | Referrers_distinctKeywords                         |    29 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | Referrers_distinctSearchEngines                    |    29 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | Referrers_distinctWebsites                         |    29 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | Referrers_distinctWebsitesUrls                     |    29 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | sum_visit_length                                   |    58 |
|      1 | 2015-02-17 | 2015-02-17 |      1 | UserCountry_distinctCountries                      |    29 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | Actions_nb_downloads                               |    30 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | Actions_nb_hits_with_time_generation               |    30 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | Actions_nb_outlinks                                |    30 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | Actions_nb_pageviews                               |    30 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | Actions_nb_uniq_downloads                          |    30 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | Actions_nb_uniq_outlinks                           |    30 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | Actions_nb_uniq_pageviews                          |    30 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | Actions_sum_time_generation                        |    30 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | bounce_count                                       |    60 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | done                                               |    47 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | max_actions                                        |    60 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | nb_actions                                         |    60 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | nb_uniq_visitors                                   |    60 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | nb_visits                                          |    60 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | Referrers_distinctCampaigns                        |    30 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | Referrers_distinctKeywords                         |    30 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | Referrers_distinctSearchEngines                    |    30 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | Referrers_distinctWebsites                         |    30 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | Referrers_distinctWebsitesUrls                     |    30 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | sum_visit_length                                   |    60 |
|      1 | 2015-02-18 | 2015-02-18 |      1 | UserCountry_distinctCountries                      |    30 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | Actions_nb_downloads                               |    28 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | Actions_nb_hits_with_time_generation               |    28 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | Actions_nb_outlinks                                |    28 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | Actions_nb_pageviews                               |    28 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | Actions_nb_uniq_downloads                          |    28 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | Actions_nb_uniq_outlinks                           |    28 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | Actions_nb_uniq_pageviews                          |    28 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | Actions_sum_time_generation                        |    28 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | bounce_count                                       |    56 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | done                                               |    46 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | max_actions                                        |    56 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | nb_actions                                         |    56 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | nb_uniq_visitors                                   |    56 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | nb_visits                                          |    56 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | Referrers_distinctCampaigns                        |    28 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | Referrers_distinctKeywords                         |    28 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | Referrers_distinctSearchEngines                    |    28 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | Referrers_distinctWebsites                         |    28 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | Referrers_distinctWebsitesUrls                     |    28 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | sum_visit_length                                   |    56 |
|      1 | 2015-02-19 | 2015-02-19 |      1 | UserCountry_distinctCountries                      |    28 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | Actions_nb_downloads                               |    29 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | Actions_nb_hits_with_time_generation               |    29 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | Actions_nb_outlinks                                |    29 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | Actions_nb_pageviews                               |    29 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | Actions_nb_uniq_downloads                          |    29 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | Actions_nb_uniq_outlinks                           |    29 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | Actions_nb_uniq_pageviews                          |    29 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | Actions_sum_time_generation                        |    29 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | bounce_count                                       |    58 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | done                                               |    46 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | max_actions                                        |    58 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | nb_actions                                         |    58 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | nb_uniq_visitors                                   |    58 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | nb_visits                                          |    58 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | Referrers_distinctCampaigns                        |    29 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | Referrers_distinctKeywords                         |    29 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | Referrers_distinctSearchEngines                    |    29 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | Referrers_distinctWebsites                         |    29 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | Referrers_distinctWebsitesUrls                     |    29 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | sum_visit_length                                   |    58 |
|      1 | 2015-02-20 | 2015-02-20 |      1 | UserCountry_distinctCountries                      |    29 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | Actions_nb_downloads                               |    29 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | Actions_nb_hits_with_time_generation               |    29 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | Actions_nb_outlinks                                |    29 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | Actions_nb_pageviews                               |    29 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | Actions_nb_uniq_downloads                          |    29 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | Actions_nb_uniq_outlinks                           |    29 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | Actions_nb_uniq_pageviews                          |    29 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | Actions_sum_time_generation                        |    29 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | bounce_count                                       |    58 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | done                                               |    47 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | max_actions                                        |    58 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | nb_actions                                         |    58 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | nb_uniq_visitors                                   |    58 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | nb_visits                                          |    58 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | Referrers_distinctCampaigns                        |    29 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | Referrers_distinctKeywords                         |    29 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | Referrers_distinctSearchEngines                    |    29 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | Referrers_distinctWebsites                         |    29 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | Referrers_distinctWebsitesUrls                     |    29 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | sum_visit_length                                   |    58 |
|      1 | 2015-02-21 | 2015-02-21 |      1 | UserCountry_distinctCountries                      |    29 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | Actions_nb_downloads                               |    41 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | Actions_nb_hits_with_time_generation               |    41 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | Actions_nb_outlinks                                |    41 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | Actions_nb_pageviews                               |    41 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | Actions_nb_uniq_downloads                          |    41 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | Actions_nb_uniq_outlinks                           |    41 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | Actions_nb_uniq_pageviews                          |    41 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | Actions_sum_time_generation                        |    41 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | bounce_count                                       |    82 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | done                                               |    58 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | max_actions                                        |    82 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | nb_actions                                         |    82 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | nb_uniq_visitors                                   |    82 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | nb_users                                           |    76 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | nb_visits                                          |    82 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | Referrers_distinctCampaigns                        |    24 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | Referrers_distinctKeywords                         |    41 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | Referrers_distinctSearchEngines                    |    41 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | Referrers_distinctWebsites                         |    41 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | Referrers_distinctWebsitesUrls                     |    41 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | sum_visit_length                                   |    82 |
|      1 | 2015-02-22 | 2015-02-22 |      1 | UserCountry_distinctCountries                      |    41 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | Actions_nb_downloads                               |    31 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | Actions_nb_hits_with_time_generation               |    31 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | Actions_nb_outlinks                                |    31 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | Actions_nb_pageviews                               |    31 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | Actions_nb_uniq_downloads                          |    31 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | Actions_nb_uniq_outlinks                           |    31 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | Actions_nb_uniq_pageviews                          |    31 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | Actions_sum_time_generation                        |    31 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | bounce_count                                       |    62 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | done                                               |    48 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | max_actions                                        |    62 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | nb_actions                                         |    62 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | nb_uniq_visitors                                   |    62 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | nb_visits                                          |    62 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | Referrers_distinctKeywords                         |    31 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | Referrers_distinctSearchEngines                    |    31 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | Referrers_distinctWebsites                         |    31 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | Referrers_distinctWebsitesUrls                     |    31 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | sum_visit_length                                   |    62 |
|      1 | 2015-02-23 | 2015-02-23 |      1 | UserCountry_distinctCountries                      |    31 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | Actions_nb_downloads                               |    36 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | Actions_nb_hits_with_time_generation               |    36 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | Actions_nb_outlinks                                |    36 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | Actions_nb_pageviews                               |    36 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | Actions_nb_uniq_downloads                          |    36 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | Actions_nb_uniq_outlinks                           |    36 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | Actions_nb_uniq_pageviews                          |    36 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | Actions_sum_time_generation                        |    36 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | bounce_count                                       |    72 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | done                                               |    38 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | max_actions                                        |    72 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | nb_actions                                         |    72 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | nb_uniq_visitors                                   |    72 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | nb_users                                           |    22 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | nb_visits                                          |    72 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | Referrers_distinctKeywords                         |    36 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | Referrers_distinctSearchEngines                    |    36 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | Referrers_distinctWebsites                         |    36 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | Referrers_distinctWebsitesUrls                     |    36 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | sum_visit_length                                   |    72 |
|      1 | 2015-02-23 | 2015-03-01 |      2 | UserCountry_distinctCountries                      |    36 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | Actions_nb_downloads                               |    30 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | Actions_nb_hits_with_time_generation               |    30 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | Actions_nb_outlinks                                |    30 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | Actions_nb_pageviews                               |    30 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | Actions_nb_uniq_downloads                          |    30 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | Actions_nb_uniq_outlinks                           |    30 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | Actions_nb_uniq_pageviews                          |    30 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | Actions_sum_time_generation                        |    30 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | bounce_count                                       |    60 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | done                                               |    49 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | max_actions                                        |    60 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | nb_actions                                         |    60 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | nb_uniq_visitors                                   |    60 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | nb_users                                           |    30 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | nb_visits                                          |    60 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | Referrers_distinctKeywords                         |    30 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | Referrers_distinctSearchEngines                    |    30 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | Referrers_distinctWebsites                         |    30 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | Referrers_distinctWebsitesUrls                     |    30 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | sum_visit_length                                   |    60 |
|      1 | 2015-02-24 | 2015-02-24 |      1 | UserCountry_distinctCountries                      |    30 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | Actions_nb_downloads                               |     9 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | Actions_nb_hits_with_time_generation               |     9 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | Actions_nb_outlinks                                |     9 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | Actions_nb_pageviews                               |     9 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | Actions_nb_uniq_downloads                          |     9 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | Actions_nb_uniq_outlinks                           |     9 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | Actions_nb_uniq_pageviews                          |     9 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | Actions_sum_time_generation                        |     9 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | bounce_count                                       |    18 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | done                                               |    26 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | max_actions                                        |    18 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | nb_actions                                         |    18 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | nb_uniq_visitors                                   |    18 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | nb_visits                                          |    18 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | Referrers_distinctKeywords                         |     9 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | Referrers_distinctSearchEngines                    |     9 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | Referrers_distinctWebsites                         |     9 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | Referrers_distinctWebsitesUrls                     |     9 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | sum_visit_length                                   |    18 |
|      1 | 2015-02-25 | 2015-02-25 |      1 | UserCountry_distinctCountries                      |     9 |
|      1 | 2015-02-26 | 2015-02-26 |      1 | done                                               |    17 |
|      1 | 2015-02-27 | 2015-02-27 |      1 | done                                               |     4 |
+--------+------------+------------+--------+----------------------------------------------------+-------+

December 2014:

MariaDB [analytics]> SELECT idsite, date1, date2, period, name, COUNT(*) as count FROM piwik_archive_numeric_2014_12 GROUP BY idsite, date1, date2, period, name HAVING count > 1;
+--------+------------+------------+--------+------------------+-------+
| idsite | date1      | date2      | period | name             | count |
+--------+------------+------------+--------+------------------+-------+
|      1 | 2014-12-01 | 2014-12-01 |      1 | bounce_count     |     2 |
|      1 | 2014-12-01 | 2014-12-01 |      1 | max_actions      |     2 |
|      1 | 2014-12-01 | 2014-12-01 |      1 | nb_actions       |     2 |
|      1 | 2014-12-01 | 2014-12-01 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-01 | 2014-12-01 |      1 | nb_visits        |     2 |
|      1 | 2014-12-01 | 2014-12-01 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-01 | 2014-12-07 |      2 | bounce_count     |     2 |
|      1 | 2014-12-01 | 2014-12-07 |      2 | max_actions      |     2 |
|      1 | 2014-12-01 | 2014-12-07 |      2 | nb_actions       |     2 |
|      1 | 2014-12-01 | 2014-12-07 |      2 | nb_uniq_visitors |     2 |
|      1 | 2014-12-01 | 2014-12-07 |      2 | nb_visits        |     2 |
|      1 | 2014-12-01 | 2014-12-07 |      2 | sum_visit_length |     2 |
|      1 | 2014-12-01 | 2014-12-31 |      3 | bounce_count     |     2 |
|      1 | 2014-12-01 | 2014-12-31 |      3 | max_actions      |     2 |
|      1 | 2014-12-01 | 2014-12-31 |      3 | nb_actions       |     2 |
|      1 | 2014-12-01 | 2014-12-31 |      3 | nb_uniq_visitors |     2 |
|      1 | 2014-12-01 | 2014-12-31 |      3 | nb_visits        |     2 |
|      1 | 2014-12-01 | 2014-12-31 |      3 | sum_visit_length |     2 |
|      1 | 2014-12-02 | 2014-12-02 |      1 | bounce_count     |     2 |
|      1 | 2014-12-02 | 2014-12-02 |      1 | max_actions      |     2 |
|      1 | 2014-12-02 | 2014-12-02 |      1 | nb_actions       |     2 |
|      1 | 2014-12-02 | 2014-12-02 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-02 | 2014-12-02 |      1 | nb_visits        |     2 |
|      1 | 2014-12-02 | 2014-12-02 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-03 | 2014-12-03 |      1 | bounce_count     |     2 |
|      1 | 2014-12-03 | 2014-12-03 |      1 | max_actions      |     2 |
|      1 | 2014-12-03 | 2014-12-03 |      1 | nb_actions       |     2 |
|      1 | 2014-12-03 | 2014-12-03 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-03 | 2014-12-03 |      1 | nb_visits        |     2 |
|      1 | 2014-12-03 | 2014-12-03 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-04 | 2014-12-04 |      1 | bounce_count     |     2 |
|      1 | 2014-12-04 | 2014-12-04 |      1 | max_actions      |     2 |
|      1 | 2014-12-04 | 2014-12-04 |      1 | nb_actions       |     2 |
|      1 | 2014-12-04 | 2014-12-04 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-04 | 2014-12-04 |      1 | nb_visits        |     2 |
|      1 | 2014-12-04 | 2014-12-04 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-05 | 2014-12-05 |      1 | bounce_count     |     2 |
|      1 | 2014-12-05 | 2014-12-05 |      1 | max_actions      |     2 |
|      1 | 2014-12-05 | 2014-12-05 |      1 | nb_actions       |     2 |
|      1 | 2014-12-05 | 2014-12-05 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-05 | 2014-12-05 |      1 | nb_visits        |     2 |
|      1 | 2014-12-05 | 2014-12-05 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-06 | 2014-12-06 |      1 | bounce_count     |     2 |
|      1 | 2014-12-06 | 2014-12-06 |      1 | max_actions      |     2 |
|      1 | 2014-12-06 | 2014-12-06 |      1 | nb_actions       |     2 |
|      1 | 2014-12-06 | 2014-12-06 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-06 | 2014-12-06 |      1 | nb_visits        |     2 |
|      1 | 2014-12-06 | 2014-12-06 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-07 | 2014-12-07 |      1 | bounce_count     |     2 |
|      1 | 2014-12-07 | 2014-12-07 |      1 | max_actions      |     2 |
|      1 | 2014-12-07 | 2014-12-07 |      1 | nb_actions       |     2 |
|      1 | 2014-12-07 | 2014-12-07 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-07 | 2014-12-07 |      1 | nb_visits        |     2 |
|      1 | 2014-12-07 | 2014-12-07 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-08 | 2014-12-08 |      1 | bounce_count     |     2 |
|      1 | 2014-12-08 | 2014-12-08 |      1 | max_actions      |     2 |
|      1 | 2014-12-08 | 2014-12-08 |      1 | nb_actions       |     2 |
|      1 | 2014-12-08 | 2014-12-08 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-08 | 2014-12-08 |      1 | nb_visits        |     2 |
|      1 | 2014-12-08 | 2014-12-08 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-08 | 2014-12-14 |      2 | bounce_count     |     2 |
|      1 | 2014-12-08 | 2014-12-14 |      2 | max_actions      |     2 |
|      1 | 2014-12-08 | 2014-12-14 |      2 | nb_actions       |     2 |
|      1 | 2014-12-08 | 2014-12-14 |      2 | nb_uniq_visitors |     2 |
|      1 | 2014-12-08 | 2014-12-14 |      2 | nb_visits        |     2 |
|      1 | 2014-12-08 | 2014-12-14 |      2 | sum_visit_length |     2 |
|      1 | 2014-12-09 | 2014-12-09 |      1 | bounce_count     |     2 |
|      1 | 2014-12-09 | 2014-12-09 |      1 | max_actions      |     2 |
|      1 | 2014-12-09 | 2014-12-09 |      1 | nb_actions       |     2 |
|      1 | 2014-12-09 | 2014-12-09 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-09 | 2014-12-09 |      1 | nb_visits        |     2 |
|      1 | 2014-12-09 | 2014-12-09 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-10 | 2014-12-10 |      1 | bounce_count     |     2 |
|      1 | 2014-12-10 | 2014-12-10 |      1 | max_actions      |     2 |
|      1 | 2014-12-10 | 2014-12-10 |      1 | nb_actions       |     2 |
|      1 | 2014-12-10 | 2014-12-10 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-10 | 2014-12-10 |      1 | nb_visits        |     2 |
|      1 | 2014-12-10 | 2014-12-10 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-11 | 2014-12-11 |      1 | bounce_count     |     2 |
|      1 | 2014-12-11 | 2014-12-11 |      1 | max_actions      |     2 |
|      1 | 2014-12-11 | 2014-12-11 |      1 | nb_actions       |     2 |
|      1 | 2014-12-11 | 2014-12-11 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-11 | 2014-12-11 |      1 | nb_visits        |     2 |
|      1 | 2014-12-11 | 2014-12-11 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-12 | 2014-12-12 |      1 | bounce_count     |     2 |
|      1 | 2014-12-12 | 2014-12-12 |      1 | max_actions      |     2 |
|      1 | 2014-12-12 | 2014-12-12 |      1 | nb_actions       |     2 |
|      1 | 2014-12-12 | 2014-12-12 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-12 | 2014-12-12 |      1 | nb_visits        |     2 |
|      1 | 2014-12-12 | 2014-12-12 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-13 | 2014-12-13 |      1 | bounce_count     |     2 |
|      1 | 2014-12-13 | 2014-12-13 |      1 | max_actions      |     2 |
|      1 | 2014-12-13 | 2014-12-13 |      1 | nb_actions       |     2 |
|      1 | 2014-12-13 | 2014-12-13 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-13 | 2014-12-13 |      1 | nb_visits        |     2 |
|      1 | 2014-12-13 | 2014-12-13 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-14 | 2014-12-14 |      1 | bounce_count     |     2 |
|      1 | 2014-12-14 | 2014-12-14 |      1 | max_actions      |     2 |
|      1 | 2014-12-14 | 2014-12-14 |      1 | nb_actions       |     2 |
|      1 | 2014-12-14 | 2014-12-14 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-14 | 2014-12-14 |      1 | nb_visits        |     2 |
|      1 | 2014-12-14 | 2014-12-14 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-15 | 2014-12-15 |      1 | bounce_count     |     2 |
|      1 | 2014-12-15 | 2014-12-15 |      1 | max_actions      |     2 |
|      1 | 2014-12-15 | 2014-12-15 |      1 | nb_actions       |     2 |
|      1 | 2014-12-15 | 2014-12-15 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-15 | 2014-12-15 |      1 | nb_visits        |     2 |
|      1 | 2014-12-15 | 2014-12-15 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-15 | 2014-12-21 |      2 | bounce_count     |     2 |
|      1 | 2014-12-15 | 2014-12-21 |      2 | max_actions      |     2 |
|      1 | 2014-12-15 | 2014-12-21 |      2 | nb_actions       |     2 |
|      1 | 2014-12-15 | 2014-12-21 |      2 | nb_uniq_visitors |     2 |
|      1 | 2014-12-15 | 2014-12-21 |      2 | nb_visits        |     2 |
|      1 | 2014-12-15 | 2014-12-21 |      2 | sum_visit_length |     2 |
|      1 | 2014-12-16 | 2014-12-16 |      1 | bounce_count     |     2 |
|      1 | 2014-12-16 | 2014-12-16 |      1 | max_actions      |     2 |
|      1 | 2014-12-16 | 2014-12-16 |      1 | nb_actions       |     2 |
|      1 | 2014-12-16 | 2014-12-16 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-16 | 2014-12-16 |      1 | nb_visits        |     2 |
|      1 | 2014-12-16 | 2014-12-16 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-17 | 2014-12-17 |      1 | bounce_count     |     2 |
|      1 | 2014-12-17 | 2014-12-17 |      1 | max_actions      |     2 |
|      1 | 2014-12-17 | 2014-12-17 |      1 | nb_actions       |     2 |
|      1 | 2014-12-17 | 2014-12-17 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-17 | 2014-12-17 |      1 | nb_visits        |     2 |
|      1 | 2014-12-17 | 2014-12-17 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-18 | 2014-12-18 |      1 | bounce_count     |     2 |
|      1 | 2014-12-18 | 2014-12-18 |      1 | max_actions      |     2 |
|      1 | 2014-12-18 | 2014-12-18 |      1 | nb_actions       |     2 |
|      1 | 2014-12-18 | 2014-12-18 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-18 | 2014-12-18 |      1 | nb_visits        |     2 |
|      1 | 2014-12-18 | 2014-12-18 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-19 | 2014-12-19 |      1 | bounce_count     |     2 |
|      1 | 2014-12-19 | 2014-12-19 |      1 | max_actions      |     2 |
|      1 | 2014-12-19 | 2014-12-19 |      1 | nb_actions       |     2 |
|      1 | 2014-12-19 | 2014-12-19 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-19 | 2014-12-19 |      1 | nb_visits        |     2 |
|      1 | 2014-12-19 | 2014-12-19 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-20 | 2014-12-20 |      1 | bounce_count     |     2 |
|      1 | 2014-12-20 | 2014-12-20 |      1 | max_actions      |     2 |
|      1 | 2014-12-20 | 2014-12-20 |      1 | nb_actions       |     2 |
|      1 | 2014-12-20 | 2014-12-20 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-20 | 2014-12-20 |      1 | nb_visits        |     2 |
|      1 | 2014-12-20 | 2014-12-20 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-21 | 2014-12-21 |      1 | bounce_count     |     2 |
|      1 | 2014-12-21 | 2014-12-21 |      1 | max_actions      |     2 |
|      1 | 2014-12-21 | 2014-12-21 |      1 | nb_actions       |     2 |
|      1 | 2014-12-21 | 2014-12-21 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-21 | 2014-12-21 |      1 | nb_visits        |     2 |
|      1 | 2014-12-21 | 2014-12-21 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-22 | 2014-12-22 |      1 | bounce_count     |     2 |
|      1 | 2014-12-22 | 2014-12-22 |      1 | max_actions      |     2 |
|      1 | 2014-12-22 | 2014-12-22 |      1 | nb_actions       |     2 |
|      1 | 2014-12-22 | 2014-12-22 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-22 | 2014-12-22 |      1 | nb_visits        |     2 |
|      1 | 2014-12-22 | 2014-12-22 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-22 | 2014-12-28 |      2 | bounce_count     |     2 |
|      1 | 2014-12-22 | 2014-12-28 |      2 | max_actions      |     2 |
|      1 | 2014-12-22 | 2014-12-28 |      2 | nb_actions       |     2 |
|      1 | 2014-12-22 | 2014-12-28 |      2 | nb_uniq_visitors |     2 |
|      1 | 2014-12-22 | 2014-12-28 |      2 | nb_visits        |     2 |
|      1 | 2014-12-22 | 2014-12-28 |      2 | sum_visit_length |     2 |
|      1 | 2014-12-23 | 2014-12-23 |      1 | bounce_count     |     2 |
|      1 | 2014-12-23 | 2014-12-23 |      1 | max_actions      |     2 |
|      1 | 2014-12-23 | 2014-12-23 |      1 | nb_actions       |     2 |
|      1 | 2014-12-23 | 2014-12-23 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-23 | 2014-12-23 |      1 | nb_visits        |     2 |
|      1 | 2014-12-23 | 2014-12-23 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-24 | 2014-12-24 |      1 | bounce_count     |     2 |
|      1 | 2014-12-24 | 2014-12-24 |      1 | max_actions      |     2 |
|      1 | 2014-12-24 | 2014-12-24 |      1 | nb_actions       |     2 |
|      1 | 2014-12-24 | 2014-12-24 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-24 | 2014-12-24 |      1 | nb_visits        |     2 |
|      1 | 2014-12-24 | 2014-12-24 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-25 | 2014-12-25 |      1 | bounce_count     |     2 |
|      1 | 2014-12-25 | 2014-12-25 |      1 | max_actions      |     2 |
|      1 | 2014-12-25 | 2014-12-25 |      1 | nb_actions       |     2 |
|      1 | 2014-12-25 | 2014-12-25 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-25 | 2014-12-25 |      1 | nb_visits        |     2 |
|      1 | 2014-12-25 | 2014-12-25 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-26 | 2014-12-26 |      1 | bounce_count     |     2 |
|      1 | 2014-12-26 | 2014-12-26 |      1 | max_actions      |     2 |
|      1 | 2014-12-26 | 2014-12-26 |      1 | nb_actions       |     2 |
|      1 | 2014-12-26 | 2014-12-26 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-26 | 2014-12-26 |      1 | nb_visits        |     2 |
|      1 | 2014-12-26 | 2014-12-26 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-27 | 2014-12-27 |      1 | bounce_count     |     2 |
|      1 | 2014-12-27 | 2014-12-27 |      1 | max_actions      |     2 |
|      1 | 2014-12-27 | 2014-12-27 |      1 | nb_actions       |     2 |
|      1 | 2014-12-27 | 2014-12-27 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-27 | 2014-12-27 |      1 | nb_visits        |     2 |
|      1 | 2014-12-27 | 2014-12-27 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-28 | 2014-12-28 |      1 | bounce_count     |     2 |
|      1 | 2014-12-28 | 2014-12-28 |      1 | max_actions      |     2 |
|      1 | 2014-12-28 | 2014-12-28 |      1 | nb_actions       |     2 |
|      1 | 2014-12-28 | 2014-12-28 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-28 | 2014-12-28 |      1 | nb_visits        |     2 |
|      1 | 2014-12-28 | 2014-12-28 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-29 | 2014-12-29 |      1 | bounce_count     |     2 |
|      1 | 2014-12-29 | 2014-12-29 |      1 | max_actions      |     2 |
|      1 | 2014-12-29 | 2014-12-29 |      1 | nb_actions       |     2 |
|      1 | 2014-12-29 | 2014-12-29 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-29 | 2014-12-29 |      1 | nb_visits        |     2 |
|      1 | 2014-12-29 | 2014-12-29 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-29 | 2015-01-04 |      2 | bounce_count     |     2 |
|      1 | 2014-12-29 | 2015-01-04 |      2 | max_actions      |     2 |
|      1 | 2014-12-29 | 2015-01-04 |      2 | nb_actions       |     2 |
|      1 | 2014-12-29 | 2015-01-04 |      2 | nb_uniq_visitors |     2 |
|      1 | 2014-12-29 | 2015-01-04 |      2 | nb_visits        |     2 |
|      1 | 2014-12-29 | 2015-01-04 |      2 | sum_visit_length |     2 |
|      1 | 2014-12-30 | 2014-12-30 |      1 | bounce_count     |     2 |
|      1 | 2014-12-30 | 2014-12-30 |      1 | max_actions      |     2 |
|      1 | 2014-12-30 | 2014-12-30 |      1 | nb_actions       |     2 |
|      1 | 2014-12-30 | 2014-12-30 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-30 | 2014-12-30 |      1 | nb_visits        |     2 |
|      1 | 2014-12-30 | 2014-12-30 |      1 | sum_visit_length |     2 |
|      1 | 2014-12-31 | 2014-12-31 |      1 | bounce_count     |     2 |
|      1 | 2014-12-31 | 2014-12-31 |      1 | max_actions      |     2 |
|      1 | 2014-12-31 | 2014-12-31 |      1 | nb_actions       |     2 |
|      1 | 2014-12-31 | 2014-12-31 |      1 | nb_uniq_visitors |     2 |
|      1 | 2014-12-31 | 2014-12-31 |      1 | nb_visits        |     2 |
|      1 | 2014-12-31 | 2014-12-31 |      1 | sum_visit_length |     2 |
+--------+------------+------------+--------+------------------+-------+

@diosmosis diosmosis self-assigned this Mar 1, 2015
diosmosis pushed a commit that referenced this issue Mar 1, 2015
Refs #7181, change ArchivePurger to use instance methods instead of s…
1cb376c 
…tatic methods, move Rules::shouldPurgeOutdatedArchives since it is only used by ArchivePurger and move comment in said function.
diosmosis pushed a commit that referenced this issue Mar 1, 2015
Refs #7181, archive purging is only done by daily scheduled task (eit…
707dc96 
…her through tracking or through CronArchive), so remove 6 hour forced time between purges in ArchivePurger::shouldPurgeOutdatedArchives.
@diosmosis
Copy link
Member

Could someone experiencing this problem run the following query on a bloated numeric table:

SELECT idarchive, name, value, period, date1, date2, ts_archived FROM piwik_archive_numeric_2015_01 where name like 'done%' and value <> 1;

? Thanks!

If the results are too large to copy-paste, feel free to email them to hello@piwik.org.

@diosmosis
Copy link
Member

Also, if anyone wants to see a better output message than "Purging temporary archives: skipped", you can replace the core/ArchiveProcessor/Rules.php file with this: https://raw.githubusercontent.com/piwik/piwik/master/core/ArchiveProcessor/Rules.php and run the core:run-scheduled-tasks --force command.

Please post the message you see here, it may help us fix the issue.

@CanuckNick
Copy link

@diosmosis - I just sent an email with a couple result exports from my tables. Hopefully that will help.

I will see if I can update and run the change to Rules.php in our test environment and get back to you.

@CanuckNick
Copy link

Just ran core:run-scheduled-tasks --force with the updated Rules.php file. This is the updated message:
Purging temporary archives: skipped (no authorization)

@skyhawk669
Copy link
Author

@diosmosis - here's the results of the query you requested:

For 2015-01:
2015-1

For 2015-02:
2015-2

@skyhawk669
Copy link
Author

@diosmosis, I have run the job with the modified Rules file and I get the same messages as @CanuckNick for each skipped line:
" Purging temporary archives: skipped (no authorization) "

@PatrickChen
Copy link

@diosmosis I also got "Purging temporary archives: skipped (no authorization)" for all archives including the newest 2015 Jan, Feb, Mar archives

@diosmosis
Copy link
Member

If you run the core:archive command and see if you get the same message when the scheduled task is run? You may have to wait for the 6 hours between purgings to pass to get useful output. Also if you've got cron archiving setup you could just check the cron job output.

@CanuckNick
Copy link

I believe the cron is running on a regular basis in our testing environment still so I will check the output tomorrow morning (EST) and get back to you.

diosmosis pushed a commit that referenced this issue Mar 3, 2015
Refs #7181, remove isRequestAuthorizedToArchive call in Rules::should…
a1fb019 
…PurgeOutdatedArchives() so archive purging can be forced in contexts other than scheduled task running.
@CanuckNick
Copy link

Just checked the logs, this is what shows up this morning:
Purging temporary archives: skipped (purging every 6hours)

@patriiiiiiiiiick
Copy link

This seems to be mostly solved for past months but not for the current one where the blob table remains abnormally large.

@mattab
Copy link
Member

mattab commented Jul 24, 2015

It may not be fully fixed so re-opening. This was reported in http://forum.piwik.org/read.php?2,128325 - (I've also removed the issue from the 2.14.1 changelog where it was announced fixed.)

@mattab mattab reopened this Jul 24, 2015
@mattab mattab modified the milestones: Short term, Mid term Jul 24, 2015
@mattab mattab removed the Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. label Jul 24, 2015
@patriiiiiiiiiick
Copy link

Indeed.

archive_blob_2015_08 6.4 G 295 M 5,161,333
archive_blob_2015_07 21 G 736 M 11,117,685
archive_blob_2015_06 445.9 M 21.6 M 499,029
archive_blob_2015_05 340 M 13.6 M 142,096
archive_blob_2015_04 384 M 44.7 M 505,544
archive_blob_2015_03 411 M 55.7 M 1,463,385
archive_blob_2015_02 389 M 52.8 M 1,027,133
archive_blob_2015_01 27.1 G 336 M 2,732,667
archive_numeric_2015_08 364 M 332.8 M 2,395,281
archive_numeric_2015_07 919.9 M 825.5 M 4,891,328
archive_numeric_2015_06 104.5 M 103.9 M 205,967
archive_numeric_2015_05 22.6 M 16.1 M 55,698
archive_numeric_2015_04 9.5 M 16.1 M 84,590
archive_numeric_2015_03 8.5 M 16.1 M 93,888
archive_numeric_2015_02 8.5 M 16.1 M 80,488
archive_numeric_2015_01 306.9 M 233.6 M 1,040,788

I'll have the following run to free up some space:
console core:purge-old-archive-data 2015-07-01 --include-year-archives --force-optimize-tables

Please note this is not documented in http://piwik.org/docs/setup-auto-archiving/#help-for-corearchive-command.

@patriiiiiiiiiick
Copy link

Here are my numbers after a “purge all”:

archive_blob_2015_08 628 M 35.7 M 943,370
archive_blob_2015_07 952 M 48.7 M 762,198
archive_blob_2015_06 317.8 M 12.6 M 117,246
archive_blob_2015_05 265.8 M 13.6 M 215,000
archive_blob_2015_04 380 M 44.7 M 825,327
archive_blob_2015_03 410 M 55.7 M 1,080,096
archive_blob_2015_02 388 M 52.8 M 1,159,006
archive_blob_2015_01 4.6 G 83.9 M 1,858,964

archive_numeric_2015_08 28.6 M 45.3 M 275,553
archive_numeric_2015_07 26.6 M 53.3 M 340,280
archive_numeric_2015_06 8.5 M 18.1 M 97,546
archive_numeric_2015_05 8.5 M 18.1 M 94,479
archive_numeric_2015_04 7.5 M 16.1 M 88,844
archive_numeric_2015_03 7.5 M 16.1 M 81,660
archive_numeric_2015_02 7.5 M 16.1 M 87,024
archive_numeric_2015_01 41.6 M 76.3 M 472,563

There is clearly an asymmetry between July-August and the rest of the year but I can't tell whether the old ones didn't run completely when they had been re-archived or if July and August still contain too many rows. To be continued...

@diosmosis diosmosis mentioned this issue Aug 12, 2015
Merged
@mattab
Copy link
Member

mattab commented Aug 21, 2015

Hi everyone,

We believe we may have finally found issue causing this bug of archive tables becoming too big.

I'm re-opening while we wait for confirmation from you guys, that this issue has been fixed.

It would be great if you could test that this bug is also fixed for you. We've released 2.15.0-b2 which you can install easily (see instructions: http://piwik.org/faq/how-to-update/faq_159/)

We're waiting for your feedback 👍

@mattab mattab reopened this Aug 21, 2015
@mattab mattab modified the milestones: 2.15.1, Short term Aug 21, 2015
@MaxWinterstein
Copy link

i just want to leave a comment here. I updated my installation to latest beta, did an archiving and optimze on all tables. My installation shrank from 80gb down to 10gb, where 6gb are from piwik.piwik_log_link_visit_action that is not able to optimize.

mysql> optimize table piwik_log_link_visit_action;
+-----------------------------------+----------+----------+------------------------------------------------------------------------------+
| Table                             | Op       | Msg_type | Msg_text                                                                     |
+-----------------------------------+----------+----------+------------------------------------------------------------------------------+
| piwik.piwik_log_link_visit_action | optimize | note     | Table does not support optimize, doing recreate + analyze instead            |
| piwik.piwik_log_link_visit_action | optimize | error    | Incorrect key file for table 'piwik_log_link_visit_action'; try to repair it |
| piwik.piwik_log_link_visit_action | optimize | status   | Operation failed                                                             |
+-----------------------------------+----------+----------+------------------------------------------------------------------------------+

@bartek85
Copy link

I had 650GB archive_blob_2015_01 table on 2.12.0, will let you know with 2.14.3 and than beta after archive will finish.

@gaumondp
Copy link

Remember that January is also the table having the yearly reports so it's "normal" it's way bigger (8X ?) than other months. AFAIK.

@bartek85
Copy link

Another piwik server:
piwik_archive_blob_2015_01 - 428GB
piwik_archive_blob_2015_02 - 26.1GB
piwik_archive_blob_2015_03 - 20.2GB
piwik_archive_blob_2015_04 - 46.3GB

so it's way bigger (10-20 times)

@gaumondp gaumondp mentioned this issue Oct 19, 2015
Open
@ThaDafinser
Copy link
Contributor

In my case it's solved and event got better with the new CLI command

@mattab
Copy link
Member

mattab commented Nov 18, 2015

Hi everyone, could you confirm whether this bug is fixed for you after upgrade to 2.15.0? if not fixed, please let us know: we need to make sure this issue is really solved. thanks!

@patriiiiiiiiiick
Copy link

It seems mostly solved. I wonder to what point it is still normal to have invalidated archives still present for the month of October, now on the 18th of November.

Please look at the attached results of

./console diagnostics:analyze-archive-table 2015_09

where the one of September has been run on the 5th of October (invalidated archives present) and Today (none present).

analyze-archive-table_2015_10.txt
analyze-archive-table_2015_09.txt

The table sizes compare as follows:
archive_blob_2015_11 733 M 40.1 M 554,460
archive_blob_2015_10 1.2 G 34.7 M 338,403
archive_blob_2015_09 250.8 M 13.6 M 70,623
archive_numeric_2015_11 49.1 M 44.2 M 226,694
archive_numeric_2015_10 21.6 M 43.2 M 235,579
archive_numeric_2015_09 7.5 M 17.1 M 91,433
where I ran an optimize table until the one of October some time in the past. I have probably added some new sites lately but none that big.

Did we make sure a table optimisation is run when needed?

@mattab
Copy link
Member

mattab commented Dec 4, 2015

Hi everyone,

We haven't heard that the issue is still active so closing this issue. please leave a comment if you find anything interesting or experience some issue. Thanks!

@mattab mattab closed this as completed Dec 4, 2015
@gaumondp
Copy link

gaumondp commented Dec 4, 2015

I updated to 2.15.0 few weeks ago and problem seems solved.

piwik_archive_blob_2015_month are now around 400 MB instead of 6 GB (except for January but that's normal, I know) !

Thanks.

@ravenxxxv
Copy link

I've updated to 2.16.0 and although it shrank the tables considerably they still appear to be bloated with duplicate entries.

before 2.16.0 console core:archive and optimize:
130G piwik_archive_blob_2016_01.ibd
31G piwik_archive_blob_2016_02.ibd
68G piwik_archive_blob_2016_03.ibd

after 2.16.0 core:archive and optimize:
2.9G piwik_archive_blob_2016_01.ibd
1.3G piwik_archive_blob_2016_02.ibd
22G piwik_archive_blob_2016_03.ibd

According to the comments in this thread, I ran the following to see the number of duplicate entries in the Mar 2016 blob table.

SELECT idsite, date1, date2, period, name, COUNT(*) as count FROM piwik_archive_blob_2016_03 GROUP BY idsite, date1, date2, period, name HAVING count > 1;

This resulted in 727180 rows

I ran the following diagnostic as well

./console diagnostics:analyze-archive-table 2016_03

Here's the summary

Total # Archives: 40728
Total # Invalidated Archives: 1154
Total # Temporary Archives: 0m
Total # Error Archives: 0
Total # Segment Archives: 20433

Please let me know if you need any further information.

@mattab mattab mentioned this issue Jul 18, 2016
Closed
@mattab mattab mentioned this issue Sep 27, 2016
Closed
@gaumondp gaumondp mentioned this issue Feb 6, 2017
Closed
@toebu toebu mentioned this issue Nov 8, 2018
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Task Indicates an issue is neither a feature nor a bug and it's purely a "technical" change.
Projects
None yet
Milestone
2.16.0
Development

No branches or pull requests