|
Title: Missing Posts Post by: Phil Thornton on January 26, 2020, 11:12:51 PM +0000 Has anyone noticed posts being deleted?
I posted in the 67F1 Junior Round 1 thread but the post is missing. However if I go to my profile and click on "Show Posts" the missing post is there and I can even click on it to quote a reply like this: Andreas I've read your report and looked at the replay, I can confirm you were dropped from the server at some point and so one of your laps wasn't registered. I've corrected the race result. There was no need for you to go to the trouble of reporting this as an incident, just a post on this race thread would have been sufficient to bring it to the moderator's attention. We can fix this sort of error without moderation. Good luck for the rest of the season ;D I think Tim and Pepe have had similar problems (See here (https://www.simracing.org.uk/smf/index.php?topic=18161.msg326582#msg326582)) has anyone else had similar issues? Title: Re: Missing Posts Post by: Dave 'Gizmo' Gymer on January 27, 2020, 08:44:58 AM +0000 How odd. The database shows that post (327722) with the correct board and topic IDs. ???
Title: Re: Missing Posts Post by: Dave 'Gizmo' Gymer on January 27, 2020, 11:00:20 AM +0000 Well, that was confusing. When SMF reads the posts for anything but the last page of a topic, it starts from the index of the first post for that page (e.g. if there are 15 posts per page, for page 1 it starts from 0, for page 2 from 15, and so on)... but when viewing the last post of a topic, it takes the number of posts it thinks are in the topic, reverses the order, and asks for what are effectively the last n posts for the topic starting from the end. If the total count for the topic is wrong (e.g. after a hardware failure when the database replicas have to be brought in line manually), it drops posts from the last page... but always keeps the final one, thus maximising confusion. ::)
The lesson is... when there's a replication failure, after bringing the databases back in line, always tell the forum to recount all the posts in the all the topics Title: Re: Missing Posts Post by: Phil Thornton on January 27, 2020, 05:46:32 PM +0000 Thanks for looking into this Giz. A pretty obsure issue, it had me doubting my sanity! Hopefully there won't be many database issues for us to worry about but if it happens again we know what to look for.
|