The Question Recently, a customer asked us:
What is the meaning of this error message found in
2019/05/14 01:48:04.973 | mysql02.prod.example.com | [east
- binlog-to-q-0] INFO pipeline.SingleThreadStageTask Performing
rollback of possible partial transaction:
Simple Overview The Skinny
This message is an indication that we are dropping any uncommitted or incomplete data read from the MySQL binary logs due to a pending error.
The Answer Safety First
This error is often seen before another error and is an
indication that we are rolling back anything uncommitted, for
safety. On a master this is normally very little and would likely
be internal transactions in the
table, for example.
As you may know with the replicator we always extract complete transactions, and so this particular message is …[Read more]