MySQL query error [1105]: Maximum writeset size exceeded

Status: This content is read-only, or is not open for further replies.

Xon

Guest

offline

OP
Mar 23, 2026
0
98

Unbound deletes can run into the issue that MariaDB Galera Cluster have an effective maximum delete/write size. This is very relevant for the xf_search table which has very wide rows and modern crawlers hammer the site in unexpected ways.

Code:

Code:

XF\Db\Exception: MySQL query error [1105]: Maximum writeset size exceeded src/XF/Db/AbstractStatement.php:230
Generated by: Unknown account Mar 23, 2026 at 11:00 AM

DELETE  FROM `xf_search` WHERE search_date < ?
------------

#0...