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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0007068
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Y. DBSourceManagermajorhave not tried2009-01-21 19:582023-09-22 12:08
ReportershuehnerView Statuspublic 
Assigned Tomarvintm 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision12166
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision12107 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0007068: update.database fails on postgres when updating accross 12107

DescriptionCommit 12107 did remove the AD_TAB entry for the tab with the name 'Period Control' and in the same commit add a new record for a tab with the same name 'Period Control' but a different uuid.
When updating postgres shows the error message:

Executed 414 SQL command(s) with 0 error(s)
Model update complete.
Disabling foreign keys
Executed 0 SQL command(s) with 0 error(s)
Disabling triggers
Executed 408 SQL command(s) with 0 error(s)
Updating database data...
Error while inserting into the database: ERROR: duplicate key value violates unique constraint "ad_tab_window_name_unique"
[alterdatabasedataall] org.apache.ddlutils.DatabaseOperationException: Error while inserting into the database: ERROR: duplicate key value violates unique constraint "ad_tab_window_name_unique"
[alterdatabasedataall] at org.apache.ddlutils.platform.PlatformImplBase.insert(PlatformImplBase.java:1557)
Proposed SolutionCheck ordering of statements in update.database
if not solvable in dbsm revert 12107 and commit it in two steps and advice all developers about the limitation.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0012490)
shuehner (administrator)
2009-01-21 20:12

As a workaround a "delete from ad_tab where name = 'Period Control' and update.database afterwards does work for me.

I suppose that dbsm does first try to insert the new Ad_tab entry and does delete the old on in a different commit afterwards.
(0012523)
svnbot (reporter)
2009-01-22 12:45

Repository: dbsourcemanager
Revision: 214
Author: marvintm
Date: 2009-01-22 12:45:52 +0100 (Thu, 22 Jan 2009)

Fixed issue 7068. Now data changes are ordered before being executed (RemoveRowChanges come first, then ColumnDataChanges, then finally AddRowChanges)

---
U trunk/src/org/apache/ddlutils/alteration/DataComparator.java
---

https://dev.openbravo.com/websvn/dbsourcemanager/?rev=214&sc=1 [^]
(0012524)
svnbot (reporter)
2009-01-22 12:46

Repository: openbravo
Revision: 12153
Author: marvintm
Date: 2009-01-22 12:46:14 +0100 (Thu, 22 Jan 2009)

Fixed issue 7068. Now data changes are ordered before being executed (RemoveRowChanges come first, then ColumnDataChanges, then finally AddRowChanges)

---
U trunk/src-db/database/lib/dbsourcemanager.jar
---

https://dev.openbravo.com/websvn/openbravo/?rev=12153&sc=1 [^]
(0012539)
svnbot (reporter)
2009-01-22 19:18

Repository: openbravo
Revision: 12166
Author: marvintm
Date: 2009-01-22 19:18:28 +0100 (Thu, 22 Jan 2009)

Hopefully finally fixed the issue 7068.

---
U trunk/src-db/database/lib/dbsourcemanager.jar
---

https://dev.openbravo.com/websvn/openbravo/?rev=12166&sc=1 [^]

- Issue History
Date Modified Username Field Change
2009-01-21 19:58 shuehner New Issue
2009-01-21 19:58 shuehner Assigned To => marvintm
2009-01-21 19:58 shuehner sf_bug_id 0 => 2526785
2009-01-21 19:58 shuehner Regression testing => No
2009-01-21 20:12 shuehner Note Added: 0012490
2009-01-22 12:45 svnbot Checkin
2009-01-22 12:45 svnbot Note Added: 0012523
2009-01-22 12:45 svnbot Status new => resolved
2009-01-22 12:45 svnbot Resolution open => fixed
2009-01-22 12:45 svnbot svn_revision => 214
2009-01-22 12:46 svnbot Checkin
2009-01-22 12:46 svnbot Note Added: 0012524
2009-01-22 12:46 svnbot svn_revision 214 => 12153
2009-01-22 19:18 svnbot Checkin
2009-01-22 19:18 svnbot Note Added: 0012539
2009-01-22 19:18 svnbot svn_revision 12153 => 12166
2009-04-21 11:05 psarobe Status resolved => closed
2023-09-15 12:55 hgbot Note Added: 0154898
2023-09-21 12:05 hgbot Note Added: 0155092
2023-09-21 12:05 hgbot Note Added: 0155097
2023-09-21 13:12 hgbot Note Added: 0155105
2023-09-22 08:40 igor_trebol Note Deleted: 0155105
2023-09-22 08:40 igor_trebol Note Deleted: 0155097
2023-09-22 08:40 igor_trebol Note Deleted: 0155092
2023-09-22 08:40 igor_trebol Note Deleted: 0154898
2023-09-22 12:08 hgbot Note Added: 0155174
2023-09-29 10:57 igor_trebol Note Deleted: 0155174


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker