Comment 11 for bug 1817374

Revision history for this message
Lucas Kanashiro (lucaskanashiro) wrote :

Thank you for taking the time to file a bug report.

I created a Bionic container to test the upgrade of mysql version 5.7.21-1ubuntu1 to 5.7.34-0ubuntu0.18.04.1 and it worked as expected:

root@mysql-test:~# apt list --upgradable
Listing... Done
mysql-server-5.7/bionic-updates,bionic-security 5.7.34-0ubuntu0.18.04.1 amd64 [upgradable from: 5.7.21-1ubuntu1]
mysql-server-core-5.7/bionic-updates,bionic-security 5.7.34-0ubuntu0.18.04.1 amd64 [upgradable from: 5.7.21-1ubuntu1]
root@mysql-test:~# apt upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
The following package was automatically installed and is no longer required:
  libfreetype6
Use 'apt autoremove' to remove it.
The following packages will be upgraded:
  mysql-server-5.7 mysql-server-core-5.7
2 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.
Need to get 10.3 MB of archives.
After this operation, 2650 kB disk space will be freed.
Do you want to continue? [Y/n]
Get:1 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 mysql-server-5.7 amd64 5.7.34-0ubuntu0.18.04.1 [2905 kB]
Get:2 http://archive.ubuntu.com/ubuntu bionic-updates/main amd64 mysql-server-core-5.7 amd64 5.7.34-0ubuntu0.18.04.1 [7418 kB]
Fetched 10.3 MB in 3s (3986 kB/s)
Preconfiguring packages ...
(Reading database ... 29454 files and directories currently installed.)
Preparing to unpack .../mysql-server-5.7_5.7.34-0ubuntu0.18.04.1_amd64.deb ...
Unpacking mysql-server-5.7 (5.7.34-0ubuntu0.18.04.1) over (5.7.21-1ubuntu1) ...
Preparing to unpack .../mysql-server-core-5.7_5.7.34-0ubuntu0.18.04.1_amd64.deb ...
Unpacking mysql-server-core-5.7 (5.7.34-0ubuntu0.18.04.1) over (5.7.21-1ubuntu1) ...
Setting up mysql-server-core-5.7 (5.7.34-0ubuntu0.18.04.1) ...
Setting up mysql-server-5.7 (5.7.34-0ubuntu0.18.04.1) ...
Installing new version of config file /etc/apparmor.d/usr.sbin.mysqld ...
Checking if update is needed.
Checking server version.
Running queries to upgrade MySQL server.
Checking system database.
mysql.columns_priv OK
mysql.db OK
mysql.engine_cost OK
mysql.event OK
mysql.func OK
mysql.general_log OK
mysql.gtid_executed OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.ndb_binlog_index OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.server_cost OK
mysql.servers OK
mysql.slave_master_info OK
mysql.slave_relay_log_info OK
mysql.slave_worker_info OK
mysql.slow_log OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK
Found outdated sys schema version 1.5.1.
Upgrading the sys schema.
Checking databases.
sys.sys_config OK
Upgrade process completed successfully.
Checking if update is needed.
Processing triggers for systemd (237-3ubuntu10.47) ...
Processing triggers for man-db (2.8.3-2ubuntu0.1) ...
Processing triggers for ureadahead (0.100.0-21) ...
root@mysql-test:~# systemctl status mysql
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: active (running) since Tue 2021-05-18 18:48:36 UTC; 36s ago
 Main PID: 4387 (mysqld)
    Tasks: 27 (limit: 77042)
   CGroup: /system.slice/mysql.service
           └─4387 /usr/sbin/mysqld --daemonize --pid-file=/run/mysqld/mysqld.pid

May 18 18:48:36 mysql-test systemd[1]: Starting MySQL Community Server...
May 18 18:48:36 mysql-test systemd[1]: Started MySQL Community Server.
May 18 18:48:36 mysql-test systemd[1]: mysql.service: Failed to reset devices.list: Operation not permitted
root@mysql-test:~#

Could you provide the mysql logs and the apt logs of the package upgrade? Also any "special" change you have made in your config files.

Since there is not enough information in your report to begin triage or to
differentiate between a local configuration problem and a bug in Ubuntu, I
am marking this bug as "Incomplete". We would be grateful if you would:
provide a more complete description of the problem, explain why you
believe this is a bug in Ubuntu rather than a problem specific to your
system, and then change the bug status back to "New".

For local configuration issues, you can find assistance here:
http://www.ubuntu.com/support/community