• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

DB Issues Continued

J

Jason Clark

Diamond Member
Well, it appears as though when the previous DB server was having drive problems and system freezes, it corrupted the database. This is why once and awhile it just stops accepting connections, It may appear as though its "busy" but its not its not even there 🙂 Which causes the webservers to stack up requests as they cannot contact the DB. This is a bit of a tedious process so we will keep you posted but I would imagine we are going to have to take the db down for a few hours to begin repairing the damage that the other db server did 🙁

Just a heads up 🙂
 
I had a hunch that the databse was corrupt, do to threads disappearing from the forums archive. I am sure you guys will get it fixed.
 
Well, we think you guys have a right to know what is happening. The corruption lies in the users table, we are going to lose some users. We will not know how many until we do a test run, which should be very soon. The test run will be done in our dev environment. This issue could not be helped, it was just a result of a failing database server.
 
Well if they are inactive users, then that not to bad ofa problem. Maybe a courasy e-mail would be nice. God I would hate to get dumped before I reached 10k 🙁
 
Hey your not getting rid of me that easy buddy... 😉

Thanks for the heads up Zuni, and thanks for all the work your doing keeping this place going. I don't envy you at all lately, your working your fingers to the bone! 😉
 
hey Zuni,

since the DB is SQL Server, did you ever think of going to stored procedures for all the queries? I know this wouldnt be compatible with other databases, but at least for the SQL server version it would make an imporvement.

I moved all the db access on one of my sites to stored procedures and the performance took a huge jump, i didnt realize until after the fact what a big difference it makes.
 
Zuni - are you saying that the users who will be 'nuked' will be totally random? It could be someone who signed up yesterday, it could be Russ...that kind of thing? :Q
 
Well if they are doing a test run I guess they could find out who would get nuked and mayeb grant them their post count back again when they restore the uncorrupted DB?
 
i think the post count is an actual count total of topics and replis by a user, not an actual number that gets incremented, im not sure, but if so, you wouldnt be able to "grant" a post count without creating bogus records.
 
We won't know what records are damaged as once its corrupted thats it.. we may be able to cross reference who isnt here etc.. Train, we have done extensive load testing and stored procs do nothing for performance. MDAC 2.6 and Coldfusion work very well together when talking to SQL, the queries are running very very fast, the place that sees load first is the web servers. It has nothing to do with stored procs 🙂. It's all about a server that shut down in the middle of transactions and had a bad drive. So it corrupted part of the database.
 
Zuni - should it occur that we're deleted, will we be able to be re-instated with our original user name, signup date, post count etc. ?
 
Snow, that will be up to the user.. as I will have no idea who got wiped and who didn't 🙂 I don't know anymore at this point as we haven't started trying to export the userbase.. to see where the break is. It may just be one record who knows.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top