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

Jochen Michlig jochen.michlig at gmx.ch
Tue Dec 13 03:59:04 EST 2005


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


More information about the FreeTDS mailing list