There are two separate "upgrades" happening: Upgrading the package and
upgrading the database. The problem is that right now the former will
fail if the latter fails, but it doesn't need to.
I have a solution (still needs some more testing, but hopefully it will
be ready soon) that:
a) Tries to run the server directly instead of through the service
system, so it should work normally if the service is disabled as long as
the server isn't already running (since then we can't stop it).
b) Completes the package upgrade even if the server can't be started,
but without running mysql_upgrade.
There are two separate "upgrades" happening: Upgrading the package and
upgrading the database. The problem is that right now the former will
fail if the latter fails, but it doesn't need to.
I have a solution (still needs some more testing, but hopefully it will
be ready soon) that:
a) Tries to run the server directly instead of through the service
system, so it should work normally if the service is disabled as long as
the server isn't already running (since then we can't stop it).
b) Completes the package upgrade even if the server can't be started,
but without running mysql_upgrade.
--
Lars
On 04/29/2017 09:51 AM, Ben Landin wrote: /urldefense. proofpoint. com/v2/ url?u=https- 3A__bugs. launchpad. net_bugs_ 1592669& d=DwIFaQ& c=RoP1YumCXCgaW HvlZYR8PQcxBKCX 5YTpkKY057SbK10 &r=HPjEzLhETPj8 fl9HCxxISaaV3f5 tXDpGXDR3R2IELx g&m=PdAlVtFEw3y L55hI32gYfa72qn bSSi8VrBBgpGOqV 9A&s=J_ Ik4Rb7XaAgBURNK to_54-iFFIwX9Bo pkj5F3xbY4I& e= /urldefense. proofpoint. com/v2/ url?u=https- 3A__bugs. launchpad. net_ubuntu_ -2Bsource_ mysql-2D5. 7_-2Bbug_ &d=DwIFaQ& c=RoP1YumCXCgaW HvlZYR8PQcxBKCX 5YTpkKY057SbK10 &r=HPjEzLhETPj8 fl9HCxxISaaV3f5 tXDpGXDR3R2IELx g&m=PdAlVtFEw3y L55hI32gYfa72qn bSSi8VrBBgpGOqV 9A&s=4q_ iH3iF49qeYu7uFb OKBQC9aiQxFqWA8 Ek4Yqf3Ay4& e= +subscriptions /urldefense. proofpoint. com/v2/ url?u=https- 3A__bugs. launchpad. net_bugs_ 1592669& d=DwIFaQ& c=RoP1YumCXCgaW HvlZYR8PQcxBKCX 5YTpkKY057SbK10 &r=HPjEzLhETPj8 fl9HCxxISaaV3f5 tXDpGXDR3R2IELx g&m=PdAlVtFEw3y L55hI32gYfa72qn bSSi8VrBBgpGOqV 9A&s=J_ Ik4Rb7XaAgBURNK to_54-iFFIwX9Bo pkj5F3xbY4I& e= ature: Ubuntu 4.4.0-24.43-generic 4.4.10 log.daemon. log: log.mysql. error.log: etc.mysql. conf.d. mysql.cnf: [mysql] etc.mysql. conf.d. mysqld_ safe_syslog. cnf: etc.mysql. conf.d. mysqldump. cnf: etc.mysql. mysql.conf. d.mysqld_ safe_syslog. cnf: isting: ['joomla', 'debian-5.7.flag', schema' , 'mysql', 'debian-5.5.flag', 'ibdata1', upgrade_ info', 'ibtmp1', 'auto.cnf', 'sys', 'ib_logfile0', /boot/vmlinuz- 4.4.0-24- generic 24616351- e938-44c6- b79f-5db042b256 3b ro quiet splash ersions: ubuntu16. 04.1 mysql.override: manual /urldefense. proofpoint. com/v2/ url?u=https- 3A__bugs. launchpad. net_ubuntu_ -2Bsource_ mysql-2D5. 7_-2Bbug_ &d=DwIFaQ& c=RoP1YumCXCgaW HvlZYR8PQcxBKCX 5YTpkKY057SbK10 &r=HPjEzLhETPj8 fl9HCxxISaaV3f5 tXDpGXDR3R2IELx g&m=PdAlVtFEw3y L55hI32gYfa72qn bSSi8VrBBgpGOqV 9A&s=4q_ iH3iF49qeYu7uFb OKBQC9aiQxFqWA8 Ek4Yqf3Ay4& e= +subscriptions /urldefense. proofpoint. com/v2/ url?u=https- 3A__bugs. launchpad. net_bugs_ 1592669& d=DwIFaQ& c=RoP1YumCXCgaW HvlZYR8PQcxBKCX 5YTpkKY057SbK10 &r=HPjEzLhETPj8 fl9HCxxISaaV3f5 tXDpGXDR3R2IELx g&m=PdAlVtFEw3y L55hI32gYfa72qn bSSi8VrBBgpGOqV 9A&s=J_ Ik4Rb7XaAgBURNK to_54-iFFIwX9Bo pkj5F3xbY4I& e= /urldefense. proofpoint. com/v2/ url?u=https- 3A__bugs. launchpad. net_ubuntu_ -2Bsource_ mysql-2D5. 7_-2Bbug_ &d=DwIFaQ& c=RoP1YumCXCgaW HvlZYR8PQcxBKCX 5YTpkKY057SbK10 &r=HPjEzLhETPj8 fl9HCxxISaaV3f5 tXDpGXDR3R2IELx g&m=PdAlVtFEw3y L55hI32gYfa72qn bSSi8VrBBgpGOqV 9A&s=4q_ iH3iF49qeYu7uFb OKBQC9aiQxFqWA8 Ek4Yqf3Ay4& e= +subscriptions
> During an upgrade, there are queries that need to be run against the
> server, which means the mysql service must be running.
>
> On Apr 29, 2017 3:04 AM, "Pablo Catalina" <email address hidden>
> wrote:
>
> But, why the service has to be enabled to upgrade it?
>
> El 29/4/2017 5:34, "Jordao" <email address hidden> escribió:
>
>> That's ok, but I guess a better approach would be delaying upgrade (no
>> install) if service is disabled or doing these steps automatically because
>> it can be very annoying and could mess something up.
>> The first option should be a bit easier to implement.
>>
>> 2017-04-28 17:08 GMT-03:00 Larika <email address hidden>:
>>
>>> sudo systemctl enable mysql
>>> sudo systemctl start mysql
>>> sudo apt install -f
>>>
>>> Upgrade process completed successfully. :)
>>>
>>> --
>>> You received this bug notification because you are subscribed to a
>>> duplicate bug report (1658034).
>>> https:/
>>>
>>> Title:
>>> postinst fails when daemon is not running (or is disabled by policy-
>>> rc.d)
>>>
>>> To manage notifications about this bug go to:
>>> https:/
>>> 1592669/
>>>
>> --
>> You received this bug notification because you are subscribed to a
>> duplicate bug report (1595208).
>> https:/
>>
>> Title:
>> postinst fails when daemon is not running (or is disabled by policy-
>> rc.d)
>>
>> Status in mysql-5.7 package in Ubuntu:
>> In Progress
>> Status in mysql-5.7 package in Debian:
>> New
>>
>> Bug description:
>> Every 10-15 minutes mysql crashes with this error.
>>
>> ProblemType: Package
>> DistroRelease: Ubuntu 16.04
>> Package: mysql-server-5.7 5.7.12-0ubuntu1
>> ProcVersionSign
>> Uname: Linux 4.4.0-24-generic x86_64
>> ApportVersion: 2.20.1-0ubuntu2.1
>> Architecture: amd64
>> Date: Fri Jun 10 10:47:34 2016
>> ErrorMessage: subprocess installed post-installation script returned
>> error exit status 1
>> InstallationDate: Installed on 2002-01-01 (5279 days ago)
>> InstallationMedia: Ubuntu 14.04.1 LTS "Trusty Tahr" - Release amd64
>> (20140722.2)
>> Logs.var.
>>
>> Logs.var.
>> MySQLConf.
>> MySQLConf.
>> [mysqld_safe]
>> syslog
>> MySQLConf.
>> [mysqldump]
>> quick
>> quote-names
>> max_allowed_packet = 16M
>> MySQLConf.
>> [mysqld_safe]
>> syslog
>> MySQLVarLibDirL
>> 'performance_
> 'ib_logfile1',
>> 'mysql_
>> 'ib_buffer_pool']
>> ProcCmdline: BOOT_IMAGE=
>> root=UUID=
>> vt.handoff=7
>> RelatedPackageV
>> dpkg 1.18.4ubuntu1.1
>> apt 1.2.12~
>> SourcePackage: mysql-5.7
>> Title: package mysql-server-5.7 5.7.12-0ubuntu1 failed to
>> install/upgrade: subprocess installed post-installation script returned
>> error exit status 1
>> UpgradeStatus: Upgraded to xenial on 2016-06-10 (4 days ago)
>> upstart.
>>
>> To manage notifications about this bug go to:
>> https:/
>> 1592669/
>>
> --
> You received this bug notification because you are subscribed to a
> duplicate bug report (1680988).
> https:/
>
> Title:
> postinst fails when daemon is not running (or is disabled by policy-
> rc.d)
>
> To manage notifications about this bug go to:
> https:/
> 1592669/
>