Read this thread - Forum database issues

bobtomay

,
Retired Staff
Joined
Dec 22, 2006
Messages
26,561
Reaction score
677
Points
113
Location
Texas, where else?
Your Mac's Specs
15" MBP '06 2.33 C2D 4GB 10.7; 13" MBA '14 1.8 i7 8GB 10.11; 21" iMac '13 2.9 i5 8GB 10.11; 6S
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


Retired Staff
Joined
Jan 4, 2005
Messages
30,133
Reaction score
703
Points
113
Location
Modesto, Ca.
Your Mac's Specs
MacMini M-1 MacOS Monterey, iMac 2010 27"Quad I7 , MBPLate2011, iPad Pro10.5", iPhoneSE
Thank You Tom for posting this.
 

pigoo3

Well-known member
Staff member
Admin
Joined
May 20, 2008
Messages
44,210
Reaction score
1,418
Points
113
Location
U.S.
Your Mac's Specs
2017 15" MBP, 16gig ram, 1TB SSD, OS 10.15
Thanks Tom.

- Nick
 

chscag

Well-known member
Staff member
Admin
Joined
Jan 23, 2008
Messages
65,248
Reaction score
1,833
Points
113
Location
Keller, Texas
Your Mac's Specs
2017 27" iMac, 10.5" iPad Pro, iPhone 8, iPhone 11, iPhone 12 Mini, Numerous iPods, Monterey
Thanks Tom. Let's hope they get it straightened out before long.
 
Last edited by a moderator:
Joined
Jul 2, 2007
Messages
3,494
Reaction score
204
Points
63
Location
Going Galt...
Your Mac's Specs
MacBookAir5,2:10.13.6-iMac18,3:10.13.6-iPhone9,3:11.4.1
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.
 
OP
bobtomay

bobtomay

,
Retired Staff
Joined
Dec 22, 2006
Messages
26,561
Reaction score
677
Points
113
Location
Texas, where else?
Your Mac's Specs
15" MBP '06 2.33 C2D 4GB 10.7; 13" MBA '14 1.8 i7 8GB 10.11; 21" iMac '13 2.9 i5 8GB 10.11; 6S
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:

Code:
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        : [url]http://www.mac-forums.com/forums/newreply.php?do=postreply&t=309498[/url]
Referrer      : [url]http://www.mac-forums.com/forums/news-community-announcements/309498-read-thread-forum-database-issues.html[/url]
IP Address    : xx.xxx.xx.x
Username      : bobtomay
Classname     : vB_Database
MySQL Version : 5.5.35-33.0-log
 
OP
bobtomay

bobtomay

,
Retired Staff
Joined
Dec 22, 2006
Messages
26,561
Reaction score
677
Points
113
Location
Texas, where else?
Your Mac's Specs
15" MBP '06 2.33 C2D 4GB 10.7; 13" MBA '14 1.8 i7 8GB 10.11; 21" iMac '13 2.9 i5 8GB 10.11; 6S
Well, it did update - several minutes later.

And no error on this reply and only a single post.
 
Joined
May 19, 2009
Messages
8,428
Reaction score
295
Points
83
Location
Waiting for a mate . . .
Your Mac's Specs
21" iMac 2.9Ghz 16GB RAM - 10.11.3, iPhone6s & iPad Air 2 - iOS 9.2.1, ATV 4Th Gen tvOS, ATV3
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
 
OP
bobtomay

bobtomay

,
Retired Staff
Joined
Dec 22, 2006
Messages
26,561
Reaction score
677
Points
113
Location
Texas, where else?
Your Mac's Specs
15" MBP '06 2.33 C2D 4GB 10.7; 13" MBA '14 1.8 i7 8GB 10.11; 21" iMac '13 2.9 i5 8GB 10.11; 6S
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


Retired Staff
Joined
Jan 4, 2005
Messages
30,133
Reaction score
703
Points
113
Location
Modesto, Ca.
Your Mac's Specs
MacMini M-1 MacOS Monterey, iMac 2010 27"Quad I7 , MBPLate2011, iPad Pro10.5", iPhoneSE
Tom, thanks for following through on this. This is the first time since the DB issue I got posts in New Posts!
 
OP
bobtomay

bobtomay

,
Retired Staff
Joined
Dec 22, 2006
Messages
26,561
Reaction score
677
Points
113
Location
Texas, where else?
Your Mac's Specs
15" MBP '06 2.33 C2D 4GB 10.7; 13" MBA '14 1.8 i7 8GB 10.11; 21" iMac '13 2.9 i5 8GB 10.11; 6S
Yeah, I haven't seen either yours or Bryan's posts update here.
 

vansmith

Senior Member
Joined
Oct 19, 2008
Messages
19,924
Reaction score
559
Points
113
Location
Queensland
Your Mac's Specs
Mini (2014, 2018, 2020), MBA (2020), iPad Pro (2018), iPhone 13 Pro Max, Watch (S6)
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

Well-known member
Staff member
Moderator
Joined
Jan 7, 2008
Messages
8,303
Reaction score
242
Points
63
Location
In Denial
Your Mac's Specs
16Gb Mac Mini 2018, 15" MacBook Pro 2012 1 TB SSD
I am seeing new posts now
 

RavingMac

Well-known member
Staff member
Moderator
Joined
Jan 7, 2008
Messages
8,303
Reaction score
242
Points
63
Location
In Denial
Your Mac's Specs
16Gb Mac Mini 2018, 15" MacBook Pro 2012 1 TB SSD
This posted . . . though I immediately got the 'Database Error' page. So, obviously still having problems.
 
Joined
Jul 2, 2007
Messages
3,494
Reaction score
204
Points
63
Location
Going Galt...
Your Mac's Specs
MacBookAir5,2:10.13.6-iMac18,3:10.13.6-iPhone9,3:11.4.1
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


Retired Staff
Joined
Jan 4, 2005
Messages
30,133
Reaction score
703
Points
113
Location
Modesto, Ca.
Your Mac's Specs
MacMini M-1 MacOS Monterey, iMac 2010 27"Quad I7 , MBPLate2011, iPad Pro10.5", iPhoneSE
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


Retired Staff
Joined
Jan 4, 2005
Messages
30,133
Reaction score
703
Points
113
Location
Modesto, Ca.
Your Mac's Specs
MacMini M-1 MacOS Monterey, iMac 2010 27"Quad I7 , MBPLate2011, iPad Pro10.5", iPhoneSE
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


Retired Staff
Joined
Jan 4, 2005
Messages
30,133
Reaction score
703
Points
113
Location
Modesto, Ca.
Your Mac's Specs
MacMini M-1 MacOS Monterey, iMac 2010 27"Quad I7 , MBPLate2011, iPad Pro10.5", iPhoneSE
Now it opened page 2.
 

dtravis7


Retired Staff
Joined
Jan 4, 2005
Messages
30,133
Reaction score
703
Points
113
Location
Modesto, Ca.
Your Mac's Specs
MacMini M-1 MacOS Monterey, iMac 2010 27"Quad I7 , MBPLate2011, iPad Pro10.5", iPhoneSE
I just checked and it's showing 46 Subscriptions. Less than I had but better!
 
OP
bobtomay

bobtomay

,
Retired Staff
Joined
Dec 22, 2006
Messages
26,561
Reaction score
677
Points
113
Location
Texas, where else?
Your Mac's Specs
15" MBP '06 2.33 C2D 4GB 10.7; 13" MBA '14 1.8 i7 8GB 10.11; 21" iMac '13 2.9 i5 8GB 10.11; 6S
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.
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top