Warning: mysqli::query(): (HY000/1): Can't create/write to file '/tmp/#sql-temptable-1-1b2aa8d-1d88f.MAI' (Errcode: 28 "No space left on device") in /app/etaamb/classes/connector.class.php on line 100
QUERY ERROR
**********
SQL: select SQL_CACHE
docs.numac as numac,
docs.anonymise as anon,
titles.raw as title_raw,
titles.pure as title_pure,
source_fr as source,
type_fr as type,
docs.chrono_id as chrono_id,
docs.senate_id as senate_id,
docs.senate_leg as senate_leg,
docs.chamber_id as chamber_id,
docs.chamber_leg as chamber_leg,
DATE_FORMAT(pub_date, '%Y%m%d') as pub_date,
DATE_FORMAT(prom_date, '%Y%m%d') as prom_date
FROM `docs`
join titles on docs.numac = titles.numac
join sources on docs.source = sources.id
join types on docs.type = types.id where docs.numac in (2014207242, 2014207301, 2014207597, 2015027006, 2015027056, 2015027121, 2015027189, 2015027190, 2015027220, 2015027226, 2015200072, 2015200480, 2015200574, 2015200951, 2015201244, 2015201562, 2015201725, 2015201794, 2015201974, 2015202374, 2015202479, 2015202480, 2015202491, 2015202527, 2015202747, 2015202976, 2015202977, 2015202982, 2015202983, 2015203205, 2015203257, 2015203259, 2015203612, 2015203805, 2015204010, 2015204138, 2015204241, 2015204243, 2015204310, 2015204325, 2015204326, 2015204368, 2015204446, 2015204490, 2015204504, 2015204576, 2015204577, 2015204642, 2015204903, 2015205063, 2015205077, 2015205113, 2015205484, 2015205755, 2015205865, 2015205949, 2015205971, 2015205972, 2015205973, 2015205975, 2015205976, 2016027001, 2016027012, 2016027013, 2016027014, 2016027029, 2016027066, 2016027216, 2016027229, 2016027252, 2016027267, 2016027298, 2016027319, 2016027320, 2016027335, 2016200160, 2016200162, 2016200247, 2016200549, 2016200646, 2016200647, 2016201097, 2016201101, 2016201186, 2016201187, 2016201249, 2016201501, 2016201726, 2016201736, 2016201757, 2016202150, 2016202331, 2016202430, 2016202520, 2016202676, 2016202677, 2016202766, 2016202819, 2016202888, 2016202974, 2016203062, 2016203121, 2016203192, 2016203193, 2016203462, 2016203486, 2016203527, 2016203585, 2016203586, 2016203624, 2016203701, 2016203747, 2016203748, 2016203870, 2016203977, 2016203978, 2016204093, 2016204260, 2016204261, 2016204379, 2016204537, 2016204538, 2016204539, 2016204558, 2016204559, 2016204579, 2016204863, 2016204864, 2016204865, 2016204923, 2016205084, 2016205089, 2016205106, 2016205107, 2016205108, 2016205123, 2016205147, 2016205171, 2016205246, 2016205251, 2016205306, 2016205469, 2016205604, 2016205605, 2016205607, 2016205713, 2016205724, 2016205879, 2016205880, 2016205881, 2016205979, 2016205984, 2016205987, 2016206079, 2016206123, 2016206239, 2016206354, 2016206423, 2016206480, 2016206481, 2016206489, 2017010384, 2017011111, 2017011433, 2017012303, 2017012479, 2017012490, 2017012491, 2017012720, 2017030634, 2017032134, 2017070001, 2017070002, 2017070166, 2017070167, 2017070168, 2017070169, 2017200102, 2017200145, 2017200147, 2017200150, 2017200167, 2017200280, 2017200295, 2017200309, 2017200435, 2017200571, 2017200573, 2017200983, 2017201195, 2017201196, 2017201464, 2017201543, 2017201629, 2017201672, 2017201673, 2017201743, 2017201744, 2017201762, 2017201764, 2017201892, 2017201991, 2017202001, 2017202018, 2017202115, 2017202269, 2017202270, 2017202272, 2017202593, 2017202667, 2017202717, 2017202718, 2017202778, 2017202779, 2017203085, 2017203195, 2017203250, 2017203265, 2017203329, 2017203584, 2017203612, 2017203740, 2017203785, 2017203824, 2017203913, 2017203926, 2017203927, 2017203969, 2017204127, 2017204142, 2017204145, 2017204384, 2017204521, 2017204522, 2017204676, 2017204738, 2017204772, 2017205040, 2017205178, 2017205205, 2017205206, 2017205212, 2017205572, 2017205655, 2017205658, 2017205690, 2017205761, 2017205775, 2017205911, 2017205912, 2017205977, 2017205979, 2017206030, 2017206274, 2017206297, 2017206417, 2017206419, 2017206538, 2017206660, 2017206739, 2017206798, 2017206810, 2018010104, 2018010470, 2018011989, 2018011990, 2018011991, 2018013520, 2018013841, 2018013878, 2018013962, 2018014305, 2018014330, 2018014385, 2018014404, 2018014448, 2018070015, 2018070016, 2018070017, 2018070018, 2018200046, 2018200189, 2018200190, 2018200191, 2018200350, 2018200439, 2018200608, 2018200687, 2018200711, 2018200869, 2018201139, 2018201301, 2018201537, 2018201540, 2018201629, 2018201656, 2018201658, 2018202248, 2018202249, 2018202406, 2018202420, 2018202422, 2018202442, 2018202790, 2018203047, 2018203051, 2018203053, 2018203137, 2018203138, 2018203168, 2018203200, 2018203221, 2018203222, 2018203265, 2018203285, 2018203286, 2018203379, 2018203492, 2018203589, 2018203814, 2018203884, 2018204361, 2018204429, 2018204430, 2018204431, 2018204438, 2018204557, 2018204582, 2018204701, 2018204702, 2018204705, 2018204736, 2018205034, 2018205047, 2018205048, 2018205096, 2018205173, 2018205201, 2018205293, 2018205297, 2018205304, 2018205387, 2018205401, 2018205473, 2018205474, 2018205475, 2018205533, 2018205565, 2018205575, 2018205576, 2018205765, 2018205816, 2018205915, 2018206098, 2018206194, 2018206213, 2018206224, 2018206247, 2018206321, 2019010361, 2019011357, 2019011843, 2019012857, 2019013316, 2019013387, 2019013752, 2019014813, 2019015074, 2019015075, 2019015080, 2019015173, 2019030089, 2019030169, 2019030363, 2019040382, 2019040383, 2019041285, 2019042318, 2019042496, 2019042659, 2019042960, 2019200146, 2019200207, 2019200241, 2019200243, 2019200345, 2019200352, 2019200355, 2019200357, 2019200402, 2019200403, 2019200469, 2019200513, 2019200666, 2019200725, 2019200752, 2019200780, 2019200781, 2019200928, 2019201060, 2019201063, 2019201436, 2019201437, 2019201518, 2019201601, 2019201603, 2019201627, 2019201646, 2019201740, 2019201746, 2019201769, 2019201793, 2019201821, 2019201864, 2019201883, 2019202054, 2019202055, 2019202068, 2019202099, 2019202193, 2019202194, 2019202332, 2019202351, 2019202352, 2019202418, 2019202419, 2019202429, 2019202430, 2019202459, 2019202465, 2019202507, 2019202550, 2019202607, 2019202610, 2019202616, 2019202622, 2019202721, 2019202722, 2019202871, 2019202967, 2019202993, 2019203007, 2019203023, 2019203024, 2019203198, 2019203347, 2019203348, 2019203473, 2019203498, 2019203587, 2019203594, 2019203626, 2019203627, 2019203670, 2019203712, 2019203882, 2019203883, 2019203892, 2019203963, 2019203970, 2019203973, 2019203993, 2019204008, 2019204179, 2019204342, 2019204705, 2019204721, 2019204754, 2019204876, 2019204895, 2019205066, 2019205225, 2019205241, 2019205628, 2019205668, 2019206085, 2019206086, 2020010220, 2020010245, 2020010447, 2020015565, 2020016055, 2020016061, 2020016192, 2020016255, 2020016294, 2020020735, 2020020818, 2020020894, 2020021091, 2020021139, 2020021251, 2020030426, 2020030464, 2020030825, 2020030925, 2020030966, 2020031144, 2020031192, 2020031524, 2020031718, 2020040758, 2020040986, 2020040987, 2020041046, 2020041047, 2020041153, 2020041455, 2020041458, 2020041783, 2020041786, 2020041895, 2020041959, 2020041995, 2020042394, 2020042509, 2020042511, 2020042974, 2020043199, 2020043452, 2020044556, 2020044688, 2020044689, 2020044709, 2020200332, 2020200445, 2020200603, 2020200626, 2020202178, 2020202189, 2020202817, 2020202829, 2020202984, 2020203028, 2020203029, 2020203130, 2020203276, 2020203312, 2020203313, 2020203684, 2020203709, 2020203710, 2020204089, 2020204161, 2020204212, 2020204214, 2020204218, 2020204244, 2020204245, 2020204325, 2020204468, 2020204719, 2020205007, 2020205341, 2020205402, 2020205556, 2020205576, 2020205716, 2021020492, 2021020656, 2021020707, 2021020954, 2021021103, 2021021339, 2021021340, 2021021650, 2021021681, 2021021814, 2021021815, 2021022078, 2021022170, 2021022201, 2021022360, 2021022390, 2021022883, 2021030062, 2021030916, 2021031200, 2021031201, 2021031202, 2021031203, 2021031232, 2021031263, 2021031264, 2021031333, 2021031357, 2021031515, 2021031671, 2021031801, 2021031802, 2021031822, 2021031919, 2021031971, 2021031972, 2021032995, 2021033115, 2021033378, 2021033407, 2021033592, 2021033727, 2021033735, 2021033749, 2021033750, 2021033999, 2021034000, 2021034034, 2021034139, 2021034458, 2021040022, 2021040222, 2021040317, 2021040318, 2021040418, 2021040471, 2021040572, 2021040573, 2021040701, 2021040781, 2021041020, 2021041717, 2021041971, 2021042517, 2021042699, 2021043606, 2021200036, 2021200055, 2021200071, 2021200131, 2021200206, 2021200218, 2021200297, 2021200311, 2021200343, 2021200379, 2021200673, 2021200989, 2021201120, 2021201399, 2021201451, 2021202234, 2021202525, 2021202615, 2021202743, 2021202798, 2021202806, 2021202824, 2021203186, 2021203303, 2021203305, 2021203307, 2021203394, 2021203401, 2021203576, 2021203928, 2021204238, 2021204393, 2021204483, 2021205059, 2021205061, 2021205177, 2021205192, 2021205807, 2021205808, 2021206025, 2022015149, 2022015423, 2022015528, 2022020001, 2022020007, 2022020285, 2022020340, 2022020351, 2022020532, 2022020832, 2022020898, 2022020979, 2022031096, 2022031270, 2022031548, 2022031655, 2022031803, 2022032083, 2022032165, 2022032480, 2022033185, 2022033273, 2022033313, 2022033687, 2022033704, 2022033767, 2022033942, 2022034025, 2022034026, 2022034178, 2022034181, 2022034279, 2022034594, 2022034595, 2022034596, 2022040557, 2022041348, 2022042047, 2022042385, 2022042748, 2022042799, 2022043449, 2022200070, 2022200096, 2022200381, 2022200383, 2022200391, 2022200410, 2022200623, 2022201127, 2022201128, 2022201209, 2022201439, 2022201572, 2022201588, 2022201589, 2022201792, 2022202059, 2022202061, 2022202196, 2022202241, 2022202286, 2022202661, 2022203256, 2022204087, 2022204109, 2022205464, 2022205502, 2022205589, 2022205592, 2022205620, 2022206215, 2022206247, 2022206273, 2022206320, 2022206333, 2022206413, 2022206414, 2022206424, 2022206606, 2022206722, 2022206901, 2022207390, 2022207398, 2022207399, 2023010009, 2023030526, 2023030527, 2023030687, 2023031081, 2023031153, 2023031280, 2023040161, 2023040424, 2023040425, 2023040524, 2023040544, 2023040589, 2023040780, 2023040800, 2023041431, 2023041432, 2023042069, 2023042075, 2023042076, 2023042111, 2023042301, 2023042302, 2023042304, 2023042312, 2023042315, 2023042748, 2023042750, 2023043014, 2023043489, 2023044650, 2023044651, 2023044779, 2023044842, 2023044852, 2023044867, 2023044869, 2023044870, 2023045121, 2023045555, 2023045698, 2023045867, 2023046134, 2023046138, 2023046533, 2023046534, 2023046668, 2023046989, 2023047320, 2023047348, 2023047413, 2023047549, 2023047551, 2023047552, 2023047554, 2023047567, 2023048235, 2023048285, 2023048390, 2023048800, 2023200051, 2023200478, 2023200707, 2023202570, 2023202571, 2023202573, 2023202878, 2023202959, 2023203003, 2023203068, 2023203240, 2023203569, 2023203772, 2023203773, 2023203778, 2023203783, 2023204398, 2023204441, 2023205746, 2023206329, 2023206355, 2023206478, 2023206484, 2023206486, 2023206586, 2023206719, 2023206720, 2024000224, 2024000521, 2024000716, 2024001154, 2024001216, 2024001528, 2024001679, 2024001785, 2024001843, 2024001844, 2024002163, 2024002435, 2024002439, 2024002587, 2024002743, 2024003324, 2024003550, 2024003912, 2024004276, 2024004279, 2024004315, 2024004586, 2024004682, 2024004960, 2024005113, 2024005116, 2024005190, 2024005848, 2024006276, 2024006327, 2024006460, 2024006523, 2024006587, 2024006664, 2024006683, 2024006864, 2024006926, 2024007154, 2024007204, 2024007209, 2024007213, 2024007525, 2024007847, 2024008136, 2024008338, 2024008504, 2024008518, 2024008925, 2024008939, 2024008940, 2024009164, 2024009223, 2024009350, 2024009619, 2024009667, 2024009680, 2024009723, 2024009880, 2024009881, 2024009882, 2024009899, 2024009902, 2024010102, 2024010113, 2024010181, 2024010381, 2024010384, 2024010537, 2024010538, 2024010633, 2024010635, 2024010995, 2024011125, 2024011174, 2024011175, 2024011307, 2024011366, 2024011433, 2024011775, 2024011851, 2024011959, 2024200325, 2024200326, 2024200405, 2024200432, 2024200435, 2024200436, 2024200500, 2024201063, 2024201065, 2024201416, 2024201548, 2024201872, 2024202133, 2024202324, 2024202562, 2024202908, 2024202910, 2024203059, 2024203062, 2024203070, 2024203378, 2024203707, 2024203709, 2024203756, 2024203781, 2024203784, 2024203791, 2024203811, 2024203839, 2024204535, 2024204795, 2024204796, 2024204923, 2024204950, 2024204997, 2024205106, 2024205273, 2024205628, 2024205662, 2024205828, 2024205915, 2024206072, 2024206293, 2025001500, 2025001502, 2025001508, 2025001707, 2025001853, 2025001993, 2025001994, 2025001995, 2025001996, 2025002226, 2025002228, 2025002229, 2025002230, 2025002262, 2025002267, 2025002284, 2025002430, 2025002431, 2025002831, 2025002927, 2025002928, 2025002931, 2025003388, 2025003393, 2025003406, 2025003430, 2025003944, 2025003945, 2025200460, 2025200474, 2025200883, 2025201687) and titles.ln = 'fr' order by types.ord ASC
ERROR: Can't create/write to file '/tmp/#sql-temptable-1-1b2aa8d-1d88f.MAI' (Errcode: 28 "No space left on device")
Fatal error: Uncaught Exception: 12808 in /app/etaamb/classes/connector.class.php:110
Stack trace:
#0 /app/etaamb/classes/collection.class.php(245): connector_class->query()
#1 /app/etaamb/classes/numac.class.php(893): collection_class->docsMeta()
#2 /app/etaamb/classes/numac.class.php(829): numac->reverseDocs_List()
#3 /app/etaamb/classes/numac.class.php(267): numac->reverseDocs()
#4 /app/etaamb/index.php(230): numac->main()
#5 {main}
thrown in /app/etaamb/classes/connector.class.php on line 110