XF 2.2 Database error when hard-deleting a thread after upgrade

[hurricane_sh]

After I upgraded the forum from 2.2.1 to the the latest 2.2.13 with the one-click upgrade, I got the following errors when hard deleting some threads. Not all threads trigger this error, I had to manually soft delete their threads to clean up spammers. Any suggestions?

Oops! We ran into some problems.
XF\Db\Exception: MySQL query error [1785]: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables. in src/XF/Db/AbstractStatement.php at line 230

1. XF\Db\AbstractStatement->getException() in src/XF/Db/Mysqli/Statement.php at line 198
2. XF\Db\Mysqli\Statement->getException() in src/XF/Db/Mysqli/Statement.php at line 79
3. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
4. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 294
5. XF\Db\AbstractAdapter->delete() in src/XF/Entity/Thread.php at line 1428
6. XF\Entity\Thread->_postDelete() in src/XF/Mvc/Entity/Entity.php at line 1659
7. XF\Mvc\Entity\Entity->delete() in src/XF/Service/Thread/Deleter.php at line 71
8. XF\Service\Thread\Deleter->delete() in src/XF/InlineMod/Thread/Delete.php at line 35
9. XF\InlineMod\Thread\Delete->applyToEntity() in src/XF/InlineMod/AbstractAction.php at line 87
10. XF\InlineMod\AbstractAction->applyInternal() in src/XF/InlineMod/AbstractAction.php at line 80
11. XF\InlineMod\AbstractAction->apply() in src/XF/Pub/Controller/InlineMod.php at line 129
12. XF\Pub\Controller\InlineMod->actionPerform() in src/XF/Mvc/Dispatcher.php at line 352
13. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 263
14. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
15. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
17. XF\App->run() in src/XF.php at line 524
18. XF::runApp() in index.php at line 20

 

[hurricane_sh]

xenForo support helped me fix it by doing

ALTER TABLE xf_thread_view ENGINE=InnoDB;

 

[robdog]

This fixed an issue I was running into. Is this going to be a fix brought into the main application through a DB update?

cc: @XenForo @Chris D