Here you send us your feedback on any problems related to nopAccelerate Solr Plugin.

Hi, I installed nopAccelerate on the default nopCommerce 3.1 website (including the 51 demo products). I enabled the nopCommerce setting 'Show the number of distinct products besides each category' (including subcategories), so I get the nice facets for categories.

When I restart the nopCommerce website (incl. recycling of app-pool) and visit the url "http://localhost/computer", I noticed that 196 select-queries are sent to Solr. Apparently most of these queries are for getting the number of products for each category. However, there seem to be a lot of identical (and unnecessary) queries fired to Solr.

Is this a bug in nopAccelerate or in nopCommerce?

See below for the list of 196 queries on visiting a page after the website restarted:

sort=CDO_2+asc&start=0&q=CategoryID:(2+OR+3+OR+4+OR+5+OR+7+OR+6)&fq={!tag%3Ddt}Price:[0+TO+9999999999999]&version=2.2&rows=4
start=0&stats.field=Price&stats=true&q=CategoryID:2&version=2.2&rows=0
q=*:*&fq=CategoryID:(1)&version=2.2&rows=0
q=*:*&fq=CategoryID:(3+OR+4+OR+5+OR+7+OR+6+OR+2)&version=2.2&rows=0
q=*:*&fq=CategoryID:(3)&version=2.2&rows=0
q=*:*&fq=CategoryID:(4)&version=2.2&rows=0
q=*:*&fq=CategoryID:(5)&version=2.2&rows=0
q=*:*&fq=CategoryID:(7)&version=2.2&rows=0
q=*:*&fq=CategoryID:(6)&version=2.2&rows=0
q=*:*&fq=CategoryID:(9+OR+10+OR+8)&version=2.2&rows=0
q=*:*&fq=CategoryID:(12+OR+13+OR+14+OR+15+OR+11)&version=2.2&rows=0
q=*:*&fq=CategoryID:(16)&version=2.2&rows=0
q=*:*&fq=CategoryID:(17)&version=2.2&rows=0
q=*:*&fq=CategoryID:(18)&version=2.2&rows=0
q=*:*&fq=CategoryID:(1)&version=2.2&rows=0
q=*:*&fq=CategoryID:(3+OR+4+OR+5+OR+7+OR+6+OR+2)&version=2.2&rows=0
q=*:*&fq=CategoryID:(9+OR+10+OR+8)&version=2.2&rows=0
q=*:*&fq=CategoryID:(12+OR+13+OR+14+OR+15+OR+11)&version=2.2&rows=0
q=*:*&fq=CategoryID:(16)&version=2.2&rows=0
q=*:*&fq=CategoryID:(17)&version=2.2&rows=0
q=*:*&fq=CategoryID:(18)&version=2.2&rows=0
q=*:*&fq=CategoryID:(1)&version=2.2&rows=0
q=*:*&fq=CategoryID:(3+OR+4+OR+5+OR+7+OR+6+OR+2)&version=2.2&rows=0
q=*:*&fq=CategoryID:(3)&version=2.2&rows=0
q=*:*&fq=CategoryID:(4)&version=2.2&rows=0
q=*:*&fq=CategoryID:(5)&version=2.2&rows=0
q=*:*&fq=CategoryID:(7)&version=2.2&rows=0
q=*:*&fq=CategoryID:(6)&version=2.2&rows=0
q=*:*&fq=CategoryID:(9+OR+10+OR+8)&version=2.2&rows=0
q=*:*&fq=CategoryID:(12+OR+13+OR+14+OR+15+OR+11)&version=2.2&rows=0
q=*:*&fq=CategoryID:(16)&version=2.2&rows=0
q=*:*&fq=CategoryID:(17)&version=2.2&rows=0
q=*:*&fq=CategoryID:(18)&version=2.2&rows=0
q=*:*&fq=CategoryID:(1)&version=2.2&rows=0
q=*:*&fq=CategoryID:(3+OR+4+OR+5+OR+7+OR+6+OR+2)&version=2.2&rows=0
q=*:*&fq=CategoryID:(3)&version=2.2&rows=0
q=*:*&fq=CategoryID:(4)&version=2.2&rows=0
q=*:*&fq=CategoryID:(5)&version=2.2&rows=0
q=*:*&fq=CategoryID:(7)&version=2.2&rows=0
q=*:*&fq=CategoryID:(6)&version=2.2&rows=0
q=*:*&fq=CategoryID:(9+OR+10+OR+8)&version=2.2&rows=0
q=*:*&fq=CategoryID:(12+OR+13+OR+14+OR+15+OR+11)&version=2.2&rows=0
q=*:*&fq=CategoryID:(16)&version=2.2&rows=0
q=*:*&fq=CategoryID:(17)&version=2.2&rows=0
q=*:*&fq=CategoryID:(18)&version=2.2&rows=0
q=*:*&fq=CategoryID:(1)&version=2.2&rows=0
q=*:*&fq=CategoryID:(3+OR+4+OR+5+OR+7+OR+6+OR+2)&version=2.2&rows=0
q=*:*&fq=CategoryID:(3)&version=2.2&rows=0
q=*:*&fq=CategoryID:(4)&version=2.2&rows=0
q=*:*&fq=CategoryID:(5)&version=2.2&rows=0
q=*:*&fq=CategoryID:(7)&version=2.2&rows=0
q=*:*&fq=CategoryID:(6)&version=2.2&rows=0
q=*:*&fq=CategoryID:(9+OR+10+OR+8)&version=2.2&rows=0
q=*:*&fq=CategoryID:(12+OR+13+OR+14+OR+15+OR+11)&version=2.2&rows=0
q=*:*&fq=CategoryID:(16)&version=2.2&rows=0
q=*:*&fq=CategoryID:(17)&version=2.2&rows=0
q=*:*&fq=CategoryID:(18)&version=2.2&rows=0
q=*:*&fq=CategoryID:(1)&version=2.2&rows=0
q=*:*&fq=CategoryID:(3+OR+4+OR+5+OR+7+OR+6+OR+2)&version=2.2&rows=0
q=*:*&fq=CategoryID:(3)&version=2.2&rows=0
q=*:*&fq=CategoryID:(4)&version=2.2&rows=0
q=*:*&fq=CategoryID:(5)&version=2.2&rows=0
q=*:*&fq=CategoryID:(7)&version=2.2&rows=0
q=*:*&fq=Categ

Dear Dion,

Thank you for reporting.

This query is being made to fetch the product count for each category. The result is then cached for saving further calls.

Moreover, you're right. This seems to be a bug as there seems to be a lot of identical queries being made to Solr which is not necessary. An appropriate issue is created and we'll fix it on urgent basis.

Once again, thank you for reporting it.

Dear Dion,

This issue is fixed. Thank you for reporting.

You can download the new plugin for your testing from your account.

Regards,

I have been receiving the following errors while trying to save or save and continue on a product. If I disable the solr plugins the error does not occur.

InvalidOperationException: The operation cannot be completed because the DbContext has been disposed.]
   System.Data.Entity.Internal.InternalContext.CheckContextNotDisposed() +27
   System.Data.Entity.Internal.LazyInternalContext.InitializeContext() +34
   System.Data.Entity.Internal.InternalContext.Initialize() +15
   System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType) +16
   System.Data.Entity.Internal.Linq.InternalSet`1.Initialize() +60
   System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext() +15
   System.Data.Entity.Internal.Linq.InternalSet`1.Find(Object[] keyValues) +20
   System.Data.Entity.DbSet`1.Find(Object[] keyValues) +28
   Nop.Data.EfRepository`1.GetById(Object id) +84
   Nop.Services.Catalog.<>c__DisplayClass1.<GetProductById>b__0() +35
   Nop.Core.Caching.CacheExtensions.Get(ICacheManager cacheManager, String key, Int32 cacheTime, Func`1 acquire) +93
   Nop.Core.Caching.CacheExtensions.Get(ICacheManager cacheManager, String key, Func`1 acquire) +58
   Nop.Services.Catalog.ProductService.GetProductById(Int32 productId) +133
   XcellenceIT.Plugin.Solr.Core.XcellenceITActionFilterProductUpdate.OnActionExecuted(ActionExecutedContext filterContext) +145
   System.Web.Mvc.Async.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() +257
   System.Web.Mvc.Async.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() +229
   System.Web.Mvc.Async.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() +229
   System.Web.Mvc.Async.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() +229
   System.Web.Mvc.Async.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() +229
   System.Web.Mvc.Async.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() +229
   System.Web.Mvc.Async.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() +229
   System.Web.Mvc.Async.<>c__DisplayClass33.<BeginInvokeActionMethodWithFilters>b__32(IAsyncResult asyncResult) +10
   System.Web.Mvc.Async.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) +10
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +46
   System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult, Object tag) +59
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +18
   System.Web.Mvc.Async.<>c__DisplayClass2b.<BeginInvokeAction>b__1c() +26
   System.Web.Mvc.Async.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult) +121
   System.Web.Mvc.Async.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) +10
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +46
   System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult, Object tag) +18
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +13
   System.Web.Mvc.Controller.<BeginExecuteCore>b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState) +13
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +36
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +51
   System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult, Object tag) +28
   System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult, Object tag) +15
   System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +26
   System.Web.Mvc.Controller.<BeginExecute>b__15(IAsyncResult asyncResult, Controller controller) +12
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +28
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +51
   System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult,

My apologies please see the proper topic post. Co-worker distracted me while I had added this.

[quote=Peter]I have been receiving the following errors while trying to save or save and continue on a product. If I disable the solr plugins the error does not occur.

InvalidOperationException: The operation cannot be completed because the DbContext has been disposed.]
   System.Data.Entity.Internal.InternalContext.CheckContextNotDisposed() +27
   System.Data.Entity.Internal.LazyInternalContext.InitializeContext() +34
   System.Data.Entity.Internal.InternalContext.Initialize() +15
   System.Data.Entity.Internal.InternalContext.GetEntitySetAndBaseTypeForType(Type entityType) +16
   System.Data.Entity.Internal.Linq.InternalSet`1.Initialize() +60
   System.Data.Entity.Internal.Linq.InternalSet`1.get_InternalContext() +15
   System.Data.Entity.Internal.Linq.InternalSet`1.Find(Object[] keyValues) +20
   System.Data.Entity.DbSet`1.Find(Object[] keyValues) +28
   Nop.Data.EfRepository`1.GetById(Object id) +84
   Nop.Services.Catalog.<>c__DisplayClass1.<GetProductById>b__0() +35
   Nop.Core.Caching.CacheExtensions.Get(ICacheManager cacheManager, String key, Int32 cacheTime, Func`1 acquire) +93
   Nop.Core.Caching.CacheExtensions.Get(ICacheManager cacheManager, String key, Func`1 acquire) +58
   Nop.Services.Catalog.ProductService.GetProductById(Int32 productId) +133
   XcellenceIT.Plugin.Solr.Core.XcellenceITActionFilterProductUpdate.OnActionExecuted(ActionExecutedContext filterContext) +145
   System.Web.Mvc.Async.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() +257
   System.Web.Mvc.Async.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() +229
   System.Web.Mvc.Async.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() +229
   System.Web.Mvc.Async.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() +229
   System.Web.Mvc.Async.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() +229
   System.Web.Mvc.Async.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() +229
   System.Web.Mvc.Async.<>c__DisplayClass46.<InvokeActionMethodFilterAsynchronouslyRecursive>b__3f() +229
   System.Web.Mvc.Async.<>c__DisplayClass33.<BeginInvokeActionMethodWithFilters>b__32(IAsyncResult asyncResult) +10
   System.Web.Mvc.Async.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) +10
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +46
   System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult, Object tag) +59
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeActionMethodWithFilters(IAsyncResult asyncResult) +18
   System.Web.Mvc.Async.<>c__DisplayClass2b.<BeginInvokeAction>b__1c() +26
   System.Web.Mvc.Async.<>c__DisplayClass21.<BeginInvokeAction>b__1e(IAsyncResult asyncResult) +121
   System.Web.Mvc.Async.WrappedAsyncResult`1.CallEndDelegate(IAsyncResult asyncResult) +10
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +46
   System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult, Object tag) +18
   System.Web.Mvc.Async.AsyncControllerActionInvoker.EndInvokeAction(IAsyncResult asyncResult) +13
   System.Web.Mvc.Controller.<BeginExecuteCore>b__1d(IAsyncResult asyncResult, ExecuteCoreState innerState) +13
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +36
   System.Web.Mvc.Async.WrappedAsyncResultBase`1.End() +51
   System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult, Object tag) +28
   System.Web.Mvc.Async.AsyncResultWrapper.End(IAsyncResult asyncResult, Object tag) +15
   System.Web.Mvc.Controller.EndExecuteCore(IAsyncResult asyncResult) +26
   System.Web.Mvc.Controller.<BeginExecute>b__15(IAsyncResult asyncResult, Controller controller) +12
   System.Web.Mvc.Async.WrappedAsyncVoid`1.CallEndDelegate(IAsyncResult asyncResult) +28
   System.Web.Mvc.Asy

The latest version 2.7 with nopcommerce 3.5 appears to have a performance problem on category pages or anywhere  SolrProductController.CategoryNavigation is used.

I have used miniprofiler to detect that particular controller action causes a significant delay in page loads (5 - 10 seconds). If I comment out the action from the parent view page loads fall in line with expectations.

Hello Peter,

Thank you for reporting the same.

We are currently checking the same at our end and if needed, proceed with fix and new release on urgent basis as performance is the core feature of our offering.

Regards,
Ankita

Hello Peter,

I have checked the performance of nopAccelerate version 2.7 with nopCommerce version 3.50 and it gives better performance. Can you please provide us some more details? On which page it took more time to load or any page URL. So, we can check and respond you.

Regards,
Ankita

Hello. Can you help with this?
The specified LINQ expression contains references to queries that are associated with different contexts
System.NotSupportedException: The specified LINQ expression contains references to queries that are associated with different contexts.
...
XcellenceIT.Plugin.Solr.Core.SolrCoreService.GetAssociatedLanguageByStoreId(Int32 sId) at XcellenceIT.Plugin.Solr.Core.SolrCoreService.StartScheduleTasks() at XcellenceIT.Plugin.Solr.Core.Services.SolrScheduleTask.Execute()

It happens when i trying to index products.