ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
Symptoms
The following error can be found on atlassian-stash.log
:
ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit
Cause
This means your Stash instance is opening more connections than defined on your SESSIONS_PER_USER
on your Oracle database
Resolution
Just as defined on Stash config properties - DB Pool, the default value for db.pool.partition.count is 4 and db.pool.partition.connection.maximum is defined as 20 by default, the maximum number of connections to be established by Stash will be 80 and the minimum will be 16 - as db.pool.partition.connection.minimum
defaults to 4.
You could either:
- Adjust
SESSIONS_PER_USER
to accommodate your current db configuration. - Adjust your
stash-config.properties
to accommodate yourSESSIONS_PER_USER