Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Tom Picklesimer
5.2.3 to 6.1 upgrade problems
June 15, 2012 9:45 AM
Answer

Tom Picklesimer

Rank: New Member

Posts: 24

Join Date: June 15, 2012

Recent Posts

Hello all,

I am having some issues in upgrading from 5.2.3 to 6.1 CE. I have backed up my database, imported the mysql file into local database server and copied data folder of 5.2.3 install to 6.1 install. When I launch tomcat server I get the following output. It looks like the upgrade is failing because of some issues with the mysql database. Any ideas how to get past this?

Thanks,

Tom


e InnoDB;

16:44:04,170 WARN [BaseDB:382] Table 'assetentries_assettags' already exists: c
reate table AssetEntries_AssetTags ( entryId bigint not null, tagId bi
gint not null, primary key (entryId, tagId)) engine InnoDB;

16:44:04,171 WARN [BaseDB:382] Table 'assetentry' already exists: create table
AssetEntry ( entryId bigint not null primary key, groupId bigint, companyI
d bigint, userId bigint, userName varchar(75) null, createDate datet
ime null, modifiedDate datetime null, classNameId bigint, classPK
bigint, visible tinyint, startDate datetime null, endDate datetime
null, publishDate datetime null, expirationDate datetime null, mimeType
varchar(75) null, title varchar(255) null, description longtext nul
l, summary longtext null, url longtext null, height integer, width in
teger, priority double, viewCount integer) engine InnoDB;

16:44:04,173 WARN [BaseDB:382] Table 'assettag' already exists: create table As
setTag ( tagId bigint not null primary key, groupId bigint, companyI
d bigint, userId bigint, userName varchar(75) null, createDate datet
ime null, modifiedDate datetime null, name varchar(75) null, assetCou
nt integer) engine InnoDB;

16:44:04,174 WARN [BaseDB:382] Table 'assettagproperty' already exists: create
table AssetTagProperty ( tagPropertyId bigint not null primary key,
companyId bigint, userId bigint, userName varchar(75) null, createDa
te datetime null, modifiedDate datetime null, tagId bigint, key_ var
char(75) null, value varchar(255) null) engine InnoDB;

16:44:04,176 WARN [BaseDB:382] Table 'assettagstats' already exists: create tab
le AssetTagStats ( tagStatsId bigint not null primary key, tagId bigint,
classNameId bigint, assetCount integer) engine InnoDB;

16:44:04,177 WARN [BaseDB:382] Table 'assetvocabulary' already exists: create t
able AssetVocabulary ( uuid_ varchar(75) null, vocabularyId bigint not null pri
mary key, groupId bigint, companyId bigint, userId bigint, userName
varchar(75) null, createDate datetime null, modifiedDate datetime nu
ll, name varchar(75) null, title longtext null, description longtext nul
l, settings_ longtext null) engine InnoDB;

16:44:04,179 WARN [BaseDB:382] Duplicate column name 'allowPingbacks': alter ta
ble BlogsEntry add allowPingbacks tinyint;

16:44:04,181 WARN [BaseDB:382] Duplicate column name 'status': alter table Blog
sEntry add status integer;

16:44:04,182 WARN [BaseDB:382] Duplicate column name 'statusByUserId': alter ta
ble BlogsEntry add statusByUserId bigint;

16:44:04,183 WARN [BaseDB:382] Duplicate column name 'statusByUserName': alter
table BlogsEntry add statusByUserName varchar(75);

16:44:04,184 WARN [BaseDB:382] Duplicate column name 'statusDate': alter table
BlogsEntry add statusDate datetime;

16:44:04,197 WARN [BaseDB:382] Unknown column 'draft' in 'where clause': update
BlogsEntry set status = 0 where draft = 0;

16:44:04,199 WARN [BaseDB:382] Unknown column 'draft' in 'where clause': update
BlogsEntry set status = 2 where draft = 1;

16:44:04,200 WARN [BaseDB:382] Unknown column 'draft' in 'where clause': update
BlogsEntry set statusByUserId = userId where draft = 0;

16:44:04,201 WARN [BaseDB:382] Unknown column 'draft' in 'where clause': update
BlogsEntry set statusByUserName = userName where draft = 0;

16:44:04,202 WARN [BaseDB:382] Unknown column 'draft' in 'where clause': update
BlogsEntry set statusDate = createDate where draft = 0;

16:44:04,203 WARN [BaseDB:382] Duplicate column name 'pendingVersion': alter ta
ble DLFileEntry add pendingVersion varchar(75) null;

16:44:04,204 WARN [BaseDB:382] Duplicate column name 'status': alter table DLFi
leShortcut add status integer;

16:44:04,205 WARN [BaseDB:382] Duplicate column name 'statusByUserId': alter ta
ble DLFileShortcut add statusByUserId bigint;

16:44:04,207 WARN [BaseDB:382] Duplicate column name 'statusByUserName': alter
table DLFileShortcut add statusByUserName varchar(75);

16:44:04,208 WARN [BaseDB:382] Duplicate column name 'statusDate': alter table
DLFileShortcut add statusDate datetime;

16:44:04,210 WARN [BaseDB:382] Duplicate column name 'description': alter table
DLFileVersion add description longtext null;

16:44:04,211 WARN [BaseDB:382] Duplicate column name 'status': alter table DLFi
leVersion add status integer;

16:44:04,212 WARN [BaseDB:382] Duplicate column name 'statusByUserId': alter ta
ble DLFileVersion add statusByUserId bigint;

16:44:04,214 WARN [BaseDB:382] Duplicate column name 'statusByUserName': alter
table DLFileVersion add statusByUserName varchar(75);

16:44:04,215 WARN [BaseDB:382] Duplicate column name 'statusDate': alter table
DLFileVersion add statusDate datetime;

16:44:04,288 WARN [BaseDB:382] Duplicate column name 'status': alter table Jour
nalArticle add status integer;

16:44:04,290 WARN [BaseDB:382] Duplicate column name 'statusByUserId': alter ta
ble JournalArticle add statusByUserId bigint;

16:44:04,291 WARN [BaseDB:382] Duplicate column name 'statusByUserName': alter
table JournalArticle add statusByUserName varchar(75);

16:44:04,292 WARN [BaseDB:382] Duplicate column name 'statusDate': alter table
JournalArticle add statusDate datetime;

16:44:04,622 WARN [BaseDB:382] Duplicate column name 'layoutPrototypeId': alter
table Layout add layoutPrototypeId bigint;

16:44:04,623 WARN [BaseDB:382] Table 'layoutprototype' already exists: create t
able LayoutPrototype ( layoutPrototypeId bigint not null primary key, companyI
d bigint, name longtext null, description longtext null, settings
_ longtext null, active_ tinyint) engine InnoDB;

16:44:04,625 WARN [BaseDB:382] Duplicate column name 'layoutSetPrototypeId': al
ter table LayoutSet add layoutSetPrototypeId bigint;

16:44:04,626 WARN [BaseDB:382] Table 'layoutsetprototype' already exists: creat
e table LayoutSetPrototype ( layoutSetPrototypeId bigint not null primary key
, companyId bigint, name longtext null, description longtext nul
l, settings_ longtext null, active_ tinyint) engine InnoDB;

16:44:04,628 WARN [BaseDB:382] Table 'lock_' already exists: create table Lock_
( uuid_ varchar(75) null, lockId bigint not null primary key, companyI
d bigint, userId bigint, userName varchar(75) null, createDate datet
ime null, className varchar(75) null, key_ varchar(200) null, owner va
rchar(75) null, inheritable tinyint, expirationDate datetime null) engine Inn
oDB;

16:44:04,629 WARN [BaseDB:382] Duplicate column name 'allowPingbacks': alter ta
ble MBMessage add allowPingbacks tinyint;

16:44:04,630 WARN [BaseDB:382] Duplicate column name 'status': alter table MBMe
ssage add status integer;

16:44:04,631 WARN [BaseDB:382] Duplicate column name 'statusByUserId': alter ta
ble MBMessage add statusByUserId bigint;

16:44:04,633 WARN [BaseDB:382] Duplicate column name 'statusByUserName': alter
table MBMessage add statusByUserName varchar(75);

16:44:04,634 WARN [BaseDB:382] Duplicate column name 'statusDate': alter table
MBMessage add statusDate datetime;

16:44:04,921 WARN [BaseDB:382] Duplicate column name 'status': alter table MBTh
read add status integer;

16:44:14,724 WARN [BaseDB:382] Duplicate column name 'statusByUserId': alter ta
ble MBThread add statusByUserId bigint;

16:44:18,812 WARN [BaseDB:382] Duplicate column name 'statusByUserName': alter
table MBThread add statusByUserName varchar(75);

16:44:23,469 WARN [BaseDB:382] Duplicate column name 'statusDate': alter table
MBThread add statusDate datetime;

16:44:31,750 WARN [BaseDB:382] Duplicate column name 'servletContextName': alte
r table Release_ add servletContextName varchar(75);

16:44:34,815 WARN [BaseDB:382] Duplicate column name 'groupId': alter table Sho
ppingItem add groupId bigint;

16:44:38,725 WARN [BaseDB:382] Table 'usergroupgrouprole' already exists: creat
e table UserGroupGroupRole ( userGroupId bigint not null, groupId bigint n
ot null, roleId bigint not null, primary key (userGroupId, groupId, roleI
d)) engine InnoDB;

16:44:41,860 WARN [BaseDB:382] Duplicate column name 'status': alter table Wiki
Page add status integer;

16:44:46,853 WARN [BaseDB:382] Duplicate column name 'statusByUserId': alter ta
ble WikiPage add statusByUserId bigint;

16:44:50,813 WARN [BaseDB:382] Duplicate column name 'statusByUserName': alter
table WikiPage add statusByUserName varchar(75);

16:44:54,038 WARN [BaseDB:382] Duplicate column name 'statusDate': alter table
WikiPage add statusDate datetime;

16:44:57,415 WARN [BaseDB:382] Table 'workflowdefinitionlink' already exists: c
reate table WorkflowDefinitionLink ( workflowDefinitionLinkId bigint not null
primary key, groupId bigint, companyId bigint, userId bigint, userName
varchar(75) null, createDate datetime null, modifiedDate datetime nu
ll, classNameId bigint, workflowDefinitionName varchar(75) null,
workflowDefinitionVersion integer) engine InnoDB;

16:45:00,582 WARN [BaseDB:382] Table 'workflowinstancelink' already exists: cre
ate table WorkflowInstanceLink ( workflowInstanceLinkId bigint not null p
rimary key, groupId bigint, companyId bigint, userId bigint, userName
varchar(75) null, createDate datetime null, modifiedDate datetime nu
ll, classNameId bigint, classPK bigint, workflowInstanceId bigint) engin
e InnoDB;

16:45:05,264 INFO [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_
0_0.UpgradeAsset
16:45:08,974 ERROR [MainServlet:198] com.liferay.portal.kernel.events.ActionExce
ption: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.ke
rnel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConstrain
tViolationException: Duplicate entry '1770' for key 'PRIMARY'
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgr
ade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.my
sql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Duplicate entry
'1770' for key 'PRIMARY'
at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServl
et.java:1267)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:195)
at javax.servlet.GenericServlet.init(GenericServlet.java:160)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.
java:1266)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.
java:1185)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:10
80)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContex
t.java:5001)
at org.apache.catalina.core.StandardContext.startInternal(StandardContex
t.java:5289)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase
.java:866)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:84
2)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)

at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.ja
va:649)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfi
g.java:1581)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:44
1)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExec
utor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor
.java:908)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.porta
l.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLIntegrityConst
raintViolationException: Duplicate entry '1770' for key 'PRIMARY'
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProce
ss.java:211)
at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(Upgrade
ProcessUtil.java:93)
at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeP
rocessUtil.java:46)
at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.
java:81)
at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHel
perUtil.java:40)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:119)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:144)

at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
... 20 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.ex
ceptions.MySQLIntegrityConstraintViolationException: Duplicate entry '1770' for
key 'PRIMARY'
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProce
ss.java:211)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProce
ss.java:225)
at com.liferay.portal.upgrade.UpgradeProcess_6_0_0.doUpgrade(UpgradeProc
ess_6_0_0.java:47)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProce
ss.java:208)
... 27 more
Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException:
Duplicate entry '1770' for key 'PRIMARY'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3256)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1313)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1585)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1500)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1485)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:105)
at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.addEntry(UpgradeAsset.
java:137)
at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.updateAssetEntries(Upg
radeAsset.java:473)
at com.liferay.portal.upgrade.v6_0_0.UpgradeAsset.doUpgrade(UpgradeAsset
.java:392)
at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProce
ss.java:208)
... 30 more
Linus Sphinx
RE: 5.2.3 to 6.1 upgrade problems
June 19, 2012 10:56 AM
Answer

Linus Sphinx

Rank: Junior Member

Posts: 89

Join Date: August 12, 2010

Recent Posts

Did you by any chance try this upgrade and abort it before completion? Have to reload the schema and start fresh in that case.
Hitoshi Ozawa
RE: 5.2.3 to 6.1 upgrade problems
June 21, 2012 3:21 PM
Answer

Hitoshi Ozawa

Rank: Liferay Legend

Posts: 7949

Join Date: March 23, 2010

Recent Posts

You'll have to upgrade 5.2.3 to 6.0.6 and then to 6.1.0.