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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0031366
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2015-11-05 09:472015-11-23 21:17
ReporterOrekariaView Statuspublic 
Assigned Toalostale 
PriorityimmediateResolutionfixedFixed in Version3.0PR16Q1
StatusclosedFix in branchFixed in SCM revisioncd794e1d482e
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToOrekaria
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0031366: 2 tests failing in try-ret-checks-oracle

DescriptionIn the try-ret-checks-oracle job, these 2 tests are failing because the Oracle database is being accessed by different users and the sql query does not take it into account

org.openbravo.test.db.model.functions.SqlCallableStatement.transactionalCallableStatemetsShouldBeClosed
org.openbravo.test.db.model.functions.SqlCallableStatement.noTransactionalCallableStatemetsShouldBeClosedCallableStatemetsShouldBeClosed
Steps To ReproduceNavigate to https://ci.openbravo.com/view/try-retail/job/try-ret-checks-oracle/ [^]

Verify that some of the builds have these failing tests due to unexpected number of cursors:
- org.openbravo.test.db.model.functions.SqlCallableStatement.transactionalCallableStatemetsShouldBeClosed
- org.openbravo.test.db.model.functions.SqlCallableStatement.noTransactionalCallableStatemetsShouldBeClosedCallableStatemetsShouldBeClosed

Send some builds with the attached cursors.diff until the tests fail

Verify that there are more users than expected:
    # of open cursors for the statement. DB Users TRY_RET_MODULES_ORACLE TRY_RET_FULL_ORACLE
Proposed SolutionChange the query to filter by user. The user can probably be picked up from the JOB_NAME environmental variable
    System.getenv("JOB_NAME")
TagsNo tags attached.
Attached Filesdiff file icon cursors.diff [^] (1,406 bytes) 2015-11-05 09:47 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00308913.0PR16Q1 closedalostale Xsql files parser does not release statement for callable statements 

-  Notes
(0081496)
hgbot (developer)
2015-11-05 10:34

Repository: erp/devel/pi
Changeset: cd794e1d482e959a541531081149c925a55e1575
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Thu Nov 05 10:32:23 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/cd794e1d482e959a541531081149c925a55e1575 [^]

fixed bug 31366: SqlCallableStatement test cases fail in try-ret-checks-oracle

  Retail oracle try infrastructure is executed in parallel for different DB users.
  When querying as DBA for open cursors, cursors only for current user should be
  checked, other way different executions can cause clashes.

---
M src-test/src/org/openbravo/test/db/model/functions/SqlCallableStatement.java
---
(0082175)
hudsonbot (developer)
2015-11-23 21:17

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/7b56bebaaa88 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2015-11-05 09:47 Orekaria New Issue
2015-11-05 09:47 Orekaria Assigned To => platform
2015-11-05 09:47 Orekaria File Added: cursors.diff
2015-11-05 09:47 Orekaria Modules => Core
2015-11-05 09:47 Orekaria Triggers an Emergency Pack => No
2015-11-05 09:54 Orekaria Priority normal => urgent
2015-11-05 10:07 alostale Priority urgent => immediate
2015-11-05 10:08 alostale Relationship added related to 0030891
2015-11-05 10:08 alostale Status new => scheduled
2015-11-05 10:08 alostale Assigned To platform => alostale
2015-11-05 10:08 alostale Review Assigned To => Orekaria
2015-11-05 10:34 hgbot Checkin
2015-11-05 10:34 hgbot Note Added: 0081496
2015-11-05 10:34 hgbot Status scheduled => resolved
2015-11-05 10:34 hgbot Resolution open => fixed
2015-11-05 10:34 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cd794e1d482e959a541531081149c925a55e1575 [^]
2015-11-05 22:29 Orekaria Status resolved => closed
2015-11-05 22:29 Orekaria Fixed in Version => 3.0PR16Q1
2015-11-23 21:17 hudsonbot Checkin
2015-11-23 21:17 hudsonbot Note Added: 0082175


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker