On our fairly normal AWS Drupal platform, with shared a RDS MariaDB instance, the 8201 update hook throws a permissions error when trying to update to DER 4.0.0-alpha1 (as pas of a D10 upgrade):
[notice] Update started: dynamic_entity_reference_update_8201
[error] SQLSTATE[HY000]: General error: 1419 You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable): DROP TRIGGER IF EXISTS paragraph__field_custom_block_der_update; Array ()I've not yet attempted a solution, but offhand I don't think Drupal should need SUPER privs and binary logging should be enabled on production databases as a matter of course, so probably others will his this problem too.
Active
4.0
Code
Update: There are in fact no triggers in the database at all 🫠 so a conditional should sort this.
Reopening. #6 is switching to DER 3 which does not have this code. This is still affecting DER 4.