Hi Andy, What is a typical query being executing that is result in a HTTP error and what is the actual error ?
When the error occurs what is the status of the server at that point , please
provide the output of running the command:
status();
Are any errors reported in the “virtuoos.log” file, please provide a copy for
review ?
You indicate having a 128GB RAM machine but memory allocated to Virtuoso is
that for a 16GB RAM machine ie NumberOfBuffer = 1360000 in the INI file, was
there a specific reason for this ?
How many triples are hosted in the Virtuoso instance , please provide the
output of the count query:
select count(*) where {?s ?p ?o}
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 20 Feb 2016, at 15:47, Nolle, Andreas <[email protected]> wrote:
>
> Hi folks,
>
> I’ve set up four Virtuoso instances (Version 7.2.2.3215) on an Ubuntu 14.04.4
> LTS server with 12 cores and 128 GB memory.
> If I run several (federated) queries in parallel (maximal 16 at a time),
> where some of the queries may take several minutes, it may happened that a
> SPARQL endpoint return some HTTP error. If I rerun the same query some
> seconds later, it will ordinarily be evaluated correct and the requested
> results are returned.
> I’ve already tried to solve this infrequent issue but without any success.
> Can you please give me some recommendations?
> Maybe my configuration may comprise some not well-chosen parameter?
>
>
> Please find below my virtuoso.ini:
>
> [Database]
> DatabaseFile = ../var/lib/virtuoso/db/virtuoso.db
> ErrorLogFile = ../var/lib/virtuoso/db/virtuoso.log
> LockFile = ../var/lib/virtuoso/db/virtuoso.lck
> TransactionFile = ../var/lib/virtuoso/db/virtuoso.trx
> xa_persistent_file = ../var/lib/virtuoso/db/virtuoso.pxa
> ErrorLogLevel = 7
> FileExtend = 200
> MaxCheckpointRemap = 150000
> Striping = 0
> TempStorage = TempDatabase
>
> [TempDatabase]
> DatabaseFile = ../var/lib/virtuoso/db/virtuoso-temp.db
> TransactionFile = ../var/lib/virtuoso/db/virtuoso-temp.trx
> MaxCheckpointRemap = 9000
> Striping = 0
>
> [Parameters]
> ServerPort = 1112
> LiteMode = 0
> DisableUnixSocket = 1
> DisableTcpSocket = 0
> MaxClientConnections = 10000
> ServerThreads = 1000
> CheckpointInterval = 60
> O_DIRECT = 0
> CaseMode = 2
> MaxStaticCursorRows = 5000
> CheckpointAuditTrail = 0
> AllowOSCalls = 0
> SchedulerInterval = 10
> DirsAllowed = ., ../share/virtuoso/vad,../saleem/dumps,
> /opt/benchset/bibsonomy
> ThreadCleanupInterval = 1
> ThreadThreshold = 1000
> ResourcesCleanupInterval = 1
> FreeTextBatchSize = 100000
> SingleCPU = 0
> VADInstallDir = ../share/virtuoso/vad/
> PrefixResultNames = 0
> RdfFreeTextRulesSize = 100
> IndexTreeMaps = 512
> MaxMemPoolSize = 200000000
> PrefixResultNames = 0
> MacSpotlight = 0
> MaxQueryMem = 8G ; memory allocated to query processor
> VectorSize = 1000 ; initial parallel query vector
> (array of query operations) size
> MaxVectorSize = 2000000 ; query vector size threshold.
> AdjustVectorSize = 0
> ThreadsPerQuery = 24
> AsyncQueueMaxThreads = 36
> NumberOfBuffers = 1360000
> MaxDirtyBuffers = 1000000
> TraceOn = errors
> CallstackOnException = 1
> MaxSortedTopRows = 10000000
> DefaultIsolation = 2
>
> [HTTPServer]
> ServerPort = 8891
> ServerRoot = ../var/lib/virtuoso/vsp
> MaxClientConnections = 10000
> DavRoot = DAV
> EnabledDavVSP = 0
> HTTPProxyEnabled = 0
> TempASPXDir = 0
> DefaultMailServer = localhost:25
> ServerThreads = 1000
> MaxKeepAlives = 100
> KeepAliveTimeout = 10
> MaxCachedProxyConnections = 10
> ProxyConnectionCacheTimeout = 15
> HTTPThreadSize = 280000
> HttpPrintWarningsInOutput = 0
> Charset = UTF-8
> MaintenancePage = atomic.html
> EnabledGzipContent = 1
>
> [AutoRepair]
> BadParentLinks = 0
>
> [Client]
> SQL_PREFETCH_ROWS = 100
> SQL_PREFETCH_BYTES = 16000
> SQL_QUERY_TIMEOUT = 0
> SQL_TXN_TIMEOUT = 0
>
> [VDB]
> ArrayOptimization = 0
> NumArrayParameters = 10
> VDBDisconnectTimeout = 1000
> KeepConnectionOnFixedThread = 0
>
> [Replication]
> ServerName = db-AKSWDESKTOP
> ServerEnable = 1
> QueueMax = 50000
>
> [Striping]
> Segment1 = 8G, db-seg1-1.db, db-seg1-2.db
> Segment2 = 8G, db-seg2-1.db, db-seg2-2.db
>
> [Zero Config]
> ServerName = virtuoso (AKSWDESKTOP)
>
> [Mono]
>
> [URIQA]
> DynamicLocal = 0
> DefaultHost = localhost:8890
>
> [SPARQL]
> DefaultGraph = http://test.hs-albsig.de/benchset
> <http://test.hs-albsig.de/benchset>
> ResultSetMaxRows = 10000000
> DefaultQuery = select distinct ?Concept where {[] a ?Concept}
> LIMIT 100
> DeferInferenceRulesInit = 0 ; controls inference rules loading
>
> [Plugins]
> LoadPath = ../lib/virtuoso/hosting
>
>
> Best regards
> Andy Nolle
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140_______________________________________________
>
> <http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140_______________________________________________>
> 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>
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
