#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
\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
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
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