{"id":380,"date":"2013-05-22T09:53:19","date_gmt":"2013-05-22T09:53:19","guid":{"rendered":"https:\/\/shan.info\/new\/error-usr-libexec-mysqld-can-t-open-file-s-frm-errno-24\/"},"modified":"2013-05-22T09:53:19","modified_gmt":"2013-05-22T09:53:19","slug":"error-usr-libexec-mysqld-can-t-open-file-s-frm-errno-24","status":"publish","type":"post","link":"https:\/\/shan.info\/new\/error-usr-libexec-mysqld-can-t-open-file-s-frm-errno-24\/","title":{"rendered":"[ERROR] \/usr\/libexec\/mysqld: Can&#8217;t open file: &#8216;.s.frm&#8217; (errno: 24)"},"content":{"rendered":"<p>\u00a0<\/p>\n<p>130522 \u00a01:45:20 [ERROR] \/usr\/libexec\/mysqld: Can&#8217;t open file: &#8216;.\/alamise\/alamise_categories.frm&#8217; (errno: 24)<\/p>\n<p>\u00a0&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/p>\n<p>ps -ef|grep mysql<\/p>\n<p>\u67e5\u770b pid<\/p>\n<p>pid 32150<\/p>\n<p>\u00a0&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;<\/p>\n<p>cat \/proc\/32150\/limits |grep files<\/p>\n<p>\u67e5\u770bpid\u6700\u5927limite<\/p>\n<p>\u00a0&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<\/p>\n<p>lsof -p 32150 |wc -l<\/p>\n<p>\u67e5\u770b\u5df2\u7ecf\u6253\u5f00\u7684\u6570\u91cf<\/p>\n<p>\u00a0<\/p>\n<p>lsof | grep mysqld<\/p>\n<p>\u67e5\u770b\u5217\u8868<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211;<\/p>\n<p>\u67e5\u770b mysql\u503c<\/p>\n<p>mysql -uUser -pPASS<\/p>\n<p>show global variables like &#8220;%open_files_limit%&#8221;;<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<\/p>\n<p>\u4fee\u590d\u8868<\/p>\n<p>mysqlcheck -A -o -r -p<\/p>\n<p>password<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<\/p>\n<p>\u66f4\u6539<\/p>\n<p>\u00a0<\/p>\n<p>\/etc\/my.cnf<\/p>\n<p>[mysqld]<\/p>\n<p>open_files_limit = 100000<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u00a0 130522 \u00a01:45:20 [ERROR] \/usr\/libexec\/mysqld: Can&#8217;t open file: &#8216;.\/alamise\/alamise_categories.frm&#8217; (errno: 24) \u00a0&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; ps -ef|grep mysql \u67e5\u770b pid pid 32150 \u00a0&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; cat \/proc\/32150\/limits |grep files \u67e5\u770bpid\u6700\u5927limite \u00a0&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- lsof -p 32150 |wc -l \u67e5\u770b\u5df2\u7ecf\u6253\u5f00\u7684\u6570\u91cf \u00a0 lsof | grep mysqld \u67e5\u770b\u5217\u8868 &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8211; \u67e5\u770b mysql\u503c mysql -uUser -pPASS show global variables like &#8220;%open_files_limit%&#8221;; &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;- \u4fee\u590d\u8868 mysqlcheck -A -o -r [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[46],"tags":[],"class_list":["post-380","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/posts\/380","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/comments?post=380"}],"version-history":[{"count":0,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/posts\/380\/revisions"}],"wp:attachment":[{"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/media?parent=380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/categories?post=380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/shan.info\/new\/wp-json\/wp\/v2\/tags?post=380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}