ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

The following error can be found on atlassian-bitbucket.log:

ORA-02391: exceeded simultaneous SESSIONS_PER_USER limit

Cause

This means your Bitbucket Server instance is opening more connections than defined on your SESSIONS_PER_USER on your Oracle database

Resolution

Just as defined on Bitbucket Server 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 Bitbucket Server 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 bitbucket.properties to accommodate your SESSIONS_PER_USER

 

Last modified on Sep 16, 2015

Was this helpful?

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