{"id":1312,"date":"2023-09-06T17:31:36","date_gmt":"2023-09-06T09:31:36","guid":{"rendered":"https:\/\/www.shuran.cn\/?p=1312"},"modified":"2023-09-06T17:31:36","modified_gmt":"2023-09-06T09:31:36","slug":"%e8%ae%b0%e5%bd%95%e6%95%b0%e6%8d%ae%e5%ba%93%e6%97%a0%e6%b3%95%e5%90%af%e5%8a%a8mariadbd-cant-lock-aria-control-file","status":"publish","type":"post","link":"https:\/\/www.shuran.cn\/?p=1312","title":{"rendered":"\u8bb0\u5f55\u6570\u636e\u5e93\u65e0\u6cd5\u542f\u52a8mariadbd: Can't lock aria control file"},"content":{"rendered":"\n<p>BT\u9762\u677f\uff0c\u88c5\u4e86mariadbd10.7\u7248\u672c\uff0c\u7ecf\u67e5\u65e0\u6cd5\u542f\u52a8<br \/>\u65e5\u5fd7\u5982\u4e0b\uff1a<\/p>\n\n\n\n<p>[ERROR] InnoDB: Missing FILE_CHECKPOINT at 74151423635 between the checkpoint 74151423635 and the end 74152982204.<br \/>[ERROR] InnoDB: Plugin initialization aborted with error Generic error<\/p>\n\n\n\n<p>\u6d4b\u8bd5\u6709\u6548\u7684\u65b9\u6848\u5982\u4e0b\uff1a<\/p>\n\n\n\n<p>\u914d\u7f6e\u4e2d\u589e\u52a0 <strong><mark>innodb_force_recovery = <\/mark><\/strong>6  \u8fdb\u884c\u53ea\u8bfb\u542f\u52a8<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;mysqld]\nport\t\t= 3306\nsocket\t\t= \/tmp\/mysql.sock\ndatadir = \/www\/server\/data\ndefault_storage_engine = InnoDB\nperformance_schema_max_table_instances = 400\ntable_definition_cache = 400\nskip-external-locking\nkey_buffer_size = 64M\nmax_allowed_packet = 100G\ntable_open_cache = 256\nsort_buffer_size = 1M\nnet_buffer_length = 4K\nread_buffer_size = 1M\nread_rnd_buffer_size = 256K\nmyisam_sort_buffer_size = 16M\nthread_cache_size = 32\nquery_cache_size = 32M\ntmp_table_size = 64M\nsql-mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES\n<strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">innodb_force_recovery = <\/mark><\/strong>6<\/code><\/pre>\n\n\n\n<p>\u542f\u52a8\u540e\uff0c\u5907\u4efd\u6570\u636e\u5e93\uff0c\u7136\u540e\u5220\u9664\u6240\u6709\u6570\u636e\u5e93\u3002\uff08\u6682\u65f6\u672a\u6d4b\u8bd5\u5176\u5b83\u65b9\u6cd5\uff09<\/p>\n\n\n\n<p>\u7136\u540e\u5173\u95ed\u6570\u636e\u5e93\uff0c\u5220\u9664\u5982\u4e0b\u6587\u4ef6<br \/>cd \/www\/server\/data<br \/>rm -f aria_log.00000001 aria_log_control ib_logfile0<\/p>\n\n\n\n<p><strong><mark style=\"background-color:rgba(0, 0, 0, 0)\" class=\"has-inline-color has-luminous-vivid-orange-color\">\u5c06\u6570\u636e\u5e93\u914d\u7f6e\u6587\u4ef6\u8fd8\u539f\uff0c\u6216\u8005\u6539\u4e3ainnodb_force_recovery = <\/mark><\/strong>1<\/p>\n\n\n\n<p>\u542f\u52a8mariadbd \uff0c\u6062\u590d\u6570\u636e<\/p>\n","protected":false},"excerpt":{"rendered":"<p>BT\u9762\u677f\uff0c\u88c5\u4e86mariadbd10.7\u7248\u672c\uff0c\u7ecf\u67e5\u65e0\u6cd5\u542f\u52a8\u65e5\u5fd7\u5982\u4e0b\uff1a [ERROR] InnoDB: Missi\u2026 <span class=\"read-more\"><a href=\"https:\/\/www.shuran.cn\/?p=1312\">Read More &raquo;<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-1312","post","type-post","status-publish","format-standard","hentry","category-os"],"_links":{"self":[{"href":"https:\/\/www.shuran.cn\/index.php?rest_route=\/wp\/v2\/posts\/1312","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.shuran.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.shuran.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.shuran.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.shuran.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1312"}],"version-history":[{"count":1,"href":"https:\/\/www.shuran.cn\/index.php?rest_route=\/wp\/v2\/posts\/1312\/revisions"}],"predecessor-version":[{"id":1313,"href":"https:\/\/www.shuran.cn\/index.php?rest_route=\/wp\/v2\/posts\/1312\/revisions\/1313"}],"wp:attachment":[{"href":"https:\/\/www.shuran.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1312"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.shuran.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1312"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.shuran.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1312"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}