<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd">
<html>
<head></head>
<body>
<div>HI Niels and Company,</div>
<div><br></div>
<div>It feels like I’m spamming so I want to apologize. It seems I spoke a little too soon. It turns out I was able to lock as long as I mounted my gluster volume using glusterfs rather than nfs. I was just on the daemon server that had mounted glusterfs using:</div>
<div><br></div>
<div><font face="Courier">>glusterfsserver</font></div>
<div><font face="Courier">$mount -t glusterfs glusterfsserver:/my_volume /mnt/my_mount</font></div>
<div><font face="Courier">#locking works</font></div>
<div><font face="Courier"><br></font></div>
<div><br></div>
<div><font face="Courier">>random_client</font></div>
<div><font face="Courier">$mount -t nfs glusterfserver:/my_volume /mnt/my_other_mount</font></div>
<div><font face="Courier">#locking doesn’t work</font></div>
<div><br></div>
<div>This just shows me another reason to install glusterfs on all my servers and mount using glusterfs rather than nfs. But I wanted to make sure that this behavior of not being able to lock is consistent in case any other users need to know.</div>
<div class="unibox-signature"><br></div>
<div class="unibox-signature">- Jordan</div>
<div><br></div>
<blockquote type="cite" class="unibox-hidden">
<div>On Jul 5, 2015, at 3:23 AM, Niels de Vos <ndevos@redhat.com> wrote:</div>
<div><br></div>
<div>On Sat, Jul 04, 2015 at 08:10:48PM -0700, Jordan Willis wrote:</div>
<div><br></div>
<blockquote>
<div>Looks like upgrading to the latest version of glusterfs solved all my<br>locking issues.<span class="Apple-converted-space"> </span>
</div>
<div><br></div>
</blockquote>
<div></div>
<div><br></div>
<div>Thanks for reporting back.</div>
<div><br></div>
<div>I'm not aware of any changes related to locking since 3.5.2 (was it?).<br>That makes it difficult to guess what the problem caused and why it<br>works fine with an updated version.</div>
<div><br></div>
<div>Have a good weekend,<br>Niels</div>
<div><br></div>
<blockquote>
<div style="orphans: auto; text-align: start; widows: auto;"></div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<div style="orphans: auto; text-align: start; widows: auto;">Thank you,<br>Jordan</div>
<div style="orphans: auto; text-align: start; widows: auto;"><br></div>
<blockquote style="orphans: auto; text-align: start; widows: auto;">
<div>On Jul 4, 2015, at 3:22 AM, Jordan Willis <jwillis0720@gmail.com> wrote:</div>
<div><br></div>
<div>Its not just sqlite, but mongodb and ipython notebook. If you have a solution for mongodb file locking, I’m welcome to suggestions. But not using mongodb, is not an option.<span class="Apple-converted-space"> </span>
</div>
<div><br></div>
<blockquote>
<div>On Jul 4, 2015, at 2:57 AM, Niels de Vos <ndevos@redhat.com> wrote:</div>
<div><br></div>
<div>On Fri, Jul 03, 2015 at 06:46:01PM -0700, Jordan Willis wrote:</div>
<div><br></div>
<blockquote>
<div>Hi,</div>
<div><br></div>
<div>Is it possible to enable posix type locking with glusterfs without<br>shutting off the volume?</div>
<div><br></div>
</blockquote>
<div></div>
<div><br></div>
<div>Locking should be enabled by default (like Kaushal explained in an other<br>reply).</div>
<div><br></div>
<blockquote>
<div>I think this is what I need (I’m trying to get sqlite to lock files on<br>my nfs mounted glusterfs volume)</div>
<div><br></div>
</blockquote>
<div></div>
<div><br></div>
<div>SQLite is not the best databases to place on a shared filesystem. The<br>locking done by SQLite is (or at least was, might have changed) not very<br>advanced. From what I remember, there is a single file lock, no table or<br>row granularity.</div>
<div><br></div>
<div>https://www.sqlite.org/pragma.html#pragma_locking_mode contains some<br>more details, and it also points to the WAL documentation. You will want<br>to prevent SQLite to use shared-memory for WAL if you access the<br>database from different servers at the same time.</div>
<div><br></div>
<div>HTH,<br>Niels</div>
<div><br></div>
</blockquote>
<div></div>
<div><br></div>
</blockquote>
<div style="orphans: auto; text-align: start; widows: auto;"></div>
<br class="Apple-interchange-newline">
</blockquote>
</blockquote>
</body>
</html>