You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Anil Soni <An...@lntinfotech.com> on 2010/04/09 06:50:23 UTC
OFBiz performance issue.
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.
______________________________________________________________________
Re: OFBiz performance issue.
Posted by David E Jones <de...@me.com>.
If you made the change and results are still the same then the change probably didn't work. Did you check the WebTools cache management page to see if the timeouts were gone?
This isn't rocket science, but be careful when you're doing custom deployments (like with JBoss) because the classpath may not be what you think it is...
-David
On Apr 13, 2010, at 12:55 AM, Anil Soni wrote:
> 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:dejc@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.
>
> ______________________________________________________________________
RE: OFBiz performance issue.
Posted by Anil Soni <An...@lntinfotech.com>.
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:dejc@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.
______________________________________________________________________
Re: OFBiz performance issue.
Posted by Jeroen van der Wal <jv...@stromboli.it>.
You can find the document here:
http://cwiki.apache.org/confluence/display/OFBTECH/Apache+OFBiz+Technical+Production+Setup+Guide#ApacheOFBizTechnicalProductionSetupGuide-CacheSettings
--
Jeroen
On Fri, Apr 9, 2010 at 6:56 AM, David E Jones <de...@me.com> wrote:
>
> 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.
>>
>> ______________________________________________________________________
>
>
Re: OFBiz performance issue.
Posted by David E Jones <de...@me.com>.
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.
>
> ______________________________________________________________________