Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Decode the logfile sudo mysqlbinlog --base64-output=decode-rows /var/log/mysql/{mysql-bin_file_from_error} > /tmp/someTempFile.sql (binlogs are only readable by mysql user & group).

  2. Search for the position by the number in the error. From that point in the file you can find the next position by searching forward for end_log_pos.

  3. Update the binlog_position field in maxwell.positionsto move where the cdc will try to resume. I initially tried the first but this was also a problem. It may be that anything in the same transaction will also be an issue.

Misc thoughts: