Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0016422Openbravo ERPY. DBSourceManagerpublic2011-03-22 14:382011-06-10 13:20
Reportermarvintm 
Assigned Tomarvintm 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version3.0RC5 
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
Summary0016422: Local changes detected when a database is exported with pg_dump and imported again
DescriptionWhen a database is exported and imported again with pg_dump/pg_restore, the ad_db_modified function finds changes (which do not exist) in the database structure.

The problem happens because PostsgreSQL adds some characters ('()' and '[]') to the database views and checks. Then, the calculated mp5 is different, and therefore, changes are detected.
Steps To ReproduceInstall the rc5 virtual appliance, and verify that when you try to install a module, pack, or Core obx, changes are detected in the database.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to backport 0016429 closed marvintm Local changes detected when a database is exported with pg_dump and imported again 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-03-22 14:38marvintmNew Issue
2011-03-22 14:38marvintmAssigned To => marvintm
2011-03-22 14:38marvintmModules => Core
2011-03-22 15:10hgbotCheckin
2011-03-22 15:10hgbotNote Added: 0035149
2011-03-22 15:10hgbotStatusnew => resolved
2011-03-22 15:10hgbotResolutionopen => fixed
2011-03-22 15:10hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/639512a95f28ff87313fecd58dd00ebd300f7027 [^]
2011-03-30 09:00psarobeNote Added: 0035353
2011-03-30 09:00psarobeStatusresolved => closed
2011-03-30 09:00psarobeFixed in Version => 3.0RC5
2011-03-31 00:00anonymoussf_bug_id0 => 3261338
2011-04-07 11:10hgbotCheckin
2011-04-07 11:10hgbotNote Added: 0035700
2011-04-07 11:10hgbotStatusclosed => resolved
2011-04-07 11:10hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/639512a95f28ff87313fecd58dd00ebd300f7027 [^] => http://code.openbravo.com/erp/devel/pi/rev/e3a7846219dda22963ffe765ca76a537b9a3ceb2 [^]
2011-06-10 13:19plujanRelationship addedrelated to 0016429
2011-06-10 13:20shuehnerNote Added: 0038232
2011-06-10 13:20shuehnerStatusresolved => closed

Notes
(0035149)
hgbot   
2011-03-22 15:10   
Repository: erp/devel/pi
Changeset: 639512a95f28ff87313fecd58dd00ebd300f7027
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Mar 22 15:09:17 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/639512a95f28ff87313fecd58dd00ebd300f7027 [^]

Fixed issue 16422. dump/restore will no longer cause ad_db_modified to detect non-existant db structure changes

---
M src-db/database/model/prescript-PostgreSql.sql
---
(0035353)
psarobe   
2011-03-30 09:00   
Fixed in RC5EU1
(0035700)
hgbot   
2011-04-07 11:10   
Repository: erp/devel/pi
Changeset: e3a7846219dda22963ffe765ca76a537b9a3ceb2
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Tue Mar 22 15:09:17 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/e3a7846219dda22963ffe765ca76a537b9a3ceb2 [^]

Fixed issue 16422. dump/restore will no longer cause ad_db_modified to detect non-existant db structure changes

---
M src-db/database/model/prescript-PostgreSql.sql
---
(0038232)
shuehner   
2011-06-10 13:20   
Tested in pi-mp0/pgsql now with clean db-state after pg_dump/pg_restore the next update.database does not complain about local changes.

However: side-effect of this fix is that any real local changes (in pgsql only) inside views + checks will never be detected anymore.