Failed to load user list (/admin/people) in Drupal 11.0.1

Created on 12 August 2024, 5 months ago

Problem/Motivation

With 50 users, the /admin/people page fails to load. The site fails with 500 error, "The SELECT would examine more than MAX_JOIN_SIZE rows".

Update: Adjusting the settings.php (SET SQL_BIG_SELECTS=1) fixes the issue. Sorry for early bugreport. Nevertheless, since this is not really a huge dataset, I suspect the query is not very well formed.

Steps to reproduce

Add more than 49 users to Drupal 11.0.1 system. PHP 8.3, MariaDB 10.11.

🐛 Bug report

Status

Closed: duplicate

Version

11.0 🔥

Component

User system →

Last updated 4 days ago

Maintained by
🇺🇸United States @moshe weitzman
🇧🇪Belgium @kristiaanvandeneynde

Created by

🇨🇿Czech Republic petrsocha

Live updates comments and jobs are added and updated live.

Comments & Activities

Issue created by @petrsocha
Comment 5 months ago →
🇨🇿Czech Republic petrsocha
Any quick fix suggestion would be highly appreciated, as this has happened on a production site. Thank you very much.
Comment 5 months ago →
🇨🇿Czech Republic petrsocha
Status changed to Closed: duplicate 5 months ago12:15pm 12 August 2024
Comment 5 months ago →
cilefen
This is a duplicate of 💬 Not able to show more than 49 users Postponed: needs info . Add information there.

contrib.social Blog FAQ Discussions

Production build 0.71.5 2024