<?xml version="1.0" encoding="UTF-8"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="en-gb">
	<link rel="self" type="application/atom+xml" href="https://blueirissoftware.com/forum/app.php/feed/topic/3061" />

	<title>Blue Iris</title>
	<subtitle>Blue Iris User Group</subtitle>
	<link href="https://blueirissoftware.com/forum/index.php" />
	<updated>2022-01-26T23:50:10+00:00</updated>

	<author><name><![CDATA[Blue Iris]]></name></author>
	<id>https://blueirissoftware.com/forum/app.php/feed/topic/3061</id>

		<entry>
		<author><name><![CDATA[varghesesa]]></name></author>
		<updated>2022-01-26T23:50:10+00:00</updated>

		<published>2022-01-26T23:50:10+00:00</published>
		<id>https://blueirissoftware.com/forum/viewtopic.php?p=12256#p12256</id>
		<link href="https://blueirissoftware.com/forum/viewtopic.php?p=12256#p12256"/>
		<title type="html"><![CDATA[Database troubleshooting]]></title>

		
		<content type="html" xml:base="https://blueirissoftware.com/forum/viewtopic.php?p=12256#p12256"><![CDATA[
<span style="font-size:150%;line-height:116%"><strong class="text-strong">Introduction</strong></span><div style="margin-left:3em"><br>Having a functioning database is critical to BI performing correctly.  If there are database read/write errors, then bad things happen like recordings/alerts go missing.<br><br>Many users do not realize this, but the Clips list, Alerts list and Timeline are visual representations of records stored in the database. <br><br></div><span style="font-size:150%;line-height:116%"><strong class="text-strong">Troubleshooting</strong></span><div style="margin-left:3em"><br><strong class="text-strong">Basics</strong><div style="margin-left:3em">Make sure you followed best practices.  FYI, reviewing entire <a href="viewtopic.php?f=20&amp;t=2080" class="postlink">Windows tuning article</a> is always beneficial.<ul><li><a href="viewtopic.php?f=20&amp;t=2080#Antivirus" class="postlink">Antivirus and firewall exclusions</a></li><li><a href="viewtopic.php?f=20&amp;t=2080#Storage" class="postlink">Confirm your database folder is setup correctly.</a></li></ul></div><strong class="text-strong">Clips missing</strong><div style="margin-left:3em">Does BI indicate it is no longer recording?  In the <em class="text-italics">filter by date</em> image below, it appears as though BI stopped recording from Jan 4 - Jan 21 (no red dots).<br><br><div class="inline-attachment"><dl class="file"><dt class="attach-image"><img src="https://blueirissoftware.com/forum/download/file.php?id=2436" class="postimage" alt="record framework_calendar.png" onclick="viewableArea(this);" /></dt></dl></div><br>Not sure yet if BI actually stopped recording or the Database is no longer being updated.  An easy check is to run Repair/Regenerate (see below) and see if BI can resolve the issue.  Another easy check is to open your New folder and see if new recordings are being created by BI.  If so, the issue is with writing to the Database.  <a href="viewtopic.php?f=27&amp;t=3043" class="postlink">Look for database errors in the logs</a>.<br><br>If new recordings are not being created, you probably have a <a href="viewtopic.php?f=11&amp;t=2817" class="postlink">storage issue</a> or <a href="viewtopic.php?f=27&amp;t=3009" class="postlink">recording issue</a>.<br><br></div><strong class="text-strong">Database tools</strong><div style="margin-left:3em">If you right click in the Clips list -&gt; Database section, you have access to the database maintenance functions.  Help provides details on each function.  Repair/regenerate is often used when users notice clips/alerts are missing from the Clips list/Alerts list.<br><br><div class="inline-attachment"><dl class="file"><dt class="attach-image"><img src="https://blueirissoftware.com/forum/download/file.php?id=2430" class="postimage" alt="database troubleshooting_maintenance functions.png" onclick="viewableArea(this);" /></dt></dl></div><br></div><strong class="text-strong">Log files</strong><div style="margin-left:3em">The logs will tell you if BI is having issues with your Database.  In order to know which errors to look for, we are documenting all the Status log errors.  The ones concerning the database are in the <a href="viewtopic.php?f=14&amp;t=2086#Database" class="postlink">Database category</a>.  Each log error provides details and possible fixes to self-correct.<br><br>The <a href="viewtopic.php?f=27&amp;t=3043" class="postlink">Log files article</a> explains how to easily deal with log files using excel.<br><br></div><strong class="text-strong">Camera stats</strong><div style="margin-left:3em">If particular cameras are missing alerts, the usual issue is lack of key frames.  See <a href="viewtopic.php?f=11&amp;t=2598#Key%20frame%20ratio" class="postlink">key frame ratio section</a> for details.<br><br></div></div><span style="font-size:150%;line-height:116%"><strong class="text-strong">Submitting a ticket</strong></span><div style="margin-left:3em"><strong class="text-strong">Issue</strong>  <div style="margin-left:3em">Clearly describe the issue.  If the issue resides with a remote endpoint, confirm whether there is also an issue in the console.  If you tried the Database maintenance commands, please share.  Anything else you tried.<br><br></div><strong class="text-strong">Storage</strong><div style="margin-left:3em">Screenshot of Alerts folder settings.<br>Screenshot of the Status button -&gt; Storage tab<br><br></div><strong class="text-strong">Camera stats</strong><div style="margin-left:3em">Status button -&gt; Cameras tab -&gt; Export<br><br></div><strong class="text-strong">Logs</strong><div style="margin-left:3em">What do the logs say?  Copy/paste the exact error events from the log file or screenshot the Logs tab.<br><br></div></div><p>Statistics: Posted by <a href="https://blueirissoftware.com/forum/memberlist.php?mode=viewprofile&amp;u=521">varghesesa</a> — Wed Jan 26, 2022 11:50 pm</p><hr />
]]></content>
	</entry>
	</feed>
