Skip to content

v2.4.3 — Fix MySQL 1038 out-of-sort-memory on the Toplists admin list

Choose a tag to compare

View all tags
@mexiter mexiter released this 17 Sep 22:47
· 3 commits to main since this release
v2.4.3
68c6c01

Fixed

  • Admin Toplists list page could hit MySQL error 1038 "Out of sort memory" once the table grew large enough that the default ORDER BY last_synced DESC filesort exceeded the host's sort_buffer_size. Schema v1.15 adds indexes on last_synced, name, and item_count (ensureToplistsSortIndexes()), covering every column ToplistsQuery::ALLOWED_SORT can hit that didn't already have one.

Verified on strike-odds.test: the Toplists admin list loads, View Details expands, Dashboard and Brands load, and the front-end casino cards still render. PHPUnit: 969 tests, 3131 assertions.

Assets 2
Loading