Willkommen, Gast
Benutzername: Passwort: Angemeldet bleiben:
  • Seite:
  • 1

THEMA: sehr merkwürdig: Got error 28 from storage engine

sehr merkwürdig: Got error 28 from storage engine 05 Mai 2013 20:23 #36789

hallo und guten Abend


also auf meiner Joomlaseite hab ich heute sehr viel Ultra-Merkwürdiges entdeckt:;

das folgende nämlich:


BTW - mein SERVER ADMIN hat neulich mal von einem Einbruch erzählt.
Kann das denn sein!!?

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.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,contact.id 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 ) 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 vjl1p_content AS a LEFT JOIN vjl1p_categories AS c ON c.id = a.catid LEFT JOIN vjl1p_users AS ua ON ua.id = a.created_by LEFT JOIN vjl1p_users AS uam ON uam.id = a.modified_by LEFT JOIN vjl1p_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN vjl1p_categories as parent ON parent.id = c.parent_id LEFT JOIN vjl1p_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM vjl1p_categories AS cat JOIN vjl1p_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 vjl1p_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND 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-05-05 18:06:47') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-05 18:06:47') GROUP BY a.id ORDER BY c.lft, fp.ordering, a.created DESC LIMIT 0, 3 Got error 28 from storage engine 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.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,contact.id 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 ) 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 vjl1p_content AS a LEFT JOIN vjl1p_categories AS c ON c.id = a.catid LEFT JOIN vjl1p_users AS ua ON ua.id = a.created_by LEFT JOIN vjl1p_users AS uam ON uam.id = a.modified_by LEFT JOIN vjl1p_contact_details AS contact on contact.user_id = a.created_by LEFT JOIN vjl1p_categories as parent ON parent.id = c.parent_id LEFT JOIN vjl1p_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM vjl1p_categories AS cat JOIN vjl1p_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 vjl1p_content_frontpage AS fp ON fp.content_id = a.id WHERE a.access IN (1,1) AND 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-05-05 18:06:47') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2013-05-05 18:06:47') GROUP BY a.id ORDER BY c.lft, fp.ordering, a.created DESC

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

Letzte Änderung: von gibraltar.

sehr merkwürdig: Got error 28 from storage engine 05 Mai 2013 22:42 #36791

.....fp.ordering, a.created DESC LIMIT 0, 3 Got error 28 from storage engine SQL=SELECT a.id, a.title, a.alias.....


lmgtfy.com/?q=Got+error+28+from+storage+engine

:woohoo:
Man soll das Kind ins Korn werfen solange es noch heiss ist, auch wenn das der eine Tropfen ist, der dem Fass die Krone ins Gesicht schlägt...

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

sehr merkwürdig: Got error 28 from storage engine 06 Mai 2013 01:36 #36792

Hi lieber Tribal


vielen Dank für deine Hilfe

Tribal6 schrieb:

.....fp.ordering, a.created DESC LIMIT 0, 3 Got error 28 from storage engine SQL=SELECT a.id, a.title, a.alias.....


lmgtfy.com/?q=Got+error+28+from+storage+engine

:woohoo:


danke cool!!


also wie das hier aufgeloest wird

forum.joomla.org/viewtopic.php?p=2241972

scheint es sich da um einen reltativ typ. DB-Fehler zu handeln:

Database Error: Unable to connect to the database:Could not connect to MySQL


Error code 28: No space left on device

This is normally caused because your /tmp folder is filled with sessions etc.
You might want/need to contact your ghost to clean that folder for you since you have no access.
They can btw if they want install on host/server level a cronjob to take care of that issue permanently



vgl

forum.joomla.org/viewtopic.php?f=470&t=8...8&p=3028623#p3028623


I had this same issue, was getting odd SQL errors, and eventually got to
the Joomla error "DB function failed with error number 1030."
When you see the mySQL error "Got error 28 from storage engine SQL..."
Error Code 28 is definitely "No Space Left on Device"

I busted into the server room and we had 5.2 KB left on disk. Heh.
Time to delete useless files!
So, lotsa useless logs and other non-essential progs got deleted that day.

Restarted and... problem solved.


werde mit meinem Server-Admin reden

er hat neulich schonmal gesagt, dass da noch etwas zu machen ist - dass die DB voll ist!


Wir müssten da mal ggf. neue SERVERHARDWARE investieren..


dir nochmals vielen Dank
vg gib

Bitte Anmelden oder Registrieren um der Konversation beizutreten.

  • Seite:
  • 1