Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0029143
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] A. Platformmajorhave not tried2015-03-04 12:302015-04-01 08:31
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PriorityurgentResolutionfixedFixed in Version3.0PR15Q1.2
StatusclosedFix in branchFixed in SCM revision79ff7ba47efb
ProjectionnoneETAnoneTarget Version3.0PR15Q1.2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToAugustoMauch
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0029143: PR14Q3 -> PR14Q4 update can fail activating FKs

DescriptionUpdating Openbravo from PR14Q3 (or lower) to PR14Q4 (or higher) can result in a constraint not being possible to be activated.
Steps To Reproduce-Install PR14Q3
-Open Costing Rules window
-Create a new Record
-Execute Validate Costing Rule process
-Update to PR14Q4
   -> This error appears:

     [java] 87780 WARN - SQL Command failed with: ERROR: insert or update on table "ad_process_run" violates foreign key constraint "ad_process_run_ad_process_requ"
     [java] Detail: Key (ad_process_request_id)=(A4A686C15C074C80982C31D6943F46AB) is not present in table "ad_process_request".
     [java] 87785 WARN - -- END
     [java] ALTER TABLE AD_PROCESS_RUN
     [java] ADD CONSTRAINT AD_PROCESS_RUN_AD_PROCESS_REQU FOREIGN KEY (AD_PROCESS_REQUEST_ID) REFERENCES AD_PROCESS_REQUEST (AD_PROCESS_REQUEST_ID) ON DELETE CASCADE
TagsApproved
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0029127 closedalostale PR14Q3 -> PR14Q4 update can fail activating FKs 

-  Notes
(0075205)
hgbot (developer)
2015-03-05 16:45

Repository: erp/backports/3.0PR15Q1.2
Changeset: 79ff7ba47efbc3c5f1f81d0ea77da9962f6593e3
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Mar 05 14:18:04 2015 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR15Q1.2/rev/79ff7ba47efbc3c5f1f81d0ea77da9962f6593e3 [^]

fixed bug 29143: PR14Q3 -> PR14Q4 update can fail activating FKs

  Added build validation to prevent this error.

  This build validation prevents issue 0029127 by deleting rows in ad_process_run for executions of
  CostingRuleProcess which is removed but due to issue 0029142 update database process is not able
  to properly handle.

  It is a temporary workaround and it should be removed one 0029142 is resolved.

  It should have been implemented as ModuleScript because it is repairing data, but because
  ad_process_run and ad_process_request tables are recreated when updating from PR14Q3 to PR14Q4,
  module script would be executed without indexes nor DB statistics which might result, depending
  on the data volumes in these table, in slow executions due to poor query execution plans.
  Exceptionally, implementing it as build validation to be executed before actual database update
  allowing better plans.

---
A src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/RemoveCostingRuleProcessExecutions.class
A src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/RemoveCostingRuleProcessExecutionsData.class
A src-util/buildvalidation/src/org/openbravo/buildvalidation/RemoveCostingRuleProcessExecutions.java
A src-util/buildvalidation/src/org/openbravo/buildvalidation/RemoveCostingRuleProcessExecutions_data.xsql
---
(0075307)
AugustoMauch (manager)
2015-03-09 12:07

Code reviewed and verified in [1]@79ff7ba47efb

[1] https://code.openbravo.com/erp/backports/3.0PR15Q1.2/ [^]
(0076198)
hgbot (developer)
2015-04-01 08:05

Repository: erp/backports/3.0PR15Q2
Changeset: 79ff7ba47efbc3c5f1f81d0ea77da9962f6593e3
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Mar 05 14:18:04 2015 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR15Q2/rev/79ff7ba47efbc3c5f1f81d0ea77da9962f6593e3 [^]

fixed bug 29143: PR14Q3 -> PR14Q4 update can fail activating FKs

  Added build validation to prevent this error.

  This build validation prevents issue 0029127 by deleting rows in ad_process_run for executions of
  CostingRuleProcess which is removed but due to issue 0029142 update database process is not able
  to properly handle.

  It is a temporary workaround and it should be removed one 0029142 is resolved.

  It should have been implemented as ModuleScript because it is repairing data, but because
  ad_process_run and ad_process_request tables are recreated when updating from PR14Q3 to PR14Q4,
  module script would be executed without indexes nor DB statistics which might result, depending
  on the data volumes in these table, in slow executions due to poor query execution plans.
  Exceptionally, implementing it as build validation to be executed before actual database update
  allowing better plans.

---
A src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/RemoveCostingRuleProcessExecutions.class
A src-util/buildvalidation/build/classes/org/openbravo/buildvalidation/RemoveCostingRuleProcessExecutionsData.class
A src-util/buildvalidation/src/org/openbravo/buildvalidation/RemoveCostingRuleProcessExecutions.java
A src-util/buildvalidation/src/org/openbravo/buildvalidation/RemoveCostingRuleProcessExecutions_data.xsql
---
(0076275)
priyam (administrator)
2015-04-01 08:31

closed again, as the status changed due the merge tag of 3.0PR15Q1.2 to backports/3.0PR15Q2

- Issue History
Date Modified Username Field Change
2015-03-05 13:59 alostale Type defect => backport
2015-03-05 13:59 alostale Target Version => 3.0PR15Q1.2
2015-03-05 14:06 alostale Review Assigned To => AugustoMauch
2015-03-05 16:26 dmitry_mezentsev Tag Attached: Approved
2015-03-05 16:45 hgbot Checkin
2015-03-05 16:45 hgbot Note Added: 0075205
2015-03-05 16:45 hgbot Status scheduled => resolved
2015-03-05 16:45 hgbot Resolution open => fixed
2015-03-05 16:45 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR15Q1.2/rev/79ff7ba47efbc3c5f1f81d0ea77da9962f6593e3 [^]
2015-03-09 12:07 AugustoMauch Note Added: 0075307
2015-03-09 12:07 AugustoMauch Status resolved => closed
2015-03-09 12:07 AugustoMauch Fixed in Version => 3.0PR15Q1.2
2015-04-01 08:05 hgbot Checkin
2015-04-01 08:05 hgbot Note Added: 0076198
2015-04-01 08:05 hgbot Status closed => resolved
2015-04-01 08:05 hgbot Fixed in SCM revision http://code.openbravo.com/erp/backports/3.0PR15Q1.2/rev/79ff7ba47efbc3c5f1f81d0ea77da9962f6593e3 [^] => http://code.openbravo.com/erp/backports/3.0PR15Q2/rev/79ff7ba47efbc3c5f1f81d0ea77da9962f6593e3 [^]
2015-04-01 08:31 priyam Status resolved => closed
2015-04-01 08:31 priyam Note Added: 0076275


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker