{"id":595,"date":"2014-01-03T13:28:37","date_gmt":"2014-01-03T12:28:37","guid":{"rendered":""},"modified":"2025-05-05T11:04:08","modified_gmt":"2025-05-05T09:04:08","slug":"drupal-6-got-error-28-storage-engine-query","status":"publish","type":"post","link":"https:\/\/nil.uniza.sk\/en\/drupal-6-got-error-28-storage-engine-query\/","title":{"rendered":"Drupal 6 &#8211; Got error 28 from storage engine query"},"content":{"rendered":"<p>\n\tIf your Drupal site receive following message<\/p>\n<p><\/p>\n<address>\n\tuser 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 =&#39;en&#39; OR i18n.language =&#39;&#39; OR i18n.language IS NULL) AND ( b.theme = &#39;garland&#39; 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.<\/address>\n<p>\n\t&nbsp;<\/p>\n<p>\n\t<img decoding=\"async\" alt=\"\" src=\"\/wp-content\/uploads\/files\/image\/webcms\/drupal\/Drupal-error28.png\" style=\"width: 550px; height: 521px;\" \/><\/p>\n<p>\n\t&nbsp;<\/p>\n<p>\n\tThe Error 28 occurs when there is not enough disk space left for MySQL to run properly. It could be because<\/p>\n<ul>\n<li>\n\t\tThe filesystem\/hardrive is full.<\/li>\n<\/ul>\n<p>\n\tCheck it out.<\/p>\n<pre>\r\ndf -h\r\nFilesystem                 Size  Used Avail Use% Mounted on\r\nrootfs                      74G   22G   48G  32% \/\r\nudev                        10M     0   10M   0% \/dev\r\ntmpfs                      1.7G  220K  1.7G   1% \/run\r\n\/dev\/disk\/by-label\/RootFS   74G   22G   48G  32% \/\r\ntmpfs                      5.0M     0  5.0M   0% \/run\/lock\r\ntmpfs                      3.4G     0  3.4G   0% \/run\/shm\r\ntmpfs                      3.4G  3.4G     0 100% \/tmp\r\n<\/pre>\n<p>\n\t&nbsp;<\/p>\n<p>\n\tand after cleaning \/tmp in my case<\/p>\n<pre>\r\ncd \/tmp\r\n\r\n\/tmp# rm -rf *\r\n\r\ndf -h\r\nFilesystem                 Size  Used Avail Use% Mounted on\r\nrootfs                      74G   22G   48G  32% \/\r\nudev                        10M     0   10M   0% \/dev\r\ntmpfs                      1.7G  220K  1.7G   1% \/run\r\n\/dev\/disk\/by-label\/RootFS   74G   22G   48G  32% \/\r\ntmpfs                      5.0M     0  5.0M   0% \/run\/lock\r\ntmpfs                      3.4G     0  3.4G   0% \/run\/shm\r\ntmpfs                      3.4G   12K  3.4G   1% \/tmp\r\n<\/pre>\n<p>\n\t&nbsp;<\/p>\n<p>\n\tit start to work again.<\/p>\n<p>\n\t&nbsp;<\/p>","protected":false},"excerpt":{"rendered":"<p>\n\tIf your Drupal site receive following message<\/p>","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_seopress_robots_primary_cat":"none","_seopress_titles_title":"","_seopress_titles_desc":"","_seopress_robots_index":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[1623,835],"tags":[],"class_list":["post-595","post","type-post","status-publish","format-standard","hentry","category-webcms-drupal-en-en","category-webcms-en"],"taxonomy_info":{"category":[{"value":1623,"label":"Drupal"},{"value":835,"label":"WebCMS"}]},"featured_image_src_large":false,"author_info":{"display_name":"admin","author_link":"https:\/\/nil.uniza.sk\/en\/author\/admin\/"},"comment_info":2,"category_info":[{"term_id":1623,"name":"Drupal","slug":"webcms-drupal-en-en","term_group":0,"term_taxonomy_id":1621,"taxonomy":"category","description":"","parent":835,"count":1,"filter":"raw","cat_ID":1623,"category_count":1,"category_description":"","cat_name":"Drupal","category_nicename":"webcms-drupal-en-en","category_parent":835},{"term_id":835,"name":"WebCMS","slug":"webcms-en","term_group":0,"term_taxonomy_id":833,"taxonomy":"category","description":"","parent":0,"count":1,"filter":"raw","cat_ID":835,"category_count":1,"category_description":"","cat_name":"WebCMS","category_nicename":"webcms-en","category_parent":0}],"tag_info":false,"_links":{"self":[{"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/posts\/595","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/comments?post=595"}],"version-history":[{"count":1,"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/posts\/595\/revisions"}],"predecessor-version":[{"id":7182,"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/posts\/595\/revisions\/7182"}],"wp:attachment":[{"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/media?parent=595"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/categories?post=595"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nil.uniza.sk\/en\/wp-json\/wp\/v2\/tags?post=595"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}