{"id":12920,"date":"2019-10-30T20:28:56","date_gmt":"2019-10-30T19:28:56","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\/"},"modified":"2019-10-30T20:28:56","modified_gmt":"2019-10-30T19:28:56","slug":"mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\/","title":{"rendered":"MariaDB 10.3.1x + 10.4.x : mysqld_multi not working properly"},"content":{"rendered":"<p>A couple of days ago, we upgraded some MariaDB instances on a consolidated database server. However, after the software update we were not able to manage our instances anymore using mysqld_multi whatever the MariaDB release (10.3.18 or the latest 10.4.x).<\/p>\n<p>Previously, everything worked fine with 10.3.14. So, what happened to our system?<br \/>\n<!--more&gt;--><br \/>\nLets&#8217; quickly start an instance:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">mysql@vmoel:\/u01\/app\/mysql\/product\/mariadb-10.3.18\/bin\/ [mysqld3] .\/mysqld_multi start 3\nelseif should be elsif at \/u01\/app\/mysql\/product\/mariadb-10.3.18\/bin\/mysqld_multi line 352.\nsyntax error at \/u01\/app\/mysql\/product\/mariadb-10.3.18\/bin\/mysqld_multi line 353, near \")\n      {\"\nsyntax error at \/u01\/app\/mysql\/product\/mariadb-10.3.18\/bin\/mysqld_multi line 356, near \"else\"\nsyntax error at \/u01\/app\/mysql\/product\/mariadb-10.3.18\/bin\/mysqld_multi line 404, near \"}\"\nIllegal declaration of subroutine main::stop_mysqlds at \/u01\/app\/mysql\/product\/mariadb-10.3.18\/bin\/mysqld_multi line 416.<\/pre>\n<p>Actually, the error message is quite simple to understand and to fix. We let you check &amp; fix the bug by yourself (hint : &#8220;elseif should be elsif&#8221;) \ud83d\ude0e<\/p>\n<p>That&#8217;s it for now but does your MariaDB instances start now? Hum, try it and check your error log like we did:<\/p>\n<pre class=\"brush: bash; gutter: true; first-line: 1\">2019-10-30 20:53:33 0 [Note] InnoDB: 10.3.18 started; log sequence number 1630952; transaction id 21\n2019-10-30 20:53:33 0 [Note] InnoDB: Loading buffer pool(s) from \/u02\/mysqldata\/mysqld3\/ib_buffer_pool\n2019-10-30 20:53:33 0 [Note] Plugin 'FEEDBACK' is disabled.\n2019-10-30 20:53:33 0 [ERROR] \/u01\/app\/mysql\/product\/mariadb-10.3.18\/bin\/mysqld: unknown variable 'defaults-group-suffix=mysqld3'\n2019-10-30 20:53:33 0 [ERROR] Aborting<\/pre>\n<p>Still not working ? Hum, now after some further analysis of the perl code especially the perl routine &#8220;start_mysqlds&#8221; we could identify the real problem.<\/p>\n<p>While, writing this article we found someone already reported that bug<a href=\"https:\/\/jira.mariadb.org\/browse\/MDEV-20728\"> MDEV-20728<\/a> !\u00a0 Thanks to him<\/p>\n<p>The fix is directly available on <a href=\"https:\/\/github.com\/MariaDB\/server\/commit\/748c97bc19b1e27e968a6eea684cc8930b634fa3\">the MariaDB GitHub repository<\/a><\/p>\n<p>Good luck \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A couple of days ago, we upgraded some MariaDB instances on a consolidated database server. However, after the software update we were not able to manage our instances anymore using mysqld_multi whatever the MariaDB release (10.3.18 or the latest 10.4.x). Previously, everything worked fine with 10.3.14. So, what happened to our system?<\/p>\n","protected":false},"author":25,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,1726],"tags":[1727,141,1728],"type_dbi":[],"class_list":["post-12920","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-mariadb","tag-elseif-should-be-elsif","tag-mariadb","tag-mysqld_multi"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>MariaDB 10.3.1x + 10.4.x : mysqld_multi not working properly - dbi Blog<\/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:\/\/www.dbi-services.com\/blog\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MariaDB 10.3.1x + 10.4.x : mysqld_multi not working properly\" \/>\n<meta property=\"og:description\" content=\"A couple of days ago, we upgraded some MariaDB instances on a consolidated database server. However, after the software update we were not able to manage our instances anymore using mysqld_multi whatever the MariaDB release (10.3.18 or the latest 10.4.x). Previously, everything worked fine with 10.3.14. So, what happened to our system?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2019-10-30T19:28:56+00:00\" \/>\n<meta name=\"author\" content=\"J\u00e9r\u00f4me Witt\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"J\u00e9r\u00f4me Witt\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\\\/\"},\"author\":{\"name\":\"J\u00e9r\u00f4me Witt\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/a2d3ecddaf732850101a39b9d62c31b7\"},\"headline\":\"MariaDB 10.3.1x + 10.4.x : mysqld_multi not working properly\",\"datePublished\":\"2019-10-30T19:28:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\\\/\"},\"wordCount\":168,\"commentCount\":0,\"keywords\":[\"elseif should be elsif\",\"MariaDB\",\"mysqld_multi\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"MariaDB\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\\\/\",\"name\":\"MariaDB 10.3.1x + 10.4.x : mysqld_multi not working properly - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"datePublished\":\"2019-10-30T19:28:56+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/a2d3ecddaf732850101a39b9d62c31b7\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MariaDB 10.3.1x + 10.4.x : mysqld_multi not working properly\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/a2d3ecddaf732850101a39b9d62c31b7\",\"name\":\"J\u00e9r\u00f4me Witt\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g\",\"caption\":\"J\u00e9r\u00f4me Witt\"},\"description\":\"J\u00e9rome Witt started his Consultant career a few years ago. He is specialized in database and infrastructure management, engineering, and optimization. He is very skilled in Oracle high availability, backup &amp; recovery, and tuning technologies. His expertise also includes the open source field (Linux\\\/Unix), advanced Perl, Shell, Windows PowerShell programming, and Automation tools (UC4). J\u00e9r\u00f4me Witt is Oracle Certified Professional 11g (OCP 11g), Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certified. Prior to joining dbi services, J\u00e9r\u00f4me Witt was Consultant at Trivadis in Basel. He also worked as a Junior Automation specialist at Selmoni AG in Basel. J\u00e9r\u00f4me Witt holds a BTS degree in Information Systems and Industrial Networks from France. His branch-related experience covers Pharma, Health Care, Banking &amp; Financial Services, Energy, Automotive etc.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/jerome-witt\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MariaDB 10.3.1x + 10.4.x : mysqld_multi not working properly - dbi Blog","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:\/\/www.dbi-services.com\/blog\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\/","og_locale":"en_US","og_type":"article","og_title":"MariaDB 10.3.1x + 10.4.x : mysqld_multi not working properly","og_description":"A couple of days ago, we upgraded some MariaDB instances on a consolidated database server. However, after the software update we were not able to manage our instances anymore using mysqld_multi whatever the MariaDB release (10.3.18 or the latest 10.4.x). Previously, everything worked fine with 10.3.14. So, what happened to our system?","og_url":"https:\/\/www.dbi-services.com\/blog\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\/","og_site_name":"dbi Blog","article_published_time":"2019-10-30T19:28:56+00:00","author":"J\u00e9r\u00f4me Witt","twitter_card":"summary_large_image","twitter_misc":{"Written by":"J\u00e9r\u00f4me Witt","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\/"},"author":{"name":"J\u00e9r\u00f4me Witt","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7"},"headline":"MariaDB 10.3.1x + 10.4.x : mysqld_multi not working properly","datePublished":"2019-10-30T19:28:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\/"},"wordCount":168,"commentCount":0,"keywords":["elseif should be elsif","MariaDB","mysqld_multi"],"articleSection":["Database Administration &amp; Monitoring","MariaDB"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\/","url":"https:\/\/www.dbi-services.com\/blog\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\/","name":"MariaDB 10.3.1x + 10.4.x : mysqld_multi not working properly - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2019-10-30T19:28:56+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/mariadb-10-3-1x-10-4-x-mysqld_multi-not-working-properly\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MariaDB 10.3.1x + 10.4.x : mysqld_multi not working properly"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/a2d3ecddaf732850101a39b9d62c31b7","name":"J\u00e9r\u00f4me Witt","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/17095c081578ca53f52ec4030ba2bde72cc18badb325cd2ba1ee2831106507ad?s=96&d=mm&r=g","caption":"J\u00e9r\u00f4me Witt"},"description":"J\u00e9rome Witt started his Consultant career a few years ago. He is specialized in database and infrastructure management, engineering, and optimization. He is very skilled in Oracle high availability, backup &amp; recovery, and tuning technologies. His expertise also includes the open source field (Linux\/Unix), advanced Perl, Shell, Windows PowerShell programming, and Automation tools (UC4). J\u00e9r\u00f4me Witt is Oracle Certified Professional 11g (OCP 11g), Oracle Certified Expert Tuning (OCE), and ITIL V3 Foundation certified. Prior to joining dbi services, J\u00e9r\u00f4me Witt was Consultant at Trivadis in Basel. He also worked as a Junior Automation specialist at Selmoni AG in Basel. J\u00e9r\u00f4me Witt holds a BTS degree in Information Systems and Industrial Networks from France. His branch-related experience covers Pharma, Health Care, Banking &amp; Financial Services, Energy, Automotive etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/jerome-witt\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/12920","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/25"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=12920"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/12920\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=12920"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=12920"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=12920"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=12920"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}