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

Upgrade 5.9.5 to 5.10.8 on test runs into an error

As a preparation to upgrade my confluence production environment from 5.9.5 to 5.10.8 i'm running into an error:
Upgrade failed. Please consult the system logs for details. You will need to fix these problems, restore your database and confluence home directory to the pre upgrade state. Then retry the upgrade.

In Confluence log I find the following error:
ncategorized SQLException for SQL []; SQL state [S0002]; error code [208]; Invalid object name 'scheduler_clustered_jobs'.; nested exception is java.sql.SQLException: Invalid object name 'scheduler_clustered_jobs'.

Looking into database both in test as in production I'm missig an table named scheduler_clustered_jobs
What to do now?

2 answers

1 accepted

0 votes
Answer accepted

How can I check schema names in confluence.cfg.xml? In SQL Server schema name both in test and prod are dbo, but I cannot  verify this in configfile. There it is both like:

property name="hibernate.connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>

<property name="hibernate.connection.isolation">2</property>

<property name="hibernate.connection.password"></property>

<property name="hibernate.connection.url">jdbc:jtds:sqlserver://localhost:1433/Confluence</property>

<property name="hibernate.connection.username">Confluence</property>

Arno, 

The article actually mentions that it's in conf/server.xml but I'm not able to see there what needs to be modified.

In my search, I discovered you already created a support ticket. I will take that ticket for now, and I ask that you send a copy of your support zip there so I can see your full logs to get a better idea of the problem.

Thank you for your help!

Kind regards,

Shannon

1 vote

Arno,

Can you let us know the version of SQL you are running, and also make sure that your schema names are consistent?

Thank you!

Kind regards,

Shannon

Hi Shanon, the SQL version in test is 2014. However in production this is stil 2008. As we're running out of support with our Confluence version end this week, we want to first upgrade Confluence to the next step Confluence and migrate Confluence to a new Windows server version and SQL version after that

Arno,

Thank you for confirming. When you have a chance, please let me know what the results of your schema tests were.

Kind regards,

Shannon

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published Thursday in Confluence

Confluence CVEs and common questions

Two vulnerabilities have been published for Confluence Server and Data Center recently: March 20, 2019 CVE-2019-3395 / CVE-2019-3396 April 17, 2019 CVE-2019-3398 The goal of this article is...

258 views 0 12
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you