Summary: | dev-db/mysql-5.0.26-r1 - init script doesn't restart | ||
---|---|---|---|
Product: | Gentoo Linux | Reporter: | Souleyman <administrateur> |
Component: | New packages | Assignee: | 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
Created attachment 103691 [details]
Mysqld error log
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 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. 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 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 Thank's for help I have disabled log-bin in my.cnf and mysql seems to work fine :o) Best regards Souleyman interesting, never seen this issue ... closing until someone come again with a similar one |