Page MenuHomePhabricator

maintain-views needs to do something smarter when trying to update dbs that don't exist
Closed, ResolvedPublic

Description

<jynus> Jaime Crespo andrewbogott, I am seeing the issue
1:59 PM you are trying to run CREATE VIEW on a database that doesn't exist
1:59 PM at least on the other, newer hosts
2:00 PM DEBUG "CREATE OR REPLACE"
2:00 PM A<andrewbogott> Andrew Bogott ok… a database, or a bunch of databases?
2:00 PM J<jynus> Jaime Crespo VIEW
2:00 PM a bunch
2:00 PM all that fail
2:00 PM I have created some manually
2:00 PM I can do that
2:00 PM but the script shoudl have a "create db if not exists" or something

Event Timeline

Bstorm claimed this task.
Bstorm subscribed.

This is true and already in place, but a mariadb bug makes it not work. Therefore we have worked around it for now using process (DBAs create the database as it comes down to WMCS). It might be fixed in 10.3 (in which case, this is very done!)