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

Attachment: 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

Reply via email to