Upgrading from 2.5 to 3.2 - cluster/sitelic error in logs, any impact?

26 views

Skip to first unread message

Colorado Kiwi

unread,

Jan 1, 2016, 1:32:08 PM1/1/16

to dotCMS User Group

Hi,

I've just finished (I think?) a dotcms upgrade from 2.5 to 3.2. Initially had a DB issue, but user error on my part (see other recent post) and now resolved. System comes up okay.

Checking the catalina.out logs during the first start that detects the upgrade, I have one remaining error (site license?) - see below. Things *seem* okay, and after doing a shutdown and restart I don't see any errors, but wanted to check whether this is indicating something I missed or still need to do as part of going from 2.x to 3.x.

For context, the upgrade was from 2.5.4 to 3.2.4. Community Edition. My database is MySQL. I'm running linux (as opposed to the Windows dotCMS packaging). Java version 1.8.

I followed the steps defined in the latest docs under: Administration / Upgrading dotCMS / Upgrading to dotCMS 3.x. In those steps, there is no mention of site license stuff, however I did see the not in the general (3.x to 3.x?) upgrade notes about "license.dat and server_id.dat license files" and wondered.

The snippet of the catalina.out log with the error…

2016-01-01 10:37:48,901 INFO com.dotmarketing.startup.StartupTasksExecutor - Running: Task03015CreateClusterConfigModel
2016-01-01 10:37:48,902 INFO com.dotmarketing.common.db.DotConnect - Executing CREATE TABLE dot_cluster(cluster_id varchar(36), PRIMARY KEY (cluster_id) );
2016-01-01 10:37:49,012 INFO com.dotmarketing.common.db.DotConnect - Executing CREATE TABLE cluster_server(server_id varchar(36), cluster_id varchar(36) NOT NULL, name varchar(100), ip_address varchar(39) NOT NULL, host varchar(36), cache_port SMALLINT, es_transport_tcp_port SMALLINT, es_network_port SMALLINT, es_http_port SMALLINT, key_ varchar(100), PRIMARY KEY (server_id) );
2016-01-01 10:37:49,155 INFO com.dotmarketing.common.db.DotConnect - Executing ALTER TABLE cluster_server add constraint fk_cluster_id foreign key (cluster_id) REFERENCES dot_cluster(cluster_id);
2016-01-01 10:37:49,291 INFO com.dotmarketing.common.db.DotConnect - Executing CREATE TABLE cluster_server_uptime(id varchar(36),server_id varchar(36) NOT NULL, startup datetime, heartbeat datetime, PRIMARY KEY (id)) ;
2016-01-01 10:37:49,420 INFO com.dotmarketing.common.db.DotConnect - Executing ALTER TABLE cluster_server_uptime add constraint fk_cluster_server_id foreign key (server_id) REFERENCES cluster_server(server_id);
2016-01-01 10:37:49,589 INFO com.dotcms.enterprise.license.b -
2016-01-01 10:37:49,590 INFO com.dotcms.enterprise.license.b -
2016-01-01 10:37:49,591 INFO com.dotcms.enterprise.license.b -
2016-01-01 10:37:49,591 INFO com.dotcms.enterprise.license.b -
2016-01-01 10:37:49,592 INFO com.dotcms.enterprise.license.b -
2016-01-01 10:37:49,592 INFO com.dotcms.enterprise.license.b -
2016-01-01 10:37:49,593 INFO com.dotcms.enterprise.license.b -
2016-01-01 10:37:49,601 INFO com.dotcms.enterprise.license.b -
2016-01-01 10:37:49,602 INFO com.dotcms.enterprise.license.b -
2016-01-01 10:37:49,682 ERROR com.dotcms.enterprise.cluster.ClusterFactory - Error trying to wire node to the Cluster
com.dotmarketing.exception.DotDataException: Table 'dotcms3.sitelic' doesn't exist
at com.dotmarketing.common.db.DotConnect.loadResult(DotConnect.java:234)
at com.dotmarketing.common.db.DotConnect.loadObjectResults(DotConnect.java:859)
at com.dotcms.enterprise.license.a.b(SourceFile:143)
at com.dotcms.enterprise.license.a.c(SourceFile:147)
at com.dotcms.enterprise.license.LicenseManager.isLicenseOnRepo(SourceFile:62)
at com.dotcms.enterprise.LicenseUtil.setUpLicenseRepo(SourceFile:212)
at com.dotcms.enterprise.cluster.ClusterFactory.addNodeToCluster(SourceFile:305)
at com.dotcms.enterprise.cluster.ClusterFactory.addNodeToCluster(SourceFile:198)
at com.dotcms.enterprise.cluster.ClusterFactory.initialize(SourceFile:112)
at com.dotmarketing.startup.runonce.Task03015CreateClusterConfigModel.executeUpgrade(Task03015CreateClusterConfigModel.java:59)
at com.dotmarketing.startup.StartupTasksExecutor.executeUpgrades(StartupTasksExecutor.java:273)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:116)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1231)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1144)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1031)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4901)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5188)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:714)
at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1069)
at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1719)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dotcms3.sitelic' doesn't exist
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
at com.mysql.jdbc.Util.getInstance(Util.java:360)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030)
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)
at org.apache.tomcat.dbcp.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:82)
at com.dotmarketing.common.db.DotConnect.executeQuery(DotConnect.java:574)
at com.dotmarketing.common.db.DotConnect.executeQuery(DotConnect.java:486)
at com.dotmarketing.common.db.DotConnect.loadResult(DotConnect.java:232)
... 27 more
2016-01-01 10:37:49,687 INFO com.dotmarketing.startup.StartupTasksExecutor - Database upgraded to version: 3015

Other than the above error, it doesn't *look like* anything else was skipped? and the rest of the log looks ok.