package mysql-server None [modified: /var/lib/dpkg/info/mysql-server.list] failed to install/upgrade: subprocess pre-installation script returned error exit status 1

[Charles Marslett]

The installation was triggered as a requirement for installing mythtv.

The package version was mysql-server 5.0.51a-3ubuntu5.1.

After manually initializing the files and mythtv (which sort of worked - I had to do a "sudo bash" to get the password prompt from the "mysql" command to work, from a # prompt), repeating the install appears to work.

ProblemType: Package
Architecture: i386
Date: Thu Jun 12 18:31:39 2008
Dependencies:

DistroRelease: Ubuntu 8.04.1
ErrorMessage: subprocess pre-installation script returned error exit status 1
Package: mysql-server None [modified: /var/lib/dpkg/info/mysql-server.list]
PackageArchitecture: all
SourcePackage: mysql-dfsg-5.0
Title: package mysql-server None [modified: /var/lib/dpkg/info/mysql-server.list] failed to install/upgrade: subprocess pre-installation script returned error exit status 1
Uname: Linux 2.6.24-19-generic i686

[Mathias Gug (mathiaz)]

Hi Charles,

On Fri, Jun 13, 2008 at 02:22:40AM -0000, Charles Marslett wrote:
>

Could you have a look in /var/log/daemon.log ? There should be more
information about the stop failure MySQL.

  status incomplete

Thank you,

--
Mathias Gug
Ubuntu Developer http://www.ubuntu.com

[Charles Marslett (charles-marslett)]

Mathias Gug wrote:
> Hi Charles,
>
> On Fri, Jun 13, 2008 at 02:22:40AM -0000, Charles Marslett wrote:
>
> Could you have a look in /var/log/daemon.log ? There should be more
> information about the stop failure MySQL.
>
> status incomplete
>
> Thank you,

There does not appear to be a whole lot of additional information about
the failure. I captured the entire /var/log/daemon.log file around the
times of the failure and the subsequent successful reinstall (I think)
just in case some line without "mysql" might be significant.

This might have been my third retry to get mythtv up and running. The
first time I actually got it to work but after a reboot it could not
access the database. I finally did a "Mark for Complete Removal"
removal from the Synaptic Package Manager before this install to repeat
the problem.

About 5 hours between the last log entry before this one, so this is
probaby a startup:

Jun 12 17:57:27 i6000 NetworkManager: <info> starting...
Jun 12 17:57:28 i6000 avahi-daemon[5255]: Found user 'avahi' (UID 108)
and group 'avahi' (GID 119).
Jun 12 17:57:28 i6000 avahi-daemon[5255]: Successfully dropped root
privileges.
Jun 12 17:57:28 i6000 avahi-daemon[5255]: avahi-daemon 0.6.22 starting up.
Jun 12 17:57:28 i6000 avahi-daemon[5255]: Successfully called chroot().
Jun 12 17:57:28 i6000 avahi-daemon[5255]: Successfully dropped remaining
capabilities.
Jun 12 17:57:28 i6000 avahi-daemon[5255]: No service file found in
/etc/avahi/services.
Jun 12 17:57:28 i6000 avahi-daemon[5255]: Joining mDNS multicast group
on interface eth0.IPv4 with address 192.168.1.5.
Jun 12 17:57:28 i6000 avahi-daemon[5255]: New relevant interface
eth0.IPv4 for mDNS.
Jun 12 17:57:28 i6000 avahi-daemon[5255]: Network interface enumeration
completed.
Jun 12 17:57:28 i6000 avahi-daemon[5255]: Registering new address record
for 192.168.1.5 on eth0.IPv4.
Jun 12 17:57:28 i6000 avahi-daemon[5255]: Registering HINFO record with
values 'I686'/'LINUX'.
Jun 12 17:57:29 i6000 avahi-daemon[5255]: Server startup complete. Host
name is i6000.local. Local service cookie is 118613902.
Jun 12 17:57:28 i6000 ntpdate[4122]: step time server 91.189.94.4 offset
-0.379633 sec
Jun 12 17:57:29 i6000 ntpd[5353]: ntpd 4.2.4p4@1.1520-o Fri Mar 7
20:24:07 UTC 2008 (1)
Jun 12 17:57:29 i6000 ntpd[5358]: precision = 1.000 usec
Jun 12 17:57:29 i6000 ntpd[5358]: Listening on interface #0 wildcard,
0.0.0.0#123 Disabled
Jun 12 17:57:29 i6000 ntpd[5358]: Listening on interface #1 lo,
127.0.0.1#123 Enabled
Jun 12 17:57:29 i6000 ntpd[5358]: Listening on interface #2 eth0,
192.168.1.5#123 Enabled
Jun 12 17:57:29 i6000 ntpd[5358]: kernel time sync status 0040
Jun 12 17:57:29 i6000 ntpd[5358]: frequency initialized -39.225 PPM from
/var/lib/ntp/ntp.drift
Jun 12 17:57:29 i6000 ntpd[5358]: getaddrinfo: "::1" invalid host
address, ignored

Here is the first "mysql" grepped in the daemon.log file:

Jun 12 17:57:30 i6000 mysqld_safe[5432]: started
Jun 12 17:57:30 i6000 mysqld[5436]: 080612 17:57:30 InnoDB: Started;
log sequence number 0 43655
Jun 12 17:57:30 i6000 mysqld[5436]: 080612 17:57:30 [Note]
/usr/sbin/mysqld: ready for connections.
Jun 12 17:57:30 i6000 mysqld[5436]: Version: '5.0.51a-3...

[zig59 (zig-59)]

I have got the above message installing mythtv (frontend & backend) from Add/Remove Applications on Ubuntu 8.10 Intrepid desktop 32bit.
Have attached /var/log/daemon.log, there does not appear to be anything relevant in the log prior to this.

[Charles Marslett (charles-marslett)]

I attempted to reproduce the problem when I upgraded to Intrepid (clean install on a new, larger hard drive), and I did not have any issues.

Installed: hdhomerun-config [0.20080430].
And verified that I could scan channels and watch a channel on VLC using it.

Installed: libgmyth0 [1:0.7.1-1], libmyth-0.21-0 [18722], libmyth-perl [18722], mythtv [18722], mythtv-backend [18722], mythtv-common [18722], mythtv-database [18722], mythtv-frontend [18722], mythtv-theme-blootube* [1:0.21.0-0], mythtv-theme-glass-wide [0.20080908-0], mythtv-theme-gray-osd, mythtv-theme-isthmus, mythtv-theme-iulius*, mythtv-theme-metallurgy*, mythtv-theme-myth*, mythtv-theme-project*, mythtv-theme-retro*, mythtv-theme-titivillus*, mythtv-transcode-utils [18722].

[One possible change, I may have had mysql installed before mythtv before and not this time.]

Then I executed these commands in this order (order may have been different before?):
sudo adduser me mythtv
mythtv-setup
sudo /etc/init.d/mythtv-backend start
Then brought up the front end form the App menu and all worked.

[One command failed because I forgot to log out and back in so I would show up in the mythtv group - I did that and continued.]

... Perhaps the issue is fixed, or perhaps it is related to something I did (slightly) differently ...

[[e-mail] (dhk-natureair)]

"I had to do a "sudo bash" to get the password prompt from the "mysql" command to work, from a # prompt), repeating the install appears to work."

Can somebody enplane the above in a layman's process so I can get this fixed on my machine? It seems like it worked. I am trying to avoid doing fresh installs as I don't want to act like I am using Winslows!

[xteejx (xteejx)]

Thank you for taking the time to report this bug and helping to make Ubuntu better. We are sorry that we do not always have the capacity to look at all reported bugs in a timely manner.
There have been many changes in Ubuntu since that time you reported the bug and your problem may have been fixed with some of the updates. It would help us a lot if you could test the current Ubuntu version (10.04). If you can test it, and it is still an issue, we would appreciate if you could upload updated logs by running apport-collect <bug #>, and any other logs that are relevant for this particular issue.

[xteejx (xteejx)]

We are closing this bug report because it lacks the information we need to investigate the problem, as described in the previous comments. Please reopen it if you can give us the missing information, and don't hesitate to submit bug reports in the future. To reopen the bug report you can click on the current status, under the Status column, and change the Status back to "New". Thanks again!