Ask the Community
Groups
How Do I Repair An Error with a Traverse Database - Connect IT Community | Kaseya
<main> <article class="userContent"> <div> <p><strong>QUESTION:</strong></p> <p>How Do I Repair An Database Error (corruption, table crash)?</p> <p><strong>SOLUTION:</strong></p> <p>(this article applies to the DGE and to the BVE)</p> <p>In the event of a database error (see example log entries below from error.log) due to improper shutdown/power failure, running out of disk space, or improper access by an external applications, a database repair may be required.</p> <p>Examples:<br><br>2009-05-18 11:17:30,438 message.RemoveExpiredMessagesFromLiveDb<br>[ThreadPool[PooledCommandRunner$PooledCommandRunnerHelper]]: <br>(ERROR) Failed to execute command: Table '.\liveeventsdb\duplicatemessageinfo' <br>is marked as crashed and should be repaired<br><br>2009-09-21 12:27:09,109 monitor.AggregatedDataDbWriter[aggregation-writer-Manager]: <br>(ERROR) Error writing objects: Incorrect key file for table<br>'.\aggregateddatadb\aggregationdatascheme2.MYI'; try to repair it</p> <p><br>On Windows platform, anti-virus software (McAfee, Symantec, etc) can cause similar corruption through "on-access scan" of the database tables/files while information is being written to them. If anti-virus software is installed on the Traverse server, they should be configured to exclude the TRAVERSE_HOME\database directories. Similarly, scheduled backup tasks should be configured to skip the database\mysql directory.</p> <p><strong>Note:</strong> If a DGE is unable to write to it's local database, you may notice missing performance data when you drill-down into a test being monitored from that DGE.</p> <p>To perform a database repair, ensure there is sufficient free space on the disk equal to the size of the largest file under 'TRAVERSE_HOME\database\mysql', then follow these steps:</p> <p>* <strong>Stop the Traverse components</strong> using Start -> All Programs -> Traverse -> Stop Traverse Components on Windows or "etc/traverse.init stop" from a shell prompt on Linux/Solaris.</p> <p>* <strong>Zip the TRAVERSE_HOME\logs directory for analysis</strong></p> <p>* <strong>Perform database repair</strong> using 'Start -> All Programs -> Traverse -> Database Management -> DGE Database Repair' on Windows. On Linux/Solaris run 'utils/db_repair.sh' from a shell prompt. ('db_repair.cmd' on Windows)</p> <p>* <strong>Start 'Performance and Event Database component'</strong> using 'Start -> All Programs -> Launch Traverse Service Controller -> Start 'Performance and Event Database' or 'etc/db_optimize.pl --run' from a shell prompt on Linux/Solaris</p> <p>* <strong>Perform database optimization</strong> using 'Start -> All Programs -> Traverse -> Database Management -> DGE Database Optimization' on Windows. On Linux/Solaris run 'utils/db_optimize.pl --run' from a shell prompt.</p> <p>* <strong>Start Traverse components</strong> using 'Start -> All Programs -> Traverse -> Start Traverse Components on Windows' or 'etc/traverse.init start' from a shell prompt on Linux/Solaris</p> <p>Once the components are up, please check database.log and error.log files to ensure that the errors are no longer being recorded.</p> <p> </p> <p><strong>APPLIES TO:</strong></p> </div> <div> </div> <div><a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fcommunity.kaseya.com%2Fkb%2Fw%2Fwiki%2Ftags%2Ftraverse%2Fdefault.aspx" rel="nofollow tag">traverse</a>, <a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fcommunity.kaseya.com%2Fkb%2Fw%2Fwiki%2Ftags%2FFAQ%2Fdefault.aspx" rel="nofollow tag">FAQ</a>, <a href="/home/leaving?allowTrusted=1&target=http%3A%2F%2Fcommunity.kaseya.com%2Fkb%2Fw%2Fwiki%2Ftags%2Fhow_2D00_to%2Fdefault.aspx" rel="nofollow tag">how-to</a></div> <div> </div> <div><strong>RELATED TO:</strong></div> <div><a rel="nofollow" href="https://kaseya.vanillacommunities.com/kb/articles/aliases/kaseya/hc/en-gb/articles/229045848-Tip-How-Do-I-optimize-the-DGE-Database">Tip: How Do I Optimize The DGE Database</a></div> <div> </div> </article> </main>