private bool Run_BulkLoader(Worker_BulkLoader Prebuilder, bool Verbose) { try { bool returnValue = Prebuilder.Perform_BulkLoader(Verbose); if (Prebuilder.Aborted) { aborted = true; } return(returnValue); } catch (Exception ee) { return(false); } }
private void Run_BulkLoader( bool Verbose ) { // Create the local log directories if (!Directory.Exists(Engine_ApplicationCache_Gateway.Settings.Local_Log_Directory)) { Console.WriteLine("Creating local log directory: " + Engine_ApplicationCache_Gateway.Settings.Local_Log_Directory); Directory.CreateDirectory(Engine_ApplicationCache_Gateway.Settings.Local_Log_Directory); } // Determine the new log name string log_name = "incoming_" + controllerStarted.Year + "_" + controllerStarted.Month.ToString().PadLeft(2, '0') + "_" + controllerStarted.Day.ToString().PadLeft(2, '0') + ".html"; string local_log_name = Engine_ApplicationCache_Gateway.Settings.Local_Log_Directory + "\\" + log_name; // Create the new log file LogFileXhtml preloader_logger = new LogFileXhtml(local_log_name, "SobekCM Incoming Packages Log", "UFDC_Builder.exe", true); // Step through each database instance foreach (Database_Instance_Configuration dbConfig in Engine_ApplicationCache_Gateway.Settings.Database_Connections) { try { if (!dbConfig.Is_Active) { Console.WriteLine( dbConfig.Name + " is set to INACTIVE"); preloader_logger.AddNonError(dbConfig.Name + " is set to INACTIVE"); } else { SobekCM_Database.Connection_String = dbConfig.Connection_String; Library.Database.SobekCM_Database.Connection_String = dbConfig.Connection_String; Worker_BulkLoader newLoader = new Worker_BulkLoader(preloader_logger, verbose, dbConfig, (instances.Count > 1), logFileDirectory); newLoader.Perform_BulkLoader(Verbose); // Save information about this last run Library.Database.SobekCM_Database.Set_Setting("Builder Version", Engine_ApplicationCache_Gateway.Settings.Current_Builder_Version); Library.Database.SobekCM_Database.Set_Setting("Builder Last Run Finished", DateTime.Now.ToString()); Library.Database.SobekCM_Database.Set_Setting("Builder Last Message", newLoader.Final_Message); } } catch { } } }
private bool Run_BulkLoader(Worker_BulkLoader Prebuilder, bool Verbose) { try { bool returnValue = Prebuilder.Perform_BulkLoader( Verbose ); // Save information about this last run Library.Database.SobekCM_Database.Set_Setting("Builder Version", Engine_ApplicationCache_Gateway.Settings.Current_Builder_Version); Library.Database.SobekCM_Database.Set_Setting("Builder Last Run Finished", DateTime.Now.ToString()); Library.Database.SobekCM_Database.Set_Setting("Builder Last Message", Prebuilder.Final_Message); if (Prebuilder.Aborted) aborted = true; return returnValue; } catch ( Exception ) { return false; } }
/// <summary> Continuously execute the processes in a recurring background thread </summary> public void Execute_In_Background() { // Set the variable which will control background execution int time_between_polls = Engine_ApplicationCache_Gateway.Settings.Builder_Override_Seconds_Between_Polls; if (( time_between_polls < 0 ) || ( Engine_ApplicationCache_Gateway.Settings.Database_Connections.Count == 1 )) time_between_polls = Convert.ToInt32(Engine_ApplicationCache_Gateway.Settings.Builder.Seconds_Between_Polls); // Determine the new log name string log_name = "incoming_" + controllerStarted.Year + "_" + controllerStarted.Month.ToString().PadLeft(2, '0') + "_" + controllerStarted.Day.ToString().PadLeft(2, '0') + ".html"; string local_log_name = Engine_ApplicationCache_Gateway.Settings.Local_Log_Directory + "\\" + log_name; if (String.IsNullOrEmpty(Engine_ApplicationCache_Gateway.Settings.Local_Log_Directory)) { local_log_name = logFileDirectory + "\\" + log_name; } // Create the new log file LogFileXhtml preloader_logger = new LogFileXhtml(local_log_name, "SobekCM Incoming Packages Log", "UFDC_Builder.exe", true); // start with warnings on imagemagick and ghostscript not being installed if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.ImageMagick_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.ImageMagick_Executable))) { Console.WriteLine("WARNING: Could not find ImageMagick installed. Some image processing will be unavailable."); preloader_logger.AddNonError("WARNING: Could not find ImageMagick installed. Some image processing will be unavailable."); } if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.Ghostscript_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.Ghostscript_Executable))) { Console.WriteLine("WARNING: Could not find GhostScript installed. Some PDF processing will be unavailable."); preloader_logger.AddNonError("WARNING: Could not find GhostScript installed. Some PDF processing will be unavailable."); } // Set the time for the next feed building event to 10 minutes from now feedNextBuildTime = DateTime.Now.Add(new TimeSpan(0, 10, 0)); // First, step through each active configuration and see if building is currently aborted // while doing very minimal processes aborted = false; Console.WriteLine("Checking for initial abort condition"); preloader_logger.AddNonError("Checking for initial abort condition"); string abort_message = String.Empty; Builder_Operation_Flag_Enum abort_flag = Builder_Operation_Flag_Enum.STANDARD_OPERATION; foreach (Database_Instance_Configuration dbConfig in instances) { if ((!aborted) && (dbConfig.Is_Active) && (dbConfig.Can_Abort)) { SobekCM_Database.Connection_String = dbConfig.Connection_String; Library.Database.SobekCM_Database.Connection_String = dbConfig.Connection_String; // Check that this should not be skipped or aborted Builder_Operation_Flag_Enum operationFlag = Abort_Database_Mechanism.Builder_Operation_Flag; switch (operationFlag) { case Builder_Operation_Flag_Enum.ABORT_REQUESTED: case Builder_Operation_Flag_Enum.ABORTING: abort_message = "PREVIOUS ABORT flag found in " + dbConfig.Name; abort_flag = Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED; Console.WriteLine(abort_message); preloader_logger.AddNonError(abort_message); aborted = true; Abort_Database_Mechanism.Builder_Operation_Flag = Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED; break; case Builder_Operation_Flag_Enum.NO_BUILDING_REQUESTED: abort_message = "PREVIOUS NO BUILDING flag found in " + dbConfig.Name; Console.WriteLine(abort_message); preloader_logger.AddNonError(abort_message); aborted = true; break; } } } // If initially aborted, step through each instance and set a message if (aborted) { // Add messages in each active instance foreach (Database_Instance_Configuration dbConfig in instances) { if (dbConfig.Is_Active) { Console.WriteLine("Setting previous abort flag message in " + dbConfig.Name); preloader_logger.AddNonError("Setting previous abort flag message in " + dbConfig.Name); SobekCM_Database.Connection_String = dbConfig.Connection_String; Library.Database.SobekCM_Database.Connection_String = dbConfig.Connection_String; Library.Database.SobekCM_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", abort_message, String.Empty); // Save information about this last run Library.Database.SobekCM_Database.Set_Setting("Builder Version", Engine_ApplicationCache_Gateway.Settings.Current_Builder_Version); Library.Database.SobekCM_Database.Set_Setting("Builder Last Run Finished", DateTime.Now.ToString()); Library.Database.SobekCM_Database.Set_Setting("Builder Last Message", abort_message); // Finally, set the builder flag appropriately if (abort_flag != Builder_Operation_Flag_Enum.STANDARD_OPERATION) Abort_Database_Mechanism.Builder_Operation_Flag = abort_flag; } } // Do nothing else return; } // Build all the bulk loader objects List<Worker_BulkLoader> loaders = new List<Worker_BulkLoader>(); bool activeInstanceFound = false; foreach (Database_Instance_Configuration dbConfig in instances) { if (!dbConfig.Is_Active) { loaders.Add(null); Console.WriteLine(dbConfig.Name + " is set to INACTIVE"); preloader_logger.AddNonError(dbConfig.Name + " is set to INACTIVE"); } else { activeInstanceFound = true; SobekCM_Database.Connection_String = dbConfig.Connection_String; Library.Database.SobekCM_Database.Connection_String = dbConfig.Connection_String; // At this point warn on mossing the Ghostscript and ImageMagick, to get it into each instances database logs if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.ImageMagick_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.ImageMagick_Executable))) { Library.Database.SobekCM_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "WARNING: Could not find ImageMagick installed. Some image processing will be unavailable.", String.Empty); } if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.Ghostscript_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.Ghostscript_Executable))) { Library.Database.SobekCM_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "WARNING: Could not find GhostScript installed. Some PDF processing will be unavailable.", String.Empty); } Console.WriteLine(dbConfig.Name + " - Preparing to begin polling"); preloader_logger.AddNonError(dbConfig.Name + " - Preparing to begin polling"); Library.Database.SobekCM_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "Preparing to begin polling", String.Empty); Worker_BulkLoader newLoader = new Worker_BulkLoader(preloader_logger, verbose, dbConfig, (instances.Count > 1), logFileDirectory); loaders.Add(newLoader); } } // If no active instances, just exit if (!activeInstanceFound) { Console.WriteLine("No active databases in the config file"); preloader_logger.AddError("No active databases in config file... Aborting"); return; } // Set the maximum number of packages to process before moving to the next instance if (loaders.Count > 1) MultiInstance_Builder_Settings.Instance_Package_Limit = 100; bool firstRun = true; // Loop continually until the end hour is achieved do { // Is it time to build any RSS/XML feeds? if (DateTime.Compare(DateTime.Now, feedNextBuildTime) >= 0) { feedNextBuildTime = DateTime.Now.Add(new TimeSpan(0, 10, 0)); } bool skip_sleep = false; // Step through each instance for (int i = 0; i < instances.Count; i++) { if (loaders[i] != null) { // Get the instance Database_Instance_Configuration dbInstance = instances[i]; // Set the database connection strings Engine_Database.Connection_String = dbInstance.Connection_String; SobekCM_Database.Connection_String = dbInstance.Connection_String; Library.Database.SobekCM_Database.Connection_String = dbInstance.Connection_String; // Look for abort if ((dbInstance.Can_Abort) && (CheckForAbort())) { aborted = true; if (Abort_Database_Mechanism.Builder_Operation_Flag != Builder_Operation_Flag_Enum.NO_BUILDING_REQUESTED) { abort_flag = Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED; Abort_Database_Mechanism.Builder_Operation_Flag = Builder_Operation_Flag_Enum.ABORTING; } break; } // Refresh all settings, etc.. loaders[i].Refresh_Settings_And_Item_List(); // Pull the abort/pause flag Builder_Operation_Flag_Enum currentPauseFlag = Abort_Database_Mechanism.Builder_Operation_Flag; // If not paused, run the prebuilder if (currentPauseFlag != Builder_Operation_Flag_Enum.PAUSE_REQUESTED) { if (firstRun) { // // Always build an endeca feed first (so it occurs once a day) // if (Engine_ApplicationCache_Gateway.Settings.Build_MARC_Feed_By_Default) // { // Create_Complete_MarcXML_Feed(false); // } //} // CLear the old logs Console.WriteLine(dbInstance.Name + " - Expiring old log entries"); preloader_logger.AddNonError(dbInstance.Name + " - Expiring old log entries"); Library.Database.SobekCM_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "Expiring old log entries", String.Empty); Library.Database.SobekCM_Database.Builder_Expire_Log_Entries(Engine_ApplicationCache_Gateway.Settings.Builder.Log_Expiration_Days); // Rebuild all the static pages Console.WriteLine(dbInstance.Name + " - Rebuilding all static pages"); preloader_logger.AddNonError(dbInstance.Name + " - Rebuilding all static pages"); long staticRebuildLogId = Library.Database.SobekCM_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "Rebuilding all static pages", String.Empty); Static_Pages_Builder builder = new Static_Pages_Builder(Engine_ApplicationCache_Gateway.Settings.Servers.Application_Server_URL, Engine_ApplicationCache_Gateway.Settings.Servers.Static_Pages_Location, Engine_ApplicationCache_Gateway.URL_Portals.Default_Portal.Default_Web_Skin); builder.Rebuild_All_Static_Pages(preloader_logger, false, Engine_ApplicationCache_Gateway.Settings.Local_Log_Directory, dbInstance.Name, staticRebuildLogId); } skip_sleep = skip_sleep || Run_BulkLoader(loaders[i], verbose); // Look for abort if ((!aborted) && (dbInstance.Can_Abort) && (CheckForAbort())) { aborted = true; if (Abort_Database_Mechanism.Builder_Operation_Flag != Builder_Operation_Flag_Enum.NO_BUILDING_REQUESTED) { abort_flag = Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED; Abort_Database_Mechanism.Builder_Operation_Flag = Builder_Operation_Flag_Enum.ABORTING; } break; } } else { preloader_logger.AddNonError( dbInstance.Name + " - Building paused"); Library.Database.SobekCM_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "Building temporarily PAUSED", String.Empty); } } } if (aborted) break; // No longer the first run firstRun = false; // Publish the log publish_log_file(local_log_name); // Sleep for correct number of milliseconds if ( !skip_sleep ) Thread.Sleep(1000 * time_between_polls); } while (DateTime.Now.Hour < BULK_LOADER_END_HOUR); // Do the final work for all of the different dbInstances if (!aborted) { for (int i = 0; i < instances.Count; i++) { if (loaders[i] != null) { // Get the instance Database_Instance_Configuration dbInstance = instances[i]; // Set the database flag SobekCM_Database.Connection_String = dbInstance.Connection_String; Library.Database.SobekCM_Database.Connection_String = dbInstance.Connection_String; // Pull the abort/pause flag Builder_Operation_Flag_Enum currentPauseFlag2 = Abort_Database_Mechanism.Builder_Operation_Flag; // If not paused, run the prebuilder if (currentPauseFlag2 != Builder_Operation_Flag_Enum.PAUSE_REQUESTED) { // Initiate the recreation of the links between metadata and collections Library.Database.SobekCM_Database.Admin_Update_Cached_Aggregation_Metadata_Links(); } // Clear the memory loaders[i].ReleaseResources(); } } } else { // Mark the aborted in each instance foreach (Database_Instance_Configuration dbConfig in instances ) { if (dbConfig.Is_Active) { Console.WriteLine("Setting abort flag message in " + dbConfig.Name); preloader_logger.AddNonError("Setting abort flag message in " + dbConfig.Name); SobekCM_Database.Connection_String = dbConfig.Connection_String; Library.Database.SobekCM_Database.Connection_String = dbConfig.Connection_String; Library.Database.SobekCM_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "Building ABORTED per request from database key", String.Empty); // Save information about this last run Library.Database.SobekCM_Database.Set_Setting("Builder Version", Engine_ApplicationCache_Gateway.Settings.Current_Builder_Version); Library.Database.SobekCM_Database.Set_Setting("Builder Last Run Finished", DateTime.Now.ToString()); Library.Database.SobekCM_Database.Set_Setting("Builder Last Message", "Building ABORTED per request"); // Finally, set the builder flag appropriately if ( abort_flag == Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED ) Abort_Database_Mechanism.Builder_Operation_Flag = Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED; } } } // Publish the log publish_log_file(local_log_name); //// Initiate a solr/lucene index optimization since we are done loading for a while //if (DateTime.Now.Day % 2 == 0) //{ // if (Engine_ApplicationCache_Gateway.Settings.Document_Solr_Index_URL.Length > 0) // { // Console.WriteLine("Initiating Solr/Lucene document index optimization"); // Solr_Controller.Optimize_Document_Index(Engine_ApplicationCache_Gateway.Settings.Document_Solr_Index_URL); // } //} //else //{ // if (Engine_ApplicationCache_Gateway.Settings.Page_Solr_Index_URL.Length > 0) // { // Console.WriteLine("Initiating Solr/Lucene page index optimization"); // Solr_Controller.Optimize_Page_Index(Engine_ApplicationCache_Gateway.Settings.Page_Solr_Index_URL); // } //} //// Sleep for twenty minutes to end this (the index rebuild might take some time) //Thread.Sleep(1000 * 20 * 60); }
/// <summary> Continuously execute the processes in a recurring background thread </summary> public void Execute_In_Background() { // Set the variable which will control background execution int time_between_polls = Engine_ApplicationCache_Gateway.Settings.Builder.Override_Seconds_Between_Polls.HasValue ? Engine_ApplicationCache_Gateway.Settings.Builder.Override_Seconds_Between_Polls.Value : 60; if ((time_between_polls < 0) || (MultiInstance_Builder_Settings.Instances.Count == 1)) { time_between_polls = Convert.ToInt32(Engine_ApplicationCache_Gateway.Settings.Builder.Seconds_Between_Polls); } // Determine the new log name string log_name = "incoming_" + controllerStarted.Year + "_" + controllerStarted.Month.ToString().PadLeft(2, '0') + "_" + controllerStarted.Day.ToString().PadLeft(2, '0') + ".html"; string local_log_name = Path.Combine(logFileDirectory, log_name); // Create the new log file LogFileXhtml preloader_logger = new LogFileXhtml(local_log_name, "SobekCM Incoming Packages Log", "UFDC_Builder.exe", true); // start with warnings on imagemagick and ghostscript not being installed if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.ImageMagick_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.ImageMagick_Executable))) { Console.WriteLine("WARNING: Could not find ImageMagick installed. Some image processing will be unavailable."); preloader_logger.AddNonError("WARNING: Could not find ImageMagick installed. Some image processing will be unavailable."); } if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.Ghostscript_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.Ghostscript_Executable))) { Console.WriteLine("WARNING: Could not find GhostScript installed. Some PDF processing will be unavailable."); preloader_logger.AddNonError("WARNING: Could not find GhostScript installed. Some PDF processing will be unavailable."); } // Set the time for the next feed building event to 10 minutes from now feedNextBuildTime = DateTime.Now.Add(new TimeSpan(0, 10, 0)); // First, step through each active configuration and see if building is currently aborted // while doing very minimal processes aborted = false; Console.WriteLine("Checking for initial abort condition"); preloader_logger.AddNonError("Checking for initial abort condition"); string abort_message = String.Empty; int build_instances = 0; foreach (Single_Instance_Configuration dbConfig in instances) { if (!dbConfig.Is_Active) { Console.WriteLine(dbConfig.Name + " is set to INACTIVE"); preloader_logger.AddNonError(dbConfig.Name + " is set to INACTIVE"); } else { SobekCM_Item_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String; Engine_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String; // Check that this should not be skipped or aborted Builder_Operation_Flag_Enum operationFlag = Abort_Database_Mechanism.Builder_Operation_Flag; switch (operationFlag) { case Builder_Operation_Flag_Enum.ABORT_REQUESTED: case Builder_Operation_Flag_Enum.ABORTING: // Since this was an abort request at the very beginning, switch back to standard Abort_Database_Mechanism.Builder_Operation_Flag = Builder_Operation_Flag_Enum.STANDARD_OPERATION; build_instances++; break; case Builder_Operation_Flag_Enum.NO_BUILDING_REQUESTED: abort_message = "PREVIOUS NO BUILDING flag found in " + dbConfig.Name; Console.WriteLine(abort_message); preloader_logger.AddNonError(abort_message); break; default: build_instances++; break; } } } // If no instances to run just abort if (build_instances == 0) { // Add messages in each active instance foreach (Single_Instance_Configuration dbConfig in instances) { if (dbConfig.Is_Active) { Console.WriteLine("No active databases set for building in the config file"); preloader_logger.AddError("No active databases set for building in config file... Aborting"); SobekCM_Item_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String; Engine_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String; Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", abort_message, String.Empty); // Save information about this last run Engine_Database.Set_Setting("Builder Version", Engine_ApplicationCache_Gateway.Settings.Static.Current_Builder_Version); Engine_Database.Set_Setting("Builder Last Run Finished", DateTime.Now.ToString()); Engine_Database.Set_Setting("Builder Last Message", abort_message); } } // Do nothing else return; } // Build all the bulk loader objects List <Worker_BulkLoader> loaders = new List <Worker_BulkLoader>(); foreach (Single_Instance_Configuration dbConfig in instances) { if (!dbConfig.Is_Active) { loaders.Add(null); continue; } SobekCM_Item_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String; Engine_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String; // At this point warn on mossing the Ghostscript and ImageMagick, to get it into each instances database logs if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.ImageMagick_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.ImageMagick_Executable))) { Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "WARNING: Could not find ImageMagick installed. Some image processing will be unavailable.", String.Empty); } if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.Ghostscript_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.Ghostscript_Executable))) { Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "WARNING: Could not find GhostScript installed. Some PDF processing will be unavailable.", String.Empty); } Console.WriteLine(dbConfig.Name + " - Preparing to begin polling"); preloader_logger.AddNonError(dbConfig.Name + " - Preparing to begin polling"); Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "Preparing to begin polling", String.Empty); // Create the new bulk loader Worker_BulkLoader newLoader = new Worker_BulkLoader(preloader_logger, dbConfig, verbose, logFileDirectory, pluginRootDirectory); // Try to refresh to test database and engine connectivity if (newLoader.Refresh_Settings_And_Item_List()) { loaders.Add(newLoader); } else { Console.WriteLine(dbConfig.Name + " - Error pulling setting of configuration information"); preloader_logger.AddError(dbConfig.Name + " - Error pulling setting of configuration information"); } } // If no loaders past the tests above, done if (loaders.Count == 0) { Console.WriteLine("Aborting since no valid instances found to process"); preloader_logger.AddError("Aborting since no valid instances found to process"); return; } // Set the maximum number of packages to process before moving to the next instance if (loaders.Count > 1) { MultiInstance_Builder_Settings.Instance_Package_Limit = 100; } bool firstRun = true; // Loop continually until the end hour is achieved Builder_Operation_Flag_Enum abort_flag = Builder_Operation_Flag_Enum.STANDARD_OPERATION; do { // Is it time to build any RSS/XML feeds? if (DateTime.Compare(DateTime.Now, feedNextBuildTime) >= 0) { feedNextBuildTime = DateTime.Now.Add(new TimeSpan(0, 10, 0)); } bool skip_sleep = false; // Step through each instance for (int i = 0; i < loaders.Count; i++) { if (loaders[i] != null) { // Get the instance Single_Instance_Configuration dbInstance = instances[i]; // Set the database connection strings Engine_Database.Connection_String = dbInstance.DatabaseConnection.Connection_String; SobekCM_Item_Database.Connection_String = dbInstance.DatabaseConnection.Connection_String; // Look for abort if (CheckForAbort()) { aborted = true; if (Abort_Database_Mechanism.Builder_Operation_Flag != Builder_Operation_Flag_Enum.NO_BUILDING_REQUESTED) { abort_flag = Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED; Abort_Database_Mechanism.Builder_Operation_Flag = Builder_Operation_Flag_Enum.ABORTING; } break; } // Refresh all settings, etc.. loaders[i].Refresh_Settings_And_Item_List(); // Pull the abort/pause flag Builder_Operation_Flag_Enum currentPauseFlag = Abort_Database_Mechanism.Builder_Operation_Flag; // If not paused, run the prebuilder if (currentPauseFlag != Builder_Operation_Flag_Enum.PAUSE_REQUESTED) { skip_sleep = skip_sleep || Run_BulkLoader(loaders[i], verbose); // Look for abort if ((!aborted) && (CheckForAbort())) { aborted = true; if (Abort_Database_Mechanism.Builder_Operation_Flag != Builder_Operation_Flag_Enum.NO_BUILDING_REQUESTED) { abort_flag = Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED; Abort_Database_Mechanism.Builder_Operation_Flag = Builder_Operation_Flag_Enum.ABORTING; } break; } } else { preloader_logger.AddNonError(dbInstance.Name + " - Building paused"); Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "Building temporarily PAUSED", String.Empty); } } } if (aborted) { break; } // Publish the log publish_log_file(local_log_name); // Sleep for correct number of milliseconds if (!skip_sleep) { Thread.Sleep(1000 * time_between_polls); } } while (DateTime.Now.Hour < BULK_LOADER_END_HOUR); // Do the final work for all of the different dbInstances if (!aborted) { for (int i = 0; i < instances.Count; i++) { if (loaders[i] != null) { // Get the instance Single_Instance_Configuration dbInstance = instances[i]; // Set the database flag SobekCM_Item_Database.Connection_String = dbInstance.DatabaseConnection.Connection_String; Engine_Database.Connection_String = dbInstance.DatabaseConnection.Connection_String; // Pull the abort/pause flag Builder_Operation_Flag_Enum currentPauseFlag2 = Abort_Database_Mechanism.Builder_Operation_Flag; // If not paused, run the prebuilder if (currentPauseFlag2 != Builder_Operation_Flag_Enum.PAUSE_REQUESTED) { // Initiate the recreation of the links between metadata and collections Engine_Database.Admin_Update_Cached_Aggregation_Metadata_Links(); } // Clear the memory loaders[i].ReleaseResources(); } } } else { // Mark the aborted in each instance foreach (Single_Instance_Configuration dbConfig in instances) { if (dbConfig.Is_Active) { Console.WriteLine("Setting abort flag message in " + dbConfig.Name); preloader_logger.AddNonError("Setting abort flag message in " + dbConfig.Name); SobekCM_Item_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String; Engine_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String; Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "Building ABORTED per request from database key", String.Empty); // Save information about this last run Engine_Database.Set_Setting("Builder Version", Engine_ApplicationCache_Gateway.Settings.Static.Current_Builder_Version); Engine_Database.Set_Setting("Builder Last Run Finished", DateTime.Now.ToString()); Engine_Database.Set_Setting("Builder Last Message", "Building ABORTED per request"); // Finally, set the builder flag appropriately if (abort_flag == Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED) { Abort_Database_Mechanism.Builder_Operation_Flag = Builder_Operation_Flag_Enum.LAST_EXECUTION_ABORTED; } } } } // Publish the log publish_log_file(local_log_name); //// Initiate a solr/lucene index optimization since we are done loading for a while //if (DateTime.Now.Day % 2 == 0) //{ // if (Engine_ApplicationCache_Gateway.Settings.Document_Solr_Index_URL.Length > 0) // { // Console.WriteLine("Initiating Solr/Lucene document index optimization"); // Solr_Controller.Optimize_Document_Index(Engine_ApplicationCache_Gateway.Settings.Document_Solr_Index_URL); // } //} //else //{ // if (Engine_ApplicationCache_Gateway.Settings.Page_Solr_Index_URL.Length > 0) // { // Console.WriteLine("Initiating Solr/Lucene page index optimization"); // Solr_Controller.Optimize_Page_Index(Engine_ApplicationCache_Gateway.Settings.Page_Solr_Index_URL); // } //} //// Sleep for twenty minutes to end this (the index rebuild might take some time) //Thread.Sleep(1000 * 20 * 60); }
private bool Configure_Builders_To_Run(LogFileXhtml PreloaderLogger) { // Verify connectivity and rights on the logs subfolder if (!Directory.Exists(logFileDirectory)) { try { Directory.CreateDirectory(logFileDirectory); } catch { Console.WriteLine("Error creating necessary logs subfolder under the application folder.\n"); Console.WriteLine("Please create manually.\n"); Console.WriteLine(logFileDirectory); return(false); } } try { StreamWriter testWriter = new StreamWriter(Path.Combine(logFileDirectory, "test.log"), false); testWriter.WriteLine("TEST"); testWriter.Flush(); testWriter.Close(); File.Delete(Path.Combine(logFileDirectory, "test.log")); } catch { Console.WriteLine("The service account needs modify rights on the logs subfolder.\n"); Console.WriteLine("Please correct manually.\n"); Console.WriteLine(logFileDirectory); return(false); } // Verify connectivity and rights on the plugins subfolder if (!Directory.Exists(pluginRootDirectory)) { try { Directory.CreateDirectory(pluginRootDirectory); } catch { Console.WriteLine("Error creating necessary plugins subfolder under the application folder.\n"); Console.WriteLine("Please create manually.\n"); Console.WriteLine(pluginRootDirectory); return(false); } } try { StreamWriter testWriter = new StreamWriter(Path.Combine(pluginRootDirectory, "test.log"), false); testWriter.WriteLine("TEST"); testWriter.Flush(); testWriter.Close(); File.Delete(Path.Combine(pluginRootDirectory, "test.log")); } catch { Console.WriteLine("The service account needs modify rights on the plugins subfolder.\n"); Console.WriteLine("Please correct manually.\n"); Console.WriteLine(pluginRootDirectory); return(false); } // Now, veryify the configuration file exists configurationFile = Path.Combine(MultiInstance_Builder_Settings.Builder_Executable_Directory, "config", "sobekcm.config"); if (!File.Exists(configurationFile)) { write_error("The configuration file is missing!!", PreloaderLogger); write_error("Execution aborted due to missing configuration file.", PreloaderLogger); return(false); } // Should be a config file now, so read it if (!MultiInstance_Builder_Settings_Reader.Read_Config(configurationFile)) { write_error("Error encountered reading the configuration file!!", PreloaderLogger); write_error("Execution aborted due to incorrect configuration file.", PreloaderLogger); return(false); } // Since the configuration was read, save the time configReadTime = DateTime.Now; // If no instances exist, then the builder has nothing to do if ((MultiInstance_Builder_Settings.Instances.Count == 0) || (String.IsNullOrEmpty(MultiInstance_Builder_Settings.Instances[0].DatabaseConnection.Connection_String))) { write_error("No instances listed in the congfiguration file", PreloaderLogger); write_error("Execution aborted due to configuration file not including any instances to process", PreloaderLogger); return(false); } // This is a bit of shortcut in the case there is only one instance if (MultiInstance_Builder_Settings.Instances.Count == 1) { // If no database connection on the single instance, return if (String.IsNullOrEmpty(MultiInstance_Builder_Settings.Instances[0].DatabaseConnection.Connection_String)) { write_error("Single instance configuration is missing the database connection string", PreloaderLogger); write_error("Execution aborted", PreloaderLogger); return(false); } Engine_Database.Connection_String = MultiInstance_Builder_Settings.Instances[0].DatabaseConnection.Connection_String; if (!Engine_Database.Test_Connection()) { write_error("Unable to connect to the database using provided connection string:", PreloaderLogger); write_error(Engine_Database.Connection_String, PreloaderLogger); write_error("Execution aborted", PreloaderLogger); return(false); } } // Look for the valid Image magick file information in the registry and configuration if ((String.IsNullOrEmpty(Engine_ApplicationCache_Gateway.Settings.Builder.ImageMagick_Executable)) || (!File.Exists(Engine_ApplicationCache_Gateway.Settings.Builder.ImageMagick_Executable))) { string possible_imagemagick = Look_For_Variable_Registry_Key("SOFTWARE\\ImageMagick", "BinPath"); if ((!String.IsNullOrEmpty(possible_imagemagick)) && (Directory.Exists(possible_imagemagick)) && (File.Exists(Path.Combine(possible_imagemagick, "convert.exe")))) { MultiInstance_Builder_Settings.ImageMagick_Executable = Path.Combine(possible_imagemagick, "convert.exe"); } } else { MultiInstance_Builder_Settings.ImageMagick_Executable = Engine_ApplicationCache_Gateway.Settings.Builder.ImageMagick_Executable; } // If no ImageMagick file found, add a warning if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.ImageMagick_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.ImageMagick_Executable))) { write_nonerror("WARNING: Could not find ImageMagick installed. Some image processing will be unavailable.", PreloaderLogger); } // Look for a valid ghostscript file information in the registry and configuration if ((String.IsNullOrEmpty(Engine_ApplicationCache_Gateway.Settings.Builder.Ghostscript_Executable)) || (!File.Exists(Engine_ApplicationCache_Gateway.Settings.Builder.Ghostscript_Executable))) { string possible_ghost = Look_For_Variable_Registry_Key("SOFTWARE\\GPL Ghostscript", "GS_DLL"); if (!String.IsNullOrEmpty(possible_ghost)) { string gsPath = Path.GetDirectoryName(possible_ghost); if ((!String.IsNullOrEmpty(gsPath)) && (Directory.Exists(gsPath)) && ((File.Exists(Path.Combine(gsPath, "gswin32c.exe"))) || (File.Exists(Path.Combine(gsPath, "gswin64c.exe"))))) { if (File.Exists(Path.Combine(gsPath, "gswin64c.exe"))) { MultiInstance_Builder_Settings.Ghostscript_Executable = Path.Combine(gsPath, "gswin64c.exe"); } else { MultiInstance_Builder_Settings.Ghostscript_Executable = Path.Combine(gsPath, "gswin32c.exe"); } } } } else { MultiInstance_Builder_Settings.Ghostscript_Executable = Engine_ApplicationCache_Gateway.Settings.Builder.Ghostscript_Executable; } // If no Ghostscript file found, add a warning if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.Ghostscript_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.Ghostscript_Executable))) { write_nonerror("WARNING: Could not find GhostScript installed. Some PDF processing will be unavailable.", PreloaderLogger); } // Save the list of instances instances.Clear(); foreach (Single_Instance_Configuration dbInfo in MultiInstance_Builder_Settings.Instances) { instances.Add(dbInfo); } // First, step through each active configuration and see if building is currently aborted // while doing very minimal processes aborted = false; write_nonerror("Checking for initial abort condition", PreloaderLogger); string abort_message = String.Empty; int build_instances = 0; foreach (Single_Instance_Configuration dbConfig in instances) { if (!dbConfig.Is_Active) { write_nonerror(dbConfig.Name + " is set to INACTIVE", PreloaderLogger); } else { SobekCM_Item_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String; Engine_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String; // Check that this should not be skipped or aborted Builder_Operation_Flag_Enum operationFlag = Abort_Database_Mechanism.Builder_Operation_Flag; switch (operationFlag) { case Builder_Operation_Flag_Enum.ABORT_REQUESTED: case Builder_Operation_Flag_Enum.ABORTING: // Since this was an abort request at the very beginning, switch back to standard Abort_Database_Mechanism.Builder_Operation_Flag = Builder_Operation_Flag_Enum.STANDARD_OPERATION; build_instances++; break; case Builder_Operation_Flag_Enum.NO_BUILDING_REQUESTED: abort_message = "PREVIOUS NO BUILDING flag found in " + dbConfig.Name; write_nonerror(abort_message, PreloaderLogger); break; default: build_instances++; break; } } } // If no instances to run just abort if (build_instances == 0) { // Add messages in each active instance foreach (Single_Instance_Configuration dbConfig in instances) { if (dbConfig.Is_Active) { write_error("No active databases set for building in config file... Aborting", PreloaderLogger); SobekCM_Item_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String; Engine_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String; Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", abort_message, String.Empty); // Save information about this last run Engine_Database.Set_Setting("Builder Version", Engine_ApplicationCache_Gateway.Settings.Static.Current_Builder_Version); Engine_Database.Set_Setting("Builder Last Run Finished", DateTime.Now.ToString()); Engine_Database.Set_Setting("Builder Last Message", abort_message); } } // Do nothing else return(false); } // Build all the bulk loader objects loaders.Clear(); foreach (Single_Instance_Configuration dbConfig in instances) { if (!dbConfig.Is_Active) { loaders.Add(null); continue; } SobekCM_Item_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String; Engine_Database.Connection_String = dbConfig.DatabaseConnection.Connection_String; // At this point warn on mossing the Ghostscript and ImageMagick, to get it into each instances database logs if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.ImageMagick_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.ImageMagick_Executable))) { Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "WARNING: Could not find ImageMagick installed. Some image processing will be unavailable.", String.Empty); } if ((String.IsNullOrEmpty(MultiInstance_Builder_Settings.Ghostscript_Executable)) || (!File.Exists(MultiInstance_Builder_Settings.Ghostscript_Executable))) { Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "WARNING: Could not find GhostScript installed. Some PDF processing will be unavailable.", String.Empty); } write_nonerror(dbConfig.Name + " - Preparing to begin polling", PreloaderLogger); Engine_Database.Builder_Add_Log_Entry(-1, String.Empty, "Standard", "Preparing to begin polling", String.Empty); // Create the new bulk loader Worker_BulkLoader newLoader = new Worker_BulkLoader(PreloaderLogger, dbConfig, verbose, logFileDirectory, pluginRootDirectory); // Try to refresh to test database and engine connectivity if (newLoader.Refresh_Settings_And_Item_List()) { loaders.Add(newLoader); } else { write_error(dbConfig.Name + " - Error pulling setting of configuration information", PreloaderLogger); } } // If no loaders past the tests above, done if (loaders.Count == 0) { write_error("Aborting since no valid instances found to process", PreloaderLogger); return(false); } // Set the maximum number of packages to process before moving to the next instance if (loaders.Count > 1) { MultiInstance_Builder_Settings.Instance_Package_Limit = 100; } return(true); }
private bool Run_BulkLoader(Worker_BulkLoader Prebuilder, bool Verbose) { try { bool returnValue = Prebuilder.Perform_BulkLoader( Verbose ); if (Prebuilder.Aborted) aborted = true; return returnValue; } catch ( Exception ee ) { return false; } }