RSS Feed/News MySQL query error [1105]: Maximum writeset size exceeded

Status
Not open for further replies.

ENXF NET

Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
Joined
Nov 13, 2018
Messages
31,014
Points
823

Reputation:

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...

Read more

Continue reading...
 
Status
Not open for further replies.
Top