Page MenuHomePhabricator

Queriing enwiki_p.externallinks access is denied
Closed, ResolvedPublic

Description

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

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptSep 21 2018, 3:53 PM
Marostegui added subscribers: Bstorm, Marostegui.EditedSep 21 2018, 3:59 PM

@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.

Marostegui added a comment.EditedSep 21 2018, 4:08 PM

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?

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?

Yeah, that could be a possibility as well.

Marostegui closed this task as Resolved.Sep 21 2018, 4:12 PM
Marostegui assigned this task to Bstorm.

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!