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 > > > -- Thanks & Regards Vipin Nirwal
