In T415031#11536882, @Marostegui wrote:

Let us know when the wiki is created so we can sanitize it

Done.

Heads-up: Something did not go well when creating it (T415555 happened, but it seems to be for a feature that is not enabled). I pinged the owning team about that ticket, but I figure DBAs should know too.

wikiadmin2023 doesn't have ALTER table grants. Why would it need that now? We've not touched grants for two years.

Section s5: Wikis kajwiki redacted - marostegui@cumin1003

In T415031#11554438, @Marostegui wrote:

wikiadmin2023 doesn't have ALTER table grants. Why would it need that now? We've not touched grants for two years.

Very good question. I do not know, and I agree it is not supposed to have the ALTER grant. Probably, the table definition (that is loaded on-creation) has an ALTER somewhere, because the developer who added it didn't know it's not allowed (the feature seems to be very new, so this seems to be plausible). I hope we'll answer that question on the other ticket.

Thanks - I am sanitizing the data now. Do you think you'll have to recreate it or something? Because if yes, then I will not send this for views creation yet.

Section s5: Wikis kajwiki set up on clouddb - marostegui@cumin1003

In T415031#11554485, @Marostegui wrote:

Do you think you'll have to recreate it or something? Because if yes, then I will not send this for views creation yet.

If by "recreate" you mean drop and start all over, definitely not. As far as I can see, no tables are missing. My understanding is that this table isn't used on kajwiki and shouldn't be there at all, but I'll let PSI confirm.

In any case, the only error I encountered happened during x1 provisioning. All other databases should be fine. IIRC, x1 doesn't have any views, so...sending this for views creation might be OK? But you know more about this than I do :)

If only x1 is involved in the issue, then we can go ahead and create the views. As you mention, indeed, we do not have anything x1 related on wikireplicas.