Hi all,
Looking for help ...
This is easy to reproduce, and appears to be 100% reproducible: i.e. the regression appears to never fully succeed when the mysql data location is in a gluster subdir, but if the location is moved to a non-gluster ext3 subdir it appears to always succeed.
With gluster, some test cases fail every time, others randomly fail. Interestingly, one of the test cases that fails every time, innodb.test, does not fail if the test case is run under strace, which suggests a timing/race condition to me (running mysql test cases with strace is slightly tricky: let me know if you want the hack work-around for this).
After installing mysql, mysql-server, and mysql-test, the regression suite can be started via root as follows from /usr/share/mysql-test :
sudo -u mysql ./mysql-test-run --vardir=<any global glusterfs subdirectory that has read/write/execute and create/remove permissions >
Configuration info:
- Linux kernel 3.2.32
- glusterfs-core.x86_64 3.1.3-1
- glusterfs-fuse.x86_64 3.1.3-1
- mysql.x86_64 5.0.77-4.el5_5.5
- mysql-server.x86_64 5.0.77-4.el5_5.5
- mysql-test.x86_64 5.0.77-4.el5_5.5
Single node gluster.
[root at sweng65 mysql-test]# cat /etc/glusterd/vols/sme_global/bricks/192.160.100.65\:-logging-sme-gfs-backing
hostname=192.160.100.65
path=/logging/sme-gfs-backing # note: this is an ext3 fs
[root at sweng65 mysql-test]# cat /etc/glusterd/vols/sme_global/sme_global-fuse.vol
volume sme_global-client-0
type protocol/client
option remote-host 192.160.100.65
option remote-subvolume /logging/sme-gfs-backing
option transport-type tcp
end-volume
volume sme_global-write-behind
type performance/write-behind
subvolumes sme_global-client-0
end-volume
volume sme_global-read-ahead
type performance/read-ahead
subvolumes sme_global-write-behind
end-volume
volume sme_global-io-cache
type performance/io-cache
subvolumes sme_global-read-ahead
end-volume
volume sme_global-quick-read
type performance/quick-read
subvolumes sme_global-io-cache
end-volume
volume sme_global-stat-prefetch
type performance/stat-prefetch
subvolumes sme_global-quick-read
end-volume
volume sme_global
type debug/io-stats
subvolumes sme_global-stat-prefetch
end-volume
[root at sweng65 mysql-test]# cat /etc/glusterfs/glusterd.vol
volume management
type mgmt/glusterd
option working-directory /etc/glusterd
option transport-type socket,rdma
option transport.socket.keepalive-time 10
option transport.socket.keepalive-interval 2
end-volume
jer - Arris Corporation
