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: [email protected] [mailto:[email protected]] On Behalf Of Poornima Gurusiddaiah Sent: Friday, 15 May 2015 4:06 PM To: Jordan Willis Cc: [email protected] 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" <[email protected]<mailto:[email protected]>> To: [email protected]<mailto:[email protected]> 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 [email protected]<mailto:[email protected]> http://www.gluster.org/mailman/listinfo/gluster-users
_______________________________________________ Gluster-users mailing list [email protected] http://www.gluster.org/mailman/listinfo/gluster-users
