…’d suggest reading over the manual’s description of how replication filtering rules are processed. There are some informative flowcharts in… if you’re not using GTID-based replication. If you are using GTID-based replication, it looks like you’ll need to… variant of this message: 130606 2:22:41 [ERROR] /usr/libexec/mysqld: Incorrect information in file: ‘./mysql/servers.frm’ ERROR: 1033 Incorrect information…
Post: The small improvements of MySQL 5.6: Duplicate Index Detection
May 31, 2013 By Leave a Comment
… 5.6 brought: GTID-based replication, InnoDB Fulltext, Memcached integration, a more….5, you will succeed without errors or warnings: mysql> ALTER TABLE test …WARNINGS\G *************************** 1. row *************************** Level: Note Code: 1831 Message: Duplicate index ‘col2_2′ defined on…
Comment: Percona XtraBackup 2.1.3 for MySQL available for download
May 30, 2013 By 3 Comments
… corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware… mysqld died. If you see no messages after this, something went terribly wrong… stack_…+0×23)[0x7f9337da4c13] /usr/sbin/mysqld(_Z25wsrep_replication_processP3THD+0x4b)[0x595edb] /usr/sbin/mysqld(…
Post: Disconnecting a replication slave is easier with MySQL 5.5+ (RESET SLAVE vs. RESET SLAVE ALL)
April 17, 2013 By 2 Comments
… better! If we try to restart replication, it fails. However, I don’t like the error message, specifically the ‘fix in config file… makes disconnecting the replica impossible. And again, if you restart replication, it will read events from the first available binary log…, you will be able to restart replication, but again as no replication coordinate is specified, replication will start at the beginning of the…
Post: Percona XtraBackup 2.1.2 for MySQL available for download
May 18, 2013 By 4 Comments
… a replication slave with the innobackupex –slave-info option, innobackupex failed with a fatal error. Replaced the fatal error with a diagnostic message about…
Post: Confusing MySQL Replication Error Message
June 4, 2008 By 11 Comments
… Error Messages which are confusing, here is one more: 080603 20:53:10 [Note] Slave: connected to master ‘repl@host.com:3306′,replication… Server I’m getting error log file flooded with messages like this and there is no hint in the message what would explain… it would be nice to include possible reason for this error message which MySQL already does in many other cases. I’ve…
Post: Replication checksums in MySQL 5.6
February 15, 2013 By 3 Comments
…nice error message: slave1 [localhost] {msandbox} ((none)) > show slave status\G [...] Slave_IO_Running: Yes Slave_SQL_Running: No [...] Last_Errno: 1594 Last_Error… 103, event_type: 2 ERROR: Could not read entry at offset 283: Error in log format or read error. [...] Replication checksums on the …
Post: How to create/restore a slave using GTID replication in MySQL 5.6
February 8, 2013 By 7 Comments
…it on the slave to set up a new replication server. master > show global variables like ‘gtid_executed’; +—————+——————————————-+ | Variable… Wop! It is important to mention that these kind of error messages can dissapear on the shell buffer because the restore…
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
… like RAND() are used in DML statements. A statement based replication slave can get out of sync with the master fairly… rows, a replication slave which does not find a row referenced in a row-based log will immediately return an error: HA…; handler error HA_ERR_KEY_NOT_FOUND; the event’s master log mysql-bin.000001, end_log_pos 340718 This error message is…
Post: Missleading Innodb message on recovery
February 15, 2010 By 2 Comments
…. The customer came to me today having the following message in the error log after Slave crash while running MySQL 5.1… version without XtraDB or Percona Patches) InnoDB: In a MySQL replication slave the last master binlog file InnoDB: position 0 10000000… find first log file name in binary log index file” error message Looking at the Master for this slave I could see…
