Have you followed all steps from Configure PolyBase to access external data in MongoDB ?
SQL Server 2019 and MongoDB
Hi,
I am using:
Microsoft SQL Server 2019 (RTM-CU7) (KB4570012) - 15.0.4063.15 (X64)
Aug 15 2020 10:48:11
Copyright (C) 2019 Microsoft Corporation
Developer Edition (64-bit) on Linux (Ubuntu 20.04.1 LTS) <X64>
and MongoDB:
"version": "4.4.1",
"gitVersion": "ad91a93a5a31e175f5cbf8c69561e788bbc55ce1",
"openSSLVersion": "OpenSSL 1.1.1f 31 Mar 2020",
"modules": [],
"allocator": "tcmalloc",
"environment": {
"distmod": "ubuntu2004",
"distarch": "x86_64",
"target_arch": "x86_64"
When I try to connect to use PolyBase to create External tables I have some weird error:
105082;Generic ODBC error: [Microsoft][MongoDBODBC] (110) Error from MongoDB Client: No servers yet eligible for rescan (Error Code: 13053) Additional error <2>: ErrorMsg: [Microsoft][MongoDBODBC] (110) Error from MongoDB Client: No servers yet eligible for rescan (Error Code: 13053), SqlState: HY000, NativeError: 110 .
After few executions table is finally created. But then, when I try to query it it shows same error.
No interesting info in logs on both sides, but I find out based on a mongodb logs that SQL Server is using mongoc drivers version 1.13
"driver":{"name":"mongoc","version":"1.13.0"},"os":{"type":"Windows","name":"Windows","version":"6.2 (9200)","architecture":"x86_64"
And this version is not compatible with version 4.4 of mongodb (https://docs.mongodb.com/drivers/c#compatibility).
Am I right and switching to older version of mongo will help? Is there any plans to update drivers used to access mongodb in SQL Server on Linux? Can I somehow point SQL Server to another drivers?
3 answers
Sort by: Most helpful
-
-
CathyJi-MSFT 22,286 Reputation points Microsoft Vendor
2020-09-15T07:55:41.907+00:00 Hi @John Abel ,
Try to check if MongoDB 4.0.4 still have this issue? Refer to this blog Enhanced PolyBase SQL 2019 – MongoDB and external table.
Best regards,
Cathy
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread. -
Schmlughtz 1 Reputation point
2022-02-01T21:20:44.46+00:00 I'm using the latest version of mongodb, and had exactly the same error, it is really frustrating !
Msg 105082, Level 16, State 1, Line 12
105082;Generic ODBC error: NativeOdbcConnection.Open, error in OdbcConnectionCreate: SqlState: HY000, NativeError: 110, 'Error calling: SQLDriverConnect(this->_hdbc, NULL, (SQLWCHAR*)connectionString, SQL_NTS, NULL, 0, &cbConnStrOut, SQL_DRIVER_NOPROMPT), SQL return code: -1 | SQL Error Info: Error <1>: ErrorMsg: [Microsoft][MongoDBODBC] (110) Error from MongoDB Client: No servers yet eligible for rescan (Error Code: 13053) Additional error <2>: ErrorMsg: [Microsoft][MongoDBODBC] (110) Error from MongoDB Client: No servers yet eligible for rescan (Error Code: 13053), SqlState: HY000, NativeError: 110 | ConnectionPooling: 1 | Error calling: pConn->Create(connectionString, databaseName, useConnectionPooling, packetSize, connectionLoginTimeout, environmentSettings, transactionToken, transactionTokenSize, resourceGroupName, driverCapabilities, spid) | state: FFFF, number: 1, active connections: 1', Connection String: Driver={PolyBase ODBC Driver for MongoDB};ssl=1;sslallowinvalidcertificates=1;defaultstringcolumnlength=2147483647;defaultbinarycolumnlength=2147483647;uid=james;server=127.0.0.1;port=27017;database=testmongo;authmechanism=SCRAM-SHA-1.