MySQLDB does not shut down the Heatwave Service

[adrienne-howard]

The MySQL section does not seem to shut down any services. The errors are Error (404) MySQL Shutdown for transperfect-replica - Authorization failed or requested resource not found.', ' - Error (404) MySQL Shutdown for main-db - Authorization failed or requested resource not found.', ' - Error (404) MySQL Shutdown for HeatWaveStreaming - Authorization failed or requested resource not found.'] - I have added some policies but they still do not seem to be working

[AnykeyNL]

Are you running single node or multiple nodes?

Here it is working: Checking HeatWave01 (MysqlDBInstance) CurentState: ACTIVE...

• Active schedule for HeatWave01: 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,[0],0,0,0,
• Initiate MySQL shutdown for HeatWave01

Can you share your output of the script?

[adrienne-howard]

I have 2 that has the lakehouse option enabled - -they are listed above. Then there is one that is running but does not show up in the script. The output is above from the topic. Do you want me to run it on the command line?

[AnykeyNL]

yes, please share output when you run from command line

[adrienne-howard]

So all I see in the log is the same thing that shows up in the topic for HW – let me know if there is anything else I can provide?

A Checking transperfect-replica (MysqlDBInstance) CurentState: ACTIVE...

• Active schedule for transperfect-replica: 0,0,0,0,0,[0],0,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,
• Initiate MySQL shutdown for transperfect-replica
• Error (404) MySQL Shutdown for transperfect-replica - Authorization failed or requested resource not found. Checking main-db (MysqlDBInstance) CurentState: ACTIVE...
• Active schedule for main-db: 0,0,0,0,0,[0],0,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,
• Initiate MySQL shutdown for main-db
• Error (404) MySQL Shutdown for main-db - Authorization failed or requested resource not found.

Checking HeatWaveStreaming (MysqlDBInstance) CurentState: ACTIVE...

• Active schedule for HeatWaveStreaming: 0,0,0,[0],0,0,0,1,1,1,1,1,1,1,1,1,1,1,0,0,0,0,0,0,
• Initiate MySQL shutdown for HeatWaveStreaming
• Error (404) MySQL Shutdown for HeatWaveStreaming - Authorization failed or requested resource not found. Adrienne Howard NAC Analytics Specialist Mobile +404-543-6225tel:+4045436225 Eastern Time Zone Oracle North American Cloud Team

From: Richard Garsthagen @.> Sent: Monday, January 6, 2025 4:24 PM To: AnykeyNL/OCI-AutoScale @.> Cc: Adrienne Howard @.>; Author @.> Subject: [External] : Re: [AnykeyNL/OCI-AutoScale] MySQLDB does not shut down the Heatwave Service (Issue #48)

yes, please share output when you run from command line

— Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https:/github.com/AnykeyNL/OCI-AutoScale/issues/48*issuecomment-2573951847__;Iw!!ACWV5N9M2RV99hQ!L7Uhf0aFJtBvjzxm9rVL23NVuIrvz7pNDpAnQdLqMmPTEknAJIpZDn-XbiyXxie4POLHvzVPnmHxrWBmvNDYWMZ5X-gz$, or unsubscribehttps://urldefense.com/v3/__https:/github.com/notifications/unsubscribe-auth/AHHT634SF34SZQKC2CEW3LT2JLX75AVCNFSM6AAAAABUV5JWWKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDKNZTHE2TCOBUG4__;!!ACWV5N9M2RV99hQ!L7Uhf0aFJtBvjzxm9rVL23NVuIrvz7pNDpAnQdLqMmPTEknAJIpZDn-XbiyXxie4POLHvzVPnmHxrWBmvNDYWIiwwtL7$. You are receiving this because you authored the thread.Message ID: @.@.>>