{"@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#"},"@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"}]}