Can you share your query? I don't understand if you're trying to insert a single literal string that is 85MB in size, or if you're trying to load 900K triples that are 85MB in total.
> Sent: Tuesday, August 06, 2019 at 9:52 AM > From: "Pierre Grenon" <pgre...@horizon-asset.co.uk> > To: "users@jena.apache.org" <users@jena.apache.org> > Subject: RE: Sensible size limit for SPARQL update payload to Fuseki2? > > Quick follow up -- > > The web fuseki interface is happy loading the turtle equivalent. Takes more > time (~10-15 sec) than it takes for the programmatic way to return an error > (<2 sec), it's about 900k triples. > > So I was thinking of splitting my INSERT and was wondering if there is a > reasonable chunk size. > > As said, will try to look at the logs anyway. > > Best, > Pierre > > THIS E-MAIL MAY CONTAIN CONFIDENTIAL AND/OR PRIVILEGED INFORMATION. > IF YOU ARE NOT THE INTENDED RECIPIENT (OR HAVE RECEIVED THIS E-MAIL > IN ERROR) PLEASE NOTIFY THE SENDER IMMEDIATELY AND DESTROY THIS > E-MAIL. ANY UNAUTHORISED COPYING, DISCLOSURE OR DISTRIBUTION OF THE > MATERIAL IN THIS E-MAIL IS STRICTLY FORBIDDEN. > > IN ACCORDANCE WITH MIFID II RULES ON INDUCEMENTS, THE FIRM'S EMPLOYEES > MAY ATTEND CORPORATE ACCESS EVENTS (DEFINED IN THE FCA HANDBOOK AS > "THE SERVICE OF ARRANGING OR BRINGING ABOUT CONTACT BETWEEN AN INVESTMENT > MANAGER AND AN ISSUER OR POTENTIAL ISSUER"). DURING SUCH MEETINGS, THE > FIRM'S EMPLOYEES MAY ON NO ACCOUNT BE IN RECEIPT OF INSIDE INFORMATION > (AS DESCRIBED IN ARTICLE 7 OF THE MARKET ABUSE REGULATION (EU) NO 596/2014). > (https://www.handbook.fca.org.uk/handbook/glossary/G3532m.html) > COMPANIES WHO DISCLOSE INSIDE INFORMATION ARE IN BREACH OF REGULATION > AND MUST IMMEDIATELY AND CLEARLY NOTIFY ALL ATTENDEES. FOR INFORMATION > ON THE FIRM'S POLICY IN RELATION TO ITS PARTICIPATION IN MARKET SOUNDINGS, > PLEASE SEE https://www.horizon-asset.co.uk/market-soundings/. > > HORIZON ASSET LLP IS AUTHORISED AND REGULATED > BY THE FINANCIAL CONDUCT AUTHORITY. > > > > -----Original Message----- > > From: Pierre Grenon > > Sent: 06 August 2019 08:47 > > To: 'users@jena.apache.org' > > Subject: RE: Sensible size limit for SPARQL update payload to Fuseki2? > > > > Hi, > > > > Thanks for your answer. > > > > I'll look into the server's logs if I can. I am using this approach because > > the > > server is in fact remote. So I read into a string that I then pass to POST. > > The > > query when saved to file is ~ 85Mb. > > > > I guess I was lazy and hoping for an easy answer if this clogged up Fuseki > > in > > known ways and whether that might be addressed through config (memory, > > thread, whatnots). > > > > Will double check a few things and report then. > > > > With many thanks and best regards, > > Pierre > > > > > > From: Laura Morales [mailto:laure...@mail.com] > > Sent: 06 August 2019 08:19 > > To: users@jena.apache.org > > Cc: users@jena.apache.org > > Subject: Re: Sensible size limit for SPARQL update payload to Fuseki2? > > > > How long is your query?? Personally I'm not aware of any such limitations, > > especially when POSTing, but other people here definitely know better than > > me if there is one or not. If there is a limit, let's say even just 1MB, > > you need > > a *very* long query to break it. 500 is a general "internal error" code, > > it's not > > specific to query length. It could be something else (look at the logs). > > Did you > > try to run the query from the Fuseki web interface, or even with another > > database entirely? It could help you debug it. > > > > > > > > > Sent: Tuesday, August 06, 2019 at 8:15 AM > > > From: "Pierre Grenon" <pgre...@horizon-asset.co.uk> > > > To: "users@jena.apache.org" <users@jena.apache.org> > > > Subject: Sensible size limit for SPARQL update payload to Fuseki2? > > > > > > Hi, > > > > > > Maybe a long shot but thought I'd ask. > > > > > > I'm sending updates to a Fuseki2 from an RDFLib/SPARQLWrapper based > > client. This POSTs an INSERT string to an update endpoint. I get back an > > error > > 500 for strings over a certain large size which (the limit) I haven't tried > > to > > figure out. > > > > > > Is there a theoretical, or other, reason why the limit exists and a > > > strategy > > to adopt besides fine tuning the string size? > > > > > > Many thanks and best regards, > > > Pierre > > > > > > THIS E-MAIL MAY CONTAIN CONFIDENTIAL AND/OR PRIVILEGED > > INFORMATION. > > > IF YOU ARE NOT THE INTENDED RECIPIENT (OR HAVE RECEIVED THIS E-MAIL > > > IN ERROR) PLEASE NOTIFY THE SENDER IMMEDIATELY AND DESTROY THIS > > > E-MAIL. ANY UNAUTHORISED COPYING, DISCLOSURE OR DISTRIBUTION OF > > THE > > > MATERIAL IN THIS E-MAIL IS STRICTLY FORBIDDEN. > > > > > > IN ACCORDANCE WITH MIFID II RULES ON INDUCEMENTS, THE FIRM'S > > EMPLOYEES > > > MAY ATTEND CORPORATE ACCESS EVENTS (DEFINED IN THE FCA > > HANDBOOK AS > > > "THE SERVICE OF ARRANGING OR BRINGING ABOUT CONTACT BETWEEN > > AN INVESTMENT > > > MANAGER AND AN ISSUER OR POTENTIAL ISSUER"). DURING SUCH > > MEETINGS, THE > > > FIRM'S EMPLOYEES MAY ON NO ACCOUNT BE IN RECEIPT OF INSIDE > > INFORMATION > > > (AS DESCRIBED IN ARTICLE 7 OF THE MARKET ABUSE REGULATION (EU) NO > > 596/2014). > > > (https://www.handbook.fca.org.uk/handbook/glossary/G3532m.html) > > > COMPANIES WHO DISCLOSE INSIDE INFORMATION ARE IN BREACH OF > > REGULATION > > > AND MUST IMMEDIATELY AND CLEARLY NOTIFY ALL ATTENDEES. FOR > > INFORMATION > > > ON THE FIRM'S POLICY IN RELATION TO ITS PARTICIPATION IN MARKET > > SOUNDINGS, > > > PLEASE SEE https://www.horizon-asset.co.uk/market-soundings/. > > > > > > HORIZON ASSET LLP IS AUTHORISED AND REGULATED > > > BY THE FINANCIAL CONDUCT AUTHORITY. > > > > > > > > > >
