Got error 28 from storage engine_MySQLÊý¾Ý¿â_ºÚ¿Í·ÀÏßÍø°²·þÎñÆ÷ά»¤»ùµØ--Powered by WWW.RONGSEN.COM.CN

Got error 28 from storage engine

×÷ÕߣººÚ¿Í·ÀÏßÍø°²MYSQLά»¤»ùµØ À´Ô´£ººÚ¿Í·ÀÏßÍø°²MYSQLά»¤»ùµØ ä¯ÀÀ´ÎÊý£º0

±¾Æª¹Ø¼ü´Ê£º error´íÎó´úÂë
ºÚ¿Í·ÀÏßÍø°²ÍøѶ£º½ñÌ쿪ÁËÐéÄâ»ú£¬´´½¨ÁËÒ»¸ö´¥·¢Æ÷£¬¿ÉÒԳɹ¦£¬²»¹ýshow triggers µÄʱºò±¨Ò»Ï´íÎó£ºGot error 28 from storage engineÒÔÏÂÊÇÏêϸ´íÎó´úÂë¡£mysql> show triggers;ERROR 1030 (HY000): Got...

½ñÌ쿪ÁËÐéÄâ»ú£¬´´½¨ÁËÒ»¸ö´¥·¢Æ÷£¬¿ÉÒԳɹ¦£¬²»¹ýshow triggers µÄʱºò±¨Ò»Ï´íÎó£º

Got error 28 from storage engine
ÒÔÏÂÊÇÏêϸ´íÎó´úÂë¡£
mysql> show triggers;
ERROR 1030 (HY000): Got error 28 from storage engine
mysql> show errors;
+-------+------+--------------------------------------------------------+
| Level | Code | Message                                                |
+-------+------+--------------------------------------------------------+
| Error | 1030 | Got error 28 from storage engine                       |
| Error |    6 | Error on delete of '/tmp/#sql_1515_0.MYI' (Errcode: 2) |
+-------+------+--------------------------------------------------------+
2 rows in set (0.00 sec)

½â¾ö˼·£º
1. ¿´ÁËϾßÌå´íÎó´úÂë
mysql> \! perror 6
OS error code   6:  No such device or address
ÄǾÍÊÇ/tmp/#sql_1515_0.MYIÕâ¸öÎļþûÓУ¿ Õâ¸öÎļþÊÇÁÙʱÉú³ÉµÄ£¬±¾À´¾ÍÓ¦¸ÃûÓа¡£¡
ÄǾÍÊÇ´´½¨µÄʱºò³ö´íÁË£¿
2. ²é¿´ÁËÏ´ÅÅ̿ռ䣬ԭÀ´ÎҵĵÚÒ»¿éÐéÄâÅÌÂúÁË£¬¶øÎҵĵڶþ¿éÅÌÉÏ´æ·ÅMySQLÊý¾Ý£¬ËùÓÐÓпռä×ã¹»£¡
[root@ytt david.yang]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1             4.9G  4.9G     0 100% /
tmpfs                 252M     0  252M   0% /dev/shm
/dev/sdb1             9.9G  2.8G  6.6G  30% /opt/sdb

ɾ³ýÁËһЩÎļþ¡£
[root@ytt david.yang]# df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/sda1             4.9G  3.5G  1.1G  77% /
tmpfs                 252M     0  252M   0% /dev/shm
/dev/sdb1             9.9G  2.8G  6.6G  30% /opt/sdb

Õâ¸öʱºòOKÁË¡£
ССBSÏÂ: ´íÎó´úÂë²»¹»Ã÷È·£¡

    ºÚ¿Í·ÀÏßÍø°²·þÎñÆ÷ά»¤·½°¸±¾ÆªÁ¬½Ó£ºhttp://www.rongsen.com.cn/show-8422-1.html
Íøվά»¤½Ì³Ì¸üÐÂʱ¼ä:2012-03-20 04:55:43  ¡¾´òÓ¡´ËÒ³¡¿  ¡¾¹Ø±Õ¡¿
ÎÒÒªÉêÇë±¾Õ¾£ºNµã | ºÚ¿Í·ÀÏß¹ÙÍø |  
רҵ·þÎñÆ÷ά»¤¼°Íøվά»¤ÊÖ¹¤°²È«´î½¨»·¾³£¬ÍøÕ¾°²È«¼Ó¹Ì·þÎñ¡£ºÚ¿Í·ÀÏßÍø°²·þÎñÆ÷ά»¤»ùµØÕÐÉ̽øÐÐÖУ¡QQ:29769479

footer  footer  footer  footer