dbConnect fails with "Undefined symbol: ZSTD_compressCCtx" after upgrading MTA:SA server

[Luminaire1337]

Describe the bug

After upgrading to the newest version of MTA:SA server, I can no longer connect to a MySQL database

Steps to reproduce

1. Download the newest version of MTA:SA server
2. Connect to a MySQL database using dbConnect function
3. Get an error

Version

Server: MTA:SA Server v1.6-release-23183 (Ubuntu 24.04, x64)
Tested on MySQL 9.x and 8.x

Additional context

No response

Relevant log output

[14:36:15] ERROR: Could not load /src/multitheftauto_linux_x64/x64/dbconmy.so - /src/multitheftauto_linux_x64/x64/dbconmy.so: undefined symbol: ZSTD_compressCCtx
[14:36:15] WARNING: mysql/db_server.lua:16: Bad usage @ 'dbConnect' [Could not connect]

Security Policy

• I have read and understood the Security Policy and this issue is not security related.

[MrFuji69]

same error.

[M7mmd97]

same error

[Luminaire1337]

LD_PRELOAD=/usr/lib/x86_64-linux-gnu/libzstd.so.1 ./mta-server64

Preloading the zstd library temporarily resolves this issue. Credits to danny6167 & daisu_ on Discord.

[botder]

The problem should be gone in the newest nightly.