[redland-dev] MySQL server has gone away

[Sean E. McBride]

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?

 

- Sean McBride

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.usefulinc.com/pipermail/redland-dev/attachments/20060904/d19c34ae/attachment.htm