Yes indeed

Good day

Le 04/09/2024 à 09:06, 雷咩咩 a écrit :
hi Jacques,


You mean framework\base\config\cache.properties, right?
I was not touching this file.
Just looked into, and found two possible section that 'can comment this out or 
increase for better performance'


Do you mean proceed like this?


Regards,
Yang






原始邮件
发件人:"Jacques Le Roux"< jacques.le.r...@les7arts.com &gt;;

发件时间:2024/9/4 14:36

收件人:"dev"< d...@ofbiz.apache.org &gt;;

主题:Re: ofibz causes system extremely slow after one night


Hi Yang,

Have you looked at cache.properties?

HTH

Jacques

Le 04/09/2024 à 04:48, 雷咩咩 a écrit&nbsp;:
&gt; Hi ofbiz users,
&gt;
&gt;
&gt; I run ofbiz trunk with default configurations(jdk17, local derby) in my 
ubuntu. Within the 1 hour or so after starting it is just working fine(most ui 
response in 1s). But after one night, when I try to access, the server seems to not 
respond, or repond only after very long time(as long as 141s), and what's worse, 
causes my system very slow, even blocking my ssh login.If I run `pkill -f ofbiz` 
then the system is recovered and fast.
&gt; Below is result of `top` command when this happens:
&gt;
&gt;
&gt; &nbsp; &nbsp; PID USER &nbsp; &nbsp; &nbsp;PR &nbsp;NI &nbsp; &nbsp;VIRT &nbsp; &nbsp;RES 
&nbsp; &nbsp;SHR S &nbsp;%CPU &nbsp;%MEM &nbsp; &nbsp; TIME+ COMMAND
&gt; &nbsp; &nbsp; &nbsp;85 root &nbsp; &nbsp; &nbsp;20 &nbsp; 0 &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; 
&nbsp;0 &nbsp; &nbsp; &nbsp;0 S &nbsp; 2.4 &nbsp; 0.0 &nbsp; 4:31.32 kswapd0
&gt; &nbsp; &nbsp;9528 ci &nbsp; &nbsp; &nbsp; &nbsp;20 &nbsp; 0 3188120 386636 &nbsp; &nbsp; 
&nbsp;0 S &nbsp; 1.5 &nbsp;22.6 &nbsp; 9:27.48 java
&gt; &nbsp; 11612 root &nbsp; &nbsp; &nbsp;20 &nbsp; 0 &nbsp;260628 &nbsp;31332 &nbsp; 3144 
D &nbsp; 1.5 &nbsp; 1.8 &nbsp; 5:40.27 unattended-upgr
&gt; &nbsp; 12081 root &nbsp; &nbsp; &nbsp;20 &nbsp; 0 1319708 &nbsp; 9596 &nbsp; &nbsp; 
&nbsp;0 S &nbsp; 1.5 &nbsp; 0.6 &nbsp; 0:19.68 snapd
&gt; &nbsp; &nbsp;9645 ci &nbsp; &nbsp; &nbsp; &nbsp;20 &nbsp; 0 3294024 838056 &nbsp; &nbsp; 
&nbsp;0 S &nbsp; 1.2 &nbsp;48.9 &nbsp; 8:10.07 java
&gt; &nbsp; &nbsp; &nbsp;83 root &nbsp; &nbsp; &nbsp; 0 -20 &nbsp; &nbsp; &nbsp; 0 &nbsp; &nbsp; 
&nbsp;0 &nbsp; &nbsp; &nbsp;0 I &nbsp; 1.0 &nbsp; 0.0 &nbsp; 0:15.96 kworker/0:1H-kblockd
&gt; &nbsp; &nbsp; 992 root &nbsp; &nbsp; &nbsp;20 &nbsp; 0 &nbsp;135468 &nbsp;10004 &nbsp; 
&nbsp; &nbsp;0 D &nbsp; 1.0 &nbsp; 0.6 &nbsp;14:20.39 AliYunDunMonito
&gt; &nbsp; &nbsp; 974 root &nbsp; &nbsp; &nbsp;20 &nbsp; 0 &nbsp; 96968 &nbsp; 2736 &nbsp; 
&nbsp; &nbsp;0 S &nbsp; 0.5 &nbsp; 0.2 &nbsp; 9:06.76 AliYunDun
&gt; &nbsp; &nbsp; 674 root &nbsp; &nbsp; &nbsp;20 &nbsp; 0 &nbsp;685632 &nbsp; 3156 &nbsp; 
&nbsp; &nbsp;0 S &nbsp; 0.2 &nbsp; 0.2 &nbsp; 1:56.29 aliyun-service
&gt; &nbsp; &nbsp; 770 root &nbsp; &nbsp; &nbsp;20 &nbsp; 0 &nbsp; 32216 &nbsp; &nbsp;888 &nbsp; 
&nbsp; &nbsp;0 S &nbsp; 0.2 &nbsp; 0.1 &nbsp; 1:28.89 AliYunDunUpdate
&gt; &nbsp; &nbsp;9498 ci &nbsp; &nbsp; &nbsp; &nbsp;20 &nbsp; 0 2150920 &nbsp;79592 &nbsp; 
&nbsp; &nbsp;0 S &nbsp; 0.2 &nbsp; 4.6 &nbsp; 1:11.93 java
&gt;
&gt;
&gt; This issue happen every day, and many times I had to force reboot my OS to 
solve, and is really painful.
&gt;
&gt;
&gt; Could anyone help analyze what's wrong, is it my OS not meet system 
requirements, or potential bug in ofbiz?
&gt;
&gt;
&gt; I have uploaded my ofbiz logs athttps://leiyang.icu/ofbiz.trunk.slow.log
&gt;
&gt;
&gt; Also copied some of the typical issue log lines:
&gt;
&gt;
&gt; 2024-09-04 09:51:14,281 |jsse-nio-8443-exec-1 |ConfigXMLReader &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; |I| controller loaded: 73.232s, 539 requests, 178 views 
infile:/home/ci/g/ofbiz-framework/applications/product/webapp/catalog/WEB-INF/controller.xml2024-09-04  09:51:14,281 |jsse-nio-8443-exec-9 
|ConfigXMLReader &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |I| controller loaded: 73.04s, 539 requests, 
178 views infile:/home/ci/g/ofbiz-framework/applications/product/webapp/catalog/WEB-INF/controller.xml
&gt; 2024-09-04 09:51:41,583 |jsse-nio-8443-exec-4 |ConfigXMLReader &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; |I| controller loaded: 53.201s, 539 requests, 178 views 
infile:/home/ci/g/ofbiz-framework/applications/product/webapp/catalog/WEB-INF/controller.xml
&gt; 2024-09-04 09:54:47,096 |jsse-nio-8443-exec-4 |ConfigXMLReader &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; |I| controller loaded: 52.922s, 4 requests, 0 views 
infile:/home/ci/g/ofbiz-framework/applications/commonext/webapp/WEB-INF/controller.xml
&gt; 2024-09-04 09:54:48,200 |jsse-nio-8443-exec-4 |ConfigXMLReader &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; |I| controller loaded: 141.023s, 539 requests, 178 views 
infile:/home/ci/g/ofbiz-framework/applications/product/webapp/catalog/WEB-INF/controller.xml
&gt; 2024-09-04 09:54:56,009 |sse-nio-8443-exec-18 |ConfigXMLReader &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; |I| controller lo
&gt; aded: 63.708s, 51 requests, 22 views 
infile:/home/ci/g/ofbiz-framework/framework/common/webcommon/WEB-INF/common-controller.xml
&gt; 2024-09-04 09:55:44,106 |sse-nio-8443-exec-18 |ConfigXMLReader &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; |I| controller loaded: 122.632s, 539 requests, 178 views 
infile:/home/ci/g/ofbiz-framework/applications/product/webapp/catalog/WEB-INF/controller.xml
&gt;
&gt;
&gt; 2024-09-04 09:01:36,440 |sse-nio-8443-exec-12 |TransactionUtil &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp; |W| In getSetRollbackOnlyCause no stack placeholder was in place, 
here is the current location:
&gt; java.lang.Exception: Current Stack Trace
&gt;       at 
org.apache.ofbiz.entity.transaction.TransactionUtil.getSetRollbackOnlyCause(TransactionUtil.java:849)
 [main/:?]
&gt;       at 
org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:265)
 [main/:?]
&gt;
&gt;
&gt;
&gt;
&gt; 2024-09-04 09:01:36,632 |sse-nio-8443-exec-12 |ControlServlet &nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp;|E| Error in request handler:
&gt; org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering 
screen [component://common/widget/CommonScreens.xml#login]: 
org.apache.ofbiz.entity.transaction.GenericTransactionException: Roll back error 
(with no rollbackOnly cause found), could not commit transaction, was rolled back 
instead: java.lang.Exception: Transaction has timed out (Transaction has timed out) 
(Roll back error (with no rollbackOnly cause found), could not commit transaction, 
was rolled back instead: java.lang.Exception: Transaction has timed out 
(Transaction has timed out))
&gt;       at 
org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:176) 
~[main/:?]
&gt;       at 
org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:147) 
~[main/:?]
&gt;
&gt;
&gt;
&gt;
&gt;       at java.lang.Thread.run(Thread.java:840) [?:?]
&gt; Caused by: 
org.apache.ofbiz.entity.transaction.GenericTransactionException: Roll back error 
(with no rollbackOnly cause found), could not commit transaction, was rolled back 
instead: java.lang.Exception: Transaction has timed out (Transaction has timed out)
&gt;       at 
org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:279)
 ~[main/:?]
&gt;       at 
org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:233)
 ~[main/:?]
&gt;       at 
org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:160) 
~[main/:?]
&gt;       ... 41 more
&gt; Caused by: java.lang.Exception: Transaction has timed out
&gt;       at 
org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:266)
 ~[geronimo-transaction-3.1.5.jar:3.1.5]
&gt;       at 
org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:263)
 ~[geronimo-transaction-3.1.5.jar:3.1.5]
&gt;       at 
org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:250)
 ~[main/:?]
&gt;
&gt;
&gt; Caused by: java.sql.SQLTransactionRollbackException: A lock could not be 
obtained within the time requested
&gt;       at 
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source) 
~[derby-10.14.2.0.jar:?]
&gt;       at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown 
Source) ~[derby-10.14.2.0.jar:?]
&gt;
&gt;
&gt;
&gt;
&gt;
&gt; Regards,
&gt; Yang

Reply via email to