SitePoint Sponsor

User Tag List

Results 1 to 7 of 7

Hybrid View

  1. #1
    SitePoint Enthusiast lieblick's Avatar
    Join Date
    Jun 2001
    Location
    Tallahassee, FL
    Posts
    98
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Lunched mySQL database (HELP!!!)

    I did a simple update ... it hung ... for a while ... so I aborted ...

    When I came back in ... I can't dump, drop, select, update, or basically do anything to that table!!!

    Our version of mySQL doesn't do Fix or Check table either ...

    Any ideas???

    The sys-admin is out of town until Wed ... while not mission critical, I'd like to fix this mofo!
    Vendor Ratings, Coupons & Specials:
    http://www.outcrier.com
    My Personal Site:
    http://www.epock.com

  2. #2
    morphine for a wooden leg randem's Avatar
    Join Date
    Jun 2002
    Location
    .chicago.il.us
    Posts
    957
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Sounds to me like you ran an update statement that keeps running until a criteria is met, but it never gets met, so it never stops running... in which case... the database... table... is locked... and disallows... all access... to the table... from all other processess...

  3. #3
    SitePoint Enthusiast lieblick's Avatar
    Join Date
    Jun 2001
    Location
    Tallahassee, FL
    Posts
    98
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ahhh ... I never thought of it like that ... how would I go about unlocking it?

    As I said, our sys admin is out of town until Wed ... so restarting mySQL isn't in my bag of tricks
    Vendor Ratings, Coupons & Specials:
    http://www.outcrier.com
    My Personal Site:
    http://www.epock.com

  4. #4
    morphine for a wooden leg randem's Avatar
    Join Date
    Jun 2002
    Location
    .chicago.il.us
    Posts
    957
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    not sure. I couldn't even say for 100% sure that my guess is correct... it's just one theory.

    Short of stopping and restarting the mysql service, I don't know what to tell you. He11, it may not even solve the problem.

  5. #5
    SitePoint Zealot
    Join Date
    Feb 2002
    Location
    Rochester, NY
    Posts
    149
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If you've got phpMyAdmin installed, go to:

    http://yourdomain.com/path/to/phpMyA...=1&mode=reload

    That should reload mySQL for ya.

    If you don't have phpMyAdmin installed, install it and do that ('tis pretty painless).

  6. #6
    Mlle. Ledoyen silver trophy seanf's Avatar
    Join Date
    Jan 2001
    Location
    UK
    Posts
    7,168
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Moved to a more appropriate forum

    Sean
    Harry Potter

    -- You lived inside my world so softly
    -- Protected only by the kindness of your nature

  7. #7
    SitePoint Enthusiast lieblick's Avatar
    Join Date
    Jun 2001
    Location
    Tallahassee, FL
    Posts
    98
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Unhappy

    mySQL got restarted and it 'unlocked' the table.

    Looks like my fingers may have jabbled too fast 'cause the value was up to 537,844,851 when I got back in. I guess my +50 statement didn't work as planned!

    Vendor Ratings, Coupons & Specials:
    http://www.outcrier.com
    My Personal Site:
    http://www.epock.com


Bookmarks

Posting Permissions

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