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

plugins.server_audit fails sporadically in buildbot

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 10.0, 5.5
    • Fix Version/s: 5.5.43
    • Component/s: Tests
    • Labels:

      Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-fulltest/builds/3449/steps/test_6/logs/stdio

      plugins.server_audit                     w1 [ fail ]
              Test ended at 2014-11-22 07:31:14
      
      CURRENT_TEST: plugins.server_audit
      --- /mnt/buildbot/build/mariadb-10.0.15/mysql-test/suite/plugins/r/server_audit.result	2014-11-21 23:02:54.000000000 +0200
      +++ /mnt/buildbot/build/mariadb-10.0.15/mysql-test/suite/plugins/r/server_audit.reject	2014-11-22 07:31:14.000000000 +0200
      @@ -156,7 +156,6 @@
       TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'show variables like \'server_audit%\'',0
       TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_mode=1',0
       TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_events=\'\'',0
      -TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'create database sa_db',0
       TIME,HOSTNAME,root,localhost,ID,0,CONNECT,test,,0
       TIME,HOSTNAME,root,localhost,ID,ID,CREATE,test,t1,
       TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'create table t1 (id2 int)',0
      @@ -169,6 +168,7 @@
       TIME,HOSTNAME,root,localhost,ID,ID,WRITE,mysql,index_stats,
       TIME,HOSTNAME,root,localhost,ID,ID,DROP,test,t1,
       TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'drop table t1',0
      +TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'create database sa_db',0
       TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'use sa_db',0
       TIME,HOSTNAME,root,localhost,ID,ID,CREATE,sa_db,sa_t1,
       TIME,HOSTNAME,root,localhost,ID,ID,QUERY,sa_db,'create table sa_t1(id int)',0
      
      mysqltest: Result content mismatch
      
      ...
      plugins.server_audit                     w1 [ retry-pass ]   6042
      

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

              Show
              holyfoot Alexey Botchkov added a comment - Fixing patch: http://lists.askmonty.org/pipermail/commits/2014-November/007066.html
              Hide
              elenst Elena Stepanova added a comment -

              Still fails (revno 4507):

              http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-x86/builds/1896/steps/test/logs/stdio

              plugins.server_audit                     w2 [ fail ]
                      Test ended at 2014-11-24 07:22:30
              
              CURRENT_TEST: plugins.server_audit
              --- /usr/local/mariadb-10.0.15-linux-i686/mysql-test/suite/plugins/r/server_audit.result	2014-11-24 02:22:27.000000000 +0100
              +++ /usr/local/mariadb-10.0.15-linux-i686/mysql-test/suite/plugins/r/server_audit.reject	2014-11-24 07:22:30.000000000 +0100
              @@ -122,9 +122,9 @@
               uninstall plugin server_audit;
               Warnings:
               Warning	1620	Plugin is busy and will be uninstalled on shutdown
              -TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_logging=on',0
               TIME,HOSTNAME,root,localhost,ID,0,CONNECT,mysql,,0
               TIME,HOSTNAME,root,localhost,ID,0,DISCONNECT,mysql,,0
              +TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_logging=on',0
               TIME,HOSTNAME,no_such_user,localhost,ID,0,FAILED_CONNECT,,,ID
               TIME,HOSTNAME,no_such_user,localhost,ID,0,DISCONNECT,,,0
               TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_incl_users=\'odin, root, dva, tri\'',0
              
              mysqltest: Result content mismatch
              
              Show
              elenst Elena Stepanova added a comment - Still fails (revno 4507): http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-x86/builds/1896/steps/test/logs/stdio plugins.server_audit w2 [ fail ] Test ended at 2014-11-24 07:22:30 CURRENT_TEST: plugins.server_audit --- /usr/local/mariadb-10.0.15-linux-i686/mysql-test/suite/plugins/r/server_audit.result 2014-11-24 02:22:27.000000000 +0100 +++ /usr/local/mariadb-10.0.15-linux-i686/mysql-test/suite/plugins/r/server_audit.reject 2014-11-24 07:22:30.000000000 +0100 @@ -122,9 +122,9 @@ uninstall plugin server_audit; Warnings: Warning 1620 Plugin is busy and will be uninstalled on shutdown -TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_logging=on',0 TIME,HOSTNAME,root,localhost,ID,0,CONNECT,mysql,,0 TIME,HOSTNAME,root,localhost,ID,0,DISCONNECT,mysql,,0 +TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_logging=on',0 TIME,HOSTNAME,no_such_user,localhost,ID,0,FAILED_CONNECT,,,ID TIME,HOSTNAME,no_such_user,localhost,ID,0,DISCONNECT,,,0 TIME,HOSTNAME,root,localhost,ID,ID,QUERY,test,'set global server_audit_incl_users=\'odin, root, dva, tri\'',0 mysqltest: Result content mismatch
              Show
              elenst Elena Stepanova added a comment - 5.5 failure: http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-x86/builds/2029/steps/test/logs/stdio
              Show
              elenst Elena Stepanova added a comment - Fresh one on 10.0: http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-amd64/builds/981/steps/test/logs/stdio Please fix!
              Hide
              holyfoot Alexey Botchkov added a comment -

              The fix pushed in 5.5.
              So closing the bug for now, let's see if it stops failing.

              Show
              holyfoot Alexey Botchkov added a comment - The fix pushed in 5.5. So closing the bug for now, let's see if it stops failing.

                People

                • Assignee:
                  holyfoot Alexey Botchkov
                  Reporter:
                  elenst Elena Stepanova
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - 0 minutes
                    0m
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 7 hours
                    7h