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/OpenLink
Google+ -- 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<mailto: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<mailto: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
