Just an update to this - which seems a bit strange.
Thinking that one or more past upgrades (from early V8 versions to 9.1.3) had led to DB problems with the OAuth* tables (which we haven’t utilized in a functional sense), I dropped the OAuth tables in our 9.1.3 environment and replaced them with the OAuth* tables from a fresh concrete install instance of 9.1.3. The same FK related error occurred on the same table OAuth2ClientScopes when I tried to the upgrade to 9.2.0.
However, I was able to upgrade to 9.2.0 successfully if I replaced our 9.1.3 OAuth* tables with those extracted from a fresh concrete 9.2.0 instance (which presumably already includes the FK entry mentioned in the error message).
So far all looks good with this upgraded 9.2.0 Test site. Are we likely to have problems with future upgrades, if we did follow the same procedure updating our Production site to 9.2.0 ?
I reckon I’ve done something very similar myself to solve a problem once.
I’d be surprised if you hit any issues - if the database schema is exactly as would be expected by the currently installed version, there’s no actual difference for it to trip up on.
You can always try doing a Doctrine refresh via the dashboard - if that works fine, then all the doctrine entities match with their database mappings.