[MDEV-17282] main.connect failed in buildbot with wrong result Created: 2018-09-24  Updated: 2023-11-28

Status: Open
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 10.2, 11.1.1
Fix Version/s: 11.1

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

http://buildbot.askmonty.org/buildbot/builders/mac-1012-bintar/builds/3947

main.connect                             [ fail ]
        Test ended at 2018-08-16 12:27:02
 
CURRENT_TEST: main.connect
--- /Users/buildbot/maria-slave/mac-1012-bintar/build/mysql-test/r/connect.result	2018-08-16 07:24:50.000000000 -0400
+++ /Users/buildbot/maria-slave/mac-1012-bintar/build/mysql-test/r/connect.reject	2018-08-16 12:27:02.000000000 -0400
@@ -222,7 +222,7 @@
 
 # -- Connecting super (2) [should fail]...
 # -- Establishing connection 'con_super_2' (user: root)...
-# -- Error: can not establish connection 'con_super_2'.
+# -- Connection 'con_super_2' has been established.
 
 # -- Ensure that we have Event Scheduler thread, 3 ordinary user
 # -- connections and one extra super-user connection.
 
mysqltest: Result length mismatch



 Comments   
Comment by Timofey Turenko [ 2023-08-11 ]

another case with the same test:

main.connect                             w1 [ fail ]
        Test ended at 2023-08-10 20:16:00
 
CURRENT_TEST: main.connect
--- /usr/share/mariadb-test/main/connect.result	2023-06-05 20:45:39.000000000 +0200
+++ /usr/share/mariadb-test/main/connect.reject	2023-08-10 20:16:00.326830145 +0200
 
 
@@ -100,6 +100,8 @@
 connect  fail_con,localhost,test,zorro,;
 ERROR 28000: Access denied for user 'test'@'localhost' (using password: YES)
 # switching from mysql.global_priv to mysql.user
+Warnings:
+Warning	1406	Data too long for column 'Host' at row 3
 update mysql.user set plugin="", authentication_string="", password=old_password("gambling2") where user=_binary"test";
 flush privileges;
 show grants for test@localhost;
@@ -366,6 +368,8 @@
 ERROR 28000: Access denied for user 'mysqltest_nouser'@'localhost' (using password: NO)
 connection default;
 # switching from mysql.global_priv to mysql.user
+Warnings:
+Warning	1406	Data too long for column 'Host' at row 3
 update mysql.user set plugin='mysql_native_password' where user = 'mysqltest_up1';
 update mysql.user set plugin='mysql_old_password' where user = 'mysqltest_up2';
 select user, password, plugin, authentication_string from mysql.user
 
mysqltest: Result length mismatch
 
 - saving '/var/tmp/mtr/1/log/main.connect/' to '/var/tmp/mtr/log/main.connect/'
 
Retrying test main.connect, attempt(2/3)...

logs https://mdbe-ci-repo.mariadb.net/bb-logs/MariaDBServerCommunityProduction/11.1.1/rocky_linux_9_gcp/mtr-big-test/22920/

Generated at Thu Feb 08 08:35:17 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.