liferay setup

[Ramesh Vijayaraghavan, modificado hace 13 años.]

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

[Hitoshi Ozawa, modificado hace 13 años.]

Is the error showing up every time you start Liferay or did it just come up when you first startup Liferay?

[Sergio González, modificado hace 13 años.]

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

[Enrique Valdes Lacasa, modificado hace 8 años.]

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:

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, modificado hace 8 años.]

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.