Page MenuHomePhabricator

Investigate Trino/ HMS <> dbt read timeout errors
Closed, ResolvedPublic

Description

Occasionally our dbt runs fail with errors like:

Database Error in model int_banner_donations (models/marts/core/intermediate/int_banner_donations.sql)
 TrinoExternalError(type=EXTERNAL, name=HIVE_METASTORE_ERROR, message="localhost:9083: java.net.SocketTimeoutException: Read timed out", query_id=20250527_141458_20824_kzbau)
 compiled code at /var/lib/dagster/dbt_target/my_dbt_assets-b298f56-edfa2b1/run/analytics_dbt/models/marts/core/intermediate/int_banner_donations.sql

See this run as an example

Event Timeline

Hi @AStein-WMF, please associate one or more active project tags with this task (via the Add Action... → Change Project Tags dropdown). That will allow to see a task when looking at project workboards or searching for tasks in certain projects, and get notified about a task when watching a related project tag. Thanks.

increasing the read timeout params for the iceberg and hive catalogs appear to have fixed this. closing