Hi Geoff,
I think killing clark-kent is a bit brute force, but I've done it myself
on a few occasions for bad runaway reports.
I'd also suggest a look over
http://evergreen-ils.org/dokuwiki/doku.php?id=scratchpad:random_magic_spells#cancel_query_report
to see how one would cancel a report from the database side of things.
I also use SELECT * FROM reporter.currently_running; to see what reports
are holding up the line too.
-- Ben
On 11/15/2012 03:45 PM, Geoff Sams wrote:
My library is having trouble with the reports interface. It seems
like something may have clogged up our system somehow and now reports
are not running. I've restarted the service and made sure that it is
running properly but reports are still not running. I figured at this
point the best action would be to purge pending reports? I'm not
really sure how to go about that from the system as asking everyone to
delete pending reports would take far too long and be very
unpredictable. Any assistance on this matter would be greatly
appreciated!
Thanks,
Geoff Sams
Roanoke Public Library
817-491-2691
--
Benjamin Shum
Open Source Software Coordinator
Bibliomation, Inc.
32 Crest Road
Middlebury, CT 06762
203-577-4070, ext. 113