Upgrade 2.10 Archive Runs, No Data in Reports


#1

Attached is the successful run of the archive cron. There are no errors, but all reports in the interface are empty since the upgrade. I do see the raw visit logs in that particular widget as well as directly querying piwik_log_visit.

Everything appears to be good post update as well.

[sub]php console core:update


Everything is already up to date.
*************************************[/sub]

Anyone have any ideas?

Below is the archive log

INFO CoreConsole[2015-02-07 01:01:03] ---------------------------
INFO CoreConsole[2015-02-07 01:01:03] INIT
INFO CoreConsole[2015-02-07 01:01:03] Piwik is installed at: Sign in - Piwik
INFO CoreConsole[2015-02-07 01:01:03] Running Piwik 2.10.0 as Super User
INFO CoreConsole[2015-02-07 01:01:06] ---------------------------
INFO CoreConsole[2015-02-07 01:01:06] NOTES
INFO CoreConsole[2015-02-07 01:01:06] - Reports for today will be processed at most every 1800 seconds. You can change this value in Piwik UI > Settings > General Settings.
INFO CoreConsole[2015-02-07 01:01:06] - Reports for the current week/month/year will be refreshed at most every 3600 seconds.
INFO CoreConsole[2015-02-07 01:01:06] - Archiving was last executed without error 53 min 25s ago
INFO CoreConsole[2015-02-07 01:01:12] - Will process 25 websites with new visits since 53 min 22s , IDs: 1, 2, 5, 6, 7, 8, 9, 10, 11, 12, 15, 16, 17, 20, 21, 22, 23, 24, 25, 27, 30, 31, 32, 33, 34
INFO CoreConsole[2015-02-07 01:01:12] - Will process 1 other websites because some old data reports have been invalidated (eg. using the Log Import script) , IDs: 30
INFO CoreConsole[2015-02-07 01:01:12] ---------------------------
INFO CoreConsole[2015-02-07 01:01:12] START
INFO CoreConsole[2015-02-07 01:01:12] Starting Piwik reports archiving…
INFO CoreConsole[2015-02-07 01:01:20] Archived website id = 1, period = day, 108 visits in last last2 days, 3 visits today, Time elapsed: 7.599s
INFO CoreConsole[2015-02-07 01:01:30] Archived website id = 1, period = week, 1441 visits in last last2 weeks, 647 visits this week, Time elapsed: 9.417s
INFO CoreConsole[2015-02-07 01:01:39] Archived website id = 1, period = month, 4498 visits in last last2 months, 745 visits this month, Time elapsed: 9.073s
INFO CoreConsole[2015-02-07 01:01:48] Archived website id = 1, period = year, 56101 visits in last last2 years, 4498 visits this year, Time elapsed: 9.617s
INFO CoreConsole[2015-02-07 01:01:57] Archived website id = 1, period = range, 745 visits in last last7 ranges, 745 visits this range, Time elapsed: 8.488s
INFO CoreConsole[2015-02-07 01:01:57] Archived website id = 1, 5 API requests, Time elapsed: 44.224s [1/25 done]
INFO CoreConsole[2015-02-07 01:02:08] Archived website id = 2, period = day, 934 visits in last last2 days, 65 visits today, Time elapsed: 10.781s
INFO CoreConsole[2015-02-07 01:02:19] Archived website id = 2, period = week, 12313 visits in last last2 weeks, 5349 visits this week, Time elapsed: 11.797s
INFO CoreConsole[2015-02-07 01:02:32] Archived website id = 2, period = month, 40373 visits in last last2 months, 6098 visits this month, Time elapsed: 12.816s
INFO CoreConsole[2015-02-07 01:02:45] Archived website id = 2, period = year, 386101 visits in last last2 years, 40373 visits this year, Time elapsed: 12.879s
INFO CoreConsole[2015-02-07 01:02:53] Archived website id = 2, period = range, 6098 visits in last last7 ranges, 6098 visits this range, Time elapsed: 7.895s
INFO CoreConsole[2015-02-07 01:02:53] Archived website id = 2, 5 API requests, Time elapsed: 56.173s [2/25 done]
INFO CoreConsole[2015-02-07 01:03:03] Archived website id = 5, period = day, 206 visits in last last2 days, 11 visits today, Time elapsed: 9.917s
INFO CoreConsole[2015-02-07 01:03:12] Archived website id = 5, period = week, 3043 visits in last last2 weeks, 1381 visits this week, Time elapsed: 8.962s
INFO CoreConsole[2015-02-07 01:03:22] Archived website id = 5, period = month, 10122 visits in last last2 months, 1557 visits this month, Time elapsed: 10.058s
INFO CoreConsole[2015-02-07 01:03:31] Archived website id = 5, period = year, 49189 visits in last last2 years, 10122 visits this year, Time elapsed: 9.390s
INFO CoreConsole[2015-02-07 01:03:39] Archived website id = 5, period = range, 1557 visits in last last7 ranges, 1557 visits this range, Time elapsed: 7.650s
INFO CoreConsole[2015-02-07 01:03:39] Archived website id = 5, 5 API requests, Time elapsed: 45.984s [3/25 done]
INFO CoreConsole[2015-02-07 01:03:52] Archived website id = 6, period = day, 3073 visits in last last2 days, 237 visits today, Time elapsed: 12.941s
INFO CoreConsole[2015-02-07 01:04:06] Archived website id = 6, period = week, 37767 visits in last last2 weeks, 15447 visits this week, Time elapsed: 13.414s
INFO CoreConsole[2015-02-07 01:04:21] Archived website id = 6, period = month, 136504 visits in last last2 months, 18342 visits this month, Time elapsed: 15.782s
INFO CoreConsole[2015-02-07 01:04:37] Archived website id = 6, period = year, 1072236 visits in last last2 years, 136504 visits this year, Time elapsed: 15.527s
INFO CoreConsole[2015-02-07 01:04:46] Archived website id = 6, period = range, 18342 visits in last last7 ranges, 18342 visits this range, Time elapsed: 8.596s
INFO CoreConsole[2015-02-07 01:04:46] Archived website id = 6, 5 API requests, Time elapsed: 66.267s [4/25 done]
INFO CoreConsole[2015-02-07 01:04:56] Archived website id = 7, period = day, 1248 visits in last last2 days, 70 visits today, Time elapsed: 10.827s
INFO CoreConsole[2015-02-07 01:05:12] Archived website id = 7, period = week, 16121 visits in last last2 weeks, 7184 visits this week, Time elapsed: 15.024s
INFO CoreConsole[2015-02-07 01:05:26] Archived website id = 7, period = month, 62255 visits in last last2 months, 8144 visits this month, Time elapsed: 14.145s
INFO CoreConsole[2015-02-07 01:05:38] Archived website id = 7, period = year, 504624 visits in last last2 years, 62255 visits this year, Time elapsed: 11.875s
INFO CoreConsole[2015-02-07 01:05:46] Archived website id = 7, period = range, 8144 visits in last last7 ranges, 8144 visits this range, Time elapsed: 8.611s
INFO CoreConsole[2015-02-07 01:05:46] Archived website id = 7, 5 API requests, Time elapsed: 60.489s [5/25 done]
INFO CoreConsole[2015-02-07 01:06:07] Archived website id = 8, period = day, 10868 visits in last last2 days, 348 visits today, Time elapsed: 20.673s
INFO CoreConsole[2015-02-07 01:06:23] Archived website id = 8, period = week, 168443 visits in last last2 weeks, 78167 visits this week, Time elapsed: 16.370s
INFO CoreConsole[2015-02-07 01:06:41] Archived website id = 8, period = month, 490584 visits in last last2 months, 85475 visits this month, Time elapsed: 17.293s
INFO CoreConsole[2015-02-07 01:06:54] Archived website id = 8, period = year, 3053788 visits in last last2 years, 490584 visits this year, Time elapsed: 12.971s
INFO CoreConsole[2015-02-07 01:07:00] Archived website id = 8, period = range, 85475 visits in last last7 ranges, 85475 visits this range, Time elapsed: 6.653s
INFO CoreConsole[2015-02-07 01:07:00] Archived website id = 8, 5 API requests, Time elapsed: 73.967s [6/25 done]
INFO CoreConsole[2015-02-07 01:07:09] Archived website id = 9, period = day, 1134 visits in last last2 days, 79 visits today, Time elapsed: 8.854s
INFO CoreConsole[2015-02-07 01:07:20] Archived website id = 9, period = week, 15543 visits in last last2 weeks, 6519 visits this week, Time elapsed: 10.798s
INFO CoreConsole[2015-02-07 01:07:32] Archived website id = 9, period = month, 50556 visits in last last2 months, 7680 visits this month, Time elapsed: 11.872s
INFO CoreConsole[2015-02-07 01:07:42] Archived website id = 9, period = year, 330268 visits in last last2 years, 50556 visits this year, Time elapsed: 10.415s
INFO CoreConsole[2015-02-07 01:07:49] Archived website id = 9, period = range, 7680 visits in last last7 ranges, 7680 visits this range, Time elapsed: 6.402s
INFO CoreConsole[2015-02-07 01:07:49] Archived website id = 9, 5 API requests, Time elapsed: 48.348s [7/25 done]
INFO CoreConsole[2015-02-07 01:07:58] Archived website id = 10, period = day, 2616 visits in last last2 days, 184 visits today, Time elapsed: 9.215s
INFO CoreConsole[2015-02-07 01:08:09] Archived website id = 10, period = week, 37838 visits in last last2 weeks, 15616 visits this week, Time elapsed: 10.682s
INFO CoreConsole[2015-02-07 01:08:20] Archived website id = 10, period = month, 129667 visits in last last2 months, 18542 visits this month, Time elapsed: 11.306s
INFO CoreConsole[2015-02-07 01:08:31] Archived website id = 10, period = year, 668271 visits in last last2 years, 129667 visits this year, Time elapsed: 10.967s
INFO CoreConsole[2015-02-07 01:08:37] Archived website id = 10, period = range, 18542 visits in last last7 ranges, 18542 visits this range, Time elapsed: 6.220s
INFO CoreConsole[2015-02-07 01:08:37] Archived website id = 10, 5 API requests, Time elapsed: 48.398s [8/25 done]
INFO CoreConsole[2015-02-07 01:08:44] Archived website id = 11, period = day, 44 visits in last last2 days, 4 visits today, Time elapsed: 7.109s
INFO CoreConsole[2015-02-07 01:08:52] Archived website id = 11, period = week, 536 visits in last last2 weeks, 262 visits this week, Time elapsed: 7.293s
INFO CoreConsole[2015-02-07 01:08:59] Archived website id = 11, period = month, 1661 visits in last last2 months, 290 visits this month, Time elapsed: 7.235s
INFO CoreConsole[2015-02-07 01:09:06] Archived website id = 11, period = year, 12850 visits in last last2 years, 1661 visits this year, Time elapsed: 7.064s
INFO CoreConsole[2015-02-07 01:09:12] Archived website id = 11, period = range, 290 visits in last last7 ranges, 290 visits this range, Time elapsed: 6.183s
INFO CoreConsole[2015-02-07 01:09:12] Archived website id = 11, 5 API requests, Time elapsed: 34.891s [9/25 done]
INFO CoreConsole[2015-02-07 01:09:20] Archived website id = 12, period = day, 1007 visits in last last2 days, 50 visits today, Time elapsed: 7.932s
INFO CoreConsole[2015-02-07 01:09:29] Archived website id = 12, period = week, 14699 visits in last last2 weeks, 6850 visits this week, Time elapsed: 8.595s
INFO CoreConsole[2015-02-07 01:09:38] Archived website id = 12, period = month, 41694 visits in last last2 months, 7530 visits this month, Time elapsed: 9.254s
INFO CoreConsole[2015-02-07 01:09:47] Archived website id = 12, period = year, 315007 visits in last last2 years, 41694 visits this year, Time elapsed: 9.364s
INFO CoreConsole[2015-02-07 01:09:54] Archived website id = 12, period = range, 7530 visits in last last7 ranges, 7530 visits this range, Time elapsed: 6.130s
INFO CoreConsole[2015-02-07 01:09:54] Archived website id = 12, 5 API requests, Time elapsed: 41.281s [10/25 done]
INFO CoreConsole[2015-02-07 01:10:01] Archived website id = 15, period = day, 112 visits in last last2 days, 4 visits today, Time elapsed: 7.186s
INFO CoreConsole[2015-02-07 01:10:10] Archived website id = 15, period = week, 1797 visits in last last2 weeks, 779 visits this week, Time elapsed: 9.492s
INFO CoreConsole[2015-02-07 01:10:19] Archived website id = 15, period = month, 5560 visits in last last2 months, 902 visits this month, Time elapsed: 8.802s
INFO CoreConsole[2015-02-07 01:10:28] Archived website id = 15, period = year, 54284 visits in last last2 years, 5560 visits this year, Time elapsed: 8.551s
INFO CoreConsole[2015-02-07 01:10:34] Archived website id = 15, period = range, 902 visits in last last7 ranges, 902 visits this range, Time elapsed: 6.656s
INFO CoreConsole[2015-02-07 01:10:34] Archived website id = 15, 5 API requests, Time elapsed: 40.692s [11/25 done]
INFO CoreConsole[2015-02-07 01:10:42] Archived website id = 16, period = day, 224 visits in last last2 days, 16 visits today, Time elapsed: 7.430s
INFO CoreConsole[2015-02-07 01:10:51] Archived website id = 16, period = week, 3221 visits in last last2 weeks, 1335 visits this week, Time elapsed: 8.695s
INFO CoreConsole[2015-02-07 01:11:01] Archived website id = 16, period = month, 10233 visits in last last2 months, 1562 visits this month, Time elapsed: 10.248s
INFO CoreConsole[2015-02-07 01:11:10] Archived website id = 16, period = year, 62123 visits in last last2 years, 10233 visits this year, Time elapsed: 9.027s
INFO CoreConsole[2015-02-07 01:11:17] Archived website id = 16, period = range, 1562 visits in last last7 ranges, 1562 visits this range, Time elapsed: 7.249s
INFO CoreConsole[2015-02-07 01:11:17] Archived website id = 16, 5 API requests, Time elapsed: 42.656s [12/25 done]
INFO CoreConsole[2015-02-07 01:11:25] Archived website id = 17, period = day, 111 visits in last last2 days, 6 visits today, Time elapsed: 7.373s
INFO CoreConsole[2015-02-07 01:11:33] Archived website id = 17, period = week, 1466 visits in last last2 weeks, 681 visits this week, Time elapsed: 7.949s
INFO CoreConsole[2015-02-07 01:11:41] Archived website id = 17, period = month, 4034 visits in last last2 months, 752 visits this month, Time elapsed: 8.141s
INFO CoreConsole[2015-02-07 01:11:48] Archived website id = 17, period = year, 23240 visits in last last2 years, 4034 visits this year, Time elapsed: 7.598s
INFO CoreConsole[2015-02-07 01:11:55] Archived website id = 17, period = range, 752 visits in last last7 ranges, 752 visits this range, Time elapsed: 6.593s
INFO CoreConsole[2015-02-07 01:11:55] Archived website id = 17, 5 API requests, Time elapsed: 37.660s [13/25 done]
INFO CoreConsole[2015-02-07 01:12:09] Archived website id = 20, period = day, 4586 visits in last last2 days, 319 visits today, Time elapsed: 14.247s
INFO CoreConsole[2015-02-07 01:12:24] Archived website id = 20, period = week, 61587 visits in last last2 weeks, 26642 visits this week, Time elapsed: 14.183s
INFO CoreConsole[2015-02-07 01:12:40] Archived website id = 20, period = month, 190609 visits in last last2 months, 31715 visits this month, Time elapsed: 16.707s
INFO CoreConsole[2015-02-07 01:12:56] Archived website id = 20, period = year, 1414725 visits in last last2 years, 190609 visits this year, Time elapsed: 15.283s
INFO CoreConsole[2015-02-07 01:13:04] Archived website id = 20, period = range, 31715 visits in last last7 ranges, 31715 visits this range, Time elapsed: 8.770s
INFO CoreConsole[2015-02-07 01:13:04] Archived website id = 20, 5 API requests, Time elapsed: 69.199s [14/25 done]
INFO CoreConsole[2015-02-07 01:13:17] Archived website id = 21, period = day, 2236 visits in last last2 days, 168 visits today, Time elapsed: 12.923s
INFO CoreConsole[2015-02-07 01:13:29] Archived website id = 21, period = week, 28830 visits in last last2 weeks, 12209 visits this week, Time elapsed: 11.952s
INFO CoreConsole[2015-02-07 01:13:41] Archived website id = 21, period = month, 91137 visits in last last2 months, 14616 visits this month, Time elapsed: 11.679s
INFO CoreConsole[2015-02-07 01:13:52] Archived website id = 21, period = year, 488981 visits in last last2 years, 91137 visits this year, Time elapsed: 11.304s
INFO CoreConsole[2015-02-07 01:14:00] Archived website id = 21, period = range, 14616 visits in last last7 ranges, 14616 visits this range, Time elapsed: 7.532s
INFO CoreConsole[2015-02-07 01:14:00] Archived website id = 21, 5 API requests, Time elapsed: 55.396s [15/25 done]
INFO CoreConsole[2015-02-07 01:14:13] Archived website id = 22, period = day, 3480 visits in last last2 days, 233 visits today, Time elapsed: 12.616s
INFO CoreConsole[2015-02-07 01:14:27] Archived website id = 22, period = week, 51067 visits in last last2 weeks, 21553 visits this week, Time elapsed: 14.334s
INFO CoreConsole[2015-02-07 01:14:43] Archived website id = 22, period = month, 179618 visits in last last2 months, 25854 visits this month, Time elapsed: 15.843s
INFO CoreConsole[2015-02-07 01:14:56] Archived website id = 22, period = year, 1618094 visits in last last2 years, 179618 visits this year, Time elapsed: 13.399s
INFO CoreConsole[2015-02-07 01:15:06] Archived website id = 22, period = range, 25854 visits in last last7 ranges, 25854 visits this range, Time elapsed: 9.469s
INFO CoreConsole[2015-02-07 01:15:06] Archived website id = 22, 5 API requests, Time elapsed: 65.667s [16/25 done]
INFO CoreConsole[2015-02-07 01:15:23] Archived website id = 23, period = day, 3049 visits in last last2 days, 241 visits today, Time elapsed: 17.396s
INFO CoreConsole[2015-02-07 01:15:38] Archived website id = 23, period = week, 42496 visits in last last2 weeks, 17222 visits this week, Time elapsed: 14.709s
INFO CoreConsole[2015-02-07 01:15:54] Archived website id = 23, period = month, 142703 visits in last last2 months, 20361 visits this month, Time elapsed: 15.724s
INFO CoreConsole[2015-02-07 01:16:08] Archived website id = 23, period = year, 1239175 visits in last last2 years, 142703 visits this year, Time elapsed: 14.005s
INFO CoreConsole[2015-02-07 01:16:16] Archived website id = 23, period = range, 20361 visits in last last7 ranges, 20361 visits this range, Time elapsed: 8.396s
INFO CoreConsole[2015-02-07 01:16:16] Archived website id = 23, 5 API requests, Time elapsed: 70.237s [17/25 done]
INFO CoreConsole[2015-02-07 01:16:27] Archived website id = 24, period = day, 1014 visits in last last2 days, 103 visits today, Time elapsed: 10.796s
INFO CoreConsole[2015-02-07 01:16:37] Archived website id = 24, period = week, 11305 visits in last last2 weeks, 4812 visits this week, Time elapsed: 10.071s
INFO CoreConsole[2015-02-07 01:16:47] Archived website id = 24, period = month, 40739 visits in last last2 months, 5699 visits this month, Time elapsed: 9.842s
INFO CoreConsole[2015-02-07 01:16:57] Archived website id = 24, period = year, 338461 visits in last last2 years, 40739 visits this year, Time elapsed: 10.349s
INFO CoreConsole[2015-02-07 01:17:05] Archived website id = 24, period = range, 5699 visits in last last7 ranges, 5699 visits this range, Time elapsed: 7.564s
INFO CoreConsole[2015-02-07 01:17:05] Archived website id = 24, 5 API requests, Time elapsed: 48.629s [18/25 done]
INFO CoreConsole[2015-02-07 01:17:14] Archived website id = 25, period = day, 349 visits in last last2 days, 23 visits today, Time elapsed: 9.595s
INFO CoreConsole[2015-02-07 01:17:25] Archived website id = 25, period = week, 4420 visits in last last2 weeks, 1869 visits this week, Time elapsed: 10.512s
INFO CoreConsole[2015-02-07 01:17:36] Archived website id = 25, period = month, 14054 visits in last last2 months, 2242 visits this month, Time elapsed: 10.771s
INFO CoreConsole[2015-02-07 01:17:46] Archived website id = 25, period = year, 75944 visits in last last2 years, 14054 visits this year, Time elapsed: 10.449s
INFO CoreConsole[2015-02-07 01:17:54] Archived website id = 25, period = range, 2242 visits in last last7 ranges, 2242 visits this range, Time elapsed: 7.639s
INFO CoreConsole[2015-02-07 01:17:54] Archived website id = 25, 5 API requests, Time elapsed: 48.971s [19/25 done]
INFO CoreConsole[2015-02-07 01:18:02] Archived website id = 27, period = day, 32 visits in last last2 days, 4 visits today, Time elapsed: 8.316s
INFO CoreConsole[2015-02-07 01:18:12] Archived website id = 27, period = week, 478 visits in last last2 weeks, 190 visits this week, Time elapsed: 9.870s
INFO CoreConsole[2015-02-07 01:18:22] Archived website id = 27, period = month, 1508 visits in last last2 months, 233 visits this month, Time elapsed: 9.416s
INFO CoreConsole[2015-02-07 01:18:30] Archived website id = 27, period = year, 10645 visits in last last2 years, 1508 visits this year, Time elapsed: 8.637s
INFO CoreConsole[2015-02-07 01:18:37] Archived website id = 27, period = range, 233 visits in last last7 ranges, 233 visits this range, Time elapsed: 7.289s
INFO CoreConsole[2015-02-07 01:18:37] Archived website id = 27, 5 API requests, Time elapsed: 43.534s [20/25 done]
INFO CoreConsole[2015-02-07 01:19:20] Archived website id = 30, period = day, 691000 visits in last last52 days, 917 visits today, Time elapsed: 42.175s
INFO CoreConsole[2015-02-07 01:20:30] Archived website id = 30, period = week, 1615233 visits in last last110 weeks, 81898 visits this week, Time elapsed: 70.328s
INFO CoreConsole[2015-02-07 01:25:21] Archived website id = 30, period = month, 0 visits in last last52 months, 0 visits this month, Time elapsed: 290.407s
INFO CoreConsole[2015-02-07 01:29:49] Archived website id = 30, period = year, 0 visits in last last7 years, 0 visits this year, Time elapsed: 268.750s
INFO CoreConsole[2015-02-07 01:30:31] Archived website id = 30, period = range, 94649 visits in last last7 ranges, 94649 visits this range, Time elapsed: 42.161s


#2

When I add a segment to the reports then I get results, but when set the segment back to “All Visits” I get zero results. I have also cleared cache several times…