[1082] in Moira
qgli problems ?
daemon@ATHENA.MIT.EDU (Matt)
Mon Feb 24 19:29:16 1997
Date: Mon, 24 Feb 1997 19:29:02 -0500
From: Matt <matt@MIT.EDU>
To: bug-moira@MIT.EDU
I noticed a couple of log messages about a number of queries with a couple
of thousand rows:
Feb 24 19:03:14 moirad[#30558]: auth[2]: "\004\006\002ATHENA.MIT.EDU", "listmaint"
Feb 24 19:03:14 moirad[#30558]: Auth to <xxxxxxx>@ATHENA.MIT.EDU using listmain, uid 75976 cid 75976
Feb 24 19:03:14 moirad[#30558]: query[2]: "qualified_get_lists", "TRUE", "TRUE", "FALSE", "TRUE", "DONTCARE"
Feb 24 19:03:26 moirad[#30558]: Server ran out of memory (Query failed)
Feb 24 19:03:26 moirad[#30558]: attempted query qualified_get_lists with 2049 rows
Feb 24 19:03:26
Feb 24 19:03:26 moirad[#30558]: Query complete.
I noticed in the logs that there were 4 incidents of this in the last 2000 log
lines) from 3 different users (not including my test)
There are a couple of problems here
1) What are the users trying to do here? It looks like they are trying to do a
'get all public lists', which we might want to make harder to do or something
(the data is in the info locker)
2) It does actually report back some of the lists, is that the desired
behavior? (for the failure)
3) Why is it that the same query suceeds on ttsp?
4) What is with the empty log line ?
5) Are we hitting a process size limit? since we appear to have plenty of
virtual memory free?
It is however very nice that it takes only 12 seconds to fail :-)
Matt