Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0029156Openbravo ERPA. Platformpublic2015-03-06 07:202015-03-10 16:59
Reporteralostale 
Assigned ToAugustoMauch 
PrioritynormalSeveritytrivialReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0PR14Q3.8Fixed in Version3.0PR14Q3.8 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0029156: log table recreation on update database
DescriptionUpdate database task recreates tables when their module is updated, this recreation can take a long time to complete but currently there is no information in the log about what is going on.
Steps To ReproduceEnable pg log for all statements
Update from PR14Q3 to PR14Q4
Check in pg logs how some tables were recreated
Proposed Solution
Additional Information
TagsApproved
Relationships
blocks feature request 0029154 closed alostale log table recreation on update database 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2015-03-06 07:21alostaleTypefeature request => backport
2015-03-06 07:21alostaleTarget Version => 3.0PR14Q3.8
2015-03-06 10:38dmitry_mezentsevTag Attached: Approved
2015-03-10 07:52hgbotCheckin
2015-03-10 07:52hgbotNote Added: 0075363
2015-03-10 07:52hgbotStatusscheduled => resolved
2015-03-10 07:52hgbotResolutionopen => fixed
2015-03-10 07:52hgbotFixed in SCM revision => http://code.openbravo.com/erp/backports/3.0PR14Q3.8/rev/337cef75e9640a2d421e1ee7222ca37360623692 [^]
2015-03-10 16:05AugustoMauchReview Assigned To => AugustoMauch
2015-03-10 16:05AugustoMauchNote Added: 0075405
2015-03-10 16:05AugustoMauchStatusresolved => closed
2015-03-10 16:05AugustoMauchFixed in Version => 3.0PR15Q1.2
2015-03-10 16:56AugustoMauchNote Deleted: 0075405
2015-03-10 16:59AugustoMauchNote Added: 0075414
2015-03-10 16:59AugustoMauchFixed in Version3.0PR15Q1.2 => 3.0PR14Q3.8

Notes
(0075363)
hgbot   
2015-03-10 07:52   
Repository: erp/backports/3.0PR14Q3.8
Changeset: 337cef75e9640a2d421e1ee7222ca37360623692
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Mar 06 08:10:31 2015 +0100
URL: http://code.openbravo.com/erp/backports/3.0PR14Q3.8/rev/337cef75e9640a2d421e1ee7222ca37360623692 [^]

fixed issue 29156: added log on table recreation when updating database

---
M src-db/database/lib/dbsourcemanager.jar
---
(0075414)
AugustoMauch   
2015-03-10 16:59   
Code reviewed and verified in [1]@337cef75e964

[1] https://code.openbravo.com/erp/backports/3.0PR14Q3.8/ [^]

Test plan:
- Update from 3.0PR14Q3.8 to the last 3.0PR14Q1 release using the module management console.
- In the terminal, revert the change done to the dbsourcemanager.jar file to use the Q3.8 version
- run ant smartbuild -Dtr=no -Dlocal=no -Dforce=yes. The message related with the recreation of the tables are shown