class.udb.php:182 Can't change size of file (Errcode: 28 - No space left on device)

CREATE TEMPORARY TABLE `tmpC1406308669` ENGINE=MEMORY
SELECT rooms.roomID, rooms.roomName, rooms.roomCount, rooms.siteID, rooms.maxGuests, rooms.maxAdults, rooms.maxKids, rooms.roomSize, rooms.basisGuests AS `basePax`,
IF(rooms.roomOrPage = 10, 1, 0) AS `isPackage`, MIN(LEAST(pr.weekday1, pr.weekend1)) AS `startPrice`, CAST(ANY_VALUE(files.src) AS CHAR(250)) AS `firstPic`, 0 AS `bedrooms`
FROM `sites` INNER JOIN `sites_periods` AS `p` USING(`siteID`) INNER JOIN `rooms_prices` AS `pr` USING(`periodID`)
INNER JOIN `rooms` USING (`roomID`)
INNER JOIN `room_type_search` ON (rooms.roomID = room_type_search.roomID AND room_type_search.roomType IN (398))
LEFT JOIN `pictures` ON (pictures.galleryID = rooms.galleryWinter AND pictures.showOrder = 1)
LEFT JOIN `files` ON (pictures.fileID = files.id)
WHERE (rooms.roomOrPage = 1 OR rooms.roomOrPage = 10) /*AND rooms.packParent = 0*/ AND pr.day = -1 AND pr.weekday1 > 0 AND pr.weekend1 > 0 AND (p.periodType > 0 OR p.dateTo >= '2025-03-25') AND sites.siteID IN (15979,16185,17094,18382) AND sites.active = 1 AND sites.hideFromFree = 0 AND rooms.active = 1
GROUP BY rooms.roomID
ORDER BY NULL
1: class.InSearch.php:298 udb::query()
2: inc_searchResults_optimized.php:127 InSearch::categorySearch()
3: index.php:811 include()