Steve,

Thanks for the speedy response. I updated MySQL using 

yum install myql

and I now have 4.1.20 running on my Fedora Core 4 box, and 3store3 works like a charm. I was contemplating a nasty kludge to get around this, but mercifully this isn't necessary.

Thanks again for a really useful tool.

Regards

Rod

On 13 Mar 2007, at 09:20, Steve Harris wrote:


On 13 Mar 2007, at 07:55, Roderic Page wrote:

Hi, I'm running 3store3 3.0.15 with redland 1.0.5 and MySQL 4.1.11 on
Fedora Core 4. Everything built OK, but any SPARQL query of the form

?s predicate ?o breaks with a MySQL error complaining about loosing a
connection. I get this via the PHP web interface, or with ts-query.
However, if I use the actual MySQL: SQL query, it's fine. For example,
here's the output from a simple SPARQL query processed with ts-explain

I think there was a bug in some versions of MySQL 4 that caused it to crash when presented with some queries. Try upgrading to the latest MySQL available in FC4, or try a newer MySQL from another source.

- Steve

---------------------
[rpage@r6-page 3store3-3.0.15]$ ts-explain "PREFIX dc:
<http://purl.org/dc/elements/1.1/> SELECT DISTINCT ?s  ?o WHERE { ?s
dc:title ?o . } LIMIT 10"
SQL error 2013: Lost connection to MySQL server during query
at util.c:55
SQL error 2002: Can't connect to local MySQL server through socket
'/var/lib/mysql/mysql.sock' (111)
at query.c:316
Warning cannot calculate complexity
Complexity: 0
SELECT DISTINCT v0.lexical AS `s`, v1.lexical AS `o`, v1.datatype AS
o_dt, v1.language AS o_lang
FROM (SELECT DISTINCT t0.object AS `o`, t0.subject AS `s`
FROM triples t0
WHERE t0.predicate=-8024650864867163606

LIMIT 10) AS `tmp0_202a`, symbols v0, symbols v1
WHERE tmp0_202a.s=v0.hash && tmp0_202a.o=v1.hash

LIMIT 10;
-----------------------

For some reason 3store3 looses the connection with MySQL, but this
doesn't happen for queries such as :

SELECT DISTINCT ?s ?p  ?o
WHERE
{
    ?s ?p ?o .
}
LIMIT 10

Has anybody come across something this before?

Regards

Rod

------------------------------------------------------------------------
----------------------------------------
Professor Roderic D. M. Page
Editor, Systematic Biology
DEEB, IBLS
Graham Kerr Building
University of Glasgow
Glasgow G12 8QP
United Kingdom

Phone:    +44 141 330 4778
Fax:      +44 141 330 2792
email:    r.page@bio.gla.ac.uk
web:      http://taxonomy.zoology.gla.ac.uk/rod/rod.html
iChat:    aim://rodpage1962
reprints: http://taxonomy.zoology.gla.ac.uk/rod/pubs.html

Subscribe to Systematic Biology through the Society of Systematic
Biologists Website:  http://systematicbiology.org
Search for taxon names: http://darwin.zoology.gla.ac.uk/~rpage/portal/
Find out what we know about a species: http://ispecies.org
Rod's rants on phyloinformatics: http://iphylo.blogspot.com
Rod's rants on ants: http://semant.blogspot.com


-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
threestore-devel mailing list
threestore-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/threestore-devel



----------------------------------------
Professor Roderic D. M. Page
Editor, Systematic Biology
DEEB, IBLS
Graham Kerr Building
University of Glasgow
Glasgow G12 8QP
United Kingdom

Phone: +44 141 330 4778
Fax: +44 141 330 2792
email: r.page@bio.gla.ac.uk
web: http://taxonomy.zoology.gla.ac.uk/rod/rod.html
iChat: aim://rodpage1962
reprints: http://taxonomy.zoology.gla.ac.uk/rod/pubs.html

Subscribe to Systematic Biology through the Society of Systematic
Biologists Website: http://systematicbiology.org
Search for taxon names: http://darwin.zoology.gla.ac.uk/~rpage/portal/
Find out what we know about a species: http://ispecies.org
Rod's rants on phyloinformatics: http://iphylo.blogspot.com
Rod's rants on ants: http://semant.blogspot.com