[CI][Flight][C++] Flight build fails on verification job for windows with missing symbol on GRPC/SSL

[raulcd]

Describe the bug, including details regarding any error messages, version, and platform.

The windows verification job has been failing for the last 15 days:

• verify-rc-source-windows

It seems that the issue is with GRPC / SSL:

C:\Program Files (x86)\Microsoft Visual Studio\2019\Enterprise\MSBuild\Microsoft\VC\v160\Microsoft.CppBuild.targets(1091,5): warning MSB8027: Two or more files with the name of serialization_internal.cc will produce outputs to the same location. This can lead to an incorrect build result.  The files involved are D:\a\crossbow\crossbow\arrow\cpp\src\arrow\flight\serialization_internal.cc, D:\a\crossbow\crossbow\arrow\cpp\src\arrow\flight\transport\grpc\serialization_internal.cc. [D:\a\crossbow\crossbow\arrow\cpp\build\src\arrow\flight\arrow_flight_shared.vcxproj]
  unity_2_cxx.cxx
  unity_1_cxx.cxx
  unity_0_cxx.cxx
  Flight.pb.cc
     Creating library D:/a/crossbow/crossbow/arrow/cpp/build/release/Release/arrow_flight.lib and object D:/a/crossbow/crossbow/arrow/cpp/build/release/Release/arrow_flight.exp
grpc.lib(json_token.cc.obj) : error LNK2019: unresolved external symbol EVP_DigestSignUpdate referenced in function "char * __cdecl compute_and_encode_signature(struct grpc_auth_json_key const *,char const *,char const *)" (?compute_and_encode_signature@@YAPEADPEBUgrpc_auth_json_key@@PEBD1@Z) [D:\a\crossbow\crossbow\arrow\cpp\build\src\arrow\flight\arrow_flight_shared.vcxproj]
grpc.lib(ssl_transport_security.cc.obj) : error LNK2019: unresolved external symbol SSL_get1_peer_certificate referenced in function "enum tsi_result __cdecl ssl_handshaker_result_extract_peer(struct tsi_handshaker_result const *,struct tsi_peer *)" (?ssl_handshaker_result_extract_peer@@YA?AW4tsi_result@@PEBUtsi_handshaker_result@@PEAUtsi_peer@@@Z) [D:\a\crossbow\crossbow\arrow\cpp\build\src\arrow\flight\arrow_flight_shared.vcxproj]
D:\a\crossbow\crossbow\arrow\cpp\build\release\Release\arrow_flight.dll : fatal error LNK1120: 2 unresolved externals [D:\a\crossbow\crossbow\arrow\cpp\build\src\arrow\flight\arrow_flight_shared.vcxproj]

This should be fixed for 12.0.0.

Component(s)

C++, Continuous Integration, FlightRPC

[raulcd]

@lidavidm any idea on this one?

[lidavidm]

Hmm, no clue. OpenSSL and gRPC versions look the same between the last success/first failure.

[lidavidm]

The only dependency changes between the first failure/last success were hypothesis, cython, and cmake (minor version bump) which seem like they should be ok.

[lidavidm]

Nothing in the diff seems relevant either.

[lidavidm]

Failure:

-- Found OpenSSL: optimized;C:/Program Files/OpenSSL/lib/VC/libcrypto64MD.lib;debug;C:/Program Files/OpenSSL/lib/VC/libcrypto64MDd.lib (found suitable version "1.1.1t", minimum required is "1.0.2")  

Success:

-- Found OpenSSL: C:/tmp/arrow-verify-release/conda-env/Library/lib/libcrypto.lib (found suitable version "3.1.0", minimum required is "1.0.2")  

It looks like we're somehow linking against system OpenSSL by accident

[lidavidm]

trying something in #35225