Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
Mysql 5.6.39 - Crashes on startup sometimes
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
jenkler
Apprentice
Apprentice


Joined: 28 Apr 2003
Posts: 222
Location: Sweden - Stockholm

PostPosted: Mon Feb 19, 2018 10:49 pm    Post subject: Mysql 5.6.39 - Crashes on startup sometimes Reply with quote

Just wondering if anyone else have this issue? Mysql crashes when starting but not always. When it works it seams to work :)

- Mysql upgrade worked fine
- Using default my.cnf from that build!

------------
2018-02-19 23:14:50 4136 [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.
2018-02-19 23:14:50 4136 [Note] InnoDB: Using atomics to ref count buffer pool pages
2018-02-19 23:14:50 4136 [Note] InnoDB: The InnoDB memory heap is disabled
2018-02-19 23:14:50 4136 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2018-02-19 23:14:50 4136 [Note] InnoDB: Memory barrier is not used
2018-02-19 23:14:50 4136 [Note] InnoDB: Compressed tables use zlib 1.2.11
2018-02-19 23:14:50 4136 [Note] InnoDB: Using Linux native AIO
2018-02-19 23:14:50 4136 [Note] InnoDB: Using CPU crc32 instructions
2018-02-19 23:14:50 4136 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2018-02-19 23:14:50 4136 [Note] InnoDB: Completed initialization of buffer pool
2018-02-19 23:14:50 4136 [Note] InnoDB: Highest supported file format is Barracuda.
2018-02-19 23:14:50 4136 [Note] InnoDB: 128 rollback segment(s) are active.
2018-02-19 23:14:50 4136 [Note] InnoDB: Waiting for purge to start
2018-02-19 23:14:50 4136 [Note] InnoDB: 5.6.39 started; log sequence number 183354962
2018-02-19 23:14:50 4136 [Warning] /usr/sbin/mysqld: unknown option '--loose-federated'
2018-02-19 23:14:51 4136 [Note] RSA private key file not found: /server/mysql//private_key.pem. Some authentication plugins will not work.
2018-02-19 23:14:51 4136 [Note] RSA public key file not found: /server/mysql//public_key.pem. Some authentication plugins will not work.
22:14:51 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 = 134280 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 0x40000
/usr/sbin/mysqld(my_print_stacktrace+0x3f)[0x30d8f8565cf]
/usr/sbin/mysqld(handle_fatal_signal+0x3d6)[0x30d8f571626]
/lib64/libpthread.so.0(+0x14b20)[0x3aacaaedb20]
/usr/sbin/mysqld(_ZN14Relay_log_infoC1EbPjS0_S0_S0_S0_S0_S0_j+0x235)[0x30d8f823f55]
/usr/sbin/mysqld(_ZN16Rpl_info_factory10create_rliEjb+0x1fd)[0x30d8f829afd]
/usr/sbin/mysqld(_ZN16Rpl_info_factory19create_coordinatorsEjPP11Master_infojPP14Relay_log_info+0x67)[0x30d8f82a9f7]
/usr/sbin/mysqld(_Z10init_slavev+0xf5)[0x30d8f81a4b5]
/usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x19d1)[0x30d8f469871]
/lib64/libc.so.6(__libc_start_main+0xfd)[0x3aac9dda5ad]
/usr/sbin/mysqld(_start+0x2a)[0x30d8f45a4aa]
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.
----
_________________
Hello from me: Jenkler IT AB (swedish) (use google translate). Check out my Linux manpages for web in english.
Back to top
View user's profile Send private message
jenkler
Apprentice
Apprentice


Joined: 28 Apr 2003
Posts: 222
Location: Sweden - Stockholm

PostPosted: Mon Feb 19, 2018 11:23 pm    Post subject: Reply with quote

This is not a solution but, i changed to MariaDB (10.1.29-MariaDB)

1. Make backup of db
2. removed mysql
3. Installed Mariadb
4. Did a mysql_upgrade -u root -p

Now everything seams to work. Maybe mysql is kinda broken.
_________________
Hello from me: Jenkler IT AB (swedish) (use google translate). Check out my Linux manpages for web in english.
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