Forums de discussion
Empty Liferay 7 instance with oracle db g11
Mikko Forsman, modifié il y a 6 années.
Empty Liferay 7 instance with oracle db g11
New Member Publications: 19 Date d'inscription: 21/04/17 Publications récentes
Hello,
During my Liferay development I have noticed that at some point Liferay stops being able to initialize a new database. I have installed an oracle g11 database which is working fine, but even if I create a new user with a new tablespace Liferay still isn't able to start when connecting to that database with the new user. Whenever I try to connect liferay to an empty oracle db instance, I get the following error right after Liferay has populated the empty tables:
If I connect to the oracle db instance that I initialized earlier on, the database works as it should. And if I connect to the hsql database, liferay initializes as it should. So where could the error be? I have also tried with a clean Liferay bundle, but the same error remains, so the issue seems to lie somewhere in the oracle database or liferay initialization.
EDIT: If I try to start the instance again after the error has occurred, I get the following exception:
Regards,
Mikko Forsman
During my Liferay development I have noticed that at some point Liferay stops being able to initialize a new database. I have installed an oracle g11 database which is working fine, but even if I create a new user with a new tablespace Liferay still isn't able to start when connecting to that database with the new user. Whenever I try to connect liferay to an empty oracle db instance, I get the following error right after Liferay has populated the empty tables:
10:06:04,605 ERROR [localhost-startStop-1][DBUpgrader:253] Unable to execute verify process: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist_ [Sanitized]
com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist_ [Sanitized]
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:73)
at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:175)
at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:87)
at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:247)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:243)
at com.liferay.portal.ee.license.StartupAction.doRun(Unknown Source)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:85)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1341)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:272)
at javax.servlet.GenericServlet.init(GenericServlet.java:158)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1238)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1151)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1038)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4997)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5289)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:585)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1794)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist_ [Sanitized]
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:73)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:88)
at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:48)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
... 28 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist_ [Sanitized]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1036)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1845)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1810)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)
at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:287)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:256)
at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:66)
at com.liferay.portal.verify.VerifyWorkflow.deleteOrphaned(VerifyWorkflow.java:73)
at com.liferay.portal.verify.VerifyWorkflow.deleteOrphaned(VerifyWorkflow.java:47)
at com.liferay.portal.verify.VerifyWorkflow.doVerify(VerifyWorkflow.java:78)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
... 31 more
10:06:04,608 ERROR [localhost-startStop-1][MainServlet:275] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist_ [Sanitized]
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist_ [Sanitized]
at com.liferay.portal.events.StartupAction.run(StartupAction.java:91)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1341)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:272)
at javax.servlet.GenericServlet.init(GenericServlet.java:158)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1238)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1151)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1038)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4997)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5289)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:725)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:701)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:717)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:585)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1794)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.liferay.portal.verify.VerifyException: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist_ [Sanitized]
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:73)
at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:113)
at com.liferay.portal.verify.VerifyProcessUtil._verifyProcess(VerifyProcessUtil.java:78)
at com.liferay.portal.verify.VerifyProcessUtil.verifyProcess(VerifyProcessUtil.java:47)
at com.liferay.portal.events.StartupHelper.verifyProcess(StartupHelper.java:175)
at com.liferay.portal.events.StartupHelperUtil.verifyProcess(StartupHelperUtil.java:87)
at com.liferay.portal.tools.DBUpgrader.verify(DBUpgrader.java:247)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:243)
at com.liferay.portal.ee.license.StartupAction.doRun(Unknown Source)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:85)
... 19 more
Caused by: com.liferay.portal.verify.VerifyException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist_ [Sanitized]
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:73)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:88)
at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:48)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
... 28 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist_ [Sanitized]
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:195)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1036)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1845)
at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1810)
at oracle.jdbc.driver.OracleStatementWrapper.executeUpdate(OracleStatementWrapper.java:294)
at com.zaxxer.hikari.pool.ProxyStatement.executeUpdate(ProxyStatement.java:120)
at com.zaxxer.hikari.pool.HikariProxyStatement.executeUpdate(HikariProxyStatement.java)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:287)
at com.liferay.portal.dao.db.BaseDB.runSQL(BaseDB.java:256)
at com.liferay.portal.kernel.dao.db.BaseDBProcess.runSQL(BaseDBProcess.java:66)
at com.liferay.portal.verify.VerifyWorkflow.deleteOrphaned(VerifyWorkflow.java:73)
at com.liferay.portal.verify.VerifyWorkflow.deleteOrphaned(VerifyWorkflow.java:47)
at com.liferay.portal.verify.VerifyWorkflow.doVerify(VerifyWorkflow.java:78)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
... 31 more
Stopping the server due to unexpected startup errors
If I connect to the oracle db instance that I initialized earlier on, the database works as it should. And if I connect to the hsql database, liferay initializes as it should. So where could the error be? I have also tried with a clean Liferay bundle, but the same error remains, so the issue seems to lie somewhere in the oracle database or liferay initialization.
EDIT: If I try to start the instance again after the error has occurred, I get the following exception:
10:10:33,120 ERROR [localhost-startStop-1][MainServlet:275] 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.
Regards,
Mikko Forsman
Olaf Kock, modifié il y a 6 années.
RE: Empty Liferay 7 instance with oracle db g11
Liferay Legend Publications: 6403 Date d'inscription: 23/09/08 Publications récentes
Out of the box Liferay Portal 7 CE does not support commercial databases any more. You should either use one of the supported (open source) ones, check Antonio's integration, or use Liferay DXP to use Oracle.