[Gluster-devel] mysql on glusterfs

[Jeff Humes]

I finally tested this install:

I could not find it on the link listed in the previous email, so I 
retrieved it from:
http://ftp.zresearch.com/pub/gluster/glusterfs/fuse/fuse-2.7.2glfs8.tar.gz

I upgraded fuse on the client, rebooted:  now cannot start mysql at all.

mountpoint:
glusterfs on /var/lib/mysql type fuse 
(rw,nosuid,nodev,allow_other,default_permissions,max_read=1048576)

client config:
[root at asknmapr01 ~]# cat /etc/glusterfs/glusterfs-client_knworksmysql.vol
volume client_knworksmysql
  type protocol/client
  option transport-type tcp/client
  option remote-host 10.1.2.226
#  option remote-subvolume knworksmysql
  option remote-subvolume posix-locks-knworksmysql
end-volume

volume writebehind
  type performance/write-behind
  option aggregate-size 131072
  subvolumes client_knworksmysql
end-volume

Errors in mysql logs:
080116 21:10:00  mysqld started
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
080116 21:10:00  InnoDB: Retrying to lock the first data file
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ibdata1, error: 11


where do I go from here?



Anand Avati wrote:
> only on the client.
>
> avati
>
> 2008/1/14, Jeff Humes <jeff at bofus.org <mailto:jeff at bofus.org>>:
>
>     Not a problem and Thank You for working on this issue!
>
>     Do I need only to update fuse on the server?  or on all (server and
>     clients)?
>
>     -JPH
>
>     Vikas Gorur wrote:
>     > Jeff:
>     >
>     > Sorry for the inordinate delay in responding to this issue.
>     Vacation
>     > time for everyone :)
>     >
>     > The MySQL+GlusterFS issue appears to have been fixed. The
>     problem was
>     > FUSE was sending us the Thread ID of the thread holding the lock,
>     > which confused posix-locks when locking/unlocking was done from two
>     > different threads.
>     >
>     > This patched FUSE fixes the problem:
>     > http://gnu.zresearch.com/~avati/fuse-2.7.2-glfs8.tar.gz
>     <http://gnu.zresearch.com/%7Eavati/fuse-2.7.2-glfs8.tar.gz>
>     >
>     > It works for me. Please do try it and let us know if it works
>     for you.
>     >
>     > Vikas
>     >
>
>
>
>
> -- 
> If I traveled to the end of the rainbow
> As Dame Fortune did intend,
> Murphy would be there to tell me
> The pot's at the other end.