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