hasura / hasura/graphql-engine
Not able to delete one off scheduled events via SQL
- 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
Assessment
This issue has not been assessed yet.