Re: [Virtuoso-users] Virtuoso 6 problematic background activity

On Mon, Nov 2, 2009 at 10:47, Tim Haynes wrote: > And another trick to bear in mind: isql -D. Thanks Tim, I didn't know about that one — I've found the documentation now (http://docs.openlinksw.com/virtuoso/pldebugger.html) but it might be worth mentioning that the option -D enters the debugger

Re: [Virtuoso-users] Virtuoso 6 problematic background activity

James Marsh wrote: Hi Hugh, On Tue, Oct 27, 2009 at 15:33, Hugh Williams > wrote: Can you please provide a copy of your Virtuoso Configuration file (virtuoso.ini) and Virtuoso log file (virtuoso.log) for review. The log shows nothing unusual - the

Re: [Virtuoso-users] Virtuoso 6 problematic background activity

Hi Hugh, On Tue, Oct 27, 2009 at 15:33, Hugh Williams wrote: > Can you please provide a copy of your Virtuoso Configuration file > (virtuoso.ini) and Virtuoso log file (virtuoso.log) for review. > The log shows nothing unusual - the usual startup/roll forward and then nothing but checkpoints. I'

Re: [Virtuoso-users] Virtuoso 6 problematic background activity

Hi James Can you please provide a copy of your Virtuoso Configuration file (virtuoso.ini) and Virtuoso log file (virtuoso.log) for review. Also, can you please clarifiy if: 1. This problem has only started occurring since your upgrade to the new 6.0.0 release as it seems unclear from you

Re: [Virtuoso-users] Virtuoso 6 problematic background activity

On Mon, Oct 26, 2009 at 18:42, Hugh Williams wrote: > Indicating their are 5 deadlocks in the database. Can you try running the > following command form the isql command line too to try and forcibly kill > and release all transactions and locks: > > txn_killall(); > > As detailed at: > > http://do

Re: [Virtuoso-users] Virtuoso 6 problematic background activity

Hi James, Looking at your status output I see: Clients: 143 connects, max 5 concurrent RPC: 2032 calls, -246 pending, 1 max until now, 0 queued, 0 burst reads (0%), 9 second brk=548294656 Checkpoint Remap 278243 pages, 0 mapped back. 2176 s atomic time. DB master 12523008 total 4875616 f

[Virtuoso-users] Virtuoso 6 problematic background activity

Using virtuoso 6-TP1, several weeks ago, I imported approx 500,000,000 triples from several bio2rdf graphs and built the additional bitmap indices RDF_QUAD_GPOS, RDF_QUAD_OGPS, RDF_QUAD_OPGS, RDF_QUAD_POGS I also created a free text index using: DB.DBA.RDF_OBJ_FT_RULE_ADD(NULL, NULL, 'bio-ft-inde