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.

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

Running "./console core:purge-old-archive-data all" fails on some system with [Exception] Date format #11778

Closed
mattab opened this issue Jun 9, 2017 · 7 comments · Fixed by #12757
Closed

Running "./console core:purge-old-archive-data all" fails on some system with [Exception] Date format #11778

mattab opened this issue Jun 9, 2017 · 7 comments · Fixed by #12757
Assignees
@sgiehl
Labels
Bug For errors / faults / flaws / inconsistencies etc.
Milestone
3.5.0

Comments

@mattab
Copy link
Member

mattab commented Jun 9, 2017

Running the following command works on most servers (demo2, localhost, etc.)

./console core:purge-old-archive-data all

But on demo.piwik.org it does not work and outputs:

  [Exception]                                                                                                                                                                     
  Date format must be: YYYY-MM-DD, or 'today' or 'yesterday' or any keyword supported by the strtotime function (see http://php.net/strtotime for more information): -2976912000  

core:purge-old-archive-data [--exclude-outdated] [--exclude-invalidated] [--exclude-ranges] [--skip-optimize-tables] [--include-year-archives] [--force-optimize-tables] [dates1] ... [datesN]

We should investigate to make sure this command always work as we use it for time to time.
@mattab mattab added the Bug For errors / faults / flaws / inconsistencies etc. label Jun 9, 2017
@sgiehl
Copy link
Member

sgiehl commented Mar 21, 2018

@mattab does that error still occur on demo?

@mattab
Copy link
Member Author

mattab commented Mar 22, 2018

we're now getting:

$ ./console core:purge-old-archive-data all


                                                                                                                                          
  [Exception]                                                                                                                             
  The date '1875-09-01' is a date before first website was online. Try date that's after Aug 6, 1991 (timestamp 681436800).: -2976912000  
                                                                                                                                          


core:purge-old-archive-data [--exclude-outdated] [--exclude-invalidated] [--exclude-ranges] [--skip-optimize-tables] [--include-year-archives] [--force-optimize-tables] [dates1] ... [datesN]

@sgiehl
Copy link
Member

sgiehl commented Mar 22, 2018

would you mind looking up the archive table names in database? Are there any archive_blob / archive_numeric tables that do not have a name like archive_{type}{month}{year}?

@mattab
Copy link
Member Author

mattab commented Mar 26, 2018 •
edited

here is all tables that contain archive, it seems OK although it has too many archive tables created in the past, and in the future:

(edit: added the second page of table names)

Table Ascending 	Rows 	Type 	Collation 	Size 	Overhead
piwik_archive_blob_1991_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1992_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1993_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1993_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1994_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1995_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1995_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1995_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1995_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1995_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1995_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1996_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1997_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1998_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_1999_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2000_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2001_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2002_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2003_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2004_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2005_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2006_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2007_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2008_01 	154,477 	InnoDB 	utf8_general_ci 	54.6 MiB 	-
piwik_archive_blob_2008_02 	216,063 	InnoDB 	utf8_general_ci 	79.7 MiB 	-
piwik_archive_blob_2008_03 	35,925 	InnoDB 	utf8_general_ci 	14.6 MiB 	-
piwik_archive_blob_2008_04 	40,112 	InnoDB 	utf8_general_ci 	16.6 MiB 	-
piwik_archive_blob_2008_05 	50,647 	InnoDB 	utf8_general_ci 	19.6 MiB 	-
piwik_archive_blob_2008_06 	47,755 	InnoDB 	utf8_general_ci 	19.6 MiB 	-
piwik_archive_blob_2008_07 	46,146 	InnoDB 	utf8_general_ci 	18.6 MiB 	-
piwik_archive_blob_2008_08 	52,418 	InnoDB 	utf8_general_ci 	21.6 MiB 	-
piwik_archive_blob_2008_09 	51,906 	InnoDB 	utf8_general_ci 	21.6 MiB 	-
piwik_archive_blob_2008_10 	50,531 	InnoDB 	utf8_general_ci 	20.6 MiB 	-
piwik_archive_blob_2008_11 	54,756 	InnoDB 	utf8_general_ci 	23.6 MiB 	-
piwik_archive_blob_2008_12 	79,495 	InnoDB 	utf8_general_ci 	32.6 MiB 	-
piwik_archive_blob_2009_01 	103,531 	InnoDB 	utf8_general_ci 	51.6 MiB 	-
piwik_archive_blob_2009_02 	71,134 	InnoDB 	utf8_general_ci 	32.6 MiB 	-
piwik_archive_blob_2009_03 	106,934 	InnoDB 	utf8_general_ci 	49.6 MiB 	-
piwik_archive_blob_2009_04 	96,512 	InnoDB 	utf8_general_ci 	43.6 MiB 	-
piwik_archive_blob_2009_05 	115,279 	InnoDB 	utf8_general_ci 	51.6 MiB 	-
piwik_archive_blob_2009_06 	84,506 	InnoDB 	utf8_general_ci 	37.6 MiB 	-
piwik_archive_blob_2009_07 	86,859 	InnoDB 	utf8_general_ci 	39.6 MiB 	-
piwik_archive_blob_2009_08 	95,859 	InnoDB 	utf8_general_ci 	43.6 MiB 	-
piwik_archive_blob_2009_09 	75,075 	InnoDB 	utf8_general_ci 	35.6 MiB 	-
piwik_archive_blob_2009_10 	92,879 	InnoDB 	utf8_general_ci 	42.6 MiB 	-
piwik_archive_blob_2009_11 	91,147 	InnoDB 	utf8_general_ci 	41.6 MiB 	-
piwik_archive_blob_2009_12 	97,190 	InnoDB 	utf8_general_ci 	46.6 MiB 	-
piwik_archive_blob_2010_01 	161,409 	InnoDB 	utf8_general_ci 	76.7 MiB 	-
piwik_archive_blob_2010_02 	126,694 	InnoDB 	utf8_general_ci 	57.6 MiB 	-
piwik_archive_blob_2010_03 	169,728 	InnoDB 	utf8_general_ci 	74.7 MiB 	-
piwik_archive_blob_2010_04 	192,379 	InnoDB 	utf8_general_ci 	93.3 MiB 	-
piwik_archive_blob_2010_05 	187,218 	InnoDB 	utf8_general_ci 	91.3 MiB 	-
piwik_archive_blob_2010_06 	157,154 	InnoDB 	utf8_general_ci 	76.2 MiB 	-
piwik_archive_blob_2010_07 	181,533 	InnoDB 	utf8_general_ci 	89.3 MiB 	-
piwik_archive_blob_2010_08 	302,531 	InnoDB 	utf8_general_ci 	144.4 MiB 	-
piwik_archive_blob_2010_09 	185,888 	InnoDB 	utf8_general_ci 	88.3 MiB 	-
piwik_archive_blob_2010_10 	172,659 	InnoDB 	utf8_general_ci 	82.2 MiB 	-
piwik_archive_blob_2010_11 	206,762 	InnoDB 	utf8_general_ci 	99.3 MiB 	-
piwik_archive_blob_2010_12 	164,639 	InnoDB 	utf8_general_ci 	82.2 MiB 	-
piwik_archive_blob_2011_01 	342,513 	InnoDB 	utf8_general_ci 	176.4 MiB 	-
piwik_archive_blob_2011_02 	310,145 	InnoDB 	utf8_general_ci 	139.3 MiB 	-
piwik_archive_blob_2011_03 	364,921 	InnoDB 	utf8_general_ci 	171.4 MiB 	-
piwik_archive_blob_2011_04 	~571,881 	InnoDB 	utf8_general_ci 	212.5 MiB 	-
piwik_archive_blob_2011_05 	333,427 	InnoDB 	utf8_general_ci 	156.4 MiB 	-
piwik_archive_blob_2011_06 	281,878 	InnoDB 	utf8_general_ci 	132.3 MiB 	-
piwik_archive_blob_2011_07 	265,421 	InnoDB 	utf8_general_ci 	123.3 MiB 	-
piwik_archive_blob_2011_08 	288,609 	InnoDB 	utf8_general_ci 	132.3 MiB 	-
piwik_archive_blob_2011_09 	279,493 	InnoDB 	utf8_general_ci 	129.3 MiB 	-
piwik_archive_blob_2011_10 	413,565 	InnoDB 	utf8_general_ci 	188.5 MiB 	-
piwik_archive_blob_2011_11 	378,388 	InnoDB 	utf8_general_ci 	171.4 MiB 	-
piwik_archive_blob_2011_12 	369,205 	InnoDB 	utf8_general_ci 	166.4 MiB 	-
piwik_archive_blob_2012_01 	~621,176 	InnoDB 	utf8_general_ci 	228.5 MiB 	-
piwik_archive_blob_2012_02 	485,424 	InnoDB 	utf8_general_ci 	214.5 MiB 	-
piwik_archive_blob_2012_03 	402,169 	InnoDB 	utf8_general_ci 	187.4 MiB 	-
piwik_archive_blob_2012_04 	401,660 	InnoDB 	utf8_general_ci 	185.4 MiB 	-
piwik_archive_blob_2012_05 	~551,211 	InnoDB 	utf8_general_ci 	192.5 MiB 	-
piwik_archive_blob_2012_06 	362,029 	InnoDB 	utf8_general_ci 	168.4 MiB 	-
piwik_archive_blob_2012_07 	52,779 	InnoDB 	utf8_general_ci 	19.1 MiB 	-
piwik_archive_blob_2012_08 	205,206 	InnoDB 	utf8_general_ci 	102.3 MiB 	-
piwik_archive_blob_2012_09 	213,973 	InnoDB 	utf8_general_ci 	107.3 MiB 	-
piwik_archive_blob_2012_10 	236,363 	InnoDB 	utf8_general_ci 	134.3 MiB 	-
piwik_archive_blob_2012_11 	241,230 	InnoDB 	utf8_general_ci 	143.3 MiB 	-
piwik_archive_blob_2012_12 	237,838 	InnoDB 	utf8_general_ci 	137.3 MiB 	-
piwik_archive_blob_2013_01 	329,985 	InnoDB 	utf8_general_ci 	217.4 MiB 	-
piwik_archive_blob_2013_02 	260,613 	InnoDB 	utf8_general_ci 	150.3 MiB 	-
piwik_archive_blob_2013_03 	277,943 	InnoDB 	utf8_general_ci 	162.3 MiB 	-
piwik_archive_blob_2013_04 	256,787 	InnoDB 	utf8_general_ci 	163.3 MiB 	-
piwik_archive_blob_2013_05 	258,496 	InnoDB 	utf8_general_ci 	160.3 MiB 	-
piwik_archive_blob_2013_06 	250,600 	InnoDB 	utf8_general_ci 	164.3 MiB 	-
piwik_archive_blob_2013_07 	305,080 	InnoDB 	utf8_general_ci 	193.4 MiB 	-
piwik_archive_blob_2013_08 	284,727 	InnoDB 	utf8_general_ci 	180.3 MiB 	-
piwik_archive_blob_2013_09 	258,695 	InnoDB 	utf8_general_ci 	175.3 MiB 	-
piwik_archive_blob_2013_10 	240,609 	InnoDB 	utf8_general_ci 	167.3 MiB 	-
piwik_archive_blob_2013_11 	216,997 	InnoDB 	utf8_general_ci 	150.3 MiB 	-
piwik_archive_blob_2013_12 	235,643 	InnoDB 	utf8_general_ci 	161.3 MiB 	-
piwik_archive_blob_2014_01 	317,093 	InnoDB 	utf8_general_ci 	248.4 MiB 	-
piwik_archive_blob_2014_02 	270,141 	InnoDB 	utf8_general_ci 	189.3 MiB 	-
piwik_archive_blob_2014_03 	300,337 	InnoDB 	utf8_general_ci 	205.4 MiB 	-
piwik_archive_blob_2014_04 	291,896 	InnoDB 	utf8_general_ci 	197.4 MiB 	-
piwik_archive_blob_2014_05 	~1,803,451 	InnoDB 	utf8_general_ci 	1 GiB 	-
piwik_archive_blob_2014_06 	270,639 	InnoDB 	utf8_general_ci 	183.3 MiB 	-
piwik_archive_blob_2014_07 	291,159 	InnoDB 	utf8_general_ci 	189.3 MiB 	-
piwik_archive_blob_2014_08 	269,823 	InnoDB 	utf8_general_ci 	177.3 MiB 	-
piwik_archive_blob_2014_09 	284,337 	InnoDB 	utf8_general_ci 	189.3 MiB 	-
piwik_archive_blob_2014_10 	293,719 	InnoDB 	utf8_general_ci 	195.3 MiB 	-
piwik_archive_blob_2014_11 	271,245 	InnoDB 	utf8_general_ci 	183.3 MiB 	-
piwik_archive_blob_2014_12 	272,875 	InnoDB 	utf8_general_ci 	184.3 MiB 	-
piwik_archive_blob_2015_01 	326,767 	InnoDB 	utf8_general_ci 	270.4 MiB 	-
piwik_archive_blob_2015_02 	293,875 	InnoDB 	utf8_general_ci 	209.4 MiB 	-
piwik_archive_blob_2015_03 	258,208 	InnoDB 	utf8_general_ci 	198.3 MiB 	-

Filters
Containing the word:
Table Ascending 	Rows 	Type 	Collation 	Size 	Overhead
piwik_archive_blob_2015_04 	106,174 	InnoDB 	utf8_general_ci 	149.2 MiB 	-
piwik_archive_blob_2015_05 	105,907 	InnoDB 	utf8_general_ci 	138.2 MiB 	-
piwik_archive_blob_2015_06 	109,110 	InnoDB 	utf8_general_ci 	137.2 MiB 	-
piwik_archive_blob_2015_07 	107,466 	InnoDB 	utf8_general_ci 	132.2 MiB 	-
piwik_archive_blob_2015_08 	114,105 	InnoDB 	utf8_general_ci 	128.2 MiB 	-
piwik_archive_blob_2015_09 	114,532 	InnoDB 	utf8_general_ci 	126.2 MiB 	-
piwik_archive_blob_2015_10 	129,102 	InnoDB 	utf8_general_ci 	138.2 MiB 	-
piwik_archive_blob_2015_11 	117,964 	InnoDB 	utf8_general_ci 	146.2 MiB 	-
piwik_archive_blob_2015_12 	108,330 	InnoDB 	utf8_general_ci 	118.2 MiB 	-
piwik_archive_blob_2016_01 	114,817 	InnoDB 	utf8_general_ci 	154.2 MiB 	-
piwik_archive_blob_2016_02 	103,627 	InnoDB 	utf8_general_ci 	127.2 MiB 	-
piwik_archive_blob_2016_03 	104,363 	InnoDB 	utf8_general_ci 	131.2 MiB 	-
piwik_archive_blob_2016_04 	101,978 	InnoDB 	utf8_general_ci 	127.2 MiB 	-
piwik_archive_blob_2016_05 	112,856 	InnoDB 	utf8_general_ci 	134.2 MiB 	-
piwik_archive_blob_2016_06 	102,642 	InnoDB 	utf8_general_ci 	130.2 MiB 	-
piwik_archive_blob_2016_07 	97,760 	InnoDB 	utf8_general_ci 	116.2 MiB 	-
piwik_archive_blob_2016_08 	100,604 	InnoDB 	utf8_general_ci 	124.2 MiB 	-
piwik_archive_blob_2016_09 	92,750 	InnoDB 	utf8_general_ci 	112.2 MiB 	-
piwik_archive_blob_2016_10 	108,131 	InnoDB 	utf8_general_ci 	132.2 MiB 	-
piwik_archive_blob_2016_11 	106,760 	InnoDB 	utf8_general_ci 	132.2 MiB 	-
piwik_archive_blob_2016_12 	96,942 	InnoDB 	utf8_general_ci 	134.2 MiB 	-
piwik_archive_blob_2017_01 	105,334 	InnoDB 	utf8_general_ci 	165.2 MiB 	-
piwik_archive_blob_2017_02 	89,988 	InnoDB 	utf8_general_ci 	130.2 MiB 	-
piwik_archive_blob_2017_03 	111,352 	InnoDB 	utf8_general_ci 	144.2 MiB 	-
piwik_archive_blob_2017_04 	105,070 	InnoDB 	utf8_general_ci 	119.2 MiB 	-
piwik_archive_blob_2017_05 	121,772 	InnoDB 	utf8_general_ci 	114.2 MiB 	-
piwik_archive_blob_2017_06 	117,900 	InnoDB 	utf8_general_ci 	106.2 MiB 	-
piwik_archive_blob_2017_07 	125,513 	InnoDB 	utf8_general_ci 	114.2 MiB 	-
piwik_archive_blob_2017_08 	112,699 	InnoDB 	utf8_general_ci 	110.2 MiB 	-
piwik_archive_blob_2017_09 	106,843 	InnoDB 	utf8_general_ci 	102.2 MiB 	-
piwik_archive_blob_2017_10 	85,644 	InnoDB 	utf8_general_ci 	102.2 MiB 	-
piwik_archive_blob_2017_11 	76,042 	InnoDB 	utf8_general_ci 	95.1 MiB 	-
piwik_archive_blob_2017_12 	71,736 	InnoDB 	utf8_general_ci 	86.1 MiB 	-
piwik_archive_blob_2018_01 	104,166 	InnoDB 	utf8_general_ci 	235.2 MiB 	-
piwik_archive_blob_2018_02 	77,624 	InnoDB 	utf8_general_ci 	105.1 MiB 	-
piwik_archive_blob_2018_03 	140,108 	InnoDB 	utf8_general_ci 	240.3 MiB 	-
piwik_archive_blob_2018_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2018_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2018_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2018_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2018_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2018_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2018_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2018_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2018_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2019_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2020_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2021_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2022_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2023_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2024_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2025_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2026_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2027_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2028_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2029_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2030_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2031_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2032_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2033_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2034_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_02 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_03 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_04 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_05 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_06 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_07 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_08 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_09 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_10 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_11 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2035_12 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-
piwik_archive_blob_2036_01 	0 	InnoDB 	utf8_general_ci 	32 KiB 	-

@sgiehl
Copy link
Member

sgiehl commented Mar 26, 2018

archive_numeric tables have the same names?
Guess we could fix that problem with a try catch, but would be good to know what causes it...

@mattab
Copy link
Member Author

mattab commented Mar 26, 2018

Hi @sgiehl

I just sent you the full list y email, btw it would be great if we could find or prevent those archive tables to be created in the future... should we create a separate issue or is this something you could open a PR for? (and we'll need to cleanup the tables from the demo DB ideally, in case you could prepare the sql query to run)

@sgiehl
Copy link
Member

sgiehl commented Mar 27, 2018

Thanks. Will have a look at it.

@sgiehl sgiehl self-assigned this Mar 27, 2018
@sgiehl sgiehl mentioned this issue Apr 23, 2018
Merged
@mattab mattab added this to the 3.5.0 milestone Apr 23, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@sgiehl sgiehl

Labels
Bug For errors / faults / flaws / inconsistencies etc.
Projects
None yet
Milestone
3.5.0
Development

Successfully merging a pull request may close this issue.

Fix core:purge-old-archive-data failing in some cases matomo-org/matomo
2 participants
@mattab @sgiehl