vBulletin Search Engine Optimization
This is a discussion on Sitemap-cronjob-error - "MySQL-server has gone away" within the Troubleshooting forums, part of the vBSEO Google/Yahoo Sitemap category; I tried to read carefully all at least to me relevant former threads, but didn´t find anything regarding my problem. ...
| |||||||
Enhancing 80 million pages. | Register | FAQ | Members List | Social Groups | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
| |||
| |||
| 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. |
|
#3
| |||
| |||
|
Thanks! I will figure that out with my host.
|
|
#4
| |||
| |||
|
Treelo, what host do you have? Hostgator? Have they recently upgraded your PHP or SQL?
|
|
#5
| |||
| |||
|
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. |
|
#6
| |||
| |||
|
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) |
|
#7
| ||||
| ||||
|
Please try to modify your vbseo.php file: FIND: PHP Code: PHP Code:
__________________ Oleg Ignatiuk / Crawlability Inc. vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD 6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You. |
|
#8
| |||
| |||
|
@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. |
|
#9
| |||
| |||
| Quote:
Anyway, thanks a lot, Oleg, this worked! So it´s no problem to stick to this changed code? |
|
#10
| ||||
| ||||
|
That should be addressed in the next build.
__________________ Oleg Ignatiuk / Crawlability Inc. vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD 6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You. |
|
#11
| ||||
| ||||
|
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 :( |
|
#12
| ||||
| ||||
|
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 :( |
|
#13
| ||||
| ||||
|
What is your PHP max_execution_time setting?
__________________ Oleg Ignatiuk / Crawlability Inc. vBSEO 3.2.0 Launched - Maximum Overdrive for Your Web Traffic! Over 100 Instant SEO Optimizations vBSEO Google Sitemap Generator - Version 2.2 Released Mandatory Upgrade for vBSEO 3.2.0 GOLD 6X Traffic - $1400 in One Day with vBSEO! Imagine What the vBSEO Patent Pending Technology Can Do For You. |
|
#14
| ||||
| ||||
|
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 |
|
#15
| ||||
| ||||
|
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 Last edited by briansol; 07-07-2008 at 03:24 AM. |
| Thread Tools | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Keep getting the following error: "Sitemap file not found" | robdog | Troubleshooting | 1 | 03-12-2008 03:40 PM |
| Sitemap status with google is "Error" | ChrisGuthrie.net | Troubleshooting | 5 | 04-20-2007 03:18 AM |
| Don't show "social bookmark" icons in "private" or "members only" forums? | john | Feature Requests | 5 | 09-09-2006 05:11 AM |