Error

Brian Jordan

unread,

May 23, 2012, 4:44:17 PM5/23/12

to dot...@googlegroups.com, Derek Gebler, Lance Ward, Liz DeVos

dotCMS,

How do we upgrade from 2.0 pre-release to 2.0? Apparently they differ VASTLY on setup aspects. We were able to get on the pre-release without problem. However, with 2.0, we have followed the instructions in the 2.0 upgrade section verbatim, and we cannot access our dotCMS login page @ /c or /admin, it brings up a 500 error. If we go to the direct portal URL it gives us the login popup, but when we attempt to login it fails and hangs at 100%. The errors that we’re getting don’t seem to be referenced on this page, either.

Database is UTF8 and db export was done with –R trigger to grab all the routines, as well. The dotCMS SQL user has proper access to the database. Added lower_case_table_names=1 in the my.conf file. Moved /tomcat directory into the plugins/.com…./ROOT directory and modified our ROOT.xml in there. Ran ./bin/deploy-plugins.sh and the build was successful.

Here’s one of several repeating errors in our catalina.out log file after starting the CMS:

2012-05-23 20:15:42,622 FATAL com.dotmarketing.startup.StartupTasksExecutor - Unable to execute the upgrade task : Task00850DropOldFilesConstraintInWorkflow

com.dotmarketing.exception.DotRuntimeException: Error on rename of './bimcms/workflowtask_files' to './bimcms/#sql2-13d3-28' (errno: 152)

at com.dotmarketing.exception.DotRuntimeException.fillInStackTrace(DotRuntimeException.java:33)

at java.lang.Throwable.<init>(Throwable.java:181)

at java.lang.Exception.<init>(Exception.java:29)

at java.lang.RuntimeException.<init>(RuntimeException.java:32)

at com.dotmarketing.exception.DotRuntimeException.<init>(DotRuntimeException.java:21)

at com.dotmarketing.startup.runonce.Task00850DropOldFilesConstraintInWorkflow.executeUpgrade(Task00850DropOldFilesConstraintInWorkflow.java:44)

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: java.sql.SQLException: Error on rename of './bimcms/workflowtask_files' to './bimcms/#sql2-13d3-28' (errno: 152)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2548)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2477)

at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:741)

at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:587)

at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)

at com.dotmarketing.common.db.DotConnect.executeStatement(DotConnect.java:212)

at com.dotmarketing.startup.runonce.Task00850DropOldFilesConstraintInWorkflow.dropConstraint(Task00850DropOldFilesConstraintInWorkflow.java:30)

at com.dotmarketing.startup.runonce.Task00850DropOldFilesConstraintInWorkflow.executeUpgrade(Task00850DropOldFilesConstraintInWorkflow.java:42)

... 28 more

Any assistance or advice would be greatly appreciated. I can send more error logs over, as well, as attachments.

Thanks,

Brian

BIM Client Support: (877) 325-3877

BIM Staff Support: (608) 512-1075

Chris Falzone

unread,

May 23, 2012, 4:53:08 PM5/23/12

to dot...@googlegroups.com

Weird Error on a very simple upgrade task. Something with your mysql?

I would:

1. Stop dotcms

2. Run the SQL in the upgrade task:

alter table workflowtask_files drop foreign key FK_task_file_inode

3. Insert a record into the db_version table for 855 with the current timestamp

4. Start dotCMS and tail the log watching for errors on the upgrade tasks.

Hope it helps,

Chris.

--
You received this message because you are subscribed to the Google Groups "dotCMS User Group" group.
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.

LWard

unread,

Jun 7, 2012, 10:51:13 AM6/7/12

to dot...@googlegroups.com

Hello,

I am working on this project with Brian.

We have run all of the upgrade tasks as well as the ones you provided above.

Any more guesses with these errors:

2012-06-07 14:48:30,686 ERROR com.dotmarketing.common.reindex.ReindexThread - No ContentIndexationThread available

2012-06-07 14:48:30,687 INFO com.dotmarketing.startup.StartupTasksExecutor - Running: Task00900CreateLogConsoleTable

2012-06-07 14:48:30,688 INFO com.dotmarketing.common.db.DotConnect - Executing create table log_mapper(

log_name varchar(30) primary key,

description varchar(50) not null,

enabled bigint(1,0) not null)

2012-06-07 14:48:30,692 ERROR com.dotmarketing.db.HibernateUtil - ---------- DotHibernate: error on rollbackTransaction ---------------

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Can't call rollback when autocommit=true

2012-06-07 14:48:30,701 FATAL com.dotmarketing.startup.StartupTasksExecutor - Unable to execute the upgrade task : Task00900CreateLogConsoleTable

com.dotmarketing.exception.DotDataException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0) not null)' at line 4

at com.dotmarketing.startup.runonce.Task00900CreateLogConsoleTable.executeUpgrade(Task00900CreateLogConsoleTable.java:39)