tracker issue : CF-3650399

select a category, or use search below
(searches all categories and all time range)
Title:

Possible unnecessary HTTP calls with CFSEARCH

| View in Tracker

Status/Resolution/Reason: Closed/Fixed/

Reporter/Name(from Bugbase): Raymond Camden / Raymond Camden (Raymond Camden)

Created: 10/16/2013

Components: Text Search, Solr

Versions: 10.0

Failure Type:

Found In Build/Fixed In Build: Final /

Priority/Frequency: Normal / All users will encounter

Locale/System: English / Mac 10 All

Vote Count: 0

Listed in the version 2016.0.0.297996 Issues Fixed doc
Verification notes: verified_fixed on September 08, 2019 using build 2016.0.01.298513 
I’m looking at the log files for a simple cfsearch call. One execution results in 3 HTTP calls:

127.0.0.1 -  -  [14/Oct/2013:19:37:32 +0000] "GET /solr/admin/cores?action=STATUS&core=&wt=xml&version=2.2 HTTP/1.1" 200 7962
127.0.0.1 -  -  [14/Oct/2013:19:37:32 +0000] "GET /solr/admin/cores?action=STATUS&core=myblog&wt=xml&version=2.2 HTTP/1.1" 200 1048
127.0.0.1 -  -  [14/Oct/2013:19:37:32 +0000] "GET /solr/myblog/select?q=PhoneGap+coldfusion&fl=*%2Cscore&rows=10&qt=standard&spellcheck=true&spellcheck.build=false&spellcheck.q=PhoneGap+coldfusion&spellcheck.collate=true&start=0&wt=xml&version=2.2 HTTP/1.1" 200 56284

The first call gets a status value on every single collection. The second does it just for the collection I was working with. The final one is doing the actual search.

From what I can tell, I get the STATUS calls because I specifically asked for a status in my cfsearch, but what I don’t get is why it does a call to get _all_ the collection data. That seems like a mistake, right?

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3650399

External Customer Info:
External Company:  
External Customer Name: cfjedimaster
External Customer Email:  
External Test Config: My Hardware and Environment details:

Attachments:

Comments:

unable to observe the issue with CF10 update 12 on Win 7 x64 with the script at the end of this note: only one HTTP call is logged by the web server. 127.0.0.1 - - [18/Dec/2013:17:28:22 +0530] "GET /CF-3650399/CF-3650399.cfm HTTP/1.1" 200 18366 @ cfjedimaster, please suggest if I am missing anything here. <cfset col_name = "bug_col"> <cfcollection action="list" name="lst_col"> <cfset col_lst = ValueList(lst_col.NAME, ",")> <cfif ListContains( col_lst, "#col_name#") EQ 0> <cfcollection action = "create" collection = "#col_name#" engine = "solr" path = "#expandpath(".")#"> </cfif> <cfindex collection="#col_name#" action="refresh" type="path" key="C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\CF-3650399\" urlpath="http://localhost:80/CF-3650399/" status="stat_info"> indexed. <cfdump var="#stat_info#"> <cfset sleep(3000)> <cfsearch name="srch_test" collection="#col_name#" criteria= "CF10"> search result... <cfdump var="#srch_test#">
Comment by Piyush K.
14195 | December 18, 2013 06:34:34 AM GMT
updated script (only cfsearch is uncommented): <cfset col_name = "bug_col"> <!--- <cfcollection action="list" name="lst_col"> <cfset col_lst = ValueList(lst_col.NAME, ",")> <cfif ListContains( col_lst, "#col_name#") EQ 0> <cfcollection action = "create" collection = "#col_name#" engine = "solr" path = "#expandpath(".")#"> </cfif> <cfindex collection="#col_name#" action="refresh" type="path" key="C:\Program Files (x86)\Apache Software Foundation\Apache2.2\htdocs\CF-3650399\" urlpath="http://localhost:80/CF-3650399/" status="stat_info"> indexed. <cfdump var="#stat_info#"> <cfset sleep(3000)>---> <cfsearch name="srch_test" collection="#col_name#" criteria= "CF10" status = "stat_struct"> <!--- '<*>`CF10`<*>'> ---> search result... <cfdump var="#srch_test#"> <cfdump var="#stat_struct#">
Comment by Piyush K.
14196 | December 18, 2013 06:35:52 AM GMT
I updated to 12 just now. I reran a test. I still see this issue. My CFM only has one cfsearch on it and i see this in the logs: 127.0.0.1 - - [18/Dec/2013:13:08:41 +0000] "GET /solr HTTP/1.1" 302 0 127.0.0.1 - - [18/Dec/2013:13:08:41 +0000] "GET /solr/ HTTP/1.1" 200 925 127.0.0.1 - - [18/Dec/2013:13:08:41 +0000] "GET /solr/admin/cores?action=STATUS&core=&wt=xml&version=2.2 HTTP/1.1" 200 8867 127.0.0.1 - - [18/Dec/2013:13:08:41 +0000] "GET /solr/admin/cores?action=STATUS&core=myblog&wt=xml&version=2.2 HTTP/1.1" 200 1048 127.0.0.1 - - [18/Dec/2013:13:08:41 +0000] "GET /solr/myblog/select?q=test&fl=*%2Cscore&rows=10&qt=standard&spellcheck=true&spellcheck.build=false&spellcheck.q=test&spellcheck.collate=true&start=0&wt=xml&version=2.2 HTTP/1.1" 200 17854 127.0.0.1 - - [18/Dec/2013:13:08:41 +0000] "GET /solr/admin/cores?action=STATUS&core=myblog&wt=xml&version=2.2 HTTP/1.1" 200 1048 To me, it almost looks worse then I said. Thats 6 calls there for the one search.
Comment by External U.
14197 | December 18, 2013 07:40:09 AM GMT
@ cfjedimaster, Can you please try the script I've shared in the notes and share the results. Can you also share your cfm template. Thanks.
Comment by Piyush K.
14198 | December 19, 2013 01:53:25 AM GMT
I get the same: 127.0.0.1 - - [19/Dec/2013:11:35:36 +0000] "GET /solr HTTP/1.1" 302 0 127.0.0.1 - - [19/Dec/2013:11:35:36 +0000] "GET /solr/ HTTP/1.1" 200 925 127.0.0.1 - - [19/Dec/2013:11:35:36 +0000] "GET /solr/admin/cores?action=STATUS&core=&wt=xml&version=2.2 HTTP/1.1" 200 8898 127.0.0.1 - - [19/Dec/2013:11:35:36 +0000] "GET /solr/admin/cores?action=STATUS&core=myblog&wt=xml&version=2.2 HTTP/1.1" 200 1051 127.0.0.1 - - [19/Dec/2013:11:35:36 +0000] "GET /solr/admin/cores?action=STATUS&core=myblog&wt=xml&version=2.2 HTTP/1.1" 200 1051 127.0.0.1 - - [19/Dec/2013:11:35:36 +0000] "GET /solr/myblog/select?q=CF10&fl=*%2Cscore&rows=4533&qt=standard&start=0&wt=xml&version=2.2 HTTP/1.1" 200 62905 127.0.0.1 - - [19/Dec/2013:11:35:36 +0000] "GET /solr/admin/cores?action=STATUS&core=myblog&wt=xml&version=2.2 HTTP/1.1" 200 1051
Comment by External U.
14199 | December 19, 2013 06:06:15 AM GMT
Right now for single cfsearch almost 6 http calls were being made if maxrows attribute is omitted, Out of these I have reduced 3 calls into 1 (status action). Rest are by design and required as of now
Comment by Uday O.
14200 | November 26, 2014 03:03:35 AM GMT
Hi Adobe, I've verified this is fixed in CF2016 Update 1 (build 2016.0.01.298513). Thanks!, -Aaron
Comment by Aaron N.
31309 | September 08, 2019 06:45:26 AM GMT