Re: [dotcms] Upgrade to dotcms 2.1 fails

[Jason Tesser]

you have to get to at least 1.9.3 before upgrading

ALSO to get there you have to goto 1.9.2.1


So in summary you should
1. Goto 1.9.2.1
2. Goto 1.9.5.1
3. Goto 2.1.x

Thanks,
Jason Tesser
dotCMS Director, Support Services
1-305-858-1422


On Wed, Aug 15, 2012 at 5:16 PM, Moa. M. <moa...@gmail.com> wrote:
> Hello
>
> I am attempting to upgrade dotcms 1.9.1 to dotcms 2.1 version (tag).
> I am guetting an error "ERROR: column inode.host does not exist"
> the front end and back end give a 500 error. Below is a partial output of
> log file.
>
> [15/08/12 16:55:51:199 EDT] INFO startup.StartupTasksExecutor: Running:
> Task00768CreateTagStorageFieldOnHostStructure
> [15/08/12 16:55:51:207 EDT] WARN util.JDBCExceptionReporter: SQL Error: 0,
> SQLState: 42703
> [15/08/12 16:55:51:207 EDT] ERROR util.JDBCExceptionReporter: ERROR: column
> inode.host does not exist
> Position: 417
> [15/08/12 16:55:51:207 EDT] WARN util.JDBCExceptionReporter: SQL Error: 0,
> SQLState: 42703
> [15/08/12 16:55:51:207 EDT] ERROR util.JDBCExceptionReporter: ERROR: column
> inode.host does not exist
> Position: 417
> [15/08/12 16:55:51:210 EDT] WARN db.HibernateUtil: ---------- DotHibernate:
> error on list ---------------
> net.sf.hibernate.exception.SQLGrammarException: Could not execute query
> at
> net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:58)
> at
> net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
> at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131)
> at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1557)
> at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
> at com.dotmarketing.db.HibernateUtil.list(HibernateUtil.java:272)
> at
> com.dotmarketing.factories.InodeFactory.getInodesOfClassByCondition(InodeFactory.java:844)
> at
> com.dotmarketing.factories.InodeFactory.getInodesOfClassByCondition(InodeFactory.java:827)
> at
> com.dotmarketing.portlets.structure.factories.StructureFactory.getStructureByVelocityVarName(StructureFactory.java:104)
> at
> com.dotmarketing.startup.runonce.Task00768CreateTagStorageFieldOnHostStructure.executeUpgrade(Task00768CreateTagStorageFieldOnHostStructure.java:27)
> at
> com.dotmarketing.startup.StartupTasksExecutor.executeUpgrades(StartupTasksExecutor.java:260)
> at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:117)
> at
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
> at
> org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
> at
> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
> at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
> at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
> at
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
> at
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
> at
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
> at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
> at
> org.apache.catalina.core.StandardService.start(StandardService.java:519)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
> 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:289)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
> Caused by: org.postgresql.util.PSQLException: ERROR: column inode.host does
> not exist
> Position: 417
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
> at
> org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
> at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89)
> at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880)
> at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273)
> at
> net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
> at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
> at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
> at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
> at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
> ... 34 more
> [15/08/12 16:55:51:211 EDT] INFO business.DotGuavaCacheAdministratorImpl:
> *** Building Cache : fieldscache, size:1000, toDisk:false,Concurrency:32
> [15/08/12 16:55:51:213 EDT] WARN util.JDBCExceptionReporter: SQL Error: 0,
> SQLState: 25P02
> [15/08/12 16:55:51:213 EDT] ERROR util.JDBCExceptionReporter: ERROR: current
> transaction is aborted, commands ignored until end of transaction block
> [15/08/12 16:55:51:214 EDT] WARN util.JDBCExceptionReporter: SQL Error: 0,
> SQLState: 25P02
> [15/08/12 16:55:51:214 EDT] ERROR util.JDBCExceptionReporter: ERROR: current
> transaction is aborted, commands ignored until end of transaction block
> [15/08/12 16:55:51:217 EDT] WARN util.JDBCExceptionReporter: SQL Error: 0,
> SQLState: 25P02
> [15/08/12 16:55:51:217 EDT] ERROR util.JDBCExceptionReporter: ERROR: current
> transaction is aborted, commands ignored until end of transaction block
> [15/08/12 16:55:51:217 EDT] WARN util.JDBCExceptionReporter: SQL Error: 0,
> SQLState: 25P02
> [15/08/12 16:55:51:217 EDT] ERROR util.JDBCExceptionReporter: ERROR: current
> transaction is aborted, commands ignored until end of transaction block
> [15/08/12 16:55:51:217 EDT] WARN db.HibernateUtil: ---------- DotHibernate:
> error on list ---------------
> net.sf.hibernate.exception.GenericJDBCException: Could not execute query
> at
> net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:80)
> at
> net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
> at
> net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
> at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131)
> at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1557)
> at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
> at com.dotmarketing.db.HibernateUtil.list(HibernateUtil.java:272)
> at
> com.dotmarketing.factories.InodeFactory.getInodesOfClassByConditionAndOrderBy(InodeFactory.java:899)
> at
> com.dotmarketing.factories.InodeFactory.getInodesOfClassByConditionAndOrderBy(InodeFactory.java:882)
> at
> com.dotmarketing.portlets.structure.factories.FieldFactory.getFieldsByStructure(FieldFactory.java:33)
> at
> com.dotmarketing.portlets.structure.model.Structure.getFields(Structure.java:137)
> at
> com.dotmarketing.cache.FieldsCache.getFieldsByStructureInode(FieldsCache.java:39)
> at
> com.dotmarketing.startup.runonce.Task00768CreateTagStorageFieldOnHostStructure.executeUpgrade(Task00768CreateTagStorageFieldOnHostStructure.java:41)
> at
> com.dotmarketing.startup.StartupTasksExecutor.executeUpgrades(StartupTasksExecutor.java:260)
> at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:117)
> at
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
> at
> org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
> at
> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
> at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
> at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
> at
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
> at
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
> at
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
> at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
> at
> org.apache.catalina.core.StandardService.start(StandardService.java:519)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
> 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:289)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
> Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is
> aborted, commands ignored until end of transaction block
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
> at
> org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
> at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89)
> at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880)
> at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273)
> at
> net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
> at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
> at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
> at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
> at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
> ... 36 more
> [15/08/12 16:55:51:220 EDT] WARN util.JDBCExceptionReporter: SQL Error: 0,
> SQLState: 25P02
> [15/08/12 16:55:51:220 EDT] ERROR util.JDBCExceptionReporter: ERROR: current
> transaction is aborted, commands ignored until end of transaction block
> [15/08/12 16:55:51:220 EDT] WARN util.JDBCExceptionReporter: SQL Error: 0,
> SQLState: 25P02
> [15/08/12 16:55:51:220 EDT] ERROR util.JDBCExceptionReporter: ERROR: current
> transaction is aborted, commands ignored until end of transaction block
> [15/08/12 16:55:51:220 EDT] WARN db.HibernateUtil: ---------- DotHibernate:
> error on list ---------------
> net.sf.hibernate.exception.GenericJDBCException: Could not execute query
> at
> net.sf.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:80)
> at
> net.sf.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:69)
> at
> net.sf.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
> at net.sf.hibernate.impl.SessionImpl.convert(SessionImpl.java:4131)
> at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1557)
> at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
> at com.dotmarketing.db.HibernateUtil.list(HibernateUtil.java:272)
> at
> com.dotmarketing.factories.InodeFactory.getInodesOfClassByConditionAndOrderBy(InodeFactory.java:899)
> at
> com.dotmarketing.factories.InodeFactory.getInodesOfClassByConditionAndOrderBy(InodeFactory.java:882)
> at
> com.dotmarketing.portlets.structure.factories.FieldFactory.getFieldsByContentletField(FieldFactory.java:74)
> at
> com.dotmarketing.portlets.structure.factories.FieldFactory.getNextAvaliableFieldNumber(FieldFactory.java:116)
> at
> com.dotmarketing.startup.runonce.Task00768CreateTagStorageFieldOnHostStructure.executeUpgrade(Task00768CreateTagStorageFieldOnHostStructure.java:91)
> at
> com.dotmarketing.startup.StartupTasksExecutor.executeUpgrades(StartupTasksExecutor.java:260)
> at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:117)
> at
> org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
> at
> org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
> at
> org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
> at
> org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
> at
> org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
> at
> org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
> at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
> at
> org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
> at
> org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
> at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
> at
> org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
> at
> org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
> at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
> at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
> at
> org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
> at
> org.apache.catalina.core.StandardService.start(StandardService.java:519)
> at
> org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
> at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
> 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:289)
> at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
> Caused by: org.postgresql.util.PSQLException: ERROR: current transaction is
> aborted, commands ignored until end of transaction block
> at
> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
> at
> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
> at
> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
> at
> org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
> at
> org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
> at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89)
> at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880)
> at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273)
> at
> net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138)
> at net.sf.hibernate.loader.Loader.doList(Loader.java:1063)
> at net.sf.hibernate.loader.Loader.list(Loader.java:1054)
> at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854)
> at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1554)
> ... 35 more
> [15/08/12 16:55:51:226 EDT] WARN util.JDBCExceptionReporter: SQL Error: 0,
> SQLState: 25P02
> [15/08/12 16:55:51:226 EDT] ERROR util.JDBCExceptionReporter: ERROR: current
> transaction is aborted, commands ignored until end of transaction block
> [15/08/12 16:55:51:226 EDT] ERROR impl.SessionImpl: Could not synchronize
> database state with session
> [15/08/12 16:55:51:231 EDT] FATAL startup.StartupTasksExecutor: Unable to
> execute the upgrade task : Task00768CreateTagStorageFieldOnHostStructure
>
> Does anyone have any idea ? i m using postgres 8.4.
>
> Thanks
>
> --
> You received this message because you are subscribed to the Google Groups
> "dotCMS User Group" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/dotcms/-/snaI1HaNnDMJ.
> To post to this group, send email to dot...@googlegroups.com.
> To unsubscribe from this group, send email to
> dotcms+un...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/dotcms?hl=en.