Upgrading Confluence

This document describes the procedure for upgrading to the latest version of Confluence on Windows or Linux.

Before you start

  • Check your Confluence licence is valid.
    To check go to  > General Configuration > Atlassian Support Tools > Health Check and make sure the license support period has not expired. If your support period has expired renew your licence and reapply it before proceeding with the upgrade.
  • Check the latest database setup guide for your database and ensure that the database is configured correctly. There may be new configuration requirements. See Database Configuration.
  • Make a note of any modifications to your Confluence instance (for example layouts or a custom theme).
    Any customisation you wish to maintain will need to be reapplied after upgrading. 

Step 1 Determine your upgrade path and method

Find the upgrade path that works for your current version of Confluence and the version you plan to upgrade to.

The following table will help you to determine the most efficient upgrade path from your current version to the latest versions of Confluence. To use the table find your current installed version of Confluence in the left column and follow the suggested path.

Your Version

Recommended upgrade path to Confluence 5

2.7 or earlier Upgrade to 2.7.4 then upgrade to 3.5.17, and follow paths below.
2.8 to 3.4 Upgrade to 3.5.17, and follow paths below.
3.5

Upgrade to 5.0.3 then upgrade to the latest version of Confluence 5.

4.0 to 4.3 

Upgrade directly to the latest version of Confluence 5.

5.0 to 5.8 

Upgrade directly to the latest version of Confluence 5.

There are several factors that will determine the upgrade method you should use. If you:

  • Are upgrading from a version earlier than Confluence 3.5 you will need to upgrade manually. You can contact Support for help determining an appropriate upgrade path.
  • Are moving to a different operating system or file location you should upgrade manually.
  • Currently use the EAR/WAR distribution to deploy Confluence into an existing application server, you can only upgrade manually.
  • Are moving to a different database you should upgrade using the installer first and then follow the procedure outlined in migrating to a different database.
  • Have a clustered instance of Confluence you should follow the procedure outlined in Upgrading Confluence Data Center.
  • Are using the embedded (trial) database you should migrate to a different database before upgrading. This database is supplied for evaluation purposes only and is not recommended for production environments. See embedded HSQLDB database for more information.

otherwise you should follow the instructions below and use the Windows or Linux installer to upgrade Confluence.

Step 2 Upgrade Confluence in a test environment

We strongly recommend you recreate your production instance and test the upgrade in this cloned environment.

  1. Create a snapshot of your current production Confluence environment on a test server - see Moving Confluence Between Servers for how to do this.
  2. Follow the steps below to perform the upgrade on your cloned environment.
  3. Test all your unsupported add-ons (plugins) and any customisation (for example custom themes and layouts) with the new version before proceeding with the upgrade in your production environment.

Step 3 Back up 

Before you begin the Confluence upgrade you must back up:

  • your external database
    You must perform a manual backup of your external database and confirm that the backup was created properly. If you are unfamiliar with the backup-restore facilities of your database, you can simply restore the backup to a different system to ensure the backup worked before proceeding.
  • your Confluence Home directory
    The Confluence Home directory is the folder where Confluence stores its configuration information, search indexes and page attachments.  The location of the Home directory is stored in a configuration file called confluence-init.properties, which is located inside the confluence/WEB-INF/classes directory in your Confluence Installation directory.
    if you store attachments outside the Confluence Home directory, you should also backup your attachments directory. 
  • the Confluence installation directory 
    This is where the Confluence application files and libraries were unpacked (unzipped) when Confluence was originally installed.

The installation wizard will back up your Confluence directories as part of the installation process, but you should also back these directions up manually before starting the upgrade. 

Step 4 Upgrade Confluence in your production environment

  1. Download the appropriate Windows or Linux installer from the Confluence Download Center.
  2. Start the installer:
    • Windows Users:  run the .exe file.
      If prompted to allow the upgrade wizard to make changes to your computer, choose 'Yes'. If you do not, the installation wizard will have restricted access to your operating system and any subsequent installation options will be limited.
    • Linux users: open a Linux console and change directory (cd) to the '.bin' file directory and execute the '.bin' file. 
      If the '.bin' file is not executable after downloading it, make it executable, for example chmod a+x atlassian-confluence-5.6.1-x64.bin (specify the exact filename of the installer you downloaded).
  3. The installation wizard will guide you through the upgrade process.  Some things to note:
    1. When prompted choose Upgrade an existing Confluence installation (for Linux users this is option 3).
    2. Verify that the Existing Confluence installation directory suggested by the wizard is correct. This is especially important if you have multiple Confluence installations running on the same machine.
    3. At the 'Back up Confluence directories' step, ensure 'Back up Confluence home' is selected. This will create a .zip backup of the Confluence home and installation directories. This is strongly recommended.
    4. The installation wizard will notify you of customisations in the Confluence Installation directory. Make a note of these before proceeding as you will need to manually reapply these customisations after the upgrade is complete.
    5. If you have not already done so, the wizard will prompt you to backup your external database and check plugin compatibility. If your database does not support online backups you will need to stop the installation wizard at this point.
  4. The wizard will shut down your Confluence instance and proceed with the upgrade. Once complete, it will restart Confluence and you can then launch Confluence in your browser to confirm the upgrade was successful.

During the upgrade the wizard will migrate following from your existing Confluence installation:

  • TCP port values in your server.xml file. 
  • Custom values in your confluence-init.properties (confluence.home property) and setenv.sh / setenv.bat files (CATALINA_OPTS or JAVA_OPTS parameters) 

If you are using an Oracle or MySQL database, you'll need to copy the jdbc driver jar file from your existing Confluence installation directory to confluence/WEB-INF/lib in your new installation directory.

(warning) Other configurations or customisations (including any other modifications in the server.xml file) are not migrated during the upgrade and need to be reapplied manually. See below for more information.

Additional steps when customisations are present

The installation wizard's ability to notify you about customisations will depend on how your existing Confluence instance was installed:

  • If your current Confluence instance was installed using the installer, the wizard will check the entire Confluence Installation directory.
  • If your current Confluence instance was installed manually it will only check the confluence subdirectory of the Confluence Installation directory. The installation wizard will not notify you of modifications in any other directory, for example modifications to start-up scripts under the bin directory or modifications to the server.xml file (such as an SSL configuration). 

If customisations are present you will need to perform the following steps after the upgrade is complete:

  1. Stop the upgraded Confluence instance.
  2. Reapply the customisations to the relevant files in the upgraded Confluence Installation directory.
  3. Restart the upgraded Confluence instance.

We strongly recommend you test your customisations in a test instance prior to upgrading your production instance as changes may have been made to Confluence that make your customisations unsuable.

Troubleshooting

Did something go wrong?

If you need to retry the upgrade, you must restore your pre-upgrade backups first.  Do not attempt to run an upgrade again, or start the older version of Confluence again after an upgrade has failed. 

Some common issues encountered while upgrading:

  • Cannot proceed with upgrade because license has expired
     If your licence has expired and was not renewed and reapplied before upgrading you will receive errors during the upgrade process. See upgrading beyond current license period for information on how to resolve this problem.
  • Unable to proceed with upgrade because of a conflict with anti virus
    Some anti-virus or other Internet security tools may interfere with the Confluence upgrade process and prevent the process from completing successfully, particularly if you run Confluence as a Windows service. If you experience or anticipate experiencing such an issue with your anti-virus / Internet security tool, disable this tool first before proceeding with the Confluence upgrade.
  • Database does not support online backups
    The upgrade wizard will prompt you to backup your database using your database's backup utilities. If your database does not support online backups, stop the upgrade process, shut down Confluence, perform your database backup and then run the installer again to continue with the upgrade.
  • Upgrade is taking a very long time
    If you have a very large database (i.e. database backups take a very long time to complete), setting the confluence.upgrade.recovery.file.enabled system property to false will speed up the upgrade process. It should be used only when there is a process to back up database and verify the backup before performing an upgrade.

You can also refer to the Upgrade Troubleshooting guide in the Confluence Knowledge Base, or check for answers from the community at Atlassian Answers.
 

Was this helpful?

Thanks for your feedback!

139 Archived comments

  1. User avatar

    Anonymous

    I don't want to rant, but what's the point of a semi automatic updater?

    E.g. this:

    TCP port values in your existing Confluence installation's server.xml file. (warning) Be aware that other configurations or customisations in this file are not migrated during upgrade, and will need to be re-applied.

    If I have to migrate other settings manually (which I think a lot of us will have to), I might as well adjust the port as well because I have to edit the file anyway. Chances are, I'll just replace the whole tag if other changes were made as well (IP bind for example).

    It's nice Confluence detects, what was changed/deleted/what ever but if it can detect the changes, why not go one more step and migrate them as well?

    An automatic upgrade would be an excellent feature which'd save a lot of time. But as it is now, it seems pretty useless to me. I just have a hard time believing that this upgrade function does the trick for anyone who uses Confluence for professional purposes.

    20 Sep 2011
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi,

      I understand the frustration with not handling the customisations of server.xml . It is actually technically very challenging to come up with a good solution to the problem. Here are the reasons for the approach we have taken:

      • the format of the tomcat's server.xml may change from version to version therefore we cannot just copy the old one
      • there can be a huge variety of customisations to the server.xml and we cannot cover all those changes and carry them over. E.g. customers can add new connectors for ssl, mod_proxy, mod_jk and many other or they can add jndi resources or change the parameters of any of the tags. We simply cannot cover everything.
      • It is possible that customisations in server.xml depend on external files that don't get copied during migration (e.g. ssl certificate file if he lives inside the installation directory.

      There is a discussion for the approach we took in this issue (it's JIRA's issue, but we take the same approach as in confluence.

      20 Sep 2011
      1. User avatar

        Anonymous

        Thanks a lot for your explanation! I hope I didn't offend any of you. In general, I'm very pleased with Atlassian products and will surely also use them in the future.

        I really just wondered why the upgrade feature just took some of the settings and let it up to me, to do the rest anyway. But now it makes perfect sense.

        Thanks again!

        20 Sep 2011
        1. User avatar

          Anonymous

          To follow up on the automated upgrade and its shortcomings:

          The handling of the system user / file system permissions of the upgrade tool is not exactly what i'd expect - and far from best practice on Linux.

          While Jira seems to completely ignore permissions and just runs tomcat as root, Confluence did start tomcat with a (random?) uid 1506.

          The installer also changed all relevant files to be owned uid 1506.

          If you actually make use of a non-privileged user (which is a good thing in general and IMO quite mandatory when running things in production) - why not allow the administrator to specify the uid at least?

          Choosing a random UID and chowning files (also making them world-readable, etc) is unnecessary.

           

          Aside from that the upgrade went fine - I just had to adjust the usual tomcat config (port, AJP connector, disable http, ..) and the filesystem permissions in some places and some modifications in the start scripts.

          27 Oct 2011
      1. User avatar

        Anonymous

        I know this is an old thread, but would it be possible to give us the choice of whether to start Confluence or not when upgrading using the scripts?  The upgrade is quite useful but I have my memory settings in setenv.sh and when these are removed Confluence can crash with an out of memory error when undertaking the first start upgrade process.

        While I'm at it, I'd also like the ability to automatically restore files that were "Added" as well.

        07 Feb 2013
        1. User avatar

          Anatoli Kazatchkov [Atlassian]

          Hi, thanks for your feedback. There is an improvement opened for the behavior you are describing: CONF-24414 - On upgrade if we found there are modz in the system we cannot handle we should give the customer an option not to start confluence Open ; please vote for it. The memory settings will be migrated during the upgrade. If it is not the case can you please raise an issue for that (please attach your setenv.sh script).

          07 Feb 2013
          1. User avatar

            Simon Bear

            Thanks for that Anatoli, much appreciated.  It looks like settings in JAVA_OPTS are kept during an upgrade, but settings in CATALINA_OPTS are not (which is only used when running Tomcat, not when shutting down Tomcat).  A temporary work around is to move your CATALINA_OPTS to JAVA_OPTS after stopping Confluence but before upgrading.

            13 Feb 2013
    1. User avatar

      Anonymous

      For those of running Confluence or JIRA on Windows, I created a script that backs up and restores the customizations. Even if you determine that they can't directly be restored in your environment and would need to be merged, it at least makes the backup part easy (without having to back up all the other files):

      http://www.briantist.com/how-to/confluence-jira-windows-upgrades/

      I got tired of manually copying all the files and keeping their structure during my upgrades, as it started to add significant time. Hope this helps someone!

      27 Sep 2012
    1. User avatar

      Dick Visser (sysadmin)

      You can use diff to capture any changes you've made to an installation, then apply them later to a newer tree:

      https://confluence.terena.org/display/~visser/Upgrading+Confluence

      It "works for me", but YMMV.

      09 Aug 2013
  2. User avatar

    Anonymous

    I get the error "Unable to determine location of the home directory. 'confluence.home' was not found inside confluence-init.properties.".

    What exactly means it? My confluence.home is defined in this file as "confluence.home=/volume1/@atlassian/application-data/confluence".

    When I remove the definition of confluence.home, I get the error "An error occurred when parsing your installation directory. Unfortunately the installer will be unable to continue with the automated upgrade".

    I'm sorry if these are stupid questions, but I'm really new at this.

    21 Sep 2011
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi,

      During the upgrade the upgrader expects to find a location of the home directory defined as

      confluence.home=/path/to/confluence/home

       

      in the <INSTALLATION-DIR>/confluence/WEB-INF/classes/confluence-init.properties . It needs it to make the backup of the home directory. If it cannot find it it shows the error that you see. It seems like in your case the behavior is not what it is supposed to be (you might be hitting a bug?). Can you please raise a support issue and we will help you to find out what is happening. Please attach your original confluence-init.properties files to the issue you create (we will try to reproduce the problem locally.

      22 Sep 2011
    1. User avatar

      Anonymous

      It appears that at least in 3.5.x versions the confluence runs perfectly fine when had -Dconfluence.home set (startup parameter) with not properly set confluence.home in <INSTALLATION-DIR>/confluence/WEB-INF/classes/confluence-init.properties  file. 

      Yet the installer looks into confluence-init.properties and that causes an error.

      After setting proper confluence.home in confluence-init.properties the installer works.


      10 Oct 2012
  3. User avatar

    Tom Winter

    I just performed an upgrade of my Confluence 3.5.9 to 4.0 on my Windows Server 2008 64-bit Standard using SQL Server 2008 R2. I had my Confluence/Tomcat configured to start as a Windows service. At the end of the install, the DOS-box looking Tomcat window appeared in order to start Tomcat rather than it being started by the service. Not a big deal, as it may be hard for your installer to know I have it setup as a service.It would be nice to add a note in your installation instructions that the Tomcat window will start, and then what to do if you normally use it as a service.

    More concerning to me though is that in the Tomcat window it showed a bunch of messages with "WARNING" and I have no idea if those matter (knowing nothing about Tomcat as I do). Things like:

    2011-09-21 10:35:09,486 WARN [main] [atlassian.config.xml.AbstractDom4jXmlConfigurationPersister] saveDocumentAtomically Unable to move D:\Confluence\data\confluence.cfg.xml8782173538950445122tmp to D:\Confluence\data\confluence.cfg.xml. Falling back to non-atomic overwrite.

    Should I ignore all that stuff? A note in the instructions about this would be good.

    I does look like the upgrade went find though. 4.0 seems to be working well. Thanks!

    21 Sep 2011
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi Tom,

      Thanks for your feedback. You can safely ignore the warning you mentioned it is harmless.

      As for the service not being automatically detected - you are right it is just difficult for us to figure it out when we do the upgrade. The experience is much smoother for users who would install 4.0 and then upgrade forward to 4.0.x(and later versions). During the installation we ask if you want to install confluence as a service and when we upgrade we honor the original decision and start confluence accordingly. Unfortunately in your case (i.e. when upgrading from pre 4.0 versions) you will have the non-ideal behavior even when upgrading forward. On a plus side the old service should still work as it points to the file that now starts the newer version.

      22 Sep 2011
      1. User avatar

        Tom Winter

        Thanks. I was going to suggest just that behavior for 4.0 --> 4.0.x.

        22 Sep 2011
    1. User avatar

      Tim Moore

      I had this as well. It didn't occur to me initially that i'd need to remove the service and re-install it. A note in there would certainly have saved me an hours worth of panicking !! (tongue)

      05 Jan 2012
  4. User avatar

    Tom Winter

    Is there a way to "upgrade" the demonstration space? I renamed it to "tutorials" for my users, but after upgrading from 3.5 to 4.0, it doesn't exactly match how things work now.

    21 Sep 2011
    1. User avatar

      Mark Hrynczak [Atlassian]

      The updated demo space gets installed on a new install of Confluence 4.0. You best option would be to:

      1. Install an evaluation version of 4.0
      2. Export the new demo space to XML
      3. Delete the existing demo space (renamed "tutorials) on your production instance
      4. Import the XML space backup from step 2 into your production instance
      5. (optional) Rename it back to "tutorials"

      Hope that works for you,

      Cheers,
      Mark

      21 Sep 2011
      1. User avatar

        Tom Winter

        Good idea. Thanks! I'll give it a try.

        22 Sep 2011
  5. User avatar

    Kari Kauppinen

    I had Oracle jdbc driver in <INSTALL>/lib. It didn't get copied into the new <INSTALL>/lib directory. 

    Should the jar be in the  <confluence install>/WEB-INF/lib?

    http://confluence.atlassian.com/display/CONF35/Database+Setup+for+Oracle#DatabaseSetupforOracle-ConfiguringConfluenceDatasourceAccess

    21 Sep 2011
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi Kari,

      Thanks for your comment, we should warn people who use oracle that on upgrade they need to copy over the drivers to the new installation.

      Unfortunately Oracle is a special case because we don't bundle Oracle drivers that's why they are not in WEB-INF/lib. During the upgrade we don't move over any added files to the new installation and in case of oracle it would mean that confluence wouldn't be able to connect to a db.

      We try to warn people in general case by showing the list the customisations ( we mention it in the documentation - step 5 b) and ask to move them manually.

      22 Sep 2011
  6. User avatar

    Chris Tybur

    I performed the 3.5.5 -> 4 upgrade on a staging server and it worked fine. However, the installation directory is named the same as before, which is 'confluence-3.5.5-std'. Is it possible to safely rename that directory after the fact to something like 'confluence-4-std', or maybe even 'confluence-std'?

    Note: I'm running it on Windows 2008 as a service, and I know I would need to uninstall/reinstall that part of it. I'm mostly worried about Confluence having that path stored somewhere in its configuration.

    29 Sep 2011
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi Chris,

      Yes it is possible to safely rename the directory as long as you change everything that points to it to point to the new directory. As you mentioned - service is probably the most important but you might also have menu items or shortcuts. It is a good idea to make a name without a version so that the next time you upgrade you don't have to go through the renaming again.

      Some background on why installer doesn't change the name automatically:

      On one hand if the old directory has the version number in its name then upgrading on-top will mean the new version will sit in the directory named after an old version. On the other hand customers may have existing scripts, services, custom created menu shortcuts on windows or other environment settings that depend on the existing name of the directory. At the end we decided that preserving the environment and not breaking the existing scripts is more important and we went with the on-top upgrade option. We have also changed the suggested installation directory name for the installer - now it doesn't include a version number.

      29 Sep 2011
      1. User avatar

        Jeff Guthrie

        Where are all the spots we would need to change the directory name? Thanks!

        05 Jan 2012
  7. User avatar

    Anonymous

    HI,

     

    I want to upgrade confluence 3.5.5 to 4 on SunOS (64bit). Is there an upgrade utility to do this or will I have to upgrade manually?

     

    Thanks

    30 Sep 2011
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi,

      You will have to upgrade manually. The upgrade utility bundles(and uses) jre that will not work on SunOS.

      30 Sep 2011
  8. User avatar

    Maghiel Dijksman

    Express Install (uses default settings) [1], Custom Install (recommended for advanced users) [2, Enter], Upgrade an existing Confluence installation [3]

    3

    Existing installation directory:

    [/opt/Confluence]

     This is a bit confusing. I first was in the believe the installer/upgrader was still searching for other paths. After the process was idle for some time, i decided to enter the installation path, and the upgrade process continued. Might be an idea to prompt the user (by example: "Is this path correct? Hit enter to use the path specified or enter another path") in future versions.

    05 Oct 2011
    1. User avatar

      Maghiel Dijksman

      And another issue:

       

      If you have many attachments in your Confluence Home Directory, the zip

      archive of this directory may consume a significant amount of disk space.

      Back up Confluence home ?

      Yes [y, Enter], No [n]

      y

       

      Checking for local modifications.

      The installer/upgrader did nothing for about 10 minutes. I decided to hit enter, and suddenly the whole procedure continued.

      05 Oct 2011
      1. User avatar

        Anatoli Kazatchkov [Atlassian]

        Hi Maghiel,

        Thanks for your feedback and suggestions. The progress indicator for the command line installer is definitely a good idea, it will make the process easier to follow. The indicator will probably solve the initial confusion too (with the directory location) - it will be clear that unless the process shows it is in progress then it is waiting for user input.

        06 Oct 2011
  9. User avatar

    Anonymous

    Hi

    Environment: linux, confluence 3.5.3, Oracle as backend data base

    We do nightly backups to XML. To test 4.0, we did the normal manual
    unpack and restored from XML backup to a clean database and clean
    confluence_home. Other than a few minor hiccoughs, this seems to be
    working well.

    However, the notes above mention that this is not the recommended
    aproach. Is there a particular reason?

    Cheers
    Mark

    10 Oct 2011
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi Mark,

      Is there a particular reason?

      The only reason we recommend the automated upgrade is because it is easier and less error prone in most cases. If manual upgrade works for you better then you can safely continue with that.

      14 Oct 2011
  10. User avatar

    Anonymous

    How to set this as a service again?

    I upgraded to version 4.0

    In older version I used the bat files in the Bin directory but I cant seem getting it to work like that anymore.

    So how do I get the upgraded 4.0 version to run as a service again?

    13 Oct 2011
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi,

      it should still be possible to install windows service as described here: Start Confluence Automatically on Windows as a Service (delete your old service first though).  If you still have problems with it, please contact support and they will help you out.

      14 Oct 2011
  11. User avatar

    Anonymous

    We have 3.0.1 installation, are you recommending us to upgrade to first 3.5 and then to 4.0 ?

    Can someone please confirm.

    26 Oct 2011
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Yes, you should first upgrade to the latest 3.5.x and then to 4.0. See our upgrade notes.

      13 Dec 2011
  12. User avatar

    Anonymous

    I'm doing some studies due to a soon-to-be rollout of confluence (if things like upgrading and migration goes well...) We will use Linux/Postgres in production environment, but for evaluation purposes I'm on Win32.

    When upgrading from 3.5.13-evaluation (standalone) to 4.0.5-x32 (standalone) the installer quits with error dialog box showing something similar to "Not a valid directory". There's no way to continue from here.

    I have one 4.0.5-x32 installation in C:\Confluence (and C:Confluence-Data) and now I was testing upgrading from 3.2 to 4.0.5 in a separate catalog C:\ConfluenceTest (yes, via subsequent upgrades to 3.3, 3.4 and 3.5 respectively - this hurts...). And the final upgrade from 3.5 to 4 failed.

    Any hints?

    07 Dec 2011
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi,

      I understand you get this message:

      The directory you have selected is not a valid Confluence installation directory.

      This message is shown when the upgrader cannot recognize the structure of the installation directory. In particular we are looking for confluence subdirectory inside the installation directory and if we cannot find it we show this message. In your case the upgrader expects to see C:\ConfluenceTest\confluence .  

      You can always fall back use the manual upgrade method to upgrade from 3.5 to 4.0 (the same steps as you used to upgrade from 3.4 to 3.5).

      You might want to contact support - they will help you with the upgrade.

      07 Dec 2011
    1. User avatar

      Tin Pham

      Hi,

      This is just my personal experience, if you are using Linux and have an experienced admin then use the tar.gz manual install instead. In Unix/Linux most good software is built independent of the OS.

      An experienced Unix admin will be able to setup a non-privileged user, some symbolic links and make Confluence pretty much independent of the OS with alot more flexibility in the future.

      For example, to upgrade from Confluence 3.5.5 to 4.1, I spent 20 minutes to read about the slight differences and quickly performed the upgrade in Staging. After that moving to say Production would simply be a matter of TARing the Confluence directory in IST and unTARing it to Production, launch Confluence and update the plugins.

      15 Dec 2011
      1. User avatar

        Anonymous

        I totally agree.    Running the bin installer stomps all over my 3.5.13 version.  Much better to extract to a separate directory and create a symbolic link to it.

        Why doesn't the bin installer do this?

        06 Jun 2012
        1. User avatar

          Anatoli Kazatchkov [Atlassian]

          Hi,

          Thanks for your input guys. There is a bit of a discussion happened on JIRA's page about the upgrader overwriting the existing dir   Re: Upgrading JIRA . Feel free to comment there as both confluence and JIRA installers work the same way.

          06 Jun 2012
  13. User avatar

    Felipe

    I have manually upgraded my test environment from 3.4.2, to 3.5, to 3.5.13, to 4.0 over the course of a few days.  In my production environment, is it possible to upgrade from 3.4.2 to 4.0 (manually)? This will save me much time ...

    13 Dec 2011
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi Filipe,

      In our  upgrade notes we specify what versions you cannot 'skip' when upgrading. In your situation you would need to do 3.4.2 to 3.5.13 and then to 4.0 upgrade.

      13 Dec 2011
  14. User avatar

    Jay Mackey

    I know this is generally a 'no-brainer' in IT circles, but there should probably be a note in the install instructions or a check-list item in the installer that anti-virus programs must be paused or disabled during installation when using the installer. Kapersky thinks the installer is trying to establish remote control, and terminates the process and quarantines the file.

    04 Jan 2012
  15. User avatar

    Anonymous

    Just successfully performed an upgrade from 3.5.5 -> 4.1.2 using the guided install, although not without some hiccups.

    We use MS SQL, and our standard server config has the "no count" option enabled.  As you know, all Atlassian apps require "no count" to be disabled; and as this is a global server-wide setting, we use a customised version of the open source jTDS driver to which we've added the ability to disable the no count option on a per connection basis.

    The problem is that after the guided install wipes the Confluence install directory and installs the new version (which includes a bundled jTDS driver, sans this customisation);  it immediately starts Confluence and proceeds with the upgrade routine. The db schema changes applied as part of this upgrade process ultimately fail (presumably due to the "no count" option being enabled).  To resolve, I had to shutdown Confluence, restore the database and home directories to their pre-upgrade state, copy over our customised jTDS driver, and restart Confluence (which re-ran the db schema upgrade process; this time successfully).

    I realise that the guided install is intended for vanilla environments, but I think it would be useful to provide a checkpoint (ie. user prompt) after the installation files have been copied, and before Confluence is started  (eg. "Start new Confluence? [y, enter]).  This would provide an opportunity for any customised files (already identified by the installer) to be copied/modified before the upgrade continues.

    10 Jan 2012
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi,

      Thanks for your feedback. Several people asked for this feature so I created a ticket for it to gauge how many people it would help. If the ticket gets enough votes for we will implement the feature.

      12 Jan 2012
  16. User avatar

    Anonymous

    I have installed/upgraded using the Standalone version for a few years now. What is the difference between the Standalone version and the Windows Installer version from an installation stand point? I am currently using version 3.5.9.  For my next upgrade, can I use the Windows Installer version to make the installation easier for myself?

    18 Jan 2012
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi

      The installer takes care of most manual steps that you otherwise would have to perform. E.g. when installing it sets the location of home directory in the right file, it is distributed with jre so you don't have to download/install it, it lets you change port numbers, it automatically creates windows service if you ask it to.

      The same executable can also be used for upgrade and it will backup all relevant directories, extract the new files will check if you have customised things and will let you know if you have to re-apply customisations manually.

      18 Jan 2012
  17. User avatar

    Anonymous

    We are currently running confluence 3.3 with very little customisation other than LDAP integration and HTTPS implementation.

    We are looking to upgrade to the latest version of Confluence but also move it to another server. Would it be possible to do an export of the 3.3 data then import to a clean install of Confluence 4.1.x?

    We are also looking at doing the same with JIRA, moving from 4.1.2 to 4.4.x.

    Is this advisable? 

    18 Jan 2012
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi,

      Depending on the size of your Confluence you might be able to perform upgrade exporting the data from 3.3 and then importing to 4.1.x. Keep in mind that only data will be preserved but not some of the settings or installed plugins.

      If you have a larger instance we generally recommend following manual steps (where you backup db and home directory manually and then configure the new version against the old home dir and pointing to the old db). The same applies to JIRA upgrade.

      18 Jan 2012
  18. User avatar

    Anonymous

    I attempted an upgrade from 4.0 -> 4.1.0.3. Should be a slam dunk right? Instead it says I have a customization to some file no one has ever touched. Then it cannot delete the home directory and so I have to ignore that to continue. Then it just fails to be able to delete some other file.

    I mean you've gotta be kidding me. Please get your documentation straight so I don't have to waste my time like this. Thank goodness I use VMWare and took a snapshot of this thing so I don't have to piece it back together with your confusing documentation.

    Oh, and I second the comment above about a semi-automatic installer. You might as well just tell us to use Beyond Compare or something and upgrade it that way so I can line by line choose to keep customizations where needed. The installer may be doing more harm than good here.

    Do you need us to run the installer as admin or something? Is that why I got the error about not being able to delete the old home directory??

    18 Jan 2012
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi,

      If you are on windows the most possible cause of 'it cannot delete the home directory' problem would be the fact that some other process has a file opened (or you simply view the directory in explorer). Windows does not allow the deletion if some other process holds on to a file descriptor.

      Do you need us to run the installer as admin or something?

      We do recommend running with admin privileges but it is not necessary if you installed it previously as normal user. In any case it would tell you that you need to run as admin if it finds that it needs admin preventives.  

      Please contact support and we will help you out with our problems.

      18 Jan 2012
  19. User avatar

    Anonymous

    Hi Anatoli,

    What is the difference between "One-Click Evaluation Installer" and "Windows Installer". When I worked on "One-Click Evaluation Installer" the Home Directory has its own path unlike the "Windows Installer" which is asking us to give the path for Home Directory...

    Please give me the details...

    Thanks...

    08 Aug 2012
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi,

      The old "One-click Evaluation Installer" was something aimed to evaluators were you could just run it, see how confluence works and then if you wanted to install confluence properly you had to go through a long manual process. The "Windows Installer" (and *nix installer for that matter) adds a lot of functionality -  proper installation/ support for upgrades/ support for Windows/Unix services/ validation that necessary ports are available and many other features. It also simplifies the process as you are no longer required to pre install JRE.

      You can still use the installer to quickly evaluate Confluence. It has 'use suggested defaults' option which makes it a 'one-click' experience.

      08 Aug 2012
      1. User avatar

        Kevin

        Hi Anatoli,

        As per my requirement I need to install "3.4.9 - One-Click Evaluation Installer (EXE)" in my environment. But I have encountered with few problems like, I am not able set the Home Directory's path according to my requirement. Can you please provide the procedure or link for the proper installation of the conflu 3.4.9.

        Cheers,

        Kevin.

        10 Aug 2012
        1. User avatar

          Anatoli Kazatchkov [Atlassian]

          Hi Kevin,

          You can check the documentation for 3.4.9 installation - Confluence Installation Guide. Is there a reason why you don't want to use the latest version of confluence?

           

          10 Aug 2012
          1. User avatar

            Kevin

            Hey Anatoli,

            Thanks for the response. Actually I am with 4.2.8, but as per my requirement I need go for 3.4.9,. And Can you suggest the ideal upgrade path for the conflu 3.4.9 to the latest version.

            10 Aug 2012
            1. User avatar

              Anatoli Kazatchkov [Atlassian]

              Hi Kevin, you will first have to upgrade to 3.5 and then to the latest 4.2.x . Here are more details on what upgrade path should be.

               

              12 Aug 2012
  20. User avatar

    Anonymous

    For the automated install, it's not clear whether the instance should be shut down first.

    11 Aug 2012
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      The installer will handle both situation. If the instance is still running it will warn you that the instance will be stopped, wait for you to confirm and then will proceed with the upgrade. If it is stopped it will go ahead with the upgrade.

      12 Aug 2012
  21. User avatar

    Anonymous

    "You do not have administrator rights to this machine and as such, some installation options will not be available."

    I prefer not to grant administrator rights to arbitrary binary blobs.  Precisely which installation options are not available?

    11 Aug 2012
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      On linux it is creating a dedicated user to run confluence and configuring right permissions for him;  plus ability to set up a service.

      On windows it is the ability to create a service.

       

      12 Aug 2012
  22. User avatar

    Anonymous

    Backing up the Confluence installation directory
    com.install4j.runtime.beans.actions.files.CreateZipFileAction failed
    Ignore [i, Enter], Quit [q]
    i
    Deleting the previous Confluence installation directory...
    Error while attempting to remove the previous installation directory. Some files may be in use. Please close all related programs and try again.

    and

    $ ls -l confluence
    total 0

    I see why I'm instructed to back up so often.

    This failed presumably because the parent of my installation directory is not writeable. (containment, you know?).  But why would the installation be allowed to continue?  And why can't the installation just happen in place?  Any decent administrator already has backups covered.  This hand-holding is unnecessary.

     
    12 Aug 2012
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi, you might want to try Upgrading Confluence Manually . It sounds like most of steps that the upgrader helps to automate are already covered by you.

      12 Aug 2012
  23. User avatar

    Theo Geelen

    Hi, i want to upgrade from 3.5.6 to 4.x on my Macbook. 

    In 3.5.x versions I find some .dmg files. in 4x version not. What file can I use on my macbook to install 4.x version without having lots of problems with the installation? 

    I'm using evaluation version for some years now with no problems at all. I'm not technical so the install script should be helping me instead of....

    thanks,

    theo 

    30 Aug 2012
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi, sounds like the best way to go for you would be to switch to the hosted offering of confluence. This way you wouldn't need to get into the technical details of running confluence and new versions will be available to you as soon as we release them.

      10 Sep 2012
      1. User avatar

        Theo Geelen

        thanks for your reply. 

        I already have a hosted version. But, I was not able to import my data from 3.5.6 into this one. How can I do that?

        thanks for now.

        theo

        10 Sep 2012
        1. User avatar

          Anatoli Kazatchkov [Atlassian]

          Hi, can you please contact support and we will help you out.

          11 Sep 2012
  24. User avatar

    prakash ganeshan

    Hi,

    I took all the below backups before upgrading from 4.1.7 to 4.3 , what in case I have to do roll things back if upgrade fails.

    1.Back up of Confluence Home Directory.
    2.Back up of database.
    3.Back up of Confluence Installation directory or Confluence webapp.
    4.If Attachments and index files are located outside your Confluence Home Directory, then backups of these directories must be performed manually.

     

    10 Sep 2012
    1. User avatar

      prakash ganeshan

      Hi ,

      Please help me on this .. is there any mechanism to roll back to previous version in case of failure while upgrading.

      11 Sep 2012
      1. User avatar

        Anatoli Kazatchkov [Atlassian]

        Hi Prakash,

        In order to rollback you would need to delete the newly installed version and restore the data that you have just backed up. We don't have a dedicated page that lists the rollback steps, but this page might be useful for you.

        12 Sep 2012
  25. User avatar

    Anonymous

    Any problem with upgrading from 2.10.2   to the most current version?

    11 Sep 2012
  26. User avatar

    Klaus Feldmann

    Please post hints for upgrading a confluence 3.5.13 on a Mac server to Windows or Linux Server.

    Mac was best for me and worked for years without big trouble. Is  it better to use Linux or Windows? Do you expect that Atlassian will drop support for Linux as they did for Mac sooner or later?

     

    14 Sep 2012
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi Klaus, we support both Linux and Windows and are not going to drop support for them. Majority of our customers run Confluence on Linux.

       

      17 Sep 2012
  27. User avatar

    Anonymous

    A special upgrade guide for OS X is missing - only Update for Linux and Windows is described. There's no installer distribution for Mac OS but a tar archive like in previous versions of Confluence.

    24 Nov 2012
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Indeed, there is not installer distribution for Mac OS. Upgrading Confluence Manually document describes how you can upgrade confluence without the installer( looks like you already knew about it).

      25 Nov 2012
  28. User avatar

    Anonymous

    We have upgrade our confluence from 4.0 to 4.3 successfully. But on Dashboard, there are lots of pages show "Corrected links that should have been relative instead of absolute.". How can we correct it? Thank you.

    18 Jan 2013
  29. User avatar

    HendersonD

    I am on Confluence 3.5.17 using Adaptavist Theme Builder 4.2.3 which is supported

    I upgraded to Confluence 4.2.4 using the Windows installer. Once it finished, my login page was a mess to the point I could not even login. There were error messages on the login page and I picked out this:

    com.adaptavist.confluence.builder.macros.tools.ShowMacro

    It appears that I need a new version of the Theme Builder plugin. It is a catch22 though, I cannot not install the new Them builder plugin because I cannot login. Any suggestions?

    18 Feb 2013
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      HI HendersonD,

      You will need to disable the plugin/restart the server and then install the new version of the plugin. To bypass the login page you can try logging in via the url parameters and going directly to the plugin : http://YOUR_SERVER_URL/admin/viewplugins.action?os_username=ADMIN_USERNAME&os_password=ADMIN_PASSWORD&pluginKey=com.adaptavist.confluence.themes.sitebuilder . This url will give you the old UI for disabling a plugin: 

      If this doesn't work another possible way is to disable the plugin by modifying data in the database and then restarting the server. Once the plugin is disabled confluence will fall back to the default theme and you will be able to log in and install the new version of the theme builder. Can you please contact support and they will help you out.

      18 Feb 2013
  30. User avatar

    Harald Mueller

    After Upgrading from 4.3.2 to 5.0.1 Space Directory stays empty.

    I can reach and view all spaces via display/SPACEKEY, the spacedirectory also shows categories from the existing labels, but

    the directory allways shows 'No spaces found'.

    Could that be an indexing issue? Is the way to recreate the index from scrtach still the same as in How to rebuild the content indexes from scratch?

    07 Mar 2013
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi Harald Mueller,

      We do populate the list of spaces in the Space Directory by looking them up in the index. If the index is broken you won't see any directories there. Rebuilding the index should help.

      07 Mar 2013
  31. User avatar

    Paolo Compieta

    I'm a bit puzzled: header in this space says Confluence 5.1 developer (EAP) releases only, but official download page (linked by this page) points to 5.1 archives as if 5.1 was the latest official downloadable release. What version shall we upgrade to in production, 5.0.3 or 5.1? Thanks

    29 Mar 2013
    1. User avatar

      Sarah Maddox [Atlassian]

      Hallo Paolo

      So sorry for the confusion, and thanks for giving us this information! The header was wrong. I've fixed it now. The latest official, production-ready downloadable release is Confluence 5.1.

      Cheers, Sarah

      30 Mar 2013
  32. User avatar

    Curtis Goggins

    I am trying to upgrade from 4.1 to 5.1.  When I run the installation wizard and select upgrade an existing confluence installation and my current version it says that my home directory can not be the same as my installation directory.

    10 Apr 2013
  33. User avatar

    E P

    Am I going mad? I've just downloaded the standalone 5.1.1 tar.gz file (for the Mac ) and there isn't a .bin file to launch.

    19 Apr 2013
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi E P

      You are not going mad (smile). Mac doesn't have automatic installer/upgrade only Windows and Linux do. For Mac you have to follow Upgrading Confluence Manually guide. 

      22 Apr 2013
  34. User avatar

    Anonymous

    download:
    atlassian-confluence-5.1.2-x64.bin
    sudo chmod +x atlassian-confluence-5.1.2-x64.bin
    as root: ./atlassian-confluence-5.1.2-x64.bin

    chose upgrade mode
    .
    .
    .
    ERRORS:
    new ~/conf/server.xml didn't get old entries for oracle database connections    

    forced into:
    Apr 26, 2013 10:14:45 AM org.apache.catalina.startup.Catalina start
    INFO: Server startup in 9466 ms
    Apr 26, 2013 10:14:50 AM org.apache.catalina.core.StandardServer await
    WARNING: StandardServer.await: Invalid command '' received
    Apr 26, 2013 10:15:40 AM org.apache.catalina.core.StandardHostValve custom
    SEVERE: Exception Processing ErrorPage[errorCode=500, location=/500page.jsp]
    java.lang.NullPointerException
            at com.atlassian.spring.container.ContainerManager.getComponent(ContainerManager.java:33)
            at com.atlassian.confluence.setup.sitemesh.PluginDecoratorMapper.getPluginAccessor(PluginDecoratorMapper.java:74)
            at com.atlassian.confluence.setup.sitemesh.PluginDecoratorMapper.getDecorator(PluginDecoratorMapper.java:23)
            at com.opensymphony.module.sitemesh.mapper.AbstractDecoratorMapper.getDecorator(AbstractDecoratorMapper.java:45)
            at com.opensymphony.module.sitemesh.mapper.InlineDecoratorMapper.getDecorator(InlineDecoratorMapper.java:41)
            at com.atlassian.confluence.util.profiling.ConfluenceDecoratorSelector.selectDecorator(ConfluenceDecoratorSelector.java:59)
            at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:83)
            at com.atlassian.confluence.util.profiling.ProfilingPageFilter.doFilter(ProfilingPageFilter.java:44)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
            at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:71)
            at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     
                                
    configured server.xml manually!

    ---
                                
    ojdbc6.jar missing after update in ~/lib/ and ~/confluence/WEB-INF/lib/

    forced into:
    INFO: Starting service Tomcat-Standalone
    Apr 26, 2013 10:47:57 AM org.apache.catalina.core.StandardEngine start
    INFO: Starting Servlet Engine: Apache Tomcat/6.0.35
    2013-04-26 10:47:58,357 INFO [main] [com.atlassian.confluence.lifecycle] contextInitialized Starting Confluence 5.1.2 [build 4224 based on com
    mit hash 875a2723d3ca93f267db5c35cdbfcf91f5910d2d]
    Apr 26, 2013 10:48:06 AM org.apache.coyote.http11.Http11Protocol start
    INFO: Starting Coyote HTTP/1.1 on http-8090
    Apr 26, 2013 10:48:06 AM org.apache.catalina.startup.Catalina start
    INFO: Server startup in 9256 ms
    Apr 26, 2013 10:49:02 AM org.apache.coyote.http11.Http11Protocol pause
    INFO: Pausing Coyote HTTP/1.1 on http-8090
    Apr 26, 2013 10:49:03 AM org.apache.catalina.core.StandardService stop
    INFO: Stopping service Tomcat-Standalone
    Apr 26, 2013 10:49:03 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
    SEVERE: The web application [] registered the JDBC driver [org.hsqldb.jdbc.JDBCDriver] but failed to unregister it when the web application wa
    s stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
    Apr 26, 2013 10:49:03 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
    SEVERE: The web application [] registered the JDBC driver [com.mysql.jdbc.Driver] but failed to unregister it when the web application was sto
    pped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
    Apr 26, 2013 10:49:03 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
    SEVERE: The web application [] registered the JDBC driver [org.postgresql.Driver] but failed to unregister it when the web application was sto
    pped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
    Apr 26, 2013 10:49:03 AM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap
    SEVERE: The web application [] created a ThreadLocal with key of type [java.lang.ThreadLocal] (value [java.lang.ThreadLocal@44660f6a]) and a v
    alue of type [org.dom4j.DocumentFactory] (value [org.dom4j.DocumentFactory@87e1b3b]) but failed to remove it when the web application was stop
    ped. This is very likely to create a memory leak.
    Apr 26, 2013 10:49:03 AM org.apache.catalina.loader.WebappClassLoader clearThreadLocalMap
    SEVERE: The web application [] created a ThreadLocal with key of type [com.atlassian.core.logging.ThreadLocalErrorCollection$2] (value [com.at
    lassian.core.logging.ThreadLocalErrorCollection$2@ac87d32]) and a value of type [java.lang.Boolean] (value [false]) but failed to remove it wh
    en the web application was stopped. This is very likely to create a memory leak.
    log4j:ERROR LogMananger.repositorySelector was null likely due to error in class reloading, using NOPLoggerRepository.
    Apr 26, 2013 10:49:04 AM org.apache.coyote.http11.Http11Protocol destroy
    INFO: Stopping Coyote HTTP/1.1 on http-8090


    copied to destination manually!


    Hope it will work better next time!

    26 Apr 2013
  35. User avatar

    Ray Hundley

    I would like to upgrade Confluence from 4.0.3 to 5.1.2.  Can I upgrade directly to 5.1.2 or is it recommended I upgrade to a 4.* point release like 4.37 first then upgrade to 5.1.2?

     

     

    13 May 2013
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi Ray, you should be able to upgrade directly to 5.1.2. When upgrading please keep in mind that we have made a lot of changes to Confluence's UI in v5.0 and if you would need to upgrade your plugins to compatible versions. More info: Confluence 5.0 Upgrade Notes

      13 May 2013
  36. User avatar

    Anonymous

    Hi, 
    This fails for me after the upgrade I get a page with the following error.

    Confluence will not start up because the build number in the home directory [3281] doesn't match the build number in the database [3277].

    Have I missed something?

     

    Daniel

    11 Jun 2013
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi Daniel, 

      It sounds like your home directory is out of synch with the data in your database. Can you please contact support and we will help you out.

      12 Jun 2013
  37. User avatar

    iWiki wooriwm

    Hi..

    Upgrade from 5.1.4 to 5.2 beta1 fails with the following error..

    SQL mus be change :  LEN(p.entity_name - 4) ==>  LEN(p.entity_name) - 4

    error log

    2013-07-12 08:22:33,949 ERROR [main] [atlassian.confluence.upgrade.UpgradeLauncherServletContextListener] contextInitialized Upgrade failed, application will not start: Upgrade task com.atlassian.confluence.upgrade.upgradetask.EmbeddedCrowdPropertySetFactoryMigrationUpgradeTask@1a961d2 failed during the UPGRADE phase due to: PreparedStatementCallback; SQL [select p.entity_name, p.entity_key, u.user_key from OS_PROPERTYENTRY p left join user_mapping u on lower(SUBSTRING(p.entity_name, 5, LEN(p.entity_name - 4))) = u.lower_username where entity_name like ? and entity_id=?]; nvarchar 값 'CWD_300158'을(를) 데이터 형식 int(으)로 변환하지 못했습니다.; nested exception is java.sql.SQLException: nvarchar 값 'CWD_300158'을(를) 데이터 형식 int(으)로 변환하지 못했습니다.


     

    11 Jul 2013
    1. User avatar

      Paul Curren

      Thanks very much for raising this issue. We'll try to get the problem addressed before the next beta.

      Could you tell me what database you are using?

      12 Jul 2013
      1. User avatar

        iWiki wooriwm

        Thanks

        Use Microsoft SQL Server (Production 2005, Dev 2008 R2 Express)

         

        12 Jul 2013
  38. User avatar

    Torben Rydiander

    We've just upgraded from version 5.1.5 to 5.2.3 on windows and now some vital plug-ins doesn't work.

    We would like to go back to previous version and we said yes to the backup during upgrade. Do you have a description on that?

    We're so far using the internal database.

    22 Aug 2013
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi Torben, 

      To rollback you will have to:

      • uncompress the previous version of installation directory (copy it in the location where home directory lives after deliting the current one)
      • uncompress the previous version of home directory (copy it into the location where installation directory lives after deliting the current one)
      • start confluence

      If you have any problems with that please contact support and we will help you out. 

      Also, before doing the rollback you can check if the plugins that are broken in 5.2.3 have new versions released that are compatible with 5.2.3. Upgrading those plugins might fix the problem.

       

      22 Aug 2013
  39. User avatar

    Torben Rydiander

    Hi Anatoli,

    Thanks a lot. It worked fine. I was unsure if there were any Registry settings preventing me from doing it that easy.

    We did look into the plugins, but they were not upgraded yet. One was from Atlassian.

    23 Aug 2013
  40. User avatar

    David Joseph

    is there a way to preserve application links when upgrading.. and the proxy settings ..

    23 Aug 2013
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi David, 

      the upgrade should preserve the application links (unless you are moving the instance to a different url). However the proxy settings will have to be transferred manually. 

      09 Sep 2013
  41. User avatar

    Anonymous

    Could you please suggest me a best way to upgrade from 3.4.9 to the latest version(5.x)?

    06 Sep 2013
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi

      • Upgrading from an early version of Confluence. If you are upgrading from a version earlier than Confluence 3.5, you must use the manual upgrade procedure. See Upgrading Confluence Manually.
      09 Sep 2013
  42. User avatar

    Anonymous

    Please update your doco. This:

    should say:

     

     

    24 Sep 2013
  43. User avatar

    Anonymous

    Just ran a test upgrade from Confluence 5.2.3 to 5.3 and get the following http 500 error on page load.

    type Exception report

    message

    description The server encountered an internal error () that prevented it from fulfilling this request.

    exception

    org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Unable to perform find; bad SQL grammar []; nested exception is org.postgresql.util.PSQLException: ERROR: column this.external_id does not exist
      Position: 484
    	org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97)
    	org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
    	org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364) etc......
    16 Oct 2013
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi, 

      Can you please contact support and we will help you out. It is difficult to see what the problem is from the stack trace you posted. 

      16 Oct 2013
      1. User avatar

        Neil

        I am also having this exact same issue. Upgrading from 5.2.3 to 5.5

        11 Jul 2014
  44. User avatar

    Joerg Sauer

    Hi,

    after upgrading the Like function is not working any longer.

    Does anybody have the same issue?

     

    Thanks

    Joerg

    25 Oct 2013
    1. User avatar

      Paul Curren

      Thanks for the report Joerg.

      I've raised this as  CONF-31370 - Likes functionality can be broken if a following user no longer exists and the site allows anonymous access Resolved  and we will aim to have it resolved in a 5.3.x bug-fix release, soon.

      28 Oct 2013
  45. User avatar

    Anonymous

    Hi

    I'm trying to upgrade from 3.5.17 to 5.4 and got this error:

    com.atlassian.confluence.importexport.actions.RestoreLocalFileAction.action.name

    The following error(s) occurred:

     
    • Backups made prior to Confluence 4.0 (build 3047) can not be restored. This backup had build number 2176.

     

    04 Dec 2013
    1. User avatar

      Rachel Robins [Atlassian Tech Writer]

      Hi Anonymous, I strongly suggest you have a look at our guide to upgrading from Confluence 3.5 - there is not a direct upgrade path from 3.4 to Confluence 5 versions due to some very significant changes in Confluence 4 and 5. 

      This guide will take you through the whole process - Upgrading from Confluence 3.5 to 5.1 - Simplified Guide

      You can also contact support for assistance during this upgrade. 

      04 Dec 2013
  46. User avatar

    Przemek Ratajczak

    Thanks for your reply. So i need to go through version 5.0.3, i mean 3.5.17 > 5.0.3 > 5.4 ?

    05 Dec 2013
  47. User avatar

    Anonymous

    Can I upgrade Windows Confluence from running 4.3.3 directly to 5.4 in one shot instead of multiple upgrades? 

    I noticed that "If your version of Confluence is earlier than 5.1, read the release notes and upgrade guides for all releases between your version and the latest version" in 5.4 release note. But I didn't see any restriction for an upgrade from 4.3.3 directly to 5.4, nor were there any mysql database pre-upgrade requirements.

    I have already made backups and run Windows 5.4 installer with upgrade option. It's straightforward and end with "Installation of Confluence 5.4 is Complete" page. But my upgraded Confluence 5.4 server was up with a lot of errors in the log hence the administration drop down list does not work. Anything was missed? 

    Please help.

    Thanks,

    23 Dec 2013
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      If you have already done the upgrade and having the problems can you please contact support and we will help you out. 

      When upgrading from 4.3 to 5.x please check the plugin compatibilities, a lot of old version of the plugins are not compatible with Confluence 5.x.

      23 Dec 2013
  48. User avatar

    Dean Slabak

    We're upgrading from 4.3.6 -> 5.0.3 -> 5.4.2 and have the follow errors in our system logs.

    atlassian-confluence.log
    31 Jan 2014
    1. User avatar

      Rachel Robins [Atlassian Tech Writer]

      Hi Dean,  If you are having trouble upgrading you should contact Support who will help you troubleshoot the problem. 

      31 Jan 2014
  49. User avatar

    Srinivas Patruni

    I have upgraded confluence from 4.1.6 to 5.4.2 in our test environment successfully without any major issues but page content is not visible. I checked the layout, stylesheets, themes etc found all are set to default. Though I had truncated the decorator table, there is no change. Any suggestions please?

    13 Feb 2014
    1. User avatar

      Anatoli Kazatchkov [Atlassian]

      Hi Srinivas, truncating the decorator table sounds suspicious; can you please contact support and we will help you out.

       

      13 Feb 2014
  50. User avatar

    Nabil Sayegh

    If your installation directory is a symlink, the upgrade will delete the symlink and create a regular directory instead. If you think you edited the Context in server.xml correctly but still get "Page Not Found" (404) for all pages, then you might have edited the wrong server.xml, i.e. the one in the previous installation directory, probably because you had the folder open, and didn't realize the symlink.

    19 Mar 2014
  51. User avatar

    Jean-Pierre Froud

    Wow... This upgrading guide is well documented, very detailed etc. But it would be greater to simplify the upgrade procedure and automate it. It's nice to have new features and stuff in the new available version but this upgrading procedure is putting a brake on it. I'd rather have an automated upgrading than new features...

    22 May 2014
  52. User avatar

    Michael Dave

    We have a very old version of confluence (2.4.4 build #707) and we are upgrading to Confluence 5.

    I am not in charge of the upgrade but need to migrate the content for our group (about 200 pages) to the new version.  I have been unable to find any documents on a semi-automated way to do so.  Here are my questions.

    1. Is there a way to harvest the content (in WIKI markup) from the old version from a given root node?
    2. If answer to above is yes, is there a way to import it into a space in the new one?
      I am not asking for a seamless transfer and am happy to manually edit the new pages.  I just would rather not transfer each page manually.
    3. Is there a way to do a regular expression search for specific URLs?  I want to be able to get all links to other confluence pages in the content above so I can identify the relevant documents and manually replace links to the appropriate new content.

    Thanks.

     

    08 Jul 2014
    1. User avatar

      Rachel Robins [Atlassian Tech Writer]

      Hi Michael, I strongly recommend you contact Support directly about this upgrade.  They will help you find the best upgrade path and have lots of experience helping customers off quite old versions. 

      09 Jul 2014
      1. User avatar

        Michael Dave

        Thanks for the suggestion Rachel.

        True to form, Atlassian has made it impossible to ask a direct question to support.  Why do I say so?  Here are the links on the support page:

        1. Search thru docs, KB, bugs or answers (which I already did)
        2. Technical docs
        3. Knowledge base
        4. Answers
        5. Bug tracker
        6. Atlassian Experts (outside parties whom I have to pay)

        Translation to plain english: "Pay us first if you want to talk to us or you're on your own (and we don't care if you already bought our stuff)".

        By now, I've wasted 2 hours on finding answers to what would seem to be relatively trivial questions.  No answers on google and no answers on Atlassian website.  I've had this exact experience with Atlassian before when I worked at another company.

        Yes, I'm frustrated.  Why?  Because when I work with organizations like Amazon, Nordstrom or Costco, I actually feel like they want to talk to me as a customer.  Here, I'm feeling like the last thing Atlassian wants is actually to talk to a customer.

        Let see if anyone at Atlassian will read this.  If you do, know that you're actively building up a bad reputation with this customer.

        09 Jul 2014
        1. User avatar

          Rachel Robins [Atlassian Tech Writer]

          Hi Michael, I'm so sorry you've had such a bad experience today.  Support really are the right people to help you (and they do want to talk to you).  If you go to https://support.atlassian.com/servicedesk/customer/csp - you'll be prompted to log in, if you don't already have an account, you can create one (free), and then select Installation Query - there you can drop in all your questions above.  

          I'm afraid I don't know the answers to your questions, but support have a lot of experience working with older versions of Confluence and will be able to help you. 

          I'll also follow up with that team on why it is so hard to create an issue from the homepage. We're doing a bad job of making it easy to create a support request. 

          09 Jul 2014
          1. User avatar

            Michael Dave

            Thanks Rachel.  I have nothing personal against you.  In fact, I appreciate your willingness to jump in promptly and help.  

            My frustration is with Atlassian support and the policies.  I feel I'm getting the same kind of run around I'd get at the "customer service" with my phone or cable company and that's not saying much.  Even for a $5 purchase from Amazon, I get a lot better customer service than this.

            In any event, thank you for your prompt responses and assistance.  I'm grateful for the same.

            09 Jul 2014
        1. User avatar

          Alex Plotkin

          Hello Michael,

          >>> I am not in charge of the upgrade but need to migrate the content for our group (about 200 pages) to the new version. >>> 

          I did not have any issues while updating to the new V.5.5.2. However, our application has only Spaces.

          Read the release and update notes and found out about the system requirements and if you can go with direct update.

           --Alex

          09 Jul 2014
          1. User avatar

            Michael Dave

            Thanks Alex.  I'm not coordinating the update for our entire site but only the 200 odd pages for our group hence my question about harvesting the content etc.

            I imagine it has got to be a relatively simple matter to harvest a bunch of text so I'm kinda surprised at the lack of information from Atlassian but so be it.

            I appreciate your help and the response.  Thanks.

            09 Jul 2014
    1. User avatar

      Michael Seager [Atlassian]

      Hi Michael, 

      Sorry for the frustrating support experience so far. I see you've got an open support ticket with us to address the technical questions, I'll organise one of my colleagues in the US to contact you directly about how we can improve the support experience for you.

      Thanks Michael.

      10 Jul 2014
      1. User avatar

        Michael Dave

        Thanks Michael.  Your support organization did contact me and they've set up a time to speak with me.

        Thank you for taking an active interest and responding quickly.  That's the type of customer service I was hoping for.

        10 Jul 2014
  53. User avatar

    mingqing wang

    update from 5.0.3 to 5.5.3 and everything seems ok.

    09 Jul 2014
  54. User avatar

    Jan-Peter Rusch

    Hi,

    I'm still wondering, why a Confluence instance with manual customisations is autostarted after an upgrade. The updater checks & reports the changes, so if it knows there have been changes which must be reapplied after upgrade why does it autostart Confluence?

    In most cases, the first start after an upgrade fails with various errors until the modifications are reapplied.

    So, please, if the updater finds a modification, make the autostart after upgrade optional & ask the admin...

    I'm wondering, if there is a issue open for this, I could vote on.

    Thanks!

    25 Aug 2014
    1. User avatar

      Nabil Sayegh

      100% agreed. Also for JIRA. E.g. in JIRA 6.3.4 there is a bug that must be workarounded right after upgrading and before restart. I don't see any benefit in auto restarting...

      25 Aug 2014
    1. User avatar

      Jimmy Liberato

      Vote for issue CONF-24414 - On upgrade if we found there are modz in the system we cannot handle we should give the customer an option not to start confluence Open

      10 Sep 2014
  55. User avatar

    Software Admin

    I'm trying to upgrade the OSX version and the instructions say to run an installer but there isn't one, just a tar file.  What's the procedure for upgrading from a previous release?

    04 Sep 2014
    1. User avatar

      Deividi Luvison [Atlassian]

      Hey There,

      We do not have a installer to OSX because we do not support as a server, just as a client, as you can see in below page:

      Supported Platforms

      To upgrade confluence from a previous version you have two options:

      1. Migrate to Linux or Windows.
      2. Then follow the instructions in this page with the installer.

      Or doing a manual upgrade using the tar file:

      Upgrading Confluence Manually#PerformingtheUpgrade

      I really recommend migrating since you might hit other problems if you use Mac as a server.

       

      Thanks and Regards,
      David|Confluence Support Engineer
      04 Sep 2014
  56. User avatar

    Software Admin

    If OSX isn't supported as a server platform that why bother having downloads?

    https://www.atlassian.com/software/confluence/download

    Or are you saying all of the code in those files is required to access Confluence from OSX?

    04 Sep 2014
    1. User avatar

      Deividi Luvison [Atlassian]

      Actually we put the downloads in there so MAC users can download and evaluate confluence features without needing to set up a linux or a windows  server/vm (smile).

      Thanks and Regards,
      David|Confluence Support Engineer

       

      04 Sep 2014
  57. User avatar

    Software Admin

    The documentation on this page says that a 4.3 installation can upgrade directly to the latest version of Confluence, but tech. support is adamant that 4.3 can only upgrade to version 5.0.3, and then 5.0.3 must be upgraded to the latest.  

    05 Sep 2014
    1. User avatar

      Deividi Luvison [Atlassian]

      Hey Michael,

      Apologies for that misunderstanding, from 4.3 you can go directly to latest version. The reason why we sometimes give the path to 5.0.3 for customers on 4.3 is because it's a very stable version and in case the upgrade to latest fails for any other reason you would be able have your instance on a stable supported version (5.0.3) while we work on the upgrade problem (in case you had one (smile)).

      I will add this addendum to the CSP you raised with us.

      Thanks and Regards,
      David|Confluence Support Engineer
      05 Sep 2014
      1. User avatar

        Ralf Abbt

        I'm about to upgrade our Confluence on our Company. But just to be sure, there is no problem upgrading from 4.3.3 to the latest Confluence Version 5.6.1, right?

        24 Sep 2014
        1. User avatar

          Neil

          Have you ran it in test yet? That is really the only way to get a definitive answer for your particular situation. Clone your production instance and run the upgrade there first. 

          24 Sep 2014
        1. User avatar

          Deividi Luvison [Atlassian]

          Hey Ralf,

          In a upgrade path perspective, yes you can go from 4.3.3 directly. As Neil replied to you as well make sure to do the upgrade in test so we can avoid any issues in production (when applying in prod remember the golden rule - Backups!!).

          Thanks and Regards,
          David|Confluence Support Engineer
          24 Sep 2014
Powered by Confluence and Scroll Viewport