[LON-CAPA-admin] lonsql_errors file

Hall, Jon jhall at btcatholic.org
Fri Mar 14 16:30:34 EDT 2008

Hi Stuart,

If I do a tail on the file, individual lines are several megabytes(!)
each, so I cannot copy a line into the email.

We have seen this behavior several times over the last year, on 2
different systems and on each release of the LC.

Any thoughts or suggestions are appreciated.

Jon Hall

-----Original Message-----
From: lon-capa-admin-admin at mail.lon-capa.org
[mailto:lon-capa-admin-admin at mail.lon-capa.org] On Behalf Of Stuart
Peter Raeburn
Sent: Friday, March 14, 2008 11:29 AM
To: lon-capa-admin at mail.lon-capa.org
Subject: Re: [LON-CAPA-admin] lonsql_errors file


Something is amiss if you're seeing a lonsql_errors file of several Gb.
What does tail -100 /home/httpd/perl/logs/lonsql_errors show? 

Apparently errors are being logged when 
/home/httpd/perl/parse_activity_log.pl is run. Of course errors are most

likely being logged at other times too. 

parse_activity_log.pl is run by the lonsql daemon when a student's
in LON-CAPA is displayed by a Course Coordinator using adm/trackstudent 
(called via the "View recent activity by this student" link a User's 
information page displayed to a CC in a course in which the student is 

Stuart Raeburn

Hall, Jon writes: 

> We have repeatedly seen our /home/httpd/perl/logs/lonsql_errors file
> grow to several Gb in size and always just deleted it, restarted
> loncontrol and httpd and been back up and running.  However, this time
> we also noticed that the file was being used by a "parse_activity"
> process and were wondering if this is an error on our system or some
> larger issue with lon capa. 

LON-CAPA-admin mailing list
LON-CAPA-admin at mail.lon-capa.org

More information about the LON-CAPA-admin mailing list