Why aren't those tables part of the federated version?

Change 123916 had a related patch set uploaded by coren:
Labs: automate federated table maintenance

https://gerrit.wikimedia.org/r/123916

Change 123916 merged by coren:
Labs: automate federated table maintenance

https://gerrit.wikimedia.org/r/123916

Federation now provides, by default, the set of public tables.

globalimagelinks is still missing

Also filearchive, filearchive_userindex, user_daily_contribs, user_properties and betafeatures_user_counts are missing compared to s4.labsdb.commonswiki_p

Hi Sean, I'm assigning this to you because Coren isn't available, this has been reopened and is needed for the Toolserver migration.
Can you help?

Best Silke

Federated filearchive, filearchive_userindex, user_daily_contribs, user_properties should now exist, pointing to the sanitized labsdb1002 commonswiki_p versions.

Need to get input from Coren on the replica maintenance scripts for globalimagelinks and betafeatures_user_counts.

Thanks Sean and ping Coren!

On s5

SELECT * FROM commonswiki_f_p.recentchanges limit 1;

fails with an error:

ERROR 1296 (HY000): Got error 10000 'Error on remote system: 1054: Unknown column 'rc_moved_to_ns' in 'field list'' from FEDERATED

Also on s5 (others not testet)

SELECT * from commonswiki_f_p.page limit 3;

ERROR 1296 (HY000): Got error 10000 'Error on remote system: 1054: Unknown column 'page_content_model' in 'field list'' from FEDERATED

Seems to be a general problem.

Any chance we get this resolved? Please increase priority so that Merl can finish his migration, too.

There's a complicated issue with schema variation between databases that is causing probems. The one caused by rc_moved_to_ns is gone, I'm working on the other one now.

I'm also stuck with one or another script on the "Unknown column 'page_content_model' in 'field list'" problem.

Both views should now work properly.

Thanks, Coren! merl, can you please check and confirm this?

No, globalimagelinks is still missing (mentioned in comment #1 and #5):

$mysql -hs5.labsdb commonswiki_f_p -e "show tables like 'globalimagelinks'"
Empty Set

Also templatelinks problem on s5

select * from commonswiki_f_p.templatelinks limit 1;
ERROR 1296 (HY000): Got error 10000 'Error on remote system: 1054: Unknown column 'tl_from_namespace' in 'field list'' from FEDERATED

globalimagelinks added, tl_from_namespace has issues (being worked on)

BTW, now would be a good time to mention if there are other irregularities and not just after I fixed both of those. :-)

templatelinks updated to track the recent schema changes.