Hi Núria,
So you increased from 9000 to 9000000 , which is excessive considering the
query takes 144secs to complete ?
Can you provide the query being executed as well as the query profile by
running “set profile on;” from isql before running the query.
What is the current triple count on the server, which can be obtained with:
sparql select count(*) where {?s ?p ?o};
Also what is the status of the server after running the query multiple times,
which can be obtained with the command:
status();
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
> On 28 Aug 2015, at 18:08, Nuria Queralt Rosinach <[email protected]> wrote:
>
> Hi Hugh,
>
>
> On 08/28/2015 06:46 PM, Hugh Williams wrote:
>> Hi Núria,
>>
>> What was the 'MaxQueryCostEstimationTime’ parameter set to previously and
>> what did you increase it to , as the “ERR_CONTENT_DECODING_FAILED” error
>> seem odd for a timeout parameter ?
>
> I increased from 9x10**3 to 9x10**6
>
> I got directly the virtuoso error message executing the query from our
> endpoint but specifying the virtuoso port in the browser, in order to avoid
> the apache server. then the message error from virtuoso was that the
> estimation execution time was too short. the error message
> "ERR_CONTENT_DECODING_FAILED" come from apache i guess, as it does not know
> how to serve the error message from virtuoso?
>
>>
>> Also, when you ran the query from isql how long does it take to execute and
>> return results ?
>
> 144552 msec
>
> best,
> n
>>
>> Best Regards
>> Hugh Williams
>> Professional Services
>> OpenLink Software, Inc. // http://www.openlinksw.com/
>> <http://www.openlinksw.com/>Weblog -- http://www.openlinksw.com/blogs/
>> <http://www.openlinksw.com/blogs/>LinkedIn --
>> http://www.linkedin.com/company/openlink-software/
>> <http://www.linkedin.com/company/openlink-software/>Twitter --
>> http://twitter.com/OpenLink <http://twitter.com/OpenLink>Google+ --
>> http://plus.google.com/100570109519069333827/
>> <http://plus.google.com/100570109519069333827/>Facebook --
>> http://www.facebook.com/OpenLinkSoftware
>> <http://www.facebook.com/OpenLinkSoftware>
>> Universal Data Access, Integration, and Management Technology Providers
>>
>>> On 28 Aug 2015, at 15:51, Nuria Queralt Rosinach <[email protected]
>>> <mailto:[email protected]>> wrote:
>>>
>>> Hi Hugh,
>>>
>>> Problem solved! just increasing a bit the ' MaxQueryCostEstimationTime'
>>> parameter in the configuration of the SPARQL service and the query works
>>> perfectly fine :)
>>>
>>> Thank you very much for your always fast replies.
>>> Best,
>>> Núria
>>>
>>> On 08/28/2015 04:30 PM, Nuria Queralt Rosinach wrote:
>>>> Hi Hugh,
>>>>
>>>>
>>>> On 08/28/2015 02:56 PM, Hugh Williams wrote:
>>>>> HI Núria,
>>>>>
>>>>> You reported the same error running a SPARQL-FED query last year, was
>>>>> this resolved then as it is unclear from the thread ?
>>>>
>>>> Good memory! i managed to solve the problem in that case. This time it is
>>>> not a FED.
>>>>> What is the query currently being run is it a SPARQL-FED query also or a
>>>>> query against the local instance ?
>>>>>
>>>>
>>>> it is about a query against local data. Issues raised via the sparql
>>>> endpoint when using DISTINCT in a SELECT query, or GROUP BY modifier: the
>>>> same query gives output without using DISTINCT or GROUP BY in the SELECT
>>>> query.
>>>>
>>>>> If the query runs from isql which executes queries as the “dba” (or
>>>>> whatever user you login as) and fails via the HTTP , which I assume is
>>>>> the /sparql endpoint, which runs as user “SPARQL”,
>>>>
>>>> yes
>>>>> then most probably the roles assigned to both differ, thus you should
>>>>> check was is assigned to both in the “System Admin -> User Accounts”
>>>>> section of the Conductor and ensure the same SPARQL roles are assigned ie
>>>>> SPARQL_SELECT, SPARQL_UPDATE, SPARQL_SPONGE, SPARQL_LOAD_SERVICE_DATA ,
>>>>> see:
>>>>>
>>>>>
>>>>> http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsupportedprotocolendpointuri
>>>>>
>>>>> <http://docs.openlinksw.com/virtuoso/rdfsparql.html#rdfsupportedprotocolendpointuri>
>>>>>
>>>>> http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksDiscoverSPARQFedCapabilities
>>>>>
>>>>> <http://virtuoso.openlinksw.com/dataspace/dav/wiki/Main/VirtTipsAndTricksDiscoverSPARQFedCapabilities>
>>>> I checked, they differ: SPARQL user has the 'SPARQL_SELECT' role assigned,
>>>> whereas the dba user does not have any role assigned...
>>>>
>>>> Thanks!
>>>> Núria
>>>>>
>>>>> Best Regards
>>>>> Hugh Williams
>>>>> Professional Services
>>>>> OpenLink Software, Inc. // http://www.openlinksw.com/
>>>>> <http://www.openlinksw.com/>
>>>>> Weblog -- http://www.openlinksw.com/blogs/
>>>>> <http://www.openlinksw.com/blogs/>
>>>>> LinkedIn -- http://www.linkedin.com/company/openlink-software/
>>>>> <http://www.linkedin.com/company/openlink-software/>
>>>>> Twitter -- http://twitter.com/OpenLink <http://twitter.com/OpenLink>
>>>>> Google+ -- http://plus.google.com/100570109519069333827/
>>>>> <http://plus.google.com/100570109519069333827/>
>>>>> Facebook -- http://www.facebook.com/OpenLinkSoftware
>>>>> <http://www.facebook.com/OpenLinkSoftware>
>>>>> Universal Data Access, Integration, and Management Technology Providers
>>>>>
>>>>>
>>>>>
>>>>>> On 28 Aug 2015, at 12:33, Nuria Queralt Rosinach <[email protected]
>>>>>> <mailto:[email protected]>> wrote:
>>>>>>
>>>>>> Dear all,
>>>>>>
>>>>>> I have a problem with a query that perfectly works via ISQL, but it does
>>>>>> not via Web. The error i got is: Error code: ERR_CONTENT_DECODING_FAILED
>>>>>>
>>>>>>
>>>>>> Virtuoso version implemented:
>>>>>> OpenLink Virtuoso Server
>>>>>> Version 07.10.3211-pthreads for Linux as of Nov 4 2014
>>>>>>
>>>>>> Could you shed light on that problem? Many thanks in advance.
>>>>>>
>>>>>> Best regards,
>>>>>> Núria
>>>>>> --
>>>>>> ********************************************************************
>>>>>> Núria Queralt Rosinach
>>>>>> Research Programme on Biomedical Informatics (GRIB)
>>>>>> Department of Experimental and Health Sciences
>>>>>> Universitat Pompeu Fabra
>>>>>> IMIM (Hospital del Mar Medical Research Institute)
>>>>>> C/Dr. Aiguader 88, 08003
>>>>>> Barcelona, Spain
>>>>>> Tel.: +34 93 316 0536 (1536)
>>>>>> E-mail: [email protected] <mailto:[email protected]>
>>>>>> Skype IM: nuriaqr76
>>>>>> http://ibi.imim.es/ <http://ibi.imim.es/>
>>>>>> ********************************************************************
>>>>>> ------------------------------------------------------------------------------
>>>>>> _______________________________________________
>>>>>> Virtuoso-users mailing list
>>>>>> [email protected]
>>>>>> <mailto:[email protected]>
>>>>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>>>>> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users>
>>>>>
>>>>
>>>> --
>>>> ********************************************************************
>>>> Núria Queralt Rosinach
>>>> Research Programme on Biomedical Informatics (GRIB)
>>>> Department of Experimental and Health Sciences
>>>> Universitat Pompeu Fabra
>>>> IMIM (Hospital del Mar Medical Research Institute)
>>>> C/Dr. Aiguader 88, 08003
>>>> Barcelona, Spain
>>>> Tel.: +34 93 316 0536 (1536)
>>>> E-mail: [email protected] <mailto:[email protected]>
>>>> Skype IM: nuriaqr76
>>>> http://ibi.imim.es/ <http://ibi.imim.es/>
>>>> ********************************************************************
>>>
>>> --
>>> ********************************************************************
>>> Núria Queralt Rosinach
>>> Research Programme on Biomedical Informatics (GRIB)
>>> Department of Experimental and Health Sciences
>>> Universitat Pompeu Fabra
>>> IMIM (Hospital del Mar Medical Research Institute)
>>> C/Dr. Aiguader 88, 08003
>>> Barcelona, Spain
>>> Tel.: +34 93 316 0536 (1536)
>>> E-mail: [email protected] <mailto:[email protected]>
>>> Skype IM: nuriaqr76
>>> http://ibi.imim.es/ <http://ibi.imim.es/>
>>> ********************************************************************
>>> ------------------------------------------------------------------------------
>>> _______________________________________________
>>> Virtuoso-users mailing list
>>> [email protected]
>>> <mailto:[email protected]>
>>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>>> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users>
>>
>
> --
> ********************************************************************
> Núria Queralt Rosinach
> Research Programme on Biomedical Informatics (GRIB)
> Department of Experimental and Health Sciences
> Universitat Pompeu Fabra
> IMIM (Hospital del Mar Medical Research Institute)
> C/Dr. Aiguader 88, 08003
> Barcelona, Spain
> Tel.: +34 93 316 0536 (1536)
> E-mail: [email protected] <mailto:[email protected]>
> Skype IM: nuriaqr76
> http://ibi.imim.es/ <http://ibi.imim.es/>
> ********************************************************************
> ------------------------------------------------------------------------------
> _______________________________________________
> Virtuoso-users mailing list
> [email protected]
> <mailto:[email protected]>
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
> <https://lists.sourceforge.net/lists/listinfo/virtuoso-users>
------------------------------------------------------------------------------
_______________________________________________
Virtuoso-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/virtuoso-users