Sqlalchemy Errors in Dagster

[glenluengen-code]

What's the issue?

Our dagster instance is running connected to a postgresdb and periodically we keep getting sql errors.
An example of the errors I am seeing is below:

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) SSL SYSCALL error: EOF detected

[SQL: INSERT INTO event_logs (run_id, event, dagster_event_type, timestamp, step_key, asset_key, partition) VALUES (%(run_id)s, %(event)s, %(dagster_event_type)s, %(timestamp)s, %(step_key)s, %(asset_key)s, %(partition)s) RETURNING event_logs.run_id, event_logs.id]
[parameters: {'run_id': 'RUNID', 'event': '{"__class__": "EventLogEntry", "dagster_event": {"__class__": "DagsterEvent", "event_specific_data": {"__class__": "RunEnqueuedData", "code_location_ ... (315 characters truncated) ...  "pipeline_name": "PIPELINENAME", "run_id": "RUNID", "step_key": null, "timestamp": 1745959176.4801, "user_message": ""}', 'dagster_event_type': 'PIPELINE_ENQUEUED', 'timestamp': datetime.datetime(2025, 4, 29, 20, 39, 36, 480100), 'step_key': None, 'asset_key': None, 'partition': None}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)

What did you expect to happen?

No response

How to reproduce?

No response

Dagster version

dagster, version 1.9.9

Deployment type

Other

Deployment details

We have deployed dagster to Tanzu Application Service

Additional information

No response

Message from the maintainers

Impacted by this issue? Give it a 👍! We factor engagement into prioritization.