I tried the usual to fix this bug ..... apt --fix-broken install apt install mysql-server
and while it did fix a broken dependency it still reported status as Upgrade in Progress 5.7 to 8.0 ... However in inspecting the SQL error log it seems that the upgrade was stuck on on infinite loop trying (and failing) to upgrade the same table over and over ...... 2020-02-27T06:33:22.196147Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.19-0ubuntu0.19.10.3) starting as process 7625 2020-02-27T06:33:22.220027Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory. 2020-02-27T06:33:25.927054Z 2 [ERROR] [MY-012083] [InnoDB] Table IP_Phones/root_group is not found in InnoDB dictionary 2020-02-27T06:33:25.927427Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for IP_Phones.root_group 2020-02-27T06:33:25.935839Z 2 [ERROR] [MY-012083] [InnoDB] Table IP_Phones/root_contact is not found in InnoDB dictionary 2020-02-27T06:33:25.936212Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for IP_Phones.root_contact 2020-02-27T06:33:25.942545Z 2 [ERROR] [MY-012083] [InnoDB] Table IP_Phones/Company is not found in InnoDB dictionary 2020-02-27T06:33:25.942987Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for IP_Phones.Company 2020-02-27T06:33:33.946118Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables. 2020-02-27T06:33:33.946879Z 0 [ERROR] [MY-010119] [Server] Aborting 2020-02-27T06:33:35.557598Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.19-0ubuntu0.19.10.3) (Ubuntu). 2020-02-27T06:33:36.706904Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead. 2020-02-27T06:33:36.711302Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.19-0ubuntu0.19.10.3) starting as process 7698 2020-02-27T06:33:36.734882Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory. 2020-02-27T06:33:39.938288Z 2 [ERROR] [MY-012083] [InnoDB] Table IP_Phones/root_group is not found in InnoDB dictionary 2020-02-27T06:33:39.938929Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for IP_Phones.root_group 2020-02-27T06:33:39.948222Z 2 [ERROR] [MY-012083] [InnoDB] Table IP_Phones/root_contact is not found in InnoDB dictionary 2020-02-27T06:33:39.948637Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for IP_Phones.root_contact 2020-02-27T06:33:39.955979Z 2 [ERROR] [MY-012083] [InnoDB] Table IP_Phones/Company is not found in InnoDB dictionary 2020-02-27T06:33:39.956409Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for IP_Phones.Company 2020-02-27T06:33:48.102907Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables. 2020-02-27T06:33:48.103689Z 0 [ERROR] [MY-010119] [Server] Aborting 2020-02-27T06:33:49.688120Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.19-0ubuntu0.19.10.3) (Ubuntu). 2020-02-27T06:33:50.699200Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead. and so on ad-infinitum ...... I moved the entire directory containing this database to my home directory and without even having to restart it the upgrade completed and started mysql. It seems the problem is not with the upgrade itself but in the fact that the upgrade gets stuck in an infinite loop when it fails to be able to upgrade a database. I will figure out what it doesn't like about the table later. 2020-02-27T06:34:38.735613Z 2 [ERROR] [MY-012083] [InnoDB] Table IP_Phones/root_contact is not found in InnoDB dictionary 2020-02-27T06:34:38.736004Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for IP_Phones.root_contact 2020-02-27T06:34:38.743030Z 2 [ERROR] [MY-012083] [InnoDB] Table IP_Phones/Company is not found in InnoDB dictionary 2020-02-27T06:34:38.743455Z 2 [ERROR] [MY-010767] [Server] Error in fixing SE data for IP_Phones.Company 2020-02-27T06:34:46.810865Z 0 [ERROR] [MY-010022] [Server] Failed to Populate DD tables. 2020-02-27T06:34:46.811643Z 0 [ERROR] [MY-010119] [Server] Aborting 2020-02-27T06:34:48.419798Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.19-0ubuntu0.19.10.3) (Ubuntu). 2020-02-27T06:34:49.426926Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead. 2020-02-27T06:34:49.431041Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.19-0ubuntu0.19.10.3) starting as process 8032 2020-02-27T06:34:49.452924Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory. 2020-02-27T06:35:06.351247Z 2 [System] [MY-011003] [Server] Finished populating Data Dictionary tables with data. 2020-02-27T06:35:08.591061Z 5 [System] [MY-013381] [Server] Server upgrade from '50700' to '80019' started. 2020-02-27T06:35:23.759966Z 5 [System] [MY-013381] [Server] Server upgrade from '50700' to '80019' completed. 2020-02-27T06:35:23.945776Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2020-02-27T06:35:24.001095Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.19-0ubuntu0.19.10.3' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu). 2020-02-27T06:35:24.163996Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1864958 Title: package mysql-server-8.0 8.0.19-0ubuntu0.19.10.3 failed to install/upgrade: installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-8.0/+bug/1864958/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
