Release issueshttps://lab.civicrm.org/dev/release/-/issues2024-01-15T11:30:51Zhttps://lab.civicrm.org/dev/release/-/issues/235.68.1 failed to upgrade DB from 5.53.0: DB Error: constraint violation2024-01-15T11:30:51ZDmitry Smirnov5.68.1 failed to upgrade DB from 5.53.0: DB Error: constraint violationAfter successfully upgrading our staging CiviCRM from 5.53.0 to 5.68.1, upgrade of production instance failed as follows:
```
[Error: Backfill civicrm_mailing_event_queue (6 => 500005)]
Error Field Error Value
Type DB_Error
Code -3
Mess...After successfully upgrading our staging CiviCRM from 5.53.0 to 5.68.1, upgrade of production instance failed as follows:
```
[Error: Backfill civicrm_mailing_event_queue (6 => 500005)]
Error Field Error Value
Type DB_Error
Code -3
Message DB Error: constraint violation
Mode 16
UserInfo UPDATE civicrm_mailing_event_queue q INNER JOIN civicrm_mailing_job job ON job.id = q.job_id SET q.mailing_id = job.mailing_id, q.is_test=job.is_test WHERE q.id >= 6 AND q.id <= 500005 AND q.mailing_id IS NULL [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`wordpress-civicrm`.`civicrm_mailing_event_queue`, CONSTRAINT `civicrm_mailing_event_queue_ibfk_1` FOREIGN KEY (`mailing_id`) REFERENCES `civicrm_mailing` (`id`) ON DELETE SET NULL)]
DebugInfo UPDATE civicrm_mailing_event_queue q INNER JOIN civicrm_mailing_job job ON job.id = q.job_id SET q.mailing_id = job.mailing_id, q.is_test=job.is_test WHERE q.id >= 6 AND q.id <= 500005 AND q.mailing_id IS NULL [nativecode=1452 ** Cannot add or update a child row: a foreign key constraint fails (`wordpress-civicrm`.`civicrm_mailing_event_queue`, CONSTRAINT `civicrm_mailing_event_queue_ibfk_1` FOREIGN KEY (`mailing_id`) REFERENCES `civicrm_mailing` (`id`) ON DELETE SET NULL)]
Civi\Core\Exception\DBQueryException: DB Error: constraint violation in /usr/share/php/PEAR.php on line 944
- DB_Error: DB Error: constraint violation in unknown on line unknown
```
That's on PHP-8.2, Debian 12 "Bookworm", Mariadb 10.9.3.
Please advise.