topic Error in accessing Delta Tables in Data Engineering

Error in accessing Delta Tables

Shehan92 — Mon, 14 Mar 2022 03:29:13 GMT

I'm getting attached error in accessing delta lake tables in the data bricks workspace

Summary of error: Could not connect to md1n4trqmokgnhr.csnrqwqko4ho.ap-southeast-1.rds.amazonaws.com:3306 : Connection reset

Attached detailed error

Re: Error in accessing Delta Tables

Hubert-Dudek — Mon, 14 Mar 2022 10:17:41 GMT

It is problem with metastore, probably you just blocked traffic to that.

On that page you can also find urls/ips which should be allowed out/routed through internet gateway: https://docs.databricks.com/administration-guide/cloud-configurations/aws/customer-managed-vpc.html

We discussed it recently also on that post https://community.databricks.com/s/question/0D53f00001lLVGDCA4/not-able-to-run-notebook-even-when-cluster-is-running-and-databasestables-are-not-visible-in-data-tab

Re: Error in accessing Delta Tables

brickster_2018 — Tue, 15 Mar 2022 01:50:02 GMT

Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to md1n4trqmokgnhr.csnrqwqko4ho.ap-southeast-1.rds.amazonaws.com:3306 : Connection reset
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:175)
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:110)
	at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1107)
	at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:502)
	at org.mariadb.jdbc.MariaDbConnection.newConnection(MariaDbConnection.java:155)
	at org.mariadb.jdbc.Driver.connect(Driver.java:86)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:95)
	at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:101)
	at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:341)
	at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:506)
	... 149 more

From the logs, the above is the "CausedBy" part. Connection issue with the metastore seems to be the primary issue and unrelated to Delta. you should be seeing this issue for any table.