Thanks David for the reply. I 'had already done all these setting and tried on Jboss but still result are the same. Now when I am doing testing through Jmeter for concurrent users than it is giving the error related to duplicate key value violates for UserLoginHistory and ServerHit entities. Here is the error logs :
---- exception report ---------------------------------------------------------- Failure in create operation for entity [UserLoginHistory]: org.ofbiz.entity.GenericEntityException: Error while inserting: [Gener icEntity:UserLoginHistory][createdStamp,2010-04-13 11:12:50.609(java.sql.Timestamp)][createdTxStamp,2010-04-13 11:12:50.609(java. sql.Timestamp)][fromDate,2010-04-13 11:12:50.609(java.sql.Timestamp)][lastUpdatedStamp,2010-04-13 11:12:50.609(java.sql.Timestamp )][lastUpdatedTxStamp,2010-04-13 11:12:50.609(java.sql.Timestamp)][partyId,admin(java.lang.String)][successfulLogin,Y(java.lang.S tring)][userLoginId,admin(java.lang.String)][visitId,10049(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.USER_LOGIN_HISTORY (USER_LOGIN_ID, VISIT_ID, FROM_DATE, THRU_DATE, PASSWORD_USED, SUCCESSFUL_LOGIN, LAST_UPDATED_STA MP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, PARTY_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_user_login_history")). Rolling back transaction. Exception: org.ofbiz.entity.GenericEntityException Message: Error while inserting: [GenericEntity:UserLoginHistory][createdStamp,2010-04-13 11:12:50.609(java.sql.Timestamp)][create dTxStamp,2010-04-13 11:12:50.609(java.sql.Timestamp)][fromDate,2010-04-13 11:12:50.609(java.sql.Timestamp)][lastUpdatedStamp,2010 -04-13 11:12:50.609(java.sql.Timestamp)][lastUpdatedTxStamp,2010-04-13 11:12:50.609(java.sql.Timestamp)][partyId,admin(java.lang. String)][successfulLogin,Y(java.lang.String)][userLoginId,admin(java.lang.String)][visitId,10049(java.lang.String)] (SQL Exceptio n while executing the following:INSERT INTO public.USER_LOGIN_HISTORY (USER_LOGIN_ID, VISIT_ID, FROM_DATE, THRU_DATE, PASSWORD_US ED, SUCCESSFUL_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, PARTY_ID) VALUES (?, ?, ?, ?, ? , ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_user_login_history")) ---- cause --------------------------------------------------------------------- Exception: org.ofbiz.entity.GenericDataSourceException Message: SQL Exception while executing the following:INSERT INTO public.USER_LOGIN_HISTORY (USER_LOGIN_ID, VISIT_ID, FROM_DATE, T HRU_DATE, PASSWORD_USED, SUCCESSFUL_LOGIN, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, PARTY_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: duplicate key value violates unique constraint "pk_user_login_history") ---- cause --------------------------------------------------------------------- Exception: org.postgresql.util.PSQLException Message: ERROR: duplicate key value violates unique constraint "pk_user_login_history" ---- stack trace --------------------------------------------------------------- org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "pk_user_login_history" org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062) org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795) org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257) org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479) org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367) org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:321) org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:105) Is there any solution for this ? -----Original Message----- From: David E Jones [mailto:d...@me.com] Sent: Friday, April 09, 2010 10:27 AM To: user@ofbiz.apache.org Subject: Re: OFBiz performance issue. You need to remove the cache timeouts. There are caches for all of the XML widgets that cache it objects that are created from the XML files so no more interpretation is needed in order to execute them. If you have the default timeouts still enabled those will be thrown away every 10 seconds, causing HUGE performance problems. These settings are in the cache.properties file, and you can use the WebTools Cache Management pages to check on the cache settings to make sure they are what you expect (ie NO timeouts for the widget and other XML files, including service defs, etc, etc). Please be sure to read through the sections on caching and logging in the Technical Production Setup Guide that is available on cwiki.apache.org. -David On Apr 8, 2010, at 11:50 PM, Anil Soni wrote: > Dear Users, > > I am doing OFBiz performance testing on JBOSS application server. I've done > all the performance setting on both side application side and database side. > But still results are very poor then I decided to find the root cause for the > problem. For that I've used Java Profiler to monitor performance and test > the time taken to load of ecommerce main page and found that Ofbiz is taking > lots of time in screen / form rendering because every time it parse XML (like > screens / forms/ and minilang service ) that takes lots of time. > > Please refer the below link to check the performance results. > > http://www.screencast.com/t/ZGJjM2QxOGY > I also tried the one thing where I've render the FTL directly in view map > instead of rendering it in screen and it saves my 50 % time. > > So it seems like OFBiz taking lots of time in XML parsing. Is anyone looked > into this issue and what is the solution for that ? > > Any suggestions or reply would be highly appreciated. > > > > Regards, > Anil Soni > Tel : 91-22-6795 4324 > Cell : 91 9930302283 > > > ________________________________ > This Email may contain confidential or privileged information for the > intended recipient (s) If you are not the intended recipient, please do not > use or disseminate the information, notify the sender and delete it from your > system. > > ______________________________________________________________________ ______________________________________________________________________ This Email may contain confidential or privileged information for the intended recipient (s) If you are not the intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system. ______________________________________________________________________
