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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0029923
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2015-05-19 09:442015-06-04 15:45
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PriorityimmediateResolutionfixedFixed in Version3.0PR15Q3
StatusclosedFix in branchFixed in SCM revision76e6524fe91c
ProjectionnoneETAnoneTarget Version3.0PR15Q3
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Tomarvintm
Web browser
ModulesCore
Regression levelAutomated tests
Regression date2015-04-28
Regression introduced in releasepi
Regression introduced by commithttps://code.openbravo.com/erp/devel/pi/rev/f8c18a0c0a00d9dc01482bb1ca5b72d2c68c1fe3 [^]
Triggers an Emergency PackNo
Summary

0029923: upgrading from 2.50 to pi shows errors in update.database log

DescriptionWhen upgrading from 2.50 to current pi, there are some errors in update.database log.
Steps To ReproduceInstall 2.50:
 hg clone pi
 hg up -C 2.50MP24
 ant install.source

Prepare to upgrade (fix some data):
  psql -c 'delete from C_BP_CUSTOMER_ACCT where C_BP_CUSTOMER_ACCT_id in ('\''1000020'\'', '\''1000019'\'', '\''1000024'\'', '\''1000022'\'', '\''1000021'\'');'

Upgrade
  ant smartbuild -Dlocal=no

These errors appear in the log:
     [java] 124879 INFO - Batch statement failed. Rolling back and retrying all the statements in a non-batched connection.
     [java] 124913 WARN - SQL Command failed with: ERROR: constraint "ad_createfact_template_ad_tabl" of relation "ad_createfact_template" does not exist
     [java] 124918 WARN - -- END
     [java] ALTER TABLE AD_CREATEFACT_TEMPLATE
     [java] DROP CONSTRAINT AD_CREATEFACT_TEMPLATE_AD_TABL
     [java] 125102 WARN - SQL Command failed with: ERROR: constraint "ad_process_request_ad_process" of relation "ad_process_request" does not exist
     [java] 125129 WARN - -- END
     [java] ALTER TABLE AD_PROCESS_REQUEST
     [java] DROP CONSTRAINT AD_PROCESS_REQUEST_AD_PROCESS
     [java] 125259 WARN - SQL Command failed with: ERROR: constraint "fact_acct_ad_table" of relation "fact_acct" does not exist
     [java] 125274 WARN - -- END
     [java] ALTER TABLE FACT_ACCT
     [java] DROP CONSTRAINT FACT_ACCT_AD_TABLE

You can see this error in CI: https://ci.openbravo.com/job/up-2.50topi-pgsql/74/ [^]
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
caused by feature request 0029270 closedalostale prevent table recreation in update.database 
related to defect 00299273.0PR15Q3 closedalostale export database after upgrade from 2.50 results in formal changes 
related to defect 00300163.0PR15Q3 closedalostale upgrading from 2.50 to pi some FKs are missing 

-  Notes
(0077754)
hgbot (developer)
2015-05-26 12:39

 Repository: erp/devel/dbsm-main
Changeset: b5dc42ee72ef7a4608b33cd76295cbc61d3ccca0
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue May 26 12:38:57 2015 +0200
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/b5dc42ee72ef7a4608b33cd76295cbc61d3ccca0 [^]

related to bug 29923: upgrading from 2.50 to pi shows errors in update.database

  added test case

---
M src-test/src/org/openbravo/dbsm/test/model/recreation/OtherRecreations.java
A src-test/model/recreation/FK4.xml
A src-test/model/recreation/FK41.xml
---
(0077757)
hgbot (developer)
2015-05-26 13:51

 Repository: erp/devel/dbsm-main
Changeset: 94360b8e364e9d9fe1513df418366970a71a66f0
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue May 26 12:52:33 2015 +0200
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/94360b8e364e9d9fe1513df418366970a71a66f0 [^]

fixed bug 29923: upgrading from 2.50 to pi shows errors in update.database

  This error ocurred when a non AD table with FKs to an AD table was recreated.

  In this situation FKs to AD table were tried to be dropped twice:
   - As part of the table recreation
   - As part of standard FK drop from non AD to AD tables

  The fix consists on not dropping FKs from non AD to AD tables for already recreated
  ones

---
M src/org/apache/ddlutils/platform/PlatformImplBase.java
---
(0077758)
hgbot (developer)
2015-05-26 13:52

 Repository: erp/devel/pi
Changeset: 76e6524fe91c3df5e6068e5c3726616ff94e2123
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Tue May 26 13:51:31 2015 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/76e6524fe91c3df5e6068e5c3726616ff94e2123 [^]

fixed bug 29923: upgrading from 2.50 to pi shows errors in update.database

  This error ocurred when a non AD table with FKs to an AD table was recreated.

  In this situation FKs to AD table were tried to be dropped twice:
   - As part of the table recreation
   - As part of standard FK drop from non AD to AD tables

  The fix consists on not dropping FKs from non AD to AD tables for already recreated
  ones

---
M src-db/database/lib/dbsourcemanager.jar
---
(0077780)
hudsonbot (developer)
2015-05-27 00:39

 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/2ac0a8fe23d2 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2015-05-19 09:44 alostale New Issue
2015-05-19 09:44 alostale Assigned To => platform
2015-05-19 09:44 alostale Modules => Core
2015-05-19 09:44 alostale Regression level => Coding ( Testing )
2015-05-19 09:44 alostale Regression date => 2015-04-28
2015-05-19 09:44 alostale Regression introduced in release => pi
2015-05-19 09:44 alostale Regression introduced by commit => https://code.openbravo.com/erp/devel/pi/rev/f8c18a0c0a00d9dc01482bb1ca5b72d2c68c1fe3 [^]
2015-05-19 09:44 alostale Triggers an Emergency Pack => No
2015-05-19 09:45 alostale Regression level Coding ( Testing ) => Automated tests
2015-05-19 09:45 alostale Relationship added caused by 0029270
2015-05-19 09:50 alostale Steps to Reproduce Updated View Revisions
2015-05-19 10:16 alostale Relationship added related to 0029927
2015-05-19 10:17 alostale Steps to Reproduce Updated View Revisions
2015-05-19 10:18 alostale Steps to Reproduce Updated View Revisions
2015-05-19 12:39 shuehner Issue Monitored: shuehner
2015-05-26 12:39 hgbot Checkin
2015-05-26 12:39 hgbot Note Added: 0077754
2015-05-26 12:46 alostale Review Assigned To => marvintm
2015-05-26 12:46 alostale Status new => scheduled
2015-05-26 13:51 hgbot Checkin
2015-05-26 13:51 hgbot Note Added: 0077757
2015-05-26 13:51 hgbot Status scheduled => resolved
2015-05-26 13:51 hgbot Resolution open => fixed
2015-05-26 13:51 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/dbsm-main/rev/94360b8e364e9d9fe1513df418366970a71a66f0 [^]
2015-05-26 13:52 hgbot Checkin
2015-05-26 13:52 hgbot Note Added: 0077758
2015-05-26 13:52 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/dbsm-main/rev/94360b8e364e9d9fe1513df418366970a71a66f0 [^] => http://code.openbravo.com/erp/devel/pi/rev/76e6524fe91c3df5e6068e5c3726616ff94e2123 [^]
2015-05-26 15:08 alostale Relationship added related to 0030016
2015-05-26 15:08 alostale Assigned To platform => alostale
2015-05-27 00:39 hudsonbot Checkin
2015-05-27 00:39 hudsonbot Note Added: 0077780
2015-06-04 15:45 marvintm Status resolved => closed
2015-06-04 15:45 marvintm Fixed in Version => 3.0PR15Q3

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker