Hi Christian Ehrhardt, I ran:
mysqlcheck -c -u root -p --all-databases and all my databases returned "OK". So my MySQL Database does NOT appear to be "broken". What else might be going on? Also, if a "broken" database can cause this failure, why not run: mysqlcheck -u root -p --auto-repair -c -o --all-databases as part of the update process to correct any issues and not generate a FAIL? Any help is appreciated. *Kenneth Ervin Young* *IDEA TO GROWTH LLC* Chief Executive Officer Mobile: +1 (813) 407-8240 500 East Kennedy Blvd, 3rd Floor Tampa, FL 33602 Website <http://www.IdeaToGrowth.com> Email <[email protected]> Facebook <https://www.facebook.com/IdeaToGrowth/> Twitter <https://twitter.com/IdeaToGrowth> *Connect with me on LinkedIn <http://www.linkedin.com/in/KennethErvinYoung>* *TAMPA BAY WAVE* Investment Readiness Program Director & Entrepreneur-In-Residence 500 East Kennedy Blvd, 3rd Floor Tampa, FL 33602 Website <http://www.tampabaywave.org/> Email <[email protected]> On Tue, Jan 2, 2018 at 5:12 AM, ChristianEhrhardt < [email protected]> wrote: > Hi, > you have mysql installed but your database is broken. > >From your Log: > 2017-12-20T13:59:10.910577Z 0 [Note] InnoDB: Log scan progressed past the > checkpoint lsn 83231063627 > 2017-12-20T13:59:10.910600Z 0 [Note] InnoDB: Doing recovery: scanned up to > log sequence number 83231064064 > 2017-12-20T13:59:10.911220Z 0 [ERROR] InnoDB: Ignoring the redo log due to > missing MLOG_CHECKPOINT between the checkpoint 83231063627 and the end > 83231064064. > 2017-12-20T13:59:10.911241Z 0 [ERROR] InnoDB: Plugin initialization > aborted with error Generic error > 2017-12-20T13:59:11.514745Z 0 [ERROR] Plugin 'InnoDB' init function > returned error. > 2017-12-20T13:59:11.514802Z 0 [ERROR] Plugin 'InnoDB' registration as a > STORAGE ENGINE failed. > 2017-12-20T13:59:11.514812Z 0 [ERROR] Failed to initialize plugins. > 2017-12-20T13:59:11.514817Z 0 [ERROR] Aborting > > Due to that the service is failing to (re-)start. > But that is a requirement to upgrade the package (to do updates on the > upgrade). > > You can fixup the DB (or remove it if not needed) or remove mysql > completely if not used anyway. > > -- > You received this bug notification because you are subscribed to the bug > report. > https://bugs.launchpad.net/bugs/1739427 > > Title: > package mysql-server-5.7 5.7.20-0ubuntu0.17.04.1 failed to > install/upgrade: subprocess installed post-installation script re > turned error exit status 1 > > Status in mysql-5.7 package in Ubuntu: > Incomplete > > Bug description: > Got this error during update from 16.04 or 16.10 to 17.04 I think > > ProblemType: Package > DistroRelease: Ubuntu 17.04 > Package: mysql-server-5.7 5.7.20-0ubuntu0.17.04.1 > Uname: Linux 4.9.50-x86_64-linode86 x86_64 > ApportVersion: 2.20.4-0ubuntu4.9 > Architecture: amd64 > Date: Wed Dec 20 08:59:11 2017 > ErrorMessage: subprocess installed post-installation script returned > error exit status 1 > KernLog: > > 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: ['kennethervinyoungdb', 'ib_logfile1', > 'performance_schema', 'thehollisgroup', 'ib_logfile0', 'ideatogrowth_db', > 'wpsiterepair_db', 'sys', 'phpmyadmin', 'eighthdatabase_db', > 'preferhired_db', 'ibdata1', 'wpsiteteam_db', 'drerichollis_db', > 'kyleedwardyoungdb', 'drerichollisdb', 'ib_buffer_pool', 'ibtmp1', > 'casajimenezwines_db', 'headsandtails_db', 'kennetheyoungdb', > 'tradesfactor_db', 'wpquicksite_db', 'debian-5.7.flag', 'mysql', > 'auto.cnf', 'mysql_upgrade_info'] > ProcCmdline: root=/dev/sda console=tty1 console=ttyS0 ro > devtmpfs.mount=1 > RelatedPackageVersions: > dpkg 1.18.10ubuntu2 > apt 1.4.6~17.04.1 > SourcePackage: mysql-5.7 > Title: package mysql-server-5.7 5.7.20-0ubuntu0.17.04.1 failed to > install/upgrade: subprocess installed post-installation script returned > error exit status 1 > UpgradeStatus: Upgraded to zesty on 2017-12-20 (0 days ago) > > To manage notifications about this bug go to: > https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/ > 1739427/+subscriptions > -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1739427 Title: package mysql-server-5.7 5.7.20-0ubuntu0.17.04.1 failed to install/upgrade: subprocess installed post-installation script re turned error exit status 1 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/mysql-5.7/+bug/1739427/+subscriptions -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
