Combination View Flat View Tree View
Threads [ Previous | Next ]
Riccardo Rotondo
Error migration from 6.0.6 CE to 6.1.0
January 24, 2013 3:54 PM
Answer

Riccardo Rotondo

Rank: Junior Member

Posts: 28

Join Date: June 11, 2010

Recent Posts

Hello everybody, I'm trying to upgrade so far as from the subject but with no results.

I have several problem with the image gallery upgrade. I successfully overcame the issue described here:

http://issues.liferay.com/browse/LPS-25092

But I still have a Duplicate Key exception, this time with another value. The problem is that it refers to each image present in the portal.

Here the log:

 1
 2[#|2013-01-24T19:44:46.894+0100|INFO|glassfish3.1|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=175;_ThreadName=Thread-1;|19:44:46,893 INFO  [admin-thread-pool-4848(2)][UpgradeProcess:207] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery
 3|#]
 4
 5[#|2013-01-24T19:44:48.120+0100|INFO|glassfish3.1|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=175;_ThreadName=Thread-1;|19:44:48,115 ERROR [admin-thread-pool-4848(2)][MainServlet:217] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '290924' for key 'IX_F9821AB4'
 6com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '290924' for key 'IX_F9821AB4'
 7        at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
 8        at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1306)
 9        at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:214)
10        at javax.servlet.GenericServlet.init(GenericServlet.java:244)
11        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1439)
12        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1241)
13        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5032)
14        at org.apache.catalina.core.StandardContext.start(StandardContext.java:5319)
15        at com.sun.enterprise.web.WebModule.start(WebModule.java:500)
16        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:917)
17        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:901)
18        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:755)
19        at com.sun.enterprise.web.WebContainer.loadWebModule(WebContainer.java:1980)
20        at com.sun.enterprise.web.WebContainer.loadWebModule(WebContainer.java:1630)
21        at com.sun.enterprise.web.WebApplication.start(WebApplication.java:100)
22        at org.glassfish.internal.data.EngineRef.start(EngineRef.java:130)
23        at org.glassfish.internal.data.ModuleInfo.start(ModuleInfo.java:269)
24        at org.glassfish.internal.data.ApplicationInfo.start(ApplicationInfo.java:286)
25        at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:461)
26        at com.sun.enterprise.v3.server.ApplicationLifecycle.deploy(ApplicationLifecycle.java:240)
27        at org.glassfish.deployment.admin.DeployCommand.execute(DeployCommand.java:370)
28        at com.sun.enterprise.v3.admin.CommandRunnerImpl$1.execute(CommandRunnerImpl.java:355)
29        at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:370)
30        at com.sun.enterprise.v3.admin.CommandRunnerImpl.doCommand(CommandRunnerImpl.java:1067)
31        at com.sun.enterprise.v3.admin.CommandRunnerImpl.access$1200(CommandRunnerImpl.java:96)
32        at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1247)
33        at com.sun.enterprise.v3.admin.CommandRunnerImpl$ExecutionContext.execute(CommandRunnerImpl.java:1235)
34        at com.sun.enterprise.v3.admin.AdminAdapter.doCommand(AdminAdapter.java:465)
35        at com.sun.enterprise.v3.admin.AdminAdapter.service(AdminAdapter.java:222)
36        at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:168)
37        at com.sun.enterprise.v3.server.HK2Dispatcher.dispath(HK2Dispatcher.java:117)
38        at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:234)
39        at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:822)
40        at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:719)
41        at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1013)
42        at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:225)
43        at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
44        at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
45        at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
46        at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
47        at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
48        at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
49        at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
50        at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
51        at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
52        at java.lang.Thread.run(Thread.java:679)
53Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '290924' for key 'IX_F9821AB4'
54        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:213)
55        at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:103)
56        at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:56)
57        at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:36)
58        at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:130)
59        at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:48)
60        at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:129)
61        at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:144)
62        at com.liferay.portal.events.StartupAction.run(StartupAction.java:52)
63        ... 45 more
64Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '290924' for key 'IX_F9821AB4'
65        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:213)
66        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:227)
67        at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:67)
68        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
69        ... 53 more
70Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '290924' for key 'IX_F9821AB4'
71        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
72        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
73        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
74        at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
75        at com.mysql.jdbc.Util.handleNewInstance(Util.java:409)
76        at com.mysql.jdbc.Util.getInstance(Util.java:384)
77        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1041)
78        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3566)
79        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3498)
80        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)
81        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2113)
82        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
83        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2113)
84        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2409)
85        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2327)
86        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2312)
87        at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:877)
88        at com.sun.gjc.spi.base.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:120)
89        at com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary.addSync(UpgradeDocumentLibrary.java:77)
90        at com.liferay.portal.upgrade.v6_1_0.UpgradeDocumentLibrary.updateSyncs(UpgradeDocumentLibrary.java:383)
91        at com.liferay.portal.upgrade.v6_1_0.UpgradeImageGallery.doUpgrade(UpgradeImageGallery.java:321)
92        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:210)
93        ... 56 more
94|#]
95
96[#|2013-01-24T19:44:48.121+0100|INFO|glassfish3.1|javax.enterprise.system.std.com.sun.enterprise.server.logging|_ThreadID=175;_ThreadName=Thread-1;|Stopping the server due to unexpected startup errors|#]


If you look for that key, key 'IX_F9821AB4', you'll find another issue here: https://issues.liferay.com/browse/LPS-25735

But it's not regarding an upgrade. Can anyone help?

Thanks in advance.