Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Orchestrator uses inefficient subquery in REPLACE to update cluster aliases

Description

Orchestrator sends a lot of concurrent REPLACE/SELECT queries that create a lot of semaphore waits in MySQL starting from version 8.0.29. This is result of but also the issue with the Orchestrator, because it may perform same task better.

How To Repeat

See first comment in

Expected Fix

Do not send identical REPLACE queries, implement smarter logic to check servers.

Environment

None

AFFECTED CS IDs

CS0030162

Activity

Show:

Satya Bodapati June 6, 2023 at 8:08 AM

Satya Bodapati January 10, 2023 at 10:39 AM

Done

Details

Assignee

Reporter

Labels

Needs QA

Yes

Components

Fix versions

Affects versions

Priority

Smart Checklist

Created December 13, 2022 at 5:07 PM
Updated October 31, 2024 at 9:45 AM
Resolved January 10, 2023 at 10:39 AM