Bad news is the updated config only extended life span of ofbiz websites(and
also my system) to 2 days.
today i see same issue again. only restarting os can solve.
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))
at
org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:176)
~[main/:?]
...
at
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
[tomcat-util-9.0.91.jar:9.0.91]
at java.lang.Thread.run(Thread.java:840) [?:?]
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)
at
org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:279)
~[main/:?]
at
org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:233)
~[main/:?]
at
org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:160)
~[main/:?]
... 40 more
Caused by: java.lang.Exception: Transaction has timed out
at
org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:266)
~[geronimo-transaction-3.1.5.jar:3.1.5]
at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:263)
~[geronimo-transaction-3.1.5.jar:3.1.5]
at
org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:250)
~[main/:?]
at
org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:233)
~[main/:?]
at
org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:160)
~[main/:?]
... 40 more
Original Email
From:"雷咩咩"< 675686...@qq.com >;
Sent Time:2024/9/5 7:47
To:"ofbiz user"< u...@ofbiz.apache.org >;"dev"< dev@ofbiz.apache.org >;
Subject:回复：Re: 回复：Re: ofibz causes system extremely slow after one night
Good news is under this config ofbiz endured last night, will monitor more few
days.
原始邮件
发件人："Jacques Le Roux"< jacques.le.r...@les7arts.com >;
发件时间：2024/9/4 15:36
收件人："dev"< dev@ofbiz.apache.org >;"雷咩咩"< 675686...@qq.com.INVALID >;"ofbiz
user"< u...@ofbiz.apache.org >;
主题：Re: 回复：Re: ofibz causes system extremely slow after one night
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 >;
>
> 发件时间：2024/9/4 14:36
>
> 收件人："dev"< dev@ofbiz.apache.org >;
>
> 主题：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 :
> > Hi ofbiz users,
> >
> >
> > 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.
> > Below is result of `top` command when this happens:
> >
> >
> > PID USER PR NI VIRT RES
SHR S %CPU %MEM TIME+ COMMAND
> > 85 root 20 0 0
0 0 S 2.4 0.0 4:31.32 kswapd0
> > 9528 ci 20 0 3188120 386636
0 S 1.5 22.6 9:27.48 java
> > 11612 root 20 0 260628 31332
3144 D 1.5 1.8 5:40.27 unattended-upgr
> > 12081 root 20 0 1319708 9596
0 S 1.5 0.6 0:19.68 snapd
> > 9645 ci 20 0 3294024 838056
0 S 1.2 48.9 8:10.07 java
> > 83 root 0 -20 0
0 0 I 1.0 0.0 0:15.96 kworker/0:1H-kblockd
> > 992 root 20 0 135468 10004
0 D 1.0 0.6 14:20.39 AliYunDunMonito
> > 974 root 20 0 96968 2736
0 S 0.5 0.2 9:06.76 AliYunDun
> > 674 root 20 0 685632 3156
0 S 0.2 0.2 1:56.29 aliyun-service
> > 770 root 20 0 32216 888
0 S 0.2 0.1 1:28.89 AliYunDunUpdate
> > 9498 ci 20 0 2150920 79592
0 S 0.2 4.6 1:11.93 java
> >
> >
> > This issue happen every day, and many times I had to force reboot my
OS to solve, and is really painful.
> >
> >
> > Could anyone help analyze what's wrong, is it my OS not meet system
requirements, or potential bug in ofbiz?
> >
> >
> > I have uploaded my ofbiz logs
athttps://leiyang.icu/ofbiz.trunk.slow.log
> >
> >
> > Also copied some of the typical issue log lines:
> >
> >
> > 2024-09-04 09:51:14,281 |jsse-nio-8443-exec-1 |ConfigXMLReader
|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 |I| controller loaded: 73.04s, 539 requests, 178
views infile:/home/ci/g/ofbiz-framework/applications/product/webapp/catalog/WEB-INF/controller.xml
> > 2024-09-04 09:51:41,583 |jsse-nio-8443-exec-4 |ConfigXMLReader
|I| controller loaded: 53.201s, 539 requests, 178 views
infile:/home/ci/g/ofbiz-framework/applications/product/webapp/catalog/WEB-INF/controller.xml
> > 2024-09-04 09:54:47,096 |jsse-nio-8443-exec-4 |ConfigXMLReader
|I| controller loaded: 52.922s, 4 requests, 0 views
infile:/home/ci/g/ofbiz-framework/applications/commonext/webapp/WEB-INF/controller.xml
> > 2024-09-04 09:54:48,200 |jsse-nio-8443-exec-4 |ConfigXMLReader
|I| controller loaded: 141.023s, 539 requests, 178 views
infile:/home/ci/g/ofbiz-framework/applications/product/webapp/catalog/WEB-INF/controller.xml
> > 2024-09-04 09:54:56,009 |sse-nio-8443-exec-18 |ConfigXMLReader
|I| controller lo
> > aded: 63.708s, 51 requests, 22 views
infile:/home/ci/g/ofbiz-framework/framework/common/webcommon/WEB-INF/common-controller.xml
> > 2024-09-04 09:55:44,106 |sse-nio-8443-exec-18 |ConfigXMLReader
|I| controller loaded: 122.632s, 539 requests, 178 views
infile:/home/ci/g/ofbiz-framework/applications/product/webapp/catalog/WEB-INF/controller.xml
> >
> >
> > 2024-09-04 09:01:36,440 |sse-nio-8443-exec-12 |TransactionUtil
|W| In getSetRollbackOnlyCause no stack placeholder was in place, here
is the current location:
> > java.lang.Exception: Current Stack Trace
> > at
org.apache.ofbiz.entity.transaction.TransactionUtil.getSetRollbackOnlyCause(TransactionUtil.java:849)
[main/:?]
> > at
org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:265)
[main/:?]
> >
> >
> >
> >
> > 2024-09-04 09:01:36,632 |sse-nio-8443-exec-12 |ControlServlet
|E| Error in request handler:
> > 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))
> > at
org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:176)
~[main/:?]
> > at
org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:147)
~[main/:?]
> >
> >
> >
> >
> > at java.lang.Thread.run(Thread.java:840) [?:?]
> > 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)
> > at
org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:279)
~[main/:?]
> > at
org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:233)
~[main/:?]
> > at
org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:160)
~[main/:?]
> > ... 41 more
> > Caused by: java.lang.Exception: Transaction has timed out
> > at
org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:266)
~[geronimo-transaction-3.1.5.jar:3.1.5]
> > at
org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:263)
~[geronimo-transaction-3.1.5.jar:3.1.5]
> > at
org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:250)
~[main/:?]
> >
> >
> > Caused by: java.sql.SQLTransactionRollbackException: A lock could not
be obtained within the time requested
> > at
org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)
~[derby-10.14.2.0.jar:?]
> > at
org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown Source)
~[derby-10.14.2.0.jar:?]
> >
> >
> >
> >
> >
> > Regards,
> > Yang
