Re: Urgent assistance with locking behaviour of existdb
Adam Retter <[email protected]> Wed, 15 Oct 2025 13:53:28 +0200
| Newsgroups | gmane.text.xml.exist |
|---|---|
| Message-ID | <CAJKLP9bsuq3EqTFDk+dARF2xw2q+s=RrhDAbeUXjsStLDuBvwA@mail.gmail.com> |
--===============0584284105492682845==
Content-Type: multipart/alternative; boundary="000000000000d0a940064131262a"
--000000000000d0a940064131262a
Content-Type: text/plain; charset="UTF-8"
> My personal experience is that
> lock ups occur when I try to update XQuery resources while they are in
> use. Therefore I do not update the applications while they are running
> production.
>
Theoretically that should not be possible as the XQuery whislt it is
executing will hold a READ lock. Whilst the READ lock is held, any requests
to update the XQuery will wait until the READ lock is released, each
pending update operation will then be executed one after another, with each
one taking the WRITE lock.
If there is a deadlock, there must be more resources involved than just the
XQuery.
Would it be possible to see a dump of the lock table when that happens
Pieter?
--
Adam Retter
eXist Core Developer
{ United Kingdom }
[email protected]
--000000000000d0a940064131262a
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr"><div class=3D"gmail_quote gmail_quote_container"><div>=C2=
=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8e=
x;border-left:1px solid rgb(204,204,204);padding-left:1ex">My personal expe=
rience is that <br>
lock ups occur when I try to update XQuery resources while they are in <br>
use. Therefore I do not update the applications while they are running <br>
production.<br></blockquote><div><br></div><div>Theoretically that should n=
ot be possible as the XQuery whislt it is executing will hold a READ lock. =
Whilst the READ lock is held, any requests to update the XQuery will wait u=
ntil the READ lock is released, each pending update operation will then be =
executed one after another, with each one taking the WRITE lock.</div><div>=
<br></div><div>If there is a deadlock, there must be more resources involve=
d than just the XQuery.</div><div><br></div><div>Would it be possible to se=
e a dump of the lock table when that happens Pieter?</div></div><div><br></=
div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" c=
lass=3D"gmail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr"><div>Adam R=
etter<br><br>eXist Core Developer<br>{ United Kingdom }<br><a href=3D"mailt=
o:[email protected]" target=3D"_blank">[email protected]</a><br></div></div=
></div></div></div></div>
--000000000000d0a940064131262a--
--===============0584284105492682845==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
--===============0584284105492682845==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
_______________________________________________
Exist-open mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/exist-open
--===============0584284105492682845==--