Sitemap cron from server crashes in loop

No matter how low we set our setting, the job won't complete. This is on both vB3 and vB4. The error on vb4 is on the same forum id every time no matter what our settings are.

This is the error every time.

Invalid SQL:

SELECT count(*) as cnt
,max(views) as maxv,avg(views) as avgv
,max(replycount) as maxre,avg(replycount) as avgre
FROM thread
WHERE forumid = 107
AND visible = 1;

MySQL Error : MySQL server has gone away
Error Number : 2006

Request Date : Friday, October 7th 2011 @ 04:37:00 PM
Error Date : Friday, October 7th 2011 @ 04:40:14 PM
Script : seo_sitemap/vbseo_sitemap.php
Referrer :
IP Address :
Username : Unregistered
Classname : vB_Database
MySQL Version :


We have 300k and 500k threads and 1.9millions and 2.5 million posts respectively.

Anyone else have this issue? This is from both vB cron and system cron, we prefer the system cron however.

Please advise.

Thanks

You need to increase mysql wait_timeout value to 175 and restart MySQL. If you have a big board , you should create sitemap files directly from a server level cron job

Thanks, we'll have the server people check the timeout. We are using system cron. Thanks!