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
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
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!
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
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
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.
Powered by Liferay™