This isn't unique to OpenACS/AOLServer we see it with JBoss and other J2EE servers. Welcome to the wonderful world of stateless connections.
I might be wrong but I don't think the process is actually a zombie - surely the query will run to completion pass back the result and end. The fact that the result doesn't have anywhere to go is another matter.