package mysql-server-5.6 5.6.19-0ubuntu0.14.04.1 failed to install/upgrade: subprocess installed post-installation script returned error exit status 1
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-5.6 (Ubuntu) |
Expired
|
Undecided
|
Unassigned |
Bug Description
I did some work for a guy, building a DB up on the cloud. The work was successful and after he didn't need the service any more, he asked me if he could get a copy of the data. I looked and about all I could do was create a 5.6 server locally and then push the data to it from the cloud server. I've never been able to get the MySQL 5.6 server to load properly. The guy has been very patient for the last six months. And my cloud contract will be running out in March 2015. I thought for sure Ubuntu would be able to get it loaded before now. Obviously, I'm wrong and I should have been taking a closer look all this time.
Here is a screen capture of when I tried loading it just now. Can you advise me where I might look to find what I'm doing wrong?
Thank You!
$ lsb_release -rd
Description: Ubuntu 14.04.1 LTS
Release: 14.04
$ apt-cache policy mysql-server-5.6
mysql-server-5.6:
Installed: 5.6.19-
Candidate: 5.6.19-
Version table:
*** 5.6.19-
500 http://
500 http://
100 /var/lib/
5.6.16-1~exp1 0
500 http://
Could this be a 64 bit vs 32 bit issue?
I saw an error go by about a script that did not have a variable set before it was used.
$ sudo apt-get upgrade mysql-server-5.6
[sudo] password for tlm:
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
mysql-server-5.6 is already the newest version.
The following packages have been kept back:
gnuplot-nox gnuplot-x11
The following packages will be upgraded:
compiz compiz-core compiz-gnome compiz-plugins compiz-
compiz-
compizconfig-
libunity-
unity-2d-common unity-2d-panel unity-2d-shell unity-2d-spread unity-services
20 upgraded, 0 newly installed, 0 to remove and 2 not upgraded.
1 not fully installed or removed.
Need to get 5,863 kB of archives.
After this operation, 102 kB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://
Get:2 http://
Get:3 http://
Get:4 http://
Get:5 http://
Get:6 http://
Get:7 http://
Get:8 http://
Get:9 http://
Get:10 http://
Get:11 http://
Get:12 http://
Get:13 http://
Get:14 http://
Get:15 http://
Get:16 http://
Get:17 http://
Get:18 http://
Get:19 http://
Get:20 http://
Fetched 5,863 kB in 38s (152 kB/s)
(Reading database ... 1376556 files and directories currently installed.)
Preparing to unpack .../libcompizco
Unpacking libcompizconfig0 (1:0.9.
Preparing to unpack .../compiz-
Unpacking compiz-gnome (1:0.9.
Preparing to unpack .../compiz-
Unpacking compiz-plugins (1:0.9.
Preparing to unpack .../compiz-
Unpacking compiz-
Preparing to unpack .../libdecorati
Unpacking libdecoration0 (1:0.9.
Preparing to unpack .../compiz-
Unpacking compiz-core (1:0.9.
Preparing to unpack .../compiz_
Unpacking compiz (1:0.9.
Preparing to unpack .../unity_
Unpacking unity (7.2.3+
Preparing to unpack .../libunity-
Unpacking libunity-core-6.0-9 (7.2.3+
Preparing to unpack .../unity-
Unpacking unity-services (7.2.3+
Preparing to unpack .../libunity-
Unpacking libunity-
Preparing to unpack .../unity-
Unpacking unity-2d (7.2.3+
Preparing to unpack .../unity-
Unpacking unity-2d-common (7.2.3+
Preparing to unpack .../unity-
Unpacking unity-2d-panel (7.2.3+
Preparing to unpack .../unity-
Unpacking unity-2d-shell (7.2.3+
Preparing to unpack .../unity-
Unpacking unity-2d-spread (7.2.3+
Preparing to unpack .../compiz-
Unpacking compiz-
Preparing to unpack .../compizconfi
Unpacking compizconfig-
Preparing to unpack .../python-
Unpacking python-compizconfig (1:0.9.
Preparing to unpack .../compizconfi
Unpacking compizconfig-
Processing triggers for libglib2.0-0:amd64 (2.40.2-0ubuntu1) ...
Processing triggers for libglib2.0-0:i386 (2.40.2-0ubuntu1) ...
Processing triggers for gconf2 (3.2.6-0ubuntu2) ...
Processing triggers for man-db (2.6.7.1-1ubuntu1) ...
Processing triggers for bamfdaemon (0.5.1+
Rebuilding /usr/share/
Processing triggers for desktop-file-utils (0.22-1ubuntu1) ...
Processing triggers for mime-support (3.54ubuntu1) ...
Processing triggers for gnome-menus (3.10.1-0ubuntu2) ...
Processing triggers for hicolor-icon-theme (0.13-1) ...
Setting up mysql-server-5.6 (5.6.19-
2014-12-08 22:18:33 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_
2014-12-08 22:18:33 11690 [Note] Plugin 'FEDERATED' is disabled.
2014-12-08 22:18:33 11690 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-12-08 22:18:33 11690 [Note] InnoDB: The InnoDB memory heap is disabled
2014-12-08 22:18:33 11690 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-12-08 22:18:33 11690 [Note] InnoDB: Compressed tables use zlib 1.2.8
2014-12-08 22:18:33 11690 [Note] InnoDB: Using Linux native AIO
2014-12-08 22:18:33 11690 [Note] InnoDB: Using CPU crc32 instructions
2014-12-08 22:18:33 11690 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-12-08 22:18:33 11690 [Note] InnoDB: Completed initialization of buffer pool
2014-12-08 22:18:33 11690 [Note] InnoDB: Highest supported file format is Barracuda.
2014-12-08 22:18:33 11690 [Note] InnoDB: 128 rollback segment(s) are active.
2014-12-08 22:18:33 11690 [Note] InnoDB: Waiting for purge to start
2014-12-08 22:18:33 11690 [Note] InnoDB: 5.6.19 started; log sequence number 1628771
2014-12-08 22:18:33 11690 [Note] Binlog end
2014-12-08 22:18:33 11690 [Note] InnoDB: FTS optimize thread exiting.
2014-12-08 22:18:33 11690 [Note] InnoDB: Starting shutdown...
2014-12-08 22:18:35 11690 [Note] InnoDB: Shutdown completed; log sequence number 1628781
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.6 (--configure):
subprocess installed post-installation script returned error exit status 1
Setting up compiz-core (1:0.9.
Setting up libcompizconfig0 (1:0.9.
Setting up libdecoration0 (1:0.9.
Setting up compiz-
Setting up compiz-gnome (1:0.9.
Setting up compiz-plugins (1:0.9.
Setting up compiz (1:0.9.
Setting up unity-services (7.2.3+
Setting up libunity-core-6.0-9 (7.2.3+
Setting up unity (7.2.3+
Setting up libunity-
Setting up unity-2d (7.2.3+
Setting up unity-2d-common (7.2.3+
Setting up unity-2d-panel (7.2.3+
Setting up unity-2d-shell (7.2.3+
Setting up unity-2d-spread (7.2.3+
Setting up compiz-
Setting up compizconfig-
Setting up python-compizconfig (1:0.9.
Setting up compizconfig-
Processing triggers for libc-bin (2.19-0ubuntu6.4) ...
Errors were encountered while processing:
mysql-server-5.6
E: Sub-process /usr/bin/dpkg returned an error code (1)
$
$ grep audit /var/log/kern.log |more
Dec 7 20:29:51 sariah kernel: [46567.454139] type=1400 audit(141800939
Dec 7 20:29:51 sariah kernel: [46567.454147] type=1400 audit(141800939
Dec 7 20:29:51 sariah kernel: [46567.454191] type=1400 audit(141800939
Dec 7 20:29:51 sariah kernel: [46567.454196] type=1400 audit(141800939
Dec 7 21:14:54 sariah kernel: [49269.266304] type=1400 audit(141801209
Dec 7 21:14:54 sariah kernel: [49269.266312] type=1400 audit(141801209
Dec 7 21:14:54 sariah kernel: [49269.266354] type=1400 audit(141801209
Dec 7 21:14:54 sariah kernel: [49269.266358] type=1400 audit(141801209
Dec 7 21:24:36 sariah kernel: [49850.667606] type=1400 audit(141801267
Dec 7 21:24:36 sariah kernel: [49850.667615] type=1400 audit(141801267
Dec 7 21:24:36 sariah kernel: [49850.667675] type=1400 audit(141801267
Dec 7 21:24:36 sariah kernel: [49850.667683] type=1400 audit(141801267
Dec 8 09:01:16 sariah kernel: [ 0.685898] audit: initializing netlink socket (disabled)
Dec 8 09:01:16 sariah kernel: [ 0.685907] type=2000 audit(141805445
Dec 8 09:01:16 sariah kernel: [ 22.445036] type=1400 audit(141805447
Dec 8 09:01:16 sariah kernel: [ 22.445042] type=1400 audit(141805447
Dec 8 09:01:16 sariah kernel: [ 22.445416] type=1400 audit(141805447
Dec 8 09:01:16 sariah kernel: [ 22.616858] type=1400 audit(141805447
Dec 8 09:01:16 sariah kernel: [ 22.616866] type=1400 audit(141805447
Dec 8 09:01:16 sariah kernel: [ 22.616871] type=1400 audit(141805447
Dec 8 09:01:16 sariah kernel: [ 22.617406] type=1400 audit(141805447
Dec 8 09:01:16 sariah kernel: [ 22.617412] type=1400 audit(141805447
Dec 8 09:01:16 sariah kernel: [ 22.617715] type=1400 audit(141805447
Dec 8 09:01:17 sariah kernel: [ 23.586896] type=1400 audit(141805447
Dec 8 09:01:35 sariah kernel: [ 40.288479] audit_printk_skb: 162 callbacks suppressed
Dec 8 09:01:35 sariah kernel: [ 40.288482] type=1400 audit(141805449
=115
Dec 8 09:01:35 sariah kernel: [ 40.289602] type=1400 audit(141805449
Dec 8 09:01:47 sariah kernel: [ 52.497890] type=1400 audit(141805450
Dec 8 09:01:47 sariah kernel: [ 52.497897] type=1400 audit(141805450
Dec 8 09:01:47 sariah kernel: [ 52.498284] type=1400 audit(141805450
Dec 8 09:16:32 sariah kernel: [ 937.520905] type=1400 audit(141805539
Dec 8 09:16:32 sariah kernel: [ 937.520912] type=1400 audit(141805539
Dec 8 09:16:32 sariah kernel: [ 937.521411] type=1400 audit(141805539
$
$ ls -l /etc/apparmor.
-rw-r--r-- 1 root root 1048 Jul 23 2013 /etc/apparmor.
$ cat /etc/apparmor.
# vim:syntax=apparmor
# Last Modified: Tue Jun 19 17:37:30 2007
#include <tunables/global>
/usr/sbin/mysqld {
#include <abstractions/base>
#include <abstractions/
#include <abstractions/
#include <abstractions/
#include <abstractions/
capability dac_override,
capability sys_resource,
capability setgid,
capability setuid,
network tcp,
/etc/hosts.allow r,
/etc/hosts.deny r,
/etc/mysql/*.pem r,
/etc/
/etc/
/etc/mysql/*.cnf r,
/usr/
/usr/
/usr/sbin/mysqld mr,
/usr/
/var/
/var/
/var/lib/mysql/ r,
/var/lib/mysql/** rwk,
/var/log/mysql/ r,
/var/log/mysql/* rw,
/var/
/var/
/run/
/run/
/sys/
# Site-specific additions and overrides. See local/README for details.
#include <local/
}
$
$ ls -l /etc/apparmor.
ls: cannot access /etc/apparmor.
$
$ ls -l /etc/apparmor.
-rw-r--r-- 1 root root 1048 Jul 23 2013 /etc/apparmor.
-rw-r--r-- 1 root root 684 Jan 24 2012 /etc/apparmor.
$
$ cat /etc/mysql/my.cnf
cat: /etc/mysql/my.cnf: No such file or directory
$ ls -l /etc/mysql/conf.d
total 4
-rw-r--r-- 1 root root 375 Jul 21 04:55 my5.6.cnf
$ cat /etc/mysql/
#
# The MySQL 5.6 database server configuration file.
#
# This custom MySQL 5.6 specific configuration file
# adds on top of the existing default my.cnf file at
# - /etc/mysql/my.cnf.
#
# Please add any extra MySQL 5.6 options in this file
# for sake of clarity.
#
# You may uncomment any existing option to enable it
#
# sql_mode=
$
$ sudo ls -l /var/lib/mysql
[sudo] password for tlm:
total 116768
-rw-rw---- 1 mysql mysql 56 Sep 30 22:16 auto.cnf
-rw-r--r-- 1 mysql mysql 0 Sep 30 21:57 debian-5.5.flag
-rw-r--r-- 1 mysql root 0 Dec 8 22:18 debian-5.6.flag
-rw-rw---- 1 mysql mysql 18874368 Dec 8 22:18 ibdata1
-rw-rw---- 1 mysql mysql 50331648 Dec 8 22:18 ib_logfile0
-rw-rw---- 1 mysql mysql 50331648 Sep 30 22:12 ib_logfile1
drwx------ 2 mysql mysql 4096 Sep 30 22:12 mysql
drwx------ 2 mysql mysql 4096 Dec 8 22:18 performance_schema
-rw-r----- 1 mysql mysql 9129 Sep 30 23:13 sariah.err
$
ProblemType: Package
DistroRelease: Ubuntu 14.04
Package: mysql-server-5.6 5.6.19-
ProcVersionSign
Uname: Linux 3.13.0-40-generic x86_64
NonfreeKernelMo
ApportVersion: 2.14.1-0ubuntu3.6
AptOrdering:
libjasper1: Install
libjasper1: Install
mysql-server-5.6: Configure
libjasper1: Configure
libjasper1: Configure
Architecture: amd64
Date: Mon Dec 8 22:06:07 2014
DuplicateSignature: package:
ErrorMessage: subprocess installed post-installation script returned error exit status 1
InstallationDate: Installed on 2012-06-22 (899 days ago)
InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Release amd64 (20120425)
SourcePackage: mysql-5.6
Title: package mysql-server-5.6 5.6.19-
UpgradeStatus: Upgraded to trusty on 2014-08-19 (111 days ago)
modified.
modified.
tags: | removed: need-duplicate-check |
update. Tried again. This time it suggested that I run apt-get install -f. If it had done that before, I missed it. Sorry. Here is the entire output. us.archive. ubuntu. com/ubuntu/ trusty- updates/ universe libssl0.9.8 amd64 0.9.8o- 7ubuntu3. 2.14.04. 1 [692 kB] 9.8_0.9. 8o-7ubuntu3. 2.14.04. 1_amd64. deb ... 7ubuntu3. 2.14.04. 1) ... 0ubuntu0. 14.04.1) ... defaults_ for_timestamp server option (see documentation for more details). 7ubuntu3. 2.14.04. 1) ...
$ sudo apt-get install -f
[sudo] password for tlm:
Reading package lists... Done
Building dependency tree
Reading state information... Done
Correcting dependencies... Done
The following extra packages will be installed:
libssl0.9.8
The following NEW packages will be installed:
libssl0.9.8
0 upgraded, 1 newly installed, 0 to remove and 2 not upgraded.
2 not fully installed or removed.
Need to get 692 kB of archives.
After this operation, 2,445 kB of additional disk space will be used.
Do you want to continue? [Y/n] y
Get:1 http://
Fetched 692 kB in 4s (146 kB/s)
Preconfiguring packages ...
Selecting previously unselected package libssl0.9.8:amd64.
(Reading database ... 1430593 files and directories currently installed.)
Preparing to unpack .../libssl0.
Unpacking libssl0.9.8:amd64 (0.9.8o-
Setting up mysql-server-5.6 (5.6.19-
2014-12-23 21:35:18 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_
2014-12-23 21:35:18 12168 [Note] Plugin 'FEDERATED' is disabled.
2014-12-23 21:35:18 12168 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-12-23 21:35:18 12168 [Note] InnoDB: The InnoDB memory heap is disabled
2014-12-23 21:35:18 12168 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-12-23 21:35:18 12168 [Note] InnoDB: Compressed tables use zlib 1.2.8
2014-12-23 21:35:18 12168 [Note] InnoDB: Using Linux native AIO
2014-12-23 21:35:18 12168 [Note] InnoDB: Using CPU crc32 instructions
2014-12-23 21:35:18 12168 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2014-12-23 21:35:18 12168 [Note] InnoDB: Completed initialization of buffer pool
2014-12-23 21:35:18 12168 [Note] InnoDB: Highest supported file format is Barracuda.
2014-12-23 21:35:18 12168 [Note] InnoDB: 128 rollback segment(s) are active.
2014-12-23 21:35:18 12168 [Note] InnoDB: Waiting for purge to start
2014-12-23 21:35:18 12168 [Note] InnoDB: 5.6.19 started; log sequence number 1629743
2014-12-23 21:35:18 12168 [Note] Binlog end
2014-12-23 21:35:18 12168 [Note] InnoDB: FTS optimize thread exiting.
2014-12-23 21:35:18 12168 [Note] InnoDB: Starting shutdown...
2014-12-23 21:35:20 12168 [Note] InnoDB: Shutdown completed; log sequence number 1629753
start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.6 (--configure):
subprocess installed post-installation script returned error exit status 1
Setting up libssl0.9.8:amd64 (0.9.8o-
Setting up cav-linux (1.1.268025-1) ...
$Starting cmdagent: The cmdagent started successfully!
$Starting cmgdaemon: The cmgdaemon started successfully!
Installation succeed, but it must be properly configured before using. post_setup. sh script ma...
Please run /opt/COMODO/