Unix Technical Forum

Can't DISCONNECT|CLOSE when -439

This is a discussion on Can't DISCONNECT|CLOSE when -439 within the Informix forums, part of the Database Server Software category; --> Hi, Any ideas why a threaded application can't DISCONNECT :connection or CLOSE DATABASE when SQLCODE was -439 before a ...


Go Back   Unix Technical Forum > Database Server Software > Informix

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-19-2008, 07:29 PM
Corne' Cornelius
 
Posts: n/a
Default Can't DISCONNECT|CLOSE when -439

Hi,

Any ideas why a threaded application can't

DISCONNECT :connection or CLOSE DATABASE

when SQLCODE was -439 before a sqlbreak(), and 0 after the sqlbreak() ?

it just encounters another -439 error, even if sqlbreak() is called before.

sqlbreakcallback(0L,callback_func) doesn't even call the callback_func
as it's supposed to.

maybe a socket timeout ? would a signal(SIGPIPE, SIG_IGN) help ?
onstat -g ses still shows the connection though

maybe a bug in the engine ? how could i get around this ?

Thanks
Corne'

!Exclude Disclaimer!

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-19-2008, 07:29 PM
Corne' Cornelius
 
Posts: n/a
Default Re: Can't DISCONNECT|CLOSE when -439

The callback functions wasn't even called when i used 0 as timeout.
Maybe the client loses the signal handler, or gets blocked ?

Not using shared memory connection. using onsoctcp

The only thing that seems to work, is to kill any thread that got the
-439 possible runaway process, and create a new thread.


Andy Lennard wrote:
> In message <3F4507B7.9090302@reach.co.za>, Corne' Cornelius
> <cornec@reach.co.za> writes
>
>>Hi,
>>
>>Any ideas why a threaded application can't
>>
>>DISCONNECT :connection or CLOSE DATABASE
>>
>>when SQLCODE was -439 before a sqlbreak(), and 0 after the sqlbreak() ?
>>
>>it just encounters another -439 error, even if sqlbreak() is called before.
>>
>>sqlbreakcallback(0L,callback_func) doesn't even call the callback_func
>>as it's supposed to.
>>

>
>
> My manual says that if the timeout is 0, then the callback function
> executes immediately, and then 'over and over again'.
>
> However it also says that the callback function will never be called if
> you use a shared memory connection.
>
> I guess the application is correctly built threaded..
>
>
>>maybe a socket timeout ? would a signal(SIGPIPE, SIG_IGN) help ?
>>onstat -g ses still shows the connection though
>>
>>maybe a bug in the engine ? how could i get around this ?
>>
>>Thanks
>>Corne'
>>
>>!Exclude Disclaimer!
>>

>
>


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:49 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com