Hi, here is the third exception. it happens with 1.2 releasse version:
Created ID AbsoluteUri1 AbsoluteUri2 HelpLink Message Source StackTrace2009-09-04 00:41:38.327 7 http://sratim.co.il/users http://sratim.co.il/users/usersbyroles.aspx NULL Violation of PRIMARY KEY constraint 'PK_HyperLinks_Hosts_Discoveries'. Cannot insert duplicate key in object 'dbo.HyperLinks_Hosts_Discoveries'. The statement has been terminated. .Net SqlClient Data Provider at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 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.ExecuteScalar() at Arachnode.DataSource.ArachnodeDataSetTableAdapters.QueriesTableAdapter.InsertHyperLink(String WebPageAbsoluteUri, String HyperLinkAbsoluteUri, Nullable`1 ClassifyAbsoluteUri, Nullable`1& HyperLinkID) in E:\DEVELOPMENT\yeshira12\DataSource\ArachnodeDataSet.Designer.cs:line 12878 at Arachnode.DataAccess.ArachnodeDAO.InsertHyperLink(String webPageAbsoluteUri, String hyperLinkAbsoluteUri) in E:\DEVELOPMENT\yeshira12\DataAccess\ArachnodeDAO.cs:line 1066
This occurs because we don't lock this table when inserting rows.
We do check using EXISTS but don't lock using a TRANSACTION for performance reasons. If this error is present, the record is safely recorded.
You can ignore this error.
For best service when you require assistance:
Skype: arachnodedotnet