Žilinská univerzita > Fakulta riadenia a informatiky > Katedra informačných sietí

Drupal 6 - Got error 28 from storage engine query

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.

 

Groups: