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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0036937
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2017-09-25 10:542017-09-26 15:25
ReporteralostaleView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision5778a1eb4671
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToAugustoMauch
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0036937: update.database source data queries current time to DB for each change

DescriptionWhen updating database, each change in source data queries DB for current time stamp.
Steps To Reproduce0. Enable logging all DB statements
1. run update.database ensuring there are changes in source data
  -> check there are as many queries to "select now() from dual" as changes detected in source data
Proposed SolutionAssuming db and sources server are in the same time zone, it's not necessary to query data to DB, being possible to calculate it in JVM preventing in this way round trips to DB.
TagsPerformance
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0035653 closedalostale update.database can fail updating src tables with a check constraint where more than one column participates 

-  Notes
(0099525)
hgbot (developer)
2017-09-25 11:23

Repository: erp/devel/dbsm-main
Changeset: ecd35e9def0f0f83e1b53bfb1af3098034ba37c8
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Sep 25 10:41:15 2017 +0200
URL: http://code.openbravo.com/erp/devel/dbsm-main/rev/ecd35e9def0f0f83e1b53bfb1af3098034ba37c8 [^]

fixed bug 36937: update.database source data queries time to DB for each change

  There is not need to query current time from DB. Now it is calculated in JVM
  instead.

---
M src/org/apache/ddlutils/platform/PlatformImplBase.java
---
(0099527)
hgbot (developer)
2017-09-25 11:23

Repository: erp/devel/pi
Changeset: 5778a1eb46718a99ff7479e483a108f24a529198
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Sep 25 11:04:14 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/5778a1eb46718a99ff7479e483a108f24a529198 [^]

fixed bug 36937, fixed bug 35653: dbsm fixing those 2 issues

---
M src-db/database/lib/dbsourcemanager.jar
---
(0099562)
AugustoMauch (developer)
2017-09-25 15:20

Code reviewed and verified
(0099588)
hudsonbot (developer)
2017-09-26 15:25

A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/8fa643b4437e [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2017-09-25 10:54 alostale New Issue
2017-09-25 10:54 alostale Assigned To => platform
2017-09-25 10:54 alostale Modules => Core
2017-09-25 10:54 alostale Triggers an Emergency Pack => No
2017-09-25 10:54 alostale Assigned To platform => alostale
2017-09-25 10:55 alostale Review Assigned To => AugustoMauch
2017-09-25 10:55 alostale Relationship added related to 0035653
2017-09-25 10:55 alostale Tag Attached: Performance
2017-09-25 11:23 hgbot Checkin
2017-09-25 11:23 hgbot Note Added: 0099525
2017-09-25 11:23 hgbot Status new => resolved
2017-09-25 11:23 hgbot Resolution open => fixed
2017-09-25 11:23 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/dbsm-main/rev/ecd35e9def0f0f83e1b53bfb1af3098034ba37c8 [^]
2017-09-25 11:23 hgbot Checkin
2017-09-25 11:23 hgbot Note Added: 0099527
2017-09-25 11:23 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/dbsm-main/rev/ecd35e9def0f0f83e1b53bfb1af3098034ba37c8 [^] => http://code.openbravo.com/erp/devel/pi/rev/5778a1eb46718a99ff7479e483a108f24a529198 [^]
2017-09-25 15:20 AugustoMauch Note Added: 0099562
2017-09-25 15:20 AugustoMauch Status resolved => closed
2017-09-26 15:25 hudsonbot Checkin
2017-09-26 15:25 hudsonbot Note Added: 0099588


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker