[
https://issues.apache.org/jira/browse/TRAFODION-2311?focusedWorklogId=268160&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-268160
]
ASF GitHub Bot logged work on TRAFODION-2311:
---------------------------------------------
Author: ASF GitHub Bot
Created on: 27/Jun/19 01:45
Start Date: 27/Jun/19 01:45
Worklog Time Spent: 10m
Work Description: xiaozhongwang commented on issue #1844:
[TRAFODION-2311] Avoid logging error 8605 and 8609 during SQLEndTrans if no
trans active
URL: https://github.com/apache/trafodion/pull/1844#issuecomment-506105531
Very good feature for compatible.
On 星期四, 六月 27, 2019 08:04 CST, Selvaganesan Govindarajan
<[email protected]> 撰寫:
The ODBC specification says the following when SQLEndTran API is called
For drivers and data sources that support transactions, calling SQLEndTran
with either SQL_COMMIT or SQL_ROLLBACK when no transaction is active returns
SQL_SUCCESS (indicating that there is no work to be committed or rolled back)
and has no effect on the data source.
When a driver is in autocommit mode, the Driver Manager does not call
SQLEndTran in the driver. SQLEndTran always returns SQL_SUCCESS regardless of
whether it is called with a CompletionType of SQL_COMMIT or SQL_ROLLBACK.
Hence this change can be merged.
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub, or mute the thread.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 268160)
Time Spent: 1.5h (was: 1h 20m)
> Avoid error 8605 and 8609 during SQLEndTran if no transaction active
> --------------------------------------------------------------------
>
> Key: TRAFODION-2311
> URL: https://issues.apache.org/jira/browse/TRAFODION-2311
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: Arvind Narain
> Assignee: Arvind Narain
> Priority: Major
> Time Spent: 1.5h
> Remaining Estimate: 0h
>
> Frequently , during performance test runs like OE and other regression tests
> following errors are observed in master logs:
> ERROR[8605] Committing a transaction which has not started.
> ERROR[8609] Waited rollback performed without starting a transaction.
> MXOSRVR does return success to the client for these errors but since
> commit/rollback is executed, the error gets logged in master exec logs.
> Some of these can be avoided if mxosrvr implements the following ODBC
> standard and skips executing the commit/rollback statement.
> "For drivers and data sources that support transactions, calling SQLEndTran
> with either SQL_COMMIT or SQL_ROLLBACK when no transaction is active returns
> SQL_SUCCESS (indicating that there is no work to be committed or rolled back)
> and has no effect on the data source."
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
