fglgo 4.10.UC1 hanging on drop table
Posted in 1994
One of my applications occasionally hangs when dropping a temp table. From the point of view of the user, the application freezes, and nothing they type makes any difference, except that ^C doesn't succeed in killing the application. Using "top" or "ps" reveals that fglgo is looping, using all the CPU time it can grab. The problem is intermittent, and non-reproducible. When it does happen, though, it seems to keep looping indefinitely: I've seen it use up hours of CPU time. Since it isn't reproducible, I haven't been able to run the debugger on it; I only found out exactly what statement was hanging by putting a diagnostic message before each statement, and having the user tell me what message is showing when it freezes. The statement is simply "drop table tmpex", so clearly the problem lies elsewhere. This is on a sun4, SunOS 4.1.2 with RDS 4.10.UC1. Has anyone seen anything like this before? I'd appreciate any suggestions of possible workarounds, ways to force the problem to reproduce itself, or word that it's been fixed in a later release. Thanks in advance, -- Harry Bochner bochner@das.harvard.edu