Not a bug Rebuild daily statistics

[JoyFreak]

Affected version

2.3.0

When rebuilding daily statistics I get this error during processing:

An exception occurred: [XF\Db\Exception] MySQL statement prepare error [2006]: MySQL server has gone away in src/XF/Db/AbstractStatement.php on line 230

XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 207
XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 43
XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 61
XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1417
XF\Mvc\Entity\Finder->fetchOne() in src/XF/Repository/UpgradeCheckRepository.php at line 34
XF\Repository\UpgradeCheckRepository->getLatestUpgradeCheck() in src/XF/Admin/App.php at line 271
XF\Admin\App->renderPageHtml() in src/XF/App.php at line 2552
XF\App->renderPage() in src/XF/Admin/App.php at line 155
XF\Admin\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 414
XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 66
XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2777
XF\App->run() in src/XF.php at line 798
XF::runApp() in admin.php at line 15

 

[JoyFreak]

I am getting the same problem with the "Rebuild post embed metadata" option too. It would be rebuilding posts but then the page would randomly go blank even though in the tab it says "Processing". I had to refresh the page a few times and it continued but same thing would happen. Eventually it gave the same error as the above.

 

[Old Nick]

When rebuilding daily statistics I get this error during processing:

Just tried and process stuck here:

I am getting the same problem with the "Rebuild post embed metadata" option too

 

[JoyFreak]

Just tried and process stuck here:
View attachment 306948


View attachment 306949

I’m stuck with manual rebuild jobs awaiting completing.

 

[htsumer]

I tried it just now and there was no problem. I marked delete cache

 

[Old Nick]

I’m stuck with manual rebuild jobs awaiting completing.

Nothing changes with XF 2.3.1, i can wait 2 hours like that...



So i cancel the process and...



But my stats are gone !!

 

[htsumer]

It's normal for me

 

[htsumer]

Evet, etkin kullanıcı istatistikleri sıfırlandı

 

[JoyFreak]

Yeah stats gone for me too and when i clicked reply to you just now the page jumped to the bottom of the page.

 

[Jeremy P]

The original report is likely to be a server configuration issue. It may be worth examining your current MySQL wait timeout.

Just tried and process stuck here:

This will be a separate issue, but I have not been able to reproduce it yet.

But my stats are gone !!

Did you check the option to delete the existing data before rebuilding?

I tried it just now and there was no problem. I marked delete cache

Evet, etkin kullanıcı istatistikleri sıfırlandı

Per the explainer, active user counts cannot be rebuilt retroactively:

 

[Old Nick]

Did you check the option to delete the existing data before rebuilding?

I tried both and same result.
Do you want i create a different bug report for this?

 

[JoyFreak]

The original report is likely to be a server configuration issue. It may be worth examining your current MySQL wait timeout.

What would you recommend the MySQL wait timeout in seconds should be?

 

[Jeremy P]

The default is 28800 (8 hours). What is yours currently set at?

 

[JoyFreak]

The default is 28800 (8 hours). What is yours currently set at?

No idea. I'm on CloudWays and upon checking it just says "Default". I couldn't find what the default value is for CW. Anyway, I've set it to 28800 and will try again.

 

[JoyFreak]

Is it meant to take an hour or two to complete? It's taking so long.

 

[Jeremy P]

It shouldn't take that long. Is it progressing at all or is it hung at a certain date? I can rebuild ~14 years of stats in a couple minutes. Do you have any add-ons which add additional stats?

 

[JoyFreak]

It shouldn't take that long. Is it progressing at all or is it hung at a certain date? I can rebuild ~14 years of stats in a couple minutes. Do you have any add-ons which add additional stats?

It seems to be rebuilding through the months and at 30k-ish posts. It seems to be progressing from what I can see but taking so long! Is there a setting I need to set to speed it up?

 

[Jeremy P]

Not really, other than maybe trying a smaller batch size to see if it helps. It could point to broader MySQL server/configuration issues but it's hard to make any particular recommendations.

 

[JoyFreak]

Not really, other than maybe trying a smaller batch size to see if it helps. It could point to broader MySQL server/configuration issues but it's hard to make any particular recommendations.

I narrowed it down. An issue with an add-on caused this. Reported to the author.

 

[Old Nick]

Thank you, @JoyFreak. I'm also experiencing this issue with the add-on: https://xenforo.com/community/threads/rebuild-daily-stats-1970.223975/