package mysql-server-5.0 5.1.30really5.0.75-0ubuntu10.2 failed to install/upgrade: le sous-processus post-installation script a retourn? une erreur de sortie d'?tat 1
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
mysql-dfsg-5.0 (Ubuntu) |
Fix Released
|
Low
|
Unassigned |
Bug Description
I can't explain
ProblemType: Package
Architecture: i386
DistroRelease: Ubuntu 9.04
ErrorMessage: le sous-processus post-installation script a retourné une erreur de sortie d'état 1
NonfreeKernelMo
Package: mysql-server-5.0 5.1.30really5.
SourcePackage: mysql-dfsg-5.0
Title: package mysql-server-5.0 5.1.30really5.
Uname: Linux 2.6.28-11-generic i686
Yannig (yannick-voyeaud) wrote : | #1 |
- Dependencies.txt Edit (1.2 KiB, text/plain; charset="utf-8")
- DpkgTerminalLog.gz Edit (1.4 KiB, application/x-gzip)
Mathias Gug (mathiaz) wrote : | #2 |
Changed in mysql-dfsg-5.0 (Ubuntu): | |
status: | New → Incomplete |
Jun 5 15:31:20 pascal-laptop mysqld_safe[14897]: ended
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]: PLEASE REMEMBER TO SET
A PASSWORD FOR THE MySQL root USER !
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]: To do so, start the
server, then issue the following commands:
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]: /usr/bin/mysqladmin -u
root password 'new-password'
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]: /usr/bin/mysqladmin -u
root -h pascal-laptop password 'new-password'
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]:
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]: Alternatively you can run:
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]:
/usr/bin/
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]:
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]: which will also give
you the option of removing the test
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]: databases and
anonymous user created by default. This is
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]: strongly recommended
for production servers.
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]:
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]: See the manual for
more instructions.
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]:
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]: Please report any
problems with the /usr/bin/mysqlbug script!
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]:
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]: The latest information
about MySQL is available on the web at
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]: http://
Jun 5 15:31:21 pascal-laptop mysqld_safe[14924]: Support MySQL by
buying support/licenses at http://
Jun 5 15:31:21 pascal-laptop mysqld_safe[14993]: ERROR: 1046 No
database selected
Jun 5 15:31:21 pascal-laptop mysqld_safe[14993]: 090605 15:31:21
[ERROR] Aborting
Jun 5 15:31:21 pascal-laptop mysqld_safe[14993]:
Jun 5 15:31:21 pascal-laptop mysqld_safe[14993]: 090605 15:31:21 [Note]
/usr/sbin/mysqld: Shutdown complete
Jun 5 15:31:21 pascal-laptop mysqld_safe[14993]:
Jun 5 15:31:22 pascal-laptop AppArmor(init): Skipping profile
/etc/apparmor.
Jun 5 15:31:22 pascal-laptop mysqld_safe[15176]: started
Jun 5 15:31:22 pascal-laptop mysqld[15179]: 090605 15:31:22 [Warning]
Can't create test file /home/mysql/
Jun 5 15:31:22 pascal-laptop mysqld[15179]: 090605 15:31:22 [Warning]
Can't create test file /home/mysql/
Jun 5 15:31:22 pascal-laptop mysqld[15179]: 090605 15:31:22 InnoDB:
Operating system error number 13 in a file operation.
Jun 5 15:31:22 pascal-laptop mysqld[15179]: InnoDB: The error means
mysqld does not have the access rights to
Jun 5 15:31:22 pascal-laptop mysqld[15179]: InnoDB: the directory.
Jun 5 15:31:22 pascal-laptop mysqld[15179]: InnoDB: File name ./ibdata1
Jun 5 15:31:22 pascal-laptop mysqld[15179]: InnoDB: File operation
call: 'open'.
Jun 5 15:31:22 pascal-laptop mysqld[15179]: InnoDB: Cannot continue
operation.
Jun 5 15:31:22 pascal-laptop mysqld_safe[15186]: ended
Jun 5 15:31:37 pascal-laptop /etc/init.
al...
On Fri, Jun 05, 2009 at 01:33:21PM -0000, pascal wrote:
> Jun 5 15:31:40 pascal-laptop mysqld_safe[15491]:
> Jun 5 15:31:40 pascal-laptop AppArmor(init): Skipping profile
> /etc/apparmor.
> Jun 5 15:31:41 pascal-laptop mysqld_safe[15673]: started
> Jun 5 15:31:41 pascal-laptop mysqld[15676]: 090605 15:31:41 [Warning]
> Can't create test file /home/mysql/
> Jun 5 15:31:41 pascal-laptop mysqld[15676]: 090605 15:31:41 [Warning]
> Can't create test file /home/mysql/
> Jun 5 15:31:41 pascal-laptop mysqld[15676]: 090605 15:31:41 InnoDB:
> Operating system error number 13 in a file operation.
> Jun 5 15:31:41 pascal-laptop mysqld[15676]: InnoDB: The error means
> mysqld does not have the access rights to
> Jun 5 15:31:41 pascal-laptop mysqld[15676]: InnoDB: the directory.
Why is mysql trying to use /home/mysql/ as its data directory?
Is /var/lib/mysql/ a symlink to /home/mysql/ ?
This is a non-default setup and thus mysqld apparmor profile needs to be
updated to account for this custom configuration.
--
Mathias Gug
Ubuntu Developer http://
Mathias Gug a écrit :
> On Fri, Jun 05, 2009 at 01:33:21PM -0000, pascal wrote:
>
>> Jun 5 15:31:40 pascal-laptop mysqld_safe[15491]:
>> Jun 5 15:31:40 pascal-laptop AppArmor(init): Skipping profile
>> /etc/apparmor.
>> Jun 5 15:31:41 pascal-laptop mysqld_safe[15673]: started
>> Jun 5 15:31:41 pascal-laptop mysqld[15676]: 090605 15:31:41 [Warning]
>> Can't create test file /home/mysql/
>> Jun 5 15:31:41 pascal-laptop mysqld[15676]: 090605 15:31:41 [Warning]
>> Can't create test file /home/mysql/
>> Jun 5 15:31:41 pascal-laptop mysqld[15676]: 090605 15:31:41 InnoDB:
>> Operating system error number 13 in a file operation.
>> Jun 5 15:31:41 pascal-laptop mysqld[15676]: InnoDB: The error means
>> mysqld does not have the access rights to
>> Jun 5 15:31:41 pascal-laptop mysqld[15676]: InnoDB: the directory.
>>
>
> Why is mysql trying to use /home/mysql/ as its data directory
>
> Is /var/lib/mysql/ a symlink to /home/mysql/ ?
>
Not a symlink, but a datadir setting in my.cnf
> This is a non-default setup and thus mysqld apparmor profile needs to be
> updated to account for this custom configuration.
>
>
Apparmor is updated and ok
All is good before the update.
On Fri, Jun 05, 2009 at 10:22:24PM -0000, pascal wrote:
> >> Jun 5 15:31:41 pascal-laptop mysqld[15676]: 090605 15:31:41 InnoDB:
> >> Operating system error number 13 in a file operation.
> >> Jun 5 15:31:41 pascal-laptop mysqld[15676]: InnoDB: The error means
> >> mysqld does not have the access rights to
> >> Jun 5 15:31:41 pascal-laptop mysqld[15676]: InnoDB: the directory.
> >>
> >
> > Why is mysql trying to use /home/mysql/ as its data directory
> >
> > Is /var/lib/mysql/ a symlink to /home/mysql/ ?
> >
> Not a symlink, but a datadir setting in my.cnf
> > This is a non-default setup and thus mysqld apparmor profile needs to be
> > updated to account for this custom configuration.
> >
> >
>
> Apparmor is updated and ok
>
> All is good before the update.
Could you post the mysqld apparmor profile (found in /etc/apparmor.d/)?
Could you check if there are audit messages related to apparmor and
mysqld in /var/log/kern.log?
--
Mathias Gug
Ubuntu Developer http://
kern.log after an update:
Jun 6 14:09:34 pascal-laptop kernel: [ 2778.336042] CE: hpet increasing
min_delta_ns to 15000 nsec
Jun 6 14:12:27 pascal-laptop kernel: [ 2951.365529] type=1505
audit(124429034
name="/
Jun 6 14:12:28 pascal-laptop kernel: [ 2951.437593] type=1505
audit(124429034
name="/
Jun 6 14:12:28 pascal-laptop kernel: [ 2951.437900] type=1505
audit(124429034
name="/
Jun 6 14:12:28 pascal-laptop kernel: [ 2951.437962] type=1505
audit(124429034
name="/
pid=6764
Jun 6 14:12:28 pascal-laptop kernel: [ 2951.438019] type=1505
audit(124429034
name="/
Jun 6 14:12:28 pascal-laptop kernel: [ 2951.625141] type=1505
audit(124429034
name="/
Jun 6 14:12:28 pascal-laptop kernel: [ 2951.625518] type=1505
audit(124429034
name="/
Jun 6 14:12:28 pascal-laptop kernel: [ 2951.673473] type=1505
audit(124429034
name="/
Jun 6 14:12:28 pascal-laptop kernel: [ 2951.715329] type=1505
audit(124429034
name="/
Jun 6 14:12:45 pascal-laptop kernel: [ 2969.356181] __ratelimit: 12
callbacks suppressed
Jun 6 14:12:45 pascal-laptop kernel: [ 2969.356185] type=1503
audit(124429036
denied_mask="a::" fsuid=0 name="/
pid=7176 profile=
Jun 6 14:12:45 pascal-laptop kernel: [ 2969.356259] type=1503
audit(124429036
denied_mask="a::" fsuid=0 name="/
pid=7176 profile=
Jun 6 14:12:45 pascal-laptop kernel: [ 2969.363748] type=1503
audit(124429036
requested_
name="/
Jun 6 14:12:46 pascal-laptop kernel: [ 2969.403433] type=1503
audit(124429036
denied_mask="a::" fsuid=0 name="/
pid=7191 profile=
Jun 6 14:12:46 pascal-laptop kernel: [ 2969.403508] type=1503
audit(124429036
denied_mask="a::" fsuid=0 name="/
pid=7191 profile=
Jun 6 14:12:46 pascal-laptop kernel: [ 2969.407872] type=1503
audit(124429036
requested_
On Sat, Jun 06, 2009 at 12:34:43PM -0000, pascal wrote:
> kern.log after an update:
>
Relevant error messages:
> audit(124429034
> name="/
> Jun 6 14:12:28 pascal-laptop kernel: [ 2951.715329] type=1505
> audit(124429034
> name="/
> Jun 6 14:12:45 pascal-laptop kernel: [ 2969.356185] type=1503
> audit(124429036
> denied_mask="a::" fsuid=0 name="/
> pid=7176 profile=
> Jun 6 14:12:45 pascal-laptop kernel: [ 2969.356259] type=1503
> audit(124429036
> denied_mask="a::" fsuid=0 name="/
> pid=7176 profile=
> Jun 6 14:12:45 pascal-laptop kernel: [ 2969.363748] type=1503
> audit(124429036
> requested_
> name="/
> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.403433] type=1503
> audit(124429036
> denied_mask="a::" fsuid=0 name="/
> pid=7191 profile=
> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.403508] type=1503
> audit(124429036
> denied_mask="a::" fsuid=0 name="/
> pid=7191 profile=
> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.407872] type=1503
> audit(124429036
> requested_
> name="/
> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.407921] type=1503
> audit(124429036
> requested_
> name="/
> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.408101] type=1503
> audit(124429036
> requested_
> name="/
> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.437078] type=1503
> audit(124429036
> denied_mask="a::" fsuid=0 name="/
> pid=7202 profile=
> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.437463] type=1503
> audit(124429036
> denied_mask="a::" fsuid=0 name="/
> pid=7202 profile=
So the problem is related to mysqld apparmor profile. Apparently mysqld
profile has been replaced during the upgrade (first line in the audit
log).
>
> /etc/apparmor.
>
> # vim:syntax=apparmor
> # Last Modified: Tue Jun 19 17:37:30 2007
> #include <tunables/global>
>
> /usr/sbin/...
News:
After restart computer, mysql is ok.
I try to install any package and i have the installation error for mysql
So, i reboot, and mysql start...
Mathias Gug a écrit :
> On Sat, Jun 06, 2009 at 12:34:43PM -0000, pascal wrote:
>
>> kern.log after an update:
>>
>>
>
> Relevant error messages:
>
>> audit(124429034
>> name="/
>> Jun 6 14:12:28 pascal-laptop kernel: [ 2951.715329] type=1505
>> audit(124429034
>> name="/
>> Jun 6 14:12:45 pascal-laptop kernel: [ 2969.356185] type=1503
>> audit(124429036
>> denied_mask="a::" fsuid=0 name="/
>> pid=7176 profile=
>> Jun 6 14:12:45 pascal-laptop kernel: [ 2969.356259] type=1503
>> audit(124429036
>> denied_mask="a::" fsuid=0 name="/
>> pid=7176 profile=
>> Jun 6 14:12:45 pascal-laptop kernel: [ 2969.363748] type=1503
>> audit(124429036
>> requested_
>> name="/
>> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.403433] type=1503
>> audit(124429036
>> denied_mask="a::" fsuid=0 name="/
>> pid=7191 profile=
>> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.403508] type=1503
>> audit(124429036
>> denied_mask="a::" fsuid=0 name="/
>> pid=7191 profile=
>> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.407872] type=1503
>> audit(124429036
>> requested_
>> name="/
>> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.407921] type=1503
>> audit(124429036
>> requested_
>> name="/
>> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.408101] type=1503
>> audit(124429036
>> requested_
>> name="/
>> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.437078] type=1503
>> audit(124429036
>> denied_mask="a::" fsuid=0 name="/
>> pid=7202 profile=
>> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.437463] type=1503
>> audit(124429036
>> denied_mask="a::" fsuid=0 name="/
>> pid=7202 profile=
>>
>
> So the problem is related to mysqld apparmor pro...
and today, update manager make his job...same error at end.
pascal a écrit :
> News:
>
> After restart computer, mysql is ok.
> I try to install any package and i have the installation error for mysql
> So, i reboot, and mysql start...
>
>
> Mathias Gug a écrit :
>
>> On Sat, Jun 06, 2009 at 12:34:43PM -0000, pascal wrote:
>>
>>
>>> kern.log after an update:
>>>
>>>
>>>
>> Relevant error messages:
>>
>>
>>> audit(124429034
>>> name="/
>>> Jun 6 14:12:28 pascal-laptop kernel: [ 2951.715329] type=1505
>>> audit(124429034
>>> name="/
>>> Jun 6 14:12:45 pascal-laptop kernel: [ 2969.356185] type=1503
>>> audit(124429036
>>> denied_mask="a::" fsuid=0 name="/
>>> pid=7176 profile=
>>> Jun 6 14:12:45 pascal-laptop kernel: [ 2969.356259] type=1503
>>> audit(124429036
>>> denied_mask="a::" fsuid=0 name="/
>>> pid=7176 profile=
>>> Jun 6 14:12:45 pascal-laptop kernel: [ 2969.363748] type=1503
>>> audit(124429036
>>> requested_
>>> name="/
>>> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.403433] type=1503
>>> audit(124429036
>>> denied_mask="a::" fsuid=0 name="/
>>> pid=7191 profile=
>>> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.403508] type=1503
>>> audit(124429036
>>> denied_mask="a::" fsuid=0 name="/
>>> pid=7191 profile=
>>> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.407872] type=1503
>>> audit(124429036
>>> requested_
>>> name="/
>>> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.407921] type=1503
>>> audit(124429036
>>> requested_
>>> name="/
>>> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.408101] type=1503
>>> audit(124429036
>>> requested_
>>> name="/
>>> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.437078] type=1503
>>> audit(124429036
>>> denied_mask="a::" fsuid=0 name="/
>>> pid=7202 profile=
>>> Jun 6 14:12:46 pascal-laptop kernel: [ 2969.437463] type=1503
>>> audit(124429036
>>...
Mathias Gug (mathiaz) wrote : | #11 |
Could you make sure that mysqld apparmor profile is still correct after the update?
Changed in mysql-dfsg-5.0 (Ubuntu): | |
importance: | Undecided → Low |
I check it just before a failed update, and it's ok.
Mathias Gug a écrit :
> Could you make sure that mysqld apparmor profile is still correct after
> the update?
>
>
On Mon, Jun 22, 2009 at 03:07:43PM -0000, pascal wrote:
> I check it just before a failed update, and it's ok.
And *after* the failed update?
--
Mathias Gug
Ubuntu Developer http://
Mathias Gug a écrit :
> On Mon, Jun 22, 2009 at 03:07:43PM -0000, pascal wrote:
>
>> I check it just before a failed update, and it's ok.
>>
>
> And *after* the failed update?
>
>
sorry, i want say just after...
pascal (pascal-coullet) wrote : | #15 |
Mathias Gug a écrit :
> On Mon, Jun 22, 2009 at 03:07:43PM -0000, pascal wrote:
>
>> I check it just before a failed update, and it's ok.
>>
>
> And *after* the failed update?
>
>
And, again, after reboot, mysql run without problem...
Changed in mysql-dfsg-5.0 (Ubuntu): | |
status: | Incomplete → Fix Released |
Relevant errors:
* Starting MySQL database server mysqld
...fail!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg : erreur de traitement de mysql-server-5.0 (--configure) :
le sous-processus post-installation script a retourné une erreur de sortie d'état 1
Could you post the content of /var/log/daemon.log around the time of the upgrade to identify why mysqld failed to start?