Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0031366 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] A. Platform | major | have not tried | 2015-11-05 09:47 | 2015-11-23 21:17 | |||
Reporter | Orekaria | View Status | public | |||||
Assigned To | alostale | |||||||
Priority | immediate | Resolution | fixed | Fixed in Version | 3.0PR16Q1 | |||
Status | closed | Fix in branch | Fixed in SCM revision | cd794e1d482e | ||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Merge Request Status | ||||||||
Review Assigned To | Orekaria | |||||||
OBNetwork customer | No | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0031366: 2 tests failing in try-ret-checks-oracle | |||||||
Description | In 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 Reproduce | Navigate 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 Solution | Change the query to filter by user. The user can probably be picked up from the JOB_NAME environmental variable System.getenv("JOB_NAME") | |||||||
Tags | No tags attached. | |||||||
Attached Files | ![]() | |||||||
![]() |
||||||||
|
![]() |
|
(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 (viewer) 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 |
![]() |
|||
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 | OBNetwork customer | => No |
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 |