Web applications and "too many sessions"

[Flemming Frandsen]

I have a webapplication that uses SAP DB, it caches the database connections between requests so I don't need to re-connect every time.

Most of the time everything is good, but when the webserver is not busy (mostly in the middle of the night) the few requests that do come fail to connect to the database:

[SAP AG][LIBSQLOD SO][SAP DB]Unable to connect to data source;-709 CONNECT: (too many sessions). (SQL-08001)

In this particular instance there were 10 apache processes and around 10 database connections, the MAXUSERTASKS parameter of the database is set to 300, so that can't really be the cause of this, right?

I do know that the sapdb client liberary has a problem connecting to the database when it has timed out more than 8-9 times (does this bug still exist?), but SESSION_TIMEOUT is set to 0 so inactive sessions should never timeout, right?


Does anyone have a clue as to why this happens?

--
Regards Flemming Frandsen - http://dion.swamp.dk
PartyTicket.Net co founder & Yet Another Perl Hacker

_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general