{"@context":{"rdf":"http://www.w3.org/1999/02/22-rdf-syntax-ns#","rdfs":"http://www.w3.org/2000/01/rdf-schema#","owl":"http://www.w3.org/2002/07/owl#","foaf":"http://xmlns.com/foaf/0.1/","dc":"http://purl.org/dc/elements/1.1/","dct":"http://purl.org/dc/terms/","sioc":"http://rdfs.org/sioc/types#","blog":"http://vocab.amy.so/blog#","as":"https://www.w3.org/ns/activitystreams#","mf2":"http://microformats.org/profile/","ldp":"http://www.w3.org/ns/ldp#","solid":"http://www.w3.org/ns/solid#","view":"https://terms.rhiaro.co.uk/view#","asext":"https://terms.rhiaro.co.uk/as#","dbp":"http://dbpedia.org/property/","geo":"http://www.w3.org/2003/01/geo/wgs84_pos#","doap":"http://usefulinc.com/ns/doap#","time":"http://www.w3.org/2006/time#"},"@graph":[{"@id":"https://rhiaro.co.uk/2014/05/","@type":["as:Collection","ldp:Container"],"ldp:contains":[{"@id":"https://rhiaro.co.uk/2014/05/arc2-sparql"},{"@id":"https://rhiaro.co.uk/2014/05/5874ab6a30d80"},{"@id":"https://rhiaro.co.uk/2014/05/5874ab6a30e18"},{"@id":"https://rhiaro.co.uk/2014/05/5874ab6a311d6"}],"as:name":"Posts between 2014/05 and 2014/06","as:totalItems":{"@type":"http://www.w3.org/2001/XMLSchema#nonNegativeInteger","@value":"4"}},{"@id":"https://rhiaro.co.uk/2014/05/5874ab6a30d80","@type":"as:Add","as:actor":{"@id":"https://rhiaro.co.uk/#me"},"as:object":{"@id":"http://livingarchive.inn.ac/"},"as:published":{"@type":"http://www.w3.org/2001/XMLSchema#dateTime","@value":"2014-05-04T10:29:35+00:00"},"as:summary":"Amy added 'Living Archive - A search engine for Open Data' to Bookmarks","as:target":{"@id":"https://rhiaro.co.uk/bookmarks/"}},{"@id":"https://rhiaro.co.uk/2014/05/5874ab6a30e18","@type":"as:Add","as:actor":{"@id":"https://rhiaro.co.uk/#me"},"as:object":{"@id":"http://linter.structured-data.org/"},"as:published":{"@type":"http://www.w3.org/2001/XMLSchema#dateTime","@value":"2014-05-06T16:05:21+00:00"},"as:summary":"Amy added 'Structured Data Linter' to Bookmarks","as:target":{"@id":"https://rhiaro.co.uk/bookmarks/"}},{"@id":"https://rhiaro.co.uk/2014/05/5874ab6a311d6","@type":"as:Add","as:actor":{"@id":"https://rhiaro.co.uk/#me"},"as:object":{"@id":"https://tom-christie.github.io/articles/correlation/"},"as:published":{"@type":"http://www.w3.org/2001/XMLSchema#dateTime","@value":"2014-05-25T07:19:43+00:00"},"as:summary":"Amy added 'Spurious correlations: I'm looking at you, internet. u2013 Tom Christie' to Bookmarks","as:target":{"@id":"https://rhiaro.co.uk/bookmarks/"}},{"@id":"https://rhiaro.co.uk/2014/05/?before=https://rhiaro.co.uk/2014/05/arc2-sparql&limit=16","@type":["as:CollectionPage","ldp:Container"],"ldp:contains":[{"@id":"https://rhiaro.co.uk/2014/05/arc2-sparql"},{"@id":"https://rhiaro.co.uk/2014/05/5874ab6a30d80"},{"@id":"https://rhiaro.co.uk/2014/05/5874ab6a30e18"},{"@id":"https://rhiaro.co.uk/2014/05/5874ab6a311d6"}],"as:items":[{"@id":"https://rhiaro.co.uk/2014/05/arc2-sparql"},{"@id":"https://rhiaro.co.uk/2014/05/5874ab6a30d80"},{"@id":"https://rhiaro.co.uk/2014/05/5874ab6a30e18"},{"@id":"https://rhiaro.co.uk/2014/05/5874ab6a311d6"}],"as:name":"Posts between 2014/05 and 2014/06","as:next":{"@id":"https://rhiaro.co.uk/2014/06/"},"as:partOf":{"@id":"https://rhiaro.co.uk/2014/05/"},"as:prev":{"@id":"https://rhiaro.co.uk/2014/04/"}},{"@id":"https://rhiaro.co.uk/2014/05/arc2-sparql","@type":"as:Article","as:actor":{"@id":"https://rhiaro.co.uk/about#me"},"as:content":"
So Slog'd got stuck for a little while because the fast, nice-looking, somewhat magical SPARQL endpoint provided by ARC2 stopped working for no discernable reason.
\r\nI thought I'd try leaving it alone for a few weeks to see if it started working again by itself, but alas, it has not.
\r\nEverything is fine until I try to query for a specific predicate. (Specific objects or subjects are fine). The query runs, it just returns no results. I know the data is in there, because I can get it out with less specific queries. Also because I can see it all in the MySQL database on which it is based. When I left it, it was working fine.
\r\nI'm going to kill the database and set it up again.
\r\nI did this by - and oh, it was joyous - going into the database settings and appending '2' to the name of the database. I then reloaded the endpoint page, and it set everything up by itself :)
\r\nI inserted two triples, and successfully queried for a specific prefix. So, it works. I wonder what will happen if I dump all my old data back in there? (I validated the raw file with all the triples in RDF/XML, and they're fine).
\r\nI inserted the rest the rest: LOAD <path/to/rdf.rdf> INTO <>
Ran a test query, aaaand... it's fine.
\r\nSo what the hell was wrong with my other database? Perhaps I'll never know...
","as:name":"ARC2 SPARQL Endpoint","as:published":{"@type":"http://www.w3.org/2001/XMLSchema#datetime","@value":"2014-05-01T19:38:00+0000"},"as:tag":[{"@id":"https://rhiaro.co.uk/tags/doing"},{"@id":"blog:Doing"},{"@id":"https://rhiaro.co.uk/tags/arc2"},{"@id":"https://rhiaro.co.uk/tags/blog"},{"@id":"https://rhiaro.co.uk/tags/hacking"},{"@id":"https://rhiaro.co.uk/tags/learning"},{"@id":"https://rhiaro.co.uk/tags/rdf"},{"@id":"https://rhiaro.co.uk/tags/semantic+web"},{"@id":"https://rhiaro.co.uk/tags/slogd"},{"@id":"https://rhiaro.co.uk/tags/sparql"},{"@id":"https://rhiaro.co.uk/tags/triplestores"}]}]}