version 0.3.26

[fms.git] / src / dbmaintenancethread.cpp

diff --git a/src/dbmaintenancethread.cpp b/src/dbmaintenancethread.cpp
index 3f4bdbc..0ecfeda 100644 (file)
--- a/src/dbmaintenancethread.cpp
+++ b/src/dbmaintenancethread.cpp
@@ -2,6 +2,7 @@
 #include "../include/stringfunctions.h"\r
 #include "../include/option.h"\r
 #include "../include/threadbuilder.h"\r
+#include "../include/dbsetup.h"\r
 \r
 #include <Poco/Timestamp.h>\r
 #include <Poco/Timespan.h>\r
@@ -36,6 +37,15 @@ DBMaintenanceThread::DBMaintenanceThread()
 \r
 void DBMaintenanceThread::Do10MinuteMaintenance()\r
 {\r
+       std::string ll="";\r
+       Option::Instance()->Get("LogLevel",ll);\r
+\r
+       // TODO - remove after corruption issue fixed\r
+       if(ll=="8")\r
+       {\r
+               std::string dbres=TestDBIntegrity();\r
+               m_log->trace("DBMaintenanceThread::Do10MinuteMaintenance() start TestDBIntegrity returned "+dbres);\r
+       }\r
 \r
        ThreadBuilder tb;\r
        SQLite3DB::Statement boardst=m_db->Prepare("SELECT BoardID FROM tblBoard WHERE Forum='true';");\r
@@ -71,6 +81,13 @@ void DBMaintenanceThread::Do10MinuteMaintenance()
                boardst.Step();\r
        }\r
 \r
+       // TODO - remove after corruption issue fixed\r
+       if(ll=="8")\r
+       {\r
+               std::string dbres=TestDBIntegrity();\r
+               m_log->trace("DBMaintenanceThread::Do10MinuteMaintenance() middle TestDBIntegrity returned "+dbres);\r
+       }\r
+\r
        // now rebuild threads where the message has been deleted\r
        SQLite3DB::Statement st=m_db->Prepare("SELECT tblThreadPost.MessageID, tblThread.BoardID FROM tblThreadPost INNER JOIN tblThread ON tblThreadPost.ThreadID=tblThread.ThreadID LEFT JOIN tblMessage ON tblThreadPost.MessageID=tblMessage.MessageID WHERE tblMessage.MessageID IS NULL;");\r
        st.Step();\r
@@ -87,6 +104,13 @@ void DBMaintenanceThread::Do10MinuteMaintenance()
                st.Step();\r
        }\r
 \r
+       // TODO - remove after corruption issue fixed\r
+       if(ll=="8")\r
+       {\r
+               std::string dbres=TestDBIntegrity();\r
+               m_log->trace("DBMaintenanceThread::Do10MinuteMaintenance() end TestDBIntegrity returned "+dbres);\r
+       }\r
+\r
        m_log->debug("PeriodicDBMaintenance::Do10MinuteMaintenance");\r
 }\r
 \r