Duplicate key violates unique constraint

Did you do any research to determine why MAX(id) was greater than NEXTVAL() for the sequence? That would be useful knowledge to add to your post (and, presumably, for you to have).