Re: existdb errors on xQueries
Michael Westbay <[email protected]> Wed, 11 Jun 2025 08:51:37 +0900
| Newsgroups | gmane.text.xml.exist |
|---|---|
| Message-ID | <CAJ6MVuM3sDbAgEgXzmOuRTrsNse4dYxutRJA8gCopbc2gtU+4g@mail.gmail.com> |
--===============7907681101125333978==
Content-Type: multipart/alternative; boundary="0000000000001d3ec30637406278"
--0000000000001d3ec30637406278
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Hi Seena,
The return type error is an easy one to fix. The function declaration
expects to always return 1 and only 1 configuration. But it is getting none=
.
If returning no configuration is an option, redefine the function as:
```xquery
declare function config:get-configuration() as element(configuration)? {
...
};
```
If it should always return a configuration, then you need to determine why
it is not finding the configuration. Since you aren't passing a parameter
into the function, it doesn't appear to be something on a per-user basis --
so there should always be the global configuration.
Hope this helps point you in the right direction.
Take care.
2025=E5=B9=B46=E6=9C=8810=E6=97=A5(=E7=81=AB) 22:08 Sanil, Seena via Exist-=
open <
[email protected]>:
> Also errors like this =E2=80=9C
>
> exerr:*ERROR* The actual return type does not match the sequence type
> declared in the function's signature: config:get-configuration() as
> element(configuration). Expected cardinality: exactly one, got 0. [at lin=
e
> 42, column 42, source: /db/apps/eXide/controller.xq]\nIn
> function:\n\tconfig:get-configuration() as element(configuration)=E2=80=
=9D
>
>
>
> *From: *Sanil, Seena <[email protected]>
> *Date: *Monday, June 9, 2025 at 7:44 PM
> *To: *eXist DB ML <[email protected]>
> *Cc: *Lubey, Brian <[email protected]>, Mulvaney, Michael <
> [email protected]>
> *Subject: *existdb errors on xQueries
>
> Hello,
>
> We are getting some errors while running xQuery=E2=80=99s all at once ag=
ainst
> our eXist database with 1.3 million files from different clients like
> browser, oxygen desktop, Postman.
>
>
>
> The errors are =E2=80=9CError while processing /exist/xmlrpc: An unknown =
error
> occurred: org.apache.xmlrpc.XmlRpcException: I/O error while processing
> request=E2=80=9D. . After that, the existdb instance hosted in the the cl=
oud is
> not coming up. Is there a reason for this behavior? How do we avoid this =
in
> the future?
>
>
>
> The xQuery we used are :
>
> _query=3D//cite.bna.reference&_howmany=3D1000 , on a collection
>
>
>
> Thanks
>
> Seena Sanil
>
>
>
>
> _______________________________________________
> Exist-open mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/exist-open
>
--=20
Michael Westbay
Writer/System Administrator
http://www.japanesebaseball.com/
--0000000000001d3ec30637406278
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
<div dir=3D"ltr"><div>Hi Seena,</div><div><br></div><div>The return type er=
ror is an easy one to fix. The function declaration expects to always retur=
n 1 and only 1 configuration. But it is getting none.</div><div><br></div><=
div>If returning no configuration is an option, redefine the function as:</=
div><div><br></div><div>```xquery</div><div><span style=3D"font-family:mono=
space">declare function config:get-configuration() as element(configuration=
)? {</span></div><div><span style=3D"font-family:monospace">=C2=A0 ...</spa=
n></div><div><span style=3D"font-family:monospace">};</span></div><div>```<=
/div><div><br></div><div>If it should always return a configuration, then y=
ou need to determine why it is not finding the configuration. Since you are=
n't passing a parameter into the function, it doesn't appear to be =
something on a per-user basis -- so there should always be the global confi=
guration.</div><div><br></div><div>Hope this helps point you in the right d=
irection.</div><div><br></div><div>Take care.</div><div><br></div><div><br>=
</div><div><br></div><div><br></div></div><br><div class=3D"gmail_quote gma=
il_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">2025=E5=B9=B46=E6=
=9C=8810=E6=97=A5(=E7=81=AB) 22:08 Sanil, Seena via Exist-open <<a href=
=3D"mailto:[email protected]">[email protected]=
et</a>>:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px =
0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div=
class=3D"msg-392584278214495462">
<div lang=3D"EN-US" style=3D"overflow-wrap: break-word;">
<div class=3D"m_-5358710114089695989WordSection1">
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">Also errors like this=
=E2=80=9C<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:9pt;font-family:Monaco;colo=
r:rgb(13,125,112);background:rgb(252,252,253)">exerr:</span><span class=3D"=
m_-5358710114089695989logseventstext-error0"><b><span style=3D"font-size:9p=
t;font-family:Monaco;color:rgb(219,0,0);background:rgb(252,252,253)">ERROR<=
/span></b></span><span style=3D"font-size:9pt;font-family:Monaco;color:rgb(=
13,125,112);background:rgb(252,252,253)">
The actual return type does not match the sequence type declared in the fu=
nction's signature: config:get-configuration() as element(configuration=
). Expected cardinality: exactly one, got 0. [at line 42, column 42, source=
: /db/apps/eXide/controller.xq]\nIn
function:\n\tconfig:get-configuration() as element(configuration)=E2=80=9D=
</span><span style=3D"font-size:11pt"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt"><u></u>=C2=A0<u></u><=
/span></p>
<div id=3D"m_-5358710114089695989mail-editor-reference-message-container">
<div>
<div>
<div style=3D"border-width:1pt medium medium;border-style:solid none none;b=
order-color:rgb(181,196,223) currentcolor currentcolor;padding:3pt 0in 0in"=
>
<p class=3D"MsoNormal" style=3D"margin-bottom:12pt"><b><span style=3D"font-=
size:12pt;color:black">From:
</span></b><span style=3D"font-size:12pt;color:black">Sanil, Seena <<a h=
ref=3D"mailto:[email protected]" target=3D"_blank">ssanil@bloomb=
ergindustry.com</a>><br>
<b>Date: </b>Monday, June 9, 2025 at 7:44 PM<br>
<b>To: </b>eXist DB ML <<a href=3D"mailto:[email protected]=
et" target=3D"_blank">[email protected]</a>><br>
<b>Cc: </b>Lubey, Brian <<a href=3D"mailto:[email protected]"=
target=3D"_blank">[email protected]</a>>, Mulvaney, Michael =
<<a href=3D"mailto:[email protected]" target=3D"_blank">MM=
[email protected]</a>><br>
<b>Subject: </b>existdb errors on xQueries<u></u><u></u></span></p>
</div>
<div>
<p class=3D"MsoNormal"><span style=3D"font-family:"Courier New"">=
Hello,</span><span style=3D"font-size:12pt"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:"Courier New"">=
We are getting some errors while running xQuery=E2=80=99s =C2=A0<span style=
=3D"color:rgb(29,28,29);background:rgb(248,248,248)">all at once against ou=
r eXist database with 1.3 million files from</span> different clients like =
browser,
oxygen desktop, Postman. </span><span style=3D"font-size:12pt"><u></u><u><=
/u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:"Courier New"">=
=C2=A0</span><span style=3D"font-size:12pt"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:"Courier New"">=
The errors are =E2=80=9C<span class=3D"m_-5358710114089695989logseventstext=
-error"><span style=3D"color:rgb(219,0,0);background:rgb(246,246,249)">Erro=
r</span></span><span style=3D"color:rgb(13,125,112);background:rgb(246,246,=
249)"> while processing /exist/xmlrpc:
An unknown </span><span class=3D"m_-5358710114089695989logseventstext-erro=
r"><span style=3D"color:rgb(219,0,0);background:rgb(246,246,249)">error</sp=
an></span><span style=3D"color:rgb(13,125,112);background:rgb(246,246,249)"=
> occurred: org.apache.xmlrpc.XmlRpcException: I/O
</span><span class=3D"m_-5358710114089695989logseventstext-error"><span sty=
le=3D"color:rgb(219,0,0);background:rgb(246,246,249)">error</span></span><s=
pan style=3D"color:rgb(13,125,112);background:rgb(246,246,249)"> while proc=
essing request=E2=80=9D.
</span><span style=3D"color:black;background:rgb(246,246,249)">. After that=
, the existdb instance hosted in the the cloud is not coming up. Is there a=
reason for this behavior? How do we avoid this in the future?</span></span=
><span style=3D"font-size:12pt"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:"Courier New";c=
olor:black;background:rgb(246,246,249)">=C2=A0</span><span style=3D"font-si=
ze:12pt"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:"Courier New";c=
olor:black;background:rgb(246,246,249)">The xQuery we used are :</span><spa=
n style=3D"font-size:12pt"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:"Courier New"">=
_query=3D//cite.bna.reference&_howmany=3D1000 , on a collection</span><=
span style=3D"font-size:12pt"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:"Courier New"">=
=C2=A0</span><span style=3D"font-size:12pt"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:"Courier New"">=
Thanks</span><span style=3D"font-size:12pt"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:"Courier New"">=
Seena Sanil</span><span style=3D"font-size:12pt"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">=C2=A0</span><span st=
yle=3D"font-size:12pt"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span style=3D"font-size:11pt">=C2=A0</span><span st=
yle=3D"font-size:12pt"><u></u><u></u></span></p>
</div>
</div>
</div>
</div>
</div>
</div>
_______________________________________________<br>
Exist-open mailing list<br>
<a href=3D"mailto:[email protected]" target=3D"_blank">Exist=
[email protected]</a><br>
<a href=3D"https://lists.sourceforge.net/lists/listinfo/exist-open" rel=3D"=
noreferrer" target=3D"_blank">https://lists.sourceforge.net/lists/listinfo/=
exist-open</a><br>
</div></blockquote></div><div><br clear=3D"all"></div><br><span class=3D"gm=
ail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signatu=
re">Michael Westbay<br>Writer/System Administrator<br><a href=3D"http://www=
.japanesebaseball.com/" target=3D"_blank">http://www.japanesebaseball.com/<=
/a></div>
--0000000000001d3ec30637406278--
--===============7907681101125333978==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
--===============7907681101125333978==
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
--===============7907681101125333978==--