[MDEV-7157] plugins.server_audit fails sporadically in buildbot Created: 2014-11-22  Updated: 2015-02-16  Resolved: 2015-02-16

Status: Closed
Project: MariaDB Server
Component/s: Tests
Affects Version/s: 5.5, 10.0
Fix Version/s: 5.5.43

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Alexey Botchkov
Resolution: Fixed Votes: 0
Labels: buildbot, tests

Issue Links:
Relates
relates to MDEV-7069 Fix buildbot failures in main server ... Stalled

 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



 Comments   
Comment by Alexey Botchkov [ 2014-11-24 ]

Fixing patch: http://lists.askmonty.org/pipermail/commits/2014-November/007066.html

Comment by Elena Stepanova [ 2014-11-24 ]

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

Comment by Elena Stepanova [ 2014-12-19 ]

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

Comment by Elena Stepanova [ 2015-01-10 ]

Fresh one on 10.0:
http://buildbot.askmonty.org/buildbot/builders/kvm-bintar-centos5-amd64/builds/981/steps/test/logs/stdio
Please fix!

Comment by Alexey Botchkov [ 2015-02-16 ]

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

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