Database Errors?

Zed7fiddy · 13-09-2007, 10:08 AM

Last night i had major issues accessing the forums (received database error warnings)

And i have noticed many posts missing (well i did at 3am lol) will they be back (if not already)?

Road Games · 13-09-2007, 10:28 AM

Me too, I was wondering if it was to do with threads linking to other forums and certain E-series pot stirrers in particular ? Forgot that there are other things to do when the Forum goes down

Allen · 13-09-2007, 10:33 AM

I thought I was going crazy... I was looking for threads in the pub etc that I posted in last night, but they don't exist anymore!

Zed7fiddy · 13-09-2007, 10:35 AM

Quote:

Originally Posted by DAZZLER351

Me too, I was wondering if it was to do with threads linking to other forums and certain E-series pot stirrers in particular ? Forgot that there are other things to do when the Forum goes down

Shhh, dont tell them, but the whole world doesnt revolve aroudn E-Series

**russellw** · 13-09-2007, 10:46 AM

When we have a database crash the indices that control the threads and posts are corrupted and our only option to fix that is a database repair.

Unfortunately the repair process typically removes any records that are incomplete or corrupted and I noticed last night (well this morning) when doing the repair that it was finding a lot of bad threads.

We have the option of restoring them from the back up but this introduces a whole other pile of potential problems as new threads created today will be taking the same numbers as those that have disappeared and we would have to shut the forum down to upload the missing threads and give them new thread id's as we did so. It is feasible but it won't be fun.

Cheers
Russ

Road Games · 13-09-2007, 11:38 AM

Thanx Russ

: You da man ........

Grum · 13-09-2007, 11:55 AM

There seems to be alot missing though

Laminge · 13-09-2007, 12:54 PM

Meh, for the sake of the time invovled in restoring the threads in question, they can be started again as required.

Clearing these threads out I dare say will solve future issues with the database.

RED FGII · 13-09-2007, 01:42 PM

I have lost my post count, avatar, username, and cant access PM's .....
any 1 else have this problem

eXtremist · 13-09-2007, 01:43 PM

I think BlackLS's account has been corrupted, he can't login anymore.

**russellw** · 13-09-2007, 01:59 PM

I have fixed BlackLS' account and emailed him accordingly. It might need a password reset.

Russ

**russellw** · 13-09-2007, 02:02 PM

Quote:

Originally Posted by OFC~EL

I have lost my post count, avatar, username, and cant access PM's .....
any 1 else have this problem

Your account isn't corrupted by the look of it and all the data is there. It actually looks as if you aren't logging in as the post is set to guest.

If you view the link below it shows your profile ok:

http://www.fordforums.com.au/member.php?u=39333

Cheers
Russ

RED FGII · 13-09-2007, 03:04 PM

Quote:

Originally Posted by russellw

Your account isn't corrupted by the look of it and all the data is there. It actually looks as if you aren't logging in as the post is set to guest.

If you view the link below it shows your profile ok:

http://www.fordforums.com.au/member.php?u=536886289

Cheers
Russ

PM sent

**russellw** · 13-09-2007, 03:46 PM

Ok. We have identified the root cause of the strange happening for some users - it has affected all those users who joined in the period since the last crash because they had user ID's that were out of number sequence by a substantial amount. This included OFC~EL as his old account was merged with his new one.

All of those users (and there are about 600 of them) have member ID's that do not match the ID's in the subsidiary tables and thus the information from those tables is not displayed. These include avatars, titles etc. etc.

We have formulated a plan of attack to fix these issues later this evening but in the interim these accounts will not display correctly.

Cheers
Russ

eXtremist · 13-09-2007, 04:50 PM

Quote:

Originally Posted by russellw

I have fixed BlackLS' account and emailed him accordingly. It might need a password reset.

Russ

blackls gets "you have not entered an email address that we recognise"

RED FGII · 13-09-2007, 05:41 PM

Cheers u admins

13-09-2007, 06:01 PM

i think my account is the same but i can get to my pm menu.

**russellw** · 13-09-2007, 07:02 PM

Quote:

Originally Posted by eXtremist

blackls gets "you have not entered an email address that we recognise"

The email address had an extra character in it - now fixed.

Cheers
Russ

Mark^^ · 13-09-2007, 07:56 PM

Hi Russ, thanks for returning me to my addiction on FFA.... However I still have some issue with my account, as I suspect other do, all my old posts now all have:

Mark^^
Guest

Posts: n/a

Which shows that the past does not recognise me as it thinks Mark^^ must have a new dress on. LOL

Its no big deal, I just though I would let you know there are still some issues.

However in this new post its all back in my old dress LOL

Regards,

Mark

Mark^^ · 13-09-2007, 08:25 PM

OK I nominate Russ for next Prime Minister he can fix anything in minutes.

Thanks Russ.

**russellw** · 13-09-2007, 08:27 PM

I will fix this now - things might be odd for the enxt 10 mins so if you can refrein from posting that would be good.

Cheers
'Russ

Quote:

Originally Posted by Mark^^

Hi Russ, thanks for returning me to my addiction on FFA.... However I still have some issue with my account, as I suspect other do, all my old posts now all have:

Mark^^
Guest

Posts: n/a

Which shows that the past does not recognise me as it thinks Mark^^ must have a new dress on. LOL

Its no big deal, I just though I would let you know there are still some issues.

However in this new post its all back in my old dress LOL

Regards,

Mark

**russellw** · 13-09-2007, 08:28 PM

Fixed - your posts were under another UID and I have changed yours to match.

Cheers
Russ

Mark^^ · 13-09-2007, 08:37 PM

Fantastic, I just upgraded my vote from Prime Minister to God.

Mark

Mark^^ · 13-09-2007, 10:11 PM

Hi Russ,

One of our members on the Territory section may be having the same problems I was having:

edwardseddie
Guest

Posts: n/a

Regards,

Mark

**russellw** · 13-09-2007, 10:28 PM

Hi Mark

We are about to import the fixes into the database in the next half hour - this should resolve those issues for the users with unlinked ID's.

Those with normal corruption of their ID's will need to email admin@fordforums.com.au so that we can reset the accounts.

Cheers
Russ

Mark^^ · 13-09-2007, 10:34 PM

great Russ, your work is never done is it.

BlackLS · 13-09-2007, 10:39 PM

Quote:

Originally Posted by russellw

The email address had an extra character in it - now fixed.

Cheers
Russ

Thanks to Extremist for posting on my behalf, and to Russ and the rest of the admin team for their time fixing problems! The internet wasn't the same without being able to post on the forums, like having no arms - I actually some work done today!

Road Games · 13-09-2007, 10:52 PM

And now a 2 week old thread in B-series Discussion, has over 15 million hits ?!

: A mans work is never done ........

**russellw** · 13-09-2007, 11:46 PM

Quote:

Originally Posted by DAZZLER351

And now a 2 week old thread in B-series Discussion, has over 15 million hits ?!

: A mans work is never done ........

Fixed that too.

Cheers
Russ

**russellw** · 14-09-2007, 03:00 AM

The user records that were earlier identified as out of sync have been updated - thanks to plext for the methodology & code and thanks also to those who have waited patiently for the fixes.

Some individual user accounts are still corrupted but we will fix those as we find them.

We have turned on extended logging for the forum which may slow things down a tiny amount but it will enable us to get a better picture of what is actually going on that has caused these two crashes.

Cheers
Russ