Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
mysql fails to start on bootup
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Other Things Gentoo
View previous topic :: View next topic  
Author Message
plut0
Apprentice
Apprentice


Joined: 21 Dec 2004
Posts: 272

PostPosted: Fri Sep 12, 2008 3:09 am    Post subject: mysql fails to start on bootup Reply with quote

Everytime I reboot, the mysql init script says it fails to start. However, the process actually does start up. Sometimes on bootup it complains about the socket existing which makes me think its not shutting down properly on reboot. The console shows this:

Code:
 * Starting mysql...
 * Starting mysql (/etc/mysql/my.cnf)
 * MySQL NOT started (0)


emerge mysql -pv
Code:
[ebuild   R   ] dev-db/mysql-5.0.60-r1  USE="berkdb -big-tables -cluster -debug -embedded -extraengine -latin1 -max-idx-128 -minimal perl (-selinux) ssl -static" 0 kB


emerge --info
Code:
Portage 2.1.4.4 (hardened/amd64/multilib, gcc-3.4.6, glibc-2.6.1-r0, 2.6.25-hardened-r5 x86_64)
=================================================================
System uname: 2.6.25-hardened-r5 x86_64 AMD Athlon(tm) 64 Processor 3200+
Timestamp of tree: Thu, 11 Sep 2008 04:04:01 +0000
distcc 2.18.3 x86_64-pc-linux-gnu (protocols 1 and 2) (default port 3632) [disabled]
ccache version 2.4 [enabled]
app-shells/bash:     3.2_p33
dev-lang/python:     2.5.2-r6
dev-util/ccache:     2.4-r7
sys-apps/baselayout: 1.12.11.1
sys-apps/sandbox:    1.2.18.1-r2
sys-devel/autoconf:  2.13, 2.61-r2
sys-devel/automake:  1.4_p6, 1.5, 1.7.9-r1, 1.9.6-r2, 1.10.1
sys-devel/binutils:  2.18-r3
sys-devel/gcc-config: 1.4.0-r4
sys-devel/libtool:   1.5.26
virtual/os-headers:  2.6.23-r3
ACCEPT_KEYWORDS="amd64"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-O2 -pipe -march=k8 -fomit-frame-pointer"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/php/apache2-php5/ext-active/ /etc/php/cgi-php5/ext-active/ /etc/php/cli-php5/ext-active/ /etc/revdep-rebuild /etc/splash /etc/terminfo /etc/udev/rules.d"
CXXFLAGS="-O2 -pipe -march=k8 -fomit-frame-pointer"
DISTDIR="/var/tmp/distfiles"
EMERGE_DEFAULT_OPTS="--alphabetical"
FEATURES="autoconfig ccache digest distlocks dstlocks metadata-transfer parallel parallel-fetch sandbox sfperms strict unmerge-orphans userfetch"
GENTOO_MIRRORS="http://distfiles.gentoo.org http://distro.ibiblio.org/pub/linux/distributions/gentoo"
LINGUAS="en en_US"
MAKEOPTS="-j2"
PKGDIR="/var/tmp/packages"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY="/usr/local/portage"
USE="acl amd64 apache2 bash-completion berkdb bzip2 cracklib crypt doc gcj hardened javascript jpeg justify ldap midi nls nptl nptlonly pam perl pic png readline samba skey snmp sse sse2 sse3 ssl tcpd threads tiff urandom vhosts xorg zlib" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" ALSA_PCM_PLUGINS="adpcm alaw asym copy dmix dshare dsnoop empty extplug file hooks iec958 ioplug ladspa lfloat linear meter mmap_emul mulaw multi null plug rate route share shm softvol" APACHE2_MODULES="actions alias auth_basic auth_digest authn_anon authn_dbd authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache dav dav_fs dav_lock dbd deflate dir disk_cache env expires ext_filter file_cache filter headers ident imagemap include info log_config logio mem_cache mime mime_magic negotiation proxy proxy_ajp proxy_balancer proxy_connect proxy_http rewrite setenvif so speling status unique_id userdir usertrack vhost_alias" ELIBC="glibc" INPUT_DEVICES="mouse keyboard" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LINGUAS="en en_US" USERLAND="GNU" VIDEO_CARDS="apm ark chips cirrus cyrix dummy fbdev glint i128 i810 mach64 mga neomagic nv r128 radeon rendition s3 s3virge savage siliconmotion sis sisusb tdfx tga trident tseng v4l vesa vga vmware voodoo"
Unset:  CPPFLAGS, CTARGET, FFLAGS, INSTALL_MASK, LANG, LC_ALL, LDFLAGS, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS
Back to top
View user's profile Send private message
VinzC
Watchman
Watchman


Joined: 17 Apr 2004
Posts: 5098
Location: Dark side of the mood

PostPosted: Fri Sep 12, 2008 11:19 am    Post subject: Reply with quote

Are you using baselayout-2* and OpenRC?
_________________
Gentoo addict: tomorrow I quit, I promise!... Just one more emerge...
1739!
Back to top
View user's profile Send private message
plut0
Apprentice
Apprentice


Joined: 21 Dec 2004
Posts: 272

PostPosted: Fri Sep 12, 2008 3:55 pm    Post subject: Reply with quote

No and no.
Back to top
View user's profile Send private message
VinzC
Watchman
Watchman


Joined: 17 Apr 2004
Posts: 5098
Location: Dark side of the mood

PostPosted: Fri Sep 12, 2008 5:08 pm    Post subject: Reply with quote

Hmm... using parallel_startup?

Otherwise are you mounting /var from another partition? Have you checked /var/run/mysqld/ is empty before mysql starts? Make sure it's empty before mysqld starts. Also make sure mysqld is not run from any other local script.
_________________
Gentoo addict: tomorrow I quit, I promise!... Just one more emerge...
1739!
Back to top
View user's profile Send private message
plut0
Apprentice
Apprentice


Joined: 21 Dec 2004
Posts: 272

PostPosted: Fri Sep 12, 2008 9:32 pm    Post subject: Reply with quote

Not using parallel_startup. The /var is another partition, what significance does this have on this issue? I suppose I can tweak the init script to list the contents of /var/run/mysqld and perhaps clean it up. I shouldn't have to do this though.
Back to top
View user's profile Send private message
VinzC
Watchman
Watchman


Joined: 17 Apr 2004
Posts: 5098
Location: Dark side of the mood

PostPosted: Sun Sep 14, 2008 9:41 am    Post subject: Reply with quote

plut0 wrote:
Not using parallel_startup. The /var is another partition, what significance does this have on this issue? I suppose I can tweak the init script to list the contents of /var/run/mysqld and perhaps clean it up. I shouldn't have to do this though.

With /var being mounted there might be an existing /var tree on your root filesystem, with mysqld socket and pid files. It's easier to use a livecd to check that. In cases /var was forced unmount there might also be residues of socket and pid files on the /var partition.

As an easy check, stop mysql manually before you power off/reboot your computer. If you get a clean start, then you'll have a hint. If you still get the same behaviour then it probably means mysql was started twice. Then remove mysql from any runlevel, reboot and check if mysqld is running.
_________________
Gentoo addict: tomorrow I quit, I promise!... Just one more emerge...
1739!
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Other Things Gentoo All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum