Bug 135198 – MySQL 4.1.20 startup fails because of permission error

• Product: Gentoo Linux
• Status: RESOLVED WONTFIX

[Description Mark D. 2006-06-01 12:38:09 UTC]

New install of mysql-4.1.20 on a stable x86 machine does not work.

# /etc/init.d/mysql start
 * Re-caching dependency info (mtimes differ)...
 * Stopping mysql ...
/etc/init.d/mysql: line 332: /var/run/mysqld/mysqld.pid: No such file or directory
 * Stopping mysqld (0)                                                                                                                [ ok ] * Re-caching dependency info (mtimes differ)...
 * Re-caching dependency info (mtimes differ)...
 * Re-caching dependency info (mtimes differ)...
 * Re-caching dependency info (mtimes differ)...
 *  ...
 * Strange, the socket file already exist in "/var/run/mysqld/mysqld.sock"
 * it will be removed now and re-created by the MySQL server
 * BUT please make your checks.
 * Starting mysql (/etc/mysql/my.cnf)                                                                                                 [ ok ]


So mysql starts ok, but dies right after as shown by /var/log/mysql/mysqld.err:

060601 12:34:33 [ERROR] bdb:  //srv/localhost/mysql/datadir: Permission denied
060601 12:34:33 [ERROR] bdb:  //srv/localhost/mysql/datadir/log.0000000001: Permission denied
060601 12:34:33 [ERROR] bdb:  PANIC: Permission denied
060601 12:34:33 [ERROR] bdb:  PANIC: DB_RUNRECOVERY: Fatal error, run database recovery
060601 12:34:33 [ERROR] bdb:  fatal region error detected; run recovery
060601 12:34:33 [ERROR] bdb:  //srv/localhost/mysql/datadir: Permission denied
060601 12:34:34  InnoDB: Started; log sequence number 0 43634
060601 12:34:34 [ERROR] Can't init databases
060601 12:34:34 [ERROR] Aborting

060601 12:34:34  InnoDB: Starting shutdown...
060601 12:34:36  InnoDB: Shutdown completed; log sequence number 0 43634
060601 12:34:36 [Note] /usr/sbin/mysqld: Shutdown complete

Same results with mysql-4.1.19.

Changing database permissions to 777 and mysql:mysql didn't help.

[Comment 1 Mark D. 2006-06-01 12:53:44 UTC]

# emerge --info
Portage 2.0.54 (default-linux/x86/2005.1, gcc-3.4.5, glibc-2.3.5-r3, 2.6.14-hardened-r5 i686)
=================================================================
System uname: 2.6.14-hardened-r5 i686 Intel(R) Pentium(R) 4 CPU 3.20GHz
Gentoo Base System version 1.6.14
ccache version 2.3 [enabled]
dev-lang/python:     2.3.5-r2, 2.4.2
dev-python/pycrypto: [Not Present]
dev-util/ccache:     2.3
dev-util/confcache:  [Not Present]
sys-apps/sandbox:    1.2.12
sys-devel/autoconf:  2.13, 2.59-r7
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r1
sys-devel/binutils:  2.16.1
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.11-r2
ACCEPT_KEYWORDS="x86"
AUTOCLEAN="yes"
CBUILD="i686-pc-linux-gnu"
CFLAGS="-march=pentium4 -O3 -pipe"
CHOST="i686-pc-linux-gnu"
CONFIG_PROTECT="/etc"
CONFIG_PROTECT_MASK="/etc/gconf /etc/terminfo /etc/env.d"
CXXFLAGS="-march=pentium4 -O3 -pipe"
DISTDIR="/mnt/distfiles"
FEATURES="autoconfig buildpkg ccache distlocks fixpackages sandbox sfperms strict userpriv"
GENTOO_MIRRORS="http://adelie.polymtl.ca/ ftp://cs.ubishops.ca/pub/gentoo ftp://ftp.ussg.iu.edu/pub/linux/gentoo"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
SYNC="rsync://mirror.iat.sfu.ca/gentoo-portage"
USE="x86 acpi apache2 berkdb bzip2 crypt dba expat gd gdbm gif imap innodb ipv6 jpeg ldap mmx mpm-worker mysql mysqli ncurses nls pam pcre perl php png python readline session slp snmp srvdir sse ssl tcpd threads truetype usb userlocales utf8 vhosts xml xml2 zlib userland_GNU kernel_linux elibc_glibc"
Unset:  CTARGET, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, LINGUAS, PORTAGE_RSYNC_EXTRA_OPTS, PORTAGE_RSYNC_OPTS, PORTDIR_OVERLAY

[Comment 2 Mark D. 2006-06-06 15:46:33 UTC]

Closing bug.
It turns out the machine did have a previous mysql-4.0 install which might possibly have an effect of killing mysql 4.1 on startup; I did try the gentoo upgrade guide from 4.0-4.1 (which didn't work)
The machine has been wiped and a clean install of gentoo + mysql-4.1 works great.