Is the configuration as described in the subject a valid architecture when multiple web service instances, in a clustered environment, are doing inserts to the same SQL Server table that has an auto-increment integer primary key? I am seeing what appears to be failures based on conflicts. Is there configuration or coding to allow this architecture, or is it not feasible? On server #1: Could not execute query: INSERT INTO (etc...); select SCOPE_IDENTITY() System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
On server #2: Could not synchronize database state with session NHibernate.StaleStateException: Batch update returned unexpected row count from update; actual row count: 0; expected: 1 -- You received this message because you are subscribed to the Google Groups "nhusers" group. To view this discussion on the web visit https://groups.google.com/d/msg/nhusers/-/v8_4bdYJe0sJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
