Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

AGROVOC submissions api endpoint is not responding #271

Closed
Tracked by #279
syphax-bouazzouni opened this issue May 18, 2022 · 2 comments
Closed
Tracked by #279

AGROVOC submissions api endpoint is not responding #271

syphax-bouazzouni opened this issue May 18, 2022 · 2 comments
Labels
bug content Issues related to the content of AgroPortal

Comments

@syphax-bouazzouni
Copy link
Contributor

syphax-bouazzouni commented May 18, 2022

Related

Issue

http://data.agroportal.lirmm.fr/ontologies/AGROVOC/submissions/22?display=all
Or
http://data.agroportal.lirmm.fr/ontologies/AGROVOC/latest_submission?display=all

returns 520 proxy error

image

Cause

When we do display=all it is 132 properties that are requested

{submissionId,prefLabelProperty,definitionProperty,synonymProperty,authorProperty,classType,hierarchyProperty
,obsoleteProperty,obsoleteParent,homepage,publication,URI,naturalLanguage,documentation,version,description,
status,creationDate,released,numberOfClasses,numberOfIndividuals,numberOfProperties,maxDepth,maxChildCount,
averageChildCount,classesWithOneChild,classesWithMoreThan25Children,classesWithNoDefinition,modificationDate,
entities,numberOfAxioms,keyClasses,keywords,knownUsage,notes,conformsToKnowledgeRepresentationParadigm,
hasContributor,hasCreator,designedForOntologyTask,wasGeneratedBy,wasInvalidatedBy,curatedBy,endorsedBy,fundedBy,
translator,hasDomain,hasFormalityLevel,hasLicense,hasOntologySyntax,isOfType,usedOntologyEngineeringMethodology,
usedOntologyEngineeringTool,useImports,hasPriorVersion,isBackwardCompatibleWith,isIncompatibleWith,deprecated,
versionIRI,ontologyRelatedTo,comesFromTheSameDomain,similarTo,isAlignedTo,explanationEvolution,generalizes,
hasDisparateModelling,hiddenLabel,coverage,publisher,identifier,source,abstract,alternative,hasPart,isFormatOf,
hasFormat,audience,valid,accrualMethod,accrualPeriodicity,accrualPolicy,endpoint,dataDump,csvDump,
openSearchDescription,uriLookupEndpoint,uriRegexPattern,depiction,logo,competencyQuestion,usedBy,metadataVoc,
hasDisjunctionsWith,toDoList,example,preferredNamespaceUri,preferredNamespacePrefix,morePermissions,
useGuidelines,curatedOn,repository,bugDatabase,mailingList,exampleIdentifier,award,copyrightHolder,associatedMedia,
workTranslation,translationOfWork,includedInDataCatalog,uploadFilePath,diffFilePath,masterFileName,missingImports,
pullLocation,metrics,
{:contact=>[:name, :email], :ontology=>[:acronym, :name, :administeredBy, :group, 
:viewingRestriction, :doNotUpdate, :flat, :hasDomain, :summaryOnly, :acl, :viewOf, :ontologyType, :views],
 :submissionStatus=>[:code], :hasOntologyLanguage=>[:acronym]}}

With this SPARQL request

SELECT DISTINCT ?id ?submissionId ?prefLabelProperty ?definitionProperty ?synonymProperty ?authorProperty ?classType
 ?hierarchyProperty ?obsoleteProperty ?obsoleteParent ?homepage ?publication ?URI ?naturalLanguage ?documentation 
?version ?description ?status ?creationDate ?released ?numberOfClasses ?numberOfIndividuals ?numberOfProperties 
?maxDepth ?maxChildCount ?averageChildCount ?classesWithOneChild ?classesWithMoreThan25Children 
?classesWithNoDefinition ?modificationDate ?entities ?numberOfAxioms ?keyClasses ?keywords ?knownUsage ?notes 
?conformsToKnowledgeRepresentationParadigm ?hasContributor ?hasCreator ?designedForOntologyTask 
?wasGeneratedBy ?wasInvalidatedBy ?curatedBy ?endorsedBy ?fundedBy ?translator ?hasDomain ?hasFormalityLevel 
?hasLicense ?hasOntologySyntax ?isOfType ?usedOntologyEngineeringMethodology ?usedOntologyEngineeringTool 
?useImports ?hasPriorVersion ?isBackwardCompatibleWith ?isIncompatibleWith ?deprecated ?versionIRI 
?ontologyRelatedTo ?comesFromTheSameDomain ?similarTo ?isAlignedTo ?explanationEvolution ?generalizes 
?hasDisparateModelling ?hiddenLabel ?coverage ?publisher ?identifier ?source ?abstract ?alternative ?hasPart 
?isFormatOf ?hasFormat ?audience ?valid ?accrualMethod ?accrualPeriodicity ?accrualPolicy ?endpoint ?dataDump 
?csvDump ?openSearchDescription ?uriLookupEndpoint ?uriRegexPattern ?depiction ?logo ?competencyQuestion 
?usedBy ?metadataVoc ?hasDisjunctionsWith ?toDoList ?example ?preferredNamespaceUri ?preferredNamespacePrefix
 ?morePermissions ?useGuidelines ?curatedOn ?repository ?bugDatabase ?mailingList ?exampleIdentifier ?award 
?copyrightHolder ?associatedMedia ?workTranslation ?translationOfWork ?includedInDataCatalog ?uploadFilePath ?
diffFilePath ?masterFileName ?missingImports ?pullLocation ?metrics
 FROM <http://data.bioontology.org/metadata/OntologySubmission> 
WHERE { ?id a <http://data.bioontology.org/metadata/OntologySubmission> . OPTIONAL { 
id <http://data.bioontology.org/metadata/submissionId> ?submissionId .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/prefLabelProperty> ?prefLabelProperty .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/definitionProperty> ?definitionProperty .  }
 OPTIONAL { ?id <http://data.bioontology.org/metadata/synonymProperty> ?synonymProperty .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/authorProperty> ?authorProperty .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/classType> ?classType .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/hierarchyProperty> ?hierarchyProperty .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/obsoleteProperty> ?obsoleteProperty .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/obsoleteParent> ?obsoleteParent .  } 
OPTIONAL { ?id <http://xmlns.com/foaf/0.1/homepage> ?homepage .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/publication> ?publication .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#URI> ?URI .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#naturalLanguage> ?naturalLanguage .  }
 OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#documentation> ?documentation .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#version> ?version .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#description> ?description .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#status> ?status .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#creationDate> ?creationDate .  }
 OPTIONAL { ?id <http://data.bioontology.org/metadata/released> ?released .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#numberOfClasses> ?numberOfClasses .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#numberOfIndividuals> ?numberOfIndividuals .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#numberOfProperties> ?numberOfProperties .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/maxDepth> ?maxDepth .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/maxChildCount> ?maxChildCount .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/averageChildCount> ?averageChildCount .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/classesWithOneChild> ?classesWithOneChild .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/classesWithMoreThan25Children> ?classesWithMoreThan25Children .  }
 OPTIONAL { ?id <http://data.bioontology.org/metadata/classesWithNoDefinition> ?classesWithNoDefinition .  }
 OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#modificationDate> ?modificationDate .  } 
OPTIONAL { ?id <http://rdfs.org/ns/void#entities> ?entities .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#numberOfAxioms> ?numberOfAxioms .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#keyClasses> ?keyClasses .  }
 OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#keywords> ?keywords .  }
 OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#knownUsage> ?knownUsage .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#notes> ?notes .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#conformsToKnowledgeRepresentationParadigm> ?conformsToKnowledgeRepresentationParadigm .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#hasContributor> ?hasContributor .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#hasCreator> ?hasCreator .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#designedForOntologyTask> ?designedForOntologyTask .  } OPTIONAL { ?id <http://www.w3.org/ns/prov#wasGeneratedBy> ?wasGeneratedBy .  } 
OPTIONAL { ?id <http://www.w3.org/ns/prov#wasInvalidatedBy> ?wasInvalidatedBy .  } 
OPTIONAL { ?id <http://purl.org/pav/curatedBy> ?curatedBy .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#endorsedBy> ?endorsedBy .  } 
OPTIONAL { ?id <http://xmlns.com/foaf/0.1/fundedBy> ?fundedBy .  } 
OPTIONAL { ?id <http://schema.org/translator> ?translator .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#hasDomain> ?hasDomain .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#hasFormalityLevel> ?hasFormalityLevel .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#hasLicense> ?hasLicense .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#hasOntologySyntax> ?hasOntologySyntax .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#isOfType> ?isOfType .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#usedOntologyEngineeringMethodology> ?usedOntologyEngineeringMethodology .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#usedOntologyEngineeringTool> ?usedOntologyEngineeringTool .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#useImports> ?useImports .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#hasPriorVersion> ?hasPriorVersion .  } 
OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#isBackwardCompatibleWith> ?isBackwardCompatibleWith .  } OPTIONAL { ?id <http://omv.ontoware.org/2005/05/ontology#isIncompatibleWith> ?isIncompatibleWith .  }
 OPTIONAL { ?id <http://www.w3.org/2002/07/owl#deprecated> ?deprecated .  } 
OPTIONAL { ?id <http://www.w3.org/2002/07/owl#versionIRI> ?versionIRI .  } 
OPTIONAL { ?id <http://kannel.open.ac.uk/ontology#ontologyRelatedTo> ?ontologyRelatedTo .  } 
OPTIONAL { ?id <http://kannel.open.ac.uk/ontology#comesFromTheSameDomain> ?comesFromTheSameDomain .  } OPTIONAL { ?id <http://kannel.open.ac.uk/ontology#similarTo> ?similarTo .  } 
OPTIONAL { ?id <http://kannel.open.ac.uk/ontology#isAlignedTo> ?isAlignedTo .  } 
OPTIONAL { ?id <http://kannel.open.ac.uk/ontology#explanationEvolution> ?explanationEvolution .  } 
OPTIONAL { ?id <http://purl.org/vocommons/voaf#generalizes> ?generalizes .  } 
OPTIONAL { ?id <http://kannel.open.ac.uk/ontology#hasDisparateModelling> ?hasDisparateModelling .  } 
OPTIONAL { ?id <http://www.w3.org/2004/02/skos/core#hiddenLabel> ?hiddenLabel .  } 
OPTIONAL { ?id <http://purl.org/dc/terms/coverage> ?coverage .  } 
OPTIONAL { ?id <http://purl.org/dc/terms/publisher> ?publisher .  } 
OPTIONAL { ?id <http://purl.org/dc/terms/identifier> ?identifier .  } 
OPTIONAL { ?id <http://purl.org/dc/terms/source> ?source .  } 
OPTIONAL { ?id <http://purl.org/dc/terms/abstract> ?abstract .  } 
OPTIONAL { ?id <http://purl.org/dc/terms/alternative> ?alternative .  } 
OPTIONAL { ?id <http://purl.org/dc/terms/hasPart> ?hasPart .  } 
OPTIONAL { ?id <http://purl.org/dc/terms/isFormatOf> ?isFormatOf .  } 
OPTIONAL { ?id <http://purl.org/dc/terms/hasFormat> ?hasFormat .  } 
OPTIONAL { ?id <http://purl.org/dc/terms/audience> ?audience .  } 
OPTIONAL { ?id <http://purl.org/dc/terms/valid> ?valid .  } 
OPTIONAL { ?id <http://purl.org/dc/terms/accrualMethod> ?accrualMethod .  }
OPTIONAL { ?id <http://purl.org/dc/terms/accrualPeriodicity> ?accrualPeriodicity .  } 
OPTIONAL { ?id <http://purl.org/dc/terms/accrualPolicy> ?accrualPolicy .  } 
OPTIONAL { ?id <http://www.w3.org/ns/sparql-service-description#endpoint> ?endpoint .  } 
OPTIONAL { ?id <http://rdfs.org/ns/void#dataDump> ?dataDump .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/csvDump> ?csvDump .  } 
OPTIONAL { ?id <http://rdfs.org/ns/void#openSearchDescription> ?openSearchDescription .  } 
OPTIONAL { ?id <http://rdfs.org/ns/void#uriLookupEndpoint> ?uriLookupEndpoint .  } 
OPTIONAL { ?id <http://rdfs.org/ns/void#uriRegexPattern> ?uriRegexPattern .  } 
OPTIONAL { ?id <http://xmlns.com/foaf/0.1/depiction> ?depiction .  } 
OPTIONAL { ?id <http://xmlns.com/foaf/0.1/logo> ?logo .  } 
OPTIONAL { ?id <http://www.isibang.ac.in/ns/mod#competencyQuestion> ?competencyQuestion .  } 
OPTIONAL { ?id <http://purl.org/vocommons/voaf#usedBy> ?usedBy .  } 
OPTIONAL { ?id <http://purl.org/vocommons/voaf#metadataVoc> ?metadataVoc .  } 
OPTIONAL { ?id <http://purl.org/vocommons/voaf#hasDisjunctionsWith> ?hasDisjunctionsWith .  } 
OPTIONAL { ?id <http://purl.org/vocommons/voaf#toDoList> ?toDoList .  } 
OPTIONAL { ?id <http://purl.org/vocab/vann/example> ?example .  } 
OPTIONAL { ?id <http://purl.org/vocab/vann/preferredNamespaceUri> ?preferredNamespaceUri .  } 
OPTIONAL { ?id <http://purl.org/vocab/vann/preferredNamespacePrefix> ?preferredNamespacePrefix .  } 
OPTIONAL { ?id <http://creativecommons.org/ns#morePermissions> ?morePermissions .  } 
OPTIONAL { ?id <http://creativecommons.org/ns#useGuidelines> ?useGuidelines .  } 
OPTIONAL { ?id <http://purl.org/pav/curatedOn> ?curatedOn .  } 
OPTIONAL { ?id <http://usefulinc.com/ns/doap#repository> ?repository .  } 
OPTIONAL { ?id <http://usefulinc.com/ns/doap#bugDatabase> ?bugDatabase .  } 
OPTIONAL { ?id <http://usefulinc.com/ns/doap#mailingList> ?mailingList .  } 
OPTIONAL { ?id <http://identifiers.org/idot/exampleIdentifier> ?exampleIdentifier .  } 
OPTIONAL { ?id <http://schema.org/award> ?award .  } 
OPTIONAL { ?id <http://schema.org/copyrightHolder> ?copyrightHolder .  } 
OPTIONAL { ?id <http://schema.org/associatedMedia> ?associatedMedia .  } 
OPTIONAL { ?id <http://schema.org/workTranslation> ?workTranslation .  } 
OPTIONAL { ?id <http://schema.org/translationOfWork> ?translationOfWork .  } 
OPTIONAL { ?id <http://schema.org/includedInDataCatalog> ?includedInDataCatalog .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/uploadFilePath> ?uploadFilePath .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/diffFilePath> ?diffFilePath .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/masterFileName> ?masterFileName .  }
 OPTIONAL { ?id <http://data.bioontology.org/metadata/missingImports> ?missingImports .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/pullLocation> ?pullLocation .  } 
OPTIONAL { ?id <http://data.bioontology.org/metadata/metrics> ?metrics .  } 
FILTER(?id = <http://data.bioontology.org/ontologies/AGROVOC/submissions/24>)
 }
@syphax-bouazzouni syphax-bouazzouni added bug content Issues related to the content of AgroPortal labels May 18, 2022
@syphax-bouazzouni
Copy link
Contributor Author

Trying to reproduce it locally, the request took 24 minutes to respond.

May be caused by this ontoportal-lirmm/goo#3

@syphax-bouazzouni
Copy link
Contributor Author

Fixed with #289
image

Response time instantly

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug content Issues related to the content of AgroPortal
Projects
None yet
Development

No branches or pull requests

1 participant