For now have increased value for "innodb_lock_wait_timeout" from 50 to 300. http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html#sysvar_innodb_lock_wait_timeout
On Thu, May 3, 2012 at 7:54 AM, varun bhansaly <[email protected]> wrote: > Hi, > I'm using ofbiz release10.04@1072382 with MySQL database server (with > default settings). > > Of late I have been observing lots of 'lock wait time out' exceptions in > the logs primarily while the system is trying to update entity OrderHeader. > > If anyone has any suggestions please do share. > > Below is the portion of the exception trace - > > 2012-05-01 18:51:34,865 [ERROR] SQL Exception while executing the > following: UPDATE ORDER_HEADER SET ORDER_TYPE_ID=?, ORDER_NAME=?, > EXTERNAL_ID=?, SALES_CHANNEL_ENUM_ID=?, ORDER_DATE=?, PRIORITY=?, > ENTRY_DATE=?, PICK_SHEET_PRINTED_DATE=?, VISIT_ID=?, STATUS_ID=?, > CREATED_BY=?, FIRST_ATTEMPT_ORDER_ID=?, CURRENCY_UOM=?, SYNC_STATUS_ID=?, > BILLING_ACCOUNT_ID=?, ORIGIN_FACILITY_ID=?, WEB_SITE_ID=?, > PRODUCT_STORE_ID=?, TERMINAL_ID=?, TRANSACTION_ID=?, > AUTO_ORDER_SHOPPING_LIST_ID=?, NEEDS_INVENTORY_ISSUANCE=?, IS_RUSH_ORDER=?, > INTERNAL_CODE=?, REMAINING_SUB_TOTAL=?, GRAND_TOTAL=?, IS_VIEWED=?, > LAST_UPDATED_STAMP=?, LAST_UPDATED_TX_STAMP=?, CREATED_STAMP=?, > CREATED_TX_STAMP=? WHERE ORDER_ID=? > 2012-05-01 18:51:34,867 [ERROR] Error while updating > [GenericEntity:OrderHeader][autoOrderShoppingListId,null()][billingAccountId,null()][createdBy,admin(java.lang.String)][createdStamp,2012-05-01 > 18:48:57.0(java.sql.Timestamp)][createdTxStamp,2012-05-01 > 18:48:57.0(java.sql.Timestamp)][currencyUom,USD(java.lang.String)][entryDate,2012-05-01 > 18:48:57.0(java.sql.Timestamp)][externalId,null()][firstAttemptOrderId,null()][grandTotal,72.00(java.math.BigDecimal)][internalCode,null()][isRushOrder,null()][isViewed,null()][lastUpdatedStamp,2012-05-01 > 18:50:43.297(java.sql.Timestamp)][lastUpdatedTxStamp,2012-05-01 > 18:50:42.078(java.sql.Timestamp)][needsInventoryIssuance,null()][orderDate,2012-05-01 > 18:48:57.0(java.sql.Timestamp)][orderId,SE11510(java.lang.String)][orderName,Test > Order(java.lang.String)][orderTypeId,SALES_ORDER(java.lang.String)][originFacilityId,null()][pickSheetPrintedDate,null()][priority,2(java.lang.String)][productStoreId,9000(java.lang.String)][remainingSubTotal,72.00(java.math.BigDecimal)][salesChannelEnumId,WEB_SALES_CHANNEL(java.lang.String)][statusId,ORDER_COMPLETED(java.lang.String)][syncStatusId,null()][terminalId,null()][transactionId,null()][visitId,5171(java.lang.String)][webSiteId,OrderEntry(java.lang.String)] > 2012-05-01 18:51:34,869 [ERROR] > ---- exception report > ---------------------------------------------------------- > Failure in store operation for entity [OrderHeader]: > org.ofbiz.entity.GenericEntityException: Error while updating OrderHeader > (SQL Exception: (Lock wait timeout exceeded; try restarting transaction)). > Rolling back transaction. > Exception: org.ofbiz.entity.GenericEntityException > Message: Error while updating OrderHeader (SQL Exception: (Lock wait > timeout exceeded; try restarting transaction)) > ---- cause > --------------------------------------------------------------------- > Exception: org.ofbiz.entity.GenericDataSourceException > Message: SQL Exception: (Lock wait timeout exceeded; try restarting > transaction) > ---- cause > --------------------------------------------------------------------- > Exception: java.sql.SQLException > Message: Lock wait timeout exceeded; try restarting transaction > > -- > Regards, > Varun Bhansaly > -- Regards, Varun Bhansaly
