MySQL is the most popular open source database of … Continue Reading MySQL ERROR 1885 (HY000): Slave has more GTIDs than the master has, using the master’s SERVER_UUID. This may indicate that the end of the binary log was truncated or that the last binary log file was lost, e.g., after a power or disk failure when sync_binlog != 1. The master may or may not have rolled back transactions that were already replicated to the slave. Suggest to replicate any transactions that master has rolled back from slave to master, and/or commit empty transactions on master to account for transactions that have been committed on master but are not included in GTID_EXECUTED.

MySQL is the most popular open source database of … Continue Reading MySQL ERROR 1884 (HY000): Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == ‘UUID:NUMBER’.

MySQL is the most popular open source database of … Continue Reading MySQL ERROR 1876 (HY000): STOP SLAVE command execution is incomplete: Slave IO thread got the stop signal, thread is busy, IO thread will stop once the current task is complete.

MySQL is the most popular open source database of … Continue Reading MySQL ERROR 1875 (HY000): STOP SLAVE command execution is incomplete: Slave SQL thread got the stop signal, thread is busy, SQL thread will stop once the current task is complete.