package mysql-server 8.0.17-0ubuntu2 failed to install/upgrade: problèmes de dépendances - laissé non configuré
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-8.0 (Ubuntu) |
Invalid
|
Undecided
|
Unassigned |
Bug Description
After upgrading from Ubuntu 19.04 to 19.10, mysql doesn't works any more (error 2002 - database not found).
I tried uninstalling / installing, but no way, dkpg error on mysqld persists.
ProblemType: Package
DistroRelease: Ubuntu 19.10
Package: mysql-server 8.0.17-0ubuntu2
ProcVersionSign
Uname: Linux 5.3.0-19-generic x86_64
ApportVersion: 2.20.11-0ubuntu8.2
Architecture: amd64
Date: Fri Nov 8 09:27:42 2019
ErrorMessage: problèmes de dépendances - laissé non configuré
InstallationDate: Installed on 2019-04-24 (197 days ago)
InstallationMedia: Ubuntu 19.04 "Disco Dingo" - Release amd64 (20190416)
Logs.var.
MySQLConf.
MySQLConf.
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
MySQLVarLibDirL
PackageArchitec
ProcCmdline: BOOT_IMAGE=
Python3Details: /usr/bin/python3.7, Python 3.7.5rc1, python3-minimal, 3.7.5-1
PythonDetails: /usr/bin/python2.7, Python 2.7.17rc1, python-minimal, 2.7.17-1
RelatedPackageV
dpkg 1.19.7ubuntu2
apt 1.9.4
SourcePackage: mysql-8.0
Title: package mysql-server 8.0.17-0ubuntu2 failed to install/upgrade: problèmes de dépendances - laissé non configuré
UpgradeStatus: No upgrade log present (probably fresh install)
This looks like a database corruption and not a MYSQL package bug:
2019-11- 08T07:30: 49.357992Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.17-0ubuntu2) starting as process 1845 08T07:30: 50.096273Z 1 [ERROR] [MY-012179] [InnoDB] Could not find any file associated with the tablespace ID: 13 08T07:30: 50.096279Z 1 [ERROR] [MY-012179] [InnoDB] Could not find any file associated with the tablespace ID: 14 08T07:30: 50.096285Z 1 [ERROR] [MY-012179] [InnoDB] Could not find any file associated with the tablespace ID: 4294967293 08T07:30: 50.096292Z 1 [ERROR] [MY-012964] [InnoDB] Use --innodb- directories to find the tablespace files. If that fails then use --innodb- force-recovery= 1 to ignore this and to permanently lose all changes to the missing tablespace(s) 08T07:30: 50.196716Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. 08T07:30: 50.596311Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine 08T07:30: 50.596411Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. 08T07:30: 50.597250Z 0 [ERROR] [MY-010119] [Server] Aborting 08T07:30: 50.597565Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.17-0ubuntu2) (Ubuntu).
2019-11-
2019-11-
2019-11-
2019-11-
2019-11-
2019-11-
2019-11-
2019-11-
2019-11-
You can try recovering your database by reading:
https:/ /dev.mysql. com/doc/ refman/ 8.0/en/ forcing- innodb- recovery. html
I'm marking this as incomplete. Feel free to mark it as "new" again if you still find this is a bug in mysql, hopefully showing us a way to reproduce the issue.
Thanks a lot!
Rafael