From Is externallinks not available for the English Wikipedia?:
I was hoping to do a query to find Flickr images on enwiki (these need to be moved to Commons). I get an error. Thanks.
View 'enwiki_p.externallinks' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
@Bstorm could this maybe be related to the column drop? I believe the views were recreated though.
I am on a train and I cannot do a simle select * on that view to check now. I can try later though.
Yes, looks like we missed it and needs to re-run it on labsdb1010 and labsdb1011:
root@neodymium:~# for i in labsdb1009 labsdb1010 labsdb1011; do echo $i ; mysql.py -h$i enwiki_p -e "select * from externallinks limit 1;";done labsdb1009 +-------+---------+------------------------------------------+-------------------------------------------+-------------------------------------------+ | el_id | el_from | el_to | el_index | el_index_60 | +-------+---------+------------------------------------------+-------------------------------------------+-------------------------------------------+ | 2 | 3850540 | http://www.housing.berkeley.edu/housing/ | http://edu.berkeley.housing.www./housing/ | http://edu.berkeley.housing.www./housing/ | +-------+---------+------------------------------------------+-------------------------------------------+-------------------------------------------+ labsdb1010 ERROR 1356 (HY000) at line 1: View 'enwiki_p.externallinks' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them labsdb1011 ERROR 1356 (HY000) at line 1: View 'enwiki_p.externallinks' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them root@neodymium:~#
Odd... Could have sworn I did those. Hitting it again. There may have been a replication lag or something that made those not get the change right away?
After @Bstorm's magic it works now!
root@neodymium:~# for i in labsdb1009 labsdb1010 labsdb1011; do echo $i ; mysql.py -h$i enwiki_p -e "select * from externallinks limit 1;";done labsdb1009 +-------+---------+------------------------------------------+-------------------------------------------+-------------------------------------------+ | el_id | el_from | el_to | el_index | el_index_60 | +-------+---------+------------------------------------------+-------------------------------------------+-------------------------------------------+ | 2 | 3850540 | http://www.housing.berkeley.edu/housing/ | http://edu.berkeley.housing.www./housing/ | http://edu.berkeley.housing.www./housing/ | +-------+---------+------------------------------------------+-------------------------------------------+-------------------------------------------+ labsdb1010 +-------+---------+------------------------------------------+-------------------------------------------+-------------------------------------------+ | el_id | el_from | el_to | el_index | el_index_60 | +-------+---------+------------------------------------------+-------------------------------------------+-------------------------------------------+ | 2 | 3850540 | http://www.housing.berkeley.edu/housing/ | http://edu.berkeley.housing.www./housing/ | http://edu.berkeley.housing.www./housing/ | +-------+---------+------------------------------------------+-------------------------------------------+-------------------------------------------+ labsdb1011 +-------+---------+------------------------------------------+-------------------------------------------+-------------------------------------------+ | el_id | el_from | el_to | el_index | el_index_60 | +-------+---------+------------------------------------------+-------------------------------------------+-------------------------------------------+ | 2 | 3850540 | http://www.housing.berkeley.edu/housing/ | http://edu.berkeley.housing.www./housing/ | http://edu.berkeley.housing.www./housing/ | +-------+---------+------------------------------------------+-------------------------------------------+-------------------------------------------+
Thanks for reporting this and thanks so much @Bstorm for getting this fixed so quickly!