hasura / hasura/graphql-engine

Not able to delete one off scheduled events via SQL

Open
#8,969 1 comment 0 reactions 0 assignees View on GitHub
a/eventing/data-triggers k/bug
Dominant language
TypeScript
Stars
32.1k
Forks
3k
PR merge metrics
PR metrics pending

Description

### Version Information

Server Version: 2.11.2-cloud.1

### Environment

Cloud/OSS

### What is the current behavior?

Im trying to delete one-off events from hdb_catalog.hdb_scheduled_events
I was able to invoke run_sql and clear the same in local deployment (by using docker-compose)
but in hasura cloud the hdb_catalog.hdb_scheduled_events is an empty table (when i accessed it directly using data grip)
but the one-off scheduled event list is not empty
when i run the delete sql in cloud deployment it is not getting cleared
https://hasura.io/docs/latest/scheduled-triggers/clean-up/#option-2-clear-processed-events

### What is the expected behavior?

- When we query the hdb_catalog.hdb_scheduled_events it should have all the one-off scheduled events
- We can run sql queries to delete one or more events

### How to reproduce the issue?

1. Hasura should be deployed with Hasura cloud
2. Connect to Postgres directly or use SQL tab under the data section
3. Run: delete from hdb_catalog.hdb_scheduled_events;
4. Check the one off scheduled tab the events will stay there

### Keywords

one off scheduled events

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.