Exception

Database Exceptionyii\db\Exception

SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql_518_48.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
The SQL being executed was:

SELECT C.Worksheet_id,
(SELECT C.CoverURL FROM catalogs C WHERE C.ID = '921') AS CoverURL ,
(SELECT W.name FROM worksheets W WHERE W.ID = C.worksheet_id) AS JENIS_BAHAN,
(SELECT GROUP_CONCAT(CS.Value ORDER BY CR.Tag,CS.Sequence ASC SEPARATOR ' ') FROM catalog_subruas CS LEFT JOIN catalog_ruas CR ON CS.RuasID = CR.ID WHERE CR.CatalogId = C.ID AND CR.Tag IN (245) GROUP BY CR.CatalogId) AS JUDUL,
(SELECT GROUP_CONCAT(CS.Value ORDER BY CR.Tag,CS.Sequence ASC SEPARATOR ' ') FROM catalog_subruas CS LEFT JOIN catalog_ruas CR ON CS.RuasID = CR.ID WHERE CR.CatalogId = C.ID AND CR.Tag IN (240) GROUP BY CR.CatalogId) AS JUDUL_SERAGAM,
(

SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR ' ') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid,
CASE
WHEN CS.SUBRUAS = 'e'
THEN CONCAT ( '(' , CS.Value , ') |' )
ELSE CS.Value
END AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '921'
AND CR.Tag IN (100,110,111,700,710,711,800,810,811)
AND CS.Subruas IN ('a', 'd' ,'e')
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z
) AS PENGARANG,
(


SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '921'
AND CR.Tag IN (250)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z


) AS EDISI,
(


SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '921'
AND CR.Tag IN (490)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z


) AS PERNYATAAN_SERI,
(

SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR ' ') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '921'
AND CR.Tag IN (260,264)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z

) AS PENERBITAN,
(
SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid,
CASE
WHEN CS.SUBRUAS = '3'
THEN CONCAT ( '[' , CS.Value , ']' )
ELSE CS.Value
END AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '921'
AND CR.Tag IN (300)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
ORDER BY CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z

) AS DESKRIPSI_FISIK,
(
SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR ' ') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid,
-- CS.Value AS VAL1
CASE
WHEN CS.SUBRUAS = '3'
THEN CONCAT ( '[' , CS.Value , ']' )
ELSE CS.Value
END AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '921'
AND CR.Tag IN (336)
and CS.SubRuas <> 2
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
ORDER BY sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z
) AS KONTEN,
(
SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '921'
AND CR.Tag IN (337)
and CS.SubRuas <> 2
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z

) AS MEDIA,
(
SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '921'
AND CR.Tag IN (338)
and CS.SubRuas <> 2
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z


) AS PENYIMPANAN_MEDIA,
(

SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '921'
AND CR.Tag IN (538)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z


) AS INFORMASI_TEKNIS,
(

SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '921'
AND CR.Tag IN (020)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z

) AS ISBN,
(

SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '921'
AND CR.Tag IN (022)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z

) AS ISSN,
(

SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '921'
AND CR.Tag IN (024)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z

) AS ISMN,
(
SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid,
CASE
WHEN CS.SubRuas <> 'a'
THEN
CONCAT(' ',CS.Value)
ELSE CS.Value
END AS VAL1

FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '921'
AND CR.Tag IN (600,610,611,650,651)
GROUP BY
CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z


) AS SUBJEK,
(


SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '921'
AND CR.Tag IN (520)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z



) AS ABSTRAK,
(

SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '921'
AND CR.Tag IN (500,501,502,504,505,533,550)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z

) AS CATATAN,
(SELECT RI.Name FROM catalog_ruas CR LEFT JOIN refferenceitems RI ON TRIM(RI.Code) = SUBSTRING(CR.VALUE,36,3) WHERE CR.CatalogId = C.ID AND CR.Tag = 008 AND RI.Refference_id = 5) AS BAHASA,
(SELECT RI.Name FROM catalog_ruas CR LEFT JOIN refferenceitems RI ON TRIM(RI.Code) = SUBSTRING(CR.VALUE,34,1) WHERE CR.CatalogId = C.ID AND CR.Tag = 008 AND RI.Refference_id = 17) AS BENTUK_KARYA,
(SELECT RI.Name FROM catalog_ruas CR LEFT JOIN refferenceitems RI ON TRIM(RI.Code) = SUBSTRING(CR.VALUE,23,1) WHERE CR.CatalogId = C.ID AND CR.Tag = 008 AND RI.Refference_id = 2) AS TARGET_PEMBACA,
(

SELECT GROUP_CONCAT(Z.RTRIM1 SEPARATOR '|') AS RTRIM2
FROM
(SELECT GROUP_CONCAT(Y.VAL1 SEPARATOR '') AS RTRIM1
FROM
(SELECT *
FROM (
(SELECT CS.sequence,
CS.Ruasid, CS.Value AS VAL1
FROM catalog_subruas CS
LEFT JOIN catalog_ruas CR
ON CS.RuasID = CR.ID
WHERE CR.CatalogId = '921'
AND CR.Tag IN (856)
GROUP BY CS.Ruasid,
CS.SUBRUAS,
CS.Value,
CS.Sequence
)) X
ORDER BY ruasid,
sequence
) Y
GROUP BY Ruasid
) Z


) AS LOKASI_AKSES_ONLINE
FROM catalogs C WHERE C.ID = '921' AND isopac = 1

Error Info: Array
(
    [0] => HY000
    [1] => 1021
    [2] => Disk full (/tmp/#sql_518_48.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
)
$_GET = [
    'id' => '921',
];

$_SESSION = [
    '__flash' => [],
];

Warning: file_put_contents(/var/www/html/library.sdwahdah.sch.id/opac/runtime/debug/6605deff14853.data): failed to open stream: No space left on device in /var/www/html/library.sdwahdah.sch.id/vendor/yiisoft/yii2-debug/LogTarget.php on line 57
Exception (Database Exception) 'yii\db\Exception' with message 'SQLSTATE[HY000]: General error: 1021 Disk full (/tmp/#sql_518_0.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") The SQL being executed was: SHOW FULL COLUMNS FROM `session`' in /var/www/html/library.sdwahdah.sch.id/vendor/yiisoft/yii2/db/Schema.php:628 Stack trace: #0 /var/www/html/library.sdwahdah.sch.id/vendor/yiisoft/yii2/db/Command.php(855): yii\db\Schema->convertException(Object(PDOException), 'SHOW FULL COLUM...') #1 /var/www/html/library.sdwahdah.sch.id/vendor/yiisoft/yii2/db/Command.php(362): yii\db\Command->queryInternal('fetchAll', NULL) #2 /var/www/html/library.sdwahdah.sch.id/vendor/yiisoft/yii2/db/mysql/Schema.php(198): yii\db\Command->queryAll() #3 /var/www/html/library.sdwahdah.sch.id/vendor/yiisoft/yii2/db/mysql/Schema.php(97): yii\db\mysql\Schema->findColumns(Object(yii\db\TableSchema)) #4 /var/www/html/library.sdwahdah.sch.id/vendor/yiisoft/yii2/db/Schema.php(146): yii\db\mysql\Schema->loadTableSchema('session') #5 /var/www/html/library.sdwahdah.sch.id/vendor/yiisoft/yii2/db/mysql/QueryBuilder.php(188): yii\db\Schema->getTableSchema('{{%session}}') #6 /var/www/html/library.sdwahdah.sch.id/vendor/yiisoft/yii2/db/Command.php(430): yii\db\mysql\QueryBuilder->insert('{{%session}}', Array, Array) #7 /var/www/html/library.sdwahdah.sch.id/vendor/yiisoft/yii2/web/DbSession.php(172): yii\db\Command->insert('{{%session}}', Array) #8 [internal function]: yii\web\DbSession->writeSession('56aodogkuqkknoc...', '__flash|a:0:{}') #9 /var/www/html/library.sdwahdah.sch.id/vendor/yiisoft/yii2/web/Session.php(174): session_write_close() #10 [internal function]: yii\web\Session->close() #11 {main}
Warning: file_put_contents(/var/www/html/library.sdwahdah.sch.id/opac/runtime/debug/6605deff14853.data): failed to open stream: No space left on device in /var/www/html/library.sdwahdah.sch.id/vendor/yiisoft/yii2-debug/LogTarget.php on line 57