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

[Mohit Anchlia]

BTW: Gluster is not meant to be used with databases.

On Tue, Apr 12, 2011 at 4:41 PM, Gally, Jerry <Jerry.Gally at arrisi.com> wrote:
> 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
>
>
>
> _______________________________________________
> Gluster-users mailing list
> Gluster-users at gluster.org
> http://gluster.org/cgi-bin/mailman/listinfo/gluster-users
>
>