Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025732Openbravo ERPA. Platformpublic2014-02-14 09:282014-03-07 09:33
Reporteregoitz 
Assigned ToAugustoMauch 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
Target Version3.0PR14Q2Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025732: AttributeSetInstanceValueData's selectNextSerNo and updateSerNoSequence methods perform poorly with large transaction volume
DescriptionAttributeSetInstanceValueData's selectNextSerNo and updateSerNoSequence methods perform poorly with large transaction volume
Steps To ReproducePrepare a test

The test essentially does the following:
1 - start 10 threads
2 - each thread attempts to create 10 attribute set instance records at the same time
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 00252863.0PR14Q3 closed AugustoMauch Deadlocks on the AD_SEQUENCE table 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-02-14 09:28egoitzNew Issue
2014-02-14 09:28egoitzAssigned To => AugustoMauch
2014-02-14 09:28egoitzModules => Core
2014-02-14 09:28egoitzResolution time => 1392505200
2014-02-14 09:28egoitzTriggers an Emergency Pack => No
2014-02-14 09:33egoitzTag Attached: Performance
2014-02-14 09:39alostaleRelationship addedrelated to 0025286
2014-02-18 08:22alostaleNote Added: 0064310
2014-02-18 08:22alostaleStatusnew => closed
2014-02-18 08:22alostaleResolutionopen => no change required
2014-03-04 08:59egoitzStatusclosed => new
2014-03-04 08:59egoitzResolutionno change required => open
2014-03-05 13:03alostaleTarget Version => PR14Q2
2014-03-06 14:12hgbotCheckin
2014-03-06 14:12hgbotNote Added: 0064914
2014-03-07 05:25hudsonbotCheckin
2014-03-07 05:25hudsonbotNote Added: 0064946
2014-03-07 09:33alostaleNote Added: 0064954
2014-03-07 09:33alostaleStatusnew => closed
2014-03-07 09:33alostaleResolutionopen => no change required

Notes
(0064310)
alostale   
2014-02-18 08:22   
See note in issue 0025286
(0064914)
hgbot   
2014-03-06 14:12   
Repository: erp/devel/pi
Changeset: 2e659cd9b4e53ebf8420931963e65b08862dad64
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Mar 06 14:11:47 2014 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/2e659cd9b4e53ebf8420931963e65b08862dad64 [^]

related to issue 25732: attr set instance val serial and lot contention

  Created methods for getting serial and lots numbers so they can be overwritten
  to behave in a different way, ie. in making them as autonomous transactions, this
  is not implemented in core as it would change current transactionality: the whole
  attribute set is created within a transaction.

---
M src/org/openbravo/erpCommon/utility/AttributeSetInstanceValue.java
---
(0064946)
hudsonbot   
2014-03-07 05:25   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/9364dd72aca6 [^]
Maturity status: Test
(0064954)
alostale   
2014-03-07 09:33   
Created methods for getting serial and lots numbers so they can be overwritten to behave in a different way, ie. in making them as autonomous transactions, this is not implemented in core as it would change current transactionality: the whole attribute set is created within a transaction.