Error in accessing Delta Tables

Shehan92
New Contributor II

‎03-13-2022 08:29 PM

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

Labels:

Hubert-Dudek
Databricks MVP

‎03-14-2022 03:17 AM

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-cl...


My blog: https://databrickster.medium.com/

brickster_2018
Databricks Employee
Databricks Employee

‎03-14-2022 06:50 PM 

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.

View solution in original post