spatial index recreated on reastart

1 view
Skip to first unread message

s.ar...@geophy.com

unread,
Dec 13, 2016, 9:20:44 AM12/13/16
to Stardog

Why  stardog recreate the spatial index every time I restarted it ?


How can I avoid this to happen?

#STARDOG/bin/stardog-admin server stop
samur@samur-XPS-15-9550:~/tools/stardog-data/sparql-queries$ $STARDOG/bin/stardog-admin server stop
Stardog server successfully received the shutdown request.
samur@samur-XPS-15-9550:~/tools/stardog-data/sparql-queries$ $STARDOG/bin/stardog-admin server start
Building Spatial Index: 0% complete in 00:00:14 (0.0K features/sec)
Building Spatial Index: 1% complete in 00:00:20 (5.4K features/sec)
Building Spatial Index: 2% complete in 00:00:22 (9.7K features/sec)
Building Spatial Index: 3% complete in 00:00:24 (13.4K features/sec)
Building Spatial Index: 4% complete in 00:00:25 (17.0K features/sec)
Building Spatial Index: 6% complete in 00:00:35 (18.4K features/sec)
Building Spatial Index: 7% complete in 00:00:39 (19.5K features/sec)
Building Spatial Index: 9% complete in 00:00:41 (23.7K features/sec)
Building Spatial Index: 10% complete in 00:00:42 (25.6K features/sec)

Stephen Nowell

unread,
Dec 13, 2016, 11:21:18 AM12/13/16
to sta...@clarkparsia.com
Hi Samur,

Which version of Stardog are you running? How big is your spatial database?

-Stephen
> --
> -- --
> You received this message because you are subscribed to the C&P
> "Stardog" group.
> To post to this group, send email to sta...@clarkparsia.com
> To unsubscribe from this group, send email to
> stardog+u...@clarkparsia.com
> For more options, visit this group at
> http://groups.google.com/a/clarkparsia.com/group/stardog?hl=en

Samur Araujo

unread,
Dec 13, 2016, 12:10:36 PM12/13/16
to sta...@clarkparsia.com
Version 4.2.1 

The database has 170 million triples. 
It happened after  I added more triples to the database using SPARUL insert.

--
-- --
You received this message because you are subscribed to the C&P "Stardog" group.
To post to this group, send email to sta...@clarkparsia.com
To unsubscribe from this group, send email to
--- You received this message because you are subscribed to a topic in the Google Groups "Stardog" group.
To unsubscribe from this topic, visit https://groups.google.com/a/clarkparsia.com/d/topic/stardog/v-Y3o89SrpE/unsubscribe.
To unsubscribe from this group and all its topics, send an email to stardog+unsubscribe@clarkparsia.com.




--
Senior Data Scientist 
Geophy 

Nieuwe Plantage 54-55
2611XK  Delft
+31 (0)70 7640725 

1 Fore Street
EC2Y 9DT  London
+44 (0)20 37690760

Reply all
Reply to author
Forward
0 new messages