{"id":1955,"date":"2023-04-25T09:54:22","date_gmt":"2023-04-25T01:54:22","guid":{"rendered":"http:\/\/175.24.184.226\/?p=1955"},"modified":"2023-04-25T09:55:18","modified_gmt":"2023-04-25T01:55:18","slug":"%e5%bd%bb%e5%ba%95%e8%a7%a3%e5%86%b3mysql%e6%8a%a5%e9%94%991030-got-error-28-from-storage-engine","status":"publish","type":"post","link":"\/?p=1955","title":{"rendered":"\u5f7b\u5e95\u89e3\u51b3mysql\u62a5\u9519:1030, \u2018Got error 28 from storage engine\u2018"},"content":{"rendered":"

\u4e00\u3001\u524d\u8a00<\/h2>\n

\u6700\u8fd1\u542c\u7c89\u4e1d\u8bf4\uff0c\u670d\u52a1\u5668\u7cfb\u7edf\u76d8\u6ee1\u4e86\uff0c\u5982\u4f55\u89e3\u51b3\uff0c\u6211\u8bf4\u8fd9\u4e2a\u5e94\u8be5\u7f51\u4e0a\u80fd\u627e\u5230\u89e3\u51b3\u65b9\u6848\u7684\uff0c\u4ed6\u4eec\u8bf4\u7f51\u4e0a\u5f88\u591a\u4eba\u90fd\u8bf4\u6e05\u4e00\u4e0b\u7f13\u5b58\uff0c\u4f46\u662f\u5e76\u6ca1\u6709\u6559\u5b9e\u9645\u64cd\u4f5c\uff0c\u8fd9\u8ba9\u6211\u4eec\u8fd9\u4e9b\u5c0f\u767d\u5c31\u5f88\u96be\u53d7\u3002<\/p>\n

\u5728\u6b64\uff0c\u6211\u7279\u610f\u53bb\u7f51\u4e0a\u770b\u4e86\u770b\uff0c\u53d1\u73b0\u7f51\u4e0a\u6587\u7ae0\u5343\u7bc7\u4e00\u5f8b\u51e0\u4e4e\u6ca1\u6709\u6559\u5b9e\u9645\u89e3\u51b3\u7684\uff0c\u5168\u662f\u8bf4\u6e05\u4e00\u4e0b\u7f13\u5b58\u5c31\u597d\u4e86\uff0c\u4f46\u662f\u90fd\u6ca1\u6709\u5b9e\u9645\u6b65\u9aa4\uff0c\u8fd9\u8ba9\u5c0f\u767d\u5f88\u61f5\u903c\u3002<\/p>\n

\u4e8c\u3001\u6b63\u6587<\/h2>\n

mysql\u62a5\u9519:1030, \u2018Got error 28 from storage engine\u2018\uff0c\u8fd9\u4e2a\u95ee\u9898\u786e\u5b9e\u662f\u670d\u52a1\u5668\u7cfb\u7edf\u76d8\u6ee1\u4e86,mysql\u6307\u5b9a\u7684\u4e34\u65f6\u6587\u4ef6\u76ee\u5f55\u6ee1\u6389,\u5927\u6982\u5c31\u662f\u8fd9\u4e2a\u610f\u601d.<\/p>\n

\u4e0b\u9762\u89e3\u51b3\/dev\/vda1\u7cfb\u7edf\u76d8\u6ee1\u4e86,\u5176\u5b9e\u6211\u538b\u6839\u4e0d\u77e5\u9053\/dev\/vda1\u8fd9\u5728\u54ea,\u662f\u4ec0\u4e48,\u540e\u6765\u4e86\u89e3\u8fd9\u662f virtio-block \u7c7b\u578b\u7684\u8bbe\u5907\u3002<\/p>\n

\u8fd9\u91cc\u79d1\u666e\u4e00\u4e0b\uff1a<\/strong><\/p>\n

\n

\u4ee5 'c' \u5f00\u5934\u7684\u4e00\u884c\u8868\u793a\u8be5\u8bbe\u5907\u662f\u4e00\u4e2a\u5b57\u7b26\u8bbe\u5907\uff0c\u4ee5 'b' \u5f00\u5934\u7684\u884c\u8868\u793a\u8fd9\u662f\u4e00\u4e2a\u5757\u8bbe\u5907\u3002
\n\/dev\/vda \u548c \/dev\/vdb \u90fd\u662f virtio-block \u7c7b\u578b\u7684\u8bbe\u5907\uff0c\u800c \/dev\/sda \u662f sd \u5373 SCSI \u7c7b\u578b\u7684\u8bbe\u5907\u3002<\/p>\n<\/blockquote>\n

\u5f00\u6574\uff01<\/h3>\n

\u9996\u5148\u767b\u5f55\u670d\u52a1\u5668:\u6267\u884cdf -h<\/strong> \u610f\u601d\u662f:<\/p>\n

\u68c0\u67e5\u4e00\u53f0\u670d\u52a1\u5668\u78c1\u76d8\u4f7f\u7528\u7a7a\u95f4\uff0c\u53d1\u73b0\u78c1\u76d8\u5df2\u7ecf\u4f7f\u7528\u4e86100%(\u8fd9\u662f\u6211\u89e3\u51b3\u4e4b\u540e\u622a\u7684\u56fe,\u5df2\u7ecf\u6062\u590d\u6b63\u5e38,\u5269\u4f5942%\u8db3\u591f\u4e86)<\/p>\n

\"\"<\/p>\n

1\u3001cd\u5230 \u6839\u76ee\u5f55,du -sh * \u770b\u54ea\u4e2a\u76ee\u5f55\u5360\u7528\u7a7a\u95f4\u5927,\u6709\u7684\u9ad8\u8fbe\u5341\u51e0\u4e2aG,\u90a3\u4e48\u5c31\u8981\u76ef\u4f4f\u8fd9\u4e2a\u76ee\u5f55\u4e86<\/strong><\/h3>\n

\"\"<\/p>\n

2\u3001cd \u5360\u5185\u5b58\u5927\u7684\u76ee\u5f55,\u7ee7\u7eed du -sh *<\/strong><\/h3>\n

\u53d1\u73b0data\u76ee\u5f55\u5c45\u713615G,\u8fdb\u5165data\u76ee\u5f55\uff1acd data<\/p>\n

\u7136\u540e\u67e5\u627e\u5927\u6587\u4ef6\uff1a<\/p>\n

\"\"<\/p>\n

\u6587\u4ef6\u67e5\u627e\u547d\u4ee4\uff1a<\/strong><\/p>\n

find -size +100M<\/code>
\n\u610f\u601d\u662f\u67e5\u627e\u5927\u4e8e100M\u7684\u6587\u4ef6\uff0cM\u662f\u5146\uff0c\u518d\u5927\u70b9\u53ef\u4ee5\u7528G`<\/p>\n

\u4e5f\u53ef\u4ee5\u67e5\u8be2\u6587\u4ef6\u5939\u5360\u7528\u663e\u793a\u8be5\u76ee\u5f55\u5360\u7528\u7a7a\u95f4\u7684\u603b\u548c\uff1a<\/strong><\/p>\n

\u4f7f\u7528\uff1adu -h --max-depth=1 \/\u8def\u5f84  \n\u4e3e\u4f8b\uff1adu -h --max-depth=1 \/var  \n\u8fd9\u662f\u67e5\u770b\u54ea\u4e2a\u6587\u4ef6\u5939\u5360\u76ee\u5f55\u5185\u5b58\u6700\u5927<\/code><\/pre>\n
\u5982\u679c\u60f3\u5b9a\u4f4d\u5927\u6587\u4ef6\uff1a<\/p>\n
ls -lhS  \n\u8fd9\u662f\u5c06\u6587\u4ef6\u4ece\u5927\u5230\u5c0f\u5c55\u73b0<\/code><\/pre>\n
3\u3001\u91cd\u590d\u524d\u4e24\u6b65\uff0c\u6839\u636e\u5b9e\u9645\u60c5\u51b5\u5224\u65ad\u5220\u9664\u6216\u8005\u79fb\u8d70<\/h3>\n
4\u3001\u5982\u679c\u65e5\u5fd7\u592a\u5927\u7684\u8bdd\u53ef\u4ee5\u6e05\u7a7a<\/h3>\n
\u8fd0\u884c\u547d\u4ee4\uff1a  \ncat \/dev\/null > file.log<\/code><\/pre>\n
\u4eb2\u6d4b\uff0cmysql\u6587\u4ef6\u5939\u4e0b\u7684catalina.out\u662f\u53ef\u4ee5\u5220\u9664\u7684\uff0c\u6267\u884c\uff1a<\/strong><\/p>\n
echo "" > catalina.out<\/code><\/pre>\n
\u4e00\u822c\u8fd9\u4e2a\u65e5\u5fd7\u6587\u4ef6\u6bd4\u8f83\u5927.<\/p>\n
5\u3001\u5982\u679c\u662f\u8f6f\u4ef6\u5305\u592a\u5927\u7684\u8bdd,\u4e0d\u9700\u8981\u7684\u53ef\u4ee5\u5378\u8f7d<\/h3>\n
\u6267\u884c\u5378\u8f7d<\/p>\n
\u6267\u884c\u5378\u8f7d<\/p>\n
rpm -e \u8f6f\u4ef6\u540d<\/code><\/p>\n
\u6216\u8005\u5220\u9664<\/p>\n
rm -rf \u6587\u4ef6\u5939\u540d<\/code><\/p>\n
6\u3001\u5927\u6587\u4ef6\u5220\u9664\u7684\u5dee\u4e0d\u591a\u4e86,\u518d\u6b21df -h,\u78c1\u76d8\u7a7a\u95f4\u9884\u7559\u4e00\u5c0f\u534a\u5373\u53ef,\u7edd\u5bf9\u5b8c\u7f8e\u89e3\u51b3mysql 1030 \u95ee\u9898!<\/strong><\/h3>\n
\u6700\u540e\u6e29\u99a8\u63d0\u793a\uff1a<\/strong>\u5c0f\u767d\u5982\u679c\u9047\u5230\u80fd\u529b\u4e4b\u5916\u7684\u95ee\u9898\uff0c\u800c\u4e14\u8fd9\u4e2a\u95ee\u9898\u8fd8\u6d89\u53ca\u5230\u670d\u52a1\u5668\u4e86\uff0c\u6700\u597d\u8ddf\u4f60\u7684\u9886\u5bfc\u6216\u8005\u5e26\u4f60\u7684\u4eba\u6c9f\u901a\u4e00\u4e0b\uff0c\u4e0d\u8981\u76f2\u76ee\u7684\u79c1\u4e0b\u64cd\u4f5c\uff0c\u51fa\u4e86\u95ee\u9898\u5c31\u9ebb\u70e6\u4e86\u3002<\/p>\n
\u672c\u6587\u8f6c\u81ea https:\/\/zhuanlan.zhihu.com\/p\/451141031<\/a>\uff0c\u5982\u6709\u4fb5\u6743\uff0c\u8bf7\u8054\u7cfb\u5220\u9664\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4e00\u3001\u524d\u8a00 \u6700\u8fd1\u542c\u7c89\u4e1d\u8bf4\uff0c\u670d\u52a1\u5668\u7cfb\u7edf\u76d8\u6ee1\u4e86\uff0c\u5982\u4f55\u89e3\u51b3\uff0c\u6211\u8bf4\u8fd9\u4e2a\u5e94\u8be5\u7f51\u4e0a\u80fd\u627e\u5230\u89e3\u51b3\u65b9\u6848\u7684\uff0c\u4ed6\u4eec\u8bf4\u7f51\u4e0a\u5f88\u591a\u4eba\u90fd\u8bf4\u6e05\u4e00\u4e0b\u7f13\u5b58\uff0c\u4f46\u662f\u5e76\u6ca1\u6709\u6559\u5b9e\u9645\u64cd   \u2026 …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0},"categories":[23],"tags":[24],"_links":{"self":[{"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1955"}],"collection":[{"href":"\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1955"}],"version-history":[{"count":2,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1955\/revisions"}],"predecessor-version":[{"id":1957,"href":"\/index.php?rest_route=\/wp\/v2\/posts\/1955\/revisions\/1957"}],"wp:attachment":[{"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1955"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1955"},{"taxonomy":"post_tag","embeddable":true,"href":"\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1955"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}