Hi, i had the same error message “General error: 1467 Failed to read auto-increment value from storage engine …” at a mautic v4.1.1 install with php 7.4. In my case with this error i was not able to create new contacts.
I was able to fix the problem with following mysql-command:
ALTER TABLE`leads`AUTO_INCREMENT =1;