Problems in upgare from 6.0.6 to 6.1.0

Fórum

Mika Saapunki, modificado 12 Anos atrás.

Problems in upgare from 6.0.6 to 6.1.0

New Member Mensagem: 1 Data de Entrada: 08/08/11 Postagens Recentes

Hi,
something went wrong with update and now I cannot get liferay to start.


lots of WARNings from duplicate columns
12:22:58,866 WARN  [BaseDB:381] Duplicate column name 'classPK': alter table WorkflowDefinitionLink add classPK bigint;

12:22:58,870 WARN  [BaseDB:381] Duplicate column name 'typePK': alter table WorkflowDefinitionLink add typePK bigint;

12:22:58,872 INFO  [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeUserName

12:22:58,883 ERROR [MainServlet:204] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'lportal.IGFolder' doesn't exist
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'lportal.IGFolder' doesn't exist
        at com.liferay.portal.events.StartupAction.run(StartupAction.java:57)
        at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1302)
        at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:201)
        at javax.servlet.GenericServlet.init(GenericServlet.java:160)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1228)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1147)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1043)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4957)
        at org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5284)
        at org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5279)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
        at java.lang.Thread.run(Thread.java:636)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'lportal.IGFolder' doesn't exist
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:211)
        at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:93)
        at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:46)
        at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
        at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
        at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:112)
        at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:128)
        at com.liferay.portal.events.StartupAction.run(StartupAction.java:51)
        ... 14 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'lportal.IGFolder' doesn't exist
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:211)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:227)
        at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:60)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:208)
        ... 21 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'lportal.IGFolder' doesn't exist
        at sun.reflect.GeneratedConstructorAccessor49.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
        at com.liferay.portal.upgrade.v6_1_0.UpgradeUserName.updateTable(UpgradeUserName.java:69)
        at com.liferay.portal.upgrade.v6_1_0.UpgradeUserName.doUpgrade(UpgradeUserName.java:36)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:208)
        ... 24 more
Stopping the server due to unexpected startup errors

How to recover from this situation? Anychange to undo those mysql changes that liferay 6.1.0 upgrade procedure has made?

EDIT: reverted back to 6.0.6 and used backup of lportal. It would have been very nice to use newest edition, but no... emoticon

Kailash Yadav, modificado 12 Anos atrás.

RE: Problems in upgare from 6.0.6 to 6.1.0

Regular Member Postagens: 211 Data de Entrada: 18/10/11 Postagens Recentes

I am also getting same problem. is there any workaround for this problem?

ma bu, modificado 12 Anos atrás.

RE: Problems in upgare from 6.0.6 to 6.1.0

Junior Member Postagens: 31 Data de Entrada: 14/05/10 Postagens Recentes

Same problem for me by trying to upgrade from 6.0.6 to 6.1.0 B4.
Is this a known bug so far? Is there a workaround available?
Thanks

Mickaël Manteau, modificado 12 Anos atrás.

RE: Problems in upgare from 6.0.6 to 6.1.0

New Member Postagens: 7 Data de Entrada: 06/12/11 Postagens Recentes

same problem with upgrade 6.0.6 GA4 to 6.1 RC1

do you have a solution ?

James Falkner, modificado 12 Anos atrás.

RE: Problems in upgare from 6.0.6 to 6.1.0

Liferay Legend Postagens: 1399 Data de Entrada: 17/09/10 Postagens Recentes

Mickaël Manteau:

same problem with upgrade 6.0.6 GA4 to 6.1 RC1

do you have a solution ?

Can you provide more details as to the state of your installation before the upgrade? Did you start with a fresh 6.0.6 and upgrade? Or what kinds of data was in the db?

Rajesh Bangaram, modificado 12 Anos atrás.

RE: Problems in upgare from 6.0.6 to 6.1.0

Junior Member Postagens: 71 Data de Entrada: 08/03/11 Postagens Recentes

Hi James,

I face the same problem, Unable to upgrade from 6.0.6 to 6.1.0. Below is the error I get.

com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lportal.igimage' doesn't exist
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'lportal.igimage' doesn't exist
at com.liferay.portal.events.StartupAction.run(StartupAction.java:58)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.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:1080)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:5001)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.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:842)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:615)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:649)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1581)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
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(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:619)

Any way to fix this issue? Thanks in advance.

-Regards
Rajesh

Tom Vleminckx, modificado 12 Anos atrás.

RE: Problems in upgare from 6.0.6 to 6.1.0

Junior Member Postagens: 39 Data de Entrada: 27/06/11 Postagens Recentes

Is there already a fix ?

MICHAIL MOUDATSOS, modificado 12 Anos atrás.

RE: Problems in upgare from 6.0.6 to 6.1.0

Regular Member Postagens: 110 Data de Entrada: 04/10/11 Postagens Recentes

It seems there are a lot of ppl having problems upgrading from 6.0.6 to 6.1. And think that 6.1 is now on official release and yet...

In my case I had various problems. My last try was as follows

I created a fresh 6.0.6 installation. I deployed my portlet project and theme. I imported .lar files concerning pages (and all included content, ie themes, portlets, web content) from another fresh 6.0.6 installation I had made some days before. Everything went smoothly. Even the .lar imprts were successful.
Then I created a fresh 6.1 installation. I backed up my DB at the SQL server I use. I restored it under a different name so I would not lose the original one. I made the proper changes to portal-ext.properties. I even tried to add the data/images folder from my 6.0.6 installation (I tried without this step also - same results, as will be shown in a minute)
Then I fired catalina.bat run on the command prompt in order to be able to see console output. Apart from the... zounds WARN [BaseDB:382] Column names in each table must be unique. and WARN [BaseDB:382] There is already an object named messages I got, the following set of messages is noteworthy since there's where the execution was terminated:

...
09:29:49,039 WARN  [BaseDB:382] Column names in each table must be unique. Column name 'site' in table 'Group_' is specified more than once.: alter ta
ble Group_ add site bit;

09:29:49,126 WARN  [BaseDB:382] Cannot find the object "[b]IGFolder[/b]" because it does not exist or you do not have permissions.: alter table IGFolder add
userName nvarchar(75) null;

09:29:49,212 WARN  [BaseDB:382] Cannot find the object "IGImage" because it does not exist or you do not have permissions.: alter table IGImage add us
erName nvarchar(75) null;
...

09:30:09,172 WARN  [BaseDB:382] There is already an object named 'QUARTZ_SIMPROP_TRIGGERS' in the database.: CREATE TABLE QUARTZ_SIMPROP_TRIGGERS (
SCHED_NAME nvarchar(120) not null,      TRIGGER_NAME nvarchar(200) not null,    TRIGGER_GROUP nvarchar(200) not null,   STR_PROP_1 nvarchar(512) null,
        STR_PROP_2 nvarchar(512) null,  STR_PROP_3 nvarchar(512) null,  INT_PROP_1 int null,    INT_PROP_2 int null,    LONG_PROP_1 bigint null,
LONG_PROP_2 bigint null,        DEC_PROP_1 NUMERIC(13,4) null,  DEC_PROP_2 NUMERIC(13,4) null,  BOOL_PROP_1 bit null,   BOOL_PROP_2 bit null,   primar
y key (SCHED_NAME, TRIGGER_NAME, TRIGGER_GROUP));

09:30:09,245 INFO  [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeUserName
09:30:09,336 ERROR [MainServlet:198] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay
.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Invalid object name '[b]IGFolder[/b]'.
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeExcepti
on: java.sql.SQLException: Invalid object name '[b]IGFolder[/b]'.
...
t java.lang.Thread.run(Thread.java:619)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Invalid obje
ct name 'IGFolder'.
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:211)
...
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: java.sql.SQLException: Invalid object name 'IGFolder'.
...
Caused by: java.sql.SQLException: Invalid object name 'IGFolder'.
...
Stopping the server due to unexpected startup errors

The error about IGFolder object was the last error before upgrade terminated abnormally.

Now what is even more interesting is that... remember that other fresh 6.0.6 installation from which I exported the .lar files for this new 6.0.6 installation on which I would try the upgrade? Well, the upgrade worked for that one! Oh yeah! ( Idon't remember if I manually copied the data/images folder before I begin upgrade but judging from the folder timestamps I probably did). Now isn't that interesting? I also have to note that, that particular upgrade took place on a different machine and OS, so I don;t really have the same conditions, still I think the fact that I used .lar imports on the 6.0.6 installation where the upgrade to 6.1 was unsuccessful, must have affected the upgrade result.

MICHAIL MOUDATSOS, modificado 12 Anos atrás.

RE: Problems in upgare from 6.0.6 to 6.1.0

Regular Member Postagens: 110 Data de Entrada: 04/10/11 Postagens Recentes

Important update!

I retried upgrade and it worked only this time I used a very very simple portal-ext.properties
containing only jdbc.default.* properties, and company properties such as company.default.name, company.default.web.id, company.security.auth.type, and image.hook.impl=com.liferay.portal.image.FileSystemHook

It is very strange but thats what happened. After an application server reboot the theme worked as well.

Michele Giacobazzi, modificado 11 Anos atrás.

RE: Problems in upgare from 6.0.6 to 6.1.0

Junior Member Postagens: 40 Data de Entrada: 09/09/11 Postagens Recentes

Mika Saapunki:

Hi,
something went wrong with update and now I cannot get liferay to start.


lots of WARNings from duplicate columns
12:22:58,866 WARN  [BaseDB:381] Duplicate column name 'classPK': alter table WorkflowDefinitionLink add classPK bigint;

12:22:58,870 WARN  [BaseDB:381] Duplicate column name 'typePK': alter table WorkflowDefinitionLink add typePK bigint;

12:22:58,872 INFO  [UpgradeProcess:205] Upgrading com.liferay.portal.upgrade.v6_1_0.UpgradeUserName

12:22:58,883 ERROR [MainServlet:204] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'lportal.IGFolder' doesn't exist
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'lportal.IGFolder' doesn't exist
        at com.liferay.portal.events.StartupAction.run(StartupAction.java:57)
        at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1302)
        at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:201)
        at javax.servlet.GenericServlet.init(GenericServlet.java:160)
        at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1228)
        at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1147)
        at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1043)
        at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4957)
        at org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5284)
        at org.apache.catalina.core.StandardContext$3.call(StandardContext.java:5279)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
        at java.util.concurrent.FutureTask.run(FutureTask.java:166)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
        at java.lang.Thread.run(Thread.java:636)
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'lportal.IGFolder' doesn't exist
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:211)
        at com.liferay.portal.upgrade.UpgradeProcessUtil._upgradeProcess(UpgradeProcessUtil.java:93)
        at com.liferay.portal.upgrade.UpgradeProcessUtil.upgradeProcess(UpgradeProcessUtil.java:46)
        at com.liferay.portal.events.StartupHelper.upgradeProcess(StartupHelper.java:73)
        at com.liferay.portal.events.StartupHelperUtil.upgradeProcess(StartupHelperUtil.java:40)
        at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:112)
        at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:128)
        at com.liferay.portal.events.StartupAction.run(StartupAction.java:51)
        ... 14 more
Caused by: com.liferay.portal.kernel.upgrade.UpgradeException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'lportal.IGFolder' doesn't exist
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:211)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:227)
        at com.liferay.portal.upgrade.UpgradeProcess_6_1_0.doUpgrade(UpgradeProcess_6_1_0.java:60)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:208)
        ... 21 more
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'lportal.IGFolder' doesn't exist
        at sun.reflect.GeneratedConstructorAccessor49.newInstance(Unknown Source)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2281)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
        at com.liferay.portal.upgrade.v6_1_0.UpgradeUserName.updateTable(UpgradeUserName.java:69)
        at com.liferay.portal.upgrade.v6_1_0.UpgradeUserName.doUpgrade(UpgradeUserName.java:36)
        at com.liferay.portal.kernel.upgrade.UpgradeProcess.upgrade(UpgradeProcess.java:208)
        ... 24 more
Stopping the server due to unexpected startup errors

Any solution to the Table 'liferay.IGFolder' doesn't exist problem?

Kailash Yadav, modificado 11 Anos atrás.

RE: Problems in upgare from 6.0.6 to 6.1.0

Regular Member Postagens: 211 Data de Entrada: 18/10/11 Postagens Recentes

Liferay 6.1 does not need IGFolder table. So upgrade procedure drop this table. If you get any error in upgrade process after IGFolder table dropped and try to upgrade again, you will face this error.

So quick solution is restore this table from your backup, and try to find out actual error.

Murali Mohan Surampudi, modificado 11 Anos atrás.

RE: Problems in upgare from 6.0.6 to 6.1.0

Junior Member Postagens: 37 Data de Entrada: 05/03/12 Postagens Recentes

Hi Guys,

Can any help me to fix this issue while upgrading liferay 6.0.6 to 6.1.0?
It is throwing many duplicate column name errors while upgrading and server is shutting down.
I have attached a file error.txt for you to review.

Thanks in Advance,
Murali Mohan

Hitoshi Ozawa, modificado 11 Anos atrás.

RE: Problems in upgare from 6.0.6 to 6.1.0

Liferay Legend Postagens: 7942 Data de Entrada: 24/03/10 Postagens Recentes

Your error seems to be from deploying your custom developed adayana-mle-lite-lms-portlet-6.0.6.1.war instead of upgrade. If you are having problems deploying your portlet, please create a new thread.

Murali Mohan Surampudi, modificado 11 Anos atrás.

RE: Problems in upgare from 6.0.6 to 6.1.0

Junior Member Postagens: 37 Data de Entrada: 05/03/12 Postagens Recentes

Hi Hitoshi Ozawa,

Thanks for ur reply...
I have posted a wrong error msg ....
Please check this upgradeError.txt and reply me..

And My portal-ext.properties file is also attached.

Thanks,
Murali