{"id":9166,"date":"2024-02-24T18:10:47","date_gmt":"2024-02-24T09:10:47","guid":{"rendered":"https:\/\/www.xenos.jp\/~zen\/blog2\/?p=9166"},"modified":"2024-02-24T18:10:49","modified_gmt":"2024-02-24T09:10:49","slug":"post-9166","status":"publish","type":"post","link":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/2024\/02\/24\/post-9166\/","title":{"rendered":"Ubuntu\u3067MariaDB\u306e\u30a2\u30c3\u30d7\u30c7\u30fc\u30c8\u304c\u30a8\u30e9\u30fc\u306b\u306a\u3063\u305f"},"content":{"rendered":"\n<p>Ubuntu 20.04 \u3067apt update , apt upgrade \u3092\u5b9f\u884c\u3057\u305f\u3068\u3053\u308d\u3001MariaDB\u306e\u66f4\u65b0\u3067\u30a8\u30e9\u30fc\u306b\u306a\u3063\u305f\u3002apt clean\u3084\u518d\u5b9f\u884c\u3067\u306f\u3001\u89e3\u6d88\u305b\u305a\u3002<\/p>\n\n\n\n<p>\u30a8\u30e9\u30fc\u306e\u4e00\u90e8<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>dpkg: error processing archive \/var\/cache\/apt\/archives\/mariadb-server-core-10.3_1%3a10.3.38-0ubuntu0.20.04.1_amd64.deb (--unpack):<\/code><\/pre>\n\n\n\n<p>\u30a8\u30e9\u30fc\u306e\u5168\u4f53<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ sudo apt upgrade\nReading package lists... Done\nBuilding dependency tree\nReading state information... Done\nCalculating upgrade... Done\nThe following packages were automatically installed and are no longer required:\n  libmariadb3 linux-image-4.15.0-202-generic linux-modules-4.15.0-202-generic\n  linux-modules-extra-4.15.0-202-generic\nUse 'sudo apt autoremove' to remove them.\nGet more security updates through Ubuntu Pro with 'esm-apps' enabled:\n  libmagickcore-6.q16-6-extra imagemagick libmagickwand-6.q16-6\n  imagemagick-6.q16 libopenexr24 libmagickcore-6.q16-6 imagemagick-6-common\nLearn more about Ubuntu Pro at https:\/\/ubuntu.com\/pro\nThe following packages will be upgraded:\n  mariadb-server-10.3 mariadb-server-core-10.3\n2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.\n168 not fully installed or removed.\n2 standard LTS security updates\nNeed to get 0 B\/10.5 MB of archives.\nAfter this operation, 773 kB disk space will be freed.\nDo you want to continue? &#91;Y\/n] Y\nPreconfiguring packages ...\n(Reading database ... 132397 files and directories currently installed.)\nPreparing to unpack ...\/mariadb-server-core-10.3_1%3a10.3.38-0ubuntu0.20.04.1_amd64.deb ...\nUnpacking mariadb-server-core-10.3 (1:10.3.38-0ubuntu0.20.04.1) over (1:10.3.37+maria~ubu1804) ...\ndpkg: error processing archive \/var\/cache\/apt\/archives\/mariadb-server-core-10.3_1%3a10.3.38-0ubuntu0.20.04.1_amd64.deb (--unpack):\n trying to overwrite '\/usr\/bin\/my_print_defaults', which is also in package mariadb-server-10.3 1:10.3.37+maria~ubu1804\ndpkg-deb: error: paste subprocess was killed by signal (Broken pipe)\ndpkg: regarding ...\/mariadb-server-10.3_1%3a10.3.38-0ubuntu0.20.04.1_amd64.deb containing mariadb-server-10.3:\n mariadb-server-10.3 conflicts with mysql-server-core-5.5\n  mariadb-server-core-10.3 provides mysql-server-core-5.5 and is present and installed.\ndpkg: error processing archive \/var\/cache\/apt\/archives\/mariadb-server-10.3_1%3a10.3.38-0ubuntu0.20.04.1_amd64.deb (--unpack):\n conflicting packages - not installing mariadb-server-10.3\nErrors were encountered while processing:\n \/var\/cache\/apt\/archives\/mariadb-server-core-10.3_1%3a10.3.38-0ubuntu0.20.04.1_amd64.deb\n \/var\/cache\/apt\/archives\/mariadb-server-10.3_1%3a10.3.38-0ubuntu0.20.04.1_amd64.deb\nE: Sub-process \/usr\/bin\/dpkg returned an error code (1)<\/code><\/pre>\n\n\n\n<p>\u5f37\u5236\u7684\u306b\u4e0a\u66f8\u304d\u3057\u305f\u3002\u30d1\u30c3\u30b1\u30fc\u30b8\u306e\u30d1\u30b9\u306f\u30a8\u30e9\u30fc\u3067\u8868\u793a\u3055\u308c\u305f\u3082\u306e\u3092\u305d\u306e\u307e\u307e\u6307\u5b9a\u3057\u3066\u3001\u5b9f\u884c\u3057\u305f\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ sudo dpkg -i --force-overwrite \/var\/cache\/apt\/archives\/mariadb-server-core-10.3_1%3a10.3.38-0ubuntu0.20.04.1_amd64.deb<\/code><\/pre>\n\n\n\n<p>\u5b9f\u884c\u4f8b\u3002\u30ef\u30fc\u30cb\u30f3\u30b0\u3084\u30a8\u30e9\u30fc\u304c\u51fa\u3066\u3044\u305f\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ sudo dpkg -i --force-overwrite \/var\/cache\/apt\/archives\/mariadb-server-core-10.3_1%3a10.3.38-0ubuntu0.20.04.1_amd64.deb\n(Reading database ... 132397 files and directories currently installed.)\nPreparing to unpack ...\/mariadb-server-core-10.3_1%3a10.3.38-0ubuntu0.20.04.1_amd64.deb ...\nUnpacking mariadb-server-core-10.3 (1:10.3.38-0ubuntu0.20.04.1) over (1:10.3.37+maria~ubu1804) ...\ndpkg: warning: overriding problem because --force enabled:\ndpkg: warning: trying to overwrite '\/usr\/bin\/my_print_defaults', which is also in package mariadb-server-10.3 1:10.3.37+maria~ubu1804\ndpkg: warning: overriding problem because --force enabled:\ndpkg: warning: trying to overwrite '\/usr\/bin\/resolveip', which is also in package mariadb-server-10.3 1:10.3.37+maria~ubu1804\ndpkg: warning: overriding problem because --force enabled:\ndpkg: warning: trying to overwrite '\/usr\/share\/man\/man1\/my_print_defaults.1.gz', which is also in package mariadb-server-10.3 1:10.3.37+maria~ubu1804\ndpkg: warning: overriding problem because --force enabled:\ndpkg: warning: trying to overwrite '\/usr\/share\/man\/man1\/resolveip.1.gz', which is also in package mariadb-server-10.3 1:10.3.37+maria~ubu1804\ndpkg: warning: overriding problem because --force enabled:\ndpkg: warning: trying to overwrite '\/usr\/share\/mysql\/fill_help_tables.sql', which is also in package mariadb-server-10.3 1:10.3.37+maria~ubu1804\ndpkg: warning: overriding problem because --force enabled:\ndpkg: warning: trying to overwrite '\/usr\/share\/mysql\/maria_add_gis_sp_bootstrap.sql', which is also in package mariadb-server-10.3 1:10.3.37+maria~ubu1804\ndpkg: warning: overriding problem because --force enabled:\ndpkg: warning: trying to overwrite '\/usr\/share\/mysql\/mysql_performance_tables.sql', which is also in package mariadb-server-10.3 1:10.3.37+maria~ubu1804\ndpkg: warning: overriding problem because --force enabled:\ndpkg: warning: trying to overwrite '\/usr\/share\/mysql\/mysql_system_tables.sql', which is also in package mariadb-server-10.3 1:10.3.37+maria~ubu1804\ndpkg: warning: overriding problem because --force enabled:\ndpkg: warning: trying to overwrite '\/usr\/share\/mysql\/mysql_system_tables_data.sql', which is also in package mariadb-server-10.3 1:10.3.37+maria~ubu1804\ndpkg: warning: overriding problem because --force enabled:\ndpkg: warning: trying to overwrite '\/usr\/share\/mysql\/mysql_test_data_timezone.sql', which is also in package mariadb-server-10.3 1:10.3.37+maria~ubu1804\ndpkg: warning: overriding problem because --force enabled:\ndpkg: warning: trying to overwrite '\/usr\/share\/mysql\/mysql_test_db.sql', which is also in package mariadb-server-10.3 1:10.3.37+maria~ubu1804\ndpkg: dependency problems prevent configuration of mariadb-server-core-10.3:\n mariadb-server-core-10.3 depends on libsnappy1v5 (>= 1.1.8); however:\n  Package libsnappy1v5:amd64 is not configured yet.\ndpkg: error processing package mariadb-server-core-10.3 (--install):\n dependency problems - leaving unconfigured\nProcessing triggers for man-db (2.9.1-1) ...\nErrors were encountered while processing:\n mariadb-server-core-10.3\n$<\/code><\/pre>\n\n\n\n<p>\u3053\u306e\u5f8c\u3001\u3082\u30461\u56de\u3001apt update\u3068apt upgrade\u3092\u5b9f\u65bd\u3057\u305f\u3002\u305d\u306e\u4ed6\u306e\u30d1\u30c3\u30b1\u30fc\u30b8\u3082\u30ad\u30ec\u30a4\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u305f\u3002<\/p>\n\n\n\n<p>\u5ff5\u306e\u305f\u3081\u3001OS\u518d\u8d77\u52d5\u3082\u5b9f\u65bd\u3057\u305f\u304c\u8d77\u52d5\u306b\u554f\u984c\u306a\u3057\u3002MariaDB\u3082\u30d0\u30fc\u30b8\u30e7\u30f3\u30a2\u30c3\u30d7\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3067\u304d\u305f\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ubuntu 20.04 \u3067apt update , apt upgrade \u3092\u5b9f\u884c\u3057\u305f\u3068\u3053\u308d\u3001MariaDB\u306e\u66f4\u65b0\u3067\u30a8\u30e9\u30fc\u306b\u306a\u3063\u305f\u3002apt clean\u3084\u518d\u5b9f\u884c\u3067\u306f\u3001\u89e3\u6d88\u305b\u305a\u3002 \u30a8\u30e9\u30fc\u306e\u4e00\u90e8 \u30a8\u30e9\u30fc\u306e\u5168\u4f53 \u5f37\u5236\u7684\u306b\u4e0a\u66f8\u304d [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[38],"class_list":["post-9166","post","type-post","status-publish","format-standard","hentry","category-linux","tag-mariadb"],"_links":{"self":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/9166","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/comments?post=9166"}],"version-history":[{"count":2,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/9166\/revisions"}],"predecessor-version":[{"id":9432,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/posts\/9166\/revisions\/9432"}],"wp:attachment":[{"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/media?parent=9166"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/categories?post=9166"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xenos.jp\/~zen\/blog2\/index.php\/wp-json\/wp\/v2\/tags?post=9166"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}