Forums de discussion

Setup Liferay 7 GA4 database

thumbnail
Viviana Salcedo, modifié il y a 6 années.

Setup Liferay 7 GA4 database

New Member Publications: 10 Date d'inscription: 25/09/17 Publications récentes
Hello everyone!

I am new at liferay development. Right now, I have tried developing hello world modules and a little form using default values of liferay 7 GA4 with hypersonic, which is the last version. Everything was going well, until I need to start a production environment with a robust database. At first I create a new database in SQL Server 2014 and try connecting a new server with tomcat and liferay with the wizard. As many of you know SQL it's not supported, so I tried downloading the appropriate driver for SQL connection. I based on the git project: https://github.com/amusarra/liferay-portal-sqlserverdb-support. However I couldn't restart successfully the server; one of the many error I found is exposed below (Error 1).

Then, I tried using a postgres 9.3 database. However I continued having problems restarting the server after I setup the database connection using the wizard. At this moment, my postgres database have 26 sessions open because of my restart, the database also have all the tables from liferay but is corrupted.

Can anyone help me identify my problems connecting to postgres or SQL Server?


Error 1
"localhost-startStop-1" #19 daemon prio=5 os_prio=31 tid=0x00007fe258c7a000 nid=0x5d03 runnable [0x000070000d848000]
java.lang.Thread.State: RUNNABLE
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:170)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1877)
at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:6642)
- locked <0x00000007aab14d78> (a com.microsoft.sqlserver.jdbc.TDSReader)
at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7963)
at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:7915)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$1PreparedHandleClose.doExecute(SQLServerPreparedStatement.java:146)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7505)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2445)
- locked <0x00000007857a6d68> (a java.lang.Object)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:191)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.closePreparedHandle(SQLServerPreparedStatement.java:154)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.closeInternal(SQLServerPreparedStatement.java:181)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.close(SQLServerStatement.java:644)
at com.zaxxer.hikari.pool.ProxyStatement.close(ProxyStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.closePreparedStatement(AbstractBatcher.java:563)
at org.hibernate.jdbc.AbstractBatcher.closeStatement(AbstractBatcher.java:291)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:271)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at com.liferay.portal.dao.orm.hibernate.event.NestableFlushEventListener.onFlush(NestableFlushEventListener.java:61)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
at com.liferay.portal.dao.orm.hibernate.SessionImpl.flush(SessionImpl.java:173)
at com.liferay.portal.kernel.dao.orm.ClassLoaderSession.flush(ClassLoaderSession.java:282)
at com.liferay.portal.dao.orm.hibernate.SessionFactoryImpl.closeSession(SessionFactoryImpl.java:46)
at com.liferay.portal.dao.orm.hibernate.VerifySessionFactoryWrapper.closeSession(VerifySessionFactoryWrapper.java:73)
at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.closeSession(BasePersistenceImpl.java:97)
at com.liferay.portal.service.persistence.impl.ResourceActionPersistenceImpl.updateImpl(ResourceActionPersistenceImpl.java:1173)
at com.liferay.portal.service.persistence.impl.ResourceActionPersistenceImpl.updateImpl(ResourceActionPersistenceImpl.java:63)
at com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl.update(BasePersistenceImpl.java:348)
at com.liferay.portal.service.impl.ResourceActionLocalServiceImpl.addResourceAction(ResourceActionLocalServiceImpl.java:72)
at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:163)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:169)
at com.sun.proxy.$Proxy58.addResourceAction(Unknown Source)
at com.liferay.portal.service.impl.ResourceActionLocalServiceImpl.checkResourceActions(ResourceActionLocalServiceImpl.java:140)
at sun.reflect.GeneratedMethodAccessor116.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:163)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:169)
at com.sun.proxy.$Proxy58.checkResourceActions(Unknown Source)
at com.liferay.portal.kernel.service.ResourceActionLocalServiceUtil.checkResourceActions(ResourceActionLocalServiceUtil.java:289)
at com.liferay.portal.verify.VerifyPermission.checkPermissions(VerifyPermission.java:94)
at com.liferay.portal.verify.VerifyPermission.doVerify(VerifyPermission.java:225)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:88)
at com.liferay.portal.verify.VerifyProcessSuite.doVerify(VerifyProcessSuite.java:32)
at com.liferay.portal.verify.VerifyProcess.verify(VerifyProcess.java:70)
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.events.StartupAction.run(StartupAction.java:85)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1329)
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)
- locked <0x0000000783ce2350> (a org.apache.catalina.core.StandardWrapper)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1151)
- locked <0x0000000783ce2350> (a org.apache.catalina.core.StandardWrapper)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1038)
- locked <0x0000000783ce2350> (a org.apache.catalina.core.StandardWrapper)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4997)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5289)
- locked <0x00000007821c7240> (a org.apache.catalina.core.StandardContext)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
- locked <0x00000007821c7240> (a org.apache.catalina.core.StandardContext)
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:745)

Locked ownable synchronizers:
- <0x00000007821976f0> (a java.util.concurrent.ThreadPoolExecutor$Worker)

"Catalina-startStop-1" #18 daemon prio=5 os_prio=31 tid=0x00007fe258cea800 nid=0x5b03 waiting on condition [0x000070000d746000]
java.lang.Thread.State: WAITING (parking)
at sun.misc.Unsafe.park(Native Method)
- parking to wait for <0x0000000782287b58> (a java.util.concurrent.FutureTask)
at java.util.concurrent.locks.LockSupport.park(LockSupport.java:175)
at java.util.concurrent.FutureTask.awaitDone(FutureTask.java:429)
at java.util.concurrent.FutureTask.get(FutureTask.java:191)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:502)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:398)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1542)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:286)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:95)
at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)
at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:394)
- locked <0x00000007821acfd8> (a org.apache.catalina.core.StandardHost)
at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:339)
- locked <0x00000007821acfd8> (a org.apache.catalina.core.StandardHost)
at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:933)
- locked <0x00000007821acfd8> (a org.apache.catalina.core.StandardHost)
at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:871)
- locked <0x00000007821acfd8> (a org.apache.catalina.core.StandardHost)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:147)
- locked <0x00000007821acfd8> (a org.apache.catalina.core.StandardHost)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1408)
at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1398)
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:745)

Locked ownable synchronizers:
- <0x00000007822877d0> (a java.util.concurrent.ThreadPoolExecutor$Worker)
Seema Pavar, modifié il y a 6 années.

RE: Setup Liferay 7 GA4 database

New Member Publications: 3 Date d'inscription: 28/09/17 Publications récentes
You can try with sudo/admin user