Archive for the ‘MySQL’ Category

“Change master” to the rescue or how to revive MySQL replication

Sometime ago had an issue with MySQL replication that consecutively faulted with two different errors. Initially with this one: Last_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master’s binary log is corrupted (you can check this by running ‘mysqlbinlog’ on the binary log), the slave’s relay […]

Posted on January 10, 2016 at 9:58 pm by sergeyt · Permalink · 2 Comments
In: MySQL

mysqldump causes error 2006

Hot on the heels of the recent mysqldump I’ve been running on MySQL 5.5 which ended with the following error: Got error: 2006: MySQL server has gone away when selecting the database Turned out that this error is quite common and there is a quick work around for that – increase max_allowed_packet. In my case […]

Posted on November 22, 2015 at 4:11 pm by sergeyt · Permalink · Leave a comment
In: MySQL

What unites DEFINER, “show table status” and ERROR 1143 (42000) in MySQL

For the very first time I had seen this error a couple of days ago: mysql> show table status; ERROR 1143 (42000): SELECT command denied to user ”@’some_host_name_here’ for column ‘sid’ in table ‘masking’ What the heck was that?! Turned out that a colleague of mine was doing a cleanup in mysql.user table a day […]

Posted on October 16, 2015 at 9:37 pm by sergeyt · Permalink · Leave a comment
In: MySQL