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