[Gluster-users] Locking and SQLite

[Jarvis, Jeremy]

I had similar issues a month ago using SQLite over NFS on windows. There was no resolution, SQLite was unable to write due to locking.

From: gluster-users-bounces at gluster.org [mailto:gluster-users-bounces at gluster.org] On Behalf Of Poornima Gurusiddaiah
Sent: Friday, 15 May 2015 4:06 PM
To: Jordan Willis
Cc: Gluster-users at gluster.org
Subject: Re: [Gluster-users] Locking and SQLite

Hi,

Looks related to posix locks in Gluster, does the gluster log file report any errors or warnings?
There are few known issues when client/server goes down when holding locks,
were there any client/server reconnects?
Does restarting brick processes(volume stop and start) solve the issue?

Regards,
Poornima

________________________________
From: "Jordan Willis" <jwillis0720 at gmail.com<mailto:jwillis0720 at gmail.com>>
To: Gluster-users at gluster.org<mailto:Gluster-users at gluster.org>
Sent: Friday, May 15, 2015 9:23:19 AM
Subject: [Gluster-users] Locking and SQLite

Hi,

I found this email thread from a long time ago, but can’t find anything recent about it.

http://www.gluster.org/pipermail/gluster-users/2011-September/008756.html

Is there still issues with SQLite and GlusterFS. I’m using:

$glusterfsd --version
glusterfs 3.5.2 built on Aug  6 2014 19:33:46

The problem is just writing to pre existing to sql databases. For instance -

->echo "select * from test1 order by id desc limit 1;" | sqlite3 test.sqlite3
Error: near line 1: database is locked

Thanks,
Jordan Willis

_______________________________________________
Gluster-users mailing list
Gluster-users at gluster.org<mailto:Gluster-users at gluster.org>
http://www.gluster.org/mailman/listinfo/gluster-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.gluster.org/pipermail/gluster-users/attachments/20150515/613ccfd6/attachment.html>