Combination View Flat View Tree View
Threads [ Previous | Next ]
toggle
Stan X
Subquery returns more than 1 row
July 27, 2010 2:27 PM
Answer

Stan X

Rank: Regular Member

Posts: 204

Join Date: January 27, 2008

Recent Posts

Trying to upgrade from 5.2.2 to 6.0.4 and getting "Subquery returns more than 1 row" errors.

LP 6.0.4 Tomcat Bundle
MySQL 5.1.45
Fedora 12

 1
 2
 314:17:06,715 INFO  [UpgradeProcess:108] Upgrading com.liferay.portal.upgrade.v5_2_3.UpgradeMessageBoards
 414:17:07,099 ERROR [MainServlet:196] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Subquery returns more than 1 row
 5com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Subquery returns more than 1 row
 6        at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
 7        at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1160)
 8        at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:193)
 9        at javax.servlet.GenericServlet.init(GenericServlet.java:212)
10        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
11        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
12        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4187)
13        at org.apache.catalina.core.StandardContext.start(StandardContext.java:4496)
14        at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
15        at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
16        at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
17        at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
18        at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
19        at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
20        at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1277)
21        at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:321)
22        at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
23        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
24        at org.apache.catalina.core.StandardHost.start(StandardHost.java:785)
25        at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1045)
26        at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
27        at org.apache.catalina.core.StandardService.start(StandardService.java:519)
28        at org.apache.catalina.core.StandardServer.start(StandardServer.java:710)
29        at org.apache.catalina.startup.Catalina.start(Catalina.java:581)
30        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
31        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
32        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
33        at java.lang.reflect.Method.invoke(Method.java:597)
34        at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
35        at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
36Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Subquery returns more than 1 row
37        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114)
38        at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:80)
39        at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:37)
40        at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
41        at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
42        at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:94)
43        at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:117)
44        at com.liferay.portal.events.StartupAction.run(StartupAction.java:47)
45        ... 29 more
46Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Subquery returns more than 1 row
47        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:114)
48        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:130)
49        at com.liferay.portal.upgrade.UpgradeProcess_5_2_3.doUpgrade(UpgradeProcess_5_2_3.java:53)
50        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
51        ... 36 more
52Caused by: java.sql.SQLException: Subquery returns more than 1 row
53        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
54        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
55        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
56        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
57        at com.mysql.jdbc.Connection.execSQL(Connection.java:3250)
58        at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1355)
59        at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1270)
60        at com.mchange.v2.c3p0.impl.NewProxyStatement.executeUpdate(NewProxyStatement.java:64)
61        at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:225)
62        at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:192)
63        at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:179)
64        at com.liferay.portal.kernel.upgrade.UpgradeProcess.runSQL(UpgradeProcess.java:80)
65        at com.liferay.portal.upgrade.v5_2_3.UpgradeMessageBoards.updateMessageClassNameId(UpgradeMessageBoards.java:75)
66        at com.liferay.portal.upgrade.v5_2_3.UpgradeMessageBoards.doUpgrade(UpgradeMessageBoards.java:27)
67        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:111)
68        ... 39 more
69Stopping the server due to unexpected startup errors


Any ideas?
Shagul Khajamohideen
RE: Subquery returns more than 1 row
July 27, 2010 3:31 PM
Answer

Shagul Khajamohideen

Rank: Liferay Master

Posts: 759

Join Date: September 27, 2007

Recent Posts

Looks like upgrading to 5.2.3 is failing. Probably you can try upgrading to just 5.2.3 to isolate and fix the issues and then try upgrading to 6 GA.

The below ticket seems related.

http://issues.liferay.com/browse/LPS-9941
Samuel Liu
RE: Subquery returns more than 1 row
July 27, 2010 4:02 PM
Answer

Samuel Liu

Community Moderator

Rank: Expert

Posts: 301

Join Date: May 27, 2010

Recent Posts

Found this in another upgrade bug ticket:

For people who are coming upon this issue having difficulties upgrading from 5.2.3 to 6.0.3/6.0.4 - for your document library upgrade to be successful you must also set 6.0.3 to use the same document library hook as your 5.2.3 bundle:

dl.hook.impl=com.liferay.documentlibrary.util.FileSystemHook

dl.hook.file.system.root.dir=L:/testing/tomcat/liferay-portal-5.2.3/data/document_library


When you get it to upgrade to 5.2.3 and are moving to upgrade to Liferay 6, this will be important to note.

There are a bunch of other upgrade bugs for 5.2.2 to 5.2.3. See http://issues.liferay.com for resolved and unresolved bugs. You can also file a bug ticket for this, which makes it easier for our developers to have a look. This would be one of the things higher up on the priority list because it has to do with upgrading.

Warm regards,
Sam
Stan X
RE: Subquery returns more than 1 row
July 27, 2010 9:38 PM
Answer

Stan X

Rank: Regular Member

Posts: 204

Join Date: January 27, 2008

Recent Posts

Thanks for the replies.

I have created the ticket LPS-11631.
Samuel Liu
RE: Subquery returns more than 1 row
July 30, 2010 1:49 PM
Answer

Samuel Liu

Community Moderator

Rank: Expert

Posts: 301

Join Date: May 27, 2010

Recent Posts

Hi Stan,

This has been reproduced and identified as a bug that has been moved into our current code sprint. Thanks for your patience and for reporting this: rest assured we are working on a fix.

Warm regards,
Sam