<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:24pt"><div><font size="2"><span><font size="3">The error came out after about 50 seconds. I don't know the pool_recycle setting. Since I didn't change it, it would be whatever default by RelStorage or SQLAlchemy. But thanks to your comment</font><font size="3">, I was encouraged to look for more general MySQL solutions. Besides the wait_timeout setting, max_allowed_packet is another common reason for the 2006 error. It defaults 1MB. After change it to 16M, the catalog updated successfully. Hope this will be useful for someone too.</font><br></span></font></div><div><font size="2"><br></font></div> <div style="font-family: times new roman, new york, times, serif; font-size: 24pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr style="height: 2px;"
size="1"> <b><span style="font-weight:bold;">From:</span></b> Alexandre Garel <alex.garel@tarentis.com><br> <b><span style="font-weight: bold;">To:</span></b> zodb-dev@zope.org <br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, March 27, 2012 1:31 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [ZODB-Dev] RelStorage gives MySQL error when rebuilding catalog in Plone/ZMI<br> </font> </div> <br>
<div id="yiv1376040503">
<div>
Le 27/03/2012 18:50, J Z a écrit :
<blockquote type="cite">
<pre>Sorry about the terrible format. Please allow me to try it again.
I have a Plone 4.1 site using RelStorage to store the zodb in MySQL 5.5
server. The site has 700 objects cataloged and the database is less than
300MB after packing. I won't consider it's a large site. When I tried to
"update catalog" or "clear & rebuild" the catalog, I got the following error:
<snip>
OperationalError: (2006, 'MySQL server has gone away')
The mysql was installed with most default settings. The wait_timeout is
28800 according to phpMyAdmin. Can someone give some idea what
could be wrong and where I should start looking? Thanks!
</pre>
</blockquote>
<br>
DuckDuckGo-ing OperationalError 'MySQL server has gone away'<br>
gives me
<a rel="nofollow" class="yiv1376040503moz-txt-link-freetext" target="_blank" href="https://rapd.wordpress.com/2008/03/02/sqlalchemy-sqlerror-operationalerror-2006-mysql-server-has-gone-away/">https://rapd.wordpress.com/2008/03/02/sqlalchemy-sqlerror-operationalerror-2006-mysql-server-has-gone-away/</a><br>
is the pool_recycle parameter set at the right value in your case ?<i>
(I will suggest less than the </i>wait_timeout)<br>
<br>
how much time is spent between launch of request and
OperationalError ?<br>
<br>
Hope it helps,<br>
<br>
Alex<br>
</div>
</div><br>_______________________________________________<br>For more information about ZODB, see <a href="http://zodb.org/" target="_blank">http://zodb.org/</a><br><br>ZODB-Dev mailing list - <a ymailto="mailto:ZODB-Dev@zope.org" href="mailto:ZODB-Dev@zope.org">ZODB-Dev@zope.org</a><br><a href="https://mail.zope.org/mailman/listinfo/zodb-dev" target="_blank">https://mail.zope.org/mailman/listinfo/zodb-dev</a><br><br><br> </div> </div> </div></body></html>