Fórumok
liferay setup
Ramesh Vijayaraghavan, módosítva 13 év-val korábban
liferay setup
Junior Member Bejegyzések: 49 Csatlakozás dátuma: 2010.09.15. Legújabb bejegyzések
I am setting up liferay6.05 with Tomcat and MySQL. However on the console, i get the ERROR below. What is this error about? what can I do to rectify it?
14:47:19,754 INFO [DialectDetector:69] Determining dialect for MySQL 5
14:47:19,879 INFO [DialectDetector:49] Using dialect org.hibernate.dialect.MySQ
LDialect
14:47:26,270 INFO [PortalImpl:277] Global lib directory /C:/liferay-portal-6.0.
5/tomcat-6.0.26/lib/ext/
14:47:26,270 INFO [PortalImpl:297] Portal lib directory /C:/liferay-portal-6.0.
5/tomcat-6.0.26/webapps/ROOT/WEB-INF/lib/
Starting Liferay Portal Community Edition 6.0.5 CE (Bunyan / Build 6005 / August
16, 2010)
14:47:52,144 ERROR [JDBCExceptionReporter:101] Table 'lportal.lock_' doesn't exi
st
14:47:53,207 WARN [ReleaseLocalServiceImpl:143] Table 'lportal.release_' doesn'
t exist
14:47:53,207 INFO [ReleaseLocalServiceImpl:84] Create tables and populate with
default data
14:48:04,035 INFO [BaseDB:399] Database does not support case sensitive queries
14:48:11,409 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify
ProcessSuite
14:47:19,754 INFO [DialectDetector:69] Determining dialect for MySQL 5
14:47:19,879 INFO [DialectDetector:49] Using dialect org.hibernate.dialect.MySQ
LDialect
14:47:26,270 INFO [PortalImpl:277] Global lib directory /C:/liferay-portal-6.0.
5/tomcat-6.0.26/lib/ext/
14:47:26,270 INFO [PortalImpl:297] Portal lib directory /C:/liferay-portal-6.0.
5/tomcat-6.0.26/webapps/ROOT/WEB-INF/lib/
Starting Liferay Portal Community Edition 6.0.5 CE (Bunyan / Build 6005 / August
16, 2010)
14:47:52,144 ERROR [JDBCExceptionReporter:101] Table 'lportal.lock_' doesn't exi
st
14:47:53,207 WARN [ReleaseLocalServiceImpl:143] Table 'lportal.release_' doesn'
t exist
14:47:53,207 INFO [ReleaseLocalServiceImpl:84] Create tables and populate with
default data
14:48:04,035 INFO [BaseDB:399] Database does not support case sensitive queries
14:48:11,409 INFO [VerifyProcess:76] Verifying com.liferay.portal.verify.Verify
ProcessSuite
Hitoshi Ozawa, módosítva 13 év-val korábban
RE: liferay setup
Liferay Legend Bejegyzések: 7942 Csatlakozás dátuma: 2010.03.24. Legújabb bejegyzések
Is the error showing up every time you start Liferay or did it just come up when you first startup Liferay?
Sergio González, módosítva 13 év-val korábban
RE: liferay setup
Expert Bejegyzések: 301 Csatlakozás dátuma: 2010.01.07. Legújabb bejegyzések
Hi Ramesh,
Actually that's not a Liferay error. Liferay is checking if the tables and basic information is already set in the DB. However, as this is the first time you start Liferay with that database, the DB tables and information has not been set yet.
Just let it run so it creates the tables and all the necessary information.
Then, you will be able to browse Liferay
Regards,
Sergio
Actually that's not a Liferay error. Liferay is checking if the tables and basic information is already set in the DB. However, as this is the first time you start Liferay with that database, the DB tables and information has not been set yet.
Just let it run so it creates the tables and all the necessary information.
Then, you will be able to browse Liferay
Regards,
Sergio
Enrique Valdes Lacasa, módosítva 8 év-val korábban
RE: liferay setup
Junior Member Bejegyzések: 92 Csatlakozás dátuma: 2014.07.29. Legújabb bejegyzések
Thanks for the info Sergio, I did as you mentioned. Although, whenever I start a Liferay CE 6.2 ga3 instance pointing a new local MySQL instance, I received this error:
Do you know if we should ignore this one? I did all the steps since the beginning with a clean bundle and a clean database, but maybe I missed something.
Thanks! Gracias!
SEVERE: Servlet.service() for servlet jsp threw exception
com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
at com.mysql.jdbc.Util.getInstance(Util.java:386)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1065)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2794)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2006)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1467)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1135)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
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 org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1185)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1261)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:113)
at com.liferay.portal.dao.orm.hibernate.QueryImpl.list(QueryImpl.java:98)
at com.liferay.portal.service.persistence.ResourcePermissionPersistenceImpl.fetchByC_N_S_P_R(ResourcePermissionPersistenceImpl.java:3701)
at com.liferay.portal.service.persistence.ResourcePermissionPersistenceImpl.fetchByC_N_S_P_R(ResourcePermissionPersistenceImpl.java:3595)
at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.doUpdateResourcePermission(ResourcePermissionLocalServiceImpl.java:1141)
at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.updateResourcePermission(ResourcePermissionLocalServiceImpl.java:1321)
at com.liferay.portal.service.impl.ResourcePermissionLocalServiceImpl.setResourcePermissions(ResourcePermissionLocalServiceImpl.java:1085)
at sun.reflect.GeneratedMethodAccessor418.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:115)
at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:62)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:51)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:175)
at com.sun.proxy.$Proxy90.setResourcePermissions(Unknown Source)
at com.liferay.portal.service.impl.ResourceLocalServiceImpl.addGroupPermissions(ResourceLocalServiceImpl.java:592)
at com.liferay.portal.service.impl.ResourceLocalServiceImpl.addGroupPermissions(ResourceLocalServiceImpl.java:582)
at com.liferay.portal.service.impl.ResourceLocalServiceImpl.addResources(ResourceLocalServiceImpl.java:885)
at com.liferay.portal.service.impl.ResourceLocalServiceImpl.addResources(ResourceLocalServiceImpl.java:298)
at sun.reflect.GeneratedMethodAccessor642.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:115)
at com.liferay.portal.spring.transaction.DefaultTransactionExecutor.execute(DefaultTransactionExecutor.java:62)
at com.liferay.portal.spring.transaction.TransactionInterceptor.invoke(TransactionInterceptor.java:51)
at com.liferay.portal.spring.aop.ServiceBeanMethodInvocation.proceed(ServiceBeanMethodInvocation.java:111)
at com.liferay.portal.spring.aop.ServiceBeanAopProxy.invoke(ServiceBeanAopProxy.java:175)
at com.sun.proxy.$Proxy85.addResources(Unknown Source)
at com.liferay.portal.service.ResourceLocalServiceUtil.addResources(ResourceLocalServiceUtil.java:230)
at com.liferay.portal.util.PortalImpl.addDefaultResource(PortalImpl.java:7231)
at com.liferay.portal.util.PortalImpl.addPortletDefaultResource(PortalImpl.java:627)
at com.liferay.portal.util.PortalUtil.addPortletDefaultResource(PortalUtil.java:144)
at com.liferay.portlet.SecurityPortletContainerWrapper.check(SecurityPortletContainerWrapper.java:207)
at com.liferay.portlet.SecurityPortletContainerWrapper.checkRender(SecurityPortletContainerWrapper.java:243)
at com.liferay.portlet.SecurityPortletContainerWrapper.render(SecurityPortletContainerWrapper.java:139)
at com.liferay.portlet.RestrictPortletContainerWrapper.render(RestrictPortletContainerWrapper.java:126)
at com.liferay.portal.kernel.portlet.PortletContainerUtil.render(PortletContainerUtil.java:156)
at com.liferay.portal.layoutconfiguration.util.PortletRenderer._render(PortletRenderer.java:125)
at com.liferay.portal.layoutconfiguration.util.PortletRenderer.access$4(PortletRenderer.java:107)
at com.liferay.portal.layoutconfiguration.util.PortletRenderer$PortletRendererCallable.doCall(PortletRenderer.java:180)
at com.liferay.portal.layoutconfiguration.util.PortletRenderer$PortletRendererCallable.doCall(PortletRenderer.java:1)
at com.liferay.portal.kernel.executor.CopyThreadLocalCallable.call(CopyThreadLocalCallable.java:69)
at java.util.concurrent.FutureTask.run(Unknown Source)
at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask._runTask(ThreadPoolExecutor.java:682)
at com.liferay.portal.kernel.concurrent.ThreadPoolExecutor$WorkerTask.run(ThreadPoolExecutor.java:593)
at java.lang.Thread.run(Unknown Source)
Do you know if we should ignore this one? I did all the steps since the beginning with a clean bundle and a clean database, but maybe I missed something.
Thanks! Gracias!
Enrique Valdes Lacasa, módosítva 8 év-val korábban
RE: liferay setup
Junior Member Bejegyzések: 92 Csatlakozás dátuma: 2014.07.29. Legújabb bejegyzések
Replying to myself, this error didn't happen after letting Liferay finish all its configuration in the database and restarting it afterwards. So it looks like it's all good! Restarting the server cleared it.