[Babase] Queries that run forever

Karl O. Pinc kop at meme.com
Thu Jan 25 19:17:52 EST 2007


Tyler,

I just killed two queries of yours that appeared to be
running forever.  I hope you didn't need
them. You can't just disconnect from the
db, the queries won't stop.  It's not good to leave them
running and sucking up resources.

I don't know that we ever figured out the right way
to use ppa to stop the queries.  (There's probably
a way to do it by logging in on another computer
and using the "process" button.)  Regardless,
the best way for you to kill them is probably to
ssh to papio and use the Unix kill command
to kill the appropriate "postmaster" process.

If you need more detail on this let me know.

If you have trouble with a query that shouldn't
run forever please let me know.  We may need to
add an index or something to the db.


Karl <kop at meme.com>
Free Software:  "You don't pay back, you pay forward."
                  -- Robert A. Heinlein



More information about the Babase mailing list