Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!

Bug 157617

Summary: dev-db/mysql-5.0.26-r1 - init script doesn't restart
Product: Gentoo Linux Reporter: Souleyman <administrateur>
Component: New packagesAssignee: Gentoo Linux MySQL bugs team <mysql-bugs>
Status: VERIFIED NEEDINFO    
Severity: normal CC: administrateur
Priority: High    
Version: 2006.0   
Hardware: AMD64   
OS: Linux   
Whiteboard:
Package list:
Runtime testing required: ---
Attachments: Mysqld error log

Description Souleyman 2006-12-09 07:09:54 UTC
Hi,
I have some troubles with mysql on a x86_64 computer.
I setup mysql with this use  flags :
leeloo ~ # emerge -av dev-db/mysql
....
[ebuild   R   ] dev-db/mysql-5.0.26-r1  USE="berkdb* latin1 perl ssl -big-tables -cluster -debug -embedded -extraengine -max-idx-128 -minimal (-selinux) -srvdir -static" 0 kB
....
 emerge --config =dev-db/mysql-5.0.26-r1

Setup  & configuration work fine
After i config m :
 emerge --config =dev-db/mysql-5.0.26-r1

After i'am able to start mysql only one time.
If i stop mysql i'am not able to restart it (without any modification)
leeloo ~ # /etc/init.d/mysql start
 * Caching service dependencies ...                                       [ ok ]
 * Starting mysql ...
 * Starting mysql (/etc/mysql/my.cnf)                                     [ ok ]
leeloo ~ # /etc/init.d/mysql stop
 * Stopping mysql ...
 * Stopping mysqld (0)                                                    [ ok ]
leeloo ~ # /etc/init.d/mysql start
 * Starting mysql ...
 * Starting mysql (/etc/mysql/my.cnf)
 * MySQL NOT started (0)                                                  [ !! ]

I have make some test by disabling some flags ...
But nothing work.

Best regards Souleyman
Comment 1 Souleyman 2006-12-09 07:12:27 UTC
Created attachment 103691 [details]
Mysqld error log
Comment 2 Souleyman 2006-12-09 07:13:44 UTC
leeloo ~ # emerge --info
Portage 2.1.1-r2 (default-linux/amd64/2006.0, gcc-3.4.5, glibc-2.4-r4, 2.6.18.1-xxxx-std-ipv4-64 x86_64)
=================================================================
System uname: 2.6.18.1-xxxx-std-ipv4-64 x86_64 Intel(R) Pentium(R) 4 CPU 3.00GHz
Gentoo Base System version 1.12.6
Last Sync: Sat, 09 Dec 2006 12:30:07 +0000
ccache version 2.3 [disabled]
app-admin/eselect-compiler: [Not Present]
dev-java/java-config: 1.3.7, 2.0.30
dev-lang/python:     2.4.3-r4
dev-python/pycrypto: 2.0.1-r5
dev-util/ccache:     2.3
dev-util/confcache:  [Not Present]
sys-apps/sandbox:    1.2.17
sys-devel/autoconf:  2.13, 2.60
sys-devel/automake:  1.4_p6, 1.5, 1.6.3, 1.7.9-r1, 1.8.5-r3, 1.9.6-r2
sys-devel/binutils:  2.16.1-r3
sys-devel/gcc-config: 1.3.13-r4
sys-devel/libtool:   1.5.22
virtual/os-headers:  2.6.11-r2
ACCEPT_KEYWORDS="amd64"
AUTOCLEAN="yes"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-O2 -pipe -march=k8"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /var/bind"
CONFIG_PROTECT_MASK="/etc/env.d /etc/env.d/java/ /etc/gconf /etc/java-config/vms/ /etc/revdep-rebuild /etc/terminfo"
CXXFLAGS="-O2 -pipe -march=k8"
DISTDIR="/usr/portage/distfiles"
FEATURES="autoconfig distlocks metadata-transfer sfperms strict"
GENTOO_MIRRORS="http://mirror.ovh.net/gentoo-distfiles/ ftp://mirror.ovh.net/gentoo-distfiles/"
LANG="fr_FR@euro"
MAKEOPTS="-j2"
PKGDIR="/usr/portage/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --delete-after --stats --timeout=180 --exclude='/distfiles' --exclude='/local' --exclude='/packages'"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage-ovh"
SYNC="rsync://rsync.gentoo.org/gentoo-portage"
USE="amd64 admin alsa apache2 berkdb bitmap-fonts bzip2 caps clamav cli contentcache cracklib crypt cups dlloader dri eds elibc_glibc emboss encode foomaticdb fortran gd gdbm gif gpm gstreamer gtk2 iconv imlib input_devices_evdev input_devices_keyboard input_devices_mouse isdnlog jpeg kernel_linux latin1 logrotate lzw lzw-tiff mp3 mpeg mysql ncurses netboot nls nptl nptlonly opengl pam pcre perl png pppd python qt3 qt4 quicktime readline reflection session spell spl ssl tcpd threads tiff truetype truetype-fonts type1-fonts unicode usb userland_GNU userlocales video_cards_apm video_cards_ark video_cards_ati video_cards_chips video_cards_cirrus video_cards_cyrix video_cards_dummy video_cards_fbdev video_cards_glint video_cards_i128 video_cards_i810 video_cards_mga video_cards_neomagic video_cards_nv video_cards_rendition video_cards_s3 video_cards_s3virge video_cards_savage video_cards_siliconmotion video_cards_sis video_cards_sisusb video_cards_tdfx video_cards_tga video_cards_trident video_cards_tseng video_cards_v4l video_cards_vesa video_cards_vga video_cards_via video_cards_vmware video_cards_voodoo vroot xml xmlreader xmlrpc xmlwriter xorg xpm xv zip zlib"
Unset:  CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, LDFLAGS, LINGUAS, PORTAGE_RSYNC_EXTRA_OPTS
Comment 3 Francesco R. (RETIRED) gentoo-dev 2006-12-09 14:54:23 UTC
sorry, could not reproduce:
sudo /etc/init.d/mysql start stop start stop start stop
 * Stopping mysql ...
 * Stopping mysqld (0)                                                                                                                         [ ok ]
 * Starting mysql ...
 * Starting mysql (/etc/mysql/my.cnf)                                                                                                          [ ok ]
 * Stopping mysql ...
 * Stopping mysqld (0)                                                                                                                         [ ok ]
 * Starting mysql ...
 * Starting mysql (/etc/mysql/my.cnf)                                                                                                          [ ok ]
 * Stopping mysql ...
 * Stopping mysqld (0)                                                                                                                         

try the new dev-db/mysql-5.0.30, it would be available in few hours.
Comment 4 Souleyman 2006-12-10 05:12:35 UTC
Hi,
I have try with the new release af mysql but I still got the same trouble
I have done an emerge -C dev-db/mysql
rm -rf /etc/mysql
rm -rf /var/lib/mysql
emerge -av dev-db/mysql
......
leeloo ~ # emerge --config =dev-db/mysql-5.0.30


Configuring pkg...

 * MySQL DATADIR is /var/lib/mysql
 * Previous datadir found, it's YOUR job to change
 * ownership and take care of it
 * Creating the mysql database and setting proper
 * permissions on it ...
 * Insert a password for the mysql 'root' user
 * Avoid ["'\_%] characters in the password
    >
 * Retype the password
    >
. * Loading "zoneinfo", this step may require a few seconds ...
 * Stopping the server ...
 * Done

leeloo ~ # /etc/init.d/mysql start
 * Caching service dependencies ...                                       [ ok ]
 * Starting mysql ...
 * Starting mysql (/etc/mysql/my.cnf)                                     [ ok ]
leeloo ~ # /etc/init.d/mysql restart
 * Stopping mysql ...
 * Stopping mysqld (0)                                                    [ ok ]
 * Starting mysql ...
 * Starting mysql (/etc/mysql/my.cnf)
 * MySQL NOT started (0)                                                  [ !! ]

There is nothing in the log that give me a way to solve the trouble.
Sorry to disturb you with this trouble but i'm really lost and have no idea on how to solve this
Best regards
Souleyman
Comment 5 Francesco R. (RETIRED) gentoo-dev 2006-12-10 09:49:41 UTC
no disturb really,

there some tricks that can help you in debug the start up:
start with:

# echo "DEBUG=4" >> /etc/conf.d/mysql

then 
8< 8< 8< 8< 8< 8< 8< 8< 8< 8< 8< 8< 8< 8< 8< 8< 8< 
# /etc/init.d/mysql start
dbg:  >>> start()
 * Starting mysql ...
dbg:  >>> get_slot_config()
dbg:  srv                0
dbg:  srv_slot           0
dbg:  srv_num
dbg:  tmp_eval           mysql_slot_0[@]
dbg:  conf_d_parameters
dbg:  MY_SUFFIX
dbg:  chroot dir =>
dbg:  niceness   =>
dbg:  basedir    => /usr
dbg:  datadir    => /srv/mysql-500
dbg:  pidfile    => /var/run/mysqld/mysqld.pid
dbg:  socket     => /var/run/mysqld/mysqld.sock
dbg:  Unamanged  =>
dbg:  <<< get_slot_config() ok
dbg:  >>> checkconfig("/srv/mysql-500")
dbg:  <<< checkconfig() ok
 * Starting mysql (/etc/mysql/my.cnf)
dbg:  starting mysqld with: --defaults-file=/etc/mysql/my.cnf   --basedir=/usr --datadir=/srv/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock
Starting /usr/sbin/mysqld...
Detaching to start /usr/sbin/mysqld...done.
dbg:
dbg:
dbg:  <<< start()                                                                                                                              [ ok ]
8< 8< 8< 8< 8< 8< 8< 8< 8< 8< 8< 8< 8< 8< 8< 8< 8< 

since it fail, we are interested in the row starting with "starting mysqld with:" (sorry for the lame word trick)

then try to manually launch mysqld with the wales displayd:

mysqld \
--defaults-file=/etc/mysql/my.cnf   --basedir=/usr --datadir=/srv/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock

and look at what hapened, "strace", "gdb" are additional tools that generally help a lot here, take a look at:

http://dev.mysql.com/doc/refman/5.0/en/using-gdb-on-mysqld.html
http://dev.mysql.com/doc/refman/5.0/en/crashing.html
http://dev.mysql.com/doc/refman/5.0/en/bug-reports.html

if the strace is not enough however recompile mysql with debug information may be needed:

FEATURES='nostrip debug' \
CFLAGS='-O2 -march=i686 -pipe -ggdb' \
CXXFLAGS='-O2 -march=i686 -pipe -ggdb' \
USE=debug \
emerge mysql

to have a better "backtrace" 

regards
Comment 6 Souleyman 2006-12-10 10:28:01 UTC
Thank's for help
I have disabled log-bin in my.cnf and mysql seems to work fine :o)
Best regards
Souleyman
Comment 7 Francesco R. (RETIRED) gentoo-dev 2006-12-10 10:37:50 UTC
interesting, never seen this issue ...
closing until someone come again with a similar one