Server overload due to multiple sessions

HCL Domino Domino Forum
1

Hi,

We’re a school running a collection of Notes DBs such that each course is its own database and there is a web portal that displays the news information specific to a particular student from all the courses he/she is registered in.

The way that is displayed is through a collection of fields using @DbColumn to lookup the news from the views respective course DBs.

We’ve recently encountered a problem in which the server crashed due to multiple sessions that simultaneously remaining open. Since it was at a time when activity is expected to be sparse and it automatically repeated itself (in the log) every 2 minutes, we suspect it’s caught in a loop.

Any help would be greatly appreciated.

Here is a sample of the messages:

09/17/2003 09:47:17 PM HTTP Server: Waiting for session to finish: Session State [Processing Request] Session ID [132119] GET /activecourses/commerceportal/commerce.nsf/CourseAnnounce?OpenForm HTTP/1.1

09/17/2003 09:47:17 PM HTTP Server: Waiting for session to finish: Session State [Processing Request] Session ID [132240] GET /activecourses/commerceportal/commerce.nsf/CourseAnnounce?OpenForm HTTP/1.1

09/17/2003 09:47:17 PM HTTP Server: Waiting for session to finish: Session State [Processing Request] Session ID [130269] GET /activecourses/commerceportal/commerce.nsf/CourseAnnounce?OpenForm HTTP/1.1

09/17/2003 09:47:17 PM HTTP Server: Waiting for session to finish: Session State [Processing Request] Session ID [130405] GET /activecourses/commerceportal/commerce.nsf/CourseAnnounce?OpenForm HTTP/1.1

09/17/2003 09:47:17 PM HTTP Server: Waiting for session to finish: Session State [Processing Request] Session ID [132422] GET /activecourses/commerceportal/commerce.nsf/CourseAnnounce?OpenForm HTTP/1.1

09/17/2003 09:47:17 PM HTTP Server: Waiting for session to finish: Session State [Processing Request] Session ID [130584] GET /activecourses/commerceportal/commerce.nsf/CourseAnnounce?OpenForm HTTP/1.1

2

Subject: Server overload due to multiple sessions

a few of ?'s

Is the @DBColumn in a field or an agent?

if Agent, have you checked # concurrent agents allowed on the server?

If in a field, is the view refresh set to automatic and what is the frequency of the documnet changes within that view?

How many fields are doing @DBColumns concurrently?

Is this and @DBColumn with and ODBC option?

3

Subject: RE: Server overload due to multiple sessions

The @DBColumn is contained within fields. The idea is professors can post news onto their course DBs, that will also be reflected on the portal.

We allow for up to 14 courses (hence, 14 fields), but a typical number is only 4.

The views themselves are refreshed automatically, and we expect at most, daily additions of documents. However, this is unpredictable as it varies between professors and courses.

Any help would be appreciated.

4

Subject: RE: Server overload due to multiple sessions

Did you find out the answer to solve the issue?

I got the same problem and like to know the answer.

Thanks