Hi Marcelo,
Does the Virtuoso Server become unresponsive immediately the query is run ie
can u not run the "status('')" command at any point while it is running from a
separate isql session? Are you able to provide access to the Virtuoso instance to it can be accessed via the conductor or isql or provide the datasets (or database file) so we can recreate this problem in-house ? 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 8 Jan 2013, at 18:35, Marcelo Aliquintuy <[email protected]> wrote: > Hi. > Was my misstake, i didn't delete spaces preceding, now takes the parameter. > Virtuoso takes almost 3GB ram :) but continues my problem. I'm thinking the > issue is with accented characters in bif:search_excerpt, bif:vector because > if i execute without this functions works fine. > Only happens with queries that have results, if i try with españa works fine > because in my repo don't have literals with españa. I think the query execute > fine but when apply the bif:search_excerpt, bif:vector to the result set and > the key have accented characters that crash :(. > > Best Regards and Thanks for your replies. > > pd: status and top: > status before the query, after a can't execute: > SQL> status(''); > REPORT > VARCHAR > _______________________________________________________________________________ > > OpenLink Virtuoso Server > Version 06.01.3127-pthreads for Darwin as of Dec 13 2012 > Started on: 2013/01/08 15:21 GMT-180 > > Database Status: > File size 65011712, 7936 pages, 5647 free. > 340000 buffers, 579 used, 0 dirty 0 wired down, repl age 0 0 w. io 0 w/crsr. > Disk Usage: 594 reads avg 0 msec, 0% r 0% w last 25 s, 77 writes, > 17 read ahead, batch = 18. Autocompact 0 in 0 out, 0% saved. > Gate: 50 2nd in reads, 0 gate write waits, 0 in while read 0 busy scrap. > Log = > /Applications/dev/virtuoso-opensource-6.1.6/var/lib/virtuoso/db/virtuoso.trx, > 155 bytes > 1303 pages have been changed since last backup (in checkpoint state) > Current backup timestamp: 0x28D5-0x46-0xF4 > Last backup date: Fri Jan 4 15:55:35 2013 > > Clients: 1 connects, max 1 concurrent > RPC: 6 calls, 1 pending, 1 max until now, 0 queued, 0 burst reads (0%), 0 > second brk=9 > Checkpoint Remap 95 pages, 0 mapped back. 0 s atomic time. > DB master 7936 total 5647 free 95 remap 0 mapped back > temp 256 total 251 free > > Lock Status: 0 deadlocks of which 0 2r1w, 0 waits, > Currently 1 threads running 0 threads waiting 0 threads in vdb. > Pending: > > 24 Rows. -- 29 msec. > > > top: > PID COMMAND %CPU TIME #TH #WQ #POR #MREG RPRVT RSHRD RSIZE > VPRVT VSIZE PGRP PPID STATE UID FAULTS COW MSGSENT MSGRECV > SYSBSD SYSMACH CSW PAGEINS KPRVT > 8753 virtuoso-t 91.9 02:48.49 25/1 0 37 238 2838M 216K 2846M > 2874M 5249M 8753 1 running 501 728881 57 15 7 > 2056309 361 138010+ 1 5945K > > > -- > Marcelo Aliquintuy > 87433162 > > El domingo, 6 de enero de 2013 a las 19:57, David Brooks escribió: > >> Hmm, Virtuoso's sample INI file has spaces preceding parameter values and >> running with "NumberOfBuffers = 80000" certainly results in >> status() reporting 80000 buffers. >> >> Marcelo, is your Virtuoso somehow using a different configuration file to >> the one you think it is ?? >> >> >> Regards, >> Dave >> >> On 7/01/13 9:40 AM, Hugh Williams wrote: >>> Hi Marcelo, >>> >>> The status output still shows the buffers are set to the default of "2000", >>> see: >>> >>> 2000 buffers, 1274 used, >>> >>> Note there should not be an spaces preceding the parameter setting >>> otherwise they will not be picked up which seem to the case here, thus >>> please remove them, restart Virtuoso and check with the status command the >>> Buffers are indeed being set to 340000. >>> >>> 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 4 Jan 2013, at 19:42, Marcelo Aliquintuy <[email protected]> wrote: >>> >>>> Hi again, I followed your instructions to try fix the problem but >>>> I tuning virtuoso with: >>>> ;; Uncomment next two lines if there is 4 GB system memory free >>>> NumberOfBuffers = 340000 >>>> MaxDirtyBuffers = 250000 >>>> >>>> and upgrade to virtuoso 6.1.6 and i got the same problem: >>>> >>>> status() before to execute the query: >>>> SQL> status(); >>>> REPORT >>>> VARCHAR >>>> _______________________________________________________________________________ >>>> >>>> OpenLink Virtuoso Server >>>> Version 06.01.3127-pthreads for Darwin as of Dec 13 2012 >>>> Started on: 2013/01/04 16:26 GMT-180 >>>> >>>> Database Status: >>>> File size 65011712, 7936 pages, 5628 free. >>>> 2000 buffers, 1274 used, 0 dirty 0 wired down, repl age 748 0 w. io 0 >>>> w/crsr. >>>> Disk Usage: 1631 reads avg 0 msec, 0% r 0% w last 0 s, 1479 writes, >>>> 203 read ahead, batch = 3. Autocompact 138 in 104 out, 24% saved. >>>> Gate: 246 2nd in reads, 0 gate write waits, 0 in while read 0 busy scrap. >>>> Log = >>>> /Applications/dev/virtuoso-opensource-6.1.6/var/lib/virtuoso/db/virtuoso.trx, >>>> 155 bytes >>>> 1303 pages have been changed since last backup (in checkpoint state) >>>> Current backup timestamp: 0x28D5-0x46-0xF4 >>>> Last backup date: Fri Jan 4 15:55:35 2013 >>>> >>>> Clients: 1 connects, max 1 concurrent >>>> RPC: 4 calls, 1 pending, 1 max until now, 0 queued, 0 burst reads (0%), 0 >>>> second brk=9 >>>> Checkpoint Remap 114 pages, 0 mapped back. 1 s atomic time. >>>> DB master 7936 total 5628 free 114 remap 0 mapped back >>>> temp 256 total 251 free >>>> >>>> Lock Status: 0 deadlocks of which 0 2r1w, 0 waits, >>>> Currently 1 threads running 0 threads waiting 0 threads in vdb. >>>> Pending: >>>> >>>> Client 1111:1: Account: dba, 203 bytes in, 256 bytes out, 1 stmts. >>>> PID: 4443056536, OS: unix, Application: unknown, IP#: 127.0.0.1 >>>> Transaction status: PENDING, 1 threads. >>>> Locks: >>>> >>>> >>>> Running Statements: >>>> Time (msec) Text >>>> 141 status() >>>> >>>> >>>> Hash indexes >>>> >>>> >>>> 38 Rows. -- 141 msec. >>>> >>>> >>>> >>>> When try to run status() again after execute query thats doesnt response: >>>> SQL> status(); >>>> >>>> top status of virtuoso: >>>> PID COMMAND %CPU TIME #TH #WQ #POR #MREG RPRVT RSHRD >>>> RSIZE VPRVT VSIZE PGRP PPID STATE UID FAULTS COW MSGSENT >>>> MSGRECV SYSBSD SYSMACH CSW PAGEINS >>>> 87639 virtuoso-t 97.2 04:41.41 26/1 0 106 216 163M 244K >>>> 186M 196M 2580M 87639 1 running 501 47802 58 200 >>>> 89 4142614 1425 348460+ 40 >>>> >>>> Thanks and Best Regards!!! >>>> -- >>>> Marcelo Aliquintuy >>>> 87433162 >>>> >> > > ------------------------------------------------------------------------------ > Master SQL Server Development, Administration, T-SQL, SSAS, SSIS, SSRS > and more. Get SQL Server skills now (including 2012) with LearnDevNow - > 200+ hours of step-by-step video tutorials by Microsoft MVPs and experts. > SALE $99.99 this month only - learn more at: > http://p.sf.net/sfu/learnmore_122512_______________________________________________ > Virtuoso-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Master Visual Studio, SharePoint, SQL, ASP.NET, C# 2012, HTML5, CSS, MVC, Windows 8 Apps, JavaScript and much more. Keep your skills current with LearnDevNow - 3,200 step-by-step video tutorials by Microsoft MVPs and experts. SALE $99.99 this month only -- learn more at: http://p.sf.net/sfu/learnmore_122412
_______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
