PDA

View Full Version : Read this thread - Forum database issues



bobtomay
03-16-2014, 12:02 AM
Keep checking here for updates.

Earlier today the was a database corruption which lost thousands of posts. The forum was restored to an earlier point in the day - which effectively lost all the posts between the time of the last backup and the time of the restore - roughly 12 hours.

At this time - there is still a problem - "Replies" in existing threads are not registering and the time stamp for new posts created in existing threads are not being updated.

Which means, until this issue is taken care of - you'll not see a recognition of new posts in this thread either...

So, keep checking in here for any news.

dtravis7
03-16-2014, 12:15 AM
Thank You Tom for posting this.

pigoo3
03-16-2014, 12:23 AM
Thanks Tom.

- Nick

chscag
03-16-2014, 12:31 AM
Thanks Tom. Let's hope they get it straightened out before long.

XJ-linux
03-16-2014, 12:49 AM
Restoring databases is always a fun rabbit hole to go down. Best wishes to those working out the kinks. Not sure what your restore method is, but I'm sure it will work out eventually.

bobtomay
03-16-2014, 09:16 AM
Sent another email off.

My 2 previous posts this morning did indeed update the Replies & Last Post inside the forum and updated the 'Today's Posts' link - but I still see no updating for anyone else's posts.

They also returned a database error, but the replies posted twice.

Also, seeing a random issue of only being able to access the 1st page of a multi-page thread.

If you're seeing other issues, let me know so I can pass it along.

Appreciate everyone's continued patience.



...
We'll see if this one updates...

edit: it did not update and posted twice.

iNet: Here is the database error:


Database error in vBulletin 3.8.7:

Invalid SQL:

INSERT INTO postlog
(postid, useragent, ip, dateline)
VALUES
(1572434, 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_2) AppleWebKit/537.74.9 (KHTML, like Gecko) Version/7.0.2 Safari/537.74.9', 1182457143, 1394972169);

MySQL Error : Duplicate entry '1572434' for key 'PRIMARY'
Error Number : 1062
Request Date : Sunday, March 16th 2014 @ 08:16:09 AM
Error Date : Sunday, March 16th 2014 @ 08:16:09 AM
Script : http://www.mac-forums.com/forums/newreply.php?do=postreply&t=309498
Referrer : http://www.mac-forums.com/forums/news-community-announcements/309498-read-thread-forum-database-issues.html
IP Address : xx.xxx.xx.x
Username : bobtomay
Classname : vB_Database
MySQL Version : 5.5.35-33.0-log

bobtomay
03-16-2014, 09:27 AM
Well, it did update - several minutes later.

And no error on this reply and only a single post.

TattooedMac
03-16-2014, 09:29 AM
Thanks Tom, I felt something amiss, as it felt empty today in here, with no updates, or in my CP.

Will keep a eye on your updates. Bookmarked incase its not working properly

bobtomay
03-16-2014, 09:33 AM
TM, are you seeing your posts update?

I'm seeing my posts update the 'Todays Posts' link - but yours are not.

edit:
Apparently, it's just taking a few minutes - now I can see your post has updated, but mine is not showing.

dtravis7
03-16-2014, 09:54 AM
Tom, thanks for following through on this. This is the first time since the DB issue I got posts in New Posts!

bobtomay
03-16-2014, 10:07 AM
Yeah, I haven't seen either yours or Bryan's posts update here.

vansmith
03-16-2014, 10:08 AM
Now for the technical (as best I can): each post is stored in a row in a database (think of a row in an Excel or Numbers document). Each row has multiple columns that need to be filled in with values. In the post by bobtomay, this includes a post id, a user agent string, an ip, and a date (this goes for all people but I'll use his post with the error as an example). One of these columns has to have a value that no other row has which, according to the error, is the post id column. This makes sense - people can have the same IP, user agent and can post at exactly the same time but each post is unique so each row will have a unique post id. This is why the post id is a 'primary key.'

The error is quite simple: it's effectively saying that the post id for bobtomay's post is the same as another in the database. In other words, his post id is the same as someone else's. This throws an error since his post id has to be unique (otherwise, his post would overwrite someone else's).

Think of it this way - people in a country can share a birthday, a name, an address, etc. but no two people can share something like a passport number. In this error, bobtomay's post is sent to the database with the same "passport number" as someone else which throws an error.

In case anyone wanted to know.

RavingMac
03-16-2014, 10:28 AM
I am seeing new posts now

RavingMac
03-16-2014, 10:30 AM
This posted . . . though I immediately got the 'Database Error' page. So, obviously still having problems.

XJ-linux
03-16-2014, 12:16 PM
Oddly enough, when I go to "Control Panel" > "List Subscriptions" link, I only see two subscriptions for threads that were started on the 14th. I should normally have about 800+ subscribed threads. Just an FYI in case it is systemic and not just me.

dtravis7
03-16-2014, 12:41 PM
Oddly enough, when I go to "Control Panel" > "List Subscriptions" link, I only see two subscriptions for threads that were started on the 14th. I should normally have about 800+ subscribed threads. Just an FYI in case it is systemic and not just me.

Just checked and I have at least 1000. Only Two are showing here also.

dtravis7
03-16-2014, 12:43 PM
Also there are now two pages to this thread. I just posted something but if I click 2 it still loads the first page!

dtravis7
03-16-2014, 01:09 PM
Now it opened page 2.

dtravis7
03-16-2014, 01:16 PM
I just checked and it's showing 46 Subscriptions. Less than I had but better!

bobtomay
03-16-2014, 01:25 PM
Mat has restored a backup of the postlog table which still threw up some errors and has now started an update on all the counters on the forum which can take a few hours. Looks as though we're getting closer to normal.

dtravis7
03-16-2014, 01:31 PM
Mat has restored a backup of the postlog table which still threw up some errors and has now started an update on all the counters on the forum which can take a few hours. Looks as though we're getting closer to normal.

Yes, it's getting back to normal! I got an email for your reply!! Thanks to Mat for all his hard work.

chscag
03-16-2014, 03:44 PM
Looks good here Dennis and Tom. This is the first time I've been able to access a thread on page 2.

XJ-linux
03-16-2014, 04:00 PM
I can see and select page 2 of this thread as well. Also, I can see all 836 of my subscribed threads in my Control Panel. Three of those threads showed us as having new posts since I last checked them which is "normal" as well. Good job!

bobtomay
03-16-2014, 07:30 PM
'Subscribed threads' was also restored to an early Saturday morning backup.

dtravis7
03-16-2014, 08:01 PM
All my subscriptions are back also! Again, thank you Mat and company!!!

chscag
03-16-2014, 08:03 PM
Hey Dennis, the only thing I subscribe to is MacWorld Magazine and Prophecy In The News..... ;D

Glad to see we're back to normal. Thanks Mat and Tom!

dtravis7
03-16-2014, 08:04 PM
Hey Dennis, the only thing I subscribe to is MacWorld Magazine and Prophecy In The News..... ;D

Glad to see we're back to normal. Thanks Mat and Tom!

Boo, Hiss! :D Grin

pigoo3
03-16-2014, 10:49 PM
Things are certainly looking & feeling much better than yesterday at this time!!!:)

- Nick

dtravis7
03-17-2014, 01:15 AM
All seems back to normal for me.

TattooedMac
03-17-2014, 02:52 AM
TM, are you seeing your posts update?

I'm seeing my posts update the 'Todays Posts' link - but yours are not.

edit:
Apparently, it's just taking a few minutes - now I can see your post has updated, but mine is not showing.

Had to run out, but when I checked back, I didn't see anything. BUT


All seems back to normal for me.

I think I'm back to normal, but In my CP Subscribed Threads, I just had a weeks worth dating back to the 12th that I just had to go into and back out to rid of them.
I didn't get a update from this thread, I had to come a looking to find it, to post. . . .

Lets see if these row and such work now :)