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

[Kenneth Ervin Young]

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)

[Christian Ehrhardt  (paelzer)]

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.

[Christian Ehrhardt  (paelzer)]

Thank you for taking the time to report this bug and helping to make Ubuntu better.

On upgrading a service this service has to be restarted to pick up the fixes.
Rather rarely a real issue occurs that the newer version does e.g. fail with the formerly working configuration.
But most of the time what happens is, that a service was installed, but stays unconfigured or experimented with but left in a broken state.

Now on any update of the related packages that service has to be restarted, but since its config is incomplete/faulty it fails to restart.
Therefore the update of that package has to consider itself incomplete.

Depending on your particular case there are two solutions:
- either remove the offending package if you don't want to continue using it.
- Or if you do want to keep it please fix the configuration so that re-starting the service will work.

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

If indeed this is a local configuration problem, you can find pointers to get help for this sort of problem here: http://www.ubuntu.com/support/community

Or if you believe that this is really a bug, then you may find it helpful to read "How to report bugs effectively" http://www.chiark.greenend.org.uk/~sgtatham/bugs.html. We'd be grateful if you would then 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.

[Kenneth Ervin Young (kennethervinyoung)]

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: [phone]

500 East Kennedy Blvd, 3rd Floor

Tampa, FL 33602

Website <http://www.IdeaToGrowth.com> Email <email address hidden>
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 address hidden>

On Tue, Jan 2, 2018 at 5:12 AM, ChristianEhrhardt <
<email address hidden>> 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:
> [mysqldum...

[Launchpad Janitor (janitor)]

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

[Kenneth Ervin Young (kennethervinyoung)]

Hello Bug,

I hope 2018 was as an exciting year for you your family and your business
as it was for my family and my business!

For my business, Idea To Growth LLC
<http://ec2-52-26-194-35.us-west-2.compute.amazonaws.com/x/c?c=3353724&l=6ffe1070-0621-40d3-99af-49c00bdc4cb5&r=39b1a937-2fa3-43b9-98f3-aefb8d32a22c>,
2019 has some exciting times coming that I wanted to share, starting in
mid-January 2019.

I completed my book "Angel Investors to Venture Capital - 10 Slides to
Startup Funding Success - Entrepreneurs Guide to Startup Fundraising". The
proofs just got here from Amazon!

[image: IMG_0371.jpeg][image: IMG_0373.jpeg]

The book teaches any Entrepreneur how to go about the process of raising
money for their startup - be it from Friends and Family, Angel Investors or
Venture Capitalists.

I've been a founder in many startups in Silicon Valley in which well over
$100M USD was raised. I've personally made a lot of goofs and gotten a lot
of sage advice over the years from investors as to what they want, and
need, to see and hear from a company founder or CEO to get them to "open
their checkbook".

If you, a family member or a friend wants to learn the best practices of
how to successfully raise money for their startup, please share this email
and the below link to sign up for my Book Launch Notice below. I'll be
offering a "Special Price" on both the eBook and the Paperback for only
24-48 hours on Book Launch Day.

To be notified about the book Launch so you can buy it at the Special
Price, you need to be on the list.

Click Here: Please Notify Me About the Book Launch Day and Special Prices!
<http://ec2-52-26-194-35.us-west-2.compute.amazonaws.com/x/c?c=3353724&l=5169326a-ba27-4bbf-aad0-9c24af02d004&r=39b1a937-2fa3-43b9-98f3-aefb8d32a22c>

If you prefer not to receive future emails from me, you may click this
unsubscribe
<http://ec2-52-26-194-35.us-west-2.compute.amazonaws.com/x/u?u=39b1a937-2fa3-43b9-98f3-aefb8d32a22c>
 link.

Again, Best Wishes for a Wonderful Holiday time and a prosperous 2019!

*Kenneth Ervin Young*

*IDEA TO GROWTH LLC *

Chief Executive Officer

<email address hidden>

<email address hidden>

Mobile/Text: [phone]

Business Mail:

3690 W Gandy Blvd

Suite #183

Tampa, FL 33611-3300

United States

*Website*
<http://ec2-52-26-194-35.us-west-2.compute.amazonaws.com/x/c?c=3353724&l=e3d7ea5b-ea53-420b-a3eb-d7b0a0d179ff&r=39b1a937-2fa3-43b9-98f3-aefb8d32a22c>
  *Email* <email address hidden> *Facebook*
<http://ec2-52-26-194-35.us-west-2.compute.amazonaws.com/x/c?c=3353724&l=175c48ab-dff9-4038-a0b8-7a20937df3d1&r=39b1a937-2fa3-43b9-98f3-aefb8d32a22c>
  *Twitte*r
<http://ec2-52-26-194-35.us-west-2.compute.amazonaws.com/x/c?c=3353724&l=49228847-4edc-4c3b-b080-d7ec392aa1a2&r=39b1a937-2fa3-43b9-98f3-aefb8d32a22c>
  *LinkedIn*
<http://ec2-52-26-194-35.us-west-2.compute.amazonaws.com/x/c?c=3353724&l=4188b065-62ab-456f-ab09-e44adf25120a&r=39b1a937-2fa3-43b9-98f3-aefb8d32a22c>
 *LinkedIn-IdeaToGrowthLLC*
<http://ec2-52-26-194-35.us-west-2.compute.amazonaws.com/x/c?c=3353724&l=579c93a5-bd58-435e-8bb8-9229e217a9c7&r=39b1a937-2fa3-43b9-98f3-aefb8d32a22c>

You received this email because you connected with ...