<br>Hello. I would like to ask about having mysql data hosted on glusterfs. Please see my issue below. I have posted DEBUG log information on pastebin. <br><br>I am using<br><br>GlusterFS version: glusterfs 1.4.0rc7<br><br>
FUSE Version :fuse-2.7.3glfs10<br><br>my ISSUE is:<br>When hosting mysql data on glusterfs I have an issue:<br><br>The first time I start the glusterfsd server using <br><br>[root@mohan ~]# /usr/local/sbin/glusterfsd -f /usr/local/etc/glusterfs/glusterfs-server.vol.sample<br>
<br>and mount the glusterfs client (/var/lib/mysql) mountpoint using <br><br>[root@localhost ~]# /usr/local/sbin/glusterfs -f /usr/local/etc/glusterfs/glusterfs-client.vol.sample /var/lib/mysql<br><br>Ok fine . then i am trying to login it through error<br>
<br>[root@localhost ~]# service mysqld status<br>mysqld (pid 1700) is running...<br><br>[root@localhost ~]# mysql -u root <br>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)<br>
<br>Then I am unmounted using <br><br>[root@localhost ~]# umount /var/lib/mysql/<br><br>Again mounted using<br><br>[root@localhost ~]# /usr/local/sbin/glusterfs -f /usr/local/etc/glusterfs/glusterfs-client.vol.sample /var/lib/mysql<br>
<br><br>i am getting the same problem like <br><br>[root@localhost ~]# mysql -u root<br>ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)<br><br><br>then I checked log ,there is no any error <br>
<br>[root@localhost ~]# cat /var/log/mysqld.log<br><br><br>I stoped and start mysqld in client machine using <br><br>[root@localhost ~]# service mysqld stop<br>Stopping MySQL: [ OK ]<br>
<br>[root@localhost ~]# service mysqld start<br>Timeout error occurred trying to start MySQL Daemon.<br>Starting MySQL: [FAILED]<br><br>Then i am trying to unmount ,it tells device id busy.but I am not using this directory <br>
<br>[root@localhost ~]# umount /var/lib/mysql/<br>umount: /var/lib/mysql: device is busy<br>umount: /var/lib/mysql: device is busy<br><br>again tryed to login mysql ,still it gives the error<br><br>[root@localhost ~]# mysql -u root<br>
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)<br><br><br>Then Again I am started mysqld . lost time this was failed .now it is started <br><br>[root@localhost ~]# service mysqld start<br>
Starting MySQL: [ OK ]<br><br>Then I tryed to login . Now i am able to login .everthing is fine . <br><br>[root@localhost ~]# mysql <br>Welcome to the MySQL monitor. Commands end with ; or \g.<br>
Your MySQL connection id is 2<br>Server version: 5.0.51a Source distribution<br><br>Type 'help;' or '\h' for help. Type '\c' to clear the buffer.<br><br>mysql> <br><br><br>Now I am getting log file it has error like this .<br>
<br>[root@localhost ~]# cat /var/log/mysqld.log<br>090120 20:52:20 mysqld ended<br><br>090120 20:52:29 mysqld started<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>090120 20:52:29 InnoDB: Retrying to lock the first data file<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>090120 20:53:42 mysqld started<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>090120 20:53:42 InnoDB: Retrying to lock the first data file<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
090120 20:54:09 InnoDB: Unable to open the first data file<br>InnoDB: Error in opening ./ibdata1<br>090120 20:54:09 InnoDB: Operating system error number 38 in a file operation.<br>InnoDB: Error number 38 means 'Function not implemented'.<br>
InnoDB: Some operating system error numbers are described at<br>InnoDB: <a href="http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html">http://dev.mysql.com/doc/refman/5.0/en/operating-system-error-codes.html</a><br>
InnoDB: Could not open or create data files.<br>InnoDB: If you tried to add new data files, and it failed here,<br>InnoDB: you should now edit innodb_data_file_path in my.cnf back<br>InnoDB: to what it was, and remove the new ibdata files InnoDB created<br>
InnoDB: in this failed attempt. InnoDB only wrote those files full of<br>InnoDB: zeros, but did not yet use them in any way. But be careful: do not<br>InnoDB: remove old data files which contain your precious data!<br>090120 20:54:09 [Note] /usr/libexec/mysqld: ready for connections.<br>
Version: '5.0.51a' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>InnoDB: Unable to lock ./ibdata1, error: 38<br>
InnoDB: Unable to lock ./ibdata1, error: 38<br><br><br><br>NOTE : I am using load posix-locks translator in my server vol file like this <br><br><br>volume brick<br> type storage/posix # POSIX FS translator<br>
option directory /mnt/mymysql/mysql #bench # Export this directory<br>end-volume<br><br><br>volume plocks<br> type features/posix-locks<br> subvolumes brick<br> # option mandatory on<br>end-volume<br><br>
<br><a href="http://www.mail-archive.com/gluster-devel@nongnu.org/msg03125.html">http://www.mail-archive.com/gluster-devel@nongnu.org/msg03125.html</a><br><br>some one faced like this ,he is using different version .it was solved . can any one please help me ? I am using <br>
<br>FUSE Version :fuse-2.7.3glfs10<br>GlusterFS version: glusterfs 1.4.0rc7<br><br> Thanks for your time <br> <br> L. Mohan<br><br><br>