Ask Your Question
0

MySql BinLog Error: A slave with the same server_uuid/server_id

asked 2020-05-26 01:46:02 -0500

gavin gravatar image

StreamSet-Version: StreamSets Data Collector 3.13.0 ( built by ubuntu on 2020-01-09T06:28Z git: e80c478a42ef4886d3a39e20c16b04ea15d1f138)

Stage Library:MySql BinLog

MySQL-Version:5.7

Error :Pipeline Status: RUNNING_ERROR: MYSQL_006 - MySql server error: A slave with the same server_uuid/server_id as this slave has connected to the master; the first event '' at 4, the last event read from './mysql-bin.000058' at 348730885, the last byte read from './mysql-bin.000058' at 348730885. ( View Details... )

BinLog Configuration: image description

i have try to change Server ID and Restart Pipeline,but even revice this error some time image description

edit retag flag offensive close merge delete

Comments

Have you tried updating the server id?

iamontheinet gravatar imageiamontheinet ( 2020-05-26 13:18:57 -0500 )edit

yes, i have try to change Server ID and Restart Pipeline,but even receive this error some time, the pipeline status is strart running - > running -> after 5min -> Error -> Retry -> Error -> Retry......the problem happened by accident

gavin gravatar imagegavin ( 2020-05-28 19:35:23 -0500 )edit

thanks for your reply, i will check it

gavin gravatar imagegavin ( 2020-06-01 21:55:49 -0500 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2020-05-30 21:01:53 -0500

iamontheinet gravatar image

updated 2020-06-09 10:27:12 -0500

Hi!

Do you have more than one replication slaves? Also, are you able to confirm that the server ID you're providing in the pipeline is unique from the server ID of the replication master and of all the other replication slaves?

Cheers, Dash

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-05-26 01:46:02 -0500

Seen: 44 times

Last updated: Jun 09