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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0011377
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2009-11-16 15:122009-11-19 00:00
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisionf87cf399296f
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0011377: Make DAL use inside dbsourcemanager more resilient to a unclean database state.

DescriptionIf a update.database run was interrupted, i.e. because of some failure then the AD_* table can be in some inconsistent state.

Example a foreign key field (i.e. ad_tab.ad_table_id) might contain some uuid where the target primary key does not exists (the ad_table entry with this value).

As DAL by default uses AD_Table,... for access control DAL startup fails and thus update.database cannot be used to 'repair' the database state.

But the automatic dal-access control in dbsourcemanager is not needed for the update.database run. Disabling it lets dal start with these inconsistent db-state and thus update.database can be run again to 'repair' the db and continue working.
Steps To ReproduceHard, as it requires a broken db-instance with this symptoms...
Proposed SolutionDisable automatic access-control earlier in dbsourcemanager when running in adminmode (meaning all rights are granted) so ad_* tables are not even read for the checks.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0021917)
hgbot (developer)
2009-11-17 12:31

Repository: erp/devel/pi
Changeset: f87cf399296ff28713b92f02245ca9e768df26c2
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Tue Nov 17 12:30:36 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/f87cf399296ff28713b92f02245ca9e768df26c2 [^]

Fixed 11377: Disable dal access checks in adminmode earlier
This makes the dal use in dbsourcemanager more resilient to an unclean db-state

---
M src/org/openbravo/dal/service/OBCriteria.java
M src/org/openbravo/dal/service/OBDal.java
M src/org/openbravo/dal/service/OBQuery.java
M src/org/openbravo/dal/xml/EntityXMLConverter.java
---
(0021970)
mtaal (manager)
2009-11-18 14:27

reviewed

- Issue History
Date Modified Username Field Change
2009-11-16 15:12 shuehner New Issue
2009-11-16 15:12 shuehner Assigned To => shuehner
2009-11-17 12:31 hgbot Checkin
2009-11-17 12:31 hgbot Note Added: 0021917
2009-11-17 12:31 hgbot Status new => resolved
2009-11-17 12:31 hgbot Resolution open => fixed
2009-11-17 12:31 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/f87cf399296ff28713b92f02245ca9e768df26c2 [^]
2009-11-18 14:27 mtaal Note Added: 0021970
2009-11-18 14:27 mtaal Status resolved => closed
2009-11-19 00:00 anonymous sf_bug_id 0 => 2900165


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker