Page 1 of 2 1 2 LastLast
Results 1 to 15 of 21

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

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. ...

  1. #1
    Junior Member
    Real Name
    Dietmar
    Join Date
    Feb 2008
    Location
    Germany
    Posts
    5
    Liked
    0 times

    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.

  2. #2
    vBSEO.com Webmaster Mert Gökçeimam's Avatar
    Real Name
    Lizard King
    Join Date
    Oct 2005
    Location
    Istanbul, Turkey, Turkey
    Posts
    22,367
    Liked
    542 times
    Blog Entries
    4
    Hello ,

    The problem is possibly related to your mysql wait_timeout setting. Try increasing wait_timeout setting.
    Mert Gökçeimam / Crawlability Inc.

    vBSEO 3.6.0 Alpha Önizlemesi - Including Like Tree
    Unveiling the NEW vBSEO Sitemap Generator 3.0 - available NOW for vBSEO Customers!


    Twitter:@Depkac
    Personal Blog : Mert Gökçeimam

  3. #3
    Junior Member
    Real Name
    Dietmar
    Join Date
    Feb 2008
    Location
    Germany
    Posts
    5
    Liked
    0 times
    Thanks! I will figure that out with my host.

  4. #4
    Member
    Real Name
    administrator
    Join Date
    Sep 2006
    Location
    Dodge City
    Posts
    62
    Liked
    0 times
    Treelo, what host do you have? Hostgator? Have they recently upgraded your PHP or SQL?

  5. #5
    Junior Member
    Real Name
    Dietmar
    Join Date
    Feb 2008
    Location
    Germany
    Posts
    5
    Liked
    0 times
    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. #6
    Junior Member
    Real Name
    Michael
    Join Date
    May 2008
    Posts
    7
    Liked
    0 times
    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. #7
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,689
    Liked
    157 times
    Please try to modify your vbseo.php file:
    FIND:
    PHP Code:
    vbseo_close_db(); 
    REPLACE WITH:
    PHP Code:
    //vbseo_close_db(); 
    Oleg Ignatiuk / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  8. #8
    Junior Member
    Real Name
    Dietmar
    Join Date
    Feb 2008
    Location
    Germany
    Posts
    5
    Liked
    0 times
    @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. #9
    Junior Member
    Real Name
    Dietmar
    Join Date
    Feb 2008
    Location
    Germany
    Posts
    5
    Liked
    0 times
    Quote Originally Posted by Oleg Ignatiuk View Post
    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?

  10. #10
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,689
    Liked
    157 times
    That should be addressed in the next build.
    Oleg Ignatiuk / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  11. #11
    Senior Member briansol's Avatar
    Real Name
    Brian
    Join Date
    Apr 2006
    Location
    Central CT, USA
    Posts
    6,981
    Liked
    8 times
    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. #12
    Senior Member briansol's Avatar
    Real Name
    Brian
    Join Date
    Apr 2006
    Location
    Central CT, USA
    Posts
    6,981
    Liked
    8 times
    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

    :(
    Attached Thumbnails Attached Thumbnails vbulletin-options-hondaswap-forums-vbulletin-admin-control-panel_1215407248589.png  

  13. #13
    vBSEO Staff Oleg Ignatiuk's Avatar
    Real Name
    Oleg Ignatiuk
    Join Date
    Jun 2005
    Location
    Belarus
    Posts
    25,689
    Liked
    157 times
    What is your PHP max_execution_time setting?
    Oleg Ignatiuk / Crawlability Inc.
    vBSEO 3.6.0 GOLD Released!
    Unveiling the NEW vBSEO Sitemap Generator 3.0. - available NOW for vBSEO Customers!


  14. #14
    Senior Member briansol's Avatar
    Real Name
    Brian
    Join Date
    Apr 2006
    Location
    Central CT, USA
    Posts
    6,981
    Liked
    8 times
    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. #15
    Senior Member briansol's Avatar
    Real Name
    Brian
    Join Date
    Apr 2006
    Location
    Central CT, USA
    Posts
    6,981
    Liked
    8 times
    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.

Page 1 of 2 1 2 LastLast

Similar Threads

  1. Replies: 1
    Last Post: 03-12-2008, 03:40 PM
  2. Sitemap status with google is "Error"
    By ChrisGuthrie.net in forum Troubleshooting
    Replies: 5
    Last Post: 04-20-2007, 03:18 AM
  3. Replies: 5
    Last Post: 09-09-2006, 05:11 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •