Mysql does not start. [Solved]

Discussions Regarding Software

Moderator: Moderators

Mysql does not start. [Solved]

Postby nobicycle » Tue Sep 11, 2012 4:18

dev-db/mysql-5.5.22-r1

sudo /etc/init.d/mysql start
* Starting mysql ...
* You don't appear to have the mysql database installed yet.
* Please run /usr/bin/mysql_install_db to have this done...
* ERROR: mysql failed to start


Prior to the current version, "equo install dev-db/mysql" would complete all configure stages but now that seems broken.

I tried running
/usr/share/mysql/scripts/mysql_install_db --user=mysql --basedir=/usr --datadir=/home/user/database/mysql --verbose

(changing the default datadir also)

but the result was:

Installing MySQL system tables...

Installation of system tables failed! Examine the logs in
/home/user/database/mysql for more information.

You can try to start the mysqld daemon with:

shell> /usr/sbin/mysqld --skip-grant &

and use the command line tool /usr/bin/mysql
to connect to the mysql database and look at the grant tables:

shell> /usr/bin/mysql -u root mysql
mysql> show tables



The error log:

120911 12:54:09 [Warning] No argument was provided to --log-bin, and --log-bin-index was not used; so replication may break when this MySQL server acts as a master and has his hostname changed!! Please use '--log-bin=mysqld-bin' to avoid this problem.
120911 12:54:09 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Table 'mysql.plugin' doesn't exist
120911 12:54:09 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
120911 12:54:09 InnoDB: The InnoDB memory heap is disabled
120911 12:54:09 InnoDB: Mutexes and rw_locks use GCC atomic builtins
120911 12:54:09 InnoDB: Compressed tables use zlib 1.2.6
120911 12:54:09 InnoDB: Using Linux native AIO
120911 12:54:09 InnoDB: Initializing buffer pool, size = 16.0M
120911 12:54:09 InnoDB: Completed initialization of buffer pool
120911 12:54:10 InnoDB: highest supported file format is Barracuda.
InnoDB: Log scan progressed past the checkpoint lsn 48941
120911 12:54:10 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
120911 12:54:10 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: Doing recovery: scanned up to log sequence number 1595675
120911 12:54:10 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
120911 12:54:11 InnoDB: Waiting for the background threads to start
120911 12:54:12 InnoDB: 1.1.8 started; log sequence number 1595675
120911 12:54:12 [Note] Recovering after a crash using mysqld-bin
120911 12:54:12 [Note] Starting crash recovery...
120911 12:54:12 [Note] Crash recovery finished.
120911 12:54:12 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist




Any help would be appreciated.
Last edited by nobicycle on Sat Sep 15, 2012 17:27, edited 1 time in total.
nobicycle
Simple Hen
 
Posts: 60
Joined: Fri Nov 20, 2009 13:55

Re: Mysql does not start.

Postby svantoviit » Tue Sep 11, 2012 8:34

tried to configure the database with equo?
of course as root (su)
Code: Select all
equo config dev-db/mysql
User avatar
svantoviit
Technological Hen
 
Posts: 393
Joined: Sun Feb 28, 2010 17:55
Location: Europe

Re: Mysql does not start.

Postby giovannicoan » Tue Sep 11, 2012 11:40

i have the same problem, so i tried equo, as you suggest...that is:
localhost ~ # equo config dev-db/mysql
>> # (1/1) dev-db/mysql-5.5.22-r1 | Installato da: sabayon-weekly
>> ## Configurazione pacchetto: dev-db/mysql-5.5.22-r1
>> ## SPM: fase di configurazione
* Please provide a password for the mysql 'root' user now, in the
* MYSQL_ROOT_PASSWORD env var or through the /root/.my.cnf file.
* Avoid ["'\_%] characters in the password
>
* Retype the password
>
* ERROR: dev-db/mysql-5.5.22-r1 failed (config phase):
* Failed to run mysql_install_db. Please review /var/log/mysql/mysqld.err AND /tmp/tmp4iQ_Rk/portage/dev-db/mysql-5.5.22-r1/temp/mysql_install_db.log
*
* Call stack:
* ebuild.sh, line 85: Called pkg_config
* environment, line 3441: Called mysql-v2_pkg_config
* environment, line 3095: Called die
* The specific snippet of code:
* die "Failed to run mysql_install_db. Please review ${EPREFIX}/var/log/mysql/mysqld.err AND ${TMPDIR}/mysql_install_db.log";
*
* If you need support, post the output of `emerge --info '=dev-db/mysql-5.5.22-r1'`,
* the complete build log and the output of `emerge -pqv '=dev-db/mysql-5.5.22-r1'`.
* The complete build log is located at '/tmp/tmp4iQ_Rk/portage/dev-db/mysql-5.5.22-r1/temp/build.log'.
* The ebuild environment file is located at '/tmp/tmp4iQ_Rk/portage/dev-db/mysql-5.5.22-r1/temp/environment'.
* Working directory: '/tmp/tmp4iQ_Rk/portage/dev-db/mysql-5.5.22-r1/temp'
* S: '/tmp/tmp4iQ_Rk/portage/dev-db/mysql-5.5.22-r1/work/mysql-5.5.22'
>> ## E' avvenuto un errore. Azione abortita.
>> @@ Ricerca file di configurazione completata.
localhost ~ # then i did :

localhost ~ # emerge --info '=dev-db/mysql-5.5.22-r1'
Portage 2.2.0_alpha123 (default/linux/amd64/10.0/desktop, gcc-4.6.3-vanilla, glibc-2.15-r2, 3.5.0-sabayon x86_64)
=================================================================
System Settings
=================================================================
System uname: Linux-3.5.0-sabayon-x86_64-Intel-R-_Core-TM-2_Duo_CPU_T5800_@_2.00GHz-with-gentoo-2.2
Timestamp of tree: Thu, 30 Aug 2012 13:45:01 +0000
app-shells/bash: 4.2_p37
dev-java/java-config: 2.1.12
dev-lang/python: 2.7.3-r2
dev-util/cmake: 2.8.9
dev-util/pkgconfig: 0.27.1
sys-apps/baselayout: 2.2::sabayon-distro
sys-apps/openrc: 0.10.5::sabayon-distro
sys-apps/sandbox: 2.6
sys-devel/autoconf: 2.13, 2.68
sys-devel/automake: 1.9.6-r3, 1.10.2, 1.11.1
sys-devel/binutils: 2.22-r1
sys-devel/gcc: 4.6.3::sabayon-distro
sys-devel/gcc-config: 1.7.3
sys-devel/libtool: 2.4-r1
sys-devel/make: 3.82-r1
sys-kernel/linux-headers: 3.1 (virtual/os-headers)
sys-libs/glibc: 2.15-r2::sabayon-distro
Repositories: gentoo
Installed sets: @system
ACCEPT_KEYWORDS="amd64 ~amd64"
ACCEPT_LICENSE="* -@EULA"
CBUILD="x86_64-pc-linux-gnu"
CFLAGS="-O2 -march=x86-64 -pipe"
CHOST="x86_64-pc-linux-gnu"
CONFIG_PROTECT="/etc /etc/conf.d /etc/entropy /etc/init.d /usr/share/config /usr/share/config/kdm /usr/share/gnupg/qualified.txt"
CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/dconf /etc/env.d /etc/fonts/fonts.conf /etc/gconf /etc/gentoo-release /etc/php/apache2-php5.3/ext-active/ /etc/php/apache2-php5.4/ext-active/ /etc/php/cgi-php5.3/ext-active/ /etc/php/cgi-php5.4/ext-active/ /etc/php/cli-php5.3/ext-active/ /etc/php/cli-php5.4/ext-active/ /etc/revdep-rebuild /etc/sandbox.d /etc/skel /etc/splash /etc/terminfo /etc/texmf/language.dat.d /etc/texmf/language.def.d /etc/texmf/updmap.d /etc/texmf/web2c"
CXXFLAGS="-O2 -march=x86-64 -pipe"
DISTDIR="/usr/portage/distfiles"
FCFLAGS="-O2 -pipe"
FEATURES="assume-digests binpkg-logs ccache config-protect-if-modified distlocks ebuild-locks fixlafiles news parallel-fetch parse-eapi-ebuild-head preserve-libs protect-owned sandbox sfperms splitdebug strict unknown-features-warn unmerge-logs unmerge-orphans userfetch"
FFLAGS="-O2 -pipe"
GENTOO_MIRRORS="ftp://mirrors.tera-byte.com/pub/gentoo ftp://ftp.spline.inf.fu-berlin.de/mirrors/gentoo/ http://archive.mmu.edu.my/gentoo rsync://gentoo.bloodhost.ru/gentoo-distfiles ftp://gentoo.mirrors.tds.net/gentoo ftp://ftp.halifax.rwth-aachen.de/gentoo/ rsync://mirror.neolabs.kz/gentoo http://ftp.gentoo.bg/ http://ftp.cc.uoc.gr/mirrors/linux/gentoo/ ftp://ftp.cc.uoc.gr/mirrors/linux/gentoo/"
LANG="it_IT.UTF-8"
LDFLAGS="-Wl,-O1 -Wl,--as-needed"
LINGUAS="en en_US af ar az bg bn br bs ca cs cy da de el en_GB eo es et eu fa fi fr fy ga gl he hi hr hu is it ja kk km ko lt lv mk mn ms nb nds nl nn pa pl pt pt_BR ro ru rw se sk sl sr sr@Latn ss sv ta tg tr uk uz vi zh_CN zh_TW es_AR es_ES fy_NL ga_IE gu gu_IN nb_NO nn_NO pt_PT sv_SE zh"
MAKEOPTS="-j16 -s"
PKGDIR="/usr/portage/packages"
PORTAGE_CONFIGROOT="/"
PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --human-readable --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages"
PORTAGE_TMPDIR="/var/tmp"
PORTDIR="/usr/portage"
PORTDIR_OVERLAY=""
SYNC="rsync://rsync.europe.gentoo.org/gentoo-portage"
USE="X a52 aac accessibility acl acpi aiglx aim alsa amd64 artswrappersuid audiofile avahi bash-completion berkdb bidi bluetooth bzip2 cairo cdda cddb cdr cjk cli consolekit cpudetection cracklib crypt cups cxx dbus dga dri dts dv dvb dvd dvdr dvdread dvi emboss encode exif fam fame fat ffmpeg firefox flac foomatic-db fortran freetype gcj gdbm gif gimpprint gmp gnutls gphoto2 gpm gsm gtk hfs iconv icq ieee1394 imap inotify ipod ipv6 irc irda jabber jack jfs joystick jpeg kdeenablefinal kdehiddenvisibility kerberos lame lcd lcms ldap libnotify live lm_sensors lzo mad mail matroska mjpeg mmx mng modules mozdevelop mp3 mp3rtp mp4 mpeg msn mudflap multilib musepack musicbrainz ncurses network nls nptl nsplugin ntfs ogg openal openexr opengl openmp pam pango pcmcia pcre pda pdf perl png policykit ppds pppd pulseaudio python qt3support qt4 rar rdesktop readline reiserfs rss scanner sdl session slp speex spell sse sse2 ssl startup-notification stream svg sysfs tcpd theora tiff truetype udev udisks unicode upower usb v4l v4l2 visualization vorbis wifi wmf wxwidgets x264 xcb xfs xine xinerama xml xpm xprint xulrunner xv xvid xvmc yahoo zeroconf zlib" ALSA_CARDS="emu10k1x darla20 darla24 emu10k1 gina20 gina24 hdsp hdspm ice1712 indigo indigoio layla20 layla24 mia mixart mona pcxhr rme32 rme96 sb16 sbawe sscape usbusx2y vx222 usb-usx2y" 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 authn_alias authn_anon authn_dbm authn_default authn_file authz_dbm authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache cgi cgid dav dav_fs dav_lock deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif speling status unique_id userdir usertrack vhost_alias" APACHE2_MPMS="prefork" CALLIGRA_FEATURES="kexi words flow plan sheets stage tables krita karbon braindump" CAMERAS="agfa_cl20 casio_qv dimagev dimera3500 kodak_dc120 kodak_dc210 kodak_dc240 kodak_dc3200 kodak_ez200 konica_qm150 panasonic_coolshot panasonic_dc1000 panasonic_dc1580 panasonic_l859 polaroid_pdc320 polaroid_pdc640 polaroid_pdc700 ricoh_g3 sipix_blink sipix_blink2 sipix_web2 sony_dscf1 sony_dscf55 toshiba_pdrm11 adc65 aox barbie canon clicksmart310 digigr8 digita directory enigma13 fuji gsmart300 hp215 iclick jamcam jd11 konica largan lg_gsm mars mustek pccam300 pccam600 ptp2 ricoh samsung sierra smal sonix soundvision spca50x sq905 stv0674 stv0680 sx330z template" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf superstar2 timing tsip tripmate tnt ubx" INPUT_DEVICES="evdev void" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LIBREOFFICE_EXTENSIONS="presenter-console presenter-minimizer" LINGUAS="en en_US af ar az bg bn br bs ca cs cy da de el en_GB eo es et eu fa fi fr fy ga gl he hi hr hu is it ja kk km ko lt lv mk mn ms nb nds nl nn pa pl pt pt_BR ro ru rw se sk sl sr sr@Latn ss sv ta tg tr uk uz vi zh_CN zh_TW es_AR es_ES fy_NL ga_IE gu gu_IN nb_NO nn_NO pt_PT sv_SE zh" LIRC_DEVICES="audio audio_alsa serial pctv" PHP_TARGETS="php5-3" PYTHON_TARGETS="python2_7" QEMU_SOFTMMU_TARGETS="x86_64 arm cris i386 m68k microblaze mips mips64 mips64el mipsel ppc ppc64 ppcemb sh4 sh4eb sparc sparc64" QEMU_USER_TARGETS="alpha arm armeb cris i386 m68k microblaze mips mipsel ppc ppc64 ppc64abi32 sh4 sh4eb sparc sparc32plus sparc64 x86_64" RUBY_TARGETS="ruby18" USERLAND="GNU" VIDEO_CARDS="fbdev vesa radeonhd" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account"
USE_PYTHON="2.7"
Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, LC_ALL, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, PORTAGE_RSYNC_EXTRA_OPTS

=================================================================
Package Settings
=================================================================

dev-db/mysql-5.5.22-r1 was built with the following:
USE="community embedded extraengine (multilib) perl ssl -berkdb -cluster -debug -latin1 -max-idx-128 -minimal -profiling (-selinux) -static -systemtap -test"
CFLAGS="-O2 -march=x86-64 -pipe -fno-strict-aliasing"
CXXFLAGS="-O2 -march=x86-64 -pipe -fno-exceptions -fno-strict-aliasing -felide-constructors -fno-rtti -fno-implicit-templates -fno-strict-aliasing"

Does anyone know the solution?
giovannicoan
Baby Hen
 
Posts: 2
Joined: Mon Dec 14, 2009 17:13

Re: Mysql does not start.

Postby nobicycle » Tue Sep 11, 2012 15:31

svantoviit wrote:tried to configure the database with equo?
of course as root (su)
Code: Select all
equo config dev-db/mysql


Yes I did try that. Same result as giovannicoan.
nobicycle
Simple Hen
 
Posts: 60
Joined: Fri Nov 20, 2009 13:55

Re: Mysql does not start.

Postby nobicycle » Sat Sep 15, 2012 17:26

Solved by our BD (Benevolent Dictator) Fabio Erculiani.
http://bugs.sabayon.org/show_bug.cgi?id=3647#c6
nobicycle
Simple Hen
 
Posts: 60
Joined: Fri Nov 20, 2009 13:55

Re: Mysql does not start. (Solved.)

Postby lxnay » Sat Sep 15, 2012 18:39

My apologies for taking so long... but I've been a bit overloaded
Image
Join us on IRC (chat.freenode.net #sabayon or WebChat)
Submit bugs to our Bug Tracker
Follow me on Twitter
Add me on Facebook
Add me on Google+
lxnay
Land Owner
 
Posts: 3415
Joined: Thu Oct 13, 2005 23:16
Location: Italy


Return to Software in General

Who is online

Users browsing this forum: No registered users and 1 guest