MySQL Forums
Forum List  »  Replication

Re: MySQL 5.6.21 signal 11 crashing instantaneously after START SLAVE
Posted by: Wagner Bianchi
Date: October 27, 2014 02:47PM

I've just got a MySQL 5.6.21 box running once again on mysql environment as a slave server, which one I'm using to test a new SSD Storage and this is executing all the transactions reading form the relay logs. At this moment, everything seems to be OK, event executing events having tables with `datetime` columns on old format.

Regarding your question about the mtype, all the `datetime` columns has its MTYPE value as 6. A sample below:

[bianchi@srv105873-br logs]$ mysql -u bianchi -p -e "select mtype from information_schema.innodb_sys_columns where name ='x' limit 10"
Enter password:
+-------+
| mtype |
+-------+
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
| 6 |
+-------+

My slave server is catching up overnight and tomorrow I'll let you know if this stops or it's finely replicating.

Cheers, WB

Wagner Bianchi - +55 31 8654-9510
Profile: bit.ly/toG94v
Blog: wagnerbianchi.com/blog
Twitter: @wagnerbianchijr
Skype: wbianchijr

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQL 5.6.21 signal 11 crashing instantaneously after START SLAVE
1444
October 27, 2014 02:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.