Public bug reported: After upgrade, mysql would not start, so uninstalled and purged. Then tried reinstalling mysql-server. Still would not start. So uninstalled and purged again. Then tried installing mariadb-server. Would not start, here is the log of process and errors:
root@ike:/var/lib/mysql# apt install mariadb-server Reading package lists... Done Building dependency tree Reading state information... Done The following packages were automatically installed and are no longer required: libevent-core-2.1-7 libmecab2 mecab-ipadic mecab-ipadic-utf8 mecab-utils Use 'apt autoremove' to remove them. The following NEW packages will be installed mariadb-server 0 to upgrade, 1 to newly install, 0 to remove and 0 not to upgrade. Need to get 12.7 kB of archives. After this operation, 68.6 kB of additional disk space will be used. Get:1 http://gb.archive.ubuntu.com/ubuntu focal/universe amd64 mariadb-server all 1:10.3.22-1ubuntu1 [12.7 kB] Fetched 12.7 kB in 10s (1,230 B/s) Selecting previously unselected package mariadb-server. (Reading database ... 137421 files and directories currently installed.) Preparing to unpack .../mariadb-server_1%3a10.3.22-1ubuntu1_all.deb ... Unpacking mariadb-server (1:10.3.22-1ubuntu1) ... Setting up mariadb-server (1:10.3.22-1ubuntu1) ... root@ike:/var/lib/mysql# root@ike:/var/lib/mysql# service mysql start Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details. root@ike:/var/lib/mysql# tail /var/log/mysql/error.log 2020-05-24 16:09:22 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool 2020-05-24 16:09:22 0 [Note] InnoDB: Cannot open '/var/lib/mysql/ib_buffer_pool' for reading: No such file or directory 2020-05-24 16:09:22 0 [Note] Plugin 'FEEDBACK' is disabled. 2020-05-24 16:09:22 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded 2020-05-24 16:09:22 0 [Note] Recovering after a crash using tc.log 2020-05-24 16:09:22 0 [Note] Starting crash recovery... 2020-05-24 16:09:22 0 [Note] Crash recovery finished. 2020-05-24 16:09:22 0 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 2020-05-24 16:09:22 0 [Note] Server socket created on IP: '127.0.0.1'. 2020-05-24 16:09:22 0 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist ProblemType: Bug DistroRelease: Ubuntu 20.04 Package: mariadb-server 1:10.3.22-1ubuntu1 ProcVersionSignature: Ubuntu 5.4.0-31.35-generic 5.4.34 Uname: Linux 5.4.0-31-generic x86_64 NonfreeKernelModules: wl ApportVersion: 2.20.11-0ubuntu27 Architecture: amd64 CasperMD5CheckResult: skip Date: Sun May 24 16:41:51 2020 InstallationDate: Installed on 2016-04-15 (1499 days ago) InstallationMedia: Ubuntu-Server 14.04.4 LTS "Trusty Tahr" - Release amd64 (20160217.1) Logs.var.log.daemon.log: MySQLConf.etc.mysql.mariadb.cnf: Error: [Errno 2] No such file or directory: '/etc/mysql/mariadb.cnf' PackageArchitecture: all SourcePackage: mariadb-10.3 UpgradeStatus: Upgraded to focal on 2020-05-24 (0 days ago) modified.conffile..etc.default.mysql: [deleted] modified.conffile..etc.mysql.debian-start: [deleted] modified.conffile..etc.mysql.mariadb.conf.d.50-mysqld_safe.cnf: [deleted] modified.conffile..etc.mysql.mariadb.conf.d.50-server.cnf: [deleted] ** Affects: mariadb-10.3 (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apparmor apport-bug focal third-party-packages -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1880415 Title: Upgraded from 18.04 to 20.04, mariadb-server installer broken To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mariadb-10.3/+bug/1880415/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
