ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

Troubleshooting Databases

On this page

Still need help?

The Atlassian Community is here for you.

Ask the community

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 your SESSIONS_PER_USER

 

Last modified on Aug 20, 2014

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.