<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="time"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:595.3pt 841.9pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=DE link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>Hello friends,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>I’ve got a strange problem with my
cluster-setup.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>I’ve got two nodes called www1 and www2 running
Ubuntu Linux <st1:time Minute="10" Hour="8" w:st="on"><st1:time Hour="8"
Minute="10" w:st="on">8.10.</st1:time><o:p></o:p></st1:time></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>The have a 50G volume which is replicated in
primary/primary mode with DRBD.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>On this volume there is an OCSF2 filesystem with this
two nodes.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>Everything is working really fine, files are perfectly
mirrored, really nice.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>On one of the two nodes, I want to run MySQL.
But…<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>When I move the MySQL data directory to the OCFS2 filesystem,
MySQL is unable to start. Filepermissions are fine, and when I su to user mysql
I can write to the OCFS2 without problems. MySQL stops with the following error
message:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Courier New"><span lang=EN-GB
style='font-size:12.0pt;font-family:"Courier New"'>090323 12:11:50 [Warning]
Can't create test file /clusterfs/mysql/www1.lower-test<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Courier New"><span lang=EN-GB
style='font-size:12.0pt;font-family:"Courier New"'>090323 12:11:50 [Warning]
Can't create test file /clusterfs/mysql/www1.lower-test<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Courier New"><span lang=EN-GB
style='font-size:12.0pt;font-family:"Courier New"'>mysqld: File
'/clusterfs/log/www1/mysql/mysql.log' not found (Errcode: 13)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Courier New"><span lang=EN-GB
style='font-size:12.0pt;font-family:"Courier New"'>090323 12:11:50 [ERROR]
Could not use /clusterfs/log/www1/mysql/mysql.log for logging (error 13).
Turning logging off for the whole duration of the MySQL server process. To turn
it on again: fix the cause, shutdown the MySQL server and restart it.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Courier New"><span lang=EN-GB
style='font-size:12.0pt;font-family:"Courier New"'>090323 12:11:50
InnoDB: Operating system error number 13 in a file operation.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Courier New"><span lang=EN-GB
style='font-size:12.0pt;font-family:"Courier New"'>InnoDB: The error means
mysqld does not have the access rights to<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Courier New"><span lang=EN-GB
style='font-size:12.0pt;font-family:"Courier New"'>InnoDB: the directory.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Courier New"><span lang=EN-GB
style='font-size:12.0pt;font-family:"Courier New"'>InnoDB: File name ./ibdata1<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Courier New"><span lang=EN-GB
style='font-size:12.0pt;font-family:"Courier New"'>InnoDB: File operation call:
'open'.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Courier New"><span lang=EN-GB
style='font-size:12.0pt;font-family:"Courier New"'>InnoDB: Cannot continue
operation.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Courier New"><span lang=EN-GB
style='font-size:12.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>I don’t understand where the problem is. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>Interesting is that MySQL did not find the file
“</span></font><font face="Courier New"><span lang=EN-GB
style='font-family:"Courier New"'>/clusterfs/log/www1/mysql/mysql.log</span></font><span
lang=EN-GB>” which is in the filesystem and chmodded 777 for sure.<o:p></o:p></span></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>There are whitepapapers on MySQL.com which describe my
setup as a working MySQL active/passive cluster setup.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>Please help me out!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>Kind regards <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=EN-GB
style='font-size:12.0pt'>Marco<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>