Python 3.11.5 incompatible https://github.com/mysql/mysql-server make libabsl_log_globals.so: undefined symbol:

[wblangdon]

Bug report

Bug description:

This is probably more of a cmake failure than a Python problem but I think it is good to document it in case other people hit it too.

Installing mysql from source (current version from github.com/mysql/mysql-server) under Linux Rocky 9.5 with Python 3.11.5 in PATH make VERBOSE=1 fails about 6% in with

cd abc/mysql/mysql-server-trunk/build/plugin/x/protocol/protobuf && ../../../../runtime_output_directory/protoc --cpp_out abc/mysql/mysql-server-trunk/build/plugin/x/generated/protobuf_lite -I abc/mysql/mysql-server-trunk/extra/protobuf/protobuf-24.4/src -Iabc/mysql/mysql-server-trunk/build/plugin/x/generated/protobuf_lite abc/mysql/mysql-server-trunk/build/plugin/x/generated/protobuf_lite/mysqlx.proto
../../../../runtime_output_directory/protoc: symbol lookup error: abc/mysql/mysql-server-trunk/build/library_output_directory/libabsl_log_globals.so: undefined symbol: _ZN4absl12lts_2023080216raw_log_internal21internal_log_functionB5cxx11E

Workaround: remove /opt/Python/Python-3.11.5 from PATH and LD_LIBRARY_PATH

Versions with problem here:
Python 3.11.5
Linux Rocky 9.5
cmake version 3.26.5
GNU Make 4.3
gcc (GCC) 11.5.0 20240719 (Red Hat 11.5.0-5)

The undefined symbol error message seems to be totally unhelpful since the problems seems to be bad LD_LIBRARY_PATH

echo $LD_LIBRARY_PATH
/opt/Python/Python-3.11.5/lib:/opt/ucl/lib:/usr/X11R6/lib

CPython versions tested on:

CPython main branch

Operating systems tested on:

Linux

[picnixz]

I don't think it's a CPython issue and this is likely a mysql build issue instead. I don't think Python is installing itself in /opt, so it could also be a Rocky issue. I'm closing it as not a CPython issue.

[wblangdon]

Ok. Thanks.
Yip we have our default (3.9.21) in /usr/bin/python
Only the newest version (3.11.5) is in /opt

Thanks again
Bill

[picnixz]

You're welcome! It's still kind of you to indicate workarounds for possible issues although they are not CPython issue per se.