Hi Sumit,
I would suggest updating your 07.10.3207 binary ( from Feb 2014 git stable/7
branch I presume) to the latest git develop/7 branch which contains all the
latest fixes up to last week as detailed at:
http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VOSGitUsage
to see if this resolves the problem ...
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 18 May 2014, at 02:44, "Purohit, Sumit" <sumit.puro...@pnnl.gov> wrote:
> 1. status of ttl file does changes from 0 to 2 when i use "select * from
> DB.DBA.load_list"
> 2. Most of the time it happens with smaller file. Recently it happened with a
> .ttl file with 1947 statements.
> 3. I have tried running "checkpoint" on isql command but that does not update
> the list.
> 4. status() has following output :
>
> SQL> status() ;
> Connected to OpenLink Virtuoso
> Driver: 07.10.3207 OpenLink Virtuoso ODBC Driver
> REPORT
> VARCHAR
> _______________________________________________________________________________
>
> OpenLink Virtuoso Server
> Version 07.10.3207-pthreads for Linux as of May 8 2014
> Started on: 2014-05-17 14:20 GMT-7
>
> Database Status:
> File size 0, 13442304 pages, 8066842 free.
> 4000000 buffers, 424609 used, 2 dirty 0 wired down, repl age 0 0 w. io 0
> w/crsr.
> Disk Usage: 425173 reads avg 0 msec, 0% r 0% w last 0 s, 4493 writes flush
> 48.08 MB,
> 1611 read ahead, batch = 262. Autocompact 29 in 20 out, 30% saved.
> Gate: 8871 2nd in reads, 0 gate write waits, 0 in while read 0 busy scrap.
> Log = /data1/DataStore/virtuoso/db/virtuoso.trx, 1287 bytes
> 5374891 pages have been changed since last backup (in checkpoint state)
> Current backup timestamp: 0x0000-0x00-0x00
> Last backup date: unknown
> Clients: 5 connects, max 1 concurrent
> RPC: 507 calls, -3 pending, 1 max until now, 0 queued, 2 burst reads (0%), 0
> second 0M large, 158M max
> Checkpoint Remap 361 pages, 0 mapped back. 3 s atomic time.
> DB master 13442304 total 8066842 free 361 remap 1 mapped back
> temp 256 total 251 free
>
> Lock Status: 0 deadlocks of which 0 2r1w, 7 waits,
> Currently 1 threads running 0 threads waiting 0 threads in vdb.
> Pending:
>
> Client 1111:5: Account: dba, 204 bytes in, 256 bytes out, 1 stmts.
> PID: 27728, OS: unix, Application: unknown, IP#: 127.0.0.1
> Transaction status: PENDING, 1 threads.
> Locks:
>
>
> Running Statements:
> Time (msec) Text
> 387 status()
>
>
> Hash indexes
>
>
> 37 Rows. -- 388 msec.
>
>
> thanks
> sumit
>
> From: Hugh Williams [hwilli...@openlinksw.com]
> Sent: Saturday, May 17, 2014 5:36 PM
> To: Purohit, Sumit
> Cc: virtuoso-users@lists.sourceforge.net
> Subject: Re: [Virtuoso-users] Graph List does not get updated after RDF load
>
> Hi Sumit,
>
> What is the version of Virtuoso being used:
>
> ./virtuoso-t -?
>
> What are the datasets being load and the expected triple count ?
>
> What does the output of running the Virtuoso status command run from isql
> report ?
>
> When you complete the loading of the data is a "checkpoint" run to ensure
> that is committed to the database ?
>
> Does the "load_list" table indicate that all the datasets where loaded
> successfully ?
>
> 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/OpenLinkGoogle+ --
> http://plus.google.com/100570109519069333827/Facebook --
> http://www.facebook.com/OpenLinkSoftware
> Universal Data Access, Integration, and Management Technology Providers
>
> On 17 May 2014, at 23:07, "Purohit, Sumit" <sumit.puro...@pnnl.gov> wrote:
>
>> Hi,
>>
>> I have observed many times after loading rdf data into a named graph using
>> ld_dir() or ld_dir_all(), updated list of graph does show up either on
>> conductor->linked data-> Graphs or using query like
>>
>> SELECT DISTINCT ?g
>> WHERE {
>> GRAPH ?g {
>> ?s ?p ?o
>> }
>> }
>>
>> Behavior is quite random and sometime a system restart + reloading data
>> again fix the issue. But other times i am clueless about how to fix it. Few
>> tricks i use are
>> 1. change location of data load directory
>> 2. change file name(s)
>>
>>
>> Recently i also observed that although graph list does not get updated but
>> data load is successful. Simple query like
>> "select ?s ?p ?o from <mygraph> where { ?s ?p ?o}" lists all the expected
>> triples.
>>
>>
>> 1. Has anyone else experienced this?
>> 2. Is it because of some internal virtuoso caching/bulk update policy which
>> i am not aware of and perceiving it as an issue when there is none.
>>
>> Thanks
>> Sumit Purohit
>>
>> ------------------------------------------------------------------------------
>> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
>> Instantly run your Selenium tests across 300+ browser/OS combos.
>> Get unparalleled scalability from the best Selenium testing platform
>> available
>> Simple to use. Nothing to install. Get started now for free."
>> http://p.sf.net/sfu/SauceLabs_______________________________________________
>> Virtuoso-users mailing list
>> Virtuoso-users@lists.sourceforge.net
>> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
>
> ------------------------------------------------------------------------------
> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
> Instantly run your Selenium tests across 300+ browser/OS combos.
> Get unparalleled scalability from the best Selenium testing platform available
> Simple to use. Nothing to install. Get started now for free."
> http://p.sf.net/sfu/SauceLabs_______________________________________________
> Virtuoso-users mailing list
> Virtuoso-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users