1,105,546 Community Members

More Bugs

Member Avatar
Ancient Dragon
Achieved Level 70
27,663 posts since Aug 2005
Reputation Points: 5,234 [?]
Q&As Helped to Solve: 3,039 [?]
Skill Endorsements: 115 [?]
Team Colleague
Featured
Sponsor
 
0
 

I can't save any posts tonight. Cleared my browsing history but that didn't help.

Member Avatar
Dani
The Queen of DaniWeb
20,571 posts since Feb 2002
Reputation Points: 1,356 [?]
Q&As Helped to Solve: 931 [?]
Skill Endorsements: 204 [?]
Administrator
Featured
Sponsor
 
0
 

I was making a change to the posts table, and that locked the entire posts table for a good 20 minutes. :(

Member Avatar
Ancient Dragon
Achieved Level 70
27,663 posts since Aug 2005
Reputation Points: 5,234 [?]
Q&As Helped to Solve: 3,039 [?]
Skill Endorsements: 115 [?]
Team Colleague
Featured
Sponsor
 
0
 

Can you put up some sort of message telling us that the tables are locked so that we don't waste a lot of time trying to figure out what's wrong?

Member Avatar
Dani
The Queen of DaniWeb
20,571 posts since Feb 2002
Reputation Points: 1,356 [?]
Q&As Helped to Solve: 931 [?]
Skill Endorsements: 204 [?]
Administrator
Featured
Sponsor
 
0
 

I didn't realize they would be. I thought the database query was only going to take like 30 seconds to execute, and it ended up taking 20 minutes! I was just staring at the screen watching it do its thing and I kept saying, "Ok, any second now it's going to finish ... Any second now ..."

Member Avatar
Dani
The Queen of DaniWeb
20,571 posts since Feb 2002
Reputation Points: 1,356 [?]
Q&As Helped to Solve: 931 [?]
Skill Endorsements: 204 [?]
Administrator
Featured
Sponsor
 
0
 

Also, I didn't realize the post was locked during the whole process. :(

Member Avatar
Ancient Dragon
Achieved Level 70
27,663 posts since Aug 2005
Reputation Points: 5,234 [?]
Q&As Helped to Solve: 3,039 [?]
Skill Endorsements: 115 [?]
Team Colleague
Featured
Sponsor
 
0
 

Oh, I know that feeling -- been there and done that :)

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article