Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0007068 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] Y. DBSourceManager | major | have not tried | 2009-01-21 19:58 | 2023-09-22 12:08 | |||
Reporter | shuehner | View Status | public | |||||
Assigned To | marvintm | |||||||
Priority | normal | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | 12166 | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | pi | SCM revision | 12107 | |||||
Merge Request Status | approved | |||||||
Review Assigned To | ||||||||
OBNetwork customer | No | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0007068: update.database fails on postgres when updating accross 12107 | |||||||
Description | Commit 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 Solution | Check 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. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
|
![]() |
|
(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 (viewer) 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 (viewer) 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 (viewer) 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 [^] |
![]() |
|||
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 | OBNetwork customer | => No |
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 | Merge Request Status | => open |
2023-09-15 12:55 | hgbot | Note Added: 0154898 | |
2023-09-19 09:31 | hgbot | Merge Request Status | open => approved |
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 |