Skip to Content.
Sympa Menu

freetds - [freetds] [Generic Connectivity Using ODBC][S1000] [9013]General error in nvITrans_BeginT - rc = -1

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] [Generic Connectivity Using ODBC][S1000] [9013]General error in nvITrans_BeginT - rc = -1

Chronological Thread  
    < Chronological >       < Thread >
  • From: "Jochen Michlig" <jochen.michlig AT gmx.ch>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] [Generic Connectivity Using ODBC][S1000] [9013]General error in nvITrans_BeginT - rc = -1
  • Date: Tue, 13 Dec 2005 09:59:04 +0100 (MET)
Hi all
I have the following problem. we are running a web application using Java
Servlets and Tomcat on a linux box. The application uses Oracle
Heterogeneous Services to connect to a MS SQL Server 2000 over unixODBC with
freetds. All is configured properly. The application works just fine. The
problem is, when the sql server goes down. Without restarting the tomcat
container we get the following error:

[unixODBC][FreeTDS][SQL Server]Could not perform COMMIT or
ROLLBACK[unixODBC][FreeTDS][SQL Server]Attempt to initiate a new SQL Server
operation with results pending. (SQL State: 24000; SQL Code: 20019)
(Last message occurred 2 times)

[S1000] [9013]General error in nvITrans_BeginT - rc = -1. Please refer to
the
log file for details.

the unixodbc trace file says:

[ODBC][5177][SQLGetConnectOption.c][219]
Entry:
Connection = 0x825c088
Option = SQL_ATTR_AUTOCOMMIT
Value = 0xbfffba10
[ODBC][5177][SQLGetConnectOption.c][499]
Exit:[SQL_SUCCESS]
[ODBC][5177][SQLGetInfo.c][214]
Entry:
Connection = 0x825c088
Info Type = SQL_TXN_ISOLATION_OPTION (72)
Info Value = 0xbfffb9b0
Buffer Length = 4
StrLen = (nil)
[ODBC][5177][SQLGetInfo.c][528]
Exit:[SQL_SUCCESS]
[ODBC][5177][SQLTransact.c][175]
Entry:
Environment = (nil)
Connection = 0x825c088
Completion Type = 0
[ODBC][5177][SQLTransact.c][347]
Exit:[SQL_ERROR]
DIAG [08S01] [FreeTDS][SQL Server]Write to SQL Server failed.

DIAG [S1000] [FreeTDS][SQL Server]Could not perform COMMIT or
ROLLBACK

[ODBC][5177][SQLError.c][424]
Entry:
Connection = 0x825c088
SQLState = 0xbfffb7a8
Native = 0xbfffb790
Message Text = 0xbfffb7b8
Buffer Length = 511
Text Len Ptr = 0xbfffb796
[ODBC][5177][SQLError.c][461]
Exit:[SQL_SUCCESS]
SQLState = S1000
Native = 0xbfffb790 -> 0
Message Text = [[unixODBC][FreeTDS][SQL Server]Could
not perform COMMIT
or ROLLBACK]
[ODBC][5177][SQLError.c][424]
Entry:
Connection = 0x825c088
SQLState = 0xbfffb7a8
Native = 0xbfffb790
Message Text = 0xbfffb7b8
Buffer Length = 511
Text Len Ptr = 0xbfffb796
[ODBC][5177][SQLError.c][461]
Exit:[SQL_SUCCESS]
SQLState = 08S01
Native = 0xbfffb790 -> 20006
Message Text = [[unixODBC][FreeTDS][SQL Server]Write
to SQL Server
failed.]
[ODBC][5177][SQLError.c][424]
Entry:
Connection = 0x825c088
SQLState = 0xbfffb7a8
Native = 0xbfffb790
Message Text = 0xbfffb7b8
Buffer Length = 511
Text Len Ptr = 0xbfffb796
[ODBC][5177][SQLError.c][461]
Exit:[SQL_NO_DATA]
[ODBC][5177][SQLGetConnectOption.c][219]
Entry:
Connection = 0x825c088
Option = SQL_ATTR_AUTOCOMMIT
Value = 0xbfffba10
[ODBC][5177][SQLGetConnectOption.c][499]
Exit:[SQL_SUCCESS]
[ODBC][5177][SQLGetInfo.c][214]
Entry:
Connection = 0x825c088
Info Type = SQL_TXN_ISOLATION_OPTION (72)
Info Value = 0xbfffb9b0
Buffer Length = 4
StrLen = (nil)
[ODBC][5177][SQLGetInfo.c][528]
Exit:[SQL_SUCCESS]
[ODBC][5177][SQLTransact.c][175]
Entry:
Environment = (nil)
Connection = 0x825c088
Completion Type = 0
[ODBC][5177][SQLTransact.c][347]
Exit:[SQL_ERROR]
DIAG [24000] [FreeTDS][SQL Server]Attempt to initiate a new
SQL Server
operation with results pending.

DIAG [S1000] [FreeTDS][SQL Server]Could not perform COMMIT or
ROLLBACK

[ODBC][5177][SQLError.c][424]
Entry:
Connection = 0x825c088
SQLState = 0xbfffb7a8
Native = 0xbfffb790
Message Text = 0xbfffb7b8
Buffer Length = 511
Text Len Ptr = 0xbfffb796
[ODBC][5177][SQLError.c][461]
Exit:[SQL_SUCCESS]
SQLState = S1000
Native = 0xbfffb790 -> 0
Message Text = [[unixODBC][FreeTDS][SQL Server]Could
not perform COMMIT
or ROLLBACK]
[ODBC][5177][SQLError.c][424]
Entry:
Connection = 0x825c088
SQLState = 0xbfffb7a8
Native = 0xbfffb790
Message Text = 0xbfffb7b8
Buffer Length = 511
Text Len Ptr = 0xbfffb796
[ODBC][5177][SQLError.c][461]
Exit:[SQL_SUCCESS]
SQLState = 24000
Native = 0xbfffb790 -> 20019
Message Text = [[unixODBC][FreeTDS][SQL
Server]Attempt to initiate a new
SQL Server operation with results pending.]
[ODBC][5177][SQLError.c][424]
Entry:
Connection = 0x825c088
SQLState = 0xbfffb7a8
Native = 0xbfffb790
Message Text = 0xbfffb7b8
Buffer Length = 511
Text Len Ptr = 0xbfffb796
[ODBC][5177][SQLError.c][461]
Exit:[SQL_NO_DATA]
[ODBC][5165][SQLGetConnectOption.c][219]
Entry:
Connection = 0x825c088
Option = SQL_ATTR_AUTOCOMMIT
Value = 0xbfffc010
[ODBC][5165][SQLGetConnectOption.c][499]
Exit:[SQL_SUCCESS]
[ODBC][5165][SQLGetInfo.c][214]
Entry:
Connection = 0x825c088
Info Type = SQL_TXN_ISOLATION_OPTION (72)
Info Value = 0xbfffbfb0
Buffer Length = 4
StrLen = (nil)
[ODBC][5165][SQLGetInfo.c][528]
Exit:[SQL_SUCCESS]
[ODBC][5165][SQLTransact.c][175]
Entry:
Environment = (nil)
Connection = 0x825c088
Completion Type = 0
[ODBC][5165][SQLTransact.c][347]
Exit:[SQL_ERROR]
DIAG [24000] [FreeTDS][SQL Server]Attempt to initiate a new
SQL Server
operation with results pending.

DIAG [S1000] [FreeTDS][SQL Server]Could not perform COMMIT or
ROLLBACK

[ODBC][5165][SQLError.c][424]
Entry:
Connection = 0x825c088
SQLState = 0xbfffbda8
Native = 0xbfffbd90
Message Text = 0xbfffbdb8
Buffer Length = 511
Text Len Ptr = 0xbfffbd96
[ODBC][5165][SQLError.c][461]
Exit:[SQL_SUCCESS]
SQLState = S1000
Native = 0xbfffbd90 -> 0
Message Text = [[unixODBC][FreeTDS][SQL Server]Could
not perform COMMIT
or ROLLBACK]
[ODBC][5165][SQLError.c][424]
Entry:
Connection = 0x825c088
SQLState = 0xbfffbda8
Native = 0xbfffbd90
Message Text = 0xbfffbdb8
Buffer Length = 511
Text Len Ptr = 0xbfffbd96
[ODBC][5165][SQLError.c][461]
Exit:[SQL_SUCCESS]
SQLState = 24000
Native = 0xbfffbd90 -> 20019
Message Text = [[unixODBC][FreeTDS][SQL
Server]Attempt to initiate a new
SQL Server operation with results pending.]
[ODBC][5165][SQLError.c][424]
Entry:
Connection = 0x825c088
SQLState = 0xbfffbda8
Native = 0xbfffbd90
Message Text = 0xbfffbdb8
Buffer Length = 511
Text Len Ptr = 0xbfffbd96
[ODBC][5165][SQLError.c][461]
Exit:[SQL_NO_DATA]

We always have to restart the tomcat container and then everything is
working fine...

any help is appreciated.
thank you


--
Telefonieren Sie schon oder sparen Sie noch?
NEU: GMX Phone_Flat http://www.gmx.net/de/go/telefonie


  • [freetds] [Generic Connectivity Using ODBC][S1000] [9013]General error in nvITrans_BeginT - rc = -1, Jochen Michlig, 12/13/2005

Archive powered by MHonArc 2.6.24.

Top of Page