Two of my configuration options for mysql, auto_increment_increment and auto_increment_offset are not set to 1. I have it set this way to support database replication.
This causes problems on install. See http://forum.civicrm.org/index.php/topic,4753.0.html for the symtoms.
The solution is to modify the installation scripts so that the the first value set in an autoincremented column is not assumed to be 1.