Skip to main content
Server Fault

Return to Answer

replaced http://meta.stackexchange.com/ with https://meta.stackexchange.com/
Source Link
Community Bot
Community Bot
  • 1

After digging out SEDE once more , I found some explanation why this happened. But still I need SE-dev to finding the root cause of this inconsistency.

Inconsistency when viewing and editing post

The source of the problem lies in dual data source when you edit and view the post. When you view the post, web page pull data from rendered content (with HTML form) in Posts table . But when you edit it, web page pull data from raw content (with Markdown form) in PostHistory table. Normally, when you submit the post, both table updated with same databoth table updated with same data (but different forms). Unfortunately sometimes these two data can be out of sync, like this case.

To prove this, I wrote a query in SEDE to compares actual tags saved in PostTags table and raw tags recorded in PostHistory table. The result almost ~350 questions in Server Fault have this inconsistency. Almost all questions have in its PostHistory entry although it has been converted to another tag in PostTags table.

My hypotesis is when Jeff Atwood "manually" converted to another , something wrong happened

  1. He forgot to update PostHistory table :(
  2. He didn't forgot to update PostHistory table but in the next-day one of fellow dev rollback the database :(

As for the solution for this kind of "bug": It can be fixed quickly by SE-developers. Of cource we I can manually edit it, but it'll bump many questions in frontpage.

Additional note:

So, this event has happened in the past too. Especially when image links has been convertedimage links has been converted from i.imgur.com to i.sstatic.net. SE developers has been "forced" to manually baked upmanually baked up fresh post bodies so it matched the revision history version.

After digging out SEDE once more , I found some explanation why this happened. But still I need SE-dev to finding the root cause of this inconsistency.

Inconsistency when viewing and editing post

The source of the problem lies in dual data source when you edit and view the post. When you view the post, web page pull data from rendered content (with HTML form) in Posts table . But when you edit it, web page pull data from raw content (with Markdown form) in PostHistory table. Normally, when you submit the post, both table updated with same data (but different forms). Unfortunately sometimes these two data can be out of sync, like this case.

To prove this, I wrote a query in SEDE to compares actual tags saved in PostTags table and raw tags recorded in PostHistory table. The result almost ~350 questions in Server Fault have this inconsistency. Almost all questions have in its PostHistory entry although it has been converted to another tag in PostTags table.

My hypotesis is when Jeff Atwood "manually" converted to another , something wrong happened

  1. He forgot to update PostHistory table :(
  2. He didn't forgot to update PostHistory table but in the next-day one of fellow dev rollback the database :(

As for the solution for this kind of "bug": It can be fixed quickly by SE-developers. Of cource we I can manually edit it, but it'll bump many questions in frontpage.

Additional note:

So, this event has happened in the past too. Especially when image links has been converted from i.imgur.com to i.sstatic.net. SE developers has been "forced" to manually baked up fresh post bodies so it matched the revision history version.

After digging out SEDE once more , I found some explanation why this happened. But still I need SE-dev to finding the root cause of this inconsistency.

Inconsistency when viewing and editing post

The source of the problem lies in dual data source when you edit and view the post. When you view the post, web page pull data from rendered content (with HTML form) in Posts table . But when you edit it, web page pull data from raw content (with Markdown form) in PostHistory table. Normally, when you submit the post, both table updated with same data (but different forms). Unfortunately sometimes these two data can be out of sync, like this case.

To prove this, I wrote a query in SEDE to compares actual tags saved in PostTags table and raw tags recorded in PostHistory table. The result almost ~350 questions in Server Fault have this inconsistency. Almost all questions have in its PostHistory entry although it has been converted to another tag in PostTags table.

My hypotesis is when Jeff Atwood "manually" converted to another , something wrong happened

  1. He forgot to update PostHistory table :(
  2. He didn't forgot to update PostHistory table but in the next-day one of fellow dev rollback the database :(

As for the solution for this kind of "bug": It can be fixed quickly by SE-developers. Of cource we I can manually edit it, but it'll bump many questions in frontpage.

Additional note:

So, this event has happened in the past too. Especially when image links has been converted from i.imgur.com to i.sstatic.net. SE developers has been "forced" to manually baked up fresh post bodies so it matched the revision history version.

replaced http://meta.serverfault.com/ with https://meta.serverfault.com/
Source Link
Community Bot
Community Bot
  • 1

After digging out SEDE once more , I found some explanation why this happened. But still I need SE-dev to finding the root cause of this inconsistency.

Inconsistency when viewing and editing post

The source of the problem lies in dual data source when you edit and view the post. When you view the post, web page pull data from rendered content (with HTML form) in Posts table . But when you edit it, web page pull data from raw content (with Markdown form) in PostHistory table. Normally, when you submit the post, both table updated with same data (but different forms). Unfortunately sometimes these two data can be out of sync, like this case.

To prove this, I wrote a query in SEDE to compares actual tags saved in PostTags table and raw tags recorded in PostHistory table. The result almost ~350 questions in Server Fault have this inconsistency. Almost all questions have in its PostHistory entry although it has been converted to another tag in PostTags table.

My hypotesis is when Jeff Atwood "manually" convertedJeff Atwood "manually" converted to another , something wrong happened

  1. He forgot to update PostHistory table :(
  2. He didn't forgot to update PostHistory table but in the next-day one of fellow dev rollback the database :(

As for the solution for this kind of "bug": It can be fixed quickly by SE-developers. Of cource we I can manually edit it, but it'll bump many questions in frontpage.

Additional note:

So, this event has happened in the past too. Especially when image links has been converted from i.imgur.com to i.sstatic.net. SE developers has been "forced" to manually baked up fresh post bodies so it matched the revision history version.

After digging out SEDE once more , I found some explanation why this happened. But still I need SE-dev to finding the root cause of this inconsistency.

Inconsistency when viewing and editing post

The source of the problem lies in dual data source when you edit and view the post. When you view the post, web page pull data from rendered content (with HTML form) in Posts table . But when you edit it, web page pull data from raw content (with Markdown form) in PostHistory table. Normally, when you submit the post, both table updated with same data (but different forms). Unfortunately sometimes these two data can be out of sync, like this case.

To prove this, I wrote a query in SEDE to compares actual tags saved in PostTags table and raw tags recorded in PostHistory table. The result almost ~350 questions in Server Fault have this inconsistency. Almost all questions have in its PostHistory entry although it has been converted to another tag in PostTags table.

My hypotesis is when Jeff Atwood "manually" converted to another , something wrong happened

  1. He forgot to update PostHistory table :(
  2. He didn't forgot to update PostHistory table but in the next-day one of fellow dev rollback the database :(

As for the solution for this kind of "bug": It can be fixed quickly by SE-developers. Of cource we I can manually edit it, but it'll bump many questions in frontpage.

Additional note:

So, this event has happened in the past too. Especially when image links has been converted from i.imgur.com to i.sstatic.net. SE developers has been "forced" to manually baked up fresh post bodies so it matched the revision history version.

After digging out SEDE once more , I found some explanation why this happened. But still I need SE-dev to finding the root cause of this inconsistency.

Inconsistency when viewing and editing post

The source of the problem lies in dual data source when you edit and view the post. When you view the post, web page pull data from rendered content (with HTML form) in Posts table . But when you edit it, web page pull data from raw content (with Markdown form) in PostHistory table. Normally, when you submit the post, both table updated with same data (but different forms). Unfortunately sometimes these two data can be out of sync, like this case.

To prove this, I wrote a query in SEDE to compares actual tags saved in PostTags table and raw tags recorded in PostHistory table. The result almost ~350 questions in Server Fault have this inconsistency. Almost all questions have in its PostHistory entry although it has been converted to another tag in PostTags table.

My hypotesis is when Jeff Atwood "manually" converted to another , something wrong happened

  1. He forgot to update PostHistory table :(
  2. He didn't forgot to update PostHistory table but in the next-day one of fellow dev rollback the database :(

As for the solution for this kind of "bug": It can be fixed quickly by SE-developers. Of cource we I can manually edit it, but it'll bump many questions in frontpage.

Additional note:

So, this event has happened in the past too. Especially when image links has been converted from i.imgur.com to i.sstatic.net. SE developers has been "forced" to manually baked up fresh post bodies so it matched the revision history version.

Source Link
masegaloeh
masegaloeh
  • 18.5k
  • 14
  • 17

After digging out SEDE once more , I found some explanation why this happened. But still I need SE-dev to finding the root cause of this inconsistency.

Inconsistency when viewing and editing post

The source of the problem lies in dual data source when you edit and view the post. When you view the post, web page pull data from rendered content (with HTML form) in Posts table . But when you edit it, web page pull data from raw content (with Markdown form) in PostHistory table. Normally, when you submit the post, both table updated with same data (but different forms). Unfortunately sometimes these two data can be out of sync, like this case.

To prove this, I wrote a query in SEDE to compares actual tags saved in PostTags table and raw tags recorded in PostHistory table. The result almost ~350 questions in Server Fault have this inconsistency. Almost all questions have in its PostHistory entry although it has been converted to another tag in PostTags table.

My hypotesis is when Jeff Atwood "manually" converted to another , something wrong happened

  1. He forgot to update PostHistory table :(
  2. He didn't forgot to update PostHistory table but in the next-day one of fellow dev rollback the database :(

As for the solution for this kind of "bug": It can be fixed quickly by SE-developers. Of cource we I can manually edit it, but it'll bump many questions in frontpage.

Additional note:

So, this event has happened in the past too. Especially when image links has been converted from i.imgur.com to i.sstatic.net. SE developers has been "forced" to manually baked up fresh post bodies so it matched the revision history version.