Hi Hugh,
I shutdown virtuoso and deleted the database and re-ran the upload
with 8 loaders the same way I did. Low and behold, the problem
re-occurred the same way. Here is your status() below. I also checked
top and virtuoso-t is at 100% at the moment. I'm not going to restart
the server right since I need to go out for a bit. I will check to see
if it corrects itself without the restart. I will let you know. - Erich
SQL> status();
REPORT
VARCHAR
_______________________________________________________________________________
OpenLink Virtuoso Server
Version 07.00.3203-pthreads for Linux as of Sep 17 2013
Started on: 2013-09-22 18:19 GMT+0
Database Status:
File size 9227468800, 1126400 pages, 304678 free.
5450000 buffers, 821582 used, 819838 dirty 11 wired down, repl age 0
0 w. io 1 w/crsr.
Disk Usage: 60 reads avg 0 msec, 0% r 0% w last 583 s, 2158 writes,
0 read ahead, batch = 0. Autocompact 290 in 213 out, 26% saved.
Gate: 0 2nd in reads, 0 gate write waits, 0 in while read 0 busy scrap.
Log = /mnt/link/disk1/virtuoso-7.0.0/var/lib/virtuoso/db/virtuoso.trx,
21437 bytes
1796 pages have been changed since last backup (in checkpoint state)
Current backup timestamp: 0x0000-0x00-0x00
Last backup date: unknown
Clients: 10 connects, max 9 concurrent
RPC: 40 calls, -2 pending, 7 max until now, 0 queued, 21 burst reads
(52%), 0 second 143M large, 2168M max
Checkpoint Remap 38 pages, 0 mapped back. 3 s atomic time.
DB master 1126400 total 304678 free 38 remap 7 mapped back
temp 256 total 251 free
Lock Status: 0 deadlocks of which 0 2r1w, 3169 waits,
Currently 2 threads running 0 threads waiting 0 threads in vdb.
Pending:
820: IER 68.195.227.26
1: IER 68.195.227.26
101: ISR 68.195.227.26
1: ISR NO OWNER
2: ISR NO OWNER
20395: ISR 68.195.227.26
115: ISR NO OWNER
Client 1111:2: Account: dba, 357 bytes in, 325 bytes out, 1 stmts.
PID: 31218, OS: unix, Application: unknown, IP#: 127.0.0.1
Transaction status: PENDING, 1 threads.
Locks:
Running Statements:
Time (msec) Text
169 status()
Hash indexes
44 Rows. -- 170 msec.
SQL>
- Erich
On 09/22/13 8:32 AM, Hugh Williams wrote:
Hi Erich,
Is this condition reproducible as a restart of the server seems to
have resolved it ? As it would be interesting to see what the
"status();" command reports as to the status of the Virtuoso server
when in this state ...
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 22 Sep 2013, at 05:32, Erich Bremer <er...@ebremer.com
<mailto:er...@ebremer.com>> wrote:
Hi all,
I'm working with Virtuoso 7.0.0 open source edition and did a load of
geonames data using isql which was 123,020,822 triples into a named
graph "http://www.geonames.org";.
I did a second load of 13,349,346 triples into a different named graph.
Both loads of turtle RDF completed quickly. When I went to check to see
if Conductor could see the named graphs, Conductor hung when I clicked
on Linked Data-->Graphs. I then tried to do:
a) select distinct ?g where {graph ?g {?s ?p ?o}}
from the SPARQL endpoint and it timed out.
however, the following query against http://www.geonames.org would work
in a second:
b) select count(*) as ?cc where {?s ?p ?o}
I initiated a shutdown using isql which took a few moments and then I
restarted virtuoso. Now, Conductor quickly shows all named graphs
including the new ones, and the above SPARQL query (a) runs nearly
instantly.
- Erich
------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8,
SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack
includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13.
http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
------------------------------------------------------------------------------
LIMITED TIME SALE - Full Year of Microsoft Training For Just $49.99!
1,500+ hours of tutorials including VisualStudio 2012, Windows 8, SharePoint
2013, SQL 2012, MVC 4, more. BEST VALUE: New Multi-Library Power Pack includes
Mobile, Cloud, Java, and UX Design. Lowest price ever! Ends 9/22/13.
http://pubads.g.doubleclick.net/gampad/clk?id=64545871&iu=/4140/ostg.clktrk
_______________________________________________
Virtuoso-users mailing list
Virtuoso-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/virtuoso-users
