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

[spgorde]

I need to your help for upgrade the same.

[Sloan]

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

[spgorde]

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

[Sloan]

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

What Database are you using?

[spgorde]

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

[spgorde]

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?

[spgorde]

How to migrate H2 database to MYSQL

[Sloan]

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

[spgorde]

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