Errors upgrading to 11.2

Installation Forum (Inactive)
Errors upgrading to 11.2 michael_stover  2011-09-15 12:07
Status: Closed
 
Different people in our group tried test upgrades to 11.2. One, using the windows upgrader, got an error:

flow-11.10-11.20.sql : ERROR null value in column "keywordid" violates not-null constraint.

Another, doing a manual upgrade on MacOS got:

ERROR ExceptionUtil 2011-09-15 14:24:16,072 http-8080-Processor25 : Unhandled exception: 500: Unexpected server error
org.labkey.api.data.SqlScriptRunner$SqlScriptException: core-10.20-10.30.sql : ERROR: function "array_accum" already exists with same argument types
    at org.labkey.api.data.SqlScriptManager.runScript(SqlScriptManager.java:132)
    at org.labkey.api.data.SqlScriptRunner.runScripts(SqlScriptRunner.java:103)
    at org.labkey.api.module.DefaultModule.versionUpdate(DefaultModule.java:249)
    at org.labkey.api.module.ModuleUpgrader.upgrade(ModuleUpgrader.java:59)
    at org.labkey.api.module.ModuleLoader.upgradeCoreModule(ModuleLoader.java:620)
    at org.labkey.api.module.ModuleLoader.doInit(ModuleLoader.java:303)
    at org.labkey.api.module.ModuleLoader.init(ModuleLoader.java:215)
    at org.apache.catalina.core.ApplicationFilterConfig.getFilter(ApplicationFilterConfig.java:221)
    at org.apache.catalina.core.ApplicationFilterConfig.setFilterDef(ApplicationFilterConfig.java:302)
    at org.apache.catalina.core.ApplicationFilterConfig.<init>(ApplicationFilterConfig.java:78)
    at org.apache.catalina.core.StandardContext.filterStart(StandardContext.java:3666)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4258)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
    at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:634)
    at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:561)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:496)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1203)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:319)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
    at org.apache.catalina.core.StandardService.start(StandardService.java:448)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
    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:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: org.postgresql.util.PSQLException: ERROR: function "array_accum" already exists with same argument types
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2103)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:512)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:374)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:366)
    at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
    at org.labkey.api.data.dialect.StatementWrapper.execute(StatementWrapper.java:979)
    at org.labkey.api.data.Table.execute(Table.java:189)
    at org.labkey.api.data.Table.execute(Table.java:416)
    at org.labkey.api.data.SqlScriptParser$Block.execute(SqlScriptParser.java:164)
    at org.labkey.api.data.SqlScriptParser.execute(SqlScriptParser.java:61)
    at org.labkey.core.PostgreSql83Dialect.runSql(PostgreSql83Dialect.java:719)
    at org.labkey.core.PostgreSql84Dialect.runSql(PostgreSql84Dialect.java:24)
    at org.labkey.api.data.SqlScriptManager.runScript(SqlScriptManager.java:127)
    ... 33 more
 
 
jeckels responded:  2011-09-22 17:57
The second error indicates that the server has already run the upgrade from version 10.20-10.30 but for some reason thought it needed to do so again.

What version was installed immediately before the attempted upgrade to 11.2?

Can you send the results of running these queries against the Postgres database?

SELECT * FROM core.modules;

SELECT * FROM core.sqlscripts;

I'll have to defer to others on the error with the flow upgrade - I'm not familiar with the specifics of what that script is doing.

Thanks,
Josh