In the production site we have found few issues with a member login, when investicated its found that there are two entries in the cmsMember table with same login name, it should not have happened, I wonder how Umbraco allowed this and there is no unique key set for the LoginName as the membership works based on login name.

Thanks

Basil