Page MenuHomePhabricator

maiwiki: s3.labsdb server alias maiwiki.labsdb missing in /etc/hosts
Closed, ResolvedPublic

Description

my bot found maiwiki at meta_p and tried to start running queries, but this fails.

name value must be 'Wikipedia' but name is currently a char sequenze repeating hex E0A4B5

MariaDB [(none)]> select *, hex(name) from meta_p.wiki where dbname like 'mai%';
+---------+------+------------+-----------+--------------------------+------+-----------+-----------+----------+-----------------+------------------+--------------+--------------------------------------------------------------+
| dbname  | lang | name       | family    | url                      | size | slice     | is_closed | has_echo | has_flaggedrevs | has_visualeditor | has_wikidata |                                                    hex(name) | 
+---------+------+------------+-----------+--------------------------+------+-----------+-----------+----------+-----------------+------------------+--------------+--------------------------------------------------------------+
| maiwiki | mai  | ?????????? | wikipedia | http://mai.wikipedia.org |    1 | s3.labsdb |         0 |        1 |               0 |                1 |            1 | E0A4B5E0A4BFE0A495E0A4BFE0A4AAE0A4BFE0A4A1E0A4BFE0A4AFE0A4BE |
+---------+------+------------+-----------+--------------------------+------+-----------+-----------+----------+-----------------+------------------+--------------+--------------------------------------------------------------+
1 row in set (0.00 sec)

maiwiki.labsdb missing in /etc/hosts

$ mysql -hmaiwiki.labsdb
ERROR 2005 (HY000): Unknown MySQL server host 'maiwiki.labsdb' (0)

Event Timeline

Merl assigned this task to coren.
Merl raised the priority of this task from to High.
Merl updated the task description. (Show Details)
Merl changed Security from none to None.
Merl added a subscriber: Merl.

The data of the meta table is mostly filled by the maintain-replicas script from API queries to the actual wiki proper; what I see when I query the table manually is 'विकिपिडिया' which is, as far as I can tell, the correct name for the project in that language. The value in hexadecimal is also correct; it /appears/ to repeat itself because those are Unicode codepoints are on a high codepoint plane and the utf8 encoding has a long prefix for every character. Notice:

E0A4B5E0A4BFE0A495...

In other words, this works as designed. You may want to use 'family' if you want to test for Wikipedia-ness rather than 'name' which is meant for display to endusers. This is true even in European languages since, for example, frwiki would have 'Wikipédia' (note the accent) in the name column.

Ok, but the dns problem still exists:

tools.merlbot@tools-dev:~/lists/qs$ mysql -hmaiwiki.labsdb
ERROR 2005 (HY000): Unknown MySQL server host 'maiwiki.labsdb' (0)
coren renamed this task from maiwiki: s3.labsdb server alias maiwiki.labsdb missing in /etc/hosts and wrong name value in meta__p to maiwiki: s3.labsdb server alias maiwiki.labsdb missing in /etc/hosts.Nov 25 2014, 4:53 PM
coren moved this task from Triage to In Progress on the Toolforge board.

The hosts files have been updated accross tools.