Ask Your Question
1

"Failed to determine binlog filename" error with Mysql-Binary-Log

asked 2017-09-26 01:48:29 -0500

sujeet gravatar image

updated 2017-09-26 19:24:39 -0500

metadaddy gravatar image

I am trying to implement CDC using mysql-binary log in StreamSets. It first gave me JDBC driver not find error after that i fixed the issue but when i tried again it is giving me "failed to determine binlog filename". How to resolve this? Why such errors are coming?

edit retag flag offensive close merge delete

2 Answers

Sort by ยป oldest newest most voted
0

answered 2017-09-26 19:27:07 -0500

metadaddy gravatar image

Check that MySQL has row-based binary logging enabled - see the prerequisites for the MySQL Binary Log origin.

Incidentally, this error message is a little confusing, but we do have an issue open to improve it: SDC-4699

edit flag offensive delete link more
0

answered 2017-09-26 05:17:22 -0500

casel.chen gravatar image

You should add MySQL JDBC Driver jar with "streamsets-datacollector-mysql-binlog-lib" Library ID in addition to "streamsets-datacollector-jdbc-lib"

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-09-26 01:48:29 -0500

Seen: 94 times

Last updated: Sep 26 '17