Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-15089

Ensure that connection ID is in 32bit range

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.2.13
    • Component/s: Server
    • Labels:
      None
    • Sprint:
      10.2.13

      Description

      Connectors assume that connection ID(often referred to as thread_id in the source) is 32bit , because this is what server sends them in the first packet. However, server handles connection IDs as 64bit integers, which means we overflow can happen, and connection ID sent to client is no longer valid,

      MySQL happens to have fixed this bug in 5.7 with https://dev.mysql.com/worklog/task/?id=7293.

      I believe we can think of a better scalable allocation algorithm not involving any kinds of hashes.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                wlad Vladislav Vaintroub
                Reporter:
                wlad Vladislav Vaintroub
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: