Bug #119258 router integration tests failing to login
Submitted: 28 Oct 7:36 Modified: 28 Oct 9:32
Reporter: Laurynas Biveinis (OCA) Email Updates:
Status: Open Impact on me:
None 
Category:MySQL Server: Tests Severity:S7 (Test Cases)
Version:9.5.0 OS:MacOS (26.0.1)
Assigned to: CPU Architecture:ARM

[28 Oct 7:36] Laurynas Biveinis 
Description:
./runtime_output_directory/routertest_integration_routing_direct
...
[ RUN      ] Spec/ConnectionTest.classic_protocol_change_user_caching_sha2/ssl_modes_PREFERRED__DISABLED
/Users/laurynas/vilniusdb/mysql-9.5.0/router/tests/integration/test_routing_direct.cc:926: Failure
Expected: (change_user_res) succeeds.
  Actual: 28000 (1045) Access denied for user 'caching_sha2' for router while reauthenticating

Google Test trace:
/Users/laurynas/vilniusdb/mysql-9.5.0/router/tests/integration/test_routing_direct.cc:906: // connecting to server

/Users/laurynas/vilniusdb/mysql-9.5.0/router/tests/helpers/process_manager.cc:664: Failure
Failed

[  FAILED  ] Spec/ConnectionTest.classic_protocol_change_user_caching_sha2/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 BD-41 88-00 01-00 00-00 09-00 00-00 00-00 00-00 AB-41 88-00 01-00 00-00 08-00 00-00 00-00 00-00> (13 ms)
... many more such cases ...

How to repeat:
Server built with 
-DCMAKE_EXPORT_COMPILE_COMMANDS=ON -DFORCE_UNSUPPORTED_COMPILER=ON -DBUILD_CONFIG=mysql_release -DCMAKE_BUILD_TYPE=Release -DMYSQL_MAINTAINER_MODE=ON -DWITH_SYSTEM_LIBS=ON -DWITH_NDBCLUSTER_STORAGE_ENGINE=OFF -DFORCE_COLORED_OUTPUT=ON -DCMAKE_CXX_FLAGS=-Wno-nonnull -g -DCMAKE_CXX_FLAGS_DEBUG=-Wno-nonnull -g -DCMAKE_CXX_FLAGS_RELEASE=-O2 -DNDEBUG -Wno-nonnull -g
[28 Oct 7:40] Laurynas Biveinis 
$ runtime_output_directory/routertest_integration_routing_sharing
...
 RUN      ] Spec/ShareConnectionTest.classic_protocol_share_different_accounts/ssl_modes_PREFERRED__DISABLED_tcp
/Users/laurynas/vilniusdb/mysql-9.5.0/router/tests/integration/test_routing_sharing.cc:1845: Failure
Expected: (connect_res) succeeds.
  Actual: 28000 (1045) Access denied for user 'caching_sha2'@'localhost' (using password: YES)

/Users/laurynas/vilniusdb/mysql-9.5.0/router/tests/helpers/process_manager.cc:664: Failure
Failed

[  FAILED  ] Spec/ShareConnectionTest.classic_protocol_share_different_accounts/ssl_modes_PREFERRED__DISABLED_tcp, 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 E4-6A BC-02 01-00 00-00 09-00 00-00 00-00 00-00 BB-5A BC-02 01-00 00-00 08-00 00-00 00-00 00-00>, true) (11 ms)
...
[28 Oct 7:43] Laurynas Biveinis 
$ runtime_output_directory/routertest_integration_routing_sharing_constrained_pools
...
[ RUN      ] Spec/ShareConnectionTinyPoolOneServerTest.overlapping_connections_different_accounts/ssl_modes_PREFERRED__DISABLED
/Users/laurynas/vilniusdb/mysql-9.5.0/router/tests/integration/test_routing_sharing_constrained_pools.cc:1739: Failure
Expected: (connect_res) succeeds.
  Actual: 28000 (1045) Access denied for user 'caching_sha2'@'localhost' (using password: YES)

/Users/laurynas/vilniusdb/mysql-9.5.0/router/tests/helpers/process_manager.cc:664: Failure
Failed

[  FAILED  ] Spec/ShareConnectionTinyPoolOneServerTest.overlapping_connections_different_accounts/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 FF-41 EC-04 01-00 00-00 09-00 00-00 00-00 00-00 5E-3F EC-04 01-00 00-00 08-00 00-00 00-00 00-00> (21 ms)
...
[28 Oct 7:44] Laurynas Biveinis 
$ runtime_output_directory/routertest_integration_routing_sharing_reconnect
...
[ RUN      ] Spec/ShareConnectionReconnectTest.change_user/ssl_modes_PREFERRED__DISABLED_tcp
/Users/laurynas/vilniusdb/mysql-9.5.0/router/tests/integration/test_routing_sharing_reconnect.cc:1201: Failure
Expected: (cmd_res) succeeds.
  Actual: 28000 (1045) Access denied for user 'onetime' for router while reauthenticating

Google Test trace:
/Users/laurynas/vilniusdb/mysql-9.5.0/router/tests/integration/test_routing_sharing_reconnect.cc:1187: // check if a change_user has handled properly.

[  FAILED  ] Spec/ShareConnectionReconnectTest.change_user/ssl_modes_PREFERRED__DISABLED_tcp, 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 42-DC 42-02 01-00 00-00 09-00 00-00 00-00 00-00 30-DC 42-02 01-00 00-00 08-00 00-00 00-00 00-00>, true) (39 ms)
[28 Oct 7:46] Laurynas Biveinis 
$ runtime_output_directory/routertest_integration_routing_splitting
...
[ RUN      ] Spec/SplittingConnectionTest.change_user_targets_the_current_destination/ssl_modes_PREFERRED__DISABLED
/Users/laurynas/vilniusdb/mysql-9.5.0/router/tests/integration/test_routing_splitting.cc:2296: Failure
Expected: (change_user_res) succeeds.
  Actual: 28000 (1045) Access denied for user 'caching_sha2' for router while reauthenticating

Google Test trace:
/Users/laurynas/vilniusdb/mysql-9.5.0/router/tests/integration/test_routing_splitting.cc:2283: // change-user to primary

[  FAILED  ] Spec/SplittingConnectionTest.change_user_targets_the_current_destination/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 A0-0C E5-02 01-00 00-00 09-00 00-00 00-00 00-00 0B-0A E5-02 01-00 00-00 08-00 00-00 00-00 00-00> (32 ms)
[28 Oct 7:48] Laurynas Biveinis 
$ runtime_output_directory/routertest_integration_routing_reuse
...
[ RUN      ] Spec/ReuseConnectionTest.classic_protocol_change_user_sha256_password/ssl_modes_PREFERRED__DISABLED_tcp
/Users/laurynas/vilniusdb/mysql-9.5.0/router/tests/integration/test_routing_reuse.cc:1156: Failure
Expected: (change_user_res) succeeds.
  Actual: 28000 (1045) Access denied for user 'sha256_pass' for router while reauthenticating

Google Test trace:
/Users/laurynas/vilniusdb/mysql-9.5.0/router/tests/integration/test_routing_reuse.cc:1122: // connecting to server

/Users/laurynas/vilniusdb/mysql-9.5.0/router/tests/helpers/process_manager.cc:664: Failure
Failed

[  FAILED  ] Spec/ReuseConnectionTest.classic_protocol_change_user_sha256_password/ssl_modes_PREFERRED__DISABLED_tcp, 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 C6-D7 FC-00 01-00 00-00 09-00 00-00 00-00 00-00 43-D7 FC-00 01-00 00-00 08-00 00-00 00-00 00-00>, true) (7 ms)
...
[28 Oct 9:32] Laurynas Biveinis 
See also bug 118211 and bug 119249