Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-17282

main.connect failed in buildbot with wrong result

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 11.1.1, 10.2(EOL)
    • 11.1(EOL)
    • Tests
    • 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

      Attachments

        Activity

          tturenko Timofey Turenko added a comment -

          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/

          tturenko Timofey Turenko added a comment - 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/

          People

            Unassigned Unassigned
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.