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

I want to upgrade confluence atlassian-confluence-6.11.0 to 7

I need to your help for upgrade the same.

1 answer

1 vote
bitvoodoo_nick Community Leader Sep 19, 2019

Hi there @spgorde 

Here if the guide for upgrading Confluence https://confluence.atlassian.com/doc/upgrading-confluence-4578.html

And if you face issues, let us know so we can help. :)

Cheers
Niklas

Thanks Niklas. I have followed same steps but I am getting JDBC error once start confluence with new version.

bitvoodoo_nick Community Leader Sep 19, 2019

This points to an error with the database connection. What does the error tell?

What Database are you using?

Hello Niklas,

 

We are using Embedded H2 Database and its present on confluence server. Can you please let me know exact steps so I can do it. I have also copy MySQL Driver but getting JDBC error.

 

Description:

Unable to start up Confluence. Fatal error during startup sequence: confluence.lifecycle.core:mananagedjobs (Start and stop the Managed Scheduled Jobs)

 

Exception:

JDBC exception on Hibernate data access: SQLException for SQL [n/a]; SQL state [HY000]; error code [50000]; could not extract ResultSet; nested exception is org.hibernate.exception.GenericJDBCException: could not extract ResultSet

I have research on this issue and found that the fix is the same; we need to get off of the H2 database and below is plan of action for same.
1. Roll back the instance by restoring the backup you made prior to attempting the upgrade. Do this by creating a fresh Confluence install (I would recommend using the same version of Confluence that we used to create your XML backup). Restore the XML backup to this.
2. Get that site working normally first.
3. Then connect to a supported database.
4. Proceed with the upgrade.
Alternatively, you can just try this method:
1. Install a fresh copy of the desired version of Confluence.
2. Connect to a supported database.
3. Restore your XML backup.
The first method is more thorough but users have been able to recover with the second method.
 
[root@sinconfluence database]# ll
total 1011660
-rw-r----- 1 root root 1223327744 Sep 20 14:00 h2db.h2.db
-rw-r----- 1 root root 99 Sep 15 02:00 h2db.lock.db
-rw-r----- 1 root root 3337544 Sep 3 13:57 h2db.trace.db
-rw-r----- 1 root root 67248216 Sep 3 13:39 h2db.trace.db.old
[root@sinconfluence database]# pwd
/var/data/confluence/database
[root@sinconfluence database]#
 
Need to know what exact steps for upgrade?

How to migrate H2 database to MYSQL

bitvoodoo_nick Community Leader Sep 20, 2019

Hi there

H2 Database is generally not supported and recommended for a productive installation. Only for an evaluation. So maybe something went wrong with the update.

For migrating follow this general guide by Atlasssian: https://confluence.atlassian.com/doc/migrating-to-another-database-148867.html

Info on the H2 database by atlassian here: https://confluence.atlassian.com/doc/embedded-h2-database-145098285.html

Cheers
Niklas

Thanks Niklas for give valuable information. The above confluence server configured in past and this is new for me.  I will check given URL's.

 

There is not any way to take help from Atlassian support team for remote check ?

 

Thanks & Regards

Som

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

How is your team having fun and bonding, remotely, utilizing Confluence?

Thanks everyone for answering last week’s question. The winner of the random drawing from those who commented is: @LarryBrock I’ll contact you separately with your prize details. This wee...

306 views 9 7
Join discussion

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