[00:28:34] !log tools.wikibugs Updated channels.yaml to: 6687ebb2a6dc348504af31c8766820eb529cfbf7 Notify analytics for schema changes [00:28:36] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.wikibugs/SAL [09:30:58] Hi. I am using PAWS to access dbs and I find some differences when I run `show databases;` from PAWS and toolforge. I am ultimately going to run stuff in toolforge, just using PAWS for experiemntation. [09:30:58] for example `use toolsdb; show databases;` in tolforge shows all dbs like `uxxxx__dbname_p` but from PAWS connecting to any db (tools, enwiki, meta etc) shows the same list of dbs and none of the user dbs. [09:30:58] I am using [09:30:58] ``` [09:30:58] conn = toolforge.connect( [09:30:59] host=os.environ['MYSQL_HOST'], [09:30:59] user=os.environ['MYSQL_USERNAME'], [09:31:00] password=os.environ['MYSQL_PASSWORD'], [09:31:00] dbname=dbname, [09:31:01] charset='utf8') [09:31:01] ``` [09:31:02] to connect from PAWS. [09:31:02] any idea why I am getting different results and what may I do to get results like toolforge in PAWS? [09:43:58] Hi tanny411, not all databases are in all hosts, and you should not expect so either as that makes it really hard to maintain and scale any database. With that in mind, what is it that you are trying to get done? [09:46:21] Hi, I am trying to get info about all the Scribunto modules from all the databases, as part of the abstract Wikipedia project, for which I needed to list the databases first. And then I would store the required info in a user database in would later create for analysis purposes [09:47:28] But connecting to toolsdb from PAWS gives the same list of dbs as any other. Thats where I was confused. [10:11:51] tanny411: what is the value of your MYSQL_HOST? it should be tools.db.svc.eqiad.wmflabs (https://wikitech.wikimedia.org/wiki/Help:Toolforge/Database#User_databases) [10:19:53] btw. more info on the multi-database arch and how to work with it: https://wikitech.wikimedia.org/wiki/News/Wiki_Replicas_2020_Redesign#I_have_a_tool_that_queries_all_of_the_wikis_and_I_use_only_one_connection [10:48:16] !log toolsbeta rebase & resolve ugly git merge conflict in labs/private.git [10:48:19] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Toolsbeta/SAL [10:53:01] !log tools rebase & resolve ugly git merge conflict in labs/private.git [10:53:04] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL [11:16:09] !log tools.lexeme-forms deployed 6e1185532d (Basque adjective) [11:16:11] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools.lexeme-forms/SAL [11:18:18] dcaro: I think i understand whats going on now. my host value was '10.100.199.204', which I suppose I should change everytime I connect to a different db. Thanks for the link, It helps! [11:19:49] tanny411: glad to help :), just a note, try using names instead if ips, that way if for whatever reason the ip changes (that might happen), you will not need to change any code and it will still work ;) [11:26:59] Thanks [13:51:26] !log merged patch to move wikidumpparse backups to cloudvirt1025 to free space on cloudvirt1026 [13:51:27] dcaro: Unknown project "merged" [13:51:34] !log admin merged patch to move wikidumpparse backups to cloudvirt1025 to free space on cloudvirt1026 [13:51:35] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Admin/SAL [13:51:36] xd [14:22:41] xd [15:30:05] !log admin cleaning up 6778 dangling snapshots for glance images in eqiad (T270478) [15:30:07] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Admin/SAL [15:30:08] T270478: [ceph] Make sure rbd snapshots are being cleaned up - https://phabricator.wikimedia.org/T270478 [18:22:06] !log tools rebooting the grid master because it is misbehaving following the NFS outage [18:22:09] Logged the message at https://wikitech.wikimedia.org/wiki/Nova_Resource:Tools/SAL