1. Are you a current member with account or password issues?

    Please visit following page for more information

    Dismiss Notice

Forum Crashed very hard today and I need some help.

Discussion in 'MEMBER RULES, GUIDELINES & ANNOUNCEMENTS' started by JonSidneyB, Dec 31, 2010.

  1. JonSidneyB
    • Administrator

    JonSidneyB Uber Prepared
    Staff Member

    Joined:
    Mar 28, 2006
    Messages:
    21,161
    Likes Received:
    12,084
    This was something I never saw coming.;D

    We had three things go wrong today. It all started with a little thing,
    Birthdays. I never thought about this causing issues like this.

    This is the very first New Years on vB. vB thinks that 18k of the members was born on Jan 1 1901. The forum wants to put them on the birthday list and send out a nice message.

    MySQL said "Thou Shalt Not"

    MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes

    So the forum tries again, and MySQL still says no.

    So they go round and round enough that now the G-mail account that I have error message go to is 25% full.

    I try and get in to the forum to turn off the birthday stuff, nope, can't get in. We now are getting

    Database error in vBulletin : mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Too many connections

    So I try and handle this from the server side. Nope, Too many connections.

    The hosting company gets involved.

    Pretty soon we have on top of a mega packet being blocked my mysql and vB and all the error messages it put out and all the connections being used up the data base became corrupted.

    The repair failed.

    vb4_post Check Warning: Table is marked as crashed and last repair failed
    vb4_post Check Error: Found key at page -1 that points to record outside datafile
    vb4_post Check Error: Corrupt

    Well it turns out the disk became full. The error messages became bigger than the forum itself.

    This was my fault for not realizing this could happen. I have set the forum so people have to put a birthday in to join the forum.

    Everyone, set your birthday in your profile, you can have the birthday hidden but please set it to something.
     
  2. mta5888

    mta5888 Loaded Pockets

    Joined:
    Dec 25, 2010
    Messages:
    293
    Likes Received:
    36
    There's a way to disable the Birthdays scheduled task(that sends those emails), I don't know the exact way I'm trying to google it and research it. Hope that helps, at least might lower the load on the server/s
     
  3. mta5888

    mta5888 Loaded Pockets

    Joined:
    Dec 25, 2010
    Messages:
    293
    Likes Received:
    36
    modifiy the "my.cnf" to allow for a bigger packet size and then you gotta restart mysql. Now I don't know what this particular traffic packets that are bothering vB like this but that would help dealing with messages.
     
  4. JonSidneyB
    • Administrator

    JonSidneyB Uber Prepared
    Staff Member

    Joined:
    Mar 28, 2006
    Messages:
    21,161
    Likes Received:
    12,084
    I have already turned it off. I was in hopes I could get it turned on again. I could just turn it off on the 30th and back on on the 2nd every year.

    Whats the best strategy to get tons of people to set their birthday.
     
  5. Gamble

    Gamble Loaded Pockets

    Joined:
    Apr 28, 2006
    Messages:
    444
    Likes Received:
    783
    promise to give them a present!
     
  6. mta5888

    mta5888 Loaded Pockets

    Joined:
    Dec 25, 2010
    Messages:
    293
    Likes Received:
    36
    You could have the web host set a cron job to do that for you. Or if you have access deep enough you could set a cron to just flip it off and then 3 days later flip it back on. I don't know the exact command set but I'm sure when can find that info online.

    Perhaps when people login it forces them to set it, if vB allows such an action. Not sure on that one.
     
  7. Cervantes

    Cervantes Loaded Pockets

    Joined:
    Jun 29, 2009
    Messages:
    1,036
    Likes Received:
    220
    I second that emotion :)
     
  8. JonSidneyB
    • Administrator

    JonSidneyB Uber Prepared
    Staff Member

    Joined:
    Mar 28, 2006
    Messages:
    21,161
    Likes Received:
    12,084
    Lets see, less than 20% of members have a birthday set. My fault for not having it a requirement to join but would still be a problem after we moved from SMF.

    18k presents at $1.00 each is $18,000 then there is shipping costs. Lets say $1.00 for shipping so we are at $36,000.

    Hmmm,
     
  9. WillCAD

    WillCAD Loaded Pockets

    Joined:
    Jul 27, 2007
    Messages:
    501
    Likes Received:
    56
    Okay, mine is set.

    Actually, it was set before. But it still is, so...
     
  10. wabash

    wabash Loaded Pockets

    Joined:
    Mar 30, 2006
    Messages:
    174
    Likes Received:
    142
    I had mine set to Jan 1. I changed it to July 4. :)


    see if there is a setting , or a mod, that limits the number of emails *per hour* that your forum software will attempt.
     
  11. FeebleOldMan

    FeebleOldMan Loaded Pockets

    Joined:
    Feb 10, 2009
    Messages:
    671
    Likes Received:
    11
    You could try to get the webhost to replace the birthday script in the scheduled tasks with the following script to exclude new years from triggering the birthday email. Replace "run birthday email script" with the appropriate commands.
    Code:
    #!/bin/bash
    TODAY=$(date "+%m%d")
    if [ "$TODAY" -ne "0101" ]; then
      run birthday email script
    else
      exit 0
    fi
    
     
  12. tower
    • In Omnia Paratus

    tower Loaded Pockets

    Joined:
    Sep 13, 2009
    Messages:
    4,591
    Likes Received:
    3,753
    Jon, I hate to be a hard ash, but if it comes to that, send out an e-mail broadcast to all members that they have 1 week to enter their BD or their registration will be toast and their screen name open to anyone wanting it. That would get some compliance and you could lose all the "dead" registrants. Sometimes you gotta drop the hammer on a live round.
     
  13. JonSidneyB
    • Administrator

    JonSidneyB Uber Prepared
    Staff Member

    Joined:
    Mar 28, 2006
    Messages:
    21,161
    Likes Received:
    12,084
    I won't do anything like that. I kind of ended up being a lost day.

    What I might do is have a brithday giveway during the Summer. No fund raising, to be eligible you have to have a birthday in your profile that is not Jan 1 1901 unless you are really 110 years old. If anyone can show that is their real birthday they will get a special prize too.
     
  14. sveqs

    sveqs Loaded Pockets

    Joined:
    May 3, 2009
    Messages:
    2,129
    Likes Received:
    497
    ...and those who were born 01/01/01 will have to donate the prizes :laugh:
     
  15. dewildeman

    dewildeman Loaded Pockets

    Joined:
    Aug 31, 2007
    Messages:
    1,292
    Likes Received:
    241
    You could offer "Grand Exalted Pooba" membership status to those who set their BD. ;D
     
  16. Gamble

    Gamble Loaded Pockets

    Joined:
    Apr 28, 2006
    Messages:
    444
    Likes Received:
    783
    How about 5% off their next purchase from the store? thats win win!
     
  17. mta5888

    mta5888 Loaded Pockets

    Joined:
    Dec 25, 2010
    Messages:
    293
    Likes Received:
    36
    Yeah that's a good one and shouldn't hit profits to run the board to hard, or maybe 15% or free ship or something.
     
  18. sveqs

    sveqs Loaded Pockets

    Joined:
    May 3, 2009
    Messages:
    2,129
    Likes Received:
    497
    ...or just kindly ask everyone to act their age and fill in the dates?
    I mean we are talking about rewarding people for going through the registration process in a proper manner??
    the date of birth may not be obligatory but really, are people afraid to share that piece of info, or just plain lazy to do so?
    this is not some sort of a bizzare dating forum where you have to pretend you're someone else...

    having said that, I can live without the forum engine wishing me happy b'day if that saves Jon and the admin team some trouble/resources

    -greg
     
  19. op1

    op1 Loaded Pockets

    Joined:
    Dec 30, 2008
    Messages:
    311
    Likes Received:
    0
    Birth date now updated.
     
  20. mta5888

    mta5888 Loaded Pockets

    Joined:
    Dec 25, 2010
    Messages:
    293
    Likes Received:
    36
    +1.