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

Adding a subtable to the row, but it already has a subtable associated. #5087

Closed

anonymous-matomo-user opened this issue May 5, 2014 · 2 comments

Labels

Milestone

anonymous-matomo-user commented May 5, 2014

Hi,

the following error occurs during the regulary archive job:

INFO [2014-05-05 07:01:13] [733f4] Archived website id = 33, period = day, 142750 visits in last 2 days, 27139 visits today, Time elapsed: 27.176s
INFO [2014-05-05 07:01:15] [733f4] ERROR: Got invalid response from API request: @@REMOVED_DOMAIN@@/index.php?module=API&method=API.get&idSite=33&period=week&date=last69&format=php&token_auth=aa76d97ca3f812780478bbcd298c148d&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:71:"Adding a subtable to the row, but it already has a subtable associated.";}'
INFO [2014-05-05 07:01:15] [733f4] Archived website id = 33, period = week, 0 visits in last 69 weeks, 0 visits this week, Time elapsed: 2.475s
INFO [2014-05-05 07:01:34] [733f4] Archived website id = 33, period = month, 24537883 visits in last 52 months, 438712 visits this month, Time elapsed: 18.967s

I already patched the code with "debug_print_backtrace();" before the "throw exception" in "core/DataTable/Row.php" (line 295). This is the output:

INFO [2014-05-05 07:14:07] [5c81b] Archived website id = 33, period = day, 144375 visits in last 2 days, 28764 visits today, Time elapsed: 23.042s
INFO [2014-05-05 07:14:10] [5c81b] ERROR: Got invalid response from API request: @@REMOVED_DOMAIN@@/index.php?module=API&method=API.get&idSite=33&period=week&date=last69&format=php&token_auth=aa76d97ca3f812780478bbcd298c148d&trigger=archivephp. Response was '#0  Piwik\DataTable\Row->addSubtable(Piwik\DataTable Object ([] => Array (),[] => 14301,[] => 0,[] => 1,[] => ,[] => ,[] => Array (),[] => 0,[] => ,[] => ,[] => Array (),[] => ,[] => Array (),[] => 0)) called at [/web/core/DataTable/Row.php:278]
#1  Piwik\DataTable\Row->sumSubtable(Piwik\DataTable Object ([] => Array ([0] => Piwik\DataTable\Row\DataTableSummaryRow Object ([c] => Array ([0] => Array ([label] => 5,[2] => 83,[12] => 89,[13] => 24,[30] => 0,[31] => 0,[32] => ,[33] => ,[19] => 37,[20] => 284,[21] => 245,[22] => 30,[15] => 36),[1] => Array (),[3] => -1846),[] => ,[maxVisitsSummed] => 0)),[] => 1845,[] => 0,[] => ,[] => 1,[] => ,[] => Array (),[] => 0,[] => ,[] => ,[] => Array ([5] => 0),[] => ,[] => Array ([column_aggregation_ops] => Array ([33] => max,[32] => min)),[] => 0)) called at [/web/core/DataTable.php:1616]
#2  Piwik\DataTable->aggregateRowWithLabel(Piwik\DataTable\Row Object ([c] => Array ([0] => Array ([label] => -1,[2] => 61289,[12] => 68067,[13] => 1412295,[29] => 45,[30] => 0,[31] => 0,[32] => ,[33] => ,[19] => 7281,[20] => 24683,[21] => 1531880,[22] => 3942,[15] => 6946),[1] => Array (),[3] => 1845),[] => ,[maxVisitsSummed] => 0), 1) called at [/web/core/DataTable.php:484]
#3  Piwik\DataTable->addDataTable(Piwik\DataTable Object ([] => Array ([0] => Piwik\DataTable\Row\DataTableSummaryRow Object ([c] => Array ([0] => Array ([label] => /index,[2] => 282846,[1] => 282844,[12] => 414292,[13] => 7324924,[29] => 984,[30] => 0,[31] => 0,[32] => ,[33] => ,[17] => 67357,[19] => 67359,[20] => 426989,[21] => 7675146,[22] => 42177,[14] => 62798,[15] => 62800),[1] => Array ([url] => http://fetish-eva-room.erog.fr/),[3] => ),[] => ,[maxVisitsSummed] => 0),[1] => Piwik\DataTable\Row\DataTableSummaryRow Object ([c] => Array ([0] => Array ([label] => status-images,[2] => 13983,[12] => 34727,[13] => 2383873,[29] => 116,[30] => 0,[31] => 0,[32] => ,[33] => ,[19] => 18,[20] => 29,[21] => 1801,[22] => 13,[15] => 9046),[1] => Array (),[3] => -4224),[] => ,[maxVisitsSummed] => 0),[2] => Piwik\DataTable\Row\DataTableSummaryRow Object ([c] => Array ([0] => Array ([label] => cgi-bin,[2] => 4161,[12] => 4877,[13] => 43354,[30] => 0,[31] => 0,[32] => ,[33] => ,[19] => 1324,[20] => 5165,[21] => 45052,[22] => 825,[15] => 1304),[1] => Array (),[3] => -4225),[] => ,[maxVisitsSummed] => 0),[3] => Piwik\DataTable\Row\DataTableSummaryRow Object ([c] => Array ([0] => Array ([label] => search,[2] => 1325,[12] => 2163,[13] => 19845,[29] => 72,[30] => 0,[31] => 0,[32] => ,[33] => ,[19] => 35,[20] => 143,[21] => 1503,[22] => 18,[15] => 82),[1] => Array (),[3] => -4229),[] => ,[maxVisitsSummed] => 0),[4] => Piwik\DataTable\Row\DataTableSummaryRow Object ([c] => Array ([0] => Array ([label] => /index.php,[2] => 1121,[1] => 1121,[12] => 1453,[13] => 50613,[30] => 0,[31] => 0,[32] => ,[33] => ,[17] => 277,[19] => 277,[20] => 1368,[21] => 35574,[22] => 149,[14] => 290,[15] => 290),[1] => Array ([url] => http://www.radio.jungboys.net/index.php),[3] => ),[] => ,[maxVisitsSummed] => 0),[5] => Piwik\DataTable\Row\DataTableSummaryRow Object ([c] => Array ([0] => Array ([label] => /news.php,[2] => 1046,[1] => 1046,[12] => 1233,[13] => 11696,[30] => 0,[31] => 0,[32] => ,[33] => ,[17] => 224,[19] => 224,[20] => 1804,[21] => 28996,[22] => 104,[14] => 213,[15] => 213),[1] => Array ([url] => http://white-angel-star-radio.de/news.php),[3] => ),[] => ,[maxVisitsSummed] => 0),[6] => Piwik\DataTable\Row\DataTableSummaryRow Object ([c] => Array ([0] => Array ([label] => gallery,[2] => 909,[12] => 1087,[13] => 5225,[29] => 1,[30] => 0,[31] => 0,[32] => ,[33] => ,[19] => 18,[20] => 146,[21] => 1401,[22] => 13,[15] => 26),[1] => Array (),[3] => -4239),[] => ,[maxVisitsSummed] => 0),[7] => Piwik\DataTable\Row\DataTableSummaryRow Object ([c] => Array ([0] => Array ([label] => kamp,[2] => 908,[12] => 16085,[13] => 365365,[30] => 0,[31] => 0,[32] => ,[33] => ,[19] => 359,[20] => 13658,[21] => 545067,[22] => 92,[15] => 257),[1] => Array (),[3] => -4245),[] => ,[maxVisitsSummed] => 0),[8] => Piwik\DataTable\Row\DataTableSummaryRow Object ([c] => Array ([0] => Array ([label] => user,[2] => 878,[12] => 1137,[13] => 21445,[29] => 7,[30] => 0,[31] => 0,[32] => ,[33] => ,[15] => 153,[19] => 155,[20] => 980,[21] => 25825,[22] => 61),[1] => Array (),[3] => -4246),[] => ,[maxVisitsSummed] => 0),[9] => Piwik\DataTable\Row\DataTableSummaryRow Object ([c] => Array ([0] => Array ([label] => codes,[2] => 836,[12] => 9357,[13] => 200830,[30] => 0,[31] => 0,[32] => ,[33] => ,[19] => 195,[20] => 8185,[21] => 272539,[22] => 82,[15] => 156),[1] => Array (),[3] => -4297),[] => ,[maxVisitsSummed] => 0),[10] => Piwik\DataTable\Row\DataTableSummaryRow Object ([c] => Array ([0] => Array ([label] => de,[2] => 812,[12] => 1307,[13] => 90434,[30] => 0,[31] => 0,[32] => ,[33] => ,[19] => 355,[20] => 1153,[21] => 86377,[22] => 213,[15] => 342,[29] => 3),[1] => Array (),[3] => -4298),[] => ,[maxVisitsSummed] => 0),[11] => Piwik\DataTable\Row\DataTableSummaryRow Object ([c] => Array ([0] => Array ([label] => /index.php?_m=knowledgebase,[2] => 710,[1] => 710,[12] => 1049,[13] => 49680,[30] => 0,[31] => 0,[32] => ,[33] => ,[17] => 606,[19] => 606,[20] => 1045,[21] => 47831,[22] => 413,[14] => 603,[15] => 603),[1] => Array ([url] => https://kundencenter.buhl.de/index.php?_m=knowledgebase),[3] => ),[] => ,[maxVisitsSummed] => 0),[12] => Piwik\DataTable\Row\DataTableSummaryRow Object ([c] => Array ([0] => Array ([label] => category,[2] => 662,[12] => 848,[13] => 16428,[30] => 0,[31] => 0,[32] => ,[33] => ,[19] => 33,[20] => 244,[21] => 1793,[22] => 15,[15] => 67,[29] => 24),[1] => Array (),[3] => -4458),[] => ,[maxVisitsSummed] => 0),[13] => Piwik\DataTable\Row\DataTableSummaryRow Object ([c] => Array ([0] => Array ([label] => stadtplan,[2] => 621,[
INFO [2014-05-05 07:14:10] [5c81b] Archived website id = 33, period = week, 0 visits in last 69 weeks, 0 visits this week, Time elapsed: 3.359s
INFO [2014-05-05 07:14:30] [5c81b] Archived website id = 33, period = month, 24539508 visits in last 52 months, 440337 visits this month, Time elapsed: 19.945s

(I had to remove the URL's because the content was detected as SPAM by Akismet with this tracking tool).

The error seems to exist for about 2 months now ("Archiving was last executed without error 67 Tage 13 Stunden ago").
Is there something I could do to fix this?

Thank you.
Thomas
Keywords: archive

The text was updated successfully, but these errors were encountered:

Member

mattab commented May 6, 2014

Thanks for report, See #4528

anonymous-matomo-user added this to the 2.2.1 - Piwik 2.2.1 milestone

anonymous-matomo-user added T: Bug labels

Member

mattab commented Aug 28, 2014

cupracer mentioned this issue

Row with label '-1' ... has already a subtable id=... but it was not loaded. #6569

Closed

This issue was closed.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment