New DB error after upgrade...?

[mickknutson]

I upgraded last week, and now I started getting this error today:

Database error in vBulletin 3.8.4:

Invalid SQL:

  SELECT albumpicture.*, album.*, user.username, user.usergroupid, picture.caption,
  IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
  FROM albumpicture AS albumpicture
  LEFT JOIN album AS album ON(album.albumid = albumpicture.albumid)
  LEFT JOIN user AS user ON(user.userid = album.userid)
  LEFT JOIN picture AS picture ON(albumpicture.pictureid = picture.pictureid)
  WHERE album.state = 'public'
  ORDER BY rand(NOW()) DESC LIMIT 0, 3;

MySQL Error   : Can't create/write to file '/var/lib/mysql/#sql_3f06_0.MYI' (Errcode: 24)
Error Number  : 1
Request Date  : Monday, October 12th 2009 @ 04:54:56 PM
Error Date    : Monday, October 12th 2009 @ 04:55:44 PM
Script        : http://blincmagazine.com/
Referrer      :
IP Address    : 68.8.129.176
Username      : Unregistered
Classname     : vB_Database
MySQL Version :

[Steve Machol]

OS error code 24: Too many open files

This is a server issues. You need to contact your host about this. They will likely need to reboot the server.