Bug #113190 Several tests in routertest_integration_routing_sharing_constrained_pools fail
Submitted: 22 Nov 2023 20:45 Modified: 16 Oct 12:44
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Verified Impact on me:
None 
Category:Tests Severity:S3 (Non-critical)
Version:8.0.40, 8.4.0 OS:Any
Assigned to: CPU Architecture:Any

[22 Nov 2023 20:45] Laurynas Biveinis 
Description:
MySQL built under macOS, Homebrew LLVM 14:
$ runtime_output_directory/routertest_integration_routing_sharing_constrained_pools
...
[ RUN      ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_DISABLED__DISABLED
/Users/laurynas/vilniusdb/mysql-8.0.35/router/tests/helpers/shared_server.cc:418: Failure
Expected: (cli_res) succeeds.
  Actual: HY000 (1040) Too many connections

Google Test trace:
/Users/laurynas/vilniusdb/mysql-8.0.35/router/tests/helpers/shared_server.cc:415: // closing all connections at the server.
/Users/laurynas/vilniusdb/mysql-8.0.35/router/tests/integration/test_routing_sharing_constrained_pools.cc:3476: // cleanup
/Users/laurynas/vilniusdb/mysql-8.0.35/router/tests/integration/test_routing_sharing_constrained_pools.cc:3406: // testing
/Users/laurynas/vilniusdb/mysql-8.0.35/router/tests/integration/test_routing_sharing_constrained_pools.cc:3342: // set max-connections = 1, globally
/Users/laurynas/vilniusdb/mysql-8.0.35/router/tests/integration/test_routing_sharing_constrained_pools.cc:3483: Failure
Expected: (shared_router()->wait_for_idle_server_connections(0, 1s)) succeeds.
  Actual: generic:60

Google Test trace:
/Users/laurynas/vilniusdb/mysql-8.0.35/router/tests/integration/test_routing_sharing_constrained_pools.cc:3476: // cleanup
/Users/laurynas/vilniusdb/mysql-8.0.35/router/tests/integration/test_routing_sharing_constrained_pools.cc:3406: // testing
/Users/laurynas/vilniusdb/mysql-8.0.35/router/tests/integration/test_routing_sharing_constrained_pools.cc:3342: // set max-connections = 1, globally
/Users/laurynas/vilniusdb/mysql-8.0.35/router/tests/helpers/process_manager.cc:669: Failure
Failed
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_DISABLED__DISABLED, where GetParam() = 56-byte object <44-49 53-41 42-4C 45-44 5F-5F 44-49 53-41 42-4C 45-44 00-00 00-00 00-12 87-1A 3A-00 01-00 00-00 08-00 00-00 00-00 00-00 87-1A 3A-00 01-00 00-00 08-00 00-00 00-00 00-00> (1088 ms)

Other tests failing with the same expected/actual difference:
[  FAILED  ] 11 tests, listed below:
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_DISABLED__DISABLED, where GetParam() = 56-byte object <44-49 53-41 42-4C 45-44 5F-5F 44-49 53-41 42-4C 45-44 00-00 00-00 00-12 87-1A 3A-00 01-00 00-00 08-00 00-00 00-00 00-00 87-1A 3A-00 01-00 00-00 08-00 00-00 00-00 00-00>
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_DISABLED__AS_CLIENT, where GetParam() = 56-byte object <44-49 53-41 42-4C 45-44 5F-5F 41-53 5F-43 4C-49 45-4E 54-00 00-00 00-13 87-1A 3A-00 01-00 00-00 08-00 00-00 00-00 00-00 90-1A 3A-00 01-00 00-00 09-00 00-00 00-00 00-00>
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_DISABLED__REQUIRED, where GetParam() = 56-byte object <44-49 53-41 42-4C 45-44 5F-5F 52-45 51-55 49-52 45-44 00-00 00-00 00-12 87-1A 3A-00 01-00 00-00 08-00 00-00 00-00 00-00 9A-1A 3A-00 01-00 00-00 08-00 00-00 00-00 00-00>
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_DISABLED__PREFERRED, where GetParam() = 56-byte object <44-49 53-41 42-4C 45-44 5F-5F 50-52 45-46 45-52 52-45 44-00 00-00 00-13 87-1A 3A-00 01-00 00-00 08-00 00-00 00-00 00-00 A3-1A 3A-00 01-00 00-00 09-00 00-00 00-00 00-00>
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_PREFERRED__DISABLED, where GetParam() = 56-byte object <50-52 45-46 45-52 52-45 44-5F 5F-44 49-53 41-42 4C-45 44-00 00-00 00-13 A3-1A 3A-00 01-00 00-00 09-00 00-00 00-00 00-00 87-1A 3A-00 01-00 00-00 08-00 00-00 00-00 00-00>
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_PREFERRED__PREFERRED, where GetParam() = 56-byte object <50-52 45-46 45-52 52-45 44-5F 5F-50 52-45 46-45 52-52 45-44 00-00 00-14 A3-1A 3A-00 01-00 00-00 09-00 00-00 00-00 00-00 A3-1A 3A-00 01-00 00-00 09-00 00-00 00-00 00-00>
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_PREFERRED__REQUIRED, where GetParam() = 56-byte object <50-52 45-46 45-52 52-45 44-5F 5F-52 45-51 55-49 52-45 44-00 00-00 00-13 A3-1A 3A-00 01-00 00-00 09-00 00-00 00-00 00-00 9A-1A 3A-00 01-00 00-00 08-00 00-00 00-00 00-00>
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_REQUIRED__DISABLED, where GetParam() = 56-byte object <52-45 51-55 49-52 45-44 5F-5F 44-49 53-41 42-4C 45-44 00-00 00-00 00-12 9A-1A 3A-00 01-00 00-00 08-00 00-00 00-00 00-00 87-1A 3A-00 01-00 00-00 08-00 00-00 00-00 00-00>
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_REQUIRED__AS_CLIENT, where GetParam() = 56-byte object <52-45 51-55 49-52 45-44 5F-5F 41-53 5F-43 4C-49 45-4E 54-00 00-00 00-13 9A-1A 3A-00 01-00 00-00 08-00 00-00 00-00 00-00 90-1A 3A-00 01-00 00-00 09-00 00-00 00-00 00-00>
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_REQUIRED__PREFERRED, where GetParam() = 56-byte object <52-45 51-55 49-52 45-44 5F-5F 50-52 45-46 45-52 52-45 44-00 00-00 00-13 9A-1A 3A-00 01-00 00-00 08-00 00-00 00-00 00-00 A3-1A 3A-00 01-00 00-00 09-00 00-00 00-00 00-00>
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_REQUIRED__REQUIRED, where GetParam() = 56-byte object <52-45 51-55 49-52 45-44 5F-5F 52-45 51-55 49-52 45-44 00-00 00-00 00-12 9A-1A 3A-00 01-00 00-00 08-00 00-00 00-00 00-00 9A-1A 3A-00 01-00 00-00 08-00 00-00 00-00 00-00>

11 FAILED TESTS
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest: SetUpTestSuite or TearDownTestSuite

How to repeat:
See above
[23 Nov 2023 4:48] MySQL Verification Team 
Hello Laurynas,

Thank you for the report and feedback!

regards,
Umesh
[18 Jan 15:32] Laurynas Biveinis 
On 8.0.36:

[  FAILED  ] 8 tests, listed below:
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_DISABLED__DISABLED, where GetParam() = 56-byte object <44-49 53-41 42-4C 45-44 5F-5F 44-49 53-41 42-4C 45-44 00-00 00-00 00-12 77-C3 A8-00 01-00 00-00 08-00 00-00 00-00 00-00 77-C3 A8-00 01-00 00-00 08-00 00-00 00-00 00-00>
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_DISABLED__AS_CLIENT, where GetParam() = 56-byte object <44-49 53-41 42-4C 45-44 5F-5F 41-53 5F-43 4C-49 45-4E 54-00 00-00 00-13 77-C3 A8-00 01-00 00-00 08-00 00-00 00-00 00-00 80-C3 A8-00 01-00 00-00 09-00 00-00 00-00 00-00>
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_DISABLED__REQUIRED, where GetParam() = 56-byte object <44-49 53-41 42-4C 45-44 5F-5F 52-45 51-55 49-52 45-44 00-00 00-00 00-12 77-C3 A8-00 01-00 00-00 08-00 00-00 00-00 00-00 8A-C3 A8-00 01-00 00-00 08-00 00-00 00-00 00-00>
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_PREFERRED__DISABLED, where GetParam() = 56-byte object <50-52 45-46 45-52 52-45 44-5F 5F-44 49-53 41-42 4C-45 44-00 00-00 00-13 93-C3 A8-00 01-00 00-00 09-00 00-00 00-00 00-00 77-C3 A8-00 01-00 00-00 08-00 00-00 00-00 00-00>
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_PREFERRED__REQUIRED, where GetParam() = 56-byte object <50-52 45-46 45-52 52-45 44-5F 5F-52 45-51 55-49 52-45 44-00 00-00 00-13 93-C3 A8-00 01-00 00-00 09-00 00-00 00-00 00-00 8A-C3 A8-00 01-00 00-00 08-00 00-00 00-00 00-00>
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_REQUIRED__DISABLED, where GetParam() = 56-byte object <52-45 51-55 49-52 45-44 5F-5F 44-49 53-41 42-4C 45-44 00-00 00-00 00-12 8A-C3 A8-00 01-00 00-00 08-00 00-00 00-00 00-00 77-C3 A8-00 01-00 00-00 08-00 00-00 00-00 00-00>
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_REQUIRED__PREFERRED, where GetParam() = 56-byte object <52-45 51-55 49-52 45-44 5F-5F 50-52 45-46 45-52 52-45 44-00 00-00 00-13 8A-C3 A8-00 01-00 00-00 08-00 00-00 00-00 00-00 93-C3 A8-00 01-00 00-00 09-00 00-00 00-00 00-00>
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.classic_protocol_server_greeting_error/ssl_modes_REQUIRED__REQUIRED, where GetParam() = 56-byte object <52-45 51-55 49-52 45-44 5F-5F 52-45 51-55 49-52 45-44 00-00 00-00 00-12 8A-C3 A8-00 01-00 00-00 08-00 00-00 00-00 00-00 8A-C3 A8-00 01-00 00-00 08-00 00-00 00-00 00-00>

 8 FAILED TESTS
[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest: SetUpTestSuite or TearDownTestSuite
[24 Jan 9:53] Laurynas Biveinis 
Many tests in 8.3.0 routertest_component_routing_strategy fail in a similar way. Posting it here instead of opening a new bug. A random example:

[ RUN      ] Spec/ConnectionConnectTest.classic_protocol_connect/sha256_password_account_with_password_auth_with_empty_password__via_REQUIRED__REQUIRED__default_auth_is_default
/Users/laurynas/vilniusdb/mysql-8.3.0/router/tests/integration/test_routing_direct.cc:4738: Failure
Expected equality of these values:
  connect_res.error().value()
    Which is: 2003
  expected_error_code
    Which is: 1045
/Users/laurynas/vilniusdb/mysql-8.3.0/router/tests/helpers/process_manager.cc:679: Failure
Failed
[  FAILED  ] Spec/ConnectionConnectTest.classic_protocol_connect/sha256_password_account_with_password_auth_with_empty_password__via_REQUIRED__REQUIRED__default_auth_is_default, where GetParam() = (128-byte object <00-E4 BA-03 00-60 00-00 3E-00 00-00 00-00 00-00 40-00 00-00 00-00 00-80 73-68 61-32 35-36 5F-70 61-73 73-00 00-60 00-00 50-C0 C8-02 00-60 00-0B 00-00 00-00 00-00 00-00 00-00 00-00 00-00 00-00 00-00 00-00 00-00 00-00 73-68 61-32 35-36 5F-70 61-73 73-77 6F-72 64-00 50-C0 C8-02 00-60 00-0F 90-B2 E8-00 01-00 00-00 00-00 00-00 00-00 00-00 00-00 00-00 00-00 00-00 58-01 78-01 00-60 00-00>, 56-byte object <52-45 51-55 49-52 45-44 5F-5F 52-45 51-55 49-52 45-44 00-00 00-00 00-12 30-BB E5-00 01-00 00-00 08-00 00-00 00-00 00-00 30-BB E5-00 01-00 00-00 08-00 00-00 00-00 00-00>, 0x100e5b96a pointing to "default") (0 ms)
[5 May 15:54] Laurynas Biveinis 
Same on 8.0.37
[6 May 9:16] Laurynas Biveinis 
Same on 8.4.0
[2 Jul 4:39] Laurynas Biveinis 
Same on 8.0.38
[16 Oct 12:44] Laurynas Biveinis 
Same on 8.0.40