niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
· nixdoc.net · man pages · Linux HOWTOs · FreeBSD Tips · Forums
navigation Forum index » Databases » Sybase
sybtcl/freetds hangs on sybclose/dbcancel -- what can I do?
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
Author Message
Mikhail Teterin
*nix forums addict


Joined: 23 Mar 2002
Posts: 56

PostPosted: Thu Jun 15, 2006 3:18 am    Post subject: sybtcl/freetds hangs on sybclose/dbcancel -- what can I do? Reply with quote

Hello!

Because Sybase foolishly would not open-source the client-library, I am
forced to use FreeTDS.

When my Tcl-script (using Sybtcl) detects the remote server's misbehaviour
(such as extreme slowness), it tries to close the connection and move on.

Sometimes this hangs, however. Here is the stack:

#0 0x00000008009f487c in select () from /lib/libc.so.6
#1 0x0000000800d9a18b in tdsdump_open () from /opt/lib/libsybdb.so.5
#2 0x0000000800d9a355 in tdsdump_open () from /opt/lib/libsybdb.so.5
#3 0x0000000800d89cb3 in tdsdump_open () from /opt/lib/libsybdb.so.5
#4 0x0000000800d8681f in stat_xact () from /opt/lib/libsybdb.so.5
#5 0x0000000800d87a71 in stat_xact () from /opt/lib/libsybdb.so.5
#6 0x0000000800d738c4 in dbcancel () from /opt/lib/libsybdb.so.5
#7 0x0000000800c5e543 in Sybtcl_Close (clientData=0x0, interp=0x505400,
objc=2, objv=0x513008)
at /usr/ports/databases/sybtcl/work/sybtcl-3.0rc2/generic/sybtcl.c:4121
#8 0x000000080065d5d5 in TclEvalObjvInternal (interp=0x505400, objc=2,
objv=0x513008, command=0x0, length=0, flags=0)
at ./../generic/tclBasic.c:3088
#9 0x0000000800690283 in TclExecuteByteCode (interp=0x505400,
codePtr=0x6de000) at ./../generic/tclExecute.c:1417
[...]

How can I detect such situation from Tcl and force sybtcl to abandon the
attempt to "say goodbye"?

Thanks!

-mi
Back to top
Michael Peppler
*nix forums Guru Wannabe


Joined: 15 May 2005
Posts: 112

PostPosted: Thu Jun 15, 2006 3:55 pm    Post subject: Re: sybtcl/freetds hangs on sybclose/dbcancel -- what can I do? Reply with quote

On Wed, 14 Jun 2006 23:18:28 -0400, Mikhail Teterin wrote:

Quote:
Hello!

Because Sybase foolishly would not open-source the client-library, I am
forced to use FreeTDS.

Well - The client library is available for a lot of platforms via the
download of the ASE developer edition...

Quote:

When my Tcl-script (using Sybtcl) detects the remote server's
misbehaviour (such as extreme slowness), it tries to close the
connection and move on.

If the problem is related to FreeTDS I think your best bet is to ask on
the freetds mailing list...

Michael
--
Michael Peppler [TeamSybase] mpeppler@peppler.org - http://www.peppler.org/
Sybase DBA/Developer
Sybase on Linux FAQ: http://www.peppler.org/FAQ/linux.html
Back to top
Mikhail Teterin
*nix forums addict


Joined: 23 Mar 2002
Posts: 56

PostPosted: Thu Jul 06, 2006 10:15 pm    Post subject: Open source the Sybase "Open" Client Reply with quote

Quote:
Well - The client library is available for a lot of platforms via the
download of the ASE developer edition...

It is not available on FreeBSD -- on neither of its 4 hardware platforms.
Nor for NetBSD (with its umpteen platforms). Etc., etc.

I understand the considerations behind not wanting to release/support the
SERVER side of Sybase on all of these, and, of course, I'm not calling for
opening the SERVER's source.

But there is no purpose whatsoever in keeping the CLIENT side of Sybase
closed source. None.

What, I wonder, does "Open" stand for in the "OCS"?

-mi
Back to top
Google

Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
The time now is Sat Aug 30, 2014 10:27 am | All times are GMT
navigation Forum index » Databases » Sybase
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts strange user-space hangs Dan Miller system 2 Thu Jul 20, 2006 12:07 am
No new posts mysql hangs on connection attempt Steve Strong MySQL 3 Tue Jul 18, 2006 6:57 pm
No new posts "Unpacking replacement..." hangs in apt-get. Adam Soltan Debian 7 Fri Jul 14, 2006 12:30 pm
No new posts Random Hangs, Linux AMD 64, 5.0.22 AB Binaries Matt Williams MySQL 2 Thu Jul 13, 2006 5:48 pm
No new posts bash pipe on while read hangs Robert Mark Bram shell 2 Thu Jul 13, 2006 2:36 pm

Copyright © 2004-2005 DeniX Solutions SRL
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum |  email marketing service
 
Privacy Policy
[ Time: 0.0309s ][ Queries: 16 (0.0033s) ][ GZIP on - Debug on ]