If your Drupal site receive following message
user warning: Got error 28 from storage engine query: SELECT DISTINCT b.* FROM blocks b LEFT JOIN blocks_roles r ON b.module = r.module AND b.delta = r.delta LEFT JOIN i18n_blocks i18n ON (b.module = i18n.module AND b.delta = i18n.delta) WHERE (i18n.language ='en' OR i18n.language ='' OR i18n.language IS NULL) AND ( b.theme = 'garland' AND b.status = 1 AND (r.rid IN (2,3) OR r.rid IS NULL) )ORDER BY b.region, b.weight, b.module in /var/www/virtualhosts/www.viro.kis.fri.uniza.sk/modules/block/block.module on line 460.
The Error 28 occurs when there is not enough disk space left for MySQL to run properly. It could be because
- The filesystem/hardrive is full.
Check it out.
df -h Filesystem Size Used Avail Use% Mounted on rootfs 74G 22G 48G 32% / udev 10M 0 10M 0% /dev tmpfs 1.7G 220K 1.7G 1% /run /dev/disk/by-label/RootFS 74G 22G 48G 32% / tmpfs 5.0M 0 5.0M 0% /run/lock tmpfs 3.4G 0 3.4G 0% /run/shm tmpfs 3.4G 3.4G 0 100% /tmp
and after cleaning /tmp in my case
cd /tmp /tmp# rm -rf * df -h Filesystem Size Used Avail Use% Mounted on rootfs 74G 22G 48G 32% / udev 10M 0 10M 0% /dev tmpfs 1.7G 220K 1.7G 1% /run /dev/disk/by-label/RootFS 74G 22G 48G 32% / tmpfs 5.0M 0 5.0M 0% /run/lock tmpfs 3.4G 0 3.4G 0% /run/shm tmpfs 3.4G 12K 3.4G 1% /tmp
it start to work again.