Re: informix doesn't close connection; isql hangs on exit

In article <6a7p11$7d3@cnj.digex.net>, Atiqullah Hashmi <hashmi@cnj.digex.net> writes >Hi, > >We recently moved to a new sun machine running sol2.4. We run informix7.1. >Applications and everything including isql run fine except that often >when we exit from isql, it doesn't come back to shell. A similar thing I've seen that with dbaccess. Hitting the interruot key solved our problem. >happens with our application which runs the transaction fine but just >doesn't return control to shell. I tracked it to the program line: > >EXEC SQL disconnect default > >where it hangs. This happens often but not always. >A truss on the applic. shows that it waits on getmsg() form /dev/tcp >and sleeps. Sometimes it returns in a few minutes sometimes won't. >Here is the truss output: > >...... snipped >open("/dev/tcp", O_RDWR) = 6 >ioctl(6, I_FIND, "timod") = 0 >sigprocmask(SIG_BLOCK, 0xDFFFDC30, 0xDFFFDCE0) = 0 >ioctl(6, I_PUSH, "timod") = 0 >sigprocmask(SIG_SETMASK, 0xDFFFDCD0, 0xDFFFDCC0) = 0 >ioctl(6, I_STR, 0xDFFFDAD8) = 0 >sigprocmask(SIG_SETMASK, 0xDFFFDCC0, 0xDFFFDCA0) = 0 >ioctl(6, I_FLUSH, FLUSHRW) = 0 >sigprocmask(SIG_SETMASK, 0xDFFFDCE0, 0x00000000) = 0 >sigprocmask(SIG_BLOCK, 0xDFFFDB60, 0xDFFFDCC0) = 0 >ioctl(6, I_STR, 0xDFFFDC84) = 0 >........ snipped more ioctls >read(0, 0x001626D4, 8192) = 0 >write(6, "\\0 T\\0\\f", 4) = 4 >getmsg(6, 0xDFFFEE1C, 0xDFFFEE10, 0xDFFFEE8C) = 0 >write(6, "\\0 8", 2) = 2 >getmsg(6, 0xDFFFEE7C, 0xDFFFEE70, 0xDFFFEEEC) = 0 >putmsg(6, 0xDFFFEE00, 0x00000000, 0) = 0 >ioctl(6, I_PEEK, 0xDFFFECC4) = 0 >poll(0xDFFFEE38, 1, 100000) (sleeping...) > >and hangs at this poll() statement. > >If possible, please reply directly. >Thanks much for any help. >AH -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care