{"id":5386,"date":"2023-08-04T09:47:09","date_gmt":"2023-08-04T00:47:09","guid":{"rendered":"https:\/\/higherhope.net\/?p=5386"},"modified":"2024-04-10T21:02:50","modified_gmt":"2024-04-10T12:02:50","slug":"mariadb%e3%81%a7error-incorrect-definition-of-table-mysql-column_stats-expected-column%ef%bd%9e%e3%81%8c%e5%87%ba%e3%81%a6%e3%81%9f%e3%81%ae%e3%81%a7%e5%af%be%e5%bf%9c%e3%81%97%e3%81%9f%e3%80%82","status":"publish","type":"post","link":"https:\/\/higherhope.net\/?p=5386","title":{"rendered":"mariadb\u3067[ERROR] Incorrect definition of table mysql.column_stats: expected column\uff5e\u304c\u51fa\u3066\u305f\u306e\u3067\u5bfe\u5fdc\u3057\u305f\u3002"},"content":{"rendered":"

\u5148\u65e5\u884c\u3063\u305fmariadb\u306eupgrade<\/a>\u5f8c\u306b\u30ed\u30b0\u3092\u898b\u305f\u3089\u3053\u306e\u3088\u3046\u306a\u30ed\u30b0\u304c\u3064\u3089\u3064\u3089\u3068\u30fb\u30fb\u30fb<\/p>\n

Jul 30 04:21:05 hoge mariadbd[2163]: 2023-07-30 4:21:05 29113 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').
\nJul 30 04:21:05 hoge mariadbd[2163]: 2023-07-30 4:21:05 29113 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).
\nJul 30 04:21:05 hoge mariadbd[2163]: 2023-07-30 4:21:05 29113 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').
\nJul 30 04:21:05 hoge mariadbd[2163]: 2023-07-30 4:21:05 29113 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).<\/code><\/p>\n

mariadb\u306eupgrade\u5f8c\u306bmariadb-upgrade\u30b3\u30de\u30f3\u30c9\u3067\u30c7\u30fc\u30bf\u30fc\u30d9\u30fc\u30b9\u306e\u30a2\u30c3\u30d7\u30b0\u30ec\u30fc\u30c9\u306e\u5b9f\u884c\u3092\u884c\u3063\u3066\u3044\u306a\u304b\u3063\u305f\u306e\u3067\u51fa\u3066\u307e\u3057\u305f\u3002<\/p>\n

\u306a\u306e\u3067\u3001mariadb-upgrade\u3092\u5b9f\u884c
\n# mariadb-upgrade -u root -p
\nEnter password:
\nPhase 1\/7: Checking and upgrading mysql database
\nProcessing databases
\nmysql
\nmysql.column_stats OK
\nmysql.columns_priv OK
\nmysql.db OK
\nmysql.event OK
\nmysql.func OK
\nmysql.global_priv OK
\nmysql.gtid_slave_pos OK
\nmysql.help_category OK
\nmysql.help_keyword OK
\nmysql.help_relation OK
\nmysql.help_topic OK
\nmysql.index_stats OK
\nmysql.innodb_index_stats OK
\n\u7565
\nsys
\nsys.sys_config OK
\nPhase 7\/7: Running 'FLUSH PRIVILEGES'
\nOK<\/code><\/p>\n

\u5b9f\u884c\u5f8c\u30a8\u30e9\u30fc\u306f\u8868\u793a\u3055\u308c\u306a\u304f\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u5148\u65e5\u884c\u3063\u305fmariadb\u306eupgrade\u5f8c\u306b\u30ed\u30b0\u3092\u898b\u305f\u3089\u3053\u306e\u3088\u3046\u306a\u30ed\u30b0\u304c\u3064\u3089\u3064\u3089\u3068\u30fb\u30fb\u30fb Jul 30 04:21:05 hoge mariadbd[2163]: 2023-07-30 4:21:05 29113 [ER… Continue reading → <\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[159],"tags":[70],"class_list":["post-5386","post","type-post","status-publish","format-standard","hentry","category-mysql-mariadb","tag-mariadb"],"yoast_head":"\nmariadb\u3067[ERROR] Incorrect definition of table mysql.column_stats: expected column\uff5e\u304c\u51fa\u3066\u305f\u306e\u3067\u5bfe\u5fdc\u3057\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/higherhope.net\/?p=5386\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"mariadb\u3067[ERROR] Incorrect definition of table mysql.column_stats: expected column\uff5e\u304c\u51fa\u3066\u305f\u306e\u3067\u5bfe\u5fdc\u3057\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\" \/>\n<meta property=\"og:description\" content=\"\u5148\u65e5\u884c\u3063\u305fmariadb\u306eupgrade\u5f8c\u306b\u30ed\u30b0\u3092\u898b\u305f\u3089\u3053\u306e\u3088\u3046\u306a\u30ed\u30b0\u304c\u3064\u3089\u3064\u3089\u3068\u30fb\u30fb\u30fb Jul 30 04:21:05 hoge mariadbd[2163]: 2023-07-30 4:21:05 29113 [ER... Continue reading →\" \/>\n<meta property=\"og:url\" content=\"https:\/\/higherhope.net\/?p=5386\" \/>\n<meta property=\"og:site_name\" content=\"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-04T00:47:09+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-10T12:02:50+00:00\" \/>\n<meta name=\"author\" content=\"higherhope\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@higherhope5963\" \/>\n<meta name=\"twitter:site\" content=\"@higherhope5963\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"higherhope\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/higherhope.net\/?p=5386#article\",\"isPartOf\":{\"@id\":\"https:\/\/higherhope.net\/?p=5386\"},\"author\":{\"name\":\"higherhope\",\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\"},\"headline\":\"mariadb\u3067[ERROR] Incorrect definition of table mysql.column_stats: expected column\uff5e\u304c\u51fa\u3066\u305f\u306e\u3067\u5bfe\u5fdc\u3057\u305f\u3002\",\"datePublished\":\"2023-08-04T00:47:09+00:00\",\"dateModified\":\"2024-04-10T12:02:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/higherhope.net\/?p=5386\"},\"wordCount\":17,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\"},\"keywords\":[\"mariadb\"],\"articleSection\":[\"mysql,mariadb\"],\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/higherhope.net\/?p=5386#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/higherhope.net\/?p=5386\",\"url\":\"https:\/\/higherhope.net\/?p=5386\",\"name\":\"mariadb\u3067[ERROR] Incorrect definition of table mysql.column_stats: expected column\uff5e\u304c\u51fa\u3066\u305f\u306e\u3067\u5bfe\u5fdc\u3057\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\",\"isPartOf\":{\"@id\":\"https:\/\/higherhope.net\/#website\"},\"datePublished\":\"2023-08-04T00:47:09+00:00\",\"dateModified\":\"2024-04-10T12:02:50+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/higherhope.net\/?p=5386#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/higherhope.net\/?p=5386\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/higherhope.net\/?p=5386#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\/\/higherhope.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"mariadb\u3067[ERROR] Incorrect definition of table mysql.column_stats: expected column\uff5e\u304c\u51fa\u3066\u305f\u306e\u3067\u5bfe\u5fdc\u3057\u305f\u3002\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/higherhope.net\/#website\",\"url\":\"https:\/\/higherhope.net\/\",\"name\":\"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002\",\"description\":\"\u304a\u3063\u3055\u3093\u307e\u3060\u307e\u3060\u697d\u3067\u304d\u307e\u305b\u3093\u3002\",\"publisher\":{\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/higherhope.net\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af\",\"name\":\"higherhope\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg\",\"contentUrl\":\"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg\",\"width\":700,\"height\":394,\"caption\":\"higherhope\"},\"logo\":{\"@id\":\"https:\/\/higherhope.net\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/x.com\/higherhope5963\"],\"url\":\"https:\/\/higherhope.net\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"mariadb\u3067[ERROR] Incorrect definition of table mysql.column_stats: expected column\uff5e\u304c\u51fa\u3066\u305f\u306e\u3067\u5bfe\u5fdc\u3057\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/higherhope.net\/?p=5386","og_locale":"ja_JP","og_type":"article","og_title":"mariadb\u3067[ERROR] Incorrect definition of table mysql.column_stats: expected column\uff5e\u304c\u51fa\u3066\u305f\u306e\u3067\u5bfe\u5fdc\u3057\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","og_description":"\u5148\u65e5\u884c\u3063\u305fmariadb\u306eupgrade\u5f8c\u306b\u30ed\u30b0\u3092\u898b\u305f\u3089\u3053\u306e\u3088\u3046\u306a\u30ed\u30b0\u304c\u3064\u3089\u3064\u3089\u3068\u30fb\u30fb\u30fb Jul 30 04:21:05 hoge mariadbd[2163]: 2023-07-30 4:21:05 29113 [ER... Continue reading →","og_url":"https:\/\/higherhope.net\/?p=5386","og_site_name":"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","article_published_time":"2023-08-04T00:47:09+00:00","article_modified_time":"2024-04-10T12:02:50+00:00","author":"higherhope","twitter_card":"summary_large_image","twitter_creator":"@higherhope5963","twitter_site":"@higherhope5963","twitter_misc":{"\u57f7\u7b46\u8005":"higherhope","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"1\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/higherhope.net\/?p=5386#article","isPartOf":{"@id":"https:\/\/higherhope.net\/?p=5386"},"author":{"name":"higherhope","@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af"},"headline":"mariadb\u3067[ERROR] Incorrect definition of table mysql.column_stats: expected column\uff5e\u304c\u51fa\u3066\u305f\u306e\u3067\u5bfe\u5fdc\u3057\u305f\u3002","datePublished":"2023-08-04T00:47:09+00:00","dateModified":"2024-04-10T12:02:50+00:00","mainEntityOfPage":{"@id":"https:\/\/higherhope.net\/?p=5386"},"wordCount":17,"commentCount":0,"publisher":{"@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af"},"keywords":["mariadb"],"articleSection":["mysql,mariadb"],"inLanguage":"ja","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/higherhope.net\/?p=5386#respond"]}]},{"@type":"WebPage","@id":"https:\/\/higherhope.net\/?p=5386","url":"https:\/\/higherhope.net\/?p=5386","name":"mariadb\u3067[ERROR] Incorrect definition of table mysql.column_stats: expected column\uff5e\u304c\u51fa\u3066\u305f\u306e\u3067\u5bfe\u5fdc\u3057\u305f\u3002 - \u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","isPartOf":{"@id":"https:\/\/higherhope.net\/#website"},"datePublished":"2023-08-04T00:47:09+00:00","dateModified":"2024-04-10T12:02:50+00:00","breadcrumb":{"@id":"https:\/\/higherhope.net\/?p=5386#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/higherhope.net\/?p=5386"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/higherhope.net\/?p=5386#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/higherhope.net\/"},{"@type":"ListItem","position":2,"name":"mariadb\u3067[ERROR] Incorrect definition of table mysql.column_stats: expected column\uff5e\u304c\u51fa\u3066\u305f\u306e\u3067\u5bfe\u5fdc\u3057\u305f\u3002"}]},{"@type":"WebSite","@id":"https:\/\/higherhope.net\/#website","url":"https:\/\/higherhope.net\/","name":"\u697d\u306b\u3057\u3066\u304f\u3060\u3055\u3044\u3002","description":"\u304a\u3063\u3055\u3093\u307e\u3060\u307e\u3060\u697d\u3067\u304d\u307e\u305b\u3093\u3002","publisher":{"@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/higherhope.net\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":["Person","Organization"],"@id":"https:\/\/higherhope.net\/#\/schema\/person\/d8206977903d5a243c56f95f977122af","name":"higherhope","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/higherhope.net\/#\/schema\/person\/image\/","url":"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg","contentUrl":"https:\/\/higherhope.net\/wp-content\/uploads\/2018\/09\/DSC_0367.jpg","width":700,"height":394,"caption":"higherhope"},"logo":{"@id":"https:\/\/higherhope.net\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/x.com\/higherhope5963"],"url":"https:\/\/higherhope.net\/?author=1"}]}},"_links":{"self":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts\/5386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5386"}],"version-history":[{"count":4,"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts\/5386\/revisions"}],"predecessor-version":[{"id":5564,"href":"https:\/\/higherhope.net\/index.php?rest_route=\/wp\/v2\/posts\/5386\/revisions\/5564"}],"wp:attachment":[{"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5386"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/higherhope.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}