Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Page 1 of 2 12 LastLast
Results 1 to 15 of 29
  1. #1
    WA
    WA is offline
    Administrator
    Join Date
    Mar 2002
    Posts
    2,596
    Thanks
    2
    Thanked 19 Times in 18 Posts

    IMPORTANT: Database reverted to Sept 15th copy, perhaps temporarily!!

    To help me isolate the strange instability issues with the forums that started on Sept 16th, please note that at the moment I've reverted the database back to the Sept 15th copy. This could mean two things:

    1) If the problems with the forums are fixed as a result of the reverting, this means I'll have to stick to this copy of the database, and posts made after Sept 15th are lost unfortunately.

    2) If the problems still persist, then I'll be restoring the latest copy of the database, which is Sept 24th, and we go from there.

    Due to the uncertainty at this point, you should bare in mind that any posts made on CF now may be flushed if 2) turns out to be the outcome.

    Sorry for the inconvenience, but this appears to be a necessary step for me to diagnose the problems, which specifically are:

    1) A vBulletin database error instead of the actual page you're viewing
    2) Slow or inaccessible pages.

    Please post any issues you experience with the forums at this point in this thread.
    - George
    - JavaScript Kit- JavaScript tutorials and 400+ scripts!
    - JavaScript Reference- JavaScript reference you can relate to.

  • #2
    Supreme Master coder! Philip M's Avatar
    Join Date
    Jun 2002
    Location
    London, England
    Posts
    17,730
    Thanks
    202
    Thanked 2,508 Times in 2,486 Posts
    At 1306 GMT was working perfectly as far as I can see.
    Last edited by Philip M; 09-24-2008 at 02:04 PM.

  • #3
    Regular Coder
    Join Date
    Feb 2007
    Location
    Canada
    Posts
    924
    Thanks
    10
    Thanked 56 Times in 55 Posts
    I had several "lags" the other day, but nothing serious...

    No doubt you and the crew will work through this issue. Thanks for providing the site in the first place.

  • #4
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts
    That's a shame because I was thanked like 500 times yesterday. Oh well

    p.s. I'll go ahead and allow you to add 500 to my thanked count to make up for it. Yes I'm bored.

  • #5
    New to the CF scene
    Join Date
    Sep 2008
    Posts
    3
    Thanks
    0
    Thanked 1 Time in 1 Post
    Is this the reason for my account being deleted? I tried to logon this morning and found my posts gone and when I reregistered it let me use the same name... that's how I found out I wasn't banned or anything (I was trying to figure out if I'd done something wrong, lol).

  • #6
    Rockstar Coder
    Join Date
    Jun 2002
    Location
    USA
    Posts
    9,074
    Thanks
    1
    Thanked 328 Times in 324 Posts
    Quote Originally Posted by sedaniel View Post
    Is this the reason for my account being deleted? I tried to logon this morning and found my posts gone and when I reregistered it let me use the same name... that's how I found out I wasn't banned or anything (I was trying to figure out if I'd done something wrong, lol).
    Yeah, that is the reason. The database also contains the list of registered users and their information so if you registered after the 15th, your account would no longer exist.
    OracleGuy

  • #7
    Master Coder mlseim's Avatar
    Join Date
    Jun 2003
    Location
    Cottage Grove, Minnesota
    Posts
    9,378
    Thanks
    8
    Thanked 1,075 Times in 1,066 Posts
    Sometimes, PHP is just too much fun

  • #8
    WA
    WA is offline
    Administrator
    Join Date
    Mar 2002
    Posts
    2,596
    Thanks
    2
    Thanked 19 Times in 18 Posts
    Quote Originally Posted by Fumigator View Post
    That's a shame because I was thanked like 500 times yesterday. Oh well

    p.s. I'll go ahead and allow you to add 500 to my thanked count to make up for it. Yes I'm bored.
    Perhaps, but on the upside, all the thanks predating Sept 15th are now back. Of course, this could be temporary if reverting back to the old copy of the database doesn't help with the issues. We're deep in the rabbit hole now...
    - George
    - JavaScript Kit- JavaScript tutorials and 400+ scripts!
    - JavaScript Reference- JavaScript reference you can relate to.

  • #9
    Regular Coder BoldUlysses's Avatar
    Join Date
    Jan 2008
    Location
    Winston-Salem, NC
    Posts
    938
    Thanks
    10
    Thanked 190 Times in 187 Posts
    Can we do anything to help? As mentioned above, thanks for your hard work and just for providing the site.
    matt | design | blog

  • #10
    WA
    WA is offline
    Administrator
    Join Date
    Mar 2002
    Posts
    2,596
    Thanks
    2
    Thanked 19 Times in 18 Posts
    Thanks for the offer. Right now, please just report any continuing database or site inaccessible/slow errors you may experience here. Other than that, at this point, there's not much I can do either actually except wait and see if the revert has made any difference.
    - George
    - JavaScript Kit- JavaScript tutorials and 400+ scripts!
    - JavaScript Reference- JavaScript reference you can relate to.

  • #11
    The fat guy next door VIPStephan's Avatar
    Join Date
    Jan 2006
    Location
    Halle (Saale), Germany
    Posts
    8,475
    Thanks
    6
    Thanked 980 Times in 953 Posts
    Ain’t there any error log where one can find out what’s wrong? Surely, these issues don’t come from nothing. Maybe the server/database has been hijacked or something?

    Maybe a fresh install of the forum software and DB would help?

  • #12
    WA
    WA is offline
    Administrator
    Join Date
    Mar 2002
    Posts
    2,596
    Thanks
    2
    Thanked 19 Times in 18 Posts
    Quote Originally Posted by VIPStephan View Post
    Ain’t there any error log where one can find out what’s wrong? Surely, these issues don’t come from nothing. Maybe the server/database has been hijacked or something?

    Maybe a fresh install of the forum software and DB would help?
    Hmm nothing that dramatic or drastic unfortunately. Basically the database has grown to be very large, so rather routine things like a database or server crash are amplified and run the risk of doing some serious issues to the integrity of the database. This seemed to have happened on September 15th; either that, or the server is simply no longer able to reliably handle the size of the database. It may be time to move CF to a different server than the one it's on very soon with increased resources.
    - George
    - JavaScript Kit- JavaScript tutorials and 400+ scripts!
    - JavaScript Reference- JavaScript reference you can relate to.

  • #13
    Senior Coder o0O0o.o0O0o's Avatar
    Join Date
    Jan 2008
    Location
    C:\Windows\System32
    Posts
    1,018
    Thanks
    19
    Thanked 9 Times in 9 Posts
    I think 2GB database size is not that large
    Please de-reputate me
    0o0o0o0

    Its better to rule in Hell then to serve in Heaven

  • #14
    Supreme Master coder! abduraooft's Avatar
    Join Date
    Mar 2007
    Location
    N/A
    Posts
    14,801
    Thanks
    160
    Thanked 2,216 Times in 2,203 Posts
    Blog Entries
    1
    Got another DB error now, and just out of curiosity, when looked the html page source, there is
    <!--
    Database error in vBulletin :

    mysql_pconnect() [&lt;a href='function.mysql-pconnect'&gt;function.mysql-pconnect&lt;/a&gt;]: User has already more than 'max_user_connections' active connections
    .(xxxx).php on line xx

    MySQL Error :
    Error Number :
    Request Date : Thursday, September 25th 2008 @ 01:28:16 AM
    .......
    Why a mysql_pconnect() ?
    Quote Originally Posted by php.net/mysql_pconnect
    Using persistent connections can require a bit of tuning of your Apache and MySQL configurations to ensure that you do not exceed the number of connections allowed by MySQL.
    Edit: PMed WA
    Last edited by WA; 09-25-2008 at 07:22 AM.
    The Dream is not what you see in sleep; Dream is the thing which doesn't let you sleep. --(Dr. APJ. Abdul Kalam)

  • #15
    WA
    WA is offline
    Administrator
    Join Date
    Mar 2002
    Posts
    2,596
    Thanks
    2
    Thanked 19 Times in 18 Posts
    Thanks for the info abduraooft! Some of that information may just prove very helpful, starting with the fact that it reminds me to turn back on error reporting via email (which I had turned off a few months ago). I've disabled persistent connections for now as well.

    Thanks.
    - George
    - JavaScript Kit- JavaScript tutorials and 400+ scripts!
    - JavaScript Reference- JavaScript reference you can relate to.


  •  
    Page 1 of 2 12 LastLast

    Posting Permissions

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