Page MenuHomePhabricator

fix flow table issue on techconductwiki
Closed, ResolvedPublic

Description

According to the configs and according to T165977, techconductwiki should have the Flow extension enabled, and it is listed in the flow.dblist accordingly. However, attempting to dump FLow content gives the following:

[59aec57791f1397c2fa7b0b0] [no req]   Wikimedia\Rdbms\DBQueryError from line 1167 of /srv/mediawiki/php-1.31.0-wmf.4/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 
Query: SELECT  *  FROM `flow_workflow`    WHERE workflow_wiki = 'techconductwiki' AND workflow_type = 'discussion'  ORDER BY workflow_id ASC LIMIT 300  
Function: BatchRowIterator::next
Error: 1146 Table 'techconductwiki.flow_workflow' doesn't exist (10.64.16.191)

Can someone have a look?

Event Timeline

Marostegui subscribed.

I guess you might need to talk to the people that created the wiki (T165977), as this is not something the DBAs can do or fix.
If the table is missing it can be created anytime: https://wikitech.wikimedia.org/wiki/Schema_changes#What_is_not_a_schema_change

Thanks, I am tagging @Dereckson and @Reedy on this in that case.

Was it in the dblist before creation? I'll look in an hour or so when I get onto a computer

Should be easy to fix

I wonder if tables are on extension1, but config looks for it locally...

This is an x1 slave so it doesn't look so:

root@db1029[techconductwiki]> show tables;
+---------------------------+
| Tables_in_techconductwiki |
+---------------------------+
| echo_email_batch          |
| echo_event                |
| echo_notification         |
| echo_target_page          |
+---------------------------+
4 rows in set (0.00 sec)

It'll be an easy fix when I have my laptop and internet ;)

Curious. https://github.com/wikimedia/mediawiki-extensions-WikimediaMaintenance/blob/master/addWiki.php doesn't add Flow tables at all, just initialises the store based on $wgFlowExternalStore, which is

> var_dump( $wgFlowExternalStore );
array(2) {
  [0]=>
  string(14) "DB://cluster24"
  [1]=>
  string(14) "DB://cluster25"
}

Soo...

reedy@tin:~$ mwscript extensions/WikimediaMaintenance/createExtensionTables.php --wiki=techconductwiki Flow
Creating Flow tables...done!
reedy@tin:~$

Resolved now?

Much better. The tables have been dumped! They are empty of course, but that's beside the point. Closing this and thanks!

Can't be much talking going on on the techconductwiki then xD

Can't be much talking going on on the techconductwiki then xD

Which is probably a good thing :)

Indeed, I confirm there is no current Flow topic on this wiki.