Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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

Can I install an older version of confluence and is a Confluence DB having 3 build numbers OK? Edited

I work with 2 JIRA/Confluence server instances. Inst-A, which I do not control and Inst-B which I have full control over.  Inst-A has been using long term release versions while in Inst-B I had been been trying to keep up to date with the latest license versions though Inst-B did fall out of use for at least 6 months.

Recently, I was asked to get Inst-B working again and matched version-wise with Inst-A which means, for Confluence, installing a lower version than was already installed.

1) On Inst-B, I installed Confluence 7.4.8, build number 8402. However, I replaced 7.8.x,, build number 8502.   Now my confluence.cfg.xml and database CONFVERSION both show 8502.  I thought I could manually edit confluence.cfg.xml and use the SQL

UPDATE CONFVERSION 
SET VERSIONTAG = NULL,
BUILDNUMBER = 7201
WHERE CONFVERSIONID = 4560123456;

using 8402 for the BUILDNUMBER and CONFVERSIONID 13959171

2021-04-26_15-04-16_Image 001.jpg

as explained in  

https://confluence.atlassian.com/confkb/confluence-will-not-start-up-because-the-build-number-in-the-home-directory-doesn-t-match-the-build-number-in-the-database-after-upgrade-376834096.html

Does this seem reasonable or should I go about it a different way?

2) Running

select * from CONFVERSION;

shows me there are 3 build numbers in our confluence database, please see above picture.  Is this "normal"? Should I delete 2 of them so there is only 1 build number in the DB?

Thank You for your help,

Jim

 

2 answers

1 accepted

1 vote
Answer accepted

You should not be messing with the numbers in the database (in fact, just don't even look at the database)

More specifically, in this case, you say "which means, for Confluence, installing a lower version than was already installed.".  Nope, don't do that, downgrades often completely fail and mess up the data in interesting ways.

"You should not be messing with the numbers in the database (in fact, just don't even look at the database)"  

Nick, I'll gladly not look at the numbers in the database!

" . .  often completely fail and mess up the data in interesting ways."

I think "Interesting ways" actually means you'll wish you never, ever tried to downgrade.

OK, Nick.  I'll take your advice.

Thank you for your reply. I truly appreciate it.

Jim

To be fair, sometimes, it can work (most important is that the database structure has not changed between the current and older version).  But it's a world of hurt getting it there and being 100% sure everything is ok.

Absolutely right about "interesting ways" - the one that taught me that lesson was not so much a downgrade attempt that broke anything day-to-day, it was that a year later, it had rendered the Confluence completely un-upgradable - it failed no matter what version it went to.  Ended up having to manually export and import 450 spaces, one at a time, and then redacted the handful that could not be exported because of the break!

Oh, and I forgot - the technical reason that there are three lines in the database for version is simply that those are the upgrades that this Confluence has been through at some point!

Those are not strictly upgrades triggered by an admin, a lot of the upgrade packages actually don't re-invent any wheels, internally they trigger a string of pre-existing upgrades.   For example, you've got 8202, 8301 and 8502 builds in there.  If you've jumped from 8202 to 8502, then the code for 8502 includes the code for an 8202 -> 8301 and 8301 -> 8502, so when you asked it to upgrade, it just went "ok, I'll chain two upgrades together".

0 votes

truly helpful article , keep it up.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
7.4.8
TAGS
Community showcase
Published in Confluence

🥓🙅🏻‍♀️ Meet-less May Badge!

Hello Confluence Community!  What if i told you that you could have a healthier life and be 100% meet-less? This month, we're promoting a healthy, balanced work diet with Confluence. We la...

131 views 2 12
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