Solved posts out of order

[rjohns39]

BYC is broken. doesn't matter who posts this morning, their post get's randomly stuck somewhere in the thread. For example, I just posted in Debby's thread and my post was placed before 6:45 yesterday. This appears to be happening consistently across all threads.

 

[MattW]

I know why it's happening now. A thread knows it's first and last post ID, so when we restored certain tables information from yesterday, it also reset these values, so when people started posting again today, the posts are being marked with the post positions following on from the previously known "last post number", which is now creating the issue with posts out of order.

The rebuild will recalculate the correct values and positions for the posts in the thread, based on the post date / time.

 

[MattW]

It's the same for everyone. Until I confirm the rebuild has been run and finished, it will still be happening. There are 1.4 million threads that need to be rebuilt.

 

[MattW]

Not rushing you! It must be really hard work. Good job

Your thread is done, and the whole rebuild is now completed.

 

[Painted Calls]

This will be my last post in public until it's sorted out. I feel bad for Matt having to try and fix a problem that he warned would happen if he tried to fix the minor issue from yesterday. Emojis are missing. Oh well. Now the entire forum is jacked.

Hope you get everything sorted out with the least amount of frustration possible @MattW!

 

[MattW]

Rebuild is underway.

 

[Nifty-Chicken]

Excellent work (as always) @MattW !!!

... and thanks to our community for their help and patience!!

(For the record: we keep about 180 days of database backups as well as distributing backups over 6 hard-drives across multiple servers, networks, hosts, and geographic locations... so even in a "worst-case" scenario, we'd roll-back to the most recent clean backup of BYC and restore to that )

 

[MattW]

I'm looking into it now. This could have been caused by what we had to do with regards to fixing the emoji issues, as we had to re-import all the old posts from before the server migration.

 

[MattW]

The rebuild does appear to be fixing the issue:

https://www.backyardchickens.com/threads/the-nfc-b-day-chat-thread.1050266/page-10315

Posts in that thread are now in the correct order.

 

[Kiki]

Rebuild is underway.

Thanks Matt!