Creating channel with many members seems to kill your server

[MainFrame]

Dear Dragonbyte,

A lot of my members are french and they keep talking french in the shoutbox so I used the new functions to create a new channel for the french.
For access to the channel I've checked everyone except banned and unregistered users.
After about 2 minutes the load went up dramaticly and caused mysql errors.

I've also created a room for only staff members and noticed the shoutbox displays the list of users with access to the room. If it does the same for the french room I understand it causes the server to crash as I have over 600.000 members with access to that room. It would create a rather large list of users I amagine..

Here's the mysql I got:

Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT
DISTINCT user.userid,
username,
usergroupid,
infractiongroupid,
displaygroupid
FROM user AS user
WHERE usergroupid IN(4,6,20,7,15,2,21,5,3)
OR (FIND_IN_SET(-1, membergroupids) OR FIND_IN_SET(4, membergroupids) OR FIND_IN_SET(6, membergroupids) OR FIND_IN_SET(20, membergroupids) OR FIND_IN_SET(7, membergroupids) OR FIND_IN_SET(15, membergroupids) OR FIND_IN_SET(2, membergroupids) OR FIND_IN_SET(21, membergroupids) OR FIND_IN_SET(5, membergroupids) OR FIND_IN_SET(3, membergroupids))
ORDER BY username ASC;

MySQL Error : Error writing file '/tmp/MYUbzN7E' (Errcode: 28)
Error Number : 3
Request Date : Saturday, April 17th 2010 @ 09:54:47 AM
Error Date : Saturday, April 17th 2010 @ 09:55:06 AM
Script : http://www.sat-television.com/ajax.php?do=dbtech_vbshout_fetch
Referrer : http://www.sat-television.com/forum.php
IP Address : xx.xx.xx.xx
Username : test_user
Classname : vB_Database_MySQLi
MySQL Version :

 

[Deceptor]

Bit of a design flaw on our end, you can disable the query for now by editing: ./dbtech/vbshout/includes/libs/shoutbox.php

Find:

	private function fetch_chatroom_users($domenu, $chatroomid)
	{
		// Array of all active users
		$users = array();

Underneath add:

		return $users;

This will make the "chat access" list blank but should resolve load issues. I've notified Bel of the issue so it can be dealt with

 

[Fillip H.]

Just a quick update, I've hot patched the file with Deceptor's workaround until we can produce a real fix.

 

[Fillip H.]

I believe I've completed the workaround

4.5.1 will be released shortly.