serlo / api.serlo.org

Public GraphQL API of https://serlo.org/
https://api.serlo.org/___graphql
Apache License 2.0
15 stars 4 forks source link

Course "logistisches Wachstum (LENABI)" is missing in staging #1517

Closed kulla closed 5 months ago

kulla commented 6 months ago

https://serlo.slack.com/archives/C062X5BJANP/p1715782665011549

elbotho commented 6 months ago

works now with this example, just created a new one and will check it tomorrow on staging.

elbotho commented 5 months ago

unfortunately it's the same issue today. the newly created entity (this time a video) does not show up. might be a staging only issue to do with the migration, but it seems api cache is still on the previous state.

kulla commented 5 months ago

Okay now it makes sense to me. This is what happens:

  1. In staging you have a taxonomy in the API cache
  2. In production you create a new entity => taxonomy in the cache gets deleted but not in staging
  3. Via DB dump the database in staging gets updated with the new entry
  4. However staging still has the old entry of the taxonomy

So this was always the case => In order to fix it we would need to do one of the following:

So luckily this is not a new bug => it was always like this. I would argue that for now we should do nothing.