Re: Locking and SQLite

["Jarvis, Jeremy" <jeremy.jarvis@xxxxxxxxxxxxxxxxxxxxx>]

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

 

_______________________________________________
Gluster-users mailing list
Gluster-users@xxxxxxxxxxx
http://www.gluster.org/mailman/listinfo/gluster-users