Hi Vipin,
Since, AFAIK, we did not ask yet and that's pretty needed as this stage, which
version are you using?
Thanks
Jacques
Le 20/12/2019 à 07:53, vipin nirwal a écrit :
Hi Humera,
Thanks for your reply.
I compared both HTTP request and did not find any difference. Seems ok to
me. When i am running concurrent user from jmeter (only 5 threads) and same
time, i am trying to submit order from UI, its taking around 30-40 sec or
even more from UI too.
I logged the queries which are taking longer in postgres and found this
query every time. But when i am doing explain on this query then its very
quickly updating.
2019-12-20 06:41:12.772 UTC [13411] LOG: duration: 96233.642 ms execute
<unnamed>: UPDATE public.PRODUCT_CALCULATED_INFO SET
TOTAL_QUANTITY_ORDERED=$1, TOTAL_TIMES_VIEWED=$2,
AVERAGE_CUSTOMER_RATING=$3, LAST_UPDATED_STAMP=$4,
LAST_UPDATED_TX_STAMP=$5, CREATED_STAMP=$6, CREATED_TX_STAMP=$7 WHERE
PRODUCT_ID=$8
2019-12-20 06:41:12.772 UTC [13411] DETAIL: parameters: $1 = '84.000000',
$2 = NULL, $3 = NULL, $4 = '2019-12-20 06:39:36.537+00', $5 = '2019-12-20
06:39:36.527+00', $6 = '2019-12-18 12:33:35.924+00', $7 = '2019-12-18
12:33:35.901+00', $8 = 'WG-5569'
2019-12-20 06:42:48.667 UTC [12179] LOG: duration: 192255.312 ms execute
<unnamed>: UPDATE public.PRODUCT_CALCULATED_INFO SET
TOTAL_QUANTITY_ORDERED=$1, TOTAL_TIMES_VIEWED=$2,
AVERAGE_CUSTOMER_RATING=$3, LAST_UPDATED_STAMP=$4,
LAST_UPDATED_TX_STAMP=$5, CREATED_STAMP=$6, CREATED_TX_STAMP=$7 WHERE
PRODUCT_ID=$8
2019-12-20 06:42:48.667 UTC [12179] DETAIL: parameters: $1 = '84.000000',
$2 = NULL, $3 = NULL, $4 = '2019-12-20 06:39:36.41+00', $5 = '2019-12-20
06:39:36.403+00', $6 = '2019-12-18 12:33:35.924+00', $7 = '2019-12-18
12:33:35.901+00', $8 = 'WG-5569'
2019-12-20 06:43:36.832 UTC [12180] LOG: duration: 240242.603 ms execute
<unnamed>: UPDATE public.PRODUCT_CALCULATED_INFO SET
TOTAL_QUANTITY_ORDERED=$1, TOTAL_TIMES_VIEWED=$2,
AVERAGE_CUSTOMER_RATING=$3, LAST_UPDATED_STAMP=$4,
LAST_UPDATED_TX_STAMP=$5, CREATED_STAMP=$6, CREATED_TX_STAMP=$7 WHERE
PRODUCT_ID=$8
2019-12-20 06:43:36.832 UTC [12180] DETAIL: parameters: $1 = '84.000000',
$2 = NULL, $3 = NULL, $4 = '2019-12-20 06:39:36.588+00', $5 = '2019-12-20
06:39:36.582+00', $6 = '2019-12-18 12:33:35.924+00', $7 = '2019-12-18
12:33:35.901+00', $8 = 'WG-5569'
BR//
Vipin Nirwal
On Fri, Dec 20, 2019 at 10:38 AM Humera Khan <[email protected]>
wrote:
Hi Vipin,
As per the attached JMeter result, status for the submit_order request is a
warning. There may be an issue related to the cookie or any other request
header. Please compare the HTTP request of JMeter with the request in
browser.
HTH!
Best Regards,
Humera Khan
On Thu, Dec 19, 2019 at 9:55 PM vipin nirwal <[email protected]> wrote:
Hi Jacques,
Thanks for your response.
I tried with out of the box derby DB too. I am trying with only 5
concurrent user but still submit order is giving hard time to me.
Looking at jmeter result, it seems submit order API is running in
sequence. Taking longer time in each submit call. Attached is jmeter
result.
I debug a bit more. CheckOutEvents.createOrder is taking longer time in
execution. Due to this , we are not able to get OrderHeader in
CheckOutHelper.checkExternalPayment method. Thats why i was getting above
error. Is there any other setting i am missing?
PS. If i am trying to submit order in UI, then its not taking more than
10
sec. I tried to increase the transaction time out( you suggested in some
thread , modify TransactionUtil class. Then all order were successful but
again taking more time).
I am trying this, if there will be any other finding, will update.
BR//
Vipin Nirwal
On Thu, Dec 19, 2019 at 6:46 PM Jacques Le Roux <
[email protected]> wrote:
Hi Vipin,
I can see only a reason: an issue to access your OFBiz database. I don't
remember such problems reported earlier. Maybe you are forcing too much
with
Jmeter and you get deadlocks in the DB.
Jacques
Le 18/12/2019 à 06:19, vipin nirwal a écrit :
Hi,
I am facing a weird issue. First submit order is taking longer like
12-20sec . Afterwards each order takes quite longer to submit. If
processing time is being increased more than 1 minutes then all order
start
failing. I am getting below error message for failed order.
<div id="content-messages" class="content-messages errorMessage"
onclick="document.getElementById('content-messages').parentNode.removeChild(this)">
<p>The Following Errors Occurred:</p>
<p>Problems getting order header. Cannot check external
gateways!</p>
</div>
This error is coming from CheckOutEvents.checkExternalPayment method.
Though few orders are submitted successfully.
Please let me know if someone faced this issue or any solution for
this. Is there any
PS. I am using apache jmeter to submit order.
BR//
Vipin Nirwal
--
Thanks & Regards
Vipin Nirwal
