I tried to upgrade from 1.1.15 to 1.1.20 and I got the following error page:

Upgrade Failed

The upgrade has been unsuccessful



The following upgrade tasks were executed with the status indicated.
Copy shared build reason data patch. failed
Cause of failure: SQLException: Column count does not match in statement [INSERT INTO build_reason (id, reason_type, details, user) VALUES (?, ?, ?, ?)]. Please see the log files for details.

Total time: 36 ms

The upgrade has failed. Please report this failure to zutubi support, including a screenshot of this page and your server log files.

Also another quik was that the data directory seems to have been missed identified because the upgrade screen showed the following:

Upgrade Preview

The data directory being used by this installation of pulse contains an existing data directory from an older installation.
Existing installation
build date 1-September-2006
build number 101019001
version 1.1.9

New installation
build date 14-November-2006
build number 0101020000
version 1.1.20

Before pulse can use this data directory, it will need to run the following upgrade tasks.
Copy shared build reason data patch. This upgrade tasks fixes data problems resulting from build reasons being shared by multiple build results. See CIB-723 for details.

Please be aware that pulse can not continue without running these upgrade tasks. If you do not wish to continue with this upgrade, shutdown this installation of pulse. Otherwise, please click continue to run the upgrade.


Notice that it identified the data directory as being from version 1.1.9 and not 1.1.15. The logs show the

[root@server ~]# Nov 13, 2006 1:58:37 PM com.zutubi.pulse.upgrade.tasks.DatabaseUpgradeTask execute
SEVERE: Column count does not match in statement [INSERT INTO build_reason (id,reason_type, details, user) VALUES (?, ?, ?, ?)]
java.sql.SQLException: Column count does not match in statement [INSERT INTO build_reason (id, reason_type, details, user) VALUES (?, ?, ?, ?)]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
        at org.apache.commons.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:185)
        at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:278)
        at com.zutubi.pulse.upgrade.tasks.CopySharedBuildReasonDataPatchUpgradeTask.execute(CopySharedBuildReasonDataPatchUpgradeTask.java:86)
        at com.zutubi.pulse.upgrade.tasks.DatabaseUpgradeTask.execute(DatabaseUpgradeTask.java:63)
        at com.zutubi.pulse.upgrade.DefaultUpgradeManager.executeUpgrade(DefaultUpgradeManager.java:233)
        at com.zutubi.pulse.web.upgrade.UpgradeExecuteAction.execute(UpgradeExecuteAction.java:23)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:353)
        at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:208)
        at com.opensymphony.webwork.interceptor.BackgroundProcess$1.run(BackgroundProcess.java:28)
        at java.lang.Thread.run(Thread.java:595)
Nov 13, 2006 1:58:37 PM com.zutubi.pulse.upgrade.DefaultUpgradeManager executeUpgrade
SEVERE: Task Copy shared build reason data patch. has been marked as failed.
com.zutubi.pulse.upgrade.UpgradeException: Task Copy shared build reason data patch. has been marked as failed.
        at com.zutubi.pulse.upgrade.DefaultUpgradeManager.executeUpgrade(DefaultUpgradeManager.java:247)
        at com.zutubi.pulse.web.upgrade.UpgradeExecuteAction.execute(UpgradeExecuteAction.java:23)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:585)
        at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:353)
        at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:208)
        at com.opensymphony.webwork.interceptor.BackgroundProcess$1.run(BackgroundProcess.java:28)
        at java.lang.Thread.run(Thread.java:595)