Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Could not find first log file name in binary log index file #27

Open
xiaobailong opened this issue May 27, 2020 · 1 comment
Open

Could not find first log file name in binary log index file #27

xiaobailong opened this issue May 27, 2020 · 1 comment

Comments

@xiaobailong
Copy link

Exception in thread "connect mysql(test, 3306) " java.lang.RuntimeException: com.github.shyiko.mysql.binlog.network.ServerException: Could not find first log file name in binary log index file
at org.apache.spark.sql.mlsql.sources.MLSQLBinLogDataSource$$anonfun$org$apache$spark$sql$mlsql$sources$MLSQLBinLogDataSource$$launchBinlogServer$1$1$$anonfun$apply$1.apply(MLSQLBinLogDataSource.scala:155)
at org.apache.spark.sql.mlsql.sources.MLSQLBinLogDataSource$$anonfun$org$apache$spark$sql$mlsql$sources$MLSQLBinLogDataSource$$launchBinlogServer$1$1$$anonfun$apply$1.apply(MLSQLBinLogDataSource.scala:152)
at org.apache.spark.sql.mlsql.sources.mysql.binlog.BinLogSocketServerInExecutor$$anon$3.onCommunicationFailure(BinLogSocketServerInExecutor.scala:191)
at com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:939)
at com.github.shyiko.mysql.binlog.BinaryLogClient.connect(BinaryLogClient.java:579)
at org.apache.spark.sql.mlsql.sources.mysql.binlog.BinLogSocketServerInExecutor.org$apache$spark$sql$mlsql$sources$mysql$binlog$BinLogSocketServerInExecutor$$_connectMySQL(BinLogSocketServerInExecutor.scala:261)
at org.apache.spark.sql.mlsql.sources.mysql.binlog.BinLogSocketServerInExecutor$$anon$1.run(BinLogSocketServerInExecutor.scala:289)
Caused by: com.github.shyiko.mysql.binlog.network.ServerException: Could not find first log file name in binary log index file
at com.github.shyiko.mysql.binlog.BinaryLogClient.listenForEventPackets(BinaryLogClient.java:903)
... 3 more

@allwefantasy
Copy link
Owner

Can you check the following parameters :

bingLogNamePrefix="xxxx"
binlogIndex="xxx"
binlogFileOffset="xxxx"

with show master status; ?

And you can try to remove the checkpoint directory and try again.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants