javax.management.InstanceAlreadyExistsException: kafka.producer:type=app-info,id=owler-mysql-dbhisto

[Mano Haran]

Hi, 

I'm using debezium-mysql-connector version:0.5.2

I'm getting the below error, 

javax.management.InstanceAlreadyExistsException: kafka.producer:type=app-info,id=owler-mysql-dbhistory

    at io.debezium.connector.mysql.MySqlSchema.start(MySqlSchema.java:142)

    at io.debezium.connector.mysql.MySqlTaskContext.start(MySqlTaskContext.java:196)

    at io.debezium.connector.mysql.MySqlConnectorTask.start(MySqlConnectorTask.java:67)

I have found an closed issue on the same issue. But I get the same issue even in 0.5.2 release

https://issues.jboss.org/browse/DBZ-124

thanks

[Gunnar Morling]

Hi Mano,

Can you share your connector config? Are you perhaps starting two connector instances on one Connect broker which share the same value for "database.history.name"? If so, using distinct values will help.

Not strictly related, but I'd also recommend to upgrade to the latest version (0.6.1), it contains many bug fixes :)

Cheers,

--Gunnar

--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+unsubscribe@googlegroups.com.
To post to this group, send email to debe...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/9ee41a6b-e0c0-4ba8-91c4-aee11df421cf%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Mano Haran]

Hi,

Please find the config below. 

 {    

   "connector.class": "io.debezium.connector.mysql.MySqlConnector",    

   "database.hostname": "10.0.0.1",    

   "database.port": "3306",    

   "database.user": "debezium",   

   "database.password": "****",    

   "database.server.name": "owler",    

   "database.whitelist": "owler",

   "table.whitelist": "member_stat",

   "include.schema.changes": "false",

   "database.history.kafka.topic": "mysql_schema",

   "database.history.kafka.bootstrap.servers": "localhost:9092"

 }

On Friday, November 3, 2017 at 1:40:16 PM UTC+5:30, Gunnar Morling wrote:

Hi Mano,

Can you share your connector config? Are you perhaps starting two connector instances on one Connect broker which share the same value for "database.history.name"? If so, using distinct values will help.

Not strictly related, but I'd also recommend to upgrade to the latest version (0.6.1), it contains many bug fixes :)

Cheers,

--Gunnar

2017-11-03 8:19 GMT+01:00 Mano Haran <pebyon...@gmail.com>:

Hi, 

I'm using debezium-mysql-connector version:0.5.2

I'm getting the below error, 

javax.management.InstanceAlreadyExistsException: kafka.producer:type=app-info,id=owler-mysql-dbhistory

    at io.debezium.connector.mysql.MySqlSchema.start(MySqlSchema.java:142)

    at io.debezium.connector.mysql.MySqlTaskContext.start(MySqlTaskContext.java:196)

    at io.debezium.connector.mysql.MySqlConnectorTask.start(MySqlConnectorTask.java:67)

I have found an closed issue on the same issue. But I get the same issue even in 0.5.2 release

https://issues.jboss.org/browse/DBZ-124

thanks

--
You received this message because you are subscribed to the Google Groups "debezium" group.

To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.

[Gunnar Morling]

Hum, the weird thing is that the MBean is using a specific name ("owler-mysql-dbhistory"), which AFAICS only happens if you set the "database.history.name" property explicitly.

Then you'd run into this when starting two connector instances with the same value. Otherwise it'll take a value containing a UUID. Perhaps double-check whether you don't set it somewhere indeed?

To unsubscribe from this group and stop receiving emails from it, send an email to debezium+unsubscribe@googlegroups.com.

To post to this group, send email to debe...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/debezium/a61bfa81-0a84-4616-92bd-8f812c14a27d%40googlegroups.com.