Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
mysql will not start
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Portage & Programming
View previous topic :: View next topic  
Author Message
linux_matt
Tux's lil' helper
Tux's lil' helper


Joined: 14 May 2012
Posts: 103

PostPosted: Thu Sep 25, 2014 10:41 pm    Post subject: mysql will not start Reply with quote

I use mysql for mythtv but it has suddenly stopped running up with systemd. would be grateful for any help in resolving this. Version of mysql is

mysql Ver 14.14 Distrib 5.6.20, for Linux (i686) using EditLine wrapper

At the end of this message is some information from the log file /var/log/mysql.err

immediately below is the output from systemctl status mysqld.service

Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled)
Active: failed (Result: start-limit) since Sun 2014-09-21 22:28:36 BST; 4 days ago
Process: 6701 ExecStartPost=/usr/libexec/mysqld-wait-ready $MAINPID (code=exited, status=1/FAILURE)
Process: 6700 ExecStart=/usr/bin/mysqld_safe --basedir=/usr (code=exited, status=0/SUCCESS)
Main PID: 6700 (code=exited, status=0/SUCCESS)

Sep 21 22:28:35 myth systemd[1]: Failed to start MySQL database server.
Sep 21 22:28:35 myth systemd[1]: Unit mysqld.service entered failed state.
Sep 21 22:28:36 myth systemd[1]: mysqld.service holdoff time over, schedu...t.
Sep 21 22:28:36 myth systemd[1]: Stopping MySQL database server...
Sep 21 22:28:36 myth systemd[1]: Starting MySQL database server...
Sep 21 22:28:36 myth systemd[1]: mysqld.service start request repeated to...t.
Sep 21 22:28:36 myth systemd[1]: Failed to start MySQL database server.
Sep 21 22:28:36 myth systemd[1]: Unit mysqld.service entered failed state.
Hint: Some lines were ellipsized, use -l to show in full.

Log file:

Thread pointer: 0x0
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 = 0 thread_stack 0x30000
/usr/sbin/mysqld(my_print_stacktrace+0x28)[0x849bfc8]
/usr/sbin/mysqld(handle_fatal_signal+0x3b3)[0x824f8f3]
linux-gate.so.1(__kernel_sigreturn+0x0)[0xb76f2400]
/usr/sbin/mysqld[0x85dd66a]
/usr/sbin/mysqld[0x85dfac4]
/usr/sbin/mysqld[0x8561a4a]
/usr/sbin/mysqld[0x84b77c7]
/usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x41)[0x819ebe1]
/usr/sbin/mysqld[0x82d00e8]
/usr/sbin/mysqld(_Z11plugin_initPiPPci+0x7f8)[0x82d4298]
/usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x8a6)[0x8198be6]
/usr/sbin/mysqld(main+0x1b)[0x817901b]
/lib/libc.so.6(__libc_start_main+0xf3)[0xb717d933]
/usr/sbin/mysqld[0x818df2c]
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.
140921 22:28:34 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
140921 22:28:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
2014-09-21 22:28:35 0 [Warning] Using unique option prefix key_buffer instead of key_buffer_size is deprecated and will be removed in a future release. Please use the full name instead.
2014-09-21 22:28:35 0 [Warning] The syntax '--language/-l' is deprecated and will be removed in a future release. Please use '--lc-messages-dir' instead.
2014-09-21 22:28:35 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2014-09-21 22:28:35 7155 [Warning] Using pre 5.5 semantics to load error messages from /usr/share/mysql/english/.
2014-09-21 22:28:35 7155 [Warning] If this is not intended, refer to the documentation for valid usage of --lc-messages-dir and --language parameters.
2014-09-21 22:28:35 7155 [Warning] Buffered warning: Changed limits: max_open_files: 1024 (requested 5000)

2014-09-21 22:28:35 b722d700 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-09-21 22:28:35 7155 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-09-21 22:28:35 7155 [Note] InnoDB: The InnoDB memory heap is disabled
2014-09-21 22:28:35 7155 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2014-09-21 22:28:35 7155 [Note] InnoDB: Memory barrier is not used
2014-09-21 22:28:35 7155 [Note] InnoDB: Compressed tables use zlib 1.2.8
2014-09-21 22:28:35 7155 [Note] InnoDB: Using Linux native AIO
2014-09-21 22:28:35 7155 [Note] InnoDB: Not using CPU crc32 instructions
2014-09-21 22:28:35 7155 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-09-21 22:28:35 7155 [Note] InnoDB: Completed initialization of buffer pool
2014-09-21 22:28:35 7155 [Note] InnoDB: Highest supported file format is Barracuda.
2014-09-21 22:28:35 7155 [Note] InnoDB: The log sequence numbers 35824214 and 35824214 in ibdata files do not match the log sequence number 37722030 in the ib_logfiles!
2014-09-21 22:28:35 7155 [Note] InnoDB: Database was not shutdown normally!
2014-09-21 22:28:35 7155 [Note] InnoDB: Starting crash recovery.
2014-09-21 22:28:35 7155 [Note] InnoDB: Reading tablespace information from the .ibd files...
2014-09-21 22:28:35 7155 [Note] InnoDB: Restoring possible half-written data pages
2014-09-21 22:28:35 7155 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 503949, file name ./mysqld-bin.000006
21:28:35 UTC - 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.
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.

key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 133772 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
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 = 0 thread_stack 0x30000
/usr/sbin/mysqld(my_print_stacktrace+0x28)[0x849bfc8]
/usr/sbin/mysqld(handle_fatal_signal+0x3b3)[0x824f8f3]
linux-gate.so.1(__kernel_sigreturn+0x0)[0xb77bd400]
/usr/sbin/mysqld[0x85dd66a]
/usr/sbin/mysqld[0x85dfac4]
/usr/sbin/mysqld[0x8561a4a]
/usr/sbin/mysqld[0x84b77c7]
/usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x41)[0x819ebe1]
/usr/sbin/mysqld[0x82d00e8]
/usr/sbin/mysqld(_Z11plugin_initPiPPci+0x7f8)[0x82d4298]
/usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x8a6)[0x8198be6]
/usr/sbin/mysqld(main+0x1b)[0x817901b]
/lib/libc.so.6(__libc_start_main+0xf3)[0xb7248933]
/usr/sbin/mysqld[0x818df2c]
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.
140921 22:28:35 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Portage & Programming 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