#1066 – Can't create/write to file '/var/tmp/mysql/

hi folks sorry to disturb you but since the 4 july we face this random error

Can't create/write to file '/var/tmp/mysql/#sql-temptable-fa1f-66f2-b.MAD' (Errcode: 28 "No space left on device")

that crash the sql database and the website of other customer on this database

as there is meta data and so on in the query, i would like to know if this SQL query is related to route 66

as our host said its this SQL query who crash the server

SELECT a.id,a.title,a.alias,a.introtext,a.fulltext,a.checked_out,a.checked_out_time,a.catid,a.created,a.created_by,a.created_by_alias,a.modified,a.modified_by,CASE WHEN a.publish_up IS NULL THEN a.created ELSE a.publish_up END AS publish_up,a.publish_down,a.images,a.urls,a.attribs,a.metadata,a.metakey,a.metadesc,a.access,a.hits,a.featured,a.language,LENGTH(a.fulltext) AS readmore,a.ordering,fp.featured_up,fp.featured_down,CASE WHEN c.published = 2 AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END AS state,c.title AS category_title,c.path AS category_route,c.access AS category_access,c.alias AS category_alias,c.language AS category_language,c.published,c.published AS parents_published,c.lft,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,uam.name AS modified_by_name,parent.title AS parent_title,parent.id AS parent_id,parent.path AS parent_route,parent.alias AS parent_alias,parent.language AS parent_language
FROM s8c9k_content AS a
LEFT JOIN s8c9k_categories AS c ON c.id = a.catid
LEFT JOIN s8c9k_users AS ua ON ua.id = a.created_by
LEFT JOIN s8c9k_users AS uam ON uam.id = a.modified_by
LEFT JOIN s8c9k_categories AS parent ON parent.id = c.parent_id
LEFT JOIN s8c9k_content_frontpage AS fp ON fp.content_id = a.id
WHERE a.access IN (1,5,7) AND c.access IN (1,5,7) AND c.published = 1 AND a.state = 1 AND a.catid IN (103,211,90,91,92,93,94,95,96,98,101) AND (a.publish_up IS NULL OR a.publish_up <= '2023-07-06 13:49:41') AND (a.publish_down IS NULL OR a.publish_down >= '2023-07-06 13:49:41')
ORDER BY a.created DESC LIMIT 3

Hi,

The error message says that your server is out of space. I am not sure if this is caused by that query. If your server is out of space then you will get this error for any query that requires a temporary table.
So the first thing to do is check that your server has enough disk space. Check for any log files that might take a lot of space on your server.

In case that your server has available space and that query is causing the issue, you need to find which extension is running this query. This seems to me like the core joomla articles query. But if you want to make sure that this is not caused by Route 66 you can simply disable all Route 66 plugins and see if the issue is resolved.

Please let me know when you have any news on this.

Regards

hi Mr Lefteris Kavadas, we have found i guess the guilty module, thanks you so much for your kind reply

f.

You are welcome.