Skip to main content
deleted 17 characters in body
Source Link
Aaron Bertrand Staff
  • 43.5k
  • 11
  • 113
  • 206

We have identified and resolved the root cause, which was related to a schema change on a base table that wasn't reflected in a view against that table.

Basically, a string column involving review task comments was made wider, but the view that feeds SEDE still thought it was shorter. A comment in the review queue for Buddhism (which exceeded the old length) was entered in the meantime, but this incompatibility wasn't spotted because the only views against it are the ones for SEDE.

  • Buddhism has been corrected manually and is now complete.
  • We are currently kicking off the remainder of the databases, which will take about 8 hours. Note: Stack Overflow takes the longest, and had a failure overnight, so add another ~8 hours fromfinished Sep 20 @ ~16~22:3607 UTC.
  • We have created a task internally to automatically refresh all SEDE-related views prior to the weekly refresh task.

We have identified and resolved the root cause, which was related to a schema change on a base table that wasn't reflected in a view against that table.

Basically, a string column involving review task comments was made wider, but the view that feeds SEDE still thought it was shorter. A comment in the review queue for Buddhism (which exceeded the old length) was entered in the meantime, but this incompatibility wasn't spotted because the only views against it are the ones for SEDE.

  • Buddhism has been corrected manually and is now complete.
  • We are currently kicking off the remainder of the databases, which will take about 8 hours. Note: Stack Overflow takes the longest, and had a failure overnight, so add another ~8 hours from Sep 20 @ ~16:36 UTC.
  • We have created a task internally to automatically refresh all SEDE-related views prior to the weekly refresh task.

We have identified and resolved the root cause, which was related to a schema change on a base table that wasn't reflected in a view against that table.

Basically, a string column involving review task comments was made wider, but the view that feeds SEDE still thought it was shorter. A comment in the review queue for Buddhism (which exceeded the old length) was entered in the meantime, but this incompatibility wasn't spotted because the only views against it are the ones for SEDE.

  • Buddhism has been corrected manually and is now complete.
  • We are currently kicking off the remainder of the databases, which will take about 8 hours. Note: Stack Overflow takes the longest, and had a failure overnight, so finished Sep 20 @ ~22:07 UTC.
  • We have created a task internally to automatically refresh all SEDE-related views prior to the weekly refresh task.
added 96 characters in body
Source Link
Aaron Bertrand Staff
  • 43.5k
  • 11
  • 113
  • 206

We have identified and resolved the root cause, which was related to a schema change on a base table that wasn't reflected in a view against that table.

Basically, a string column involving review task comments was made wider, but the view that feeds SEDE still thought it was shorter. A comment in the review queue for Buddhism (which exceeded the old length) was entered in the meantime, but this incompatibility wasn't spotted because the only views against it are the ones for SEDE.

  • Buddhism has been corrected manually and is now complete.
  • We are currently kicking off the remainder of the databases, which will take about 8 hours. Note: Stack Overflow takes the longest, and had a failure overnight, so add another ~8 hours from Sep 20 @ ~16:36 UTC.
  • We have created a task internally to automatically refresh all SEDE-related views prior to the weekly refresh task.

We have identified and resolved the root cause, which was related to a schema change on a base table that wasn't reflected in a view against that table.

Basically, a string column involving review task comments was made wider, but the view that feeds SEDE still thought it was shorter. A comment in the review queue for Buddhism (which exceeded the old length) was entered in the meantime, but this incompatibility wasn't spotted because the only views against it are the ones for SEDE.

  • Buddhism has been corrected manually and is now complete.
  • We are currently kicking off the remainder of the databases, which will take about 8 hours.
  • We have created a task internally to automatically refresh all SEDE-related views prior to the weekly refresh task.

We have identified and resolved the root cause, which was related to a schema change on a base table that wasn't reflected in a view against that table.

Basically, a string column involving review task comments was made wider, but the view that feeds SEDE still thought it was shorter. A comment in the review queue for Buddhism (which exceeded the old length) was entered in the meantime, but this incompatibility wasn't spotted because the only views against it are the ones for SEDE.

  • Buddhism has been corrected manually and is now complete.
  • We are currently kicking off the remainder of the databases, which will take about 8 hours. Note: Stack Overflow takes the longest, and had a failure overnight, so add another ~8 hours from Sep 20 @ ~16:36 UTC.
  • We have created a task internally to automatically refresh all SEDE-related views prior to the weekly refresh task.
added 50 characters in body
Source Link
Aaron Bertrand Staff
  • 43.5k
  • 11
  • 113
  • 206

We have identified and resolved the root cause, which was related to a schema change on a base table that wasn't reflected in a view against that table.

Basically, a string column involving review task comments was made widera string column involving review task comments was made wider, but the view that feeds SEDE still thought it was shorter. A comment in the review queue for Buddhism (which exceeded the old length) was entered in the meantime, but this incompatibility wasn't spotted because the only views against it are the ones for SEDE.

  • Buddhism has been corrected manually and is now complete.
  • We are currently kicking off the remainder of the databases, which will take about 8 hours.
  • We have created a task internally to automatically refresh all SEDE-related views prior to the weekly refresh task.

We have identified and resolved the root cause, which was related to a schema change on a base table that wasn't reflected in a view against that table.

Basically, a string column involving review task comments was made wider, but the view that feeds SEDE still thought it was shorter. A comment in the review queue for Buddhism (which exceeded the old length) was entered in the meantime, but this incompatibility wasn't spotted because the only views against it are the ones for SEDE.

  • Buddhism has been corrected manually and is now complete.
  • We are currently kicking off the remainder of the databases, which will take about 8 hours.
  • We have created a task internally to automatically refresh all SEDE-related views prior to the weekly refresh task.

We have identified and resolved the root cause, which was related to a schema change on a base table that wasn't reflected in a view against that table.

Basically, a string column involving review task comments was made wider, but the view that feeds SEDE still thought it was shorter. A comment in the review queue for Buddhism (which exceeded the old length) was entered in the meantime, but this incompatibility wasn't spotted because the only views against it are the ones for SEDE.

  • Buddhism has been corrected manually and is now complete.
  • We are currently kicking off the remainder of the databases, which will take about 8 hours.
  • We have created a task internally to automatically refresh all SEDE-related views prior to the weekly refresh task.
In 8 hours it would be late night here (2 am) and same for many other people. :-)
Source Link
Shadow Wizard
  • 175k
  • 33
  • 437
  • 864
Loading
Source Link
Aaron Bertrand Staff
  • 43.5k
  • 11
  • 113
  • 206
Loading