Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
/etc/init.d/mysql start - fails [SOLVED]
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Networking & Security
View previous topic :: View next topic  
Author Message
dufeu
l33t
l33t


Joined: 30 Aug 2002
Posts: 896
Location: US-FL-EST

PostPosted: Fri Nov 13, 2015 12:27 am    Post subject: /etc/init.d/mysql start - fails [SOLVED] Reply with quote

mysql no longer starts at boot time. When I try to start it manually, I get only this message in /var/log/messages:
Quote:
mysql[1579]: ERROR: mysql failed to start

These are the terminal messages displayed when I try to manually start mysql using /etc/init.d/mysql:
Quote:
# /etc/init.d/mysql start
* Caching service dependencies ... [ ok ]
* Checking mysqld configuration for mysql ...
2015-11-12 18:42:10 139974306531136 [Warning] No argument was provided to --log-bin and neither --log-basename or --log-bin-index where used; This may cause repliction to break when this server acts as a master and has its hostname changed! Please use '--log-basename=pyrogyro' or '--log-bin=mysqld-bin' to avoid this problem.
2015-11-12 18:42:10 139974306531136 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-12 18:42:10 139974306531136 [Warning] Could not open mysql.plugin table. Some options may be missing from the help text
151112 18:42:10 [ERROR] mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see http://kb.askmonty.org/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

Server version: 10.1.8-MariaDB-log
key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=0
max_threads=153
thread_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 136938 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x48000
/usr/sbin/mysqld(my_print_stacktrace+0x29)[0x5605f7d7f689]
/usr/sbin/mysqld(handle_fatal_signal+0x35d)[0x5605f7970d8d]
/lib64/libpthread.so.0(+0x10b30)[0x7f4e4d8bbb30]
/usr/sbin/mysqld(_ZN7sys_varC1EP13sys_var_chainPKcS3_ili16get_opt_arg_type20enum_mysql_show_typexP8PolyLockNS_18binlog_status_enumEPFbPS_P3THDP7set_varEPFbS9_SB_13enum_var_typeES3_+0x113)[0x5605f77b92d3]
/usr/sbin/mysqld(_ZN17sys_var_pluginvarC1EP13sys_var_chainPKcP13st_plugin_intP16st_mysql_sys_var+0xa2)[0x5605f7834f0a]
/usr/sbin/mysqld(+0x4011bb)[0x5605f78351bb]
/usr/sbin/mysqld(+0x4015d8)[0x5605f78355d8]
/usr/sbin/mysqld(_Z11plugin_initPiPPci+0x93a)[0x5605f783666a]
/usr/sbin/mysqld(+0x3755cd)[0x5605f77a95cd]
/usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x4c0)[0x5605f77ae400]
/lib64/libc.so.6(__libc_start_main+0xf0)[0x7f4e4c66b610]
/usr/sbin/mysqld(_start+0x29)[0x5605f77a3399]
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
* mysql config check failed [ !! ]
* ERROR: mysql failed to start

According to MYSQL SERVER ERROR CODES AND MESSAGES 1550 - 1599, message 1579 is:
Quote:
Error: 1579 SQLSTATE: HY000 (ER_UNSUPORTED_LOG_ENGINE)

Message: This storage engine cannot be used for log tables"

I'm not a mysql DB guru and I've always accepted the defaults in my Gentoo installations. I've followed the advice provided during 'emerge' upgrades and mail notices. i.e. The point is that I run a vanilla install of mysql.

As per previous notices I'm currently running 'mariadb':
Quote:
# eix mariadb
[I] dev-db/mariadb
Available versions: (~)5.5.46^d 10.0.21(0/18)^td (~)10.0.21-r1(0/18)^td{tbz2} 10.0.22(0/18)^td (~)10.0.22-r1(0/18)^td (~)10.1.8(0/18)^td{tbz2} {bindist client-libs cluster +community cracklib debug embedded extraengine galera innodb-lz4 innodb-lzo innodb-snappy jemalloc latin1 libressl max-idx-128 minimal mroonga odbc +openssl oqgraph pam +perl profiling selinux +server sphinx ssl sst-rsync sst-xtrabackup static static-libs systemd systemtap tcmalloc test tokudb +tools xml yassl ABI_MIPS="n32 n64 o32" ABI_PPC="32 64" ABI_S390="32 64" ABI_X86="32 64 x32"}
Installed versions: 10.1.8^d{tbz2}(02:00:36 PM 11/12/2015)(client-libs cracklib embedded odbc openssl pam perl server tools xml -bindist -debug -extraengine -galera -innodb-lz4 -innodb-lzo -innodb-snappy -jemalloc -latin1 -libressl -mroonga -oqgraph -profiling -selinux -sphinx -sst-rsync -sst-xtrabackup -static -static-libs -systemd -systemtap -tcmalloc -test -tokudb -yassl ABI_MIPS="-n32 -n64 -o32" ABI_PPC="-32 -64" ABI_S390="-32 -64" ABI_X86="32 64 -x32")
Homepage: http://mariadb.org/
Description: An enhanced, drop-in replacement for MySQL

I obviously can't run
Code:
mysql_upgrade -u root -p
if I can't get a running instance of 'mysqld'. For the same reason, I can't run any mysqkl admin tasks.

Some pointers would be very much appreciated.
_________________
People whom think M$ is mediocre, don't know the half of it.


Last edited by dufeu on Fri Nov 13, 2015 3:55 am; edited 2 times in total
Back to top
View user's profile Send private message
khayyam
Watchman
Watchman


Joined: 07 Jun 2012
Posts: 6228
Location: Room 101

PostPosted: Fri Nov 13, 2015 1:02 am    Post subject: Re: /etc/init.d/mysql start - fails Reply with quote

dufeu wrote:
Code:
[Warning] No argument was provided to --log-bin and neither --log-basename or --log-bin-index where used;  This may cause repliction to break when this server acts as a master and has its hostname changed! Please use '--log-basename=pyrogyro' or '--log-bin=mysqld-bin' to avoid this problem.

dufeu ... given these parameters were introduced in 10.1.6 I imagine the init script and/or conf.d/mariadb currently installed isn't addapted for them ... and your mysql.cnf doesn't define them. That would be the most obvious reason ... 10.1.x all being ~arch.

See, log-bin, log-bin-basename, etc.

ps. please fix the the line breaks in the above.

HTH & best ... khay
Back to top
View user's profile Send private message
dufeu
l33t
l33t


Joined: 30 Aug 2002
Posts: 896
Location: US-FL-EST

PostPosted: Fri Nov 13, 2015 3:54 am    Post subject: Re: /etc/init.d/mysql start - fails Reply with quote

khayyam wrote:
dufeu ... given these parameters were introduced in 10.1.6 I imagine the init script and/or conf.d/mariadb currently installed isn't addapted for them ... and your mysql.cnf doesn't define them. That would be the most obvious reason ... 10.1.x all being ~arch.

See, log-bin, log-bin-basename, etc.

ps. please fix the the line breaks in the above.

HTH & best ... khay

Thank you for pointers. In and of themselves, they weren't 'the answer' but they did start me thinking in other tangents rather than getting stuck on error messages and wondering what was going on. I'm not certain what the 'mariadb' package is supposed to install in terms of scripts, but the only relavent scripts in /etc/init.d/ and etc/conf.d/ are 'mysql', 'mysql-s6' and 'mysqlmanager'. There were no 'mariadb' scripts.

I checked to see what depended directly on 'mariadb':
Code:
# equery d mariadb
 * These packages depend on mariadb:
virtual/libmysqlclient-18 (dev-db/mariadb:0[client-libs(+),static-libs?,abi_x86_32(-)?,abi_x86_64(-)?,abi_x86_x32(-)?,abi_mips_n32(-)?,abi_mips_n64(-)?,abi_mips_o32(-)?,abi_ppc_32(-)?,abi_ppc_64(-)?,abi_s390_32(-)?,abi_s390_64(-)?])
virtual/mysql-5.6-r6 (embedded ? =dev-db/mariadb-10.1*[client-libs(+),embedded,static=])
                     (embedded ? =dev-db/mariadb-10.0*[client-libs(+),embedded,static=])
                     (!embedded ? =dev-db/mariadb-10.1*[-embedded,static=])
                     (!embedded ? =dev-db/mariadb-10.0*[-embedded,static=])

Since 'mariadb' is a drop in replacement for 'mysql', the 'virtual/mysql' tells us everything we need to know about 'mariadb' version requirements. Basically, I wanted to confirm if and how far downards I could push the version of 'mariadb' I had installed. The above told me version 10.0.22-r1 was acceptable so I installed this version instead and tried to start 'mysql' again.
Code:
# /etc/init.d/mysql start
 * Caching service dependencies ...                                                                 [ ok ]
 * Checking mysqld configuration for mysql ...                                                      [ ok ]
 * Starting mysql ...
 * start-stop-daemon: caught an interrupt
 * start-stop-daemon: /usr/sbin/mysqld died                                                         [ !! ]
 * ERROR: mysql failed to start

Again, the service failed to start, but the fact that this previous version of 'mariadb' had been working at one point suggested it was perhaps time to replace the existing database.

I move the existing /var/log/mysql directory to another location and ran:
Code:
emerge --config  =dev-db/mariadb-10.0.22-r1

I then tried to start the service and it stated with no failure messages.

I finally updated to 'mariadb-10.1.8' and restarted the 'mysql' service and it successfully restarted.

In theory, I understand one doesn't really want to 'blow' away one's databases and restart them from nothing. After thinking about it, in my case, my only current uses for 'mysql' are for embedded databases as required by a few installed packages which are for their internal uses only. As such, it dosn't hurt me to clear the DB files. They'll get rebuilt as needed anyway.

Thanks again for your reply. It really did get me out of the rut I was in and into thinking more about other approaches.
_________________
People whom think M$ is mediocre, don't know the half of it.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Networking & Security 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