Seems I had corrupted database again. Most likely because I continue to use beta releases of MacOS and have to keep updating Homebrew to keep up. But maybe not…<\/p>\n\n\n\n
This time, even with recovery from timemachine backup, I still had trouble with the Aria plugin engine. It had a corruped log file that I couldn’t seem to lick.<\/p>\n\n\n\n
Finally found a reference to a routine to run on all my MIA files – <\/p>\n\n\n\n
aria_chk -r *.MIA<\/pre>\n\n\n\nWhen followed with deletion of all the aria_log.xxx files, this seems to resolve all the remaining issues with the tables. All of this predicated with…<\/p>\n\n\n\n
brew services stop mariadb<\/pre>\n\n\n\nWatching the log file (Mac-Pro.lan.err) found the errors and all clean now…<\/p>\n\n\n\n
2020-04-05 7:47:50 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins\n2020-04-05 7:47:50 0 [Note] InnoDB: Uses event mutexes\n2020-04-05 7:47:50 0 [Note] InnoDB: Compressed tables use zlib 1.2.11\n2020-04-05 7:47:50 0 [Note] InnoDB: Number of pools: 1\n2020-04-05 7:47:50 0 [Note] InnoDB: Using SSE2 crc32 instructions\n2020-04-05 7:47:50 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M\n2020-04-05 7:47:50 0 [Note] InnoDB: Completed initialization of buffer pool\n2020-04-05 7:47:50 0 [Note] InnoDB: 128 out of 128 rollback segments are active.\n2020-04-05 7:47:50 0 [Note] InnoDB: Creating shared tablespace for temporary tables\n2020-04-05 7:47:50 0 [Note] InnoDB: Setting file '.\/ibtmp1' size to 12 MB. Physically writing the file full; Please wait \u2026\n2020-04-05 7:47:50 0 [Note] InnoDB: File '.\/ibtmp1' size is now 12 MB.\n2020-04-05 7:47:50 0 [Note] InnoDB: Waiting for purge to start\n2020-04-05 7:47:50 0 [Note] InnoDB: 10.4.11 started; log sequence number 1383411434; transaction id 1238187\n2020-04-05 7:47:50 0 [Note] InnoDB: Loading buffer pool(s) from \/usr\/local\/var\/mysql\/ib_buffer_pool\n2020-04-05 7:47:50 0 [Note] Plugin 'FEEDBACK' is disabled.\n2020-04-05 7:47:50 0 [Note] InnoDB: Buffer pool(s) load completed at 200405 7:47:50\n2020-04-05 7:47:50 0 [Note] Server socket created on IP: '::'.\n2020-04-05 7:47:51 0 [Note] Reading of all Master_info entries succeeded\n2020-04-05 7:47:51 0 [Note] Added new Master_info '' to hash table\n2020-04-05 7:47:51 0 [Note] \/usr\/local\/opt\/mariadb\/bin\/mysqld: ready for connections.\nVersion: '10.4.11-MariaDB' socket: '\/tmp\/mysql.sock' port: 3306 Homebrew<\/pre>\n\n\n\nAll golden!<\/p>\n","protected":false},"excerpt":{"rendered":"
Seems I had corrupted database again. Most likely because I continue to use beta releases of MacOS and have to keep updating Homebrew to keep up. But maybe not… This time, even with recovery from timemachine backup, I still had trouble with the Aria plugin engine. It had a corruped log file that I couldn’t … Continue reading Yet another issue with mysql<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-174","post","type-post","status-publish","format-standard","hentry","category-techproj"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p81R5K-2O","jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/zimplicity.hopto.org\/index.php?rest_route=\/wp\/v2\/posts\/174","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zimplicity.hopto.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zimplicity.hopto.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zimplicity.hopto.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zimplicity.hopto.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=174"}],"version-history":[{"count":0,"href":"https:\/\/zimplicity.hopto.org\/index.php?rest_route=\/wp\/v2\/posts\/174\/revisions"}],"wp:attachment":[{"href":"https:\/\/zimplicity.hopto.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=174"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zimplicity.hopto.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=174"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zimplicity.hopto.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=174"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}