Error Number: 1 / Can't create/write to file (Errcode: 28)

UPDATE: found the solution to fix the error message on this page - problem has been solved - http://expressionengine.stackexchange.com/questions/7053/is-this-a-hosting-database-issue-not-an-ee-issue

This error is coming up intermittently on various pages of a website. It’s not permanent. I can usually reload the page after a few minutes and it will render again. Any idea on how I should fix this? I’ve tried optimizing and repairing the tables. v2.6.1 - Build Date: 20130506

Here’s an error message:

Error Number: 1 Can’t create/write to file ‘/tmp/#sql_7b7c_0.MYI’ (Errcode: 28) SELECT DISTINCT a.file_id, a.*, ae.* FROM exp_assets_files a INNER JOIN exp_assets_selections ae ON ae.file_id = a.file_id WHERE ae.entry_id IN (29) AND ae.field_id IN (1) AND is_draft = 0 ORDER BY ae.sort_order Filename: third_party/assets/ext.assets.php Line Number: 236

and here’s another one:

Error Number: 1

Can’t create/write to file ‘/tmp/#sql_7b7c_0.MYI’ (Errcode: 28)

SELECT c.cat_name, c.cat_url_title, c.cat_id, c.cat_image, c.cat_description, c.parent_id, p.cat_id, p.entry_id, c.group_id , cg.field_html_formatting, fd.* FROM (exp_categories AS c, exp_category_posts AS p) LEFT JOIN exp_category_field_data AS fd ON fd.cat_id = c.cat_id LEFT JOIN exp_category_groups AS cg ON cg.group_id = c.group_id WHERE c.cat_id = p.cat_id AND p.entry_id IN (‘26’) ORDER BY c.group_id, c.parent_id, c.cat_order

Filename: modules/channel/mod.channel.php

Line Number: 493