Bug 105552 – mysql Failed to chown/chmod/unlink in movefile

• Status: VERIFIED TEST-REQUEST
• Product: Gentoo Linux

[Description Dave O'Connor 2005-09-10 16:47:43 UTC]

The emerge seeems to work fine until it has to access the data dir which, in
this case, is in a non-standard location.

Reproducible: Always
Steps to Reproduce:
1. emerge -Du world
2. emerges mysql but craps out putting files into place
3.

Actual Results:  
--- /usr/share/doc/
--- /usr/share/doc/mysql-4.0.25-r2/
>>> /usr/share/doc/mysql-4.0.25-r2/README.gz
>>> /usr/share/doc/mysql-4.0.25-r2/COPYING.gz
>>> /usr/share/doc/mysql-4.0.25-r2/ChangeLog.gz
>>> /usr/share/doc/mysql-4.0.25-r2/EXCEPTIONS-CLIENT.gz
>>> /usr/share/doc/mysql-4.0.25-r2/INSTALL-SOURCE.gz
--- /usr/sbin/
>>> /usr/sbin/mysqld
--- /work/
--- /work/data/
!!! Failed to chown/chmod/unlink in movefile()
!!! /work/data/.keep
!!! [Errno 1] Operation not permitted: '/work/data/.keep'


Expected Results:  
The emerge should have completed.

root@greyskull ~ # emerge info
Portage 2.0.51.22-r2 (default-linux/x86/2005.0, gcc-3.3.6, glibc-2.3.5-r1,
2.6.12-gentoo-r4 i686)
=================================================================
System uname: 2.6.12-gentoo-r4 i686 Intel(R) Pentium(R) 4 Mobile CPU 1.70GHz
Gentoo Base System version 1.6.13
dev-lang/python:     2.3.5-r2
sys-apps/sandbox:    1.2.12
sys-devel/autoconf:  2.13, 2.59-r6
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6
sys-devel/binutils:  2.15.92.0.2-r10
sys-devel/libtool:   1.5.18-r1
virtual/os-headers:  2.6.11-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-O2 -march=i686 -fomit-frame-pointer -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc /usr/kde/2/share/config /usr/kde/3.3/env
/usr/kde/3.3/share/config /usr/kde/3.3/shutdown /usr/kde/3.4/env
/usr/kde/3.4/share/config /usr/kde/3.4/shutdown /usr/kde/3/share/config
/usr/lib/X11/xkb /usr/lib/mozilla/defaults/pref /usr/share/config
/var/qmail/control"
CONFIG_PROTECT_MASK="/etc/gconf /etc/terminfo /etc/env.d"
CXXFLAGS="-O2 -march=i686 -fomit-frame-pointer -pipe"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig distlocks sandbox sfperms strict"
GENTOO_MIRRORS="http://gentoo.tiscali.nl/gentoo/"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="x86 3dnow X adns alsa apm arts avi berkdb bitmap-fonts cdr crypt cups curl
dba dvd dvdread eds emboss encode esd fam flac foomaticdb fortran freetds gd
gdbm gif gnome gpm gstreamer gtk gtk2 imagemagick imlib java jpeg junit kde ldap
libg++ libwww mad mikmod motif mozilla mp3 mpeg mysql ncurses nls ogg oggvorbis
opengl oss pam pdflib perl php png postgres python qt quicktime readline samba
sdl slang spell ssl svga tcltk tcpd tiff truetype truetype-fonts type1-fonts
vorbis xine xml2 xmms xv zlib userland_GNU kernel_linux elibc_glibc"
Unset:  ASFLAGS, CTARGET, LANG, LC_ALL, LDFLAGS, LINGUAS, PORTDIR_OVERLAY

[Comment 1 Robin Johnson 2005-09-10 22:25:28 UTC]

I don't know what's up with your system, but the ebuild does NOT 
create /work/data.

The datadir is /var/lib/mysql/.

[Comment 2 Dave O'Connor 2005-09-11 05:53:25 UTC]

(In reply to comment #1)
> I don't know what's up with your system, but the ebuild does NOT 
> create /work/data.
> 
> The datadir is /var/lib/mysql/.

Yep, that's why I said it has a problem when the data dir is in a non-standard
location, I changed it in the mysql config file to that dir and have been using
it that way for about a year now. It has never been a problem until this update.

Regards
Dave

[Comment 3 Francesco R. (RETIRED) 2005-09-11 11:13:46 UTC]

This could happen when the following criteria are meet:
- a mysql version is already installed
- /etc/mysql/my.cnf exist and [mysqld] section contain "datadir = /my/path/to"
- "/my/path/to" the designed datadir still does not exist

Is this your situation ?

[Comment 4 Dave O'Connor 2005-09-11 15:33:38 UTC]

(In reply to comment #3)
> This could happen when the following criteria are meet:
> - a mysql version is already installed
> - /etc/mysql/my.cnf exist and [mysqld] section contain "datadir = /my/path/to"
> - "/my/path/to" the designed datadir still does not exist
> 
> Is this your situation ?

doc @ greyskull ~ $ sudo grep datadir /etc/mysql/my.cnf
datadir         = /work/data

/work/data exists and this is only a problem now and has never been for any
other update.

[Comment 5 Francesco R. (RETIRED) 2005-09-12 09:16:08 UTC]

The test for a previous "datadir" in place has been improved.
Please test.

[Comment 6 Dave O'Connor 2005-09-12 15:50:41 UTC]

emerge sync and update worked.

Thanks :)

[Comment 7 Francesco R. (RETIRED) 2005-09-12 16:22:05 UTC]

tnx, closing