Timeout exception while loading Sensor information

[aniruddharana84]

What's the issue?

Operation name: SingleSensorQuery

Message: (psycopg2.errors.QueryCanceled) canceling statement due to statement timeout

[SQL: SELECT job_ticks.id, job_ticks.tick_body
FROM job_ticks
WHERE job_ticks.selector_id = %(selector_id_1)s OR job_ticks.selector_id IS NULL AND job_ticks.job_origin_id = %(job_origin_id_1)s ORDER BY job_ticks.timestamp DESC
LIMIT %(param_1)s]
[parameters: {'selector_id_1': 'd509a485fa21b1176f4b977f8ac0c003fe7898f4', 'job_origin_id_1': '239789070ef309f6749098d4834c8d92a8c022f1', 'param_1': 1}]
(Background on this error at: https://sqlalche.me/e/20/e3q8)

Path: ["sensorOrError","sensorState","ticks"]

Locations: [{"line":23,"column":9}]

Stack Trace:
File "/usr/local/lib/python3.10/site-packages/graphql/execution/execute.py", line 521, in execute_field
result = resolve_fn(source, info, **args)
File "/usr/local/lib/python3.10/site-packages/dagster_graphql/schema/instigation.py", line 689, in resolve_ticks
return get_instigation_ticks(
File "/usr/local/lib/python3.10/site-packages/dagster_graphql/implementation/fetch_ticks.py", line 67, in get_instigation_ticks
ticks = graphene_info.context.instance.get_ticks(
File "/usr/local/lib/python3.10/site-packages/dagster/_utils/init.py", line 671, in inner
return func(*args, **kwargs)
File "/usr/local/lib/python3.10/site-packages/dagster/_core/instance/init.py", line 2903, in get_ticks
return self._schedule_storage.get_ticks( # type: ignore # (possible none)
File "/usr/local/lib/python3.10/site-packages/dagster/_core/storage/schedules/sql_schedule_storage.py", line 398, in get_ticks
rows = self.execute(query)
File "/usr/local/lib/python3.10/site-packages/dagster/_core/storage/schedules/sql_schedule_storage.py", line 70, in execute
result_proxy = conn.execute(query)
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1421, in execute
return meth(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/sql/elements.py", line 514, in _execute_on_connection
return connection._execute_clauseelement(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1643, in _execute_clauseelement
ret = self._execute_context(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1849, in _execute_context
return self._exec_single_context(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1989, in _exec_single_context
self._handle_dbapi_exception(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 2356, in _handle_dbapi_exception
raise sqlalchemy_exception.with_traceback(exc_info[2]) from e
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1970, in _exec_single_context
self.dialect.do_execute(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 924, in do_execute
cursor.execute(statement, parameters)

The above exception was the direct cause of the following exception:

Message: psycopg2.errors.QueryCanceled: canceling statement due to statement timeout

Stack Trace:
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1970, in _exec_single_context
self.dialect.do_execute(
File "/usr/local/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 924, in do_execute
cursor.execute(statement, parameters)

What did you expect to happen?

No response

How to reproduce?

No response

Dagster version

1.6.10

Deployment type

None

Deployment details

No response

Additional information

No response

Message from the maintainers

Impacted by this issue? Give it a 👍! We factor engagement into prioritization.
By submitting this issue, you agree to follow Dagster's Code of Conduct.