📢 Moderators Needed 🚀

Moderators are needed with resources to post or have access to resources to post. Submit an application to be considered.

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

Thread starter Xon
Start date Yesterday at 11:49 AM

Xon

Guest

Guest or Bot

Yesterday at 11:49 AM

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

M	RSS Import error: XF\Db\DuplicateKeyException: MySQL query error [1062]: Duplicate entry 'articles-Forum' for key 'node_name_unique' in src/XF/Db/Abstract Mr Lucky Dec 6, 2025 Xenforo RSS Feed
B	RSS XFMG caused a MySQL query error BredyAK Jan 16, 2026 Xenforo RSS Feed
I	RSS MySQL query error [1034] ibrian Jan 20, 2026 Xenforo RSS Feed
E	RSS MySQL statement prepare error [1054]: Unknown column 'edit_count' in 'field list' Excell Mar 5, 2026 Xenforo RSS Feed
P	RSS MySQL process Q pilot823 Oct 28, 2025 Xenforo RSS Feed

📢 Moderators Needed 🚀

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

Xon

Guest

We value your privacy