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 -
test2wiki
- maindb
mediawikiwiki (s3)
- maindb
- eqiad
- codfw
enwiki:
- extension1db
- eqiad
- codfw
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/
Version: unspecified
Severity: minor
See Also:
https://bugzilla.wikimedia.org/show_bug.cgi?id=41987