Reply to thread

Message

<blockquote data-quote="MJGraf" data-source="post: 1037961" data-attributes="member: 17886">Thanks, Morph!IRC-Bot failing to build:I have to admit that I have no idea why this happens. Sorry, I'm not familiar enough with our build process. What I see from your BuildLog, however, is this:[CODE]&nbsp; &quot;d:\github\MediaPortal-2\MediaPortal\Build\\NuGet.exe&quot; install &quot;d:\github\MediaPortal-2\MediaPortal\Incubator\SQLiteDatabase\packages.config&quot;&nbsp; Restoring NuGet packages...&nbsp; To prevent NuGet from downloading packages during build, open the Visual Studio Options dialog, click on the Package Manager node and uncheck 'Allow NuGet to download missing packages'.&nbsp; All packages listed in packages.config are already installed.[/CODE]The packages.config that is mentioned here looks like this:[CODE]&lt;?xml version=&quot;1.0&quot; encoding=&quot;utf-8&quot;?&gt;&lt;packages&gt;&nbsp; &lt;package id=&quot;System.Data.SQLite.x86&quot; version=&quot;1.0.89.0&quot; targetFramework=&quot;net40&quot; /&gt;&lt;/packages&gt;[/CODE]So my understanding is that it looked up System.Data.SQLite.x86 version 1.0.89.0 and realized that it is already there and doesn't have to be downloaded.Later it says in the log:[CODE]Project &quot;d:\github\MediaPortal-2\MediaPortal\Source\MP2-Server.sln&quot; (59) is building &quot;d:\github\MediaPortal-2\MediaPortal\Incubator\SQLiteDatabase\SQLiteDatabase.csproj&quot; (65) on node 1 (Rebuild target(s)).ResolveAssemblyReferences:&nbsp; Primary reference &quot;System.Data.SQLite&quot;.C:\Windows\Microsoft.NET\Framework\v4.0.30319\Microsoft.Common.targets(1360,9): warning MSB3245: Could not resolve this reference. Could not locate the assembly &quot;System.Data.SQLite&quot;. Check to make sure the assembly exists on disk. If this reference is required by your code, you may get compilation errors. [d:\github\MediaPortal-2\MediaPortal\Incubator\SQLiteDatabase\SQLiteDatabase.csproj]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; For SearchPath &quot;{HintPathFromItem}&quot;.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Considered &quot;..\..\Source\packages\System.Data.SQLite.x86.1.0.89.0\lib\net40\System.Data.SQLite.dll&quot;, but it didn't exist.[/CODE]So here it complains that system.data.sqlite.dll is not there. But why the heck did it say above that it was there and didn't have to be downloaded?!?Think I need help with this one..Exception on boot:This is a nasty one <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite8" alt=":D" title="Big Grin&nbsp; &nbsp; :D" loading="lazy" data-shortname=":D" />I use ManagementObjectSearcher to find out the overall RAM of the system. But as I learned now, ManagementObjectSearcher needs the Windows WMI service to be started. So when MP2 Server Service - on startup - starts before the WMI service, we get this exception. When MP2 Server Service is started manually later on, WMI service is already started and it works...I think the cleanest solution for this is to make a direct PInvoke to GlobalMemoryStatusEx (see here: <a href="http://www.emoticode.net/c-sharp/get-total-and-free-ram-on-a-computer.html" target="_blank">http://www.emoticode.net/c-sharp/get-total-and-free-ram-on-a-computer.html</a>). Additionally I would wrap it into a try-catch-block and if we get an exception at this point, we just use the lowest value (32MB) for the cache size of SQlite. In any case, a problem in determining the total available RAM shouldn't prevent SQLiteDatabase from starting...Will try the PInvoke solution and report back...</blockquote>

[QUOTE="MJGraf, post: 1037961, member: 17886"] Thanks, Morph! [U]IRC-Bot failing to build:[/U] I have to admit that I have no idea why this happens. Sorry, I'm not familiar enough with our build process. What I see from your BuildLog, however, is this: [CODE] "d:\github\MediaPortal-2\MediaPortal\Build\\NuGet.exe" install "d:\github\MediaPortal-2\MediaPortal\Incubator\SQLiteDatabase\packages.config" Restoring NuGet packages... To prevent NuGet from downloading packages during build, open the Visual Studio Options dialog, click on the Package Manager node and uncheck 'Allow NuGet to download missing packages'. All packages listed in packages.config are already installed. [/CODE] The packages.config that is mentioned here looks like this: [CODE]<?xml version="1.0" encoding="utf-8"?> <packages> <package id="System.Data.SQLite.x86" version="1.0.89.0" targetFramework="net40" /> </packages> [/CODE] So my understanding is that it looked up System.Data.SQLite.x86 version 1.0.89.0 and realized that it is already there and doesn't have to be downloaded. Later it says in the log: [CODE]Project "d:\github\MediaPortal-2\MediaPortal\Source\MP2-Server.sln" (59) is building "d:\github\MediaPortal-2\MediaPortal\Incubator\SQLiteDatabase\SQLiteDatabase.csproj" (65) on node 1 (Rebuild target(s)). ResolveAssemblyReferences: Primary reference "System.Data.SQLite". C:\Windows\Microsoft.NET\Framework\v4.0.30319\Microsoft.Common.targets(1360,9): warning MSB3245: Could not resolve this reference. Could not locate the assembly "System.Data.SQLite". Check to make sure the assembly exists on disk. If this reference is required by your code, you may get compilation errors. [d:\github\MediaPortal-2\MediaPortal\Incubator\SQLiteDatabase\SQLiteDatabase.csproj] For SearchPath "{HintPathFromItem}". Considered "..\..\Source\packages\System.Data.SQLite.x86.1.0.89.0\lib\net40\System.Data.SQLite.dll", but it didn't exist. [/CODE] So here it complains that system.data.sqlite.dll is not there. But why the heck did it say above that it was there and didn't have to be downloaded?!? Think I need help with this one.. [U]Exception on boot:[/U] This is a nasty one :D I use ManagementObjectSearcher to find out the overall RAM of the system. But as I learned now, ManagementObjectSearcher needs the Windows WMI service to be started. So when MP2 Server Service - on startup - starts before the WMI service, we get this exception. When MP2 Server Service is started manually later on, WMI service is already started and it works... I think the cleanest solution for this is to make a direct PInvoke to GlobalMemoryStatusEx (see here: [url]http://www.emoticode.net/c-sharp/get-total-and-free-ram-on-a-computer.html[/url]). Additionally I would wrap it into a try-catch-block and if we get an exception at this point, we just use the lowest value (32MB) for the cache size of SQlite. In any case, a problem in determining the total available RAM shouldn't prevent SQLiteDatabase from starting... Will try the PInvoke solution and report back... [/QUOTE]

Verification