[Gluster-users] mysql regression tests fail with gluster 3.1.3

[Gally, Jerry]

Typo:
Kernel 2.6.32
Distro Centos 5.5

From: Gally, Jerry
Sent: Tuesday, April 12, 2011 4:40 PM
To: 'Gluster-users at gluster.org'
Subject: mysql regression tests fail with gluster 3.1.3

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