deadlock - Handle NHibernate Transaction Errors -


The use of our application (which NHibernate and ASP.NET MVC), the stress placed NHibernate transaction errors under trials Throws a lot. The main types are:

  1. The transaction is not connected or disconnected
  2. Route updates or deletions by any other transaction (or unsaved-value mappings) )
  3. The transaction (process ID 177) was locked on lock resources with other resources and was chosen as a deadlock victim. Run the transaction again. Can someone help me identify the cause of exception 1? I know that I have to handle other exceptions in my code. Does anyone point me to resources that can help me handle these errors in a efficient way?

    Q How do we manage sessions and transactions?

    A. For each server request we are using Autofack, we create a new request container in which the session is in the container lifetime, we activate the transaction when we activate the session. When the request is complete, we do the transaction. In some cases, the transaction may be huge. To simplify, every server is contained in a transaction in the request.

Look at this thread:

Actually what is the reason for this exception As says:

2010-02-17 21: 01: 41,204 Warning NHibernate.Util.ADOExceptionReporter - System.Data.SqlClient SqlException: The transaction log for the database 'database name' is filled. Find out why it can not be used to log into space again, maybe you see log_reuse_wait_desc column sys.databases

transactions made during the transaction, such as the size of the log function Is the proportional to the amount of, in the order bookers' handling on the part of the transaction, the limits of their transaction of orders should be included. You will then load the state with session # X, which you want to mutate, mutate and commit it, all this is a unit of work in #X.

In relation to the reading side of things, you may have another Christian # that reads the data; This ISession can be used for batch, reads in the example, with the repetitive or futures facility, something else can be read from a cache similarly (it is actually a crutch). Doing this can help you overcome "errors" which are not; Livelocks, deadlocks and victim transactions.

The problem with using a transaction for a request is that your Issation maintains many functions when you are working, which is part of all transactions, therefore participate in database transactions, Marks of datas (rols, columns, tables, etc.) as a wait-graph reason that crosses the database (not in the database-sense, not the DDD sense), which are not actually part of the

record (Other people have stopped it), Fabian The data layer was working to deal with exceptions. Citing some of their code; 

  public class MsSqlExceptionConverterExample: ISQLExceptionConverter {public exception Convert (AdoExceptionContextInfo exInfo) {var sqle = ADOExceptionHelper.ExtractDbException (exInfo.SqlException) as SqlException; If (sqle = null!) {Switch (sqle.Number) {case 547: return new ConstraintViolationException (exInfo.Message, sqle.InnerException, exInfo.Sql, null); Case 208: Return the new SQL Gamram Express (XInfo Message, Excel.InException, XInfo SQL); Case 3960: Return the new Stale ObjectState Expansion (exInfo.EntityName, exInfo.EntityId); }} Return SQLStateConverter. Handlen Special Expression (exInfo.SqlException, exInfo.Message, exInfo.Sql); The exception of 547 is the number of exceptions to the conflict.  
  •  208 has an exception number in an invalid object name in SQL.   
  •  Exception number of snapshot isolation transaction has been revoked due to conflict of conflict.   
     So if you are running compatibility issues like what you describe; Remember that they will cancel your resignation and you have to handle them as above.  
     The CQRS, where you read and write separately, can help:,.  
     To summarize; Your problems can be related to the way you control your transactions. Also, try to run  from sys.databases from log_wait_reuse_desc where name = 'MyDBName'  and see what it gives you.

    • -

    Comments

    Post a Comment

    Popular posts from this blog

    Eclipse CDT variable colors in editor -

    I hope this is a good question to ask here. This programming is related, so I thought it would be better than the superuser, so I am using the CDT C ++ Eclipse plugin. I know how the editor changes colors for some things But is there a way to do that all the variables are different colors? For example in KDEValue, it sets the local variables and square variables in different colors and bold square squares. Can I copy it to CDT? Eclips provides some level of color customization for text editor syntax You can see it on the following: There are many elements, including the Window> Preferences> C / C ++> Editor> Syntax color code that can be changed, assembly, Comments, Preprocessor and Doxian Under the code, it is possible to change the color of some variable types, such as global variables, local variable announcements, local variable references, and parameter variables. But I do not think the code is capable of changing the color of each variable declared....
    Read more

    AJAX doesn't send POST query -

    $ (दस्तावेज़) .ready (function () {function ajaxselectrss (rssurlvar) {var ajaxRequest; // वेरिएबल जो अजाक्स को संभव बनाता है! कोशिश करें कि {// ओपेरा 8.0+, फ़ायरफ़ॉक्स, सफारी अजाक्स अनुरोध} = नया एक्सएमएलएचटीपीआरइवेस्ट ();} कैच (ई) {// इंटरनेट एक्सप्लोरर ब्राउज़र्स {ajaxRequest = new ActiveXObject ("Msxml2.XMLHTTP");} पकड़ो (ई) {try {ajaxRequest = new ActiveXObject ("Microsoft.XMLHTTP");} कैच (ई) {// कुछ गलत चेतावनी ("आपका ब्राउज़र तोड़ दिया!"); वापसी झूठी;}}} // एक बनाएं फ़ंक्शन जो सर्वर से भेजे गए डेटा प्राप्त करेंगे ajaxRequest.onreadystatechange = function () {if (ajaxRequest.readyState == 4) {var ajaxDisplay = document.getElementById ('news'); ajaxDisplay.innerHTML = ajaxRequest.responseText;}} / / Var rssurlvar = $ (this) .attr ("title"); var queryString = "rurl =" + rssurlvar; var urltofile = "rssget.php"; ajaxRequest.open ("पोस्ट", urltofile, सच); ajaxRequ Est.setRequestHeader ("सामग्री-प्र...
    Read more

    wpf - Custom Message Box Advice -

    Well, I'm using a custom window box that comes with some custom control boxes that accompany the text The producers who are displayed are called. I have a defined event, which has been subscribed through the original class, it gets burnt when clicking on the button. However, I can not see how to use it effectively, I would like to return one yes, whether yes or not, but obviously my code will continue to execute, so this Below is some example code to clarify the problem that the method has subscibed by clicking on the button. Message box window Public partial class custom message box: window {public representative message messagebox object sender, event events e); Public event messagebox handler messagebox document; Public Customs Box () {Initial group (); } Public Customsbox (String Message) {InitializeComponent (); This.txtdescription.Text = Message; } Public Customsbox (String Message, String Title, String First BTNtext) {Initialization (); This.lbltitle.Content =...
    Read more