[mythtv-users] How to repair mysql?

UB40D ub40dd at googlemail.com
Sun Mar 10 09:10:10 UTC 2013 

Thanks Igor.

On Sun, Mar 10, 2013 at 12:01 AM, Igor Cicimov <icicimov at gmail.com> wrote:

> Run
> # dpkg -P mysql-server-5.5
> to completely remove the package. When told some package depends on it
> then include that one too in the above command. Then install all of them
> again.
>

*************************
Did that. The "completely remove" part worked without complaints; the
"install all of them again" failed. See below.
*************************


# dpkg -P mysql-server-5.5
(Reading database ... 322177 files and directories currently installed.)
Removing mysql-server-5.5 ...
Purging configuration files for mysql-server-5.5 ...
Processing triggers for man-db ...
Processing triggers for ureadahead ...


# dpkg -l mysql-server mysql-server-5.5 apparmor
Desired=Unknown/Install/Remove/Purge/Hold
|
Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name           Version      Architecture Description
+++-==============-============-============-=================================
ii  apparmor       2.8.0-0ubunt amd64        User-space parser utility for
App
iU  mysql-server   5.5.29-0ubun all          MySQL database server
(metapackag
un  mysql-server-5 <none>                    (no description available)

# apt-get install mysql-server mysql-server-5.5
Reading package lists... Done
Building dependency tree
Reading state information... Done
mysql-server is already the newest version.
Suggested packages:
  tinyca mailx
The following NEW packages will be installed:
  mysql-server-5.5
0 upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
1 not fully installed or removed.
Need to get 0 B/8,839 kB of archives.
After this operation, 32.7 MB of additional disk space will be used.
Do you want to continue [Y/n]?
Preconfiguring packages ...
Selecting previously unselected package mysql-server-5.5.
(Reading database ... 322093 files and directories currently installed.)
Unpacking mysql-server-5.5 (from
.../mysql-server-5.5_5.5.29-0ubuntu0.12.10.1_amd64.deb) ...
Processing triggers for ureadahead ...
Processing triggers for man-db ...
Setting up mysql-server-5.5 (5.5.29-0ubuntu0.12.10.1) ...
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.5 (--configure):
 subprocess installed post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.5; however:
  Package mysql-server-5.5 is not configured yet.

dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured
Processing triggers for ureadahead ...
No apport report written because the error message indicates its a followup
error from a previous failure.
                          Errors were encountered while processing:
 mysql-server-5.5
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)


********************
So next I tried your second suggestion of reinstalling with aptitude (which
itself wasn't there, ok, big deal). Even the process of installing aptitude
complained about mysql-server and mysql-server-5.5, which I found weird!
And then the reinstallation concluded with a mysterious Internal Error, No
file name for mysql-server-5.5:amd64
********************


# aptitude reinstall mysql-server-5.5
The program 'aptitude' is currently not installed. You can install it by
typing:
apt-get install aptitude

# apt-get install aptitude
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
  aptitude-common libcwidget3
Suggested packages:
  aptitude-doc-en aptitude-doc tasksel debtags libcwidget-dev
The following NEW packages will be installed:
  aptitude aptitude-common libcwidget3
0 upgraded, 3 newly installed, 0 to remove and 0 not upgraded.
2 not fully installed or removed.
Need to get 2,459 kB of archives.
After this operation, 10.2 MB of additional disk space will be used.
Do you want to continue [Y/n]?
Get:1 http://gb.archive.ubuntu.com/ubuntu/ quantal/main aptitude-common all
0.6.8.1-2ubuntu1 [669 kB]
Get:2 http://gb.archive.ubuntu.com/ubuntu/ quantal/main libcwidget3 amd64
0.5.16-3.4ubuntu1 [387 kB]
Get:3 http://gb.archive.ubuntu.com/ubuntu/ quantal/main aptitude amd64
0.6.8.1-2ubuntu1 [1,404 kB]
Fetched 2,459 kB in 0s (3,285 kB/s)
Selecting previously unselected package aptitude-common.
(Reading database ... 322178 files and directories currently installed.)
Unpacking aptitude-common (from
.../aptitude-common_0.6.8.1-2ubuntu1_all.deb) ...
Selecting previously unselected package libcwidget3.
Unpacking libcwidget3 (from .../libcwidget3_0.5.16-3.4ubuntu1_amd64.deb) ...
Selecting previously unselected package aptitude.
Unpacking aptitude (from .../aptitude_0.6.8.1-2ubuntu1_amd64.deb) ...
Processing triggers for man-db ...
Processing triggers for menu ...
Setting up mysql-server-5.5 (5.5.29-0ubuntu0.12.10.1) ...
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.5 (--configure):
 subprocess installed post-installation script returned error exit status 1
No apport report written because MaxReports is reached already
                                                              dpkg:
dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-5.5; however:
  Package mysql-server-5.5 is not configured yet.

dpkg: error processing mysql-server (--configure):
 dependency problems - leaving unconfigured
Setting up aptitude-common (0.6.8.1-2ubuntu1) ...
No apport report written because MaxReports is reached already
                                                              Setting up
libcwidget3 (0.5.16-3.4ubuntu1) ...
Setting up aptitude (0.6.8.1-2ubuntu1) ...
update-alternatives: using /usr/bin/aptitude-curses to provide
/usr/bin/aptitude (aptitude) in auto mode
Processing triggers for libc-bin ...
ldconfig deferred processing now taking place
Processing triggers for menu ...
Errors were encountered while processing:
 mysql-server-5.5
 mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

# aptitude reinstall mysql-server-5.5
The following packages will be REINSTALLED:
  mysql-server-5.5
The following partially installed packages will be configured:
  mysql-server
0 packages upgraded, 0 newly installed, 1 reinstalled, 0 to remove and 0
not upgraded.
Need to get 0 B of archives. After unpacking 0 B will be used.
E: Internal Error, No file name for mysql-server-5.5:amd64



**************************
Then, combining both of your alternatives, I went back to removing, with
the first method, both mysql-server and mysql-server.5.5. Seemed to work.
Then I checked. And it strangely denied knowledge of mysql-server-5.5
(?!?!). An apt-get update didn't help either.
**************************

# dpkg -P mysql-server-5.5 mysql-server
(Reading database ... 322308 files and directories currently installed.)
Removing mysql-server-5.5 ...
Purging configuration files for mysql-server-5.5 ...
Removing mysql-server ...
Processing triggers for man-db ...
Processing triggers for ureadahead ...

# dpkg -l mysql-server mysql-server-5.5
Desired=Unknown/Install/Remove/Purge/Hold
|
Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name           Version      Architecture Description
+++-==============-============-============-=================================
un  mysql-server   <none>                    (no description available)
dpkg-query: no packages found matching mysql-server-5.5

# apt-get update
Ign http://gb.archive.ubuntu.com quantal InRelease
Ign http://security.ubuntu.com quantal-security InRelease
Ign http://gb.archive.ubuntu.com quantal-updates InRelease
Ign http://gb.archive.ubuntu.com quantal-backports InRelease
Get:1 http://security.ubuntu.com quantal-security Release.gpg [933 B]
Hit http://gb.archive.ubuntu.com quantal Release.gpg
Get:2 http://security.ubuntu.com quantal-security Release [49.6 kB]
Get:3 http://gb.archive.ubuntu.com quantal-updates Release.gpg [933 B]
Get:4 http://gb.archive.ubuntu.com quantal-backports Release.gpg [933 B]
Hit http://gb.archive.ubuntu.com quantal Release
Get:5 http://gb.archive.ubuntu.com quantal-updates Release [49.6
kB]
Get:6 http://security.ubuntu.com quantal-security/main Sources [34.8 kB]
Get:7 http://gb.archive.ubuntu.com quantal-backports Release [49.6
kB]
Get:8 http://security.ubuntu.com quantal-security/restricted Sources [14
B]
Hit http://gb.archive.ubuntu.com quantal/main Sources
Get:9 http://security.ubuntu.com quantal-security/universe Sources [15.4 kB]
Hit http://gb.archive.ubuntu.com quantal/restricted Sources
Hit http://gb.archive.ubuntu.com quantal/universe Sources
Get:10 http://security.ubuntu.com quantal-security/multiverse Sources [700
B]
Hit http://gb.archive.ubuntu.com quantal/multiverse Sources
Hit http://gb.archive.ubuntu.com quantal/main amd64 Packages
Get:11 http://security.ubuntu.com quantal-security/main amd64 Packages
[93.1 kB]
Hit http://gb.archive.ubuntu.com quantal/restricted amd64 Packages
Hit http://gb.archive.ubuntu.com quantal/universe amd64 Packages
Hit http://gb.archive.ubuntu.com quantal/multiverse amd64 Packages
Get:12 http://security.ubuntu.com quantal-security/restricted amd64
Packages [14 B]
Get:13 http://security.ubuntu.com quantal-security/universe amd64 Packages
[41.9 kB]
Hit http://gb.archive.ubuntu.com quantal/main i386 Packages
Hit http://gb.archive.ubuntu.com quantal/restricted i386 Packages
Get:14 http://security.ubuntu.com quantal-security/multiverse amd64
Packages [1,155 B]
Hit http://gb.archive.ubuntu.com quantal/universe i386 Packages
Get:15 http://security.ubuntu.com quantal-security/main i386 Packages [92.6
kB]
Hit http://gb.archive.ubuntu.com quantal/multiverse i386 Packages
Hit http://gb.archive.ubuntu.com quantal/main Translation-en_GB
Hit http://gb.archive.ubuntu.com quantal/main Translation-en
Hit http://gb.archive.ubuntu.com quantal/multiverse Translation-en_GB
Get:16 http://security.ubuntu.com quantal-security/restricted i386 Packages
[14 B]
Hit http://gb.archive.ubuntu.com quantal/multiverse
Translation-en
Hit http://gb.archive.ubuntu.com quantal/restricted Translation-en_GB
Get:17 http://security.ubuntu.com quantal-security/universe i386 Packages
[42.5 kB]
Hit http://gb.archive.ubuntu.com quantal/restricted Translation-en
Hit http://gb.archive.ubuntu.com quantal/universe Translation-en_GB
Get:18 http://security.ubuntu.com quantal-security/multiverse i386 Packages
[1,397 B]
Hit http://gb.archive.ubuntu.com quantal/universe Translation-en
Get:19 http://gb.archive.ubuntu.com quantal-updates/main Sources [82.0 kB]
Get:20 http://gb.archive.ubuntu.com quantal-updates/restricted Sources
[1,302 B]
Get:21 http://gb.archive.ubuntu.com quantal-updates/universe Sources [79.7
kB]
Hit http://security.ubuntu.com quantal-security/main Translation-en
Get:22 http://gb.archive.ubuntu.com quantal-updates/multiverse Sources
[2,932 B]
Hit http://security.ubuntu.com quantal-security/multiverse
Translation-en
Hit http://security.ubuntu.com quantal-security/restricted Translation-en
Get:23 http://gb.archive.ubuntu.com quantal-updates/main amd64 Packages
[213 kB]
Hit http://security.ubuntu.com quantal-security/universe Translation-en
Get:24 http://gb.archive.ubuntu.com quantal-updates/restricted amd64
Packages [3,048 B]
Get:25 http://gb.archive.ubuntu.com quantal-updates/universe amd64 Packages
[170 kB]
Get:26 http://gb.archive.ubuntu.com quantal-updates/multiverse amd64
Packages [7,938 B]
Get:27 http://gb.archive.ubuntu.com quantal-updates/main i386 Packages [211
kB]
Get:28 http://gb.archive.ubuntu.com quantal-updates/restricted i386
Packages [3,067 B]
Get:29 http://gb.archive.ubuntu.com quantal-updates/universe i386 Packages
[171 kB]
Get:30 http://gb.archive.ubuntu.com quantal-updates/multiverse i386
Packages [8,109 B]
Hit http://gb.archive.ubuntu.com quantal-updates/main
Translation-en
Hit http://gb.archive.ubuntu.com quantal-updates/multiverse Translation-en
Hit http://gb.archive.ubuntu.com quantal-updates/restricted Translation-en
Hit http://gb.archive.ubuntu.com quantal-updates/universe Translation-en
Ign http://security.ubuntu.com quantal-security/main Translation-en_GB
Ign http://security.ubuntu.com quantal-security/multiverse Translation-en_GB
Ign http://security.ubuntu.com quantal-security/restricted Translation-en_GB
Ign http://security.ubuntu.com quantal-security/universe Translation-en_GB
Get:31 http://gb.archive.ubuntu.com quantal-backports/main Sources [14 B]
Get:32 http://gb.archive.ubuntu.com quantal-backports/restricted Sources
[14 B]
Get:33 http://gb.archive.ubuntu.com quantal-backports/universe Sources
[7,750 B]
Get:34 http://gb.archive.ubuntu.com quantal-backports/multiverse Sources
[781 B]
Get:35 http://gb.archive.ubuntu.com quantal-backports/main amd64 Packages
[14 B]
Get:36 http://gb.archive.ubuntu.com quantal-backports/restricted amd64
Packages [14 B]
Get:37 http://gb.archive.ubuntu.com quantal-backports/universe amd64
Packages [11.6 kB]
Get:38 http://gb.archive.ubuntu.com quantal-backports/multiverse amd64
Packages [1,118 B]
Get:39 http://gb.archive.ubuntu.com quantal-backports/main i386 Packages
[14 B]
Get:40 http://gb.archive.ubuntu.com quantal-backports/restricted i386
Packages [14 B]
Get:41 http://gb.archive.ubuntu.com quantal-backports/universe i386
Packages [12.4 kB]
Get:42 http://gb.archive.ubuntu.com quantal-backports/multiverse i386
Packages [1,118 B]
Hit http://gb.archive.ubuntu.com quantal-backports/main Translation-en
Hit http://gb.archive.ubuntu.com quantal-backports/multiverse Translation-en
Hit http://gb.archive.ubuntu.com quantal-backports/restricted Translation-en
Hit http://gb.archive.ubuntu.com quantal-backports/universe Translation-en
Ign http://gb.archive.ubuntu.com quantal-updates/main Translation-en_GB
Ign http://gb.archive.ubuntu.com quantal-updates/multiverse
Translation-en_GB
Ign http://gb.archive.ubuntu.com quantal-updates/restricted
Translation-en_GB
Ign http://gb.archive.ubuntu.com quantal-updates/universe Translation-en_GB
Ign http://gb.archive.ubuntu.com quantal-backports/main Translation-en_GB
Ign http://gb.archive.ubuntu.com quantal-backports/multiverse
Translation-en_GB
Ign http://gb.archive.ubuntu.com quantal-backports/restricted
Translation-en_GB
Ign http://gb.archive.ubuntu.com quantal-backports/universe
Translation-en_GB
Fetched 1,464 kB in 1s (753 kB/s)
Reading package lists... Done

# dpkg -l mysql-server mysql-server-5.5
Desired=Unknown/Install/Remove/Purge/Hold
|
Status=Not/Inst/Conf-files/Unpacked/halF-conf/Half-inst/trig-aWait/Trig-pend
|/ Err?=(none)/Reinst-required (Status,Err: uppercase=bad)
||/ Name           Version      Architecture Description
+++-==============-============-============-=================================
un  mysql-server   <none>                    (no description available)
dpkg-query: no packages found matching mysql-server-5.5


***************************
What's wrong here? Surely mysql-server-5.5 exists for amd64, since it was
working until last week on this system... Anything else I can try?
***************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.mythtv.org/pipermail/mythtv-users/attachments/20130310/f6b56a5c/attachment.html>

More information about the mythtv-users mailing list