"Manual rebuild job needs completion"

[Spartan]

When I login to the ACP, I a message about a manual rebuild job. When I click the link I get this error message:

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

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 196
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 39
3. XF\Db\Mysqli\Statement->prepare() in src/XF/Db/Mysqli/Statement.php at line 54
4. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 79
5. XF\Db\AbstractAdapter->query() in src/XF/Session/DbStorage.php at line 57
6. XF\Session\DbStorage->writeSession() in src/XF/Session/Session.php at line 215
7. XF\Session\Session->save() in src/XF/Admin/App.php at line 84
8. XF\Admin\App->complete() in src/XF/App.php at line 1934
9. XF\App->run() in src/XF.php at line 329
10. XF::runApp() in admin.php at line 13

 

[Ozzy47]

That error is usually caused by one of these MySQL settings being exceeded:

wait_timeout
max_allowed_packet

Your host needs to increase these settings in MySQL. There is more info here:

http://dev.mysql.com/doc/refman/5.1/en/gone-away.html

 

[Chris D]

Generally such an issue is caused by insufficient limits in your MySQL configuration.

The specific limits worth checking are mentioned in this thread:
https://xenforo.com/community/threads/rebuilding-search-index-error.140217/