class.udb.php:182 Error writing file '/tmp/#sql1e1a_ea33a9_0.frm' (Errcode: 28 - No space left on device)

CREATE TEMPORARY TABLE `tmpT766746688` (
`cDate` DATE NOT NULL DEFAULT '0000-00-00',
`wEnd` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
`cEnd` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
`roomID` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
`packParent` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
`roomCount` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
`isPackage` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
`siteID` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
`nightIndex` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
`bp1` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
`basePeriod` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
`periodID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
`ppID` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
`price` FLOAT NOT NULL DEFAULT -1,
`altPrice` FLOAT NOT NULL DEFAULT -1,
`fixedBase` FLOAT NOT NULL DEFAULT -1,
`fixedBase2` FLOAT NOT NULL DEFAULT -1,
`fixedPrice` FLOAT NOT NULL DEFAULT -1,
`fixedAlt` FLOAT NOT NULL DEFAULT -1,
`panPrice` SMALLINT(6) NOT NULL DEFAULT 0,
`cleanFee` FLOAT NOT NULL DEFAULT 0,
`extraAdults` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
`extraKids` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
`totalEA` FLOAT NOT NULL DEFAULT -1,
`totalEK` FLOAT NOT NULL DEFAULT -1,
`frees` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
`minGuests` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
`maxGuests` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
`maxAdults` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
`maxKids` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
`basePax` TINYINT(3) NOT NULL DEFAULT 0,
`minNights` TINYINT(4) NOT NULL DEFAULT 1,
`minVoid` TINYINT(4) NOT NULL DEFAULT 1,
`minBlock` TINYINT(3) UNSIGNED NOT NULL DEFAULT 0,
`bedrooms` TINYINT(3) UNSIGNED NOT NULL DEFAULT 1,
`exitBaseP` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
`exitRealP` MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0
) ENGINE=MEMORY

SELECT year.date AS `cDate`, year.weekday AS `wEnd`, 0 AS `cEnd`, rooms.roomID, rooms.packParent, rooms.roomCount, IF(rooms.roomOrPage = 10, 1, 0) AS `isPackage`, rooms.siteID, DATEDIFF(year.date, '2025-03-25') AS `nightIndex`
, p1.periodID AS `bp1`, IF(p3.periodID OR (holidays.holidayID AND p0.periodID IS NULL), p2.periodID, p1.periodID) AS `basePeriod`, IFNULL(p3.periodID, IF(holidays.holidayID AND p0.periodID IS NULL, p2.periodID, p1.periodID)) as `periodID`
, IF(rp3.roomID, p3.periodID, IF(p3.periodID OR (holidays.holidayID AND p0.periodID IS NULL), IF(rp2.roomID, p2.periodID, p1.periodID), p1.periodID)) as `ppID`
, -1 as `price`, -1 as `altPrice`, -1 as `fixedBase`, -1 as `fixedBase2`, -1 as `fixedPrice`, -1 as `fixedAlt`, 0 as `panPrice`, rooms.cleanFee
, GREATEST(0, -rooms.basisGuests + 2) as `extraAdults`, GREATEST(0, LEAST(-rooms.basisGuests + 0, 0)) as `extraKids`
, IF(rp3.roomID IS NULL, IF(rp3.roomID IS NOT NULL AND (p3.periodID OR (holidays.holidayID AND p0.periodID IS NULL)), IF(FIND_IN_SET(year.weekday, p2.weekend), IFNULL(rp2.extraPriceAdultWeekend, -1), IFNULL(rp2.extraPriceAdultWeekday, -1)), IF(FIND_IN_SET(year.weekday, p1.weekend), IFNULL(rp1.extraPriceAdultWeekend, -1), IFNULL(rp1.extraPriceAdultWeekday, -1))), IF( FIND_IN_SET(year.weekday, p3.weekend), rp3.extraPriceAdultWeekend, rp3.extraPriceAdultWeekday)) AS `totalEA`
, IF(rp3.roomID IS NULL, IF(rp3.roomID IS NOT NULL AND (p3.periodID OR (holidays.holidayID AND p0.periodID IS NULL)), IF(FIND_IN_SET(year.weekday, p2.weekend), IFNULL(rp2.extraPriceKidWeekend, -1), IFNULL(rp2.extraPriceKidWeekday, -1)), IF(FIND_IN_SET(year.weekday, p1.weekend), IFNULL(rp1.extraPriceKidWeekend, -1), IFNULL(rp1.extraPriceKidWeekday, -1))), IF( FIND_IN_SET(year.weekday, p3.weekend), rp3.extraPriceKidWeekend, rp3.extraPriceKidWeekday)) AS `totalEK`
, IF(rooms.roomOrPage = 10, 0, IFNULL(ud.free, rooms.roomCount)) AS `frees`, rooms.minGuests, rooms.maxGuests, rooms.maxAdults, rooms.maxKids, rooms.basisGuests AS `basePax`, -100 as `minNights`, -100 as `minVoid`, 0 AS `minBlock`, 1 AS `bedrooms`, 0 AS `exitBaseP`, 0 AS `exitRealP`
FROM `year` INNER JOIN `rooms` ON (year.date BETWEEN '2025-03-25' AND '2025-03-25') INNER JOIN `sites` USING(`siteID`)
INNER JOIN `sites_periods` as `p1` ON (sites.siteID = p1.siteID AND p1.periodType = 1)
INNER JOIN `sites_periods` as `p2` ON (sites.siteID = p2.siteID AND p2.periodType = 2)

LEFT JOIN `rooms_prices` as `rp1` ON (rp1.periodID = p1.periodID AND rooms.roomID = rp1.roomID AND rp1.day = year.weekday)
LEFT JOIN `rooms_prices` as `rp2` ON (rp2.periodID = p2.periodID AND rooms.roomID = rp2.roomID AND rp2.day = year.weekday)
LEFT JOIN `sites_periods` as `p3` ON (sites.siteID = p3.siteID AND p3.periodType = 0 AND year.date BETWEEN p3.dateFrom AND p3.dateTo)
LEFT JOIN `rooms_prices` as `rp3` ON (rp3.periodID = p3.periodID AND rooms.roomID = rp3.roomID AND rp3.day = year.weekday)
LEFT JOIN `holidays` ON (p3.periodID IS NULL AND year.date BETWEEN holidays.dateStart AND holidays.dateEnd)
LEFT JOIN `sites_periods` as `p0` ON (holidays.holidayID IS NOT NULL AND sites.siteID = p0.siteID AND p0.periodType = 0 AND p0.holidayID = holidays.holidayID)
LEFT JOIN `unitsDates` AS `ud` ON (ud.roomID = rooms.roomID AND ud.date = year.date)
WHERE ((rooms.roomOrPage = 1 OR rooms.roomOrPage = 10) AND sites.siteID IN (14364) AND sites.active = 1 /*AND sites.hideFromFree = 0*/ AND rooms.active = 1) GROUP BY `cDate`, `roomID` ORDER BY NULL
1: class.InSearch.php:593 udb::query()
2: inc_minisiteNew_optimized.php:465 InSearch::getPriceData()
3: index.php:809 include()