package mysql-server-5.5 5.5.28-0ubuntu0.12.04.2 failed to install/upgrade: il sottoprocesso vecchio script di post-installation ha restituito lo stato di errore 1

Bug #1071909 reported by Angelo
18
This bug affects 3 people
Affects Status Importance Assigned to Milestone
mysql-5.5 (Ubuntu)
Invalid
Medium
Unassigned

Bug Description

installing update only this

ProblemType: Package
DistroRelease: Ubuntu 12.04
Package: mysql-server-5.5 5.5.28-0ubuntu0.12.04.2
ProcVersionSignature: Ubuntu 3.2.0-33.52-generic 3.2.31
Uname: Linux 3.2.0-33-generic x86_64
NonfreeKernelModules: nvidia
ApportVersion: 2.0.1-0ubuntu14
AptOrdering:
 mysql-server-5.5: Configure
 mysql-server: Configure
Architecture: amd64
Date: Fri Oct 26 21:40:12 2012
DpkgTerminalLog:
 Configurazione di mysql-server-5.5 (5.5.28-0ubuntu0.12.04.2)...
 start: Job failed to start
 invoke-rc.d: initscript mysql, action "start" failed.
 dpkg: errore nell'elaborare mysql-server-5.5 (--configure):
  il sottoprocesso vecchio script di post-installation ha restituito lo stato di errore 1
ErrorMessage: il sottoprocesso vecchio script di post-installation ha restituito lo stato di errore 1
InstallationMedia: Ubuntu 12.04 LTS "Precise Pangolin" - Release amd64 (20120425)
Logs.var.log.daemon.log:

MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: ['phpmyadmin', 'mysql', 'debian-5.5.flag', 'performance_schema', 'mysql_upgrade_info', 'ibdata1', 'container', 'ib_logfile0', 'ib_logfile1', 'elenchi', 'test']
SourcePackage: mysql-5.5
Title: package mysql-server-5.5 5.5.28-0ubuntu0.12.04.2 failed to install/upgrade: il sottoprocesso vecchio script di post-installation ha restituito lo stato di errore 1
UpgradeStatus: No upgrade log present (probably fresh install)

Revision history for this message
Angelo (angeloballabio-gmail) wrote :
Revision history for this message
Clint Byrum (clint-fewbar) wrote :

Hello Angelo! Can you please include the file /var/log/upstart/mysql.log , and any non-empty files you see when you run 'ls -l /var/log/mysql*' ? Thanks!

Changed in mysql-5.5 (Ubuntu):
status: New → Incomplete
importance: Undecided → Medium
Revision history for this message
joosteto (joosteto) wrote :

Maybe I run into this bug too. For me the install hangs, and returns an error message when I press ^C.
The logfile /var/log/upstart/mysql.log you mention has an access time of the 10'th of november, so apparently mysql doesn't log anything there.
While the upgrade (first aptitute upgrade, now dpkg --configure -a) runs (hangs), I see this in "ps ax | grep mysql":

20724 pts/2 S+ 0:00 /usr/bin/perl -w /usr/share/debconf/frontend /var/lib/dpkg/info/mysql-server-5.5.postinst configure 5.5.27-0ubuntu2
20734 pts/2 S+ 0:00 /bin/bash -e /var/lib/dpkg/info/mysql-server-5.5.postinst configure 5.5.27-0ubuntu2
20898 pts/2 S+ 0:00 /bin/sh /usr/sbin/invoke-rc.d mysql start
20914 pts/2 S+ 0:00 /bin/sh -e /etc/init.d/mysql start
20925 pts/2 S+ 0:00 start mysql
22241 ? Ssl 0:00 /usr/sbin/mysqld
22269 pts/3 S+ 0:00 grep --color=auto mysql

Pressing ^C and running the invoke-rc.d script, I get:

# /bin/sh /usr/sbin/invoke-rc.d mysql start
Rather than invoking init scripts through /etc/init.d, use the service(8)
utility, e.g. service mysql start

Since the script you are attempting to invoke has been converted to an
Upstart job, you may also use the start(8) utility, e.g. start mysql

This is the output I get from running dpkg --configure -a:

# dpkg --configure -a
Setting up mysql-server-5.5 (5.5.28-0ubuntu0.12.10.1) ...
mysql stop/waiting
^Cdpkg: error processing mysql-server-5.5 (--configure):
 subprocess installed post-installation script was interrupted
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
Errors were encountered while processing:
 mysql-server-5.5
 mysql-server

Revision history for this message
joosteto (joosteto) wrote :

Oh, and about the files in /var/log/mysql you asked about.

While I'm running "dpkg --configure -a" (and don't stop it):

/var/log/mysql/error.log:
[lot's of lines, gets continuously longer]:
121110 17:48:56 InnoDB: Starting shutdown...
121110 17:48:57 InnoDB: Shutdown completed; log sequence number 2347290
121110 17:48:57 [Note]
121110 17:48:58 [Note] Plugin 'FEDERATED' is disabled.
121110 17:48:58 InnoDB: The InnoDB memory heap is disabled
121110 17:48:58 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121110 17:48:58 InnoDB: Compressed tables use zlib 1.2.7
121110 17:48:58 InnoDB: Using Linux native AIO
121110 17:48:58 InnoDB: Initializing buffer pool, size = 128.0M
121110 17:48:58 InnoDB: Completed initialization of buffer pool
121110 17:48:58 InnoDB: highest supported file format is Barracuda.
121110 17:48:59 InnoDB: Waiting for the background threads to start
121110 17:49:00 InnoDB: 1.1.8 started; log sequence number 2347290
121110 17:49:00 [ERROR] Aborting

121110 17:49:00 InnoDB: Starting shutdown...
121110 17:49:01 InnoDB: Shutdown completed; log sequence number 2347290
121110 17:49:01 [Note]
121110 17:49:01 [Note] Plugin 'FEDERATED' is disabled.
121110 17:49:01 InnoDB: The InnoDB memory heap is disabled
121110 17:49:01 InnoDB: Mutexes and rw_locks use GCC atomic builtins
121110 17:49:01 InnoDB: Compressed tables use zlib 1.2.7
121110 17:49:01 InnoDB: Using Linux native AIO
121110 17:49:01 InnoDB: Initializing buffer pool, size = 128.0M
121110 17:49:02 InnoDB: Completed initialization of buffer pool
121110 17:49:02 InnoDB: highest supported file format is Barracuda.
121110 17:49:02 InnoDB: Waiting for the background threads to start

and the file /var/log/upstart/mysql.log contains lots of lines:
121110 17:58:09 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'
^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
121110 17:58:12 [ERROR] Can't find messagefile '/usr/share/mysql/errmsg.sys'

Revision history for this message
Angelo (angeloballabio-gmail) wrote : Re: [Bug 1071909] Re: package mysql-server-5.5 5.5.28-0ubuntu0.12.04.2 failed to install/upgrade: il sottoprocesso vecchio script di post-installation ha restituito lo stato di errore 1
Download full text (7.2 KiB)

Sorry when not work I purge my installation, then after 2 week I see some
is change and I install from scratch again end now it work.
Next time this is happen again I make a copy off this file, really is not
the first time it happen

if can be help this syslog

Nov 4 18:18:03 angelo-mobile mysqld_safe[15780]:
Nov 4 18:18:03 angelo-mobile mysqld_safe[15780]: PLEASE REMEMBER TO SET A
PASSWORD FOR THE MySQL root USER !
Nov 4 18:18:03 angelo-mobile mysqld_safe[15780]: To do so, start the
server, then issue the following commands:
Nov 4 18:18:03 angelo-mobile mysqld_safe[15780]:
Nov 4 18:18:03 angelo-mobile mysqld_safe[15780]: /usr/bin/mysqladmin -u
root password 'new-password'
Nov 4 18:18:03 angelo-mobile mysqld_safe[15780]: /usr/bin/mysqladmin -u
root -h angelo-mobile password 'new-password'
Nov 4 18:18:03 angelo-mobile mysqld_safe[15780]:
Nov 4 18:18:03 angelo-mobile mysqld_safe[15780]: Alternatively you can run:
Nov 4 18:18:03 angelo-mobile mysqld_safe[15780]:
/usr/bin/mysql_secure_installation
Nov 4 18:18:03 angelo-mobile mysqld_safe[15780]:
Nov 4 18:18:03 angelo-mobile mysqld_safe[15780]: which will also give you
the option of removing the test
Nov 4 18:18:03 angelo-mobile mysqld_safe[15780]: databases and anonymous
user created by default. This is
Nov 4 18:18:03 angelo-mobile mysqld_safe[15780]: strongly recommended for
production servers.
Nov 4 18:18:03 angelo-mobile mysqld_safe[15780]:
Nov 4 18:18:03 angelo-mobile mysqld_safe[15780]: See the manual for more
instructions.
Nov 4 18:18:03 angelo-mobile mysqld_safe[15780]:
Nov 4 18:18:03 angelo-mobile mysqld_safe[15780]: Please report any
problems with the /usr/bin/mysqlbug script!
Nov 4 18:18:03 angelo-mobile mysqld_safe[15780]:
Nov 4 18:18:03 angelo-mobile mysqld_safe[15810]: 121104 18:18:03 [Note]
Plugin 'FEDERATED' is disabled.
Nov 4 18:18:03 angelo-mobile mysqld_safe[15810]: 121104 18:18:03 InnoDB:
The InnoDB memory heap is disabled
Nov 4 18:18:03 angelo-mobile mysqld_safe[15810]: 121104 18:18:03 InnoDB:
Mutexes and rw_locks use GCC atomic builtins
Nov 4 18:18:03 angelo-mobile mysqld_safe[15810]: 121104 18:18:03 InnoDB:
Compressed tables use zlib 1.2.7
Nov 4 18:18:03 angelo-mobile mysqld_safe[15810]: 121104 18:18:03 InnoDB:
Using Linux native AIO
Nov 4 18:18:03 angelo-mobile mysqld_safe[15810]: 121104 18:18:03 InnoDB:
Initializing buffer pool, size = 128.0M
Nov 4 18:18:03 angelo-mobile mysqld_safe[15810]: 121104 18:18:03 InnoDB:
Completed initialization of buffer pool
Nov 4 18:18:03 angelo-mobile mysqld_safe[15810]: 121104 18:18:03 InnoDB:
highest supported file format is Barracuda.
Nov 4 18:18:03 angelo-mobile mysqld_safe[15810]: 121104 18:18:03 InnoDB:
Waiting for the background threads to start
Nov 4 18:18:04 angelo-mobile mysqld_safe[15810]: 121104 18:18:04 InnoDB:
1.1.8 started; log sequence number 2348911
Nov 4 18:18:04 angelo-mobile mysqld_safe[15810]: 121104 18:18:04 InnoDB:
Starting shutdown...
Nov 4 18:18:05 angelo-mobile mysqld_safe[15810]: 121104 18:18:05 InnoDB:
Shutdown completed; log sequence number 2348911
Nov 4 18:18:07 angelo-mobile mysqld_safe[15855]: 121104 18:18:07 [Note]
Plugin 'FEDERATED' is disabled.
Nov 4 18:18:07 angelo-mobile...

Read more...

Revision history for this message
Clint Byrum (clint-fewbar) wrote :

No problem, thanks for the quick response!

Changed in mysql-5.5 (Ubuntu):
status: Incomplete → Invalid
Revision history for this message
ilmondo (q-launchpad-ilmondodiwit-com) wrote :
Download full text (6.9 KiB)

seems to got me also. i attach the files you asked to angelo doing 'ls -l /var/log/mysql*

there was the /var/log/mysql/error.log

130314 12:21:13 [Note] Plugin 'FEDERATED' is disabled.
130314 12:21:13 InnoDB: The InnoDB memory heap is disabled
130314 12:21:13 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130314 12:21:13 InnoDB: Compressed tables use zlib 1.2.3.4
130314 12:21:13 InnoDB: Initializing buffer pool, size = 128.0M
130314 12:21:13 InnoDB: Completed initialization of buffer pool
InnoDB: The first specified data file ./ibdata1 did not exist:
InnoDB: a new database to be created!
130314 12:21:13 InnoDB: Setting file ./ibdata1 size to 10 MB
InnoDB: Database physically writes the file full: wait...
130314 12:21:13 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 5 MB
InnoDB: Database physically writes the file full: wait...
130314 12:21:14 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 5 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Doublewrite buffer not found: creating new
InnoDB: Doublewrite buffer created
InnoDB: 127 rollback segment(s) active.
InnoDB: Creating foreign key constraint system tables
InnoDB: Foreign key constraint system tables created
130314 12:21:15 InnoDB: Waiting for the background threads to start
130314 12:21:16 InnoDB: 1.1.8 started; log sequence number 0
130314 12:21:16 InnoDB: Starting shutdown...
130314 12:21:17 InnoDB: Shutdown completed; log sequence number 1595675
130314 12:21:17 [Note] Plugin 'FEDERATED' is disabled.
130314 12:21:17 InnoDB: The InnoDB memory heap is disabled
130314 12:21:17 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130314 12:21:17 InnoDB: Compressed tables use zlib 1.2.3.4
130314 12:21:17 InnoDB: Initializing buffer pool, size = 128.0M
130314 12:21:17 InnoDB: Completed initialization of buffer pool
130314 12:21:17 InnoDB: highest supported file format is Barracuda.
130314 12:21:17 InnoDB: Waiting for the background threads to start
130314 12:21:18 InnoDB: 1.1.8 started; log sequence number 1595675
130314 12:21:18 InnoDB: Starting shutdown...
130314 12:21:18 InnoDB: Shutdown completed; log sequence number 1595675
130314 12:21:18 [Note] Plugin 'FEDERATED' is disabled.
130314 12:21:18 InnoDB: The InnoDB memory heap is disabled
130314 12:21:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
130314 12:21:18 InnoDB: Compressed tables use zlib 1.2.3.4
130314 12:21:18 InnoDB: Initializing buffer pool, size = 128.0M
130314 12:21:18 InnoDB: Completed initialization of buffer pool
130314 12:21:18 InnoDB: highest supported file format is Barracuda.
130314 12:21:19 InnoDB: Waiting for the background threads to start
130314 12:21:20 InnoDB: 1.1.8 started; log sequence number 1595675
ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE user ADD column Show_view_priv enum('N','Y') CHARACTER SET utf8 NOT ' at line 1
130314 12:21:20 [ERROR] Aborting

130314 12:21:20 InnoDB: Starting shutdown...
130314 12:21:21 InnoDB: Sh...

Read more...

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.