package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade: subprocess new pre-installation script returned error exit status 1

Thanks for reporting this bug and helping to make ubuntu better.

The dpkg log shows that it wanted to stop mysql, but wasn't sure how. So
it asked you to stop mysql yourself, then retry the upgrade.

Could you please post here the result of

    'ps -ef | grep mysql'

? Then do a 'stop mysql' and re-try the upgrade.

Thanks Serge,

I rebooted the computer fixing the package with the --configure -a as the
package manager requested.
I have managed to apply all the upgrades that the upgrade manager required
except the mysql 5.1 upgrade. And rebooted again.

I attempted to do the mysql upgrade separately. After 24 hours it still
sits at the same spot as described in the bug report.

I rebooted again, ran synaptic package manager, fixed it as usual, ran it
again then attempted to uninstall mysql, thinking that might be simpler. -
it will not let me uninstall. Yen when i attempt the upgrade it tells me it
would be better if i uninstalled it and reinstalled, which i cannot do.

I do want to keep my settings because i use mysql for some great apps like
SugarCRM, but i have so far been going in circles with the
upgrade/uninstall/reinstall.

Best regards,

Duncan

On Wed, Sep 1, 2010 at 4:41 PM, Serge Hallyn <email address hidden>wrote:

> Thanks for reporting this bug and helping to make ubuntu better.
>
> The dpkg log shows that it wanted to stop mysql, but wasn't sure how. So
> it asked you to stop mysql yourself, then retry the upgrade.
>
> Could you please post here the result of
>
> 'ps -ef | grep mysql'
>
> ? Then do a 'stop mysql' and re-try the upgrade.
>
> ** Changed in: mysql-dfsg-5.1 (Ubuntu)
> Importance: Undecided => Medium
>
> ** Changed in: mysql-dfsg-5.1 (Ubuntu)
> Status: New => Incomplete
>
> --
> package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade:
> subprocess new pre-installation script returned error exit status 1
> https://bugs.launchpad.net/bugs/627723
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in “mysql-dfsg-5.1” package in Ubuntu: Incomplete
>
> Bug description:
> Update manager tried to update MySQL, but crashes
> Gets as far as "Preparing to replace MySQL...."
> Then nothing
>
> ProblemType: Package
> DistroRelease: Ubuntu 10.04
> Package: mysql-server-5.1 5.1.41-3ubuntu12.3
> ProcVersionSignature: Ubuntu 2.6.32-24.42-generic 2.6.32.15+drm33.5
> Uname: Linux 2.6.32-24-generic x86_64
> NonfreeKernelModules: nvidia
> Architecture: amd64
> Date: Tue Aug 31 16:31:14 2010
> ErrorMessage: subprocess new pre-installation script returned error exit
> status 1
> Logs.var.log.daemon.log:
>
> Logs.var.log.kern.log:
> Aug 30 19:29:14 ivan kernel: [ 36.788557] type=1505
> audit(1283210954.163:5): operation="profile_load" pid=934
> name="/usr/sbin/mysqld"
> Aug 31 16:22:07 ivan kernel: [ 39.756658] type=1505
> audit(1283286127.133:10): operation="profile_load" pid=954
> name="/usr/sbin/mysqld"
> Aug 31 16:37:07 ivan kernel: [ 21.875719] type=1505
> audit(1283287027.253:5): operation="profile_load" pid=911
> name="/usr/sbin/mysqld"
> Aug 31 19:45:26 ivan kernel: [ 25.621957] type=1505
> audit(1283298326.015:5): operation="profile_load" pid=929
> name="/usr/sbin/mysqld"
> MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
> [mysqld_safe]
> syslog
> MySQLVarLibDirListing: ['debian-5.1.flag', 'ibdata1', 'mysql_upgrade_info',
> 'ib_logfile1', 'phpmyadmin', 'mysql', 'EnGen', 'sugarcrm', 'ib_logfile0',
> 'debian-5.0.flag']
> SourcePackage: mysql-df...

Attached are the snapshots in the hope they will be helpful

Best regards.

Duncan

On Wed, Sep 1, 2010 at 4:41 PM, Serge Hallyn <email address hidden>wrote:

> Thanks for reporting this bug and helping to make ubuntu better.
>
> The dpkg log shows that it wanted to stop mysql, but wasn't sure how. So
> it asked you to stop mysql yourself, then retry the upgrade.
>
> Could you please post here the result of
>
> 'ps -ef | grep mysql'
>
> ? Then do a 'stop mysql' and re-try the upgrade.
>
> ** Changed in: mysql-dfsg-5.1 (Ubuntu)
> Importance: Undecided => Medium
>
> ** Changed in: mysql-dfsg-5.1 (Ubuntu)
> Status: New => Incomplete
>
> --
> package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade:
> subprocess new pre-installation script returned error exit status 1
> https://bugs.launchpad.net/bugs/627723
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in “mysql-dfsg-5.1” package in Ubuntu: Incomplete
>
> Bug description:
> Update manager tried to update MySQL, but crashes
> Gets as far as "Preparing to replace MySQL...."
> Then nothing
>
> ProblemType: Package
> DistroRelease: Ubuntu 10.04
> Package: mysql-server-5.1 5.1.41-3ubuntu12.3
> ProcVersionSignature: Ubuntu 2.6.32-24.42-generic 2.6.32.15+drm33.5
> Uname: Linux 2.6.32-24-generic x86_64
> NonfreeKernelModules: nvidia
> Architecture: amd64
> Date: Tue Aug 31 16:31:14 2010
> ErrorMessage: subprocess new pre-installation script returned error exit
> status 1
> Logs.var.log.daemon.log:
>
> Logs.var.log.kern.log:
> Aug 30 19:29:14 ivan kernel: [ 36.788557] type=1505
> audit(1283210954.163:5): operation="profile_load" pid=934
> name="/usr/sbin/mysqld"
> Aug 31 16:22:07 ivan kernel: [ 39.756658] type=1505
> audit(1283286127.133:10): operation="profile_load" pid=954
> name="/usr/sbin/mysqld"
> Aug 31 16:37:07 ivan kernel: [ 21.875719] type=1505
> audit(1283287027.253:5): operation="profile_load" pid=911
> name="/usr/sbin/mysqld"
> Aug 31 19:45:26 ivan kernel: [ 25.621957] type=1505
> audit(1283298326.015:5): operation="profile_load" pid=929
> name="/usr/sbin/mysqld"
> MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
> [mysqld_safe]
> syslog
> MySQLVarLibDirListing: ['debian-5.1.flag', 'ibdata1', 'mysql_upgrade_info',
> 'ib_logfile1', 'phpmyadmin', 'mysql', 'EnGen', 'sugarcrm', 'ib_logfile0',
> 'debian-5.0.flag']
> SourcePackage: mysql-dfsg-5.1
> Title: package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to
> install/upgrade: subprocess new pre-installation script returned error exit
> status 1
>
> To unsubscribe from this bug, go to:
>
> https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/627723/+subscribe
>

Looking at https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/574557 ,
could you try

    start mysql

to see if that'll kick your upgrade process?

Also, I still would like to see the output of
    ps -ef
(before and after you do 'start mysql')

Sorry. I apologise for not including these last time.

start: Job is already running: mysql

Duncan

On Thu, Sep 2, 2010 at 10:37 AM, Serge Hallyn <email address hidden>wrote:

> Looking at
> https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/574557 ,
> could you try
>
> start mysql
>
> to see if that'll kick your upgrade process?
>
> Also, I still would like to see the output of
> ps -ef
> (before and after you do 'start mysql')
>
> --
> package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade:
> subprocess new pre-installation script returned error exit status 1
> https://bugs.launchpad.net/bugs/627723
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in “mysql-dfsg-5.1” package in Ubuntu: Incomplete
>
> Bug description:
> Update manager tried to update MySQL, but crashes
> Gets as far as "Preparing to replace MySQL...."
> Then nothing
>
> ProblemType: Package
> DistroRelease: Ubuntu 10.04
> Package: mysql-server-5.1 5.1.41-3ubuntu12.3
> ProcVersionSignature: Ubuntu 2.6.32-24.42-generic 2.6.32.15+drm33.5
> Uname: Linux 2.6.32-24-generic x86_64
> NonfreeKernelModules: nvidia
> Architecture: amd64
> Date: Tue Aug 31 16:31:14 2010
> ErrorMessage: subprocess new pre-installation script returned error exit
> status 1
> Logs.var.log.daemon.log:
>
> Logs.var.log.kern.log:
> Aug 30 19:29:14 ivan kernel: [ 36.788557] type=1505
> audit(1283210954.163:5): operation="profile_load" pid=934
> name="/usr/sbin/mysqld"
> Aug 31 16:22:07 ivan kernel: [ 39.756658] type=1505
> audit(1283286127.133:10): operation="profile_load" pid=954
> name="/usr/sbin/mysqld"
> Aug 31 16:37:07 ivan kernel: [ 21.875719] type=1505
> audit(1283287027.253:5): operation="profile_load" pid=911
> name="/usr/sbin/mysqld"
> Aug 31 19:45:26 ivan kernel: [ 25.621957] type=1505
> audit(1283298326.015:5): operation="profile_load" pid=929
> name="/usr/sbin/mysqld"
> MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
> [mysqld_safe]
> syslog
> MySQLVarLibDirListing: ['debian-5.1.flag', 'ibdata1', 'mysql_upgrade_info',
> 'ib_logfile1', 'phpmyadmin', 'mysql', 'EnGen', 'sugarcrm', 'ib_logfile0',
> 'debian-5.0.flag']
> SourcePackage: mysql-dfsg-5.1
> Title: package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to
> install/upgrade: subprocess new pre-installation script returned error exit
> status 1
>
> To unsubscribe from this bug, go to:
>
> https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/627723/+subscribe
>

And if you just run it by hand, i.e.:

    /usr/sbin/mysqld

does a subsequent

   ps -ef | grep mysqld

show it running?

I'm encountering a similar enough problem that I think it is the same. Fresh Ubuntu 10.04 server, installing mysql-server-5.1_5.1.41-3ubuntu12_amd64.deb (and dependencies) from official repos, the install seemed to work but mysql doesn't start. 'start mysql' just shows "start: Job failed to start"

On the other hand, `sudo -umysql /usr/sbin/mysqld` starts it with no errors. How can I better troubleshoot the service's issues?

Hi Serge,

Since i could not uninstall, i could not reinstall, and i could not upgrade,
I decided to be bold and break the installation much more severely in the
hope that it would trigger a more effective repair/reinstall.

I renamed /usr/bin/mysql; /usr/bin/mysqladmin; /usr/lib/mysql;
/usr/sbin/mysqld; /usr/sbin/mysqld-akonadi; /usr/sbin/mysqlmanager

Restarted the computer.

Immediately it ran the package manager and reinstalled the mysql package.

Problem solved, and no additional configuration was required to return the
SugarCRM or other mssql dependent packages to full operation.

Best regards,

Duncan

On Tue, Sep 7, 2010 at 12:32 AM, Serge Hallyn <email address hidden>wrote:

> And if you just run it by hand, i.e.:
>
> /usr/sbin/mysqld
>
> does a subsequent
>
> ps -ef | grep mysqld
>
> show it running?
>
> --
> package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to install/upgrade:
> subprocess new pre-installation script returned error exit status 1
> https://bugs.launchpad.net/bugs/627723
> You received this bug notification because you are a direct subscriber
> of the bug.
>
> Status in “mysql-dfsg-5.1” package in Ubuntu: Incomplete
>
> Bug description:
> Update manager tried to update MySQL, but crashes
> Gets as far as "Preparing to replace MySQL...."
> Then nothing
>
> ProblemType: Package
> DistroRelease: Ubuntu 10.04
> Package: mysql-server-5.1 5.1.41-3ubuntu12.3
> ProcVersionSignature: Ubuntu 2.6.32-24.42-generic 2.6.32.15+drm33.5
> Uname: Linux 2.6.32-24-generic x86_64
> NonfreeKernelModules: nvidia
> Architecture: amd64
> Date: Tue Aug 31 16:31:14 2010
> ErrorMessage: subprocess new pre-installation script returned error exit
> status 1
> Logs.var.log.daemon.log:
>
> Logs.var.log.kern.log:
> Aug 30 19:29:14 ivan kernel: [ 36.788557] type=1505
> audit(1283210954.163:5): operation="profile_load" pid=934
> name="/usr/sbin/mysqld"
> Aug 31 16:22:07 ivan kernel: [ 39.756658] type=1505
> audit(1283286127.133:10): operation="profile_load" pid=954
> name="/usr/sbin/mysqld"
> Aug 31 16:37:07 ivan kernel: [ 21.875719] type=1505
> audit(1283287027.253:5): operation="profile_load" pid=911
> name="/usr/sbin/mysqld"
> Aug 31 19:45:26 ivan kernel: [ 25.621957] type=1505
> audit(1283298326.015:5): operation="profile_load" pid=929
> name="/usr/sbin/mysqld"
> MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
> [mysqld_safe]
> syslog
> MySQLVarLibDirListing: ['debian-5.1.flag', 'ibdata1', 'mysql_upgrade_info',
> 'ib_logfile1', 'phpmyadmin', 'mysql', 'EnGen', 'sugarcrm', 'ib_logfile0',
> 'debian-5.0.flag']
> SourcePackage: mysql-dfsg-5.1
> Title: package mysql-server-5.1 5.1.41-3ubuntu12.3 failed to
> install/upgrade: subprocess new pre-installation script returned error exit
> status 1
>
> To unsubscribe from this bug, go to:
>
> https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/627723/+subscribe
>

Neat idea, thanks for the update!

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