We have a master-slave replication that was running perfectly until recently. Today i've found the error:
Query caused different errors on master and slave. Error on master: message (format)='Size of tree cache used in bulk insert optimisation. Note that this is a limit per thread!' error code=126; Error on slave:actual message='no error', error code=0. Default database:'dbname'. Query:'UPDATE table SET something='0', something2='' WHERE something3=4'
We are using GTID based replication.
I tried to skip 1 GTID knowing that the query wasn't important anyway, but it didn't help (the slave sql didn't want to run).
ignore_error = 126 worked, but then I turned it off immediately, and another query did the same thing.
The error that the slave shows for the master doesn't seem to be an error, only a documentation for bulk insert optimization.
What's the best way to make the replication work again?
edit: I've executed a problematic query on the master, and it worked.