Last modified: 2014-03-14 01:05:28 UTC
Short description: Rename two indexes in the Echo extension. These were renamed for the benefit of SQLite on the foundations Continuous Integration environment which requires index names to be unique not just to a table, but to the entire database. My review of mariadb's 'ALTER TABLE' statement suggests there is no rename index option(incl in mysql 5.7), so the indexes would need to be dropped and recreated. We are not sure if its actually worthwhile to rename these indexes in prod, up to you. Which wikis are affected: testwiki: maindb & extension1db - maindb is not used but it's good to make it either up to date or just remove all echo tables test2wiki: maindb mediawikiwiki: maindb enwiki: extension1db Which tables: echo_event and echo_notification What is the change to those tables: CREATE INDEX /*i*/echo_event_type ON /*_*/echo_event (event_type); DROP INDEX /*i*/event_type ON /*_*/echo_event; CREATE INDEX /*i*/echo_user_timestamp ON /*_*/echo_notification (notification_user, notification_timestamp); DROP INDEX /*i*/user_timestamp ON /*_*/echo_notification; Links to gerrit changes and/or other related bug reports. https://gerrit.wikimedia.org/r/#/c/64594/ https://gerrit.wikimedia.org/r/#/c/68728/
Sean: Any news here (as you set yourself as assignee and as this is high priority)? Or should priority be lower instead?