RE: Unable to Start Liferay DXP 7.1 with MySQL 8.0

Anuvab Ghosh, modified 6 Years ago.

Unable to Start Liferay DXP 7.1 with MySQL 8.0

Regular Member Posts: 130 Join Date: 4/18/15 Recent Posts

Hi,

I am using Liferay DXP (7.1) trial version for development. Also I want to connect this with databse MySQL 8.0.

I have already changed the MySQL connector jar to mysql-connector-java-8.0.13.

But still getting below mentioned error.

2018-12-19 14:09:26.863 ERROR [main][MainServlet:273] java.lang.IllegalStateException: The database contains changes from a previous upgrade attempt that failed. Please restore the old database and file system and retry the upgrade. A patch may be required if the upgrade failed due to a bug or an unforeseen data permutation that resulted from a corrupt database.
java.lang.IllegalStateException: The database contains changes from a previous upgrade attempt that failed. Please restore the old database and file system and retry the upgrade. A patch may be required if the upgrade failed due to a bug or an unforeseen data permutation that resulted from a corrupt database.
   at com.liferay.portal.tools.DBUpgrader._checkReleaseState(DBUpgrader.java:351)
   at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:219)
   at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:239)
   at com.liferay.portal.ee.license.StartupAction.doRun(Unknown Source)
   at com.liferay.portal.events.StartupAction.run(StartupAction.java:82)
   at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1335)
   at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:270)
   at javax.servlet.GenericServlet.init(GenericServlet.java:158)
   at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1124)
   at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1079)
   at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:971)
   at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4765)
   at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5075)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
   at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:742)
   at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:718)
   at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:703)
   at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:630)
   at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1840)
   at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
   at java.util.concurrent.FutureTask.run(FutureTask.java:266)
   at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
   at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:112)
   at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:525)
   at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:424)
   at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1586)
   at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:308)
   at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123)
   at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:424)
   at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:367)
   at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:966)
   at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:839)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
   at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1427)
   at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1417)
   at java.util.concurrent.FutureTask.run(FutureTask.java:266)
   at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75)
   at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:134)
   at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:943)
   at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:258)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
   at org.apache.catalina.core.StandardService.startInternal(StandardService.java:422)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
   at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:770)
   at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183)
   at org.apache.catalina.startup.Catalina.start(Catalina.java:682)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:498)
   at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:353)
   at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:493)

As per Liferay Compatibility Matrix, I have to use MySQL 5.7 for Liferay DXP 7.1.

Is there any way or patch to connect Liferay DXP 7.1 with MySQL 8.0?

Kindly provide your valuable comments here.

Thanks in advance.

Thanks and Regards,

Anuvab

Alberto Chaparro, modified 6 Years ago.

RE: Unable to Start Liferay DXP 7.1 with MySQL 8.0

Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts

Hi Anubav,

The error is not related to your MySQL:

The database contains changes from a previous upgrade attempt that failed. Please restore the old database and file system and retry the upgrade. A patch may be required if the upgrade failed due to a bug or an unforeseen data permutation that resulted from a corrupt database.

It's related to a corrupt state of your database after a previous upgrade attempt. Please restore a backup a repeat and the upgrade MySQL 8.

You can use this version of Mysql, the only difference is that EE Support won't cover those issues caused by the use of a non sopported database version.

Please, let us know about the final results.

Cheers!

Anuvab Ghosh, modified 6 Years ago.

RE: Unable to Start Liferay DXP 7.1 with MySQL 8.0

Regular Member Posts: 130 Join Date: 4/18/15 Recent Posts

hi,

Thanks for your reply.

I have tried several times, but unable to start and getting same error.

As per Lifray Compatibility Matrix, DXP 7.1 support MySQL 5.7.

Kindly share your opinions on this.

Thanks in advance.

Thanks and Regards,

Anuvab

Rob Zondag, modified 6 Years ago.

RE: Unable to Start Liferay DXP 7.1 with MySQL 8.0

New Member Posts: 8 Join Date: 8/7/12 Recent Posts

Alberto Chaparro<p>You can use this version of Mysql, the only difference is that EE
Support won't cover those issues caused by the use of a non sopported
database version.</p>

Hi Alberto,

We're on DXP 7.0 at the moment and really want to upgrade our database server to a clustered MySQL 8 setup.
Have you got any idea if Liferay has MySQL 8 on the roadmap for DXP 7.1 or 7.2 ?

Thanks,

Rob

Alberto Chaparro, modified 6 Years ago.

RE: Unable to Start Liferay DXP 7.1 with MySQL 8.0

Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts

Hi Rob,

We are currently finishing the tests to support MySQL 8 with Liferay 7.2, if everything goes well it will be supported.

For 7.1 is not supported, at least for now. Check compatibility matrices for already published releases here:
https://web.liferay.com/es/services/support/compatibility-matrix

I hope it helps.

Regards.

Community

Company

Feedback

Ask Questions and Find Answers

Important:

Ask is now read-only. You can review any existing questions and answers, but not add anything new.

But - don't panic! While ask is no more, we've replaced it with discuss - the new Liferay Discussion Forum! Read more here here or just visit the site here:

discuss.liferay.com

RE: Unable to Start Liferay DXP 7.1 with MySQL 8.0