Redshift Serverless WLM rules for max query execution time does not update - bug or am I missing something?

Hi,

WLM for Redshift Serverless does not seem to update its max_query_execution_time rule after a workgroup was created initially with a different rule.

The consequences from it are that new rules cannot be applied and WLM aborts queries that it should not be aborting according to the new rules.

More details follow below after the message. What am I missing or is this a bug? How can this be fixed without migrating to a new workgroup?

Replication:

• set up a workgroup with Query Monitoring Rules maximum query execution time 600s
• update the rule to 2400s
• wait more than 10 mins for the rule to propagate
• run a query that stretches over 600s and get error below

Error messages:

• cancelled by WLM abort action of Query Monitoring Rule "max_query_execution code: 1078
• cancelled by WLM abort action of Query Monitoring Rule "max_query_execution query: 0 location: wlm_query_action.cpp:179 process: wlm

Troubleshooting:

• seeing that the rule update was correctly updated in related WLM system tables and views does not seem to be possible as per https://repost.aws/questions/QUr1ywNL6kQPOglpmRVMCtCA/redshift-superuser-permission-denied-to-stl-tables
• updating the rule again and waiting does not help
• deleting the rule altogether does not help