Page 3 of 5 FirstFirst 12345 LastLast
Results 21 to 30 of 44

Thread: Database Errors

  1. #21
    Senior Tech 250+ Posts driving lots of miles's Avatar
    Join Date
    Jun 2016
    Location
    Kansas
    Posts
    362
    Rep Power
    22

    Re: Database Errors

    working normal now even the new posts button is working again.
    thanks!

  2. #22
    Service Manager 2,500+ Posts
    Database Errors


    Join Date
    Sep 2005
    Location
    South Jersey
    Posts
    3,831
    Rep Power
    133

    Re: Database Errors

    Thanks aneurysm. Hopefully it's fixed and you don't have to be messing with this during the holiday weekend!


    Working great! Seems faster or maybe just because I haven't been able to get on in about a week

    Happy Thanksgiving to everyone.

  3. #23
    Administrator 500+ Posts Aneurysm's Avatar
    Join Date
    Jan 2005
    Location
    New York
    Posts
    887
    Rep Power
    100

    Re: Database Errors

    Quote Originally Posted by NeoMatrix View Post
    The database purge appears to have worked.

    Re. Database fault.
    Was it a temp table dataset(AKA dead file) that didn't merge with the primary database?
    Maybe semaphore flag holding the primary data set locked?
    Could it be duplicate primary key or out of range variable fill with corrupt characters?
    Corrupt data can prevent the main database from updating.

    It appears you have fixed the fault, well done....
    One of the tables in the database had a very large chunk of corrupt data, it should have self-corrected but I think due to the size of the bad data it was taking too long to repair and that brought on the timeout errors. Had to fix it from the Server/SQL side, hopefully that will take care of it.
    --
    Snap, Crackle, Aneurysm!

  4. #24
    Administrator 500+ Posts Aneurysm's Avatar
    Join Date
    Jan 2005
    Location
    New York
    Posts
    887
    Rep Power
    100

    Re: Database Errors

    Quote Originally Posted by copyman View Post
    Thanks aneurysm. Hopefully it's fixed and you don't have to be messing with this during the holiday weekend!


    Working great! Seems faster or maybe just because I haven't been able to get on in about a week

    Happy Thanksgiving to everyone.

    Seems a little faster to me too
    --
    Snap, Crackle, Aneurysm!

  5. #25
    Master Of The Obvious 10,000+ Posts
    Database Errors

    blackcat4866's Avatar
    Join Date
    Jul 2007
    Location
    Lapeer, Michigan
    Posts
    22,442
    Rep Power
    462

    Re: Database Errors

    Thanks! I was getting worried. =^..^=
    If you'd like a serious answer to your request:
    1) demonstrate that you've read the manual
    2) demonstrate that you made some attempt to fix it.
    3) if you're going to ask about jams include the jam code.
    4) if you're going to ask about an error code include the error code.
    5) You are the person onsite. Only you can make observations.

    blackcat: Master Of The Obvious =^..^=

  6. #26
    Retired 10,000+ Posts
    Database Errors

    slimslob's Avatar
    Join Date
    May 2013
    Location
    Bakersfield, CA
    Posts
    34,126
    Rep Power
    989

    Re: Database Errors

    Thanks Aneurysm, some of us were starting to worry about you.

  7. #27
    Field Supervisor 500+ Posts
    Database Errors

    mansart's Avatar
    Join Date
    Apr 2009
    Posts
    843
    Rep Power
    54

    Re: Database Errors

    Thumbs up.....aneurysm

    Now for the "put your money where your mouth is" statement........

    Would be nice to see a few new "Contributor" badges

  8. #28
    Field Supervisor 500+ Posts Zaxxon's Avatar
    Join Date
    Jan 2014
    Posts
    607
    Rep Power
    36

    Thumbs up Re: Database Errors

    Great admin, thanks

  9. #29
    Just a tech 250+ Posts keithxxiii's Avatar
    Join Date
    Nov 2014
    Posts
    463
    Rep Power
    28

    Re: Database Errors

    Awwww Yisssss!!! We're back!
    Aye! Cut the crap

  10. #30
    Service Manager 10,000+ Posts
    Database Errors

    Phil B.'s Avatar
    Join Date
    Jul 2016
    Location
    Raleigh NC
    Posts
    22,656
    Rep Power
    658

    Re: Database Errors

    Quote Originally Posted by Aneurysm View Post
    One of the tables in the database had a very large chunk of corrupt data, it should have self-corrected but I think due to the size of the bad data it was taking too long to repair and that brought on the timeout errors. Had to fix it from the Server/SQL side, hopefully that will take care of it.
    AWESOME Job Brother! Working correctly on my end also!.. will be contributing again!

Tags for this Thread

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
  •  
Get the Android App
click or scan for the Copytechnet Mobile App

-= -= -= -= -=


IDrive Remote Backup

Lunarpages Internet Solutions

Advertise on Copytechnet

Your Link Here