Investboy
Member of DD Central
Trying to recover from P2P revolution
Posts: 564 
Likes: 201
|
Post by Investboy on Mar 22, 2018 20:09:00 GMT
I'm trying to invest in 1000099 - Refinance of Property & Modular Assets but getting message with strange error
Unexpected error occurred: Transaction (Process ID 60) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Anyone else seeing this?
|
|
scubabeer
Member of DD Central
Posts: 54
Likes: 20
|
Post by scubabeer on Mar 22, 2018 20:12:22 GMT
Had various errors, including this one  After about 20 attempts finally managed to get a bid accepted  |
|
|
|
Post by stevem on Mar 22, 2018 20:12:31 GMT
Yes, along with all kinds of other errors - not quite sure why but when I changed my investment to a nice round figure rather than trying to use all the cash I had on Ablrate it worked straightaway but still won't let me invest the remaining £12:00
Unexpected error occurred: This Loan instance in memory is out-of-date. A clone of it is already updated in the transaction. It is not allowed to update the same instance multiple times in a transaction, because then the earlier updates would be overwriten by the older state of the instance in memory.
BAD:
Database.Update(myObject, x=> x.P1 = ...); // Note: this could also be nested inside another method that's called here instead.
Database.Update(myObject, x=> x.P2 = ...);
GOOD:
Database.Update(myObject, x=> x.P1 = ...);
myObject = Database.Reload(myObject);
Database.Update(myObject, x=> x.P2 = ...);
|
|
TonyL
Posts: 53
Likes: 98
|
Post by TonyL on Mar 22, 2018 20:13:07 GMT
So I've tried to lend into the latest loan and all a I get is the response "Unexpected error occurred: Transaction (Process ID 98) was deadlocked...". I've tried a dozen times already. Why on earth are these IT systems never designed to cope with the traffic the website is designed to attract. It's not rocket science. Sooooo infuriating. Grr.
This is why I prefer the Lendy approach where you say how much you would like and you get a fair allocation up to your maximum desired amount. None of this fastest-finger-first stuff, which is just so old fashioned. Please improve your IT systems to cope with traffic or change your mechanism to avoid dense traffic.
|
|
jontyab
Member of DD Central
Posts: 116
Likes: 79
|
Post by jontyab on Mar 22, 2018 20:14:27 GMT
After about 20 attempts... Gosh, whatever could the problem be
|
|
|
|
Post by dan1 on Mar 22, 2018 20:18:35 GMT
So I've tried to lend into the latest loan and all a I get is the response "Unexpected error occurred: Transaction (Process ID 98) was deadlocked...". I've tried a dozen times already. Why on earth are these IT systems never designed to cope with the traffic the website is designed to attract. It's not rocket science. Sooooo infuriating. Grr. This is why I prefer the Lendy approach where you say how much you would like and you get a fair allocation up to your maximum desired amount. None of this fastest-finger-first stuff, which is just so old fashioned. Please improve your IT systems to cope with traffic or change your mechanism to avoid dense traffic. I think it's a case of concurrent transactions attempting to access the DB. I got this error too and the fact several people reported this at the same time indicates we were all trying to invest at the same time. I prefer a real-time system to anything Lendy-esq.... in fact anything Lendy-esq brings me out in hives
|
|
|
|
Post by df on Mar 22, 2018 20:25:54 GMT
So I've tried to lend into the latest loan and all a I get is the response "Unexpected error occurred: Transaction (Process ID 98) was deadlocked...". I've tried a dozen times already. Why on earth are these IT systems never designed to cope with the traffic the website is designed to attract. It's not rocket science. Sooooo infuriating. Grr. This is why I prefer the Lendy approach where you say how much you would like and you get a fair allocation up to your maximum desired amount. None of this fastest-finger-first stuff, which is just so old fashioned. Please improve your IT systems to cope with traffic or change your mechanism to avoid dense traffic. I think it's a case of concurrent transactions attempting to access the DB. I got this error too and the fact several people reported this at the same time indicates we were all trying to invest at the same time. I prefer a real-time system to anything Lendy-esq.... in fact anything Lendy-esq brings me out in hives I've been trying since 8pm, no luck. Obviously not everyone is experiencing this problem, the loan is filling up. That would be the best to do? Wait for an hour and try again? Edit: straight after posting it, I've tried again and it worked.
|
|
|
|
Post by fatbritabroad on Mar 22, 2018 20:27:28 GMT
Keep trying it'll work eventually
|
|
|
|
Post by dan1 on Mar 22, 2018 20:31:05 GMT
I think it's a case of concurrent transactions attempting to access the DB. I got this error too and the fact several people reported this at the same time indicates we were all trying to invest at the same time. I prefer a real-time system to anything Lendy-esq.... in fact anything Lendy-esq brings me out in hives I've been trying since 8pm, no luck. Obviously not everyone is experiencing this problem, the loan is filling up. That would be the best to do? Wait for an hour and try again? I guess so but it's always nervous watching the loan fill. It may explain the comparatively slow take up of this loan although that may be explained by the number of loans to the same borrower. It would be nice to get some comment from ablrate as to any changes in the system that may have precipitated this? I think we can wait until the morning for an explanation
|
|
|
|
Post by fatbritabroad on Mar 22, 2018 20:33:39 GMT
Its slow because of the 2k bid limit im impressedso much has gone already tbh
|
|
ptr120
Member of DD Central
Posts: 1,198
Likes: 1,346
|
Post by ptr120 on Mar 22, 2018 20:37:45 GMT
IIRC the last loan overfilled slightly due to duplicate bids being placed within less than a second. ablrate said that they were going to implement a fix - i'd speculate that this is what has caused the problems that some users have experienced. |
|
|
|
Post by ablrate on Mar 23, 2018 9:29:11 GMT
Hi Guys
Sorry for the errors here. We recently made some changes to prevent concurrent transactions.. devs looking at it
|
|
Investboy
Member of DD Central
Trying to recover from P2P revolution
Posts: 564
Likes: 201
|
Post by Investboy on Mar 23, 2018 13:45:11 GMT
Worked now. But I guess the hot bidding period was over.
|
|
hantsowl
Member of DD Central
Posts: 672
Likes: 546
|
Post by hantsowl on May 1, 2018 19:09:02 GMT
Can't seem to buy the new loan. Repeated deadlocks  |
|
|
|
Post by winger on May 1, 2018 19:11:12 GMT
I'm getting deadlocks too, and SQL errors ("Unexpected error occurred: Error in running SQL Query."). About 15 errors to 1 non-error so far......!
|
|
