protected void worker_DoWork(object sender, DoWorkEventArgs e)
{
int wait = 15;
for (int i = 0; i < wait * 100; i++)
{
// The sleep should happen on the worker thread rather than the application thread
System.Threading.Thread.Sleep(10);
if (e.Cancel)
{
// Poll the thread every [wait] seconds to work out if the worker should be cancelled
return;
}
}
//HttpContext.Current = (HttpContext)e.Argument;
Mysql db = new Mysql(WebConfigurationManager.AppSettings["mysql-user"],
WebConfigurationManager.AppSettings["mysql-password"],
WebConfigurationManager.AppSettings["mysql-database"],
WebConfigurationManager.AppSettings["mysql-host"]);
Core core = new Core(db);
string processViews = WebConfigurationManager.AppSettings["queue-process-views"];
if (!string.IsNullOrEmpty(processViews) && processViews.ToLower() == "true")
{
try
{
ItemView.ProcessViews(core);
}
catch (Exception ex)
{
InsertQuery iQuery = new InsertQuery(typeof(ApplicationError));
iQuery.AddField("error_title", "An Error occured at " + Hyperlink.Domain + " in global.asax");
iQuery.AddField("error_body", "EXCEPTION THROWN:\n" + ex.ToString());
core.Db.Query(iQuery);
}
}
string cronApplication = WebConfigurationManager.AppSettings["queue-cron-application"];
if (!string.IsNullOrEmpty(cronApplication))
{
List<ApplicationEntry> aes = new List<ApplicationEntry>();
if (cronApplication == "*")
{
aes.AddRange(core.GetCronApplications());
}
else
{
ApplicationEntry ae = core.GetApplication(cronApplication);
if (ae != null)
{
BoxSocial.Internals.Application.LoadApplication(core, AppPrimitives.Any, ae);
aes.Add(ae);
}
}
foreach (ApplicationEntry ae in aes)
{
if (UnixTime.UnixTimeStamp() % ae.CronFrequency < 15)
{
Application jobApplication = BoxSocial.Internals.Application.GetApplication(core, AppPrimitives.Any, ae);
if (jobApplication != null)
{
try
{
if (!jobApplication.ExecuteCron())
{
StringBuilder failedCronLog = new StringBuilder();
failedCronLog.AppendLine("Application Id: " + ae.ApplicationId);
InsertQuery iQuery = new InsertQuery(typeof(ApplicationError));
iQuery.AddField("error_title", "Cron failed at " + Hyperlink.Domain);
iQuery.AddField("error_body", "FAILED CRON:\n" + failedCronLog.ToString());
core.Db.Query(iQuery);
}
}
catch (Exception ex)
{
InsertQuery iQuery = new InsertQuery(typeof(ApplicationError));
iQuery.AddField("error_title", "An Error occured at " + Hyperlink.Domain + " in global.asax");
iQuery.AddField("error_body", "EXCEPTION THROWN:\n" + ex.ToString() + "\n\n" + core.Console.ToString());
core.Db.Query(iQuery);
}
}
}
}
}
try
{
bool flag = false;
lock (queueLock)
{
if (queue != null)
{
flag = true;
}
}
if (flag)
{
int failedJobs = 0;
// Retrieve Jobs
Dictionary<string, int> queues = new Dictionary<string, int>();
queues.Add(WebConfigurationManager.AppSettings["queue-default-priority"], 10);
StringBuilder failedJobsLog = new StringBuilder();
foreach (string queueName in queues.Keys)
{
List<Job> jobs = null;
lock (queueLock)
{
try
{
jobs = Queue.ClaimJobs(queueName, queues[queueName]);
}
catch
{
return;
}
}
foreach (Job job in jobs)
{
core.LoadUserProfile(job.UserId);
}
foreach (Job job in jobs)
{
core.CreateNewSession(core.PrimitiveCache[job.UserId]);
// Load Application
if (job.ApplicationId > 0)
{
ApplicationEntry ae = core.GetApplication(job.ApplicationId);
BoxSocial.Internals.Application.LoadApplication(core, AppPrimitives.Any, ae);
}
// Execute Job
if (core.InvokeJob(job))
{
lock (queueLock)
{
Queue.DeleteJob(job);
}
}
else
{
failedJobs++;
//queue.ReleaseJob(job);
#if DEBUG
failedJobsLog.AppendLine("Application Id: " + job.ApplicationId);
failedJobsLog.AppendLine("Item Id: " + job.ItemId);
failedJobsLog.AppendLine("Item Type Id: " + job.ItemTypeId);
failedJobsLog.AppendLine("Function: " + job.Function);
failedJobsLog.AppendLine("Body: " + job.Body);
failedJobsLog.AppendLine("Message: " + job.Message);
failedJobsLog.AppendLine("Error: " + job.Error);
failedJobsLog.AppendLine("====================");
#endif
}
}
}
if (failedJobs > 0)
{
InsertQuery iQuery = new InsertQuery(typeof(ApplicationError));
iQuery.AddField("error_title", "Jobs failed at " + Hyperlink.Domain);
iQuery.AddField("error_body", "FAILED JOB COUNT:\n" + failedJobs.ToString() + "\n\n" + failedJobsLog.ToString());
core.Db.Query(iQuery);
#if DEBUG
core.Email.SendEmail(WebConfigurationManager.AppSettings["error-email"], "Jobs failed at " + Hyperlink.Domain, "FAILED JOB COUNT:\n" + failedJobs.ToString() + "\n\n" + failedJobsLog.ToString());
#endif
}
}
}
catch (Exception ex)
{
try
{
InsertQuery iQuery = new InsertQuery(typeof(ApplicationError));
iQuery.AddField("error_title", "An Error occured at " + Hyperlink.Domain + " in global.asax");
iQuery.AddField("error_body", "EXCEPTION THROWN:\n" + ex.ToString());
core.Db.Query(iQuery);
core.Email.SendEmail(WebConfigurationManager.AppSettings["error-email"], "An Error occured at " + Hyperlink.Domain + " in global.asax", "EXCEPTION THROWN:\n" + ex.ToString());
}
catch
{
try
{
core.Email.SendEmail(WebConfigurationManager.AppSettings["error-email"], "An Error occured at " + Hyperlink.Domain + " in global.asax", "EXCEPTION THROWN:\n" + ex.ToString());
}
catch
{
}
}
}
// Cleanup
lock (queueLock)
{
if (queue != null)
{
Queue.CloseConnection();
Queue = null;
}
}
core.CloseProse();
core.CloseSearch();
core.CloseCache();
core = null;
db.CloseConnection();
db = null;
}
