Re: Yet another INET problem

Igor G. Popov (res@din.lois.perm.su) wrote: : The slow Informix-Net problem was succesfully solved, thank you, : all! It was bug in version 5.00 of this product. I have version : 5.02 now, and it works as fast as I expect it. But... When my : query return many rows (more than 1000) I get -408 error. In : peak of hours, I get ones even if my query return handred rows : only! H-m-m. Net 5.00 is slow, but it works. Net 5.02 is fast, : but it crashes. What is incorrect? I have INFORMIX-NET 5.02.UC2 : for INTERACTIVE UNIX 3.0. : Yours, : . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . : . Igor G.Popov . Laboratory of Open Information Systems, ltd. . : . res@lois.perm.su . Russia, Perm, Kirova 128-770, +7-3422-395028 . : . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Finally I've found someone else that has this problem!!! I've posted this problem twice in the last 2 months and haven't had any response back. Informix Tech Support has been working on my system for the last eight weeks trying to find a reason why this happens. To date, they have not. I'm running 5.02.UC6 on an SCO Unix system. I've found that this problem exists under both 5.02.UC2 and 5.02.UC6. (Incidently, 5.02.UC2 has other nasty bugs, and was no longer being shipped I thought) After much troubleshooting on my own I've come to the conclusion that the I-net sqlexec process must have a problem keeping its connections straight, because I've determined that you will not get the -408 error when you are the only user. As soon as another user gets on, your chances increase. The more users and the higher the traffic, the more likely you will get a -408 error. I will be forwarding your post to my tech support person at Informix so that he will be aware that the problem has been found elsewhere and on a slightly different operating system platform. Incidently, we are getting around the problem for now by using an old copy of an Online engine and I-Star on the front end. We put up with the errors for about 6 weeks and then gave up waiting for a fix. If anyone else has experienced these problems (or is running these versions and not experiencing problems) please send me e-mail. Misery loves company :-) -- Dale Van Voorst voorst@dordt.edu Computer Services postmaster@dordt.edu Dordt College Sioux Center, IA 51250 (712) 722-6299