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

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptOct 24 2017, 8:08 AM
Marostegui added a subscriber: Marostegui.

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.

Reedy added a comment.Oct 24 2017, 8:50 AM

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

Reedy added a comment.Oct 24 2017, 9:00 AM

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)
Reedy added a comment.Oct 24 2017, 9:12 AM

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?

ArielGlenn moved this task from Backlog to Active on the Dumps-Generation board.Oct 24 2017, 11:47 AM
Reedy claimed this task.Oct 24 2017, 11:58 AM
ArielGlenn closed this task as Resolved.Oct 24 2017, 12:32 PM

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.

ArielGlenn moved this task from Active to Done on the Dumps-Generation board.Nov 6 2017, 1:30 PM