Hi Ward, Correction. The error is compile-time, you need to increase MaxMemPoolSize parameter in the [Parameters] section of your virtuoso.ini file. This is maximum allowed amount of memory SQL optimizer can temporarily occupy. I set it to 1000000000, for approx 1 gigabyte, on a box with 4Gb RAM, having 2Gb for buffers. Unlike buffers taht are in use continuously, this gigabyte is usually occupied only for few seconds so you can set the amount in 'aggressive' style.
Best Regards, Ivan Mikhailov, OpenLink Software. On Thu, 2008-02-21 at 15:46 +0000, Hugh Williams wrote: > Hi Ward > > Are you sure this worked with a previous version and if so which version. > Might the size of the result set increased since then ? > > You can increased the available memory pool size by increasing the following > params in the [Parameters] section of your virtuoso.ini file: > > NumberOfBuffers = 300000 > MaxDirtyBuffers = 240000 > MaxCheckpointRemap = 300000 > > As detailed at: > > http://docs.openlinksw.com/virtuoso/dbadm.html#ini_Parameters > > I would suggest doubling them to start off with and increase accordingly > until the query runs. > > Best Regards, > Hugh Williams > Professional Services > OpenLink Software > Web: http://www.openlinksw.com > Universal Data Access & Data Integration Technology Providers > > > On 21/02/2008 14:33, "Ward Blondé" <wa...@psb.ugent.be> wrote: > > > > > > > Hello, > > > > In VOS 5.0.5 I tried the following query: > > > > prefix rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#> > > prefix > > uri001:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_C0000043> > > prefix uri002:<http://www.cellcycleontology.org/ontology/rdf/CCO#Definition> > > prefix > > uri003:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_C0000446> > > prefix uri004:<http://www.cellcycleontology.org/ontology/rdf/CCO#Definition> > > prefix > > uri005:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_C0000505> > > prefix uri006:<http://www.cellcycleontology.org/ontology/rdf/CCO#Definition> > > prefix > > uri007:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_C0000793> > > prefix uri008:<http://www.w3.org/2000/01/rdf-schema#comment> > > prefix > > uri009:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_C0001883> > > prefix uri010:<http://www.cellcycleontology.org/ontology/rdf/CCO#Definition> > > prefix > > uri011:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_C0001980> > > prefix uri012:<http://www.cellcycleontology.org/ontology/rdf/CCO#Definition> > > prefix > > uri013:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_C0002040> > > prefix uri014:<http://www.cellcycleontology.org/ontology/rdf/CCO#Definition> > > prefix > > uri015:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_P0000103> > > prefix uri016:<http://www.cellcycleontology.org/ontology/rdf/CCO#Definition> > > prefix > > uri017:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_P0000103> > > prefix uri018:<http://www.cellcycleontology.org/ontology/rdf/CCO#synonym> > > prefix > > uri019:<http://www.cellcycleontology.org/ontology/rdf/CCO#CCO_P0000103> > > prefix uri020:<http://www.cellcycleontology.org/ontology/rdf/CCO#synonym> > > select * > > from <http://www.cellcycleontology.org/ontology/rdf/CCO> > > where { > > optional{uri001: rdf:type ?type001}. > > optional{uri002: rdf:type ?type002}. > > optional{uri003: rdf:type ?type003}. > > optional{uri004: rdf:type ?type004}. > > optional{uri005: rdf:type ?type005}. > > optional{uri006: rdf:type ?type006}. > > optional{uri007: rdf:type ?type007}. > > optional{uri008: rdf:type ?type008}. > > optional{uri009: rdf:type ?type009}. > > optional{uri010: rdf:type ?type010}. > > optional{uri011: rdf:type ?type011}. > > optional{uri012: rdf:type ?type012}. > > optional{uri013: rdf:type ?type013}. > > optional{uri014: rdf:type ?type014}. > > optional{uri015: rdf:type ?type015}. > > optional{uri016: rdf:type ?type016}. > > optional{uri017: rdf:type ?type017}. > > optional{uri018: rdf:type ?type018}. > > optional{uri019: rdf:type ?type019}. > > optional{uri020: rdf:type ?type020}. > > } > > > > The aim is to post-process the answer of any other random query > > programmatically, and to look what are the types of the uri's. But I get > > this error-message: > > ..... Error SQ200: The memory pool size 10495344 reached the limit > > 10485760 bytes, try to increase the MaxMemPoolSize ini setting. > > > > Is it because I used to many prefixes? I thought this query worked > > before the change to 5.0.5. It still seems to work with less uri's. > > > > thanks, > > > > Ward > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by: Microsoft > > Defy all challenges. Microsoft(R) Visual Studio 2008. > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > _______________________________________________ > > Virtuoso-users mailing list > > Virtuoso-users@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/virtuoso-users > > > > > > > ------------------------------------------------------------------------- > This SF.net email is sponsored by: Microsoft > Defy all challenges. Microsoft(R) Visual Studio 2008. > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
