• Type: Bug
• Resolution: Done
• Priority: Major
• Fix Version/s: 1.9.1.Final, 2.0.0.Alpha1
• Affects Version/s: 1.9.0.Final
• Component/s: mongodb-connector
• Labels:

  None

[DBZ-5003] Can't use 'local' database through mongos

Exporting...

Debezium Builder made changes - 2022/04/21 4:52 PM

Status

Original: Resolved [ 5 ]

New: Closed [ 6 ]

Collapse comment: Debezium Builder added a comment - 2022/04/21 4:52 PM

Debezium Builder added a comment - 2022/04/21 4:52 PM

Released

Expand comment: Debezium Builder added a comment - 2022/04/21 4:52 PM

Debezium Builder added a comment - 2022/04/21 4:52 PM Released

Debezium Builder made changes - 2022/04/21 3:44 PM

Target Release

New: 1.9.GA [ 12381652 ]

Jiri Pechanec made changes - 2022/04/20 8:06 AM

Resolution		New: Done [ 1 ]
Status	Original: Pull Request Sent [ 10011 ]	New: Resolved [ 5 ]

Jiri Pechanec made changes - 2022/04/20 7:36 AM

Fix Version/s		New: 2.0-next [ 12380203 ]
Fix Version/s		New: 1.9.1.Final [ 12384300 ]

Automated transition triggered when Andrey Pustovetov (Inactive) created pull request #3410 in GitHub - 2022/04/20 5:32 AM

Status

Original: Open [ 1 ]

New: Pull Request Sent [ 10011 ]

Andrey Pustovetov (Inactive) made changes - 2022/04/19 6:16 PM

Description

Original: In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type. h1. Bug report For bug reports, provide this information, please: h2. What Debezium connector do you use and what version? debezium-connector-mongodb version 1.9.0.Final h2. What is the connector configuration? {noformat} {   "name": "test-mongodb-connector",   "config": {     "connector.class": "io.debezium.connector.mongodb.MongoDbConnector",     "mongodb.hosts": "mongos.mongo-cluster:27017",     "mongodb.name": "test_mongodb",     "collection.include.list": "public.test_collection",     "capture.mode": "oplog"   } } {noformat} h2. What is the captured database version and mode of deployment? MongoDB v4.2.18, Kubernetes h2. What behaviour do you expect? The connector is successfully created when I specify the data to connect to the shared MongoDB cluster. h2. What behaviour do you see? The connector creation fails with the error: {noformat} {   "error_code": 400,   "message": "Connector configuration is invalid and contains the following 1 error(s):\nUnable to connect: Command failed with error 20 (IllegalOperation): 'Can't use 'local' database through mongos' on server mongos.mongo-cluster:27017. The full response is {\"ok\": 0.0, \"errmsg\": \"Can't use 'local' database through mongos\", \"code\": 20, \"codeName\": \"IllegalOperation\", \"operationTime\": {\"$timestamp\": {\"t\": 1650033077, \"i\": 2}}, \"$clusterTime\": {\"clusterTime\": {\"$timestamp\": {\"t\": 1650033077, \"i\": 2}}, \"signature\": {\"hash\": {\"$binary\": {\"base64\": \"YCO98zagOHfEzh2/tdz9tdYLnIw=\", \"subType\": \"00\"}}, \"keyId\": 7079052315168079876}}}\nYou can also find the above list of errors at the endpoint `/connector-plugins/{connectorType}/config/validate`" } {noformat} h2. Do you see the same behaviour using the latest released Debezium version? Yes h2. Implementation ideas (optional) I suggest to use "config" database if the database exists, otherwise, use "local" database to get MongoDB version during connector validation.

New: h1. Bug report For bug reports, provide this information, please: h2. What Debezium connector do you use and what version? debezium-connector-mongodb version 1.9.0.Final h2. What is the connector configuration? {noformat} {   "name": "test-mongodb-connector",   "config": {     "connector.class": "io.debezium.connector.mongodb.MongoDbConnector",     "mongodb.hosts": "mongos.mongo-cluster:27017",     "mongodb.name": "test_mongodb",     "collection.include.list": "public.test_collection",     "capture.mode": "oplog"   } } {noformat} h2. What is the captured database version and mode of deployment? MongoDB v4.2.18, Kubernetes h2. What behaviour do you expect? The connector is successfully created when I specify the data to connect to the shared MongoDB cluster. h2. What behaviour do you see? The connector creation fails with the error: {noformat} {   "error_code": 400,   "message": "Connector configuration is invalid and contains the following 1 error(s):\nUnable to connect: Command failed with error 20 (IllegalOperation): 'Can't use 'local' database through mongos' on server mongos.mongo-cluster:27017. The full response is {\"ok\": 0.0, \"errmsg\": \"Can't use 'local' database through mongos\", \"code\": 20, \"codeName\": \"IllegalOperation\", \"operationTime\": {\"$timestamp\": {\"t\": 1650033077, \"i\": 2}}, \"$clusterTime\": {\"clusterTime\": {\"$timestamp\": {\"t\": 1650033077, \"i\": 2}}, \"signature\": {\"hash\": {\"$binary\": {\"base64\": \"YCO98zagOHfEzh2/tdz9tdYLnIw=\", \"subType\": \"00\"}}, \"keyId\": 7079052315168079876}}}\nYou can also find the above list of errors at the endpoint `/connector-plugins/{connectorType}/config/validate`" } {noformat} h2. Do you see the same behaviour using the latest released Debezium version? Yes h2. Implementation ideas (optional) I suggest using "config" database if the database exists, otherwise, use "local" database to get MongoDB version during connector validation.

Andrey Pustovetov (Inactive) made changes - 2022/04/19 6:15 PM

Git Pull Request		New: https://github.com/debezium/debezium/pull/3410
Description	Original: In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type. h1. Bug report For bug reports, provide this information, please: h2. What Debezium connector do you use and what version? debezium-connector-mongodb version 1.9.0.Final h2. What is the connector configuration? {noformat} {   "name": "test-mongodb-connector",   "config": {     "connector.class": "io.debezium.connector.mongodb.MongoDbConnector",     "mongodb.hosts": "mongos.mongo-cluster:27017",     "mongodb.name": "test_mongodb",     "collection.include.list": "public.test_collection",     "capture.mode": "oplog"   } } {noformat} h2. What is the captured database version and mode of deployment? MongoDB v4.2.18, Kubernetes h2. What behaviour do you expect? The connector is successfully created when I specify the data to connect to the shared MongoDB cluster. h2. What behaviour do you see? The connector creation fails with the error: {noformat} {   "error_code": 400,   "message": "Connector configuration is invalid and contains the following 1 error(s):\nUnable to connect: Command failed with error 20 (IllegalOperation): 'Can't use 'local' database through mongos' on server mongos.mongo-cluster:27017. The full response is {\"ok\": 0.0, \"errmsg\": \"Can't use 'local' database through mongos\", \"code\": 20, \"codeName\": \"IllegalOperation\", \"operationTime\": {\"$timestamp\": {\"t\": 1650033077, \"i\": 2}}, \"$clusterTime\": {\"clusterTime\": {\"$timestamp\": {\"t\": 1650033077, \"i\": 2}}, \"signature\": {\"hash\": {\"$binary\": {\"base64\": \"YCO98zagOHfEzh2/tdz9tdYLnIw=\", \"subType\": \"00\"}}, \"keyId\": 7079052315168079876}}}\nYou can also find the above list of errors at the endpoint `/connector-plugins/{connectorType}/config/validate`" } {noformat} h2. Do you see the same behaviour using the latest released Debezium version? Yes h2. Do you have the connector logs, ideally from start till finish? (You might be asked later to provide [DEBUG/TRACE|https://debezium.io/documentation/reference/stable/operations/logging.html] level log) <Your answer> h2. How to reproduce the issue using our [tutorial|https://github.com/debezium/debezium-examples/tree/main/tutorial] deployment? <Your answer> h1. Feature request or enhancement For feature requests or enhancements, provide this information, please: h2. Which use case/requirement will be addressed by the proposed feature? <Your answer> h2. Implementation ideas (optional) <Your answer>	New: In order to make your issue reports as actionable as possible, please provide the following information, depending on the issue type. h1. Bug report For bug reports, provide this information, please: h2. What Debezium connector do you use and what version? debezium-connector-mongodb version 1.9.0.Final h2. What is the connector configuration? {noformat} {   "name": "test-mongodb-connector",   "config": {     "connector.class": "io.debezium.connector.mongodb.MongoDbConnector",     "mongodb.hosts": "mongos.mongo-cluster:27017",     "mongodb.name": "test_mongodb",     "collection.include.list": "public.test_collection",     "capture.mode": "oplog"   } } {noformat} h2. What is the captured database version and mode of deployment? MongoDB v4.2.18, Kubernetes h2. What behaviour do you expect? The connector is successfully created when I specify the data to connect to the shared MongoDB cluster. h2. What behaviour do you see? The connector creation fails with the error: {noformat} {   "error_code": 400,   "message": "Connector configuration is invalid and contains the following 1 error(s):\nUnable to connect: Command failed with error 20 (IllegalOperation): 'Can't use 'local' database through mongos' on server mongos.mongo-cluster:27017. The full response is {\"ok\": 0.0, \"errmsg\": \"Can't use 'local' database through mongos\", \"code\": 20, \"codeName\": \"IllegalOperation\", \"operationTime\": {\"$timestamp\": {\"t\": 1650033077, \"i\": 2}}, \"$clusterTime\": {\"clusterTime\": {\"$timestamp\": {\"t\": 1650033077, \"i\": 2}}, \"signature\": {\"hash\": {\"$binary\": {\"base64\": \"YCO98zagOHfEzh2/tdz9tdYLnIw=\", \"subType\": \"00\"}}, \"keyId\": 7079052315168079876}}}\nYou can also find the above list of errors at the endpoint `/connector-plugins/{connectorType}/config/validate`" } {noformat} h2. Do you see the same behaviour using the latest released Debezium version? Yes h2. Implementation ideas (optional) I suggest to use "config" database if the database exists, otherwise, use "local" database to get MongoDB version during connector validation.

Andrey Pustovetov (Inactive) created issue - 2022/04/19 5:38 PM