|
|
Rank: Newbie
Joined: 4/24/2008
Posts: 20
Location: Belgium
|
I used for an hour the content manager, I got into troubles. I went to the Activity Monitor of my SQL Server, more then 150 processes of my DB where running... I restarted SQL server, IIS... And guess what ! My content manager is again crashed. Content, and all other things are empty !
|
|
Rank: Newbie
Joined: 4/24/2008
Posts: 20
Location: Belgium
|
After restart and first load of the Content manager... I already have 99 processes for my Database into the SQL Manager... Definitely, something goes wrong with the SQL Connection manager.... (Close and Dispose.. your objects everytime !!! )
|
|
Rank: Umbracoholic
Joined: 9/8/2006
Posts: 1,285
Location: KY, USA
|
Very strange. What version of umbraco are you running? Did you compile it from the source or use the provided binaries? Can you reproduce this problem? If so, what are the steps so that we can reproduce it as well? cheers, doug.
MVP 2007-2009 - Official Umbraco Trainer for North America - Percipient Studios
|
|
Rank: Newbie
Joined: 4/24/2008
Posts: 20
Location: Belgium
|
It should be version 3.04. I don't know if we compiled the thing or not, what was the initial source ? I'm taking over some "Unfinished trashy thing", and they would like to make it work, but I even can't make Umbraco work correctly to setup and finalize the complete thing. :-)
I'm trying to get a connection to the CodePlex server to get the latest sources, and trying to merge my current project to the latest sources, but I can't get logged in. (I'm using TFS, and trying to connect with snd\cmwalolo_cp and my password as explained in some page on codeplex :-))
Thanks
Laurent
|
|
Rank: Newbie
Joined: 4/24/2008
Posts: 20
Location: Belgium
|
It seems that the Empty trash function causes the problem of the connection pools...
It should not dispose the connection, when I'm deleting 20 items, it seems that 20 new processes are run and not disposed in my Activity Monitor.
I looked for other items, and I don't see for now much activity. However I have 6 open processes in my activity monitor for a unique client. I'll test more next week, it's time to have a long break :-)))
See you,
Laurent
|
|
Rank: Newbie
Joined: 3/19/2008
Posts: 13
Location: London
|
Hi Laurent,
I posted this in your "Umbraco Content Manager" thread, but just in case you check this first:
Try run DBCC INPUTBUFFER(@spid)
where @spid is the id of one of those dead connections...
Do this for a few of those connections and see if they all ran the same command as their last batch. That will give you a clue as to which process is calling that command in the code and not closing the connection.
|
|
Rank: Fanatic
Joined: 7/19/2006
Posts: 395
Location: Göteborg, Sweden
|
If you are using a "nightly build" from Codeplex you will find the Umbraco.datalayer.dll file in your bin folder. I had a lot of db errors before I installed the 3.0.5 release last week... And I had about 2-3 deadlocks per day and I had a website that stopped responding for some minutes each time the deadlocks appeared. So, if you have binaries from the repository please install 3.0.5 since the datalayer is work in progress.. // ;) Kalle
" - Yeah I'd like to share your point of view, as long as it's my view too... ( http://www.d-a-d.dk/lyrics/pointofview)
|
|
Rank: Addict
Joined: 7/19/2006
Posts: 706
Location: Århus, Denmark
|
cmwalolo wrote:
I'm trying to get a connection to the CodePlex server to get the latest sources, and trying to merge my current project to the latest sources, but I can't get logged in. (I'm using TFS, and trying to connect with snd\cmwalolo_cp and my password as explained in some page on codeplex :-))
Only people that are developers on a project can access it through TFS. If you just want the code, then you can download it as a .zip file on the "Source" tab.
Morten Bock - Level 2 certified - My danish blog with a few english posts | CodeGarden on Facebook
|
|
Rank: Newbie
Joined: 4/24/2008
Posts: 20
Location: Belgium
|
Oki, I will try release 3.0.5 :-)
|
|
|
Guest |