Integrity Constraint Violation

@EJL

Seems you have bigger headaches than I have.

The integrity violation seems to point to a foreign key that does not exist in the database.

Try:
mautic:segment:update --force

Timing sounds like it could be an issue when you get to importing so many records. I would run each command from the terminal and time how long it takes to ge the Cron timing more aligned.