Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Database Connection URL: Confluence

Hi, have an open ticket with support but responses are very sporadic and therefore I'm just left hanging at moment. 

We have very bad performance of Confluence on our pre-prod server.  I have recently upgraded it from version 6.2 to version 6.13.5 but it hadn't been used in a long time before that, certainly before I worked here at least so I cannot testify to the performance of it before now.   We couldn't even get into the sql instance so refreshed a copy of live db into another instance and I repointed all configs to new db. 

Confluence is painfully slow and I am only user on pre-prod.  I very often get unknown errors when trying to update Apps or accessing System Information (sometimes it gets there mostly it doesn't) and Atlassian said it was due to latency talking to the database.  Both Apps server and db server report healthy performance so I'm struggling to understand where latency is occurring.  There are no firewalls or blocking network issues.

However, looking at System information I notice the latency in pre-prod is high (77) and I noticed it has a stupidly long connection URL compared to Production and I'm suspecting this could be root cause but I do not know where to find/edit this. 

Question? The Confluence.cfg.xml has the string I expect but the System info is obviously reading from somewhere else, database table maybe?

Database connection URL in confluence.cfg.xml

<property name="hibernate.connection.url">jdbc:sqlserver://apc-vd-mssql-01:1433;databaseName=Confluence620_QA</property>

Database connection URL (in full): shown in System Information:-

01:1433;jaasConfigurationName=SQLJDBCDriver;statementPoolingCacheSize=10;serverPreparedStatementDiscardThreshold=10;enablePrepareOnFirstPreparedStatementCall=false;fips=false;socketTimeout=0;authentication=NotSpecified;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustStoreType=JKS;trustServerCertificate=false;TransparentNetworkIPResolution=true;serverNameAsACE=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;queryTimeout=-1;packetSize=8000;multiSubnetFailover=false;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=false;databaseName=Confluence620_QA;columnEncryptionSetting=Disabled;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite;

You can see the database latency and other information in below image


system information.JPG

Thank you





1 answer

1 accepted

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Confluence

Confluence Mythbusters: Does Atlassian even use Confluence?

Hi, Confluence collaborators! As part of #Confluence-Collaboratory month, we’ve created a very special Mythsbusters segment, where we're dive into an interesting myth and uncover the truth behind i...

1,710 views 7 32
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you