|
|
Rank: Newbie
Joined: 4/24/2008
Posts: 20
Location: Belgium
|
My site is showing pages well. But everything has disappeared from the Manager. No Content, no settings, nothing ! I'm running out of connection pools ??? What the hell is this ?
|
|
Rank: Fanatic
Joined: 7/19/2006
Posts: 457
Location: Göteborg, Sweden
|
What version are you using? Have you verified that all permission settings are correct? Have you made any modifications to your installation lately? these are some points where additional information might come in handy if you would like good assistance ;) // ;) 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: Fanatic
Joined: 7/25/2006
Posts: 396
Location: Silkeborg, Denmark
|
Basically, the website itself (the frontend) runs off the XML file /data/umbraco.config. Whereas the backend, or Content Manager if you will, communicates with the database directly. So it sounds very much to me like you've lost the connection to your database! Have you made any changes to web.config lately? Perhabs upgraded Umbraco, and by accident overwritten it with a default one? Do you get any error messages when logging in to the backend? Check your web.config and see if the umbracoDbDSN setting still points to your database. You could also try starting up the installation wizard by going to www.yoursite.com/install/default.aspxDon't complete it, just get to the point (step 2 or 3?) where it checks if it can establish a connection with your db. Disclaimer: Remember to backup before doing any changes. I'm not sure whether redoing the install wizard can hurt your website in any way (I don't think it can), but you haven't really provided any details about your setup to evaluate this.
Brug for råd til hvordan du driver en god webshop? / Need advice on how to run an effective webshop?
|
|
Rank: Newbie
Joined: 4/24/2008
Posts: 20
Location: Belgium
|
My database is OK... I got a restore and it works again.... But I lost all my changes of the day, and I don't think I will lose everyday work, because I forever go that point :-) Tarata ! Wait and see, for later, If I reach that point again.
|
|
Rank: Fanatic
Joined: 7/19/2006
Posts: 457
Location: Göteborg, Sweden
|
Good to hear that you're up and running again. I didn't fully understand your description of the cause for this error though... Do you mind explaining this again for anyone else facing the same problem? // ;) 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: Newbie
Joined: 4/24/2008
Posts: 20
Location: Belgium
|
There is no explanation... It happened again just a few minutes ago. I'm using the content manager, and suddenly it blocks and i'm running out of connection pool. Indeed my Activity Monitor shows me 100 dead processes to my databases.
Problem is when I restart everything... Something happens that should not... I can not access anymore to any object into the manager.
|
|
Rank: Newbie
Joined: 3/19/2008
Posts: 14
Location: London
|
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 are 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: Newbie
Joined: 4/24/2008
Posts: 20
Location: Belgium
|
Oki I 'll try this later :-)
|
|
Rank: Fanatic
Joined: 7/25/2006
Posts: 396
Location: Silkeborg, Denmark
|
Mind telling us what version of Umbraco you're using? 3.0.3 and 3.04 had some performance issues related to DB connections (I think), which has been corrected in 3.0.5.
Brug for råd til hvordan du driver en god webshop? / Need advice on how to run an effective webshop?
|
|
Rank: Newbie
Joined: 4/24/2008
Posts: 20
Location: Belgium
|
I installed 3.0.5 and I run again within the same problems....
(@parentId int,@nodeObjectType uniqueidentifier)select count(id) from umbracoNode where nodeObjectType = @nodeObjectType and parentId = @parentId
(@id int)Select mandatory, DataTypeId, tabId, ContentTypeId, sortOrder, alias, name, validationRegExp, description from cmsPropertyType where id=@id
Those are the kind of things that are retrieved from the detail of the Process...
So there is definitely things that are not correct within Umbraco... So I would like to remember some things :
Connections that are not disposed stay in the connection pools until the Garbage collector is saved ! We should dispose any connection at any time, in any case.
More likely if Umbracco is using threads... Threads should be killed and disposed at any time once processes are run, (even not successfully) especially if they have open connections to the DB !
|
|
|
Guest |