[redland-dev] MySQL server has gone away

[Dave Beckett]

Sean E. McBride wrote:
> Hi, I’m using the latest version of Redland’s Python bindings in Ubuntu.
> I’m working on a web application for my college that allows students to
> see what movies/books/cds other students have, and it uses an RDF
> Redland database with MySQL storage. When the application is dormant
> (nobody uses it) for more than 8 hours, the application starts throwing
> this error:
> 
> Error(RedlandError): MySQL query failed: MySQL server has gone away
> 
> I’ve run into this error in other contexts before, and I’m pretty sure
> it’s because the MySQL connection isn’t being made with the reconnect=1
> option. Is there any way to force Redland to use the reconnect option
> for MySQL stores? Has anyone else had this problem?

Not currently although somebody asked on IRC about this (was it you?)
and I made a bug with untested patch to do this.

http://bugs.librdf.org/mantis/view.php?id=117

Dave