[OPEN-ILS-GENERAL] A new problem with reports

[Sharp, Chris]

Deana,

I would have your IT staff check the following:

1) whether clark-kent.pl is running on your server - can be done with 'ps aux | grep -i clark'.  You should see a process that says "Clark Kent, waiting for trouble", which is the daemon process waiting for reports to run.  If there are any reports running, you would also see "Clark Kent reporting: (name of report)" for each running report.

2) whether the report is listed in the database as currently running.  You can do this from the psql command line with "SELECT * FROM reporter.currently_running;"

If the "Clark Kent, waiting for trouble" process isn't running, no reports will run.  If the "Clark Kent reporting: (name of report)" process isn't running and the report is still listed in reporter.currently_running, that probably means that the clark kent process for that report died before it could finish and update the database to say it's done.

Feel free to respond here with more information and someone may be able to assist.

Hope that's helpful!

Chris

----- Original Message -----
> From: "Deana Cunningham" <deana.cunningham at granvillecounty.org>
> To: open-ils-general at list.georgialibraries.org
> Sent: Friday, December 6, 2013 11:53:40 AM
> Subject: [OPEN-ILS-GENERAL] A new problem with reports
> 
> 
> Hi all,
> 
> 
> We have been successfully running a statistics report that takes
> about 10 minutes to produce a result. Without changing anything
> overtly, the report has now been attempting to run for almost 36
> hours. Any suggestions?
> 
> 
> Thanks,
> 
> 
> Deana
> 
> 
> 
> Deana Cunningham
> Branch Manager, South Branch Library
> 1550 S. Campus Dr.
> Creedmoor, NC 27522
> Phone: (919) 528-1752
> Fax: (919) 528-1376
> deana.cunningham at granvillecounty.org

-- 
Chris Sharp
PINES System Administrator
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
csharp at georgialibraries.org
http://pines.georgialibraries.org/