* type checking fixes

* changelog

Copy push rules during a room upgrade from the old room to the new room, instead of deleting them from the old room.

For instance, we've defined upgrading of a room multiple times to be possible, and push rules won't be transferred on the second upgrade if they're deleted during the first.

Also fix some missing yields that probably broke things quite a bit.

Fix errors storing large retry intervals.

Fix fetching censored redactions from DB

We have set the max retry interval to a value larger than a postgres or
sqlite int can hold, which caused exceptions when updating the
destinations table.

To fix postgres we need to change the column to a bigint, and for sqlite
we lower the max interval to 2**62 (which is still incredibly long).

Fix censoring redactions performance

Fetching a censored redactions caused an exception due to the code
expecting redactions to have a `redact` key, which redacted redactions
don't have.

Joining against `events` and ordering by `stream_ordering` is
inefficient as it forced scanning the entirety of the redactions table.

This isn't the case if we use `redactions.received_ts` column as we can
then use an index.

This will allow us to efficiently search for uncensored redactions in
the DB before a given time.

Currently we don't set `have_censored` column if we don't have the
target event of a redaction, which means we repeatedly attempt to censor
the same non-existant event.

When we persist non-redacted events we unset the `have_censored` column
for any redactions that target said event.

Fix `devices_last_seen` background update.

Fixes #6134.

These tables are unused since #5893 (as amended by #6047), so we can now drop
them.

Fixes #6048.

Reject pending invites on deactivation

Co-Authored-By: Andrew Morgan <1342360+anoadragon453@users.noreply.github.com>

Co-Authored-By: Andrew Morgan <1342360+anoadragon453@users.noreply.github.com>

Co-Authored-By: Andrew Morgan <1342360+anoadragon453@users.noreply.github.com>

Just to have all the methods that make calls to identity services in one place.

Add some helpful opentracing tags and remove get_user_by_req span

Fix 'redaction_retention_period' sampel config to match guidelines

Doing a password reset via SMS has never worked, and in any case is a silly
idea because msisdn recycling is a thing.

See also matrix-org/matrix-doc#2303.

formatting tweak