Hi Guys,

If I have more than 20 users on the registration page I get this errors. The member is saved, but all custom properties are not saved. The users I'm trying to create are all diferent. Same occurs on the production server.

Errors:

1. Violation of PRIMARY KEY constraint 'PK_cmsMember2MemberGroup'. Cannot insert duplicate key in object 'dbo.cmsMember2MemberGroup'. The duplicate key value is (50946, 1151)

2. The process cannot access the file '634740044628548079-XXXX.del' because it is being used by another process.

 

UmbracoLog Table

umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_cmsMember2MemberGroup'. Cannot insert duplicate key in object 'dbo.cmsMember2MemberGroup'. The duplicate key value is (50946, 1151).  The statement has been terminated.     at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)     at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()     at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)     at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)     at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)     at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)     at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)     at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()     at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters)     at umbraco.DataLayer.SqlHelper`1.ExecuteNonQuery(String commandText, IParameter[] parameters)     --- End of inner exception stack trace ---     at PingoDoce.Core.Gateways.AuthenticationGateway.SaveUser(User user) in C:\development\MyWebSite\PingoDoce\trunk\PingoDoce.Core\Gateways\AuthenticationGateway.cs:line 126     at PingoDoce.Frontend.restServices.RestAuthentication.<SaveUser>b__9() in C:\development\MyWebSite\PingoDoce\trunk\PingoDoce.Frontend\restServices\RestAuthentication.cs:line 109     at PingoDoce.Frontend.restServices.RestService.ExecuteRequest[T](RestOperation operation) in C:\development\MyWebSite\PingoDoce\trunk\PingoDoce.Frontend\restServices\RestService.cs:line 30

 

Log4Net log

:: [/LM/W3SVC/7/ROOT-10-129829518435764181] :: 2012-05-31 16:30:51,987 [WARN ]-[13  ] - :: AuthenticationGateway :: SaveUser - ChangeNewsletterStatus[p2b9306730cec40d0bc7ef9d3d40835a516;[email protected];System.Data.SqlClient.SqlException (0x80131904): Violation of UNIQUE KEY constraint 'IX_user_Newsletter_Unique_Email'. Cannot insert duplicate key in object 'dbo.site_Newsletter'. The duplicate key value is ([email protected]).

The statement has been terminated.

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

   at System.Data.SqlClient.SqlDataReader.get_MetaData()

   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

   at System.Data.Linq.SqlClient.SqlProvider.Execute(Expression query, QueryInfo queryInfo, IObjectReaderFactory factory, Object[] parentArgs, Object[] userArgs, ICompiledSubQuery[] subQueries, Object lastResult)

   at System.Data.Linq.SqlClient.SqlProvider.ExecuteAll(Expression query, QueryInfo[] queryInfos, IObjectReaderFactory factory, Object[] userArguments, ICompiledSubQuery[] subQueries)

   at System.Data.Linq.SqlClient.SqlProvider.System.Data.Linq.Provider.IProvider.Execute(Expression query)

   at System.Data.Linq.ChangeDirector.StandardChangeDirector.DynamicInsert(TrackedObject item)

   at System.Data.Linq.ChangeDirector.StandardChangeDirector.Insert(TrackedObject item)

   at System.Data.Linq.ChangeProcessor.SubmitChanges(ConflictMode failureMode)

   at System.Data.Linq.DataContext.SubmitChanges(ConflictMode failureMode)

   at Website.Core.Managers.NewsletterManager.ChangeNewsletterStatus(String email, Boolean register) in C:\development\MyWebSite\Website\trunk\Website.Core\Managers\NewsletterManager.cs:line 21

   at Website.Core.Gateways.AuthenticationGateway.SaveUser(User user) in C:\development\MyWebSite\Website\trunk\Website.Core\Gateways\AuthenticationGateway.cs:line 105] - [Website.Core.Gateways.AuthenticationGateway]-(?)

 

Log4Net log - the file exists, and its not being used by another process, like antivirus programns, etc

:: [/LM/W3SVC/7/ROOT-11-129828773807771203] :: 2012-05-30 19:54:22,854 [FATAL]-[126 ] - :: AuthenticationGateway :: SaveUser - ERROR generalError[pcdc8-bcdb230049be41;[email protected];System.IO.IOException: The process cannot access the file 'C:\development\MyWebSite\Website\trunk\Website.Frontend\App_Data\TEMP\ExamineIndexes\InternalMember\Queue\634740044628548079-PEDRO-ADAO.del' because it is being used by another process.

   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)

   at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath)

   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy)

   at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options)

   at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize)

   at System.IO.StreamWriter..ctor(String path, Boolean append)

   at System.IO.FileInfo.CreateText()

   at Examine.LuceneEngine.SerializableDictionaryExtensions.SaveToDisk[TKey,TValue](SerializableDictionary`2 sd, FileInfo fi)

   at Examine.LuceneEngine.Providers.LuceneIndexer.SaveDeleteIndexQueueItem(KeyValuePair`2 term)

   at Examine.LuceneEngine.Providers.LuceneIndexer.ReIndexNode(XElement node, String type)

   at Examine.ExamineManager._ReIndexNode(XElement node, String type, IEnumerable`1 providers)

   at umbraco.cms.businesslogic.member.Member.SaveEventHandler.Invoke(Member sender, SaveEventArgs e)

   at umbraco.cms.businesslogic.member.Member.Save()

   at umbraco.cms.businesslogic.member.Member.MakeNew(String Name, String LoginName, String Email, MemberType mbt, User u)

   at umbraco.cms.businesslogic.member.Member.MakeNew(String Name, String Email, MemberType mbt, User u)

   at umbraco.providers.members.UmbracoMembershipProvider.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status)

   at System.Web.Security.Membership.CreateUser(String username, String password, String email, String passwordQuestion, String passwordAnswer, Boolean isApproved, Object providerUserKey, MembershipCreateStatus& status)

   at Website.Core.Managers.MembershipManager.CreateUser(String username, String password, String email) in C:\development\MyWebSite\Website\trunk\Website.Core\Managers\MembershipManager.cs:line 157

   at Website.Core.Gateways.AuthenticationGateway.SaveUser(User user) in C:\development\MyWebSite\Website\trunk\Website.Core\Gateways\AuthenticationGateway.cs:line 67] - [Website.Core.Gateways.AuthenticationGateway]-(?)