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.