[Ubuntu] Issue with libstdc++ cannot allocate memory in static TLS block

[miketimofeev]

Breaking changes

Due to a bug in MySql 8.0.27 (https://bugs.mysql.com/bug.php?id=105288) we had to revert the version to 8.0.26 yet it's not possible to use ubuntu upstream repo as it doesn't contain older versions. In this PR we switched the installation to install all the dependencies step by step utilizing the dpkg -i command #4674

This leads to unpredictable behavior in libstdc++ usage when calling from Python (there could be other cases we are not aware of) — #4733, #4790
Please use the provided workaround until we either got 8.0.26 in the upstream repo or the new version 8.0.28 is released.

Possible impact

If your Python code uses some C++ libraries it can be broken.

Virtual environments affected

• Ubuntu 18.04
• Ubuntu 20.04
• macOS 10.15
• macOS 11
• Windows Server 2016
• Windows Server 2019
• Windows Server 2022

Mitigation ways

Reinstall MySQL version 8.0.27 using upstream repo:

sudo apt-get update
sudo apt-get remove mysql* && sudo apt-get install -y mysql-server

[RW21]

To add to the mitigation method provided, if you are using Python's mysql-client, you will need to install libmysqlclient-dev, otherwise you will get OSError: mysql_config not found.
So:

    - name: GA fixes
      run: |
        sudo apt-get update
        sudo apt-get remove mysql* && sudo apt-get install -y mysql-server libmysqlclient-dev

[marcelgerber]

I think this issue can be fixed by now, right?
The underlying bug is fixed in 8.0.28, and 8.0.28 is available from apt in 20.04 LTS. So simply reverting #4674 should do the trick.

[miketimofeev]

thanks @marcelgerber for the update!
We will test the behavior to make sure it's is really fixed and then rollback the workaround 🙂

[miketimofeev]

@marcelgerber we have reverted mysql client installation to the upstream repo, this shouldn't be the issue anymore.