The coming week we're supposed to go live with part 1 of the 'big' website that we're building for our client.
We never had any big issue, except the fact that some Orchard features do not like our large amount of 'content' (mostly because our rather large user list because a 'user' is also content in Orchard)
But now, 2-3 days before going live while filling in content, we ran in multiple deadlocks (why always near the end of a deadline...)
I'm rather sure it has to do something with our custom menu system, since once we're done filling in the menu, the deadlocks stopped occuring.
It seems to be a 'database' deadlock since once we restart the sql server, the site 'unblocks'.
As I stated, I don't think the problem is caused by something from the Orchard core, but does anyone have any advice on how I should go in finding the cause and a solution for this kind of problem?
We have a NHibernate Profiler license and so far I don't see anything truly bad (plenty of queries as always, but none of them are really heavy nor return plenty of records) but we did notice, once the issue occurs, that one transaction session wasn't committed (causing
Is there a possibility that somehow a transaction is not properly committed / rolled back when something blows up (unhandled exception)?
Any advice is VERY welcome since if this isn't resolved we'll not reach our deadline :/
FYI: Afaik, we don't use any 'custom' locks others than the locks 'caused' by transactions) to synchronize access in our custom code.
If you can help us out or put us on the correct path, I'll give you a sneak peak at our 'big' Orchard project and you'll get free cookies (after visiting the website that is :P)!.