package mysql-server-8.0 8.0.20-0ubuntu0.19.10.1 failed to install/upgrade: el subproceso instalado paquete mysql-server-8.0 script post-installation devolvió el código de salida de error 1

[Elkin Octavio Peralta Reyes]

error al tratar de configurar mysql

ProblemType: Package
DistroRelease: Ubuntu 19.10
Package: mysql-server-8.0 8.0.20-0ubuntu0.19.10.1
ProcVersionSignature: Ubuntu 5.3.0-56.50-generic 5.3.18
Uname: Linux 5.3.0-56-generic x86_64
ApportVersion: 2.20.11-0ubuntu8.9
AptOrdering:
 mysql-server-8.0:amd64: Install
 NULL: ConfigurePending
Architecture: amd64
Date: Fri May 29 09:59:05 2020
ErrorMessage: el subproceso instalado paquete mysql-server-8.0 script post-installation devolvió el código de salida de error 1
InstallationDate: Installed on 2020-03-10 (80 days ago)
InstallationMedia: Ubuntu 16.04.3 LTS "Xenial Xerus" - Release amd64 (20170801)
Logs.var.log.daemon.log:

MySQLConf.etc.mysql.conf.d.mysql.cnf: [mysql]
MySQLConf.etc.mysql.conf.d.mysqldump.cnf:
 [mysqldump]
 quick
 quote-names
 max_allowed_packet = 16M
MySQLConf.etc.mysql.mysql.conf.d.mysqld_safe_syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: ['patiosmelgar', 'rnc', 'pruebas', 'recaudo_ot', 'sys', 'medicolombia', 'ca-key.pem', 'creditcard', 'patios@002dgruas', 'performance_schema', 'test_conf', 'binlog.index', 'auto.cnf', 'conductor1', 'axesor', 'ib_logfile0', 'universidad', 'bktc', 'comparacion', 'SNEZ', 'server-cert.pem', 'cuestionario', 'recaudos_faca', 'public_key.pem', 'facturacion', 'client-cert.pem', 'server-key.pem', 'debian-5.7.flag', 'AXESOR_AVIANCA', 'sisec', 'resoluciones', 'mysql_dd_upgrade_info', 'private_key.pem', 'ib_logfile1', 'ib_buffer_pool', 'tepsicon', 'conexred', 'juriscoo_drupa89', 'ca.pem', 'ocsweb', 'conductor', 'mysql', 'cuestionarioP', 'PRIORIRTYPASS', 'mysql_upgrade_info', 'client-key.pem', 'armas', 'ibdata1', 'simit']
ProcCmdline: BOOT_IMAGE=/vmlinuz-5.3.0-56-generic root=/dev/mapper/ubuntu--vg-root ro quiet splash vt.handoff=7
Python3Details: /usr/bin/python3.7, Python 3.7.5, python3-minimal, 3.7.5-1
PythonDetails: /usr/bin/python2.7, Python 2.7.17, python-minimal, 2.7.17-1
RelatedPackageVersions:
 dpkg 1.19.7ubuntu2
 apt 1.9.4ubuntu0.1
SourcePackage: mysql-8.0
Title: package mysql-server-8.0 8.0.20-0ubuntu0.19.10.1 failed to install/upgrade: el subproceso instalado paquete mysql-server-8.0 script post-installation devolvió el código de salida de error 1
UpgradeStatus: Upgraded to eoan on 2020-05-28 (0 days ago)
modified.conffile..etc.mysql.mysql.conf.d.mysqld.cnf: [modified]
mtime.conffile..etc.mysql.mysql.conf.d.mysqld.cnf: 2020-05-29T08:14:32.154037

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Lucas Kanashiro (lucaskanashiro)]

Thanks for taking the time to report this bug and try to make Ubuntu better.

Checking the logs I noticed those errors:

2020-05-29T16:59:19.347285Z 1 [ERROR] [MY-012209] [InnoDB] Multiple files found for the same tablespace ID:
2020-05-29T16:59:19.347488Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 62 = ['ocsweb/softwares.ibd', 'test_conf/transtornos.ibd']

2020-05-29T16:59:19.347648Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 133 = ['axesor/clientesunicos.ibd', 'juriscoo_drupa89/dr_advanced_help_index.ibd']

2020-05-29T16:59:19.347838Z 1 [ERROR] [MY-012202] [InnoDB] Tablespace ID: 145 = ['axesor/avianca_cliente11_2.ibd', 'juriscoo_drupa89/dr_block_role.ibd']

2020-05-29T16:59:19.348147Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Failed, retry may succeed.
2020-05-29T16:59:19.348351Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2020-05-29T16:59:19.348820Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2020-05-29T16:59:19.349084Z 0 [ERROR] [MY-010119] [Server] Aborting

As the message says you have multiple files associated to the same tablespace ID which makes the startup process fail. If you are trying to move those files to other directories you might want to take a look at this upstream documentation:

https://dev.mysql.com/doc/refman/8.0/en/innodb-moving-data-files-offline.html

Since it seems likely to me that this is a local configuration problem,
rather than a bug in Ubuntu, I am marking this bug as 'Incomplete'.

However, if you believe that this is really a bug in Ubuntu, then we would
be grateful if you would provide a more complete description of the problem
with steps to reproduce, 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

[Launchpad Janitor (janitor)]

[Expired for mysql-8.0 (Ubuntu) because there has been no activity for 60 days.]