Process steps to handle the database-upgrade-error-column-to-be-renamed-is-used-in-a-virtual-column-expression

Depended  on this article:

https://confluence.atlassian.com/bitbucketserverkb/database-upgrade-error-column-to-be-renamed-is-used-in-a-virtual-column-expression-827098665.html

As I understand correct, that I must do the following steps:

  1. shut down all Bitbucket DC applications (4.0.4)
  2. Disable the Extended Statistics feature of Oracle 12 DB by my Oracle Admin
  3. Removing columns created by Extended Statistics feature  by my Oracle Admin
  4. Start again my Bitbucket DC applications (4.0.4)
  5. Check that all is working fine
  6. Again shut down all Bitbucket DC applications (4.0.4)
  7. Update to Bitbucket DC applications (4.8.6) (DB will be renamed)
  8. shut down my new Bitbucket DC applications (4.8.6)
  9. Enable the Extended Statistics feature of Oracle 12 DB by my Oracle Admin
  10. Start all new Bitbucket DC applications (4.8.6)
    --Finish--

1 answer

0 vote

H iThomas,

Yes the procedure is correct as you mentioned.

The only thing I would like to add are:

  • Be sure to perform a full backup of your existing instance, including the db before proceeding with the change.
  • Is not mandatory to re-enable the Extended statistics after the upgrade but if you wish to do so please be sure you keep track of this in your internal upgrade procedure so to avoid getting the same issue at your next upgrade.

Aside from that I would suggest you to continue the conversation back in the ticket you have open with us so to receive a better support experience.

 

Please let me know if you have any question.

Best Regards,
Daniele Carcasole

 

Suggest an answer

Log in or Join to answer
Community showcase
Piotr Plewa
Published Dec 27, 2017 in Bitbucket

Recipe: Deploying AWS Lambda functions with Bitbucket Pipelines

Bitbucket Pipelines helps me manage and automate a number of serverless deployments to AWS Lambda and this is how I do it. I'm building Node.js Lambda functions using node-lambda&nbsp...

709 views 0 4
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot