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] 
> > (mailto:[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

Reply via email to