filename: conf/fts/py-fts-custmap-rqg-queries-mk.conf
prefix: fts.stable_topology_fts.StableTopFTS
Global Test input params:
{'cluster_name': 'fts',
 'conf_file': 'conf/fts/py-fts-custmap-rqg-queries-mk.conf',
 'ini': 'resources/jenkins/fts.ini',
 'num_nodes': 1,
 'spec': 'py-fts-custmap-rqg-queries-mk'}
Logs will be stored at /Users/mihirkamdar/PycharmProjects/testrunner_fts_0725/testrunner/logs/testrunner-16-Aug-09_11-21-59/test_1

./testrunner -i resources/jenkins/fts.ini  -t fts.stable_topology_fts.StableTopFTS.index_query_custom_mapping,items=1000,custom_map=True,num_custom_analyzers=1,multiple_filters=true,cm_id=0,num_queries=100,compare_es=True,GROUP=P0,cluster=D+F

Test Input params:
{'cluster_name': 'fts', 'num_custom_analyzers': '1', 'GROUP': 'P0', 'compare_es': 'True', 'cluster': 'D+F', 'items': '1000', 'num_queries': '100', 'conf_file': 'conf/fts/py-fts-custmap-rqg-queries-mk.conf', 'num_nodes': 1, 'multiple_filters': 'true', 'cm_id': '0', 'ini': 'resources/jenkins/fts.ini', 'case_number': 1, 'logs_folder': '/Users/mihirkamdar/PycharmProjects/testrunner_fts_0725/testrunner/logs/testrunner-16-Aug-09_11-21-59/test_1', 'custom_map': 'True', 'spec': 'py-fts-custmap-rqg-queries-mk'}
Run before suite setup for fts.stable_topology_fts.StableTopFTS.index_query_custom_mapping
2016-08-09 11:21:59 | WARNING | MainProcess | MainThread | [data_helper.<module>] Can not import concurrent module. Data for each server will be loaded/retrieved sequentially
2016-08-09 11:22:00 | INFO | MainProcess | test_thread | [fts_base.setUp] ==== FTSbasetests setup is started for test #1 index_query_custom_mapping ====
2016-08-09 11:22:01 | INFO | MainProcess | test_thread | [fts_base.cleanup_cluster] removing nodes from cluster ...
2016-08-09 11:22:02 | INFO | MainProcess | test_thread | [fts_base.cleanup_cluster] cleanup [ip:172.23.106.72 port:8091 ssh_username:root]
2016-08-09 11:22:03 | INFO | MainProcess | test_thread | [bucket_helper.delete_all_buckets_or_assert] deleting existing buckets [] on 172.23.106.72
2016-08-09 11:22:06 | INFO | MainProcess | test_thread | [cluster_helper.wait_for_ns_servers_or_assert] waiting for ns_server @ 172.23.106.72:8091
2016-08-09 11:22:07 | INFO | MainProcess | test_thread | [cluster_helper.wait_for_ns_servers_or_assert] ns_server @ 172.23.106.72:8091 is running
2016-08-09 11:22:08 | INFO | MainProcess | test_thread | [fts_base.create_index_es] Created empty index es_index on Elastic Search node with custom standard analyzer(default)
2016-08-09 11:22:08 | INFO | MainProcess | test_thread | [fts_base.init_cluster] Initializing Cluster ...
2016-08-09 11:22:10 | INFO | MainProcess | Cluster_Thread | [rest_client.init_cluster_memoryQuota] pools/default params : memoryQuota=2069
2016-08-09 11:22:11 | INFO | MainProcess | Cluster_Thread | [rest_client.set_indexer_storage_mode] settings/indexes params : storageMode=forestdb
2016-08-09 11:22:11 | INFO | MainProcess | Cluster_Thread | [rest_client.init_cluster] settings/web params on 172.23.106.72:8091:username=Administrator&password=password&port=8091
2016-08-09 11:22:17 | INFO | MainProcess | Cluster_Thread | [rest_client.create_bucket] http://172.23.106.72:8091/pools/default/buckets with param: bucketType=membase&evictionPolicy=valueOnly&threadsNumber=3&ramQuotaMB=1569&proxyPort=11211&authType=sasl&name=default&flushEnabled=1&replicaNumber=1&replicaIndex=1&saslPassword=None
2016-08-09 11:22:17 | INFO | MainProcess | Cluster_Thread | [rest_client.create_bucket] 0.50 seconds to create bucket default
2016-08-09 11:22:17 | INFO | MainProcess | Cluster_Thread | [bucket_helper.wait_for_memcached] waiting for memcached bucket : default in 172.23.106.72 to accept set ops
2016-08-09 11:22:23 | INFO | MainProcess | Cluster_Thread | [data_helper.direct_client] creating direct client 172.23.106.72:11210 default
2016-08-09 11:22:29 | INFO | MainProcess | Cluster_Thread | [data_helper.direct_client] creating direct client 172.23.106.72:11210 default
2016-08-09 11:27:11 | INFO | MainProcess | Cluster_Thread | [task.check] bucket 'default' was created with per node RAM quota: 1569
2016-08-09 11:27:13 | INFO | MainProcess | test_thread | [rest_client.diag_eval] /diag/eval status on 172.23.106.72:8091: True content: "/opt/couchbase/var/lib/couchbase/logs" command: filename:absname(element(2, application:get_env(ns_server,error_logger_mf_dir))).
2016-08-09 11:27:13 | INFO | MainProcess | test_thread | [remote_util.__init__] connecting to 172.23.106.72 with username : root password : couchbase ssh_key: 
2016-08-09 11:27:16 | INFO | MainProcess | test_thread | [remote_util.__init__] Connected to 172.23.106.72
2016-08-09 11:27:30 | INFO | MainProcess | test_thread | [remote_util.execute_command_raw] running command.raw on 172.23.106.72: zgrep "panic:" "/opt/couchbase/var/lib/couchbase/logs"/fts.log* | wc -l
2016-08-09 11:27:38 | INFO | MainProcess | test_thread | [remote_util.execute_command_raw] command executed successfully
2016-08-09 11:27:38 | INFO | MainProcess | test_thread | [fts_base.check_error_count_in_fts_log] 0
2016-08-09 11:27:38 | INFO | MainProcess | test_thread | [remote_util.execute_command_raw] running command.raw on 172.23.106.72: zgrep "crash in forestdb" "/opt/couchbase/var/lib/couchbase/logs"/fts.log* | wc -l
2016-08-09 11:27:45 | INFO | MainProcess | test_thread | [remote_util.execute_command_raw] command executed successfully
2016-08-09 11:27:45 | INFO | MainProcess | test_thread | [fts_base.check_error_count_in_fts_log] 0
2016-08-09 11:27:45 | INFO | MainProcess | test_thread | [fts_base.__initialize_error_count_dict] {'172.23.106.72': {'crash in forestdb': 0, 'panic:': 0}}
2016-08-09 11:27:45 | INFO | MainProcess | test_thread | [fts_base.setUp] ==== FTSbasetests setup is finished for test #1 index_query_custom_mapping ====
{'text': ['email', 'name', 'manages_reports'], 'number': ['manages_team_size', 'mutated'], 'datetime': ['join_date']}
2016-08-09 11:27:48 | INFO | MainProcess | test_thread | [fts_base.generate_new_custom_map] {
   "mapping": {
      "default_analyzer": "customAnalyzer1", 
      "default_datetime_parser": "dateTimeOptional", 
      "type_field": "type", 
      "default_mapping": {
         "default_analyzer": "", 
         "dynamic": true, 
         "enabled": false
      }, 
      "default_type": "_default", 
      "analysis": {
         "analyzers": {
            "customAnalyzer1": {
               "type": "custom", 
               "char_filters": [
                  "html"
               ], 
               "tokenizer": "web", 
               "token_filters": [
                  "back_edge_ngram", 
                  "truncate", 
                  "to_lower"
               ]
            }
         }, 
         "token_filters": {
            "dict_compound_en": {
               "dict_token_map": "stop_en", 
               "type": "dict_compound"
            }, 
            "length": {
               "max": 5, 
               "type": "length", 
               "min": 3
            }, 
            "truncate": {
               "length": 10, 
               "type": "truncate_token"
            }, 
            "dict_compound_fr": {
               "dict_token_map": "articles_fr", 
               "type": "dict_compound"
            }, 
            "ngram": {
               "max": 5, 
               "type": "ngram", 
               "min": 3
            }, 
            "front_edge_ngram": {
               "max": 5, 
               "type": "edge_ngram", 
               "back": false, 
               "min": 3
            }, 
            "back_edge_ngram": {
               "max": 5, 
               "type": "edge_ngram", 
               "back": true, 
               "min": 3
            }, 
            "shingle": {
               "output_original": "false", 
               "min": 2, 
               "filler": "", 
               "max": 5, 
               "separator": "", 
               "type": "shingle"
            }, 
            "keyword_marker_en": {
               "type": "keyword_marker", 
               "keywords_token_map": "stop_en"
            }
         }
      }, 
      "default_field": "_all", 
      "types": {
         "emp": {
            "enabled": true, 
            "dynamic": false, 
            "properties": {
               "mutated": {
                  "enabled": true, 
                  "dynamic": false, 
                  "properties": {}, 
                  "fields": [
                     {
                        "index": true, 
                        "name": "mutated", 
                        "include_in_all": true, 
                        "type": "number", 
                        "analyzer": "", 
                        "include_term_vectors": true, 
                        "store": false
                     }
                  ]
               }, 
               "join_date": {
                  "enabled": true, 
                  "dynamic": false, 
                  "properties": {}, 
                  "fields": [
                     {
                        "index": true, 
                        "name": "join_date", 
                        "include_in_all": true, 
                        "type": "datetime", 
                        "analyzer": "", 
                        "include_term_vectors": true, 
                        "store": false
                     }
                  ]
               }, 
               "manages": {
                  "enabled": true, 
                  "dynamic": false, 
                  "properties": {
                     "reports": {
                        "enabled": true, 
                        "dynamic": false, 
                        "properties": {}, 
                        "fields": [
                           {
                              "index": true, 
                              "name": "reports", 
                              "include_in_all": true, 
                              "type": "text", 
                              "analyzer": "customAnalyzer1", 
                              "include_term_vectors": true, 
                              "store": false
                           }
                        ]
                     }
                  }, 
                  "fields": []
               }, 
               "email": {
                  "enabled": true, 
                  "dynamic": false, 
                  "properties": {}, 
                  "fields": [
                     {
                        "index": true, 
                        "name": "email", 
                        "include_in_all": true, 
                        "type": "text", 
                        "analyzer": "customAnalyzer1", 
                        "include_term_vectors": true, 
                        "store": false
                     }
                  ]
               }, 
               "name": {
                  "enabled": true, 
                  "dynamic": false, 
                  "properties": {}, 
                  "fields": [
                     {
                        "index": true, 
                        "name": "name", 
                        "include_in_all": true, 
                        "type": "text", 
                        "analyzer": "customAnalyzer1", 
                        "include_term_vectors": true, 
                        "store": false
                     }
                  ]
               }
            }, 
            "fields": []
         }
      }
   }
}
2016-08-09 11:27:48 | INFO | MainProcess | test_thread | [fts_base.create] Checking if index already exists ...
2016-08-09 11:27:50 | ERROR | MainProcess | test_thread | [rest_client._http_request] http://172.23.106.72:8094/api/index/custom_index error 403 reason: status: 403, content: rest_auth: preparePerm, err: index not found 
 rest_auth: preparePerm, err: index not found 
2016-08-09 11:27:51 | ERROR | MainProcess | test_thread | [rest_client._http_request] http://172.23.106.72:8094/api/index/custom_index error 403 reason: status: 403, content: rest_auth: preparePerm, err: index not found 
 rest_auth: preparePerm, err: index not found 
2016-08-09 11:27:51 | INFO | MainProcess | test_thread | [fts_base.create] Creating fulltext-index custom_index on 172.23.106.72
2016-08-09 11:27:51 | INFO | MainProcess | test_thread | [rest_client.create_fts_index] {"params": {"mapping": {"default_analyzer": "customAnalyzer1", "default_datetime_parser": "dateTimeOptional", "type_field": "type", "default_mapping": {"default_analyzer": "", "dynamic": true, "enabled": false}, "default_type": "_default", "analysis": {"analyzers": {"customAnalyzer1": {"type": "custom", "char_filters": ["html"], "tokenizer": "web", "token_filters": ["back_edge_ngram", "truncate", "to_lower"]}}, "token_filters": {"dict_compound_en": {"dict_token_map": "stop_en", "type": "dict_compound"}, "length": {"max": 5, "type": "length", "min": 3}, "truncate": {"length": 10, "type": "truncate_token"}, "dict_compound_fr": {"dict_token_map": "articles_fr", "type": "dict_compound"}, "ngram": {"max": 5, "type": "ngram", "min": 3}, "front_edge_ngram": {"max": 5, "type": "edge_ngram", "back": false, "min": 3}, "back_edge_ngram": {"max": 5, "type": "edge_ngram", "back": true, "min": 3}, "shingle": {"output_original": "false", "min": 2, "filler": "", "max": 5, "separator": "", "type": "shingle"}, "keyword_marker_en": {"type": "keyword_marker", "keywords_token_map": "stop_en"}}}, "default_field": "_all", "types": {"emp": {"enabled": true, "dynamic": false, "properties": {"mutated": {"enabled": true, "dynamic": false, "properties": {}, "fields": [{"index": true, "name": "mutated", "include_in_all": true, "type": "number", "analyzer": "", "include_term_vectors": true, "store": false}]}, "join_date": {"enabled": true, "dynamic": false, "properties": {}, "fields": [{"index": true, "name": "join_date", "include_in_all": true, "type": "datetime", "analyzer": "", "include_term_vectors": true, "store": false}]}, "manages": {"enabled": true, "dynamic": false, "properties": {"reports": {"enabled": true, "dynamic": false, "properties": {}, "fields": [{"index": true, "name": "reports", "include_in_all": true, "type": "text", "analyzer": "customAnalyzer1", "include_term_vectors": true, "store": false}]}}, "fields": []}, "email": {"enabled": true, "dynamic": false, "properties": {}, "fields": [{"index": true, "name": "email", "include_in_all": true, "type": "text", "analyzer": "customAnalyzer1", "include_term_vectors": true, "store": false}]}, "name": {"enabled": true, "dynamic": false, "properties": {}, "fields": [{"index": true, "name": "name", "include_in_all": true, "type": "text", "analyzer": "customAnalyzer1", "include_term_vectors": true, "store": false}]}}, "fields": []}}}}, "name": "custom_index", "planParams": {"hierarchyRules": null, "nodePlanParams": null, "numReplicas": 0, "planFrozen": false, "maxPartitionsPerPIndex": 32}, "sourceName": "default", "sourceUUID": "", "sourceType": "couchbase", "type": "fulltext-index", "sourceParams": {"authUser": "default", "dataManagerSleepMaxMS": 20000, "authSaslUser": "", "clusterManagerSleepMaxMS": 20000, "authSaslPassword": "", "clusterManagerSleepInitMS": 0, "dataManagerBackoffFactor": 0, "authPassword": "", "dataManagerSleepInitMS": 0, "feedBufferAckThreshold": 0, "feedBufferSizeBytes": 0, "clusterManagerBackoffFactor": 0}, "uuid": ""}
2016-08-09 11:27:51 | INFO | MainProcess | test_thread | [rest_client.create_fts_index] Index custom_index created
2016-08-09 11:27:51 | INFO | MainProcess | test_thread | [fts_base.is_index_partitioned_balanced] Validating index distribution for custom_index ...
2016-08-09 11:27:59 | INFO | MainProcess | test_thread | [fts_base.is_index_partitioned_balanced] Validated: Number of PIndexes = 32
2016-08-09 11:28:00 | INFO | MainProcess | test_thread | [fts_base.is_index_partitioned_balanced] Validated: Every pIndex serves 32 partitions or lesser
2016-08-09 11:28:00 | INFO | MainProcess | test_thread | [fts_base.is_index_partitioned_balanced] Validated: pIndexes are distributed across [u'01f2123585e97e23aae3e7def29a2bcc'] 
2016-08-09 11:28:00 | INFO | MainProcess | test_thread | [fts_base.is_index_partitioned_balanced] Expecting num of partitions in each node in range 992-1024
2016-08-09 11:28:00 | INFO | MainProcess | test_thread | [fts_base.is_index_partitioned_balanced] Validated: Node 01f2123585e97e23aae3e7def29a2bcc houses 32 pindexes which serve 1024 partitions
2016-08-09 11:28:00 | INFO | MainProcess | test_thread | [es_base.create_index_mapping] Creating es_index with mapping {
   "mappings": {
      "emp": {
         "dynamic": false, 
         "properties": {
            "mutated": {
               "index": "analyzed", 
               "type": "float", 
               "store": false
            }, 
            "join_date": {
               "index": "analyzed", 
               "type": "date", 
               "store": false
            }, 
            "manages": {
               "enabled": true, 
               "dynamic": false, 
               "properties": {
                  "reports": {
                     "index": "analyzed", 
                     "type": "string", 
                     "analyzer": "customAnalyzer1", 
                     "store": false, 
                     "term_vector": "yes"
                  }
               }, 
               "type": "object"
            }, 
            "email": {
               "index": "analyzed", 
               "type": "string", 
               "analyzer": "customAnalyzer1", 
               "store": false, 
               "term_vector": "yes"
            }, 
            "name": {
               "index": "analyzed", 
               "type": "string", 
               "analyzer": "customAnalyzer1", 
               "store": false, 
               "term_vector": "yes"
            }
         }
      }
   }, 
   "settings": {
      "analysis": {
         "filter": {
            "truncate": {
               "length": 10, 
               "type": "truncate"
            }, 
            "shingle": {
               "token_separator": "", 
               "output_unigrams": "false", 
               "filler_token": "", 
               "output_unigrams_if_no_shingles": "false", 
               "min_shingle_size": 2, 
               "type": "shingle", 
               "max_shingle_size": 5
            }, 
            "ngram": {
               "max_gram": 5, 
               "type": "nGram", 
               "side": "front", 
               "min_gram": 3
            }, 
            "keyword_marker_en": {
               "keywords": [
                  "i", 
                  "me", 
                  "my", 
                  "myself", 
                  "we", 
                  "our", 
                  "ours", 
                  "ourselves", 
                  "you", 
                  "your", 
                  "yours", 
                  "yourself", 
                  "yourselves", 
                  "he", 
                  "him", 
                  "his", 
                  "himself", 
                  "she", 
                  "her", 
                  "hers", 
                  "herself", 
                  "it", 
                  "its", 
                  "itself", 
                  "they", 
                  "them", 
                  "their", 
                  "theirs", 
                  "themselves", 
                  "what", 
                  "which", 
                  "who", 
                  "whom", 
                  "this", 
                  "that", 
                  "these", 
                  "those", 
                  "am", 
                  "is", 
                  "are", 
                  "was", 
                  "were", 
                  "be", 
                  "been", 
                  "being", 
                  "have", 
                  "has", 
                  "had", 
                  "having", 
                  "do", 
                  "does", 
                  "did", 
                  "doing", 
                  "would", 
                  "should", 
                  "could", 
                  "ought", 
                  "i'm", 
                  "you're", 
                  "he's", 
                  "she's", 
                  "it's", 
                  "we're", 
                  "they're", 
                  "i've", 
                  "you've", 
                  "we've", 
                  "they've", 
                  "i'd", 
                  "you'd", 
                  "he'd", 
                  "she'd", 
                  "we'd", 
                  "they'd", 
                  "i'll", 
                  "you'll", 
                  "he'll", 
                  "she'll", 
                  "we'll", 
                  "they'll", 
                  "isn't", 
                  "aren't", 
                  "wasn't", 
                  "weren't", 
                  "hasn't", 
                  "haven't", 
                  "hadn't", 
                  "doesn't", 
                  "don't", 
                  "didn't", 
                  "won't", 
                  "wouldn't", 
                  "shan't", 
                  "shouldn't", 
                  "can't", 
                  "cannot", 
                  "couldn't", 
                  "mustn't", 
                  "let's", 
                  "that's", 
                  "who's", 
                  "what's", 
                  "here's", 
                  "there's", 
                  "when's", 
                  "where's", 
                  "why's", 
                  "how's", 
                  "a", 
                  "an", 
                  "the", 
                  "and", 
                  "but", 
                  "if", 
                  "or", 
                  "because", 
                  "as", 
                  "until", 
                  "while", 
                  "of", 
                  "at", 
                  "by", 
                  "for", 
                  "with", 
                  "about", 
                  "against", 
                  "between", 
                  "into", 
                  "through", 
                  "during", 
                  "before", 
                  "after", 
                  "above", 
                  "below", 
                  "to", 
                  "from", 
                  "up", 
                  "down", 
                  "in", 
                  "out", 
                  "on", 
                  "off", 
                  "over", 
                  "under", 
                  "again", 
                  "further", 
                  "then", 
                  "once", 
                  "here", 
                  "there", 
                  "when", 
                  "where", 
                  "why", 
                  "how", 
                  "all", 
                  "any", 
                  "both", 
                  "each", 
                  "few", 
                  "more", 
                  "most", 
                  "other", 
                  "some", 
                  "such", 
                  "no", 
                  "nor", 
                  "not", 
                  "only", 
                  "own", 
                  "same", 
                  "so", 
                  "than", 
                  "too", 
                  "very"
               ], 
               "type": "keyword_marker"
            }, 
            "length": {
               "max": 5, 
               "type": "length", 
               "min": 3
            }, 
            "front_edge_ngram": {
               "max_gram": 5, 
               "type": "edgeNGram", 
               "side": "front", 
               "min_gram": 3
            }, 
            "back_edge_ngram": {
               "max_gram": 5, 
               "type": "edgeNGram", 
               "side": "back", 
               "min_gram": 3
            }
         }, 
         "analyzer": {
            "customAnalyzer1": {
               "filter": [
                  "back_edge_ngram", 
                  "truncate", 
                  "lowercase"
               ], 
               "char_filter": [
                  "html_strip"
               ], 
               "tokenizer": "uax_url_email"
            }
         }
      }
   }
}
2016-08-09 11:28:01 | INFO | MainProcess | test_thread | [es_base.create_index_mapping] SUCCESS: ES index created with above mapping
2016-08-09 11:28:01 | INFO | MainProcess | test_thread | [task.__init__] Starting operation 'create' on Elastic Search ...
2016-08-09 11:28:04 | INFO | MainProcess | test_thread | [data_helper.direct_client] creating direct client 172.23.106.72:11210 default
2016-08-09 11:28:06 | INFO | MainProcess | ES_Thread  | [task.execute] 1000 documents bulk loaded into ES
2016-08-09 11:28:07 | INFO | MainProcess | ES_Thread  | [task.execute] ES index count for 'es_index': 1000
2016-08-09 11:28:12 | INFO | MainProcess | test_thread | [fts_base.load_data] Loading phase complete!
2016-08-09 11:28:17 | INFO | MainProcess | test_thread | [fts_base.wait_for_indexing_complete] Docs in bucket = 1000, docs in FTS index 'custom_index': 496, docs in ES index: 1000 
2016-08-09 11:28:29 | INFO | MainProcess | test_thread | [fts_base.wait_for_indexing_complete] Docs in bucket = 1000, docs in FTS index 'custom_index': 1000, docs in ES index: 1000 
2016-08-09 11:28:29 | INFO | MainProcess | test_thread | [fts_base.wait_for_indexing_complete] FTS indexed 1000 docs in 0.29 mins
Smart queries will be generated on fields: {'date': ['join_date'], 'text': ['email', 'name', 'manages_reports'], 'num': ['manages_team_size', 'mutated'], 'str': ['email', 'name', 'manages_reports']}
2016-08-09 11:28:30 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 1 -----------------------------------------------------------------
2016-08-09 11:28:31 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"conjuncts": [{"field": "name", "match": "Trista Stewart"}, {"field": "email", "prefix": "gab"}, {"field": "email", "match_phrase": "basha@mcdiabetes.com"}, {"inclusive_max": true, "field": "manages.team_size", "max": 9882, "inclusive_min": true, "min": 9}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:28:32 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:28:32 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"conjuncts": [{"field": "name", "match": "Trista Stewart"}, {"field": "email", "prefix": "gab"}, {"field": "email", "match_phrase": "basha@mcdiabetes.com"}, {"inclusive_max": true, "field": "manages.team_size", "max": 9882, "inclusive_min": true, "min": 9}]} is 0 (took 15.587099ms)
2016-08-09 11:28:33 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"must": [{"match": {"name": "Trista Stewart"}}, {"prefix": {"email": "gab"}}, {"match_phrase": {"email": "basha@mcdiabetes.com"}}, {"filtered": {"filter": {"range": {"manages.team_size": {"gte": 9, "lte": 9882}}}}}]}} on es_index is 0 (took 1ms)
2016-08-09 11:28:33 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:28:33 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 2 -----------------------------------------------------------------
2016-08-09 11:28:34 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "manages.reports", "match": "Lucretia Sirena"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:28:36 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:28:36 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "manages.reports", "match": "Lucretia Sirena"} is 149 (took 10.583223ms)
2016-08-09 11:28:37 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match": {"manages.reports": "Lucretia Sirena"}} on es_index is 149 (took 5ms)
2016-08-09 11:28:37 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:28:37 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 3 -----------------------------------------------------------------
2016-08-09 11:28:39 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"query": "+mutated:>2 +mutated:<=6112 name:\"Josué\" -manages.reports:\"Maura Keelia Kallie\""}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:28:40 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:28:40 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"query": "+mutated:>2 +mutated:<=6112 name:\"Josué\" -manages.reports:\"Maura Keelia Kallie\""} is 0 (took 93.056239ms)
2016-08-09 11:28:41 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"query_string": {"query": "+mutated:>2 +mutated:<=6112 name:\"Josué\" -manages.reports:\"Maura Keelia Kallie\""}} on es_index is 0 (took 1ms)
2016-08-09 11:28:41 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:28:41 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 4 -----------------------------------------------------------------
2016-08-09 11:28:42 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_start": true, "field": "join_date", "inclusive_end": true, "end": "2016-08-09T11:28:29.453778", "start": "2008-03-16T05:58:00"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:28:43 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:28:43 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_start": true, "field": "join_date", "inclusive_end": true, "end": "2016-08-09T11:28:29.453778", "start": "2008-03-16T05:58:00"} is 122 (took 31.553516ms)
2016-08-09 11:28:44 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"join_date": {"gte": "2008-03-16T05:58:00", "lte": "2016-08-09T11:28:29.453778"}}}}} on es_index is 122 (took 5ms)
2016-08-09 11:28:44 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:28:44 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 5 -----------------------------------------------------------------
2016-08-09 11:28:46 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "email", "wildcard": "winta@mcdi*"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:28:47 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:28:47 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "email", "wildcard": "winta@mcdi*"} is 0 (took 1.75137ms)
2016-08-09 11:28:48 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"wildcard": {"email": "winta@mcdi*"}} on es_index is 0 (took 1ms)
2016-08-09 11:28:48 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:28:48 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 6 -----------------------------------------------------------------
2016-08-09 11:28:49 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "name", "match": "Chatha"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:28:50 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:28:50 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "name", "match": "Chatha"} is 11 (took 8.994762ms)
2016-08-09 11:28:51 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match": {"name": "Chatha"}} on es_index is 11 (took 2ms)
2016-08-09 11:28:51 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:28:51 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 7 -----------------------------------------------------------------
2016-08-09 11:28:52 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "email", "prefix": "per"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:28:53 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:28:53 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "email", "prefix": "per"} is 0 (took 3.042502ms)
2016-08-09 11:28:54 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"prefix": {"email": "per"}} on es_index is 0 (took 1ms)
2016-08-09 11:28:54 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:28:54 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 8 -----------------------------------------------------------------
2016-08-09 11:28:55 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.454201", "start": "2003-04-07T04:49:00"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:28:57 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:28:57 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.454201", "start": "2003-04-07T04:49:00"} is 197 (took 60.065022ms)
2016-08-09 11:28:58 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"join_date": {"lt": "2016-08-09T11:28:29.454201", "gt": "2003-04-07T04:49:00"}}}}} on es_index is 197 (took 6ms)
2016-08-09 11:28:58 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:28:58 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 9 -----------------------------------------------------------------
2016-08-09 11:29:00 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"query": "name:\"Ambika Wells\""}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:29:01 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:29:01 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"query": "name:\"Ambika Wells\""} is 0 (took 5.462074ms)
2016-08-09 11:29:01 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"query_string": {"query": "name:\"Ambika Wells\""}} on es_index is 0 (took 1ms)
2016-08-09 11:29:01 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:29:01 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 10 -----------------------------------------------------------------
2016-08-09 11:29:03 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"conjuncts": [{"field": "manages.reports", "match": "Dominique Kory Cynara"}, {"field": "email", "prefix": "kimb"}, {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.454494", "start": "1983-08-20T23:21:00"}, {"inclusive_max": false, "field": "manages.team_size", "max": 3362, "inclusive_min": false, "min": 8}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:29:04 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:29:04 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"conjuncts": [{"field": "manages.reports", "match": "Dominique Kory Cynara"}, {"field": "email", "prefix": "kimb"}, {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.454494", "start": "1983-08-20T23:21:00"}, {"inclusive_max": false, "field": "manages.team_size", "max": 3362, "inclusive_min": false, "min": 8}]} is 0 (took 104.48613ms)
2016-08-09 11:29:05 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"must": [{"match": {"manages.reports": "Dominique Kory Cynara"}}, {"prefix": {"email": "kimb"}}, {"filtered": {"filter": {"range": {"join_date": {"lt": "2016-08-09T11:28:29.454494", "gt": "1983-08-20T23:21:00"}}}}}, {"filtered": {"filter": {"range": {"manages.team_size": {"lt": 3362, "gt": 8}}}}}]}} on es_index is 0 (took 1ms)
2016-08-09 11:29:05 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:29:05 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 11 -----------------------------------------------------------------
2016-08-09 11:29:06 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.454767", "start": "1957-03-23T07:48:00"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:29:09 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:29:09 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.454767", "start": "1957-03-23T07:48:00"} is 882 (took 45.816323ms)
2016-08-09 11:29:12 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"join_date": {"lt": "2016-08-09T11:28:29.454767", "gt": "1957-03-23T07:48:00"}}}}} on es_index is 882 (took 21ms)
2016-08-09 11:29:12 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:29:12 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 12 -----------------------------------------------------------------
2016-08-09 11:29:13 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "manages.reports", "match_phrase": "Quella"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:29:14 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:29:14 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "manages.reports", "match_phrase": "Quella"} is 48 (took 6.43689ms)
2016-08-09 11:29:15 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match_phrase": {"manages.reports": "Quella"}} on es_index is 91 (took 4ms)
2016-08-09 11:29:15 | ERROR | MainProcess | Cluster_Thread | [task.execute] FAIL: FTS hits: 48, while ES hits: 91
2016-08-09 11:29:15 | ERROR | MainProcess | Cluster_Thread | [task.execute] FAIL: Following 43 docs were not returned by FTS, but ES, printing 50: [u'emp10000305', u'emp10000306', u'emp10000308', u'emp10000558', u'emp10000793', u'emp10000479', u'emp10000381', u'emp10000579', u'emp10000084', u'emp10000892', u'emp10000974', u'emp10000899', u'emp10000898', u'emp10000288', u'emp10000957', u'emp10000168', u'emp10000831', u'emp10000607', u'emp10000666', u'emp10000916', u'emp10000603', u'emp10000174', u'emp10000028', u'emp10000057', u'emp10000648', u'emp10000076', u'emp10000746', u'emp10000319', u'emp10000507', u'emp10000371', u'emp10000686', u'emp10000016', u'emp10000378', u'emp10000179', u'emp10000546', u'emp10000618', u'emp10000506', u'emp10000847', u'emp10000803', u'emp10000719', u'emp10000191', u'emp10000710', u'emp10000261']
2016-08-09 11:29:15 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 13 -----------------------------------------------------------------
2016-08-09 11:29:17 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"query": "email:\"killian@mcdiabetes.com\""}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:29:19 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:29:19 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"query": "email:\"killian@mcdiabetes.com\""} is 1000 (took 11.687251ms)
2016-08-09 11:29:22 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"query_string": {"query": "email:\"killian@mcdiabetes.com\""}} on es_index is 1000 (took 22ms)
2016-08-09 11:29:22 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:29:22 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 14 -----------------------------------------------------------------
2016-08-09 11:29:23 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"query": "-email:\"ambika@mcdiabetes.com\""}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:29:24 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:29:24 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"query": "-email:\"ambika@mcdiabetes.com\""} is 0 (took 118.949094ms)
2016-08-09 11:29:25 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"query_string": {"query": "-email:\"ambika@mcdiabetes.com\""}} on es_index is 0 (took 1ms)
2016-08-09 11:29:25 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:29:25 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 15 -----------------------------------------------------------------
2016-08-09 11:29:26 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"query": "-mutated:>1 +mutated:<4794 mutated:>5 +mutated:<2215 -manages.reports:\"Kory Dominique Ciara\""}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:29:28 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:29:28 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"query": "-mutated:>1 +mutated:<4794 mutated:>5 +mutated:<2215 -manages.reports:\"Kory Dominique Ciara\""} is 1000 (took 168.067093ms)
2016-08-09 11:29:31 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"query_string": {"query": "-mutated:>1 +mutated:<4794 mutated:>5 +mutated:<2215 -manages.reports:\"Kory Dominique Ciara\""}} on es_index is 1000 (took 23ms)
2016-08-09 11:29:31 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:29:31 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 16 -----------------------------------------------------------------
2016-08-09 11:29:33 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"conjuncts": [{"field": "email", "match": "kimberly@mcdiabetes.com"}, {"field": "manages.reports", "prefix": "Ber"}, {"inclusive_start": true, "field": "join_date", "inclusive_end": true, "end": "2016-08-09T11:28:29.455283", "start": "1994-01-20T21:52:00"}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:29:34 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:29:34 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"conjuncts": [{"field": "email", "match": "kimberly@mcdiabetes.com"}, {"field": "manages.reports", "prefix": "Ber"}, {"inclusive_start": true, "field": "join_date", "inclusive_end": true, "end": "2016-08-09T11:28:29.455283", "start": "1994-01-20T21:52:00"}]} is 0 (took 41.462762ms)
2016-08-09 11:29:34 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"must": [{"match": {"email": "kimberly@mcdiabetes.com"}}, {"prefix": {"manages.reports": "Ber"}}, {"filtered": {"filter": {"range": {"join_date": {"gte": "1994-01-20T21:52:00", "lte": "2016-08-09T11:28:29.455283"}}}}}]}} on es_index is 0 (took 2ms)
2016-08-09 11:29:34 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:29:34 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 17 -----------------------------------------------------------------
2016-08-09 11:29:36 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"query": "+mutated:<1"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:29:38 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:29:38 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"query": "+mutated:<1"} is 1000 (took 62.377061ms)
2016-08-09 11:29:41 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"query_string": {"query": "+mutated:<1"}} on es_index is 1000 (took 20ms)
2016-08-09 11:29:41 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:29:41 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 18 -----------------------------------------------------------------
2016-08-09 11:29:43 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "email", "prefix": "chat"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:29:44 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:29:44 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "email", "prefix": "chat"} is 0 (took 2.208824ms)
2016-08-09 11:29:45 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"prefix": {"email": "chat"}} on es_index is 0 (took 1ms)
2016-08-09 11:29:45 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:29:45 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 19 -----------------------------------------------------------------
2016-08-09 11:29:46 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "name", "prefix": "Ann"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:29:47 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:29:47 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "name", "prefix": "Ann"} is 0 (took 2.232896ms)
2016-08-09 11:29:48 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"prefix": {"name": "Ann"}} on es_index is 0 (took 1ms)
2016-08-09 11:29:48 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:29:48 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 20 -----------------------------------------------------------------
2016-08-09 11:29:49 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_max": false, "field": "manages.team_size", "max": 8299, "inclusive_min": false, "min": 9}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:29:50 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:29:50 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_max": false, "field": "manages.team_size", "max": 8299, "inclusive_min": false, "min": 9} is 0 (took 41.634025ms)
2016-08-09 11:29:51 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"manages.team_size": {"lt": 8299, "gt": 9}}}}} on es_index is 0 (took 1ms)
2016-08-09 11:29:51 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:29:51 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 21 -----------------------------------------------------------------
2016-08-09 11:29:52 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"disjuncts": [{"field": "name", "match": "Casondrah Campbell"}, {"field": "manages.reports", "match": "Severin Adrianne Severin"}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:29:54 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:29:54 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"disjuncts": [{"field": "name", "match": "Casondrah Campbell"}, {"field": "manages.reports", "match": "Severin Adrianne Severin"}]} is 173 (took 69.676472ms)
2016-08-09 11:29:55 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"should": [{"match": {"name": "Casondrah Campbell"}}, {"match": {"manages.reports": "Severin Adrianne Severin"}}]}} on es_index is 173 (took 7ms)
2016-08-09 11:29:55 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:29:55 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 22 -----------------------------------------------------------------
2016-08-09 11:29:57 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "name", "wildcard": "?mbika"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:29:58 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:29:58 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "name", "wildcard": "?mbika"} is 0 (took 22.357234ms)
2016-08-09 11:29:59 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"wildcard": {"name": "?mbika"}} on es_index is 0 (took 1ms)
2016-08-09 11:29:59 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:29:59 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 23 -----------------------------------------------------------------
2016-08-09 11:30:00 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "name", "match_phrase": "Sidonia Gerónimo"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:30:01 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:30:01 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "name", "match_phrase": "Sidonia Gerónimo"} is 0 (took 5.509591ms)
2016-08-09 11:30:02 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match_phrase": {"name": "Sidonia Gerónimo"}} on es_index is 1 (took 1ms)
2016-08-09 11:30:02 | ERROR | MainProcess | Cluster_Thread | [task.execute] FAIL: FTS hits: 0, while ES hits: 1
2016-08-09 11:30:02 | ERROR | MainProcess | Cluster_Thread | [task.execute] FAIL: Following 1 docs were not returned by FTS, but ES, printing 50: [u'emp10000318']
2016-08-09 11:30:02 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 24 -----------------------------------------------------------------
2016-08-09 11:30:03 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"query": "-mutated:>2 +mutated:<=8380"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:30:06 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:30:06 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"query": "-mutated:>2 +mutated:<=8380"} is 1000 (took 90.012691ms)
2016-08-09 11:30:09 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"query_string": {"query": "-mutated:>2 +mutated:<=8380"}} on es_index is 1000 (took 23ms)
2016-08-09 11:30:09 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:30:09 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 25 -----------------------------------------------------------------
2016-08-09 11:30:10 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_max": true, "field": "mutated", "max": 839, "inclusive_min": true, "min": 3}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:30:12 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:30:12 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_max": true, "field": "mutated", "max": 839, "inclusive_min": true, "min": 3} is 0 (took 9.757027ms)
2016-08-09 11:30:12 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"mutated": {"gte": 3, "lte": 839}}}}} on es_index is 0 (took 1ms)
2016-08-09 11:30:12 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:30:12 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 26 -----------------------------------------------------------------
2016-08-09 11:30:14 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_max": false, "field": "manages.team_size", "max": 4186, "inclusive_min": false, "min": 10}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:30:15 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:30:15 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_max": false, "field": "manages.team_size", "max": 4186, "inclusive_min": false, "min": 10} is 0 (took 28.295502ms)
2016-08-09 11:30:16 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"manages.team_size": {"lt": 4186, "gt": 10}}}}} on es_index is 0 (took 1ms)
2016-08-09 11:30:16 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:30:16 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 27 -----------------------------------------------------------------
2016-08-09 11:30:17 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_start": true, "field": "join_date", "inclusive_end": true, "end": "2016-08-09T11:28:29.456388", "start": "1950-10-15T02:07:00"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:30:20 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:30:20 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_start": true, "field": "join_date", "inclusive_end": true, "end": "2016-08-09T11:28:29.456388", "start": "1950-10-15T02:07:00"} is 978 (took 54.508895ms)
2016-08-09 11:30:23 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"join_date": {"gte": "1950-10-15T02:07:00", "lte": "2016-08-09T11:28:29.456388"}}}}} on es_index is 978 (took 26ms)
2016-08-09 11:30:23 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:30:24 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 28 -----------------------------------------------------------------
2016-08-09 11:30:25 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_max": false, "field": "manages.team_size", "max": 1833, "inclusive_min": false, "min": 9}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:30:26 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:30:26 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_max": false, "field": "manages.team_size", "max": 1833, "inclusive_min": false, "min": 9} is 0 (took 41.491499ms)
2016-08-09 11:30:27 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"manages.team_size": {"lt": 1833, "gt": 9}}}}} on es_index is 0 (took 1ms)
2016-08-09 11:30:27 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:30:27 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 29 -----------------------------------------------------------------
2016-08-09 11:30:28 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"conjuncts": [{"field": "email", "match": "cynara@mcdiabetes.com"}, {"field": "manages.reports", "match_phrase": "Balandria Hedda Kerry Deirdre"}, {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.456692", "start": "2007-01-06T06:18:00"}, {"inclusive_max": true, "field": "mutated", "max": 8469, "inclusive_min": true, "min": 5}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:30:29 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:30:29 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"conjuncts": [{"field": "email", "match": "cynara@mcdiabetes.com"}, {"field": "manages.reports", "match_phrase": "Balandria Hedda Kerry Deirdre"}, {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.456692", "start": "2007-01-06T06:18:00"}, {"inclusive_max": true, "field": "mutated", "max": 8469, "inclusive_min": true, "min": 5}]} is 0 (took 119.63703ms)
2016-08-09 11:30:30 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"must": [{"match": {"email": "cynara@mcdiabetes.com"}}, {"match_phrase": {"manages.reports": "Balandria Hedda Kerry Deirdre"}}, {"filtered": {"filter": {"range": {"join_date": {"lt": "2016-08-09T11:28:29.456692", "gt": "2007-01-06T06:18:00"}}}}}, {"filtered": {"filter": {"range": {"mutated": {"gte": 5, "lte": 8469}}}}}]}} on es_index is 0 (took 2ms)
2016-08-09 11:30:30 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:30:30 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 30 -----------------------------------------------------------------
2016-08-09 11:30:31 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "name", "match_phrase": "Lilith Gerónimo"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:30:32 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:30:32 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "name", "match_phrase": "Lilith Gerónimo"} is 0 (took 3.950655ms)
2016-08-09 11:30:33 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match_phrase": {"name": "Lilith Gerónimo"}} on es_index is 0 (took 1ms)
2016-08-09 11:30:33 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:30:33 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 31 -----------------------------------------------------------------
2016-08-09 11:30:34 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"query": "+mutated:>1 +mutated:<5873 mutated:>2 -mutated:>1 +mutated:<9895"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:30:35 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:30:35 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"query": "+mutated:>1 +mutated:<5873 mutated:>2 -mutated:>1 +mutated:<9895"} is 0 (took 185.46347ms)
2016-08-09 11:30:36 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"query_string": {"query": "+mutated:>1 +mutated:<5873 mutated:>2 -mutated:>1 +mutated:<9895"}} on es_index is 0 (took 1ms)
2016-08-09 11:30:36 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:30:36 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 32 -----------------------------------------------------------------
2016-08-09 11:30:37 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "manages.reports", "match": "Dabria Safiya Dabria"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:30:39 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:30:39 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "manages.reports", "match": "Dabria Safiya Dabria"} is 171 (took 13.292396ms)
2016-08-09 11:30:41 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match": {"manages.reports": "Dabria Safiya Dabria"}} on es_index is 171 (took 6ms)
2016-08-09 11:30:41 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:30:41 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 33 -----------------------------------------------------------------
2016-08-09 11:30:42 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_max": true, "field": "mutated", "max": 3374, "inclusive_min": true, "min": 2}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:30:43 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:30:43 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_max": true, "field": "mutated", "max": 3374, "inclusive_min": true, "min": 2} is 0 (took 10.866186ms)
2016-08-09 11:30:44 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"mutated": {"gte": 2, "lte": 3374}}}}} on es_index is 0 (took 1ms)
2016-08-09 11:30:44 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:30:44 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 34 -----------------------------------------------------------------
2016-08-09 11:30:45 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "name", "match": "Winta"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:30:46 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:30:46 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "name", "match": "Winta"} is 20 (took 5.288474ms)
2016-08-09 11:30:47 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match": {"name": "Winta"}} on es_index is 20 (took 1ms)
2016-08-09 11:30:47 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:30:47 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 35 -----------------------------------------------------------------
2016-08-09 11:30:48 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"disjuncts": [{"field": "manages.reports", "match": "Beryl"}, {"field": "name", "match": "Nicolás"}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:30:50 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:30:50 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"disjuncts": [{"field": "manages.reports", "match": "Beryl"}, {"field": "name", "match": "Nicolás"}]} is 58 (took 6.448014ms)
2016-08-09 11:30:51 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"should": [{"match": {"manages.reports": "Beryl"}}, {"match": {"name": "Nicolás"}}]}} on es_index is 58 (took 4ms)
2016-08-09 11:30:51 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:30:51 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 36 -----------------------------------------------------------------
2016-08-09 11:30:52 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"query": "+mutated:>1 +mutated:<614"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:30:54 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:30:54 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"query": "+mutated:>1 +mutated:<614"} is 0 (took 28.816372ms)
2016-08-09 11:30:54 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"query_string": {"query": "+mutated:>1 +mutated:<614"}} on es_index is 0 (took 1ms)
2016-08-09 11:30:54 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:30:54 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 37 -----------------------------------------------------------------
2016-08-09 11:30:55 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "manages.reports", "match": "Ambika"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:30:57 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:30:57 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "manages.reports", "match": "Ambika"} is 36 (took 4.613867ms)
2016-08-09 11:30:58 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match": {"manages.reports": "Ambika"}} on es_index is 36 (took 2ms)
2016-08-09 11:30:58 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:30:58 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 38 -----------------------------------------------------------------
2016-08-09 11:30:59 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_start": true, "field": "join_date", "inclusive_end": true, "end": "2016-08-09T11:28:29.457953", "start": "1989-02-06T02:49:00"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:31:01 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:31:01 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_start": true, "field": "join_date", "inclusive_end": true, "end": "2016-08-09T11:28:29.457953", "start": "1989-02-06T02:49:00"} is 409 (took 44.503576ms)
2016-08-09 11:31:03 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"join_date": {"gte": "1989-02-06T02:49:00", "lte": "2016-08-09T11:28:29.457953"}}}}} on es_index is 409 (took 14ms)
2016-08-09 11:31:03 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:31:03 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 39 -----------------------------------------------------------------
2016-08-09 11:31:05 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "manages.reports", "match_phrase": "Kimberly Araceli"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:31:06 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:31:06 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "manages.reports", "match_phrase": "Kimberly Araceli"} is 0 (took 4.809008ms)
2016-08-09 11:31:06 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match_phrase": {"manages.reports": "Kimberly Araceli"}} on es_index is 0 (took 2ms)
2016-08-09 11:31:06 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:31:06 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 40 -----------------------------------------------------------------
2016-08-09 11:31:07 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "email", "prefix": "t"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:31:09 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:31:09 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "email", "prefix": "t"} is 0 (took 1.039501ms)
2016-08-09 11:31:10 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"prefix": {"email": "t"}} on es_index is 0 (took 1ms)
2016-08-09 11:31:10 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:31:10 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 41 -----------------------------------------------------------------
2016-08-09 11:31:11 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_max": false, "field": "manages.team_size", "max": 5472, "inclusive_min": false, "min": 7}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:31:13 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:31:13 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_max": false, "field": "manages.team_size", "max": 5472, "inclusive_min": false, "min": 7} is 0 (took 38.322009ms)
2016-08-09 11:31:14 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"manages.team_size": {"lt": 5472, "gt": 7}}}}} on es_index is 0 (took 1ms)
2016-08-09 11:31:14 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:31:14 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 42 -----------------------------------------------------------------
2016-08-09 11:31:15 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_max": true, "field": "mutated", "max": 5642, "inclusive_min": true, "min": 2}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:31:16 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:31:16 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_max": true, "field": "mutated", "max": 5642, "inclusive_min": true, "min": 2} is 0 (took 6.911615ms)
2016-08-09 11:31:17 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"mutated": {"gte": 2, "lte": 5642}}}}} on es_index is 0 (took 1ms)
2016-08-09 11:31:17 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:31:17 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 43 -----------------------------------------------------------------
2016-08-09 11:31:19 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"query": "email:\"kimberly@mcdiabetes.com\""}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:31:23 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:31:23 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"query": "email:\"kimberly@mcdiabetes.com\""} is 1000 (took 15.756453ms)
2016-08-09 11:31:28 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"query_string": {"query": "email:\"kimberly@mcdiabetes.com\""}} on es_index is 1000 (took 24ms)
2016-08-09 11:31:28 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:31:28 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 44 -----------------------------------------------------------------
2016-08-09 11:31:29 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "manages.reports", "match": "Thea Adara Kory"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:31:31 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:31:31 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "manages.reports", "match": "Thea Adara Kory"} is 199 (took 8.076681ms)
2016-08-09 11:31:33 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match": {"manages.reports": "Thea Adara Kory"}} on es_index is 199 (took 7ms)
2016-08-09 11:31:33 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:31:33 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 45 -----------------------------------------------------------------
2016-08-09 11:31:34 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "email", "match_phrase": "deandra@mcdiabetes.com"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:31:37 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:31:37 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "email", "match_phrase": "deandra@mcdiabetes.com"} is 1000 (took 13.342537ms)
2016-08-09 11:31:43 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match_phrase": {"email": "deandra@mcdiabetes.com"}} on es_index is 1000 (took 20ms)
2016-08-09 11:31:43 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:31:43 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 46 -----------------------------------------------------------------
2016-08-09 11:31:44 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "manages.reports", "wildcard": "Beryl Devi Da*"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:31:45 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:31:45 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "manages.reports", "wildcard": "Beryl Devi Da*"} is 0 (took 2.987172ms)
2016-08-09 11:31:45 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"wildcard": {"manages.reports": "Beryl Devi Da*"}} on es_index is 0 (took 1ms)
2016-08-09 11:31:45 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:31:45 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 47 -----------------------------------------------------------------
2016-08-09 11:31:47 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"disjuncts": [{"field": "manages.reports", "match": "Casondrah"}, {"field": "email", "match": "adena@mcdiabetes.com"}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:31:50 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:31:50 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"disjuncts": [{"field": "manages.reports", "match": "Casondrah"}, {"field": "email", "match": "adena@mcdiabetes.com"}]} is 1000 (took 26.056145ms)
2016-08-09 11:31:55 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"should": [{"match": {"manages.reports": "Casondrah"}}, {"match": {"email": "adena@mcdiabetes.com"}}]}} on es_index is 1000 (took 24ms)
2016-08-09 11:31:55 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:31:55 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 48 -----------------------------------------------------------------
2016-08-09 11:31:56 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"conjuncts": [{"field": "email", "match": "basha@mcdiabetes.com"}, {"field": "name", "prefix": "Sir"}, {"field": "manages.reports", "match_phrase": "Kala Amara Duvessa"}, {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.459296", "start": "1985-08-24T11:47:00"}, {"inclusive_max": true, "field": "mutated", "max": 7986, "inclusive_min": true, "min": 5}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:31:58 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:31:58 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"conjuncts": [{"field": "email", "match": "basha@mcdiabetes.com"}, {"field": "name", "prefix": "Sir"}, {"field": "manages.reports", "match_phrase": "Kala Amara Duvessa"}, {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.459296", "start": "1985-08-24T11:47:00"}, {"inclusive_max": true, "field": "mutated", "max": 7986, "inclusive_min": true, "min": 5}]} is 0 (took 64.304336ms)
2016-08-09 11:31:58 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"must": [{"match": {"email": "basha@mcdiabetes.com"}}, {"prefix": {"name": "Sir"}}, {"match_phrase": {"manages.reports": "Kala Amara Duvessa"}}, {"filtered": {"filter": {"range": {"join_date": {"lt": "2016-08-09T11:28:29.459296", "gt": "1985-08-24T11:47:00"}}}}}, {"filtered": {"filter": {"range": {"mutated": {"gte": 5, "lte": 7986}}}}}]}} on es_index is 0 (took 2ms)
2016-08-09 11:31:58 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:31:58 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 49 -----------------------------------------------------------------
2016-08-09 11:31:59 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"conjuncts": [{"field": "email", "match": "kacila@mcdiabetes.com"}, {"inclusive_max": false, "field": "manages.team_size", "max": 7735, "inclusive_min": false, "min": 9}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:32:01 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:32:01 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"conjuncts": [{"field": "email", "match": "kacila@mcdiabetes.com"}, {"inclusive_max": false, "field": "manages.team_size", "max": 7735, "inclusive_min": false, "min": 9}]} is 0 (took 44.640344ms)
2016-08-09 11:32:01 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"must": [{"match": {"email": "kacila@mcdiabetes.com"}}, {"filtered": {"filter": {"range": {"manages.team_size": {"lt": 7735, "gt": 9}}}}}]}} on es_index is 0 (took 1ms)
2016-08-09 11:32:01 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:32:01 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 50 -----------------------------------------------------------------
2016-08-09 11:32:02 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"conjuncts": [{"field": "name", "match": "Chatha Edwards Sr."}, {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.459754", "start": "1977-06-25T17:40:00"}, {"inclusive_max": false, "field": "mutated", "max": 6121, "inclusive_min": false, "min": 2}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:32:04 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:32:04 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"conjuncts": [{"field": "name", "match": "Chatha Edwards Sr."}, {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.459754", "start": "1977-06-25T17:40:00"}, {"inclusive_max": false, "field": "mutated", "max": 6121, "inclusive_min": false, "min": 2}]} is 0 (took 125.124985ms)
2016-08-09 11:32:05 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"must": [{"match": {"name": "Chatha Edwards Sr."}}, {"filtered": {"filter": {"range": {"join_date": {"lt": "2016-08-09T11:28:29.459754", "gt": "1977-06-25T17:40:00"}}}}}, {"filtered": {"filter": {"range": {"mutated": {"lt": 6121, "gt": 2}}}}}]}} on es_index is 0 (took 2ms)
2016-08-09 11:32:05 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:32:05 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 51 -----------------------------------------------------------------
2016-08-09 11:32:06 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"should": {"disjuncts": [{"field": "email", "match": "kallie@mcdiabetes.com"}, {"field": "name", "match": "Kory Cox"}]}}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:32:10 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:32:10 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"should": {"disjuncts": [{"field": "email", "match": "kallie@mcdiabetes.com"}, {"field": "name", "match": "Kory Cox"}]}} is 1000 (took 66.274181ms)
2016-08-09 11:32:15 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"should": [{"match": {"email": "kallie@mcdiabetes.com"}}, {"match": {"name": "Kory Cox"}}]}} on es_index is 1000 (took 24ms)
2016-08-09 11:32:15 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:32:15 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 52 -----------------------------------------------------------------
2016-08-09 11:32:16 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_max": false, "field": "mutated", "max": 1115, "inclusive_min": false, "min": 4}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:32:17 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:32:17 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_max": false, "field": "mutated", "max": 1115, "inclusive_min": false, "min": 4} is 0 (took 61.3138ms)
2016-08-09 11:32:18 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"mutated": {"lt": 1115, "gt": 4}}}}} on es_index is 0 (took 1ms)
2016-08-09 11:32:18 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:32:18 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 53 -----------------------------------------------------------------
2016-08-09 11:32:19 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"query": "-mutated:>5 mutated:>=0 manages.reports:\"Quella Hedda Maura\""}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:32:22 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:32:22 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"query": "-mutated:>5 mutated:>=0 manages.reports:\"Quella Hedda Maura\""} is 1000 (took 67.8914ms)
2016-08-09 11:32:28 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"query_string": {"query": "-mutated:>5 mutated:>=0 manages.reports:\"Quella Hedda Maura\""}} on es_index is 1000 (took 22ms)
2016-08-09 11:32:28 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:32:28 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 54 -----------------------------------------------------------------
2016-08-09 11:32:29 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "email", "prefix": "del"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:32:30 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:32:30 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "email", "prefix": "del"} is 0 (took 2.093235ms)
2016-08-09 11:32:31 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"prefix": {"email": "del"}} on es_index is 0 (took 1ms)
2016-08-09 11:32:31 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:32:31 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 55 -----------------------------------------------------------------
2016-08-09 11:32:32 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "email", "match": "ciara@mcdiabetes.com"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:32:35 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:32:35 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "email", "match": "ciara@mcdiabetes.com"} is 1000 (took 25.176595ms)
2016-08-09 11:32:38 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match": {"email": "ciara@mcdiabetes.com"}} on es_index is 1000 (took 21ms)
2016-08-09 11:32:38 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:32:38 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 56 -----------------------------------------------------------------
2016-08-09 11:32:40 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"disjuncts": [{"field": "name", "match": "Duvessa"}, {"field": "email", "match": "quella@mcdiabetes.com"}, {"field": "manages.reports", "match": "Kory Duvessa Dabria Araceli"}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:32:43 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:32:43 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"disjuncts": [{"field": "name", "match": "Duvessa"}, {"field": "email", "match": "quella@mcdiabetes.com"}, {"field": "manages.reports", "match": "Kory Duvessa Dabria Araceli"}]} is 1000 (took 79.364494ms)
2016-08-09 11:32:46 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"should": [{"match": {"name": "Duvessa"}}, {"match": {"email": "quella@mcdiabetes.com"}}, {"match": {"manages.reports": "Kory Duvessa Dabria Araceli"}}]}} on es_index is 1000 (took 28ms)
2016-08-09 11:32:46 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:32:46 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 57 -----------------------------------------------------------------
2016-08-09 11:32:48 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"should": {"disjuncts": [{"field": "name", "match": "Delores Johnson"}, {"field": "name", "match": "Riona Adams"}]}, "must_not": {"disjuncts": [{"field": "name", "match": "Riona"}, {"field": "name", "match": "Juan José"}]}, "must": {"conjuncts": [{"field": "manages.reports", "match": "Antonia Mia"}]}}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:32:49 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:32:49 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"should": {"disjuncts": [{"field": "name", "match": "Delores Johnson"}, {"field": "name", "match": "Riona Adams"}]}, "must_not": {"disjuncts": [{"field": "name", "match": "Riona"}, {"field": "name", "match": "Juan José"}]}, "must": {"conjuncts": [{"field": "manages.reports", "match": "Antonia Mia"}]}} is 93 (took 17.929216ms)
2016-08-09 11:32:51 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"should": [{"match": {"name": "Delores Johnson"}}, {"match": {"name": "Riona Adams"}}], "must_not": [{"match": {"name": "Riona"}}, {"match": {"name": "Juan José"}}], "must": {"match": {"manages.reports": "Antonia Mia"}}}} on es_index is 144 (took 4ms)
2016-08-09 11:32:51 | ERROR | MainProcess | Cluster_Thread | [task.execute] FAIL: FTS hits: 93, while ES hits: 144
2016-08-09 11:32:51 | ERROR | MainProcess | Cluster_Thread | [task.execute] FAIL: Following 51 docs were not returned by FTS, but ES, printing 50: [u'emp10000675', u'emp10000419', u'emp10000734', u'emp10000417', u'emp10000102', u'emp10000022', u'emp10000175', u'emp10000120', u'emp10000343', u'emp10000894', u'emp10000994', u'emp10000978', u'emp10000997', u'emp10000205', u'emp10000484', u'emp10000084', u'emp10000936', u'emp10000747', u'emp10000607', u'emp10000914', u'emp10000582', u'emp10000705', u'emp10000641', u'emp10000052', u'emp10000952', u'emp10000132', u'emp10000071', u'emp10000319', u'emp10000594', u'emp10000112', u'emp10000225', u'emp10000038', u'emp10000464', u'emp10000393', u'emp10000466', u'emp10000544', u'emp10000996', u'emp10000985', u'emp10000340', u'emp10000191', u'emp10000505', u'emp10000803', u'emp10000495', u'emp10000772', u'emp10000804', u'emp10000639', u'emp10000775', u'emp10000809', u'emp10000907', u'emp10000714']
2016-08-09 11:32:51 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 58 -----------------------------------------------------------------
2016-08-09 11:32:52 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "email", "prefix": "ada"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:32:53 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:32:53 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "email", "prefix": "ada"} is 0 (took 5.074017ms)
2016-08-09 11:32:53 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"prefix": {"email": "ada"}} on es_index is 0 (took 1ms)
2016-08-09 11:32:53 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:32:53 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 59 -----------------------------------------------------------------
2016-08-09 11:32:54 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "manages.reports", "match_phrase": "Dabria Killian Thea"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:32:55 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:32:55 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "manages.reports", "match_phrase": "Dabria Killian Thea"} is 0 (took 5.830377ms)
2016-08-09 11:32:56 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match_phrase": {"manages.reports": "Dabria Killian Thea"}} on es_index is 0 (took 1ms)
2016-08-09 11:32:56 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:32:56 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 60 -----------------------------------------------------------------
2016-08-09 11:32:57 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.461276", "start": "1980-06-20T06:01:00"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:32:59 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:32:59 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.461276", "start": "1980-06-20T06:01:00"} is 522 (took 82.843493ms)
2016-08-09 11:33:03 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"join_date": {"lt": "2016-08-09T11:28:29.461276", "gt": "1980-06-20T06:01:00"}}}}} on es_index is 522 (took 14ms)
2016-08-09 11:33:03 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:33:03 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 61 -----------------------------------------------------------------
2016-08-09 11:33:04 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "email", "prefix": "thea"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:33:05 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:33:05 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "email", "prefix": "thea"} is 0 (took 3.729395ms)
2016-08-09 11:33:05 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"prefix": {"email": "thea"}} on es_index is 0 (took 1ms)
2016-08-09 11:33:05 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:33:05 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 62 -----------------------------------------------------------------
2016-08-09 11:33:06 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"query": "mutated:<0 +mutated:>4 +mutated:<5088 +email:\"balandria@mcdiabetes.com\""}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:33:07 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:33:07 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"query": "mutated:<0 +mutated:>4 +mutated:<5088 +email:\"balandria@mcdiabetes.com\""} is 0 (took 60.332685ms)
2016-08-09 11:33:08 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"query_string": {"query": "mutated:<0 +mutated:>4 +mutated:<5088 +email:\"balandria@mcdiabetes.com\""}} on es_index is 0 (took 1ms)
2016-08-09 11:33:08 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:33:08 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 63 -----------------------------------------------------------------
2016-08-09 11:33:10 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "email", "match_phrase": "dabria@mcdiabetes.com"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:33:13 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:33:13 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "email", "match_phrase": "dabria@mcdiabetes.com"} is 1000 (took 8.936948ms)
2016-08-09 11:33:17 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match_phrase": {"email": "dabria@mcdiabetes.com"}} on es_index is 1000 (took 22ms)
2016-08-09 11:33:17 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:33:17 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 64 -----------------------------------------------------------------
2016-08-09 11:33:18 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"should": {"disjuncts": [{"field": "name", "match": "Araceli"}]}, "must": {"conjuncts": [{"field": "email", "match": "delores@mcdiabetes.com"}]}}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:33:22 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:33:22 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"should": {"disjuncts": [{"field": "name", "match": "Araceli"}]}, "must": {"conjuncts": [{"field": "email", "match": "delores@mcdiabetes.com"}]}} is 1000 (took 34.207578ms)
2016-08-09 11:33:26 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"should": {"match": {"name": "Araceli"}}, "must": {"match": {"email": "delores@mcdiabetes.com"}}}} on es_index is 1000 (took 19ms)
2016-08-09 11:33:26 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:33:26 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 65 -----------------------------------------------------------------
2016-08-09 11:33:27 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"must_not": {"disjuncts": [{"field": "name", "match": "Dabria Robinson Sr."}, {"field": "manages.reports", "match": "Cynara Joby Killian Perdita"}, {"field": "name", "match": "Callia Wood"}]}, "should": {"disjuncts": [{"field": "name", "match": "Johnson"}]}}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:33:29 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:33:29 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"must_not": {"disjuncts": [{"field": "name", "match": "Dabria Robinson Sr."}, {"field": "manages.reports", "match": "Cynara Joby Killian Perdita"}, {"field": "name", "match": "Callia Wood"}]}, "should": {"disjuncts": [{"field": "name", "match": "Johnson"}]}} is 0 (took 34.279316ms)
2016-08-09 11:33:29 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"must_not": [{"match": {"name": "Dabria Robinson Sr."}}, {"match": {"manages.reports": "Cynara Joby Killian Perdita"}}, {"match": {"name": "Callia Wood"}}], "should": {"match": {"name": "Johnson"}}}} on es_index is 0 (took 3ms)
2016-08-09 11:33:29 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:33:29 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 66 -----------------------------------------------------------------
2016-08-09 11:33:30 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "email", "prefix": "me"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:33:32 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:33:32 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "email", "prefix": "me"} is 0 (took 2.581256ms)
2016-08-09 11:33:32 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"prefix": {"email": "me"}} on es_index is 0 (took 1ms)
2016-08-09 11:33:32 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:33:32 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 67 -----------------------------------------------------------------
2016-08-09 11:33:33 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"conjuncts": [{"field": "name", "match": "Dabria Palmer"}, {"field": "name", "prefix": "Kor"}, {"field": "manages.reports", "match_phrase": "Drucilla Keelia Adena"}, {"inclusive_max": true, "field": "mutated", "max": 3985, "inclusive_min": true, "min": 0}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:33:35 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:33:35 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"conjuncts": [{"field": "name", "match": "Dabria Palmer"}, {"field": "name", "prefix": "Kor"}, {"field": "manages.reports", "match_phrase": "Drucilla Keelia Adena"}, {"inclusive_max": true, "field": "mutated", "max": 3985, "inclusive_min": true, "min": 0}]} is 0 (took 21.420383ms)
2016-08-09 11:33:35 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"must": [{"match": {"name": "Dabria Palmer"}}, {"prefix": {"name": "Kor"}}, {"match_phrase": {"manages.reports": "Drucilla Keelia Adena"}}, {"filtered": {"filter": {"range": {"mutated": {"gte": 0, "lte": 3985}}}}}]}} on es_index is 0 (took 1ms)
2016-08-09 11:33:35 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:33:35 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 68 -----------------------------------------------------------------
2016-08-09 11:33:37 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "manages.reports", "wildcard": "Ci?r?"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:33:38 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:33:38 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "manages.reports", "wildcard": "Ci?r?"} is 0 (took 2.533246ms)
2016-08-09 11:33:38 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"wildcard": {"manages.reports": "Ci?r?"}} on es_index is 0 (took 1ms)
2016-08-09 11:33:38 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:33:38 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 69 -----------------------------------------------------------------
2016-08-09 11:33:39 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"query": "+mutated:>=0"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:33:43 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:33:43 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"query": "+mutated:>=0"} is 1000 (took 17.318238ms)
2016-08-09 11:33:47 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"query_string": {"query": "+mutated:>=0"}} on es_index is 1000 (took 26ms)
2016-08-09 11:33:47 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:33:47 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 70 -----------------------------------------------------------------
2016-08-09 11:33:48 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "name", "wildcard": "Ro?ers"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:33:49 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:33:49 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "name", "wildcard": "Ro?ers"} is 0 (took 1.675897ms)
2016-08-09 11:33:50 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"wildcard": {"name": "Ro?ers"}} on es_index is 0 (took 1ms)
2016-08-09 11:33:50 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:33:50 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 71 -----------------------------------------------------------------
2016-08-09 11:33:51 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.462706", "start": "1988-08-15T09:38:00"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:33:53 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:33:53 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.462706", "start": "1988-08-15T09:38:00"} is 417 (took 114.649706ms)
2016-08-09 11:33:56 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"join_date": {"lt": "2016-08-09T11:28:29.462706", "gt": "1988-08-15T09:38:00"}}}}} on es_index is 417 (took 12ms)
2016-08-09 11:33:56 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:33:56 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 72 -----------------------------------------------------------------
2016-08-09 11:33:57 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "manages.reports", "match_phrase": "Ebony Joby"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:33:58 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:33:58 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "manages.reports", "match_phrase": "Ebony Joby"} is 0 (took 4.541324ms)
2016-08-09 11:33:59 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match_phrase": {"manages.reports": "Ebony Joby"}} on es_index is 0 (took 1ms)
2016-08-09 11:33:59 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:33:59 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 73 -----------------------------------------------------------------
2016-08-09 11:34:00 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_max": false, "field": "manages.team_size", "max": 4018, "inclusive_min": false, "min": 5}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:34:01 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:34:01 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_max": false, "field": "manages.team_size", "max": 4018, "inclusive_min": false, "min": 5} is 0 (took 87.755557ms)
2016-08-09 11:34:02 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"manages.team_size": {"lt": 4018, "gt": 5}}}}} on es_index is 0 (took 1ms)
2016-08-09 11:34:02 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:34:02 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 74 -----------------------------------------------------------------
2016-08-09 11:34:03 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_max": false, "field": "mutated", "max": 4730, "inclusive_min": false, "min": 2}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:34:04 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:34:04 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_max": false, "field": "mutated", "max": 4730, "inclusive_min": false, "min": 2} is 0 (took 40.360659ms)
2016-08-09 11:34:05 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"mutated": {"lt": 4730, "gt": 2}}}}} on es_index is 0 (took 1ms)
2016-08-09 11:34:05 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:34:05 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 75 -----------------------------------------------------------------
2016-08-09 11:34:06 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.463190", "start": "1983-06-27T10:08:00"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:34:08 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:34:08 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.463190", "start": "1983-06-27T10:08:00"} is 480 (took 53.81865ms)
2016-08-09 11:34:11 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"join_date": {"lt": "2016-08-09T11:28:29.463190", "gt": "1983-06-27T10:08:00"}}}}} on es_index is 480 (took 13ms)
2016-08-09 11:34:11 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:34:11 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 76 -----------------------------------------------------------------
2016-08-09 11:34:12 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"disjuncts": [{"field": "email", "match": "fuscienne@mcdiabetes.com"}, {"field": "manages.reports", "match": "Hedda"}, {"field": "email", "match": "severin@mcdiabetes.com"}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:34:16 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:34:16 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"disjuncts": [{"field": "email", "match": "fuscienne@mcdiabetes.com"}, {"field": "manages.reports", "match": "Hedda"}, {"field": "email", "match": "severin@mcdiabetes.com"}]} is 1000 (took 69.707923ms)
2016-08-09 11:34:20 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"should": [{"match": {"email": "fuscienne@mcdiabetes.com"}}, {"match": {"manages.reports": "Hedda"}}, {"match": {"email": "severin@mcdiabetes.com"}}]}} on es_index is 1000 (took 22ms)
2016-08-09 11:34:20 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:34:20 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 77 -----------------------------------------------------------------
2016-08-09 11:34:21 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"query": "-manages.reports:\"Desdomna Araceli\" -name:\"Mitchell\" manages.team_size:>=7"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:34:22 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:34:22 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"query": "-manages.reports:\"Desdomna Araceli\" -name:\"Mitchell\" manages.team_size:>=7"} is 0 (took 33.753311ms)
2016-08-09 11:34:23 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"query_string": {"query": "-manages.reports:\"Desdomna Araceli\" -name:\"Mitchell\" manages.team_size:>=7"}} on es_index is 0 (took 2ms)
2016-08-09 11:34:23 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:34:23 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 78 -----------------------------------------------------------------
2016-08-09 11:34:24 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"should": {"disjuncts": [{"field": "manages.reports", "match": "Gallia Lucretia"}]}, "must": {"conjuncts": [{"field": "name", "match": "Dabria"}, {"field": "email", "match": "cassandra@mcdiabetes.com"}]}}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:34:26 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:34:26 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"should": {"disjuncts": [{"field": "manages.reports", "match": "Gallia Lucretia"}]}, "must": {"conjuncts": [{"field": "name", "match": "Dabria"}, {"field": "email", "match": "cassandra@mcdiabetes.com"}]}} is 50 (took 18.623236ms)
2016-08-09 11:34:27 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"should": {"match": {"manages.reports": "Gallia Lucretia"}}, "must": [{"match": {"name": "Dabria"}}, {"match": {"email": "cassandra@mcdiabetes.com"}}]}} on es_index is 50 (took 4ms)
2016-08-09 11:34:27 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:34:27 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 79 -----------------------------------------------------------------
2016-08-09 11:34:28 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "name", "match_phrase": "Caryssa Russell"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:34:29 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:34:29 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "name", "match_phrase": "Caryssa Russell"} is 0 (took 4.549716ms)
2016-08-09 11:34:29 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match_phrase": {"name": "Caryssa Russell"}} on es_index is 0 (took 2ms)
2016-08-09 11:34:29 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:34:29 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 80 -----------------------------------------------------------------
2016-08-09 11:34:30 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "name", "match": "Desdomna"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:34:31 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:34:31 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "name", "match": "Desdomna"} is 10 (took 4.429718ms)
2016-08-09 11:34:32 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match": {"name": "Desdomna"}} on es_index is 10 (took 2ms)
2016-08-09 11:34:32 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:34:32 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 81 -----------------------------------------------------------------
2016-08-09 11:34:33 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"disjuncts": [{"field": "email", "match": "kala@mcdiabetes.com"}, {"field": "name", "match": "Cooper"}, {"field": "manages.reports", "match": "Sidonia Drucilla Alarice Kory"}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:34:36 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:34:36 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"disjuncts": [{"field": "email", "match": "kala@mcdiabetes.com"}, {"field": "name", "match": "Cooper"}, {"field": "manages.reports", "match": "Sidonia Drucilla Alarice Kory"}]} is 1000 (took 31.654719ms)
2016-08-09 11:34:39 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"should": [{"match": {"email": "kala@mcdiabetes.com"}}, {"match": {"name": "Cooper"}}, {"match": {"manages.reports": "Sidonia Drucilla Alarice Kory"}}]}} on es_index is 1000 (took 23ms)
2016-08-09 11:34:39 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:34:39 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 82 -----------------------------------------------------------------
2016-08-09 11:34:40 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"query": "+manages.reports:\"Thea Kacila Gallia Kory\""}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:34:41 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:34:41 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"query": "+manages.reports:\"Thea Kacila Gallia Kory\""} is 0 (took 10.613905ms)
2016-08-09 11:34:42 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"query_string": {"query": "+manages.reports:\"Thea Kacila Gallia Kory\""}} on es_index is 0 (took 1ms)
2016-08-09 11:34:42 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:34:42 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 83 -----------------------------------------------------------------
2016-08-09 11:34:43 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"disjuncts": [{"field": "email", "match": "kerry-ann@mcdiabetes.com"}, {"field": "email", "match": "maura@mcdiabetes.com"}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:34:47 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:34:47 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"disjuncts": [{"field": "email", "match": "kerry-ann@mcdiabetes.com"}, {"field": "email", "match": "maura@mcdiabetes.com"}]} is 1000 (took 67.05213ms)
2016-08-09 11:34:51 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"should": [{"match": {"email": "kerry-ann@mcdiabetes.com"}}, {"match": {"email": "maura@mcdiabetes.com"}}]}} on es_index is 1000 (took 26ms)
2016-08-09 11:34:51 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:34:51 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 84 -----------------------------------------------------------------
2016-08-09 11:34:52 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"query": "+email:\"joby@mcdiabetes.com\""}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:34:55 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:34:55 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"query": "+email:\"joby@mcdiabetes.com\""} is 1000 (took 15.156794ms)
2016-08-09 11:35:01 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"query_string": {"query": "+email:\"joby@mcdiabetes.com\""}} on es_index is 1000 (took 22ms)
2016-08-09 11:35:01 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:35:01 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 85 -----------------------------------------------------------------
2016-08-09 11:35:02 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"query": "manages.reports:\"Deandra Fantine Deandra Adrianne\""}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:35:03 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:35:03 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"query": "manages.reports:\"Deandra Fantine Deandra Adrianne\""} is 0 (took 10.053526ms)
2016-08-09 11:35:04 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"query_string": {"query": "manages.reports:\"Deandra Fantine Deandra Adrianne\""}} on es_index is 0 (took 2ms)
2016-08-09 11:35:04 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:35:04 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 86 -----------------------------------------------------------------
2016-08-09 11:35:05 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_start": true, "field": "join_date", "inclusive_end": true, "end": "2016-08-09T11:28:29.465186", "start": "1962-03-19T17:18:00"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:35:09 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:35:09 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_start": true, "field": "join_date", "inclusive_end": true, "end": "2016-08-09T11:28:29.465186", "start": "1962-03-19T17:18:00"} is 824 (took 42.327593ms)
2016-08-09 11:35:12 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"join_date": {"gte": "1962-03-19T17:18:00", "lte": "2016-08-09T11:28:29.465186"}}}}} on es_index is 824 (took 16ms)
2016-08-09 11:35:12 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:35:12 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 87 -----------------------------------------------------------------
2016-08-09 11:35:13 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "manages.reports", "prefix": "Dar"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:35:14 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:35:14 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "manages.reports", "prefix": "Dar"} is 0 (took 2.0104ms)
2016-08-09 11:35:15 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"prefix": {"manages.reports": "Dar"}} on es_index is 0 (took 1ms)
2016-08-09 11:35:15 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:35:15 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 88 -----------------------------------------------------------------
2016-08-09 11:35:16 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"disjuncts": [{"field": "name", "match": "Foster"}, {"field": "manages.reports", "match": "Araceli Amara"}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:35:18 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:35:18 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"disjuncts": [{"field": "name", "match": "Foster"}, {"field": "manages.reports", "match": "Araceli Amara"}]} is 198 (took 20.548986ms)
2016-08-09 11:35:20 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"should": [{"match": {"name": "Foster"}}, {"match": {"manages.reports": "Araceli Amara"}}]}} on es_index is 198 (took 8ms)
2016-08-09 11:35:20 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:35:20 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 89 -----------------------------------------------------------------
2016-08-09 11:35:21 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"disjuncts": [{"field": "name", "match": "Duvessa"}, {"field": "name", "match": "Salina"}, {"field": "manages.reports", "match": "Adrianne Bryn Gallia Balandria"}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:35:25 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:35:25 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"disjuncts": [{"field": "name", "match": "Duvessa"}, {"field": "name", "match": "Salina"}, {"field": "manages.reports", "match": "Adrianne Bryn Gallia Balandria"}]} is 359 (took 20.080015ms)
2016-08-09 11:35:27 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"should": [{"match": {"name": "Duvessa"}}, {"match": {"name": "Salina"}}, {"match": {"manages.reports": "Adrianne Bryn Gallia Balandria"}}]}} on es_index is 359 (took 9ms)
2016-08-09 11:35:27 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:35:27 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 90 -----------------------------------------------------------------
2016-08-09 11:35:28 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"conjuncts": [{"field": "email", "match": "ebony@mcdiabetes.com"}, {"field": "name", "prefix": "Do"}, {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.465785", "start": "1985-04-07T02:47:00"}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:35:29 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:35:29 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"conjuncts": [{"field": "email", "match": "ebony@mcdiabetes.com"}, {"field": "name", "prefix": "Do"}, {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.465785", "start": "1985-04-07T02:47:00"}]} is 0 (took 45.86807ms)
2016-08-09 11:35:30 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"must": [{"match": {"email": "ebony@mcdiabetes.com"}}, {"prefix": {"name": "Do"}}, {"filtered": {"filter": {"range": {"join_date": {"lt": "2016-08-09T11:28:29.465785", "gt": "1985-04-07T02:47:00"}}}}}]}} on es_index is 0 (took 1ms)
2016-08-09 11:35:30 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:35:30 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 91 -----------------------------------------------------------------
2016-08-09 11:35:32 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "email", "match_phrase": "cytheria@mcdiabetes.com"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:35:34 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:35:34 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "email", "match_phrase": "cytheria@mcdiabetes.com"} is 1000 (took 58.118769ms)
2016-08-09 11:35:39 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match_phrase": {"email": "cytheria@mcdiabetes.com"}} on es_index is 1000 (took 25ms)
2016-08-09 11:35:39 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:35:39 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 92 -----------------------------------------------------------------
2016-08-09 11:35:40 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "name", "match_phrase": "Lysha Rogers"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:35:41 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:35:41 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "name", "match_phrase": "Lysha Rogers"} is 0 (took 9.995645ms)
2016-08-09 11:35:42 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match_phrase": {"name": "Lysha Rogers"}} on es_index is 0 (took 2ms)
2016-08-09 11:35:42 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:35:42 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 93 -----------------------------------------------------------------
2016-08-09 11:35:43 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"conjuncts": [{"field": "name", "match": "Trista Turner"}, {"field": "manages.reports", "match_phrase": "Cytheria Lysha Sirena"}, {"inclusive_max": false, "field": "manages.team_size", "max": 3739, "inclusive_min": false, "min": 6}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:35:44 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:35:44 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"conjuncts": [{"field": "name", "match": "Trista Turner"}, {"field": "manages.reports", "match_phrase": "Cytheria Lysha Sirena"}, {"inclusive_max": false, "field": "manages.team_size", "max": 3739, "inclusive_min": false, "min": 6}]} is 0 (took 50.190732ms)
2016-08-09 11:35:45 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"must": [{"match": {"name": "Trista Turner"}}, {"match_phrase": {"manages.reports": "Cytheria Lysha Sirena"}}, {"filtered": {"filter": {"range": {"manages.team_size": {"lt": 3739, "gt": 6}}}}}]}} on es_index is 0 (took 2ms)
2016-08-09 11:35:45 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:35:45 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 94 -----------------------------------------------------------------
2016-08-09 11:35:46 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.466381", "start": "2004-07-10T14:01:00"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:35:48 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:35:48 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.466381", "start": "2004-07-10T14:01:00"} is 177 (took 58.277416ms)
2016-08-09 11:35:50 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"filtered": {"filter": {"range": {"join_date": {"lt": "2016-08-09T11:28:29.466381", "gt": "2004-07-10T14:01:00"}}}}} on es_index is 177 (took 5ms)
2016-08-09 11:35:50 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:35:50 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 95 -----------------------------------------------------------------
2016-08-09 11:35:51 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"conjuncts": [{"field": "email", "match": "winta@mcdiabetes.com"}, {"field": "email", "match_phrase": "solita@mcdiabetes.com"}, {"inclusive_max": false, "field": "mutated", "max": 2359, "inclusive_min": false, "min": 5}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:35:52 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:35:52 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"conjuncts": [{"field": "email", "match": "winta@mcdiabetes.com"}, {"field": "email", "match_phrase": "solita@mcdiabetes.com"}, {"inclusive_max": false, "field": "mutated", "max": 2359, "inclusive_min": false, "min": 5}]} is 0 (took 84.596449ms)
2016-08-09 11:35:53 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"must": [{"match": {"email": "winta@mcdiabetes.com"}}, {"match_phrase": {"email": "solita@mcdiabetes.com"}}, {"filtered": {"filter": {"range": {"mutated": {"lt": 2359, "gt": 5}}}}}]}} on es_index is 0 (took 1ms)
2016-08-09 11:35:53 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:35:53 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 96 -----------------------------------------------------------------
2016-08-09 11:35:54 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"conjuncts": [{"field": "name", "match": "Ciara"}, {"field": "manages.reports", "match_phrase": "Adena Kagami Gallia"}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:35:55 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:35:55 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"conjuncts": [{"field": "name", "match": "Ciara"}, {"field": "manages.reports", "match_phrase": "Adena Kagami Gallia"}]} is 0 (took 11.287322ms)
2016-08-09 11:35:56 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"must": [{"match": {"name": "Ciara"}}, {"match_phrase": {"manages.reports": "Adena Kagami Gallia"}}]}} on es_index is 0 (took 2ms)
2016-08-09 11:35:56 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:35:56 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 97 -----------------------------------------------------------------
2016-08-09 11:35:57 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "email", "match": "sidonia@mcdiabetes.com"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:36:01 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:36:01 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "email", "match": "sidonia@mcdiabetes.com"} is 1000 (took 24.058265ms)
2016-08-09 11:36:06 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match": {"email": "sidonia@mcdiabetes.com"}} on es_index is 1000 (took 19ms)
2016-08-09 11:36:06 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:36:06 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 98 -----------------------------------------------------------------
2016-08-09 11:36:07 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"conjuncts": [{"field": "name", "match": "Reed"}, {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.466952", "start": "1962-04-09T22:12:00"}, {"inclusive_max": true, "field": "mutated", "max": 8631, "inclusive_min": true, "min": 1}]}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:36:08 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:36:08 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"conjuncts": [{"field": "name", "match": "Reed"}, {"inclusive_start": false, "field": "join_date", "inclusive_end": false, "end": "2016-08-09T11:28:29.466952", "start": "1962-04-09T22:12:00"}, {"inclusive_max": true, "field": "mutated", "max": 8631, "inclusive_min": true, "min": 1}]} is 0 (took 68.820798ms)
2016-08-09 11:36:09 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"bool": {"must": [{"match": {"name": "Reed"}}, {"filtered": {"filter": {"range": {"join_date": {"lt": "2016-08-09T11:28:29.466952", "gt": "1962-04-09T22:12:00"}}}}}, {"filtered": {"filter": {"range": {"mutated": {"gte": 1, "lte": 8631}}}}}]}} on es_index is 0 (took 1ms)
2016-08-09 11:36:09 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:36:09 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 99 -----------------------------------------------------------------
2016-08-09 11:36:10 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "name", "match_phrase": "Ciara Bailey"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:36:11 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:36:11 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "name", "match_phrase": "Ciara Bailey"} is 0 (took 3.434097ms)
2016-08-09 11:36:12 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"match_phrase": {"name": "Ciara Bailey"}} on es_index is 0 (took 1ms)
2016-08-09 11:36:12 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:36:12 | INFO | MainProcess | Cluster_Thread | [task.execute] ------------------------------------------------------------------ Query # 100 -----------------------------------------------------------------
2016-08-09 11:36:13 | INFO | MainProcess | Cluster_Thread | [fts_base.run_fts_query] Running query {"from": 0, "indexName": "custom_index", "fields": [], "explain": false, "ctl": {"timeout": 60000, "consistency": {"vectors": {}, "level": ""}}, "query": {"field": "name", "prefix": "Wr"}, "size": 10000000} on node: 172.23.106.72:
2016-08-09 11:36:14 | INFO | MainProcess | Cluster_Thread | [task.execute] Status: {u'successful': 32, u'failed': 0, u'total': 32}
2016-08-09 11:36:14 | INFO | MainProcess | Cluster_Thread | [task.execute] FTS hits for query: {"field": "name", "prefix": "Wr"} is 0 (took 2.905577ms)
2016-08-09 11:36:15 | INFO | MainProcess | Cluster_Thread | [task.execute] ES hits for query: {"prefix": {"name": "Wr"}} on es_index is 0 (took 1ms)
2016-08-09 11:36:15 | INFO | MainProcess | Cluster_Thread | [task.execute] SUCCESS: Docs returned by FTS = docs returned by ES, doc_ids verified
2016-08-09 11:36:16 | INFO | MainProcess | test_thread | [rest_client.diag_eval] /diag/eval status on 172.23.106.72:8091: True content: "/opt/couchbase/var/lib/couchbase/logs" command: filename:absname(element(2, application:get_env(ns_server,error_logger_mf_dir))).
2016-08-09 11:36:16 | INFO | MainProcess | test_thread | [remote_util.__init__] connecting to 172.23.106.72 with username : root password : couchbase ssh_key: 
2016-08-09 11:36:20 | INFO | MainProcess | test_thread | [remote_util.__init__] Connected to 172.23.106.72
2016-08-09 11:36:33 | INFO | MainProcess | test_thread | [remote_util.execute_command_raw] running command.raw on 172.23.106.72: zgrep "panic:" "/opt/couchbase/var/lib/couchbase/logs"/fts.log* | wc -l
2016-08-09 11:36:42 | INFO | MainProcess | test_thread | [remote_util.execute_command_raw] command executed successfully
2016-08-09 11:36:42 | INFO | MainProcess | test_thread | [fts_base.check_error_count_in_fts_log] 0
2016-08-09 11:36:42 | INFO | MainProcess | test_thread | [fts_base.check_error_count_in_fts_log] Initial 'panic:' count on 172.23.106.72 :0, now :0
2016-08-09 11:36:42 | INFO | MainProcess | test_thread | [remote_util.execute_command_raw] running command.raw on 172.23.106.72: zgrep "crash in forestdb" "/opt/couchbase/var/lib/couchbase/logs"/fts.log* | wc -l
2016-08-09 11:36:49 | INFO | MainProcess | test_thread | [remote_util.execute_command_raw] command executed successfully
2016-08-09 11:36:49 | INFO | MainProcess | test_thread | [fts_base.check_error_count_in_fts_log] 0
2016-08-09 11:36:49 | INFO | MainProcess | test_thread | [fts_base.check_error_count_in_fts_log] Initial 'crash in forestdb' count on 172.23.106.72 :0, now :0
2016-08-09 11:36:49 | INFO | MainProcess | test_thread | [fts_base.tearDown] ====  FTSbasetests cleanup is started for test #1 index_query_custom_mapping ====
2016-08-09 11:36:51 | INFO | MainProcess | test_thread | [fts_base.delete] Deleting fulltext-index custom_index on 172.23.106.72
2016-08-09 11:36:54 | INFO | MainProcess | test_thread | [remote_util.__init__] connecting to 172.23.106.72 with username : root password : couchbase ssh_key: 
2016-08-09 11:36:57 | INFO | MainProcess | test_thread | [remote_util.__init__] Connected to 172.23.106.72
2016-08-09 11:37:11 | INFO | MainProcess | test_thread | [remote_util.execute_command_raw] running command.raw on 172.23.106.72: ls /opt/couchbase/var/lib/couchbase/data/@fts |grep custom_index*.pindex | wc -l
2016-08-09 11:37:12 | INFO | MainProcess | test_thread | [remote_util.execute_command_raw] command executed successfully
2016-08-09 11:37:12 | INFO | MainProcess | test_thread | [fts_base.are_index_files_deleted_from_disk] 0
2016-08-09 11:37:12 | INFO | MainProcess | test_thread | [fts_base.delete] Validated: all index files for custom_index deleted from disk
2016-08-09 11:37:12 | INFO | MainProcess | test_thread | [fts_base.cleanup_cluster] removing nodes from cluster ...
2016-08-09 11:37:13 | INFO | MainProcess | test_thread | [fts_base.cleanup_cluster] cleanup [ip:172.23.106.72 port:8091 ssh_username:root]
2016-08-09 11:37:14 | INFO | MainProcess | test_thread | [bucket_helper.delete_all_buckets_or_assert] deleting existing buckets [u'default'] on 172.23.106.72
2016-08-09 11:37:14 | INFO | MainProcess | test_thread | [bucket_helper.delete_all_buckets_or_assert] remove bucket default ...
2016-08-09 11:37:19 | INFO | MainProcess | test_thread | [bucket_helper.delete_all_buckets_or_assert] deleted bucket : default from 172.23.106.72
2016-08-09 11:37:19 | INFO | MainProcess | test_thread | [bucket_helper.wait_for_bucket_deletion] waiting for bucket deletion to complete....
2016-08-09 11:37:19 | INFO | MainProcess | test_thread | [rest_client.bucket_exists] node 172.23.106.72 existing buckets : []
2016-08-09 11:37:22 | INFO | MainProcess | test_thread | [cluster_helper.wait_for_ns_servers_or_assert] waiting for ns_server @ 172.23.106.72:8091
2016-08-09 11:37:23 | INFO | MainProcess | test_thread | [cluster_helper.wait_for_ns_servers_or_assert] ns_server @ 172.23.106.72:8091 is running
Cluster instance shutdown with force
2016-08-09 11:37:23 | INFO | MainProcess | test_thread | [es_base.delete_indices] ES index es_index deleted
2016-08-09 11:37:23 | INFO | MainProcess | test_thread | [fts_base.tearDown] ====  FTSbasetests cleanup is finished for test #1 index_query_custom_mapping ===
Cluster instance shutdown with force
summary so far suite fts.stable_topology_fts.StableTopFTS , pass 0 , fail 1
failures so far...
fts.stable_topology_fts.StableTopFTS.index_query_custom_mapping
testrunner logs, diags and results are available under /Users/mihirkamdar/PycharmProjects/testrunner_fts_0725/testrunner/logs/testrunner-16-Aug-09_11-21-59/test_1
Run after suite setup for fts.stable_topology_fts.StableTopFTS.index_query_custom_mapping
Thread Cluster_Thread was not properly terminated, will be terminated now.
Thread ES_Thread was not properly terminated, will be terminated now.