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

Gally, Jerry Jerry.Gally at arrisi.com
Tue Apr 12 23:41:59 UTC 2011

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/\:-logging-sme-gfs-backing
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
    option remote-subvolume /logging/sme-gfs-backing
    option transport-type tcp

volume sme_global-write-behind
    type performance/write-behind
    subvolumes sme_global-client-0

volume sme_global-read-ahead
    type performance/read-ahead
    subvolumes sme_global-write-behind

volume sme_global-io-cache
    type performance/io-cache
    subvolumes sme_global-read-ahead

volume sme_global-quick-read
    type performance/quick-read
    subvolumes sme_global-io-cache

volume sme_global-stat-prefetch
    type performance/stat-prefetch
    subvolumes sme_global-quick-read

volume sme_global
    type debug/io-stats
    subvolumes sme_global-stat-prefetch

[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

jer - Arris Corporation

More information about the Gluster-users mailing list