Sitemap-cronjob-error - "MySQL-server has gone away"

I tried to read carefully all at least to me relevant former threads, but didn´t find anything regarding my problem. So apologies for possibly double posting.

For a few days I´m always getting sitemap-errors with the automatically started cronjob from within vbulletin.

This is the error-email from vbulletin:
------------------------------------------------
Database error in vBulletin 3.7.0:

Invalid SQL:

INSERT INTO cronlog
(varname, dateline, description, type)
VALUES
('vbseo_sitemap_task',
1210638645,
'Google Sitemap Created',
0);

MySQL Error : MySQL server has gone away
Error Number : 2006
-----------------------------------------------------
My config: vb3.7, vbseo3.2rc5 and the recent sitemap generator.

I tried the hint with the "vbseo_linkback"-fix with no success.

If I´m starting the sitemap-generation manually within the sitemap-admin-panel, everything seems to be ok.

My host restricts the cronjob-duration to 30 seconds and my forum is increasing. Can this time-limit cause the failure?

Many thanks in advance for a possible reply.

Hello ,

The problem is possibly related to your mysql wait_timeout setting. Try increasing wait_timeout setting.

Thanks! I will figure that out with my host.

Treelo, what host do you have? Hostgator? Have they recently upgraded your PHP or SQL?

My host is Hosteurope. They changed a parameter, but didn´t tell me which parameter - with no effect.

Hosteurope is going to update the server with the new versions of Apache (2.5.2) and PHP (5.2.6 and 4.4.8) in the next time.

When I´m preventing the cronjob from sending any emails or creating log-entries, the error doesn´t occur.

could be that execution time for the script is too low and script is
interrupted therefore. I would recommend to ask hoster to increase
above mentioned variable, then it should work (in case I'm right here.
For me it fixed this nasty prob)

Please try to modify your vbseo.php file:
FIND:

PHP Code:

vbseo_close_db(); 


REPLACE WITH:

PHP Code:

//vbseo_close_db(); 


@Lappen:
I´m afraid, that the hoster isn´t willing to increase the timeout for cronjobs. I asked the hotline about the timeout-limit within higher-class webspace-products and got contradictory answers from different hotliners. I´m afraid again, that the timeout will stick to 30 seconds. I searched around for other competitors in the German webhosting-scene and found a pretty big hoster with 90 seconds of timeout even within the lower positioned webspace-products.

@Oleg:
Thank you very much for the hint, I´ll give it a try.

Originally Posted by Oleg Ignatiuk

Please try to modify your vbseo.php file:
FIND:

PHP Code:

vbseo_close_db(); 


REPLACE WITH:

PHP Code:

//vbseo_close_db(); 


So the closing of the database is commented out?

Anyway, thanks a lot, Oleg, this worked! I turned on the log-entry- and emailing-option and no further database-error occurred.

So it´s no problem to stick to this changed code?

That should be addressed in the next build.

Still having this problem in 2.2

re-commented the close(), and it still times out.

my wait_timeout is up there too... 90secs



Forum Display: 2041
Show Thread: 111234
Show Post:
Member Profiles: 45886
Poll Results: 1830
Archive: 0

Total Indexed URLs: 1064317
Total Processing Time: 1,547,805.42 seconds

which means, this hasn't run successfuly via the task in months :(

this is also probably reaking havoc on my SE results...

i just ran the last one by hand, refreshing everytime it died.

without it, the auto-task ends up with results all over the place, timeouts, double-runs, massive url count fluctuations... etc etc

:(

What is your PHP max_execution_time setting?

30 secs. when higher, i run out of apache->sql connection ports or something... and then i get sigfaults and sigterms and lockups


Ideally, i'd like to see this run in stages
-run
-make conenction
-select stuff for first file
- write file
-close
- wait setting (as already in the options... which doesn't seem to do anything BTW)
- make new connection
-write file 2

etc etc

I removed member prodiles from my sitemap

2008-07-07 02:01 88.86 s 114,417 -84,165 Yes Yes
2008-07-07 01:02 224.26 s 198,582 -865,735 Yes Yes



that's a SIGNIFICANT time drop for 45k users... but somehow ended up with -84k? (does it also drop social pages as well? perhaps that's the dupe)

maybe some time can be found in the members area