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

API message: This report has been reprocessed since your last click. #3414

Closed
mattab opened this issue Oct 3, 2012 · 6 comments · May be fixed by sirinartk/matomo#2
Closed

API message: This report has been reprocessed since your last click. #3414

mattab opened this issue Oct 3, 2012 · 6 comments · May be fixed by sirinartk/matomo#2
Assignees
@mattab
Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Milestone
2.10.0

Comments

@mattab
Copy link
Member

mattab commented Oct 3, 2012

Open Row Evolution, Change selector to show last 90 days, on one piwik install this causes the following API error, which is not expected.

URL: analytics/index.php?viewDataTable=graphEvolution&module=CoreHome&action=getRowEvolutionGraph&date=yesterday&evolution_day_last_n=90&columns=nb_visits%2Cnb_uniq_visitors%2Cnb_actions%2Cnb_actions_per_visit%2Cavg_time_on_site%2Cbounce_rate&filter_column=label&filter_column_recursive=label&filter_sort_order=desc&keep_summary_row=0&apiMethod=CustomVariables.getCustomVariables&idSite=1&period=day&label=location&disableLink=1&controllerActionCalledWhenRequestSubTable=&debug

Error:

API returned an error: This report has been reprocessed since your last click. To see this error less often, please increase the timeout value in seconds in Settings > General Settings. (error: id 519 not found).

Backtrace:


#0 /home/dz/www/piwik/plugins/API/API.php(1187): Piwik_API_API->loadRowEvolutionDataFromAPI('1', 'day', '2012-07-05,2012...', 'CustomVariables', 'getCustomVariab...', 'location', false, false)
#1 /home/dz/www/piwik/plugins/API/API.php(1173): Piwik_API_API->getSingleRowEvolution('1', 'day', '2012-07-05,2012...', 'CustomVariables', 'getCustomVariab...', 'location', false, false, false)
#2 [internal function]: Piwik_API_API->getRowEvolution('1', 'day', '2012-07-05,2012...', 'CustomVariables', 'getCustomVariab...', 'location', false, false, false, false)
#3 /home/dz/www/piwik/core/API/Proxy.php(190): call_user_func_array(Array, Array)
#4 /home/dz/www/piwik/core/API/Request.php(128): Piwik_API_Proxy->call('Piwik_API_API', 'getRowEvolution', Array)
#5 /home/dz/www/piwik/plugins/CoreHome/DataTableRowAction/RowEvolution.php(160): Piwik_API_Request->process()
#6 /home/dz/www/piwik/plugins/CoreHome/DataTableRowAction/RowEvolution.php(97): Piwik_CoreHome_DataTableRowAction_RowEvolution->loadEvolutionReport()
#7 /home/dz/www/piwik/plugins/CoreHome/Controller.php(179): Piwik_CoreHome_DataTableRowAction_RowEvolution->__construct(1, Object(Piwik_Date), 'graphEvolution')
#8 /home/dz/www/piwik/plugins/CoreHome/Controller.php(162): Piwik_CoreHome_Controller->makeRowEvolution(0, 'graphEvolution')
#9 [internal function]: Piwik_CoreHome_Controller->getRowEvolutionGraph()
#10 /home/dz/www/piwik/core/FrontController.php(138): call_user_func_array(Array, Array)
#11 /home/dz/www/piwik/index.php(53): Piwik_FrontController->dispatch()
#12 {main}
@mattab
Copy link
Member Author

mattab commented Nov 15, 2012

It looks like it's working now I can't reproduce!

@mattab
Copy link
Member Author

mattab commented May 9, 2014

This was again reported in this forum post, it's a bug.

@mattab mattab added this to the 2.x - The Great Piwik 2.x Backlog milestone Jul 8, 2014
@emersion
Copy link

I have this bug too :

WARN Referrers[2014-07-18 15:52:10] [ef7d4] Failed to get data from API: This report has been reprocessed since your last click. To see this error less often, please increase the timeout value in seconds in Settings > General Settings. (error: id 76 not found).
#0 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/DataTable.php(902): Piwik\DataTable\Manager->getTable(76)#1 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/ArchiveProcessor.php(457): Piwik\DataTable->renameColumn(1, 11, true)#2 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/ArchiveProcessor.php(343): Piwik\ArchiveProcessor->renameColumnsAfterAggregation(Object(Piwik\DataTable), NULL)#3 [internal function]: Piwik\ArchiveProcessor->Piwik{closure}(Object(Piwik\DataTable))#4 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/DataTable.php(408): call_user_func_array(Object(Closure), Array)#5 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/DataTable/Map.php(108): Piwik\DataTable->filter(Object(Closure), Array)#6 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/ArchiveProcessor.php(344): Piwik\DataTable\Map->filter(Object(Closure))#7 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/ArchiveProcessor.php(199): Piwik\ArchiveProcessor->aggregateDataTableRecord('Referrers_searc...', NULL, NULL)#8 /srv/data/web/vhosts/analytics.e3au.org/htdocs/plugins/Referrers/Archiver.php(221): Piwik\ArchiveProcessor->aggregateDataTableRecords(Array, '1000', '50', 2)#9 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/ArchiveProcessor/PluginsArchiver.php(102): Piwik\Plugins\Referrers\Archiver->aggregateMultipleReports()#10 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/ArchiveProcessor/Loader.php(119): Piwik\ArchiveProcessor\PluginsArchiver->callAggregateAllPlugins(38, 0)#11 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/ArchiveProcessor/Loader.php(73): Piwik\ArchiveProcessor\Loader->prepareAllPluginsArchive(38, 0)#12 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/Archive.php(801): Piwik\ArchiveProcessor\Loader->prepareArchive('Referrers')#13 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/Archive.php(614): Piwik\Archive->prepareArchive(Array, Object(Piwik\Site), Object(Piwik\Period\Range))#14 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/Archive.php(556): Piwik\Archive->cacheArchiveIdsAfterLaunching(Array, Array)#15 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/Archive.php(497): Piwik\Archive->getArchiveIds(Array)#16 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/Archive.php(368): Piwik\Archive->get('Referrers_searc...', 'blob', NULL)#17 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/Archive.php(459): Piwik\Archive->getDataTable('Referrers_searc...', NULL)#18 /srv/data/web/vhosts/analytics.e3au.org/htdocs/plugins/Referrers/API.php(45): Piwik\Archive::getDataTableFromArchive('Referrers_searc...', '1', 'range', '2014-06-18,2014...', false, false, NULL)#19 /srv/data/web/vhosts/analytics.e3au.org/htdocs/plugins/Referrers/API.php(138): Piwik\Plugins\Referrers\API->getDataTable('Referrers_searc...', '1', 'range', '2014-06-18,2014...', false, false)#20 [internal function]: Piwik\Plugins\Referrers\API->getKeywords('1', 'range', '2014-06-18,2014...', false, false)#21 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/API/Proxy.php(209): call_user_func_array(Array, Array)#22 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/API/Request.php(215): Piwik\API\Proxy->call('\Piwik\Plugins...', 'getKeywords', Array)#23 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/ViewDataTable/Request.php(48): Piwik\API\Request->process()#24 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/Plugin/ViewDataTable.php(287): Piwik\ViewDataTable\Request->loadDataTableFromAPI(Array)#25 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/Plugin/Visualization.php(166): Piwik\Plugin\ViewDataTable->loadDataTableFromAPI(Array)#26 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/Plugin/ViewDataTable.php(374): Piwik\Plugin\Visualization->buildView()#27 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/Plugin/Controller.php(281): Piwik\Plugin\ViewDataTable->render()#28 /srv/data/web/vhosts/analytics.e3au.org/htdocs/plugins/Referrers/Controller.php(154): Piwik\Plugin\Controller->renderReport('getKeywords')#29 [internal function]: Piwik\Plugins\Referrers\Controller->getKeywords()#30 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/FrontController.php(531): call_user_func_array(Array, Array)#31 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/FrontController.php(84): Piwik\FrontController->doDispatch(NULL, NULL, NULL)#32 /srv/data/web/vhosts/analytics.e3au.org/htdocs/core/dispatch.php(34): Piwik\FrontController->dispatch()#33 /srv/data/web/vhosts/analytics.e3au.org/htdocs/index.php(47): require_once('/srv/data/web/v...')#34 {main}

Happens in referers.

@fleish
Copy link

fleish commented Aug 1, 2014

I am seeing this error as well. It started happening intermittently yesterday after I added a global segment that is setup to be archived during the archive cron job which runs hourly. The error has happened at the following times and I've noticed when it happens back-to-back the error: id # is the same:
yesterday @ 2309 (id 7099)
today @ 1206 (id 7099)
today @ 1109 (id 7162)
today @ 1206 (id 7162)
today @ 1806 (id 9961)
today @ 1906 (id 9961)
today @ 2006 (id 9961)
today @ 2106 (id 9961)
today @ 2206 (id 9961)

Here is the full output of one of them:
Error in the last Piwik archive.php run:
1 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=year&date=last2&format=php&token_auth=***&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:193:"This report has been reprocessed since your last click. To see this error less often, please increase the timeout value in seconds in Settings > General Settings. (error: id 7137 not found).";}'

Here is the full errors output:

INIT
Querying Piwik API at: https://piwik/index.php

Running Piwik 2.0.3 as Super User: admin

NOTES

  • Reports for today will be processed at most every 3600 seconds. You can change this value in Piwik UI > Settings > General Settings.
  • Reports for the current week/month/year will be refreshed at most every 3600 seconds.
  • Archiving was last executed without error 59 min 58s ago
  • Will pre-process 1 Segments for each website and each period: visitDuration<11

- Will process 1 websites with new visits since 59 min 58s , IDs: 1

START
Will pre-process the following 1 Segments for this website (id = 1): visitDuration<11
Archived website id = 1, period = day, Time elapsed: 11.136s
Will pre-process the following 1 Segments for this website (id = 1): visitDuration<11
Archived website id = 1, period = week, 416644 visits, Time elapsed: 14.259s
Will pre-process the following 1 Segments for this website (id = 1): visitDuration<11
Archived website id = 1, period = month, 0 visits, Time elapsed: 156.702s
Will pre-process the following 1 Segments for this website (id = 1): visitDuration<11
ERROR: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=year&date=last2&format=php&token_auth=***&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:193:"This report has been reprocessed since your last click. To see this error less often, please increase the timeout value in seconds in Settings > General Settings. (error: id 7137 not found).";}'
Archived website id = 1, period = year, 0 visits, Time elapsed: 7.710s
Starting Piwik reports archiving...

Done archiving!

SUMMARY
Total daily visits archived: 7797
Archived today's reports for 1 websites
Archived week/month/year for 1 websites
Skipped 1 websites: no new visit since the last script execution
Skipped 0 websites day archiving: existing daily reports are less than 3600 seconds old
Skipped 0 websites week/month/year archiving: existing periods reports are less than 3600 seconds old
Total API requests: 8
done: 1/1 100%, 7797 v, 1 wtoday, 1 wperiods, 8 req, 189809 ms, 1 errors. eg. 'Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=year&date=last2&format=php&token_auth=***&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:193:"This report has been reprocessed since your last click. To see this error less often, please increase the timeout value in seconds in Settings > General Settings. (error: id 7137 not found).";}''

Time elapsed: 189.809s

SCHEDULED TASKS
Starting Scheduled tasks...
No task to run

done

SUMMARY OF ERRORS
Error: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=year&date=last2&format=php&token_auth=**_&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:193:"This report has been reprocessed since your last click. To see this error less often, please increase the timeout value in seconds in Settings > General Settings. (error: id 7137 not found).";}'
1 total errors during this script execution, please investigate and try and fix these errors
ERROR: 1 total errors during this script execution, please investigate and try and fix these errors. First error was: Got invalid response from API request: https://piwik/index.php?module=API&method=VisitsSummary.getVisits&idSite=1&period=year&date=last2&format=php&token_auth=**_&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:193:"This report has been reprocessed since your last click. To see this error less often, please increase the timeout value in seconds in Settings > General Settings. (error: id 7137 not found).";}'

Here is the entry in the segment db table for the segment in question:
*************************** 1. row ***************************
idsegment: 6
name: 0-10 global
definition: visitDuration<11
login: admin
enable_all_users: 1
enable_only_idsite: 0
auto_archive: 1
ts_created: 2014-07-30 17:26:41
ts_last_edit: 2014-07-30 18:16:22
deleted: 0

My reports for today (or any other Date Range including today) will be processed at most every value was set to 3600 seconds, though it was also reduced to 3000 seconds today though that change did not correlate to any of the failures. For completeness sake, it was changed halfway between these two failures:
today @ 1206 (id 7162)
today @ 1806 (id 9961)

There were 2 archive runs that ran successfully subsequent to this change.

I am planning on upgrading from 2.0.3 to the latest release, but I may also try deleting this segment to see if it fixes my issue first.

EDIT: I deleted the segment prior to my last hourly run but still received the same error with id 9961.

@mattab mattab modified the milestones: Mid term, Short term Aug 3, 2014
@fleish
Copy link

fleish commented Aug 5, 2014

If there is anything I can do to help provide more information or test a potential fix for this issue please let me know. As of know we cannot process reports due to this issue

@mattab mattab added the Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical. label Oct 12, 2014
@mattab mattab mentioned this issue Dec 1, 2014
Closed
@mattab mattab modified the milestones: Piwik 2.10.0 , Short term Dec 3, 2014
@mattab mattab self-assigned this Dec 10, 2014
@mattab
Copy link
Member Author

mattab commented Dec 10, 2014

Alright, got an idea to fix this one

mattab added a commit that referenced this issue Dec 10, 2014
@mattab
reuse $row->getSubtable() as much as possible instead of callng Manag…
c28f9d6 
…er::getInstance()->getTable which can throw exception refs #3414
@mattab mattab mentioned this issue Dec 10, 2014
Merged
@mattab mattab mentioned this issue Dec 18, 2014
Closed
@snyk-bot snyk-bot mentioned this issue Mar 29, 2020
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@mattab mattab

Labels
Bug For errors / faults / flaws / inconsistencies etc. Major Indicates the severity or impact or benefit of an issue is much higher than normal but not critical.
Projects
None yet
Milestone
2.10.0
Development

Successfully merging a pull request may close this issue.

[Snyk] Security upgrade mocha from 5.2.0 to 6.0.0 sirinartk/matomo
4 participants
@diosmosis @mattab @emersion @fleish