The database was created.

I'm getting this:

root@db1154:~# for i in vewikimedia; do echo $i; redact_sanitarium.sh -d $i -S /run/mysqld/mysqld.s5.sock | mysql -S /run/mysqld/mysqld.s5.sock $i ; done
vewikimedia

But then:

root@db1154:~# check_private_data.py -S /run/mysqld/mysqld.s5.sock
-- Non-public databases that are present:
DROP DATABASE IF EXISTS `vewikimedia`;
-- Non-public tables that are present:
-- Unfiltered columns that are present:

I think there is something wrong?

(Possibly because it's fishbowl wiki?)

I guess it's due to this wiki having existed in the past, then being deleted and now being recreated. So probably we have some remnants from back then.

I don't know if that's the reason but it needs fixing regardless, it's in https://gerrit.wikimedia.org/g/operations/mediawiki-config/+/ba364eb6dc99aa6d81ab7255a3411608401d8400/dblists/deleted.dblist

Removed from the dblist: https://gerrit.wikimedia.org/r/c/operations/mediawiki-config/+/892566/

I still see it, I need to figure out where does this come from

I guess mw-config needs to be updated in db1154, we can wait for a bit: https://gerrit.wikimedia.org/g/operations/puppet/+/3311226c98544255063d0d8f10828ca85cf05154/modules/role/files/mariadb/check_private_data.py

Is it in private.dblist too? just checking

In T330704#8650904, @Ladsgroup wrote:

I guess mw-config needs to be updated in db1154, we can wait for a bit: https://gerrit.wikimedia.org/g/operations/puppet/+/3311226c98544255063d0d8f10828ca85cf05154/modules/role/files/mariadb/check_private_data.py

yep, it uses Git::Clone, which can take a bit (a puppet run?).

Is it in private.dblist too? just checking

nope

Awesome, ran puppet agent and now it's clean:

root@db1154:~# check_private_data.py -S /run/mysqld/mysqld.s5.sock
-- Non-public databases that are present:
-- Non-public tables that are present:
-- Unfiltered columns that are present:
root@db1154:~#

This looks clean and the grants are added GRANT SELECT, SHOW VIEW ON as well as the _p database. This is ready for the views creation

Mentioned in SAL (#wikimedia-operations) [2023-04-25T15:02:00Z] <btullis@cumin1001> Added views for new wiki: vewikimedia T330704