Erreur code 28

Réduire
X
 
  • Filtrer
  • Heure
  • Afficher
Tout effacer
nouveaux messages

  • Erreur code 28

    Bonjour,
    Depuis quelque temps la page d'accueil de mon site présente un contenu "bizarre" (voir ci-dessous) affiché en rouge sur fond blanc. Dans ces phases, le back-end renvoie lui aussi des messages "étranges" (ci-dessous aussi). Les dernières lignes du message indiquent l'heure du plantage mais je ne comprends pas vraiment l'origine de celui-ci. Quelqu'un aurait-il vécu ce genre de situation, ou aurait-il une idée de "traitement" à mettre en place pour éviter cela ?

    Merci d'avance !

    Message en back-end :
    Can't create/write to file '/tmp/#sql_4fd8_3.MYI' (Errcode: 28) SQL=SELECT a.id AS value, a.title AS text, a.level, a.published FROM jnew_categories AS a LEFT JOIN `jnew_categories` AS b ON a.lft > b.lft AND a.rgt < b.rgt WHERE (a.extension = 'com_content') AND a.published IN (0,1) GROUP BY a.id, a.title, a.level, a.lft, a.rgt, a.extension, a.parent_id, a.published ORDER BY a.lft ASC

    Message en front-end :
    Can't create/write to file '/tmp/#sql_4fd8_1.MYD' (Errcode: 28) SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 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.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null 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,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM jnew_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM jnew_content AS a LEFT JOIN jnew_categories AS c ON c.id = a.catid LEFT JOIN jnew_users AS ua ON ua.id = a.created_by LEFT JOIN jnew_users AS uam ON uam.id = a.modified_by LEFT JOIN jnew_categories as parent ON parent.id = c.parent_id LEFT JOIN jnew_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jnew_categories AS cat JOIN jnew_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN jnew_content_frontpage AS fp ON fp.content_id = a.id WHERE CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-09-26 17:33:48') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-09-26 17:33:48') ORDER BY a.featured DESC, fp.ordering, a.created DESC LIMIT 0, 9 Can't create/write to file '/tmp/#sql_4fd8_1.MYD' (Errcode: 28) SQL=SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,CASE WHEN a.publish_up = 0 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.xreference, a.featured, LENGTH(a.fulltext) AS readmore,CASE WHEN badcats.id is not null 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,CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,( SELECT MAX(contact.id) AS id FROM jnew_contact_details AS contact WHERE contact.published = 1 AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM jnew_content AS a LEFT JOIN jnew_categories AS c ON c.id = a.catid LEFT JOIN jnew_users AS ua ON ua.id = a.created_by LEFT JOIN jnew_users AS uam ON uam.id = a.modified_by LEFT JOIN jnew_categories as parent ON parent.id = c.parent_id LEFT JOIN jnew_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jnew_categories AS cat JOIN jnew_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.extension = 'com_content' AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id INNER JOIN jnew_content_frontpage AS fp ON fp.content_id = a.id WHERE CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2013-09-26 17:33:48') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-09-26 17:33:48') ORDER BY a.featured DESC, fp.ordering, a.created DESC

  • #2
    Re : Erreur code 28

    Bonjour,

    Une erreur MySQL 28 signifie "Plus d'espace disponible sur le disque".

    Dans ce cas précis, une requête SQL complexe nécessite une table temporaire /tmp/#sql_4fd8_3.MYI, ce qui implique que la partition contenant /tmp est pleine (soit un /tmp jamais vidé, soit un process cron de nettoyage jamais exécuté).

    Seule et unique solution: nettoyer le fatras pour faire de la place.

    Si en hébergement mutualisé, faire remonter l'info à l'hébergeur.
    Si sur VPS/Dédié, fairele ménage dans /tmp en virant sans étât d'âme tout ce qui y traine et date de plus de 24 heures. Et en prime, revoir la config du serveur pour tracer pourquoi le cron.daily de nettoyage n'est jamais exécuté.

    Un autre cas de figure en dédié/VPS est que les partitions sont mal déclarées et que le /tmp est vraiment à l'étroit.

    Si la partition /var a beaucoup d'espace libre, supprimer /tmp et créer un lien symbolique (symlinq) par exemple ln -s /var/tmp /tmp
    Dernière édition par jisse03 à 27/09/2013, 05h33
    Pas de demande de support par MP.
    S'il n'y a pas de solution, c'est qu'il n'y a pas de problème (Devise Shadok)

    Commentaire


    • #3
      Re : Erreur code 28

      Merci beaucoup pour cette réponse. Je fais le nécessaire pour mettre de l'ordre !

      Commentaire

      Annonce

      Réduire
      Aucune annonce pour le moment.

      Partenaire de l'association

      Réduire

      Hébergeur Web PlanetHoster
      Travaille ...
      X