Hi, Thank for the tip. It works very well now.
Regards, Fabrice Le 01/09/2011 15:26, Eric Dalquist a écrit : > Could you edit > /uportal-war/src/main/resources/properties/portal.properties and change > the property > > org.jasig.portal.io.threadPool.maxThreads=20 > > To: > > org.jasig.portal.io.threadPool.maxThreads=1 > > > On 9/1/11 8:12 AM, Fabrice Marchon wrote: >> Hi, >> >> >> I'm experiencing some problems when using MySQL as database for uPortal >> v4 (both tags 4RC2 and 4.0.0) construction. >> >> I have run the steps specified on the MySQL configuration page >> (https://wiki.jasig.org/display/UPM40/MySQL). >> >> Everything goes fine for the "ant dbtest" target until I try the "ant >> initdb" or "ant initportal" one ; a superb "deadlock" error arises when >> making a prepared statement into the UP_USER table. >> >> >> Do you have an idea?? >> >> >> Environnement: >> - RHEL 6.1 64 bits, MySQL 5.1.52 , mysql-connector-java 5.1.17 >> >> >> Regards, >> Fabrice Marchon >> >> >> Here is the stacktrace: >> >> [java] INFO Importing Data from: >> /home/tomcat5/uportal/uportal4/uPortal/uportal-war/src/main/data/required_entities >> [java] INFO Initializing ExecutorService 'importExportThreadPool' >> [java] INFO Adding destruction callback singleton for bean >> 'scopedTarget.sessionAttributesOverridesMap' >> [java] WARN Invalid JavaBean property 'userNames' being accessed! >> Ambiguous write methods found next to actually used [public void >> org.jasig.portal.io.PropertiesFilesIsIncludedUser.setUserNames(java.util.Map)]: >> [public void >> org.jasig.portal.io.PropertiesFilesIsIncludedUser.setUserNames(java.util.Set)] >> [java] INFO Scanning for files to Import from: >> /home/tomcat5/uportal/uportal4/uPortal/uportal-war/src/main/data/required_entities >> [java] INFO Found 17 files to Import from: >> /home/tomcat5/uportal/uportal4/uPortal/uportal-war/src/main/data/required_entities >> [java] INFO Importing 7 files of type <entity-type >> script="classpath://org/jasig/portal/io/import-entity-type_v3-2.crn"> >> [java] INFO Looking up bean 'counterStore' in ApplicationContext >> due to context not yet being initialized >> [java] INFO Imported : >> entity-type/org.jasig.portal.services.entityproperties.EntityProperties.entity-type.xml >> [java] INFO Imported : >> entity-type/org.jasig.portal.portlet.om.IPortletDefinition.entity-type.xml >> [java] INFO Imported : >> entity-type/org.jasig.portal.groups.IEntity.entity-type.xml >> [java] INFO Imported : entity-type/java.lang.Object.entity-type.xml >> [java] INFO Imported : >> entity-type/org.jasig.portal.security.IPermissionSet.entity-type.xml >> [java] INFO Imported : >> entity-type/org.jasig.portal.security.IPerson.entity-type.xml >> [java] INFO Imported : >> entity-type/org.jasig.portal.groups.IEntityGroup.entity-type.xml >> [java] INFO Importing 2 files of type >> <{https://source.jasig.org/schemas/uportal/io/stylesheet-descriptor}stylesheet-descriptor >> version="4.0"> >> [java] INFO Imported : >> stylesheet-descriptor/DLMXHTML.stylesheet-descriptor.xml >> [java] INFO Imported : >> stylesheet-descriptor/DLMTabsColumns.stylesheet-descriptor.xml >> [java] INFO Importing 1 files of type >> <{https://source.jasig.org/schemas/uportal/io/user}template-user >> version="4.0"> >> [java] INFO Imported : user/defaultTemplateUser.user.xml >> [java] INFO Importing 2 files of type >> <{https://source.jasig.org/schemas/uportal/io/user}user version="4.0"> >> [java] ERROR Exception while importing file >> [/home/tomcat5/uportal/uportal4/uPortal/uportal-war/src/main/data/required_entities/user/system.user.xml] >> [java] java.util.concurrent.ExecutionException: >> org.springframework.dao.DeadlockLoserDataAccessException: >> PreparedStatementCallback; SQL [INSERT INTO UP_USER(USER_ID, >> USER_DFLT_USR_ID, USER_DFLT_LAY_ID, NEXT_STRUCT_ID, USER_NAME) >> [java] VALUES(?, ?, 1, ?, ?)]; Deadlock found when trying to get >> lock; try restarting transaction; nested exception is >> com.mysql.jdbc.exceptions.MySQLTransactionRollbackException: Deadlock >> found when trying to get lock; try restarting transaction >> [java] at >> java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222) >> [java] at java.util.concurrent.FutureTask.get(FutureTask.java:83) >> [java] at >> org.jasig.portal.io.xml.JaxbPortalDataHandlerService.waitForFutures(JaxbPortalDataHandlerService.java:812) >> [java] at >> org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:402) >> [java] at >> org.jasig.portal.io.xml.IPortalDataHandlerService$importData.call(Unknown >> Source) >> [java] at >> org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:42) >> [java] at >> org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108) >> [java] at >> org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:124) >> [java] at upshell_35149373.run(upshell_35149373.groovy:67) >> [java] at >> groovy.lang.GroovyShell.runScriptOrMainOrTestOrRunnable(GroovyShell.java:266) >> [java] at groovy.lang.GroovyShell.run(GroovyShell.java:229) >> [java] at >> org.jasig.portal.shell.PortalShell.main(PortalShell.java:84) >> [java] Caused by: >> org.springframework.dao.DeadlockLoserDataAccessException: >> PreparedStatementCallback; SQL [INSERT INTO UP_USER(USER_ID, >> USER_DFLT_USR_ID, USER_DFLT_LAY_ID, NEXT_STRUCT_ID, USER_NAME) >> [java] VALUES(?, ?, 1, ?, ?)]; Deadlock found when trying to get >> lock; try restarting transaction; nested exception is >> com.mysql.jdbc.exceptions.MySQLTransactionRollbackException: Deadlock >> found when trying to get lock; try restarting transaction >> [java] at >> org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:265) >> [java] at >> org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) >> [java] at >> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602) >> [java] at >> org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:811) >> [java] at >> org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:867) >> [java] at >> org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:875) >> [java] at >> org.jasig.portal.io.xml.user.UserImporterExporter.importData(UserImporterExporter.java:157) >> [java] at >> org.jasig.portal.io.xml.user.UserImporterExporter.importData(UserImporterExporter.java:60) >> [java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> [java] at >> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) >> [java] at >> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) >> [java] at java.lang.reflect.Method.invoke(Method.java:597) >> [java] at >> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309) >> [java] at >> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183) >> [java] at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) >> [java] at >> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) >> [java] at >> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) >> [java] at >> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202) >> [java] at $Proxy100.importData(Unknown Source) >> [java] at >> org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importOrUpgradeData(JaxbPortalDataHandlerService.java:517) >> [java] at >> org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:480) >> [java] at >> org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:447) >> [java] at >> org.jasig.portal.io.xml.JaxbPortalDataHandlerService$1.call(JaxbPortalDataHandlerService.java:370) >> [java] at >> org.jasig.portal.io.xml.JaxbPortalDataHandlerService$ErrorReportingCallable.call(JaxbPortalDataHandlerService.java:885) >> [java] at >> java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) >> [java] at java.util.concurrent.FutureTask.run(FutureTask.java:138) >> [java] at >> java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) >> [java] at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) >> [java] at java.lang.Thread.run(Thread.java:662) >> [java] Caused by: >> com.mysql.jdbc.exceptions.MySQLTransactionRollbackException: Deadlock >> found when trying to get lock; try restarting transaction >> [java] at >> com.mysql.jdbc.SQLError.createSQLException(SQLError.java:941) >> [java] at >> com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) >> [java] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) >> [java] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) >> [java] at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) >> [java] at >> com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) >> [java] at >> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) >> [java] at >> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) >> [java] at >> com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) >> [java] at >> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) >> [java] at >> org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) >> [java] at >> org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:817) >> [java] at >> org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:1) >> [java] at >> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586) >> [java] ... 26 more >> [java] INFO Imported : user/guest.user.xml >> [java] Exception in thread "main" java.lang.RuntimeException: >> data-import for >> /home/tomcat5/uportal/uportal4/uPortal/uportal-war/src/main/data/required_entities >> and null failed >> [java] at >> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) >> [java] at >> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) >> [java] at >> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) >> [java] at >> java.lang.reflect.Constructor.newInstance(Constructor.java:513) >> [java] at >> org.codehaus.groovy.reflection.CachedConstructor.invoke(CachedConstructor.java:77) >> [java] at >> org.codehaus.groovy.runtime.callsite.ConstructorSite$ConstructorSiteNoUnwrapNoCoerce.callConstructor(ConstructorSite.java:102) >> [java] at >> org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstructor(CallSiteArray.java:54) >> [java] at >> org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:182) >> [java] at >> org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:194) >> [java] at upshell_35149373.run(upshell_35149373.groovy:70) >> [java] at >> groovy.lang.GroovyShell.runScriptOrMainOrTestOrRunnable(GroovyShell.java:266) >> [java] at groovy.lang.GroovyShell.run(GroovyShell.java:229) >> [java] at >> org.jasig.portal.shell.PortalShell.main(PortalShell.java:84) >> [java] Caused by: java.lang.RuntimeException: Halted due to 1 >> failures, see previous exceptions for causes. >> [java] file >> [/home/tomcat5/uportal/uportal4/uPortal/uportal-war/src/main/data/required_entities/user/system.user.xml] >> [java] >> [java] at >> org.jasig.portal.io.xml.JaxbPortalDataHandlerService.waitForFutures(JaxbPortalDataHandlerService.java:859) >> [java] at >> org.jasig.portal.io.xml.JaxbPortalDataHandlerService.importData(JaxbPortalDataHandlerService.java:402) >> [java] at >> org.jasig.portal.io.xml.IPortalDataHandlerService$importData.call(Unknown >> Source) >> [java] at >> org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:42) >> [java] at >> org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108) >> [java] at >> org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:124) >> [java] at upshell_35149373.run(upshell_35149373.groovy:67) >> [java] ... 3 more >> [java] INFO Shutting down ExecutorService 'importExportThreadPool' -- ----------------------------------------- Fabrice Marchon ++41 21 692 22 36 [email protected] Université de Lausanne Centre informatique Quartier UNIL-Sorge Bâtiment Amphimax CH-1015 Lausanne ----------------------------------------- -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/uportal-dev
