# Need help with ES (SearchPhaseExecutionException) **URL:** \ **Category:** Elasticsearch\ **Created:** [January 3, 2013, 9:27am UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217 "2013-01-03T09:27:31Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![muzakcube64](https://avatars.discourse-cdn.com/v4/letter/m/a183cd/32.png) [@muzakcube64](https://discuss.elastic.co/u/muzakcube64)\ **Post date:** [January 3, 2013, 9:27am UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/1 "2013-01-03T09:27:31Z")
I'm having issues and I don't know where to turn. Long story short, my web designer left me high and dry and I have no idea what he did and he refuses to answer his phone. I have access to the main page but after that, I'm completely locked out and staring at a SearchPhaseExecutionException for every single product in my store. Any help would be much appreciated as I am completely clueless on what to do. Here is the full error log: SearchPhaseExecutionException at /category/1 Failed to execute phase [query], total failure; shardFailures {[_na_][product][0]: No active shards}{[_na_][product][1]: No active shards}{[_na_][product][2]: No active shards}{[_na_][product][3]: No active shards}{[_na_][product][4]: No active shards} Request Method:GETRequest URL: [http://www.affordablequalitylighting.com/category/1Django](http://www.affordablequalitylighting.com/category/1Django) Version:1.3.1Exception Type:SearchPhaseExecutionExceptionException Value: Failed to execute phase [query], total failure; shardFailures {[_na_][product][0]: No active shards}{[_na_][product][1]: No active shards}{[_na_][product][2]: No active shards}{[_na_][product][3]: No active shards}{[_na_][product][4]: No active shards} Exception Location:/usr/local/lib/python2.6/dist-packages/pyes/convert\_errors.py in raise\_if\_error, line 68Python Executable:/usr/bin/pythonPython Version: 2.6.5Python Path: ['/usr/lib/python2.6', '/usr/lib/python2.6/plat-linux2', '/usr/lib/python2.6/lib-tk', '/usr/lib/python2.6/lib-old', '/usr/lib/python2.6/lib-dynload', '/usr/lib/python2.6/dist-packages', '/usr/lib/python2.6/dist-packages/PIL', '/usr/lib/pymodules/python2.6', '/usr/lib/pymodules/python2.6/gtk-2.0', '/usr/lib/python2.6/dist-packages/wx-2.8-gtk2-unicode', '/usr/local/lib/python2.6/dist-packages', '/var/www/singularity/py'] Server time:Thu, 3 Jan 2013 01:24:15 -0800 Traceback Switch to copy-and-paste view[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) - /usr/local/lib/python2.6/dist-packages/django/core/handlers/base.py in get\_response 1. ``` response = callback(request, *callback_args, **callback_kwargs) ... ``` ▶ Local vars [http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) - /var/www/singularity/py/store/catalog/views.py in category\_view 1. ``` filterblock = filtering.filter(category, request, num_results, page_num) ... ``` ▶ Local vars [http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) - /var/www/singularity/py/store/catalog/filtering.py in filter 1. ``` results = sitesearch.raw_search(q, search.product_index) ... ``` ▶ Local vars [http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) - /var/www/singularity/py/sitesearch/interface.py in raw\_search 1. ``` return C.search(data, [_idxname(index_name)]) ... ``` ▶ Local vars [http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) - /usr/local/lib/python2.6/dist-packages/pyes/es.py in search 1. ``` return self._query_call("_search", body, indexes, doc_types, **query_params) ... ``` ▶ Local vars [http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) - /usr/local/lib/python2.6/dist-packages/pyes/es.py in \_query\_call 1. ``` response = self._send_request('GET', path, body, querystring_args) ... ``` ▶ Local vars [http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) - /usr/local/lib/python2.6/dist-packages/pyes/es.py in \_send\_request 1. ``` raise_if_error(response.status, decoded) ... ``` ▶ Local vars [http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) - /usr/local/lib/python2.6/dist-packages/pyes/convert\_errors.py in raise\_if\_error 1. ``` raise excClass(msg, status, result) ... ``` ▶ Local vars [http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) Request informationGET No GET data POST No POST data FILES No FILES data COOKIESVariableValue\_\_utmz '36364016.1355763714.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)' \_vis\_opt\_s '2%7C' \_vis\_opt\_exp\_11\_goal\_3 '1' sessionid '8894e58e6eee1d47f9bdfdb41e9fe7f4' \_vis\_opt\_exp\_11\_combi '2' csrftoken '8b335c16f43607ae18f730559c2e0d56' \_\_utma '36364016.1140701240.1355763714.1355942217.1355945322.4' \_vis\_opt\_exp\_10\_combi '1' METAVariableValuemod\_wsgi.reload\_mechanism '1' mod\_wsgi.listener\_port '80' HTTP\_REFERER '[http://www.affordablequalitylighting.com/](http://www.affordablequalitylighting.com/)' mod\_wsgi.listener\_host '' SERVER\_SOFTWARE 'Apache/2.2.14 (Ubuntu)' SCRIPT\_NAME u'' SERVER\_SIGNATURE 'Apache/2.2.14 (Ubuntu) Server at [www.affordablequalitylighting.com](http://www.affordablequalitylighting.com) Port 80\n' REQUEST\_METHOD 'GET' PATH\_INFO u'/outdoor-lighting' SERVER\_PROTOCOL 'HTTP/1.1' QUERY\_STRING '' PATH '/usr/local/bin:/usr/bin:/bin' HTTP\_ACCEPT\_CHARSET 'ISO-8859-1,utf-8;q=0.7,\*;q=0.3' HTTP\_USER\_AGENT 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.97 Safari/537.11' HTTP\_CONNECTION 'keep-alive' HTTP\_COOKIE '\_vis\_opt\_exp\_10\_combi=1; \_vis\_opt\_s=2%7C; \_vis\_opt\_exp\_11\_combi=2; \_vis\_opt\_exp\_11\_goal\_3=1; \_\_utma=36364016.1140701240.1355763714.1355942217.1355945322.4; \_\_utmz=36364016.1355763714.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); csrftoken=8b335c16f43607ae18f730559c2e0d56; sessionid=8894e58e6eee1d47f9bdfdb41e9fe7f4' SERVER\_NAME '[www.affordablequalitylighting.com](http://www.affordablequalitylighting.com)' REMOTE\_ADDR '10.168.14.143' wsgi.url\_scheme 'http' PATH\_TRANSLATED '/var/www/singularity/py/wsgi/singularity.py/outdoor-lighting' SERVER\_PORT '80' wsgi.multiprocess False SERVER\_ADDR '10.160.83.83' DOCUMENT\_ROOT '/htdocs' mod\_wsgi.process\_group 'django' HTTP\_X\_FORWARDED\_PROTO 'http' SCRIPT\_FILENAME '/var/www/singularity/py/wsgi/singularity.py' SERVER\_ADMIN '[no address given]' SCRIPT\_URI '[http://www.affordablequalitylighting.com/outdoor-lighting](http://www.affordablequalitylighting.com/outdoor-lighting)' wsgi.input \ HTTP\_HOST '[www.affordablequalitylighting.com](http://www.affordablequalitylighting.com)' SCRIPT\_URL '/outdoor-lighting' wsgi.multithread True mod\_wsgi.callable\_object 'application' REQUEST\_URI '/outdoor-lighting' HTTP\_ACCEPT 'text/html,application/xhtml+xml,application/xml;q=0.9,_/_;q=0.8' wsgi.version (1, 0) GATEWAY\_INTERFACE 'CGI/1.1' HTTP\_X\_FORWARDED\_FOR '173.196.151.198' wsgi.errors \ REMOTE\_PORT '37237' HTTP\_ACCEPT\_LANGUAGE 'en-US,en;q=0.8' mod\_wsgi.version (2, 8) wsgi.run\_once False HTTP\_X\_FORWARDED\_PORT '80' mod\_wsgi.application\_group '' mod\_wsgi.script\_reloading '1' wsgi.file\_wrapper '' CSRF\_COOKIE '8b335c16f43607ae18f730559c2e0d56' HTTP\_ACCEPT\_ENCODING 'gzip,deflate,sdch' SettingsUsing settings module settingsSettingValueGOOGLE\_ANALYTICS\_ID 'UA-13030541-1' SERVER\_EMAIL 'noreply@affordablequalitylighting.com' USE\_L10N True USE\_THOUSAND\_SEPARATOR False IMAGES\_CONFIG {'dest\_dir': '/var/www/singularity-media/images/store', 'url\_prefix': 'images/store'} LANGUAGE\_CODE 'en-us' ROOT\_URLCONF 'urls' MANAGERS (('Blake Eggleston', 'bdeggleston@gmail.com'), ('Blake Eggleston', 'be@concordlighting.com')) SESSION\_EXPIRE\_AT\_BROWSER\_CLOSE False DEFAULT\_CHARSET 'utf-8' STATIC\_ROOT '' TEST\_DATABASE\_CHARSET None USING\_WSGI True MESSAGE\_STORAGE 'django.contrib.messages.storage.user\_messages.LegacyFallbackStorage' DATABASE\_HOST '' EMAIL\_SUBJECT\_PREFIX '[Django] ' SEND\_BROKEN\_LINK\_EMAILS False URL\_VALIDATOR\_USER\_AGENT 'Django/1.3.1 ([http://www.djangoproject.com](http://www.djangoproject.com))' STATICFILES\_FINDERS ('django.contrib.staticfiles.finders.FileSystemFinder', 'django.contrib.staticfiles.finders.AppDirectoriesFinder') SESSION\_COOKIE\_DOMAIN None SESSION\_COOKIE\_NAME 'sessionid' CSRF\_COOKIE\_NAME 'csrftoken' ADMIN\_FOR () TIME\_INPUT\_FORMATS ('%H:%M:%S', '%H:%M') DATABASES {'default': {'ENGINE': 'django.db.backends.mysql', 'HOST': '[aqldb.clapuphfn4dw.us-west-1.rds.amazonaws.com](http://aqldb.clapuphfn4dw.us-west-1.rds.amazonaws.com)', 'NAME': 'singularity', 'OPTIONS': {}, 'PASSWORD': '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*', 'PORT': '', 'TEST\_CHARSET': None, 'TEST\_COLLATION': None, 'TEST\_MIRROR': None, 'TEST\_NAME': None, 'TIME\_ZONE': 'America/Los\_Angeles', 'USER': 'singularity'}} TEST\_DATABASE\_NAME None FILE\_UPLOAD\_PERMISSIONS None FILE\_UPLOAD\_HANDLERS ('django.core.files.uploadhandler.MemoryFileUploadHandler', 'django.core.files.uploadhandler.TemporaryFileUploadHandler') DEFAULT\_CONTENT\_TYPE 'text/html' TEST\_RUNNER 'store.testing.runners.TestRunner' AUTHNET\_DEBUG False FIRST\_DAY\_OF\_WEEK 0 DATABASE\_ROUTERS [] SEND\_EMAILS True YEAR\_MONTH\_FORMAT 'F Y' CONTENT\_PERMS 508 CACHES {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache', 'LOCATION': ''}} ACCOUNT\_CONTENT\_BASE\_PATH '/var/www/singularity-media/images/store/account\_src' PAYPAL\_DEBUG False SESSION\_COOKIE\_PATH '/' USE\_X\_FORWARDED\_HOST False CONTENT\_BASE\_PATH '/var/www/singularity-media/images/store/content' AUTHNET\_ENABLED True IGNORABLE\_404\_ENDS ('mail.pl', 'mailform.pl', 'mail.cgi', 'mailform.cgi', 'favicon.ico', '.php') ENCRYPTION\_CONFIG {'cc\_staging\_key': '54c376a2210b8ca994e88758c9a31871', 'cc\_storage\_key': 'ea284f3c20a9d2c944a6bcb4f7b774d9'} MIDDLEWARE\_CLASSES ('store.metrics.middleware.MetricsMiddleware', 'store.middleware.WorkQueue', 'store.middleware.RedirectMiddleware', 'django.middleware.common.CommonMiddleware', 'django.contrib.sessions.middleware.SessionMiddleware', 'django.middleware.csrf.CsrfViewMiddleware', 'django.contrib.auth.middleware.AuthenticationMiddleware', 'django.contrib.messages.middleware.MessageMiddleware', 'store.middleware.UrlRenamer', 'store.discount.middleware.DiscountUrlAttach', 'dynamicpages.DynamicPagesHandler') USE\_I18N True THOUSAND\_SEPARATOR ',' SECRET\_KEY '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*' LANGUAGE\_COOKIE\_NAME 'django\_language' DEFAULT\_INDEX\_TABLESPACE '' SERVE\_IMAGES True CONFIG\_PATH '/var/www/singularity/data/config' TRANSACTIONS\_MANAGED False LOGGING\_CONFIG 'django.utils.log.dictConfig' PAYPAL\_DOMAIN\_NAME '[aql-lb002-1208657660.us-west-1.elb.amazonaws.com](http://aql-lb002-1208657660.us-west-1.elb.amazonaws.com)' APPEND\_SLASH True TEMPLATE\_LOADERS ('django.template.loaders.filesystem.Loader', 'django.template.loaders.app\_directories.Loader') ACCOUNT\_IMAGE\_FORMATS {'formats': [{'description': 'the fullsize account image', 'max\_x': 80, 'max\_y': 80, 'name': 'account\_full'}, {'description': 'images shown in the sub comments', 'max\_x': 40, 'max\_y': 40, 'name': 'account\_small'}], 'src\_dir': '/var/www/singularity-media/images/store/account\_src'} TEMPLATE\_DEBUG False CONTENT\_BASE\_URL '/images/store/content' TEST\_DATABASE\_COLLATION None FORCE\_SCRIPT\_NAME None CACHE\_BACKEND 'locmem://' SESSION\_COOKIE\_SECURE False TEST\_EXCLUDE ('django', 'authorizenet', 'paypal') COMPILE\_TEMPLATES True LOCAL\_PATH '/var/www/singularity' CSRF\_COOKIE\_DOMAIN None FILE\_CHARSET 'utf-8' DEBUG False SESSION\_FILE\_PATH None DEFAULT\_FILE\_STORAGE 'django.core.files.storage.FileSystemStorage' INSTALLED\_APPS ['django.contrib.auth', 'django.contrib.contenttypes', 'django.contrib.sessions', 'django.contrib.sites', 'django.contrib.messages', 'django.contrib.admin', 'django.contrib.admindocs', 'authorizenet', 'paypal.standard.ipn', 'caching', 'sitesearch', 'interaction', 'blog', 'offline', 'store', 'store.account', 'store.cart', 'store.catalog', 'store.catalog.indexing', 'store.catalog.manage', 'store.content', 'store.discount', 'store.images', 'store.locations', 'store.marketing', 'store.metrics', 'store.orders', 'store.reviews', 'store.shipments', 'store.transactions'] LANGUAGES\_BIDI ('he', 'ar', 'fa') DATABASE\_ENGINE '' DEFAULT\_FILTER\_RESULTS 20 DATABASE\_NAME '' COMMENTS\_FIRST\_FEW 0 AUTHNET\_LOGIN\_ID '2w87JmTv' REQUIRE\_PAYMENT\_AT 'invoice' SEARCH\_SERVERS ('127.0.0.1:9200',) SESSION\_COOKIE\_HTTPONLY False DATABASE\_PORT '' DEBUG\_PROPAGATE\_EXCEPTIONS False PAYPAL\_RECEIVER\_EMAIL 'paypal@affordablequalitylighting.com' MONTH\_DAY\_FORMAT 'F j' AUTHNET\_IMMEDIATE\_CAPTURE False LOGIN\_URL '/user' DEFAULT\_SEARCH\_QTY 9 TIME\_FORMAT 'P' DATE\_INPUT\_FORMATS ('%Y-%m-%d', '%m/%d/%Y', '%m/%d/%y', '%b %d %Y', '%b %d, %Y', '%d %b %Y', '%d %b, %Y', '%B %d %Y', '%B %d, %Y', '%d %B %Y', '%d %B, %Y') AUTHENTICATION\_BACKENDS ('store.account.backends.EmailAuth',) EMAIL\_HOST\_PASSWORD '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*' APP\_INSTANCE 0 TEMPLATE\_PATH '/var/www/tmplaql' CONTENT\_GROUP 'images' PASSWORD\_RESET\_TIMEOUT\_DAYS '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*' CACHE\_MIDDLEWARE\_ALIAS 'default' SESSION\_SAVE\_EVERY\_REQUEST True ADMIN\_MEDIA\_PREFIX '/admin/media/' NUMBER\_GROUPING 0 SESSION\_ENGINE 'django.contrib.sessions.backends.db' STATICFILES\_STORAGE 'django.contrib.staticfiles.storage.StaticFilesStorage' CSRF\_FAILURE\_VIEW 'django.views.csrf.csrf\_failure' COMMENTS\_SKETCHY\_USERS\_GROUP None LOGIN\_REDIRECT\_URL '/accounts/profile/' PAYPAL\_ENABLED True DECIMAL\_SEPARATOR '.' CACHE\_MIDDLEWARE\_KEY\_PREFIX '' LOCALE\_PATHS () TEMPLATE\_STRING\_IF\_INVALID '' COMMENTS\_ALLOW\_PROFANITIES False LOGOUT\_URL '/accounts/logout/' EMAIL\_USE\_TLS True TEMPLATE\_DIRS ('/var/www/tmplaql/templates', '/var/www/singularity/templates') BLOG\_CONTENT\_BASE\_URL '/images/blog' FIXTURE\_DIRS ('/var/www/singularity/fixtures',) EMAIL\_HOST '[smtp.gmail.com](http://smtp.gmail.com)' DATE\_FORMAT 'N j, Y' ACCOUNT\_CONTENT\_BASE\_URL '/images/store/account\_src' MEDIA\_ROOT '' ADMINS (('Blake Eggleston', 'bdeggleston@gmail.com'), ('Blake Eggleston', 'be@concordlighting.com')) FORMAT\_MODULE\_PATH None DEFAULT\_FROM\_EMAIL 'webmaster@localhost' BLOG\_CONTENT\_BASE\_PATH '/var/www/singularity-media/images/blog' PRODUCTS\_PER\_PAGE 10000 REQUIRE\_PAYMENT\_CHOICES ['invoice', 'processing', 'shipment', 'completion'] STATICFILES\_DIRS () MEDIA\_URL '/media/' DATETIME\_FORMAT 'N j, Y, P' IGNORABLE\_404\_STARTS ('/cgi-bin/', '/\_vti\_bin', '/\_vti\_inf') DEBUG\_CHECKOUT False PROFILE\_SQL False SITE\_ID 1 DISALLOWED\_USER\_AGENTS () ALLOWED\_INCLUDE\_ROOTS () PRODUCT\_IMAGE\_FORMATS {'formats': [{'description': 'the default image on the product page', 'max\_x': 447, 'max\_y': 384, 'name': 'product\_page'}, {'description': 'images shown in the category/filtering view', 'max\_x': 130, 'max\_y': 96, 'name': 'product\_cart'}, {'description': 'images shown in the order review view', 'max\_x': 60, 'max\_y': 60, 'name': 'product\_review'}, {'description': 'images shown in the category/filtering view', 'max\_x': 48, 'max\_y': 49, 'name': 'product\_preview'}, {'description': 'category list and related products', 'max\_x': 150, 'max\_y': 150, 'name': 'product\_list'}, {'description': 'the tiny images in the footer', 'max\_x': 25, 'max\_y': 25, 'name': 'product\_tiny'}, {'description': 'the full highres image', 'force\_size': False, 'max\_x': 1000, 'max\_y': 1000, 'name': 'product\_full'}], 'src\_dir': '/var/www/singularity-media/images/store/product\_src'} CONTENT\_USER 'www-data' LOGGING {'disable\_existing\_loggers': False, 'handlers': {'mail\_admins': {'class': 'django.utils.log.AdminEmailHandler', 'level': 'ERROR'}}, 'loggers': {'django.request': {'handlers': ['mail\_admins'], 'level': 'ERROR', 'propagate': True}}, 'version': 1} PREPEND\_WWW False SHORT\_DATE\_FORMAT 'm/d/Y' DATABASE\_USER '' FREIGHT\_CARRIERS {'rate\_modifiers': {'3aa49ec6bfc910647fa1c5a013e48eef': 25}, 'ups': {'api\_access\_key': 'FC6D4E635C4A7F10', 'api\_password': 'passive1', 'api\_user\_id': 'LampsDirect', 'billing\_city': 'Valencia', 'billing\_country\_code': 'US', 'billing\_post\_code': '91355', 'billing\_territory': 'CA', 'dim\_type': 'IN', 'free\_freight\_amount': 0, 'freight\_markup': -20, 'shipper\_number': 'X0305A', 'weight\_type': 'LBS'}, 'ups\_freight': {'api\_access\_key': 'CC770A558C47ACB8', 'api\_password': 'passive1', 'api\_user\_id': 'LampsDirect', 'billing\_city': 'Valencia', 'billing\_country\_code': 'US', 'billing\_name': 'Concord Lighting', 'billing\_post\_code': '91355', 'billing\_street1': '28150 Ave Crocker', 'billing\_street2': 'Ste 312', 'billing\_territory': 'CA', 'dim\_type': 'IN', 'free\_freight\_amount': 0, 'freight\_markup': -20, 'shipper\_number': 'X0305A', 'weight\_type': 'LBS'}} ANALYTICS\_ACTIVE True TIME\_ZONE 'America/Los\_Angeles' FILE\_UPLOAD\_MAX\_MEMORY\_SIZE 2621440 PAYMENT\_PROCESSORS {'authorizenet': {'key': '7862YPJ34uumy3MF', 'live': True, 'username': '2w87JmTv'}, 'paypalwps': {'business\_display\_name': 'Affordable Quality Lighting', 'domain\_name': '[ec2-50-18-148-185.us-west-1.compute.amazonaws.com](http://ec2-50-18-148-185.us-west-1.compute.amazonaws.com)', 'key': 'eyoBTzMK8wy25X-Yq5irPxrSe\_\_Gx5BBev4-UVhcq150mnR2VEEWeEbbCRm', 'live': False, 'username': 'be\_1333732418\_biz@concordlighting.com'}} EMAIL\_BACKEND 'django.core.mail.backends.smtp.EmailBackend' BLOG\_TITLE 'DIY Lighting Blog' DEFAULT\_TABLESPACE '' TEMPLATE\_CONTEXT\_PROCESSORS ('django.contrib.auth.context\_processors.auth', 'django.core.context\_processors.debug', 'django.core.context\_processors.i18n', 'django.core.context\_processors.media', 'django.core.context\_processors.static', 'django.contrib.messages.context\_processors.messages') AUTHNET\_TRANSACTION\_KEY '7862YPJ34uumy3MF' TEST\_RUN False SESSION\_COOKIE\_AGE 1209600 SETTINGS\_MODULE 'settings' USE\_ETAGS False EMAIL\_HOST\_NAME 'Affordable Quality Lighting' LANGUAGES (('ar', 'Arabic'), ('az', 'Azerbaijani'), ('bg', 'Bulgarian'), ('bn', 'Bengali'), ('bs', 'Bosnian'), ('ca', 'Catalan'), ('cs', 'Czech'), ('cy', 'Welsh'), ('da', 'Danish'), ('de', 'German'), ('el', 'Greek'), ('en', 'English'), ('en-gb', 'British English'), ('es', 'Spanish'), ('es-ar', 'Argentinian Spanish'), ('es-mx', 'Mexican Spanish'), ('es-ni', 'Nicaraguan Spanish'), ('et', 'Estonian'), ('eu', 'Basque'), ('fa', 'Persian'), ('fi', 'Finnish'), ('fr', 'French'), ('fy-nl', 'Frisian'), ('ga', 'Irish'), ('gl', 'Galician'), ('he', 'Hebrew'), ('hi', 'Hindi'), ('hr', 'Croatian'), ('hu', 'Hungarian'), ('id', 'Indonesian'), ('is', 'Icelandic'), ('it', 'Italian'), ('ja', 'Japanese'), ('ka', 'Georgian'), ('km', 'Khmer'), ('kn', 'Kannada'), ('ko', 'Korean'), ('lt', 'Lithuanian'), ('lv', 'Latvian'), ('mk', 'Macedonian'), ('ml', 'Malayalam'), ('mn', 'Mongolian'), ('nl', 'Dutch'), ('no', 'Norwegian'), ('nb', 'Norwegian Bokmal'), ('nn', 'Norwegian Nynorsk'), ('pa', 'Punjabi'), ('pl', 'Polish'), ('pt', 'Portuguese'), ('pt-br', 'Brazilian Portuguese'), ('ro', 'Romanian'), ('ru', 'Russian'), ('sk', 'Slovak'), ('sl', 'Slovenian'), ('sq', 'Albanian'), ('sr', 'Serbian'), ('sr-latn', 'Serbian Latin'), ('sv', 'Swedish'), ('ta', 'Tamil'), ('te', 'Telugu'), ('th', 'Thai'), ('tr', 'Turkish'), ('uk', 'Ukrainian'), ('ur', 'Urdu'), ('vi', 'Vietnamese'), ('zh-cn', 'Simplified Chinese'), ('zh-tw', 'Traditional Chinese')) FILE\_UPLOAD\_TEMP\_DIR None INTERNAL\_IPS () STATIC\_URL None EMAIL\_PORT 25 SHORT\_DATETIME\_FORMAT 'm/d/Y P' ENFORCE\_SSL True PROFILE False ABSOLUTE\_URL\_OVERRIDES {} DATABASE\_OPTIONS {} CACHE\_MIDDLEWARE\_SECONDS 600 BANNED\_IPS () DATETIME\_INPUT\_FORMATS ('%Y-%m-%d %H:%M:%S', '%Y-%m-%d %H:%M', '%Y-%m-%d', '%m/%d/%Y %H:%M:%S', '%m/%d/%Y %H:%M', '%m/%d/%Y', '%m/%d/%y %H:%M:%S', '%m/%d/%y %H:%M', '%m/%d/%y') DATABASE\_PASSWORD '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*' COMMENTS\_MODERATORS\_GROUP None PROFANITIES\_LIST '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*' EMAIL\_HOST\_USER 'noreply@affordablequalitylighting.com' COMMENTS\_BANNED\_USERS\_GROUP None You're seeing this error because you have DEBUG = True in your Django settings file. Change that to False, and Django will display a standard 500 page. -- ---
**Author:** ![radu\_gheorghe](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/radu_gheorghe/32/556_2.png) [@radu\_gheorghe](https://discuss.elastic.co/u/radu_gheorghe)\ **Post date:** [January 3, 2013, 10:48am UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/2 "2013-01-03T10:48:03Z")
Hello, The "no active shards" part seems the most relevant. I would assume that none of the shards of the index(indices) you're looking for are active/allocated. You can confirm/invalidate this assumption with a command like this: curl localhost:9200/\_cluster/health?pretty=true You need to have yellow/green state to get all the needed results from a search. ## Best regards, Radu [http://sematext.com/](http://sematext.com/) -- Elasticsearch -- Solr -- Lucene On Thu, Jan 3, 2013 at 11:27 AM, [muzakcube64@yahoo.com](mailto:muzakcube64@yahoo.com) wrote: > I'm having issues and I don't know where to turn. Long story short, my > web designer left me high and dry and I have no idea what he did and he > refuses to answer his phone. I have access to the main page but after that, > I'm completely locked out and staring at a SearchPhaseExecutionException > for every single product in my store. Any help would be much appreciated > as I am completely clueless on what to do. Here is the full error log: > > SearchPhaseExecutionException at /category/1 > > Failed to execute phase [query], total failure; shardFailures {[_na_][product][0]: No active shards}{[_na_][product][1]: No active shards}{[_na_][product][2]: No active shards}{[_na_][product][3]: No active shards}{[_na_][product][4]: No active shards} > > Request Method:GETRequest URL: > [http://www.affordablequalitylighting.com/category/1Django](http://www.affordablequalitylighting.com/category/1Django) Version:1.3.1Exception > Type:SearchPhaseExecutionExceptionException Value: > > Failed to execute phase [query], total failure; shardFailures {[_na_][product][0]: No active shards}{[_na_][product][1]: No active shards}{[_na_][product][2]: No active shards}{[_na_][product][3]: No active shards}{[_na_][product][4]: No active shards} > > Exception Location:/usr/local/lib/python2.6/dist-packages/pyes/convert\_errors.py > in raise\_if\_error, line 68Python Executable:/usr/bin/pythonPython Version: > 2.6.5Python Path: > > ['/usr/lib/python2.6', > '/usr/lib/python2.6/plat-linux2', > '/usr/lib/python2.6/lib-tk', > '/usr/lib/python2.6/lib-old', > '/usr/lib/python2.6/lib-dynload', > '/usr/lib/python2.6/dist-packages', > '/usr/lib/python2.6/dist-packages/PIL', > '/usr/lib/pymodules/python2.6', > '/usr/lib/pymodules/python2.6/gtk-2.0', > '/usr/lib/python2.6/dist-packages/wx-2.8-gtk2-unicode', > '/usr/local/lib/python2.6/dist-packages', > '/var/www/singularity/py'] > > Server time:Thu, 3 Jan 2013 01:24:15 -0800 > Traceback Switch to copy-and-paste view[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > - /usr/local/lib/python2.6/dist-packages/django/core/handlers/base.py > in get\_response > > 1. > > ``` > response = callback(request, *callback_args, **callback_kwargs) > > ... > > ``` > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > - /var/www/singularity/py/store/catalog/views.py in category\_view > > 1. > > ``` > filterblock = filtering.filter(category, request, num_results, page_num) > > ... > > ``` > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > - /var/www/singularity/py/store/catalog/filtering.py in filter > > 1. > > ``` > results = sitesearch.raw_search(q, search.product_index) > > ... > > ``` > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > - /var/www/singularity/py/sitesearch/interface.py in raw\_search > > 1. > > ``` > return C.search(data, [_idxname(index_name)]) > > ... > > ``` > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > - /usr/local/lib/python2.6/dist-packages/pyes/es.py in search > > 1. > > ``` > return self._query_call("_search", body, indexes, doc_types, **query_params) > > ... > > ``` > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > - /usr/local/lib/python2.6/dist-packages/pyes/es.py in \_query\_call > > 1. > > ``` > response = self._send_request('GET', path, body, querystring_args) > > ... > > ``` > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > - /usr/local/lib/python2.6/dist-packages/pyes/es.py in \_send\_request > > 1. > > ``` > raise_if_error(response.status, decoded) > > ... > > ``` > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > - /usr/local/lib/python2.6/dist-packages/pyes/convert\_errors.py in > raise\_if\_error > > 1. > > ``` > raise excClass(msg, status, result) > > ... > > ``` > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > Request informationGET > > No GET data > POST > > No POST data > FILES > > No FILES data > COOKIESVariableValue\_\_utmz > > '36364016.1355763714.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)' > > \_vis\_opt\_s > > '2%7C' > > \_vis\_opt\_exp\_11\_goal\_3 > > '1' > > sessionid > > '8894e58e6eee1d47f9bdfdb41e9fe7f4' > > \_vis\_opt\_exp\_11\_combi > > '2' > > csrftoken > > '8b335c16f43607ae18f730559c2e0d56' > > \_\_utma > > '36364016.1140701240.1355763714.1355942217.1355945322.4' > > \_vis\_opt\_exp\_10\_combi > > '1' > > METAVariableValuemod\_wsgi.reload\_mechanism > > '1' > > mod\_wsgi.listener\_port > > '80' > > HTTP\_REFERER > > '[http://www.affordablequalitylighting.com/](http://www.affordablequalitylighting.com/)' > > mod\_wsgi.listener\_host > > '' > > SERVER\_SOFTWARE > > 'Apache/2.2.14 (Ubuntu)' > > SCRIPT\_NAME > > u'' > > SERVER\_SIGNATURE > > 'Apache/2.2.14 (Ubuntu) Server at [www.affordablequalitylighting.com](http://www.affordablequalitylighting.com) Port 80\n' > > REQUEST\_METHOD > > 'GET' > > PATH\_INFO > > u'/outdoor-lighting' > > SERVER\_PROTOCOL > > 'HTTP/1.1' > > QUERY\_STRING > > '' > > PATH > > '/usr/local/bin:/usr/bin:/bin' > > HTTP\_ACCEPT\_CHARSET > > 'ISO-8859-1,utf-8;q=0.7,\*;q=0.3' > > HTTP\_USER\_AGENT > > 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.97 Safari/537.11' > > HTTP\_CONNECTION > > 'keep-alive' > > HTTP\_COOKIE > > '\_vis\_opt\_exp\_10\_combi=1; \_vis\_opt\_s=2%7C; \_vis\_opt\_exp\_11\_combi=2; \_vis\_opt\_exp\_11\_goal\_3=1; \_\_utma=36364016.1140701240.1355763714.1355942217.1355945322.4; \_\_utmz=36364016.1355763714.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); csrftoken=8b335c16f43607ae18f730559c2e0d56; sessionid=8894e58e6eee1d47f9bdfdb41e9fe7f4' > > SERVER\_NAME > > '[www.affordablequalitylighting.com](http://www.affordablequalitylighting.com)' > > REMOTE\_ADDR > > '10.168.14.143' > > wsgi.url\_scheme > > 'http' > > PATH\_TRANSLATED > > '/var/www/singularity/py/wsgi/singularity.py/outdoor-lighting' > > SERVER\_PORT > > '80' > > wsgi.multiprocess > > False > > SERVER\_ADDR > > '10.160.83.83' > > DOCUMENT\_ROOT > > '/htdocs' > > mod\_wsgi.process\_group > > 'django' > > HTTP\_X\_FORWARDED\_PROTO > > 'http' > > SCRIPT\_FILENAME > > '/var/www/singularity/py/wsgi/singularity.py' > > SERVER\_ADMIN > > '[no address given]' > > SCRIPT\_URI > > '[http://www.affordablequalitylighting.com/outdoor-lighting](http://www.affordablequalitylighting.com/outdoor-lighting)' > > wsgi.input > > \ > > HTTP\_HOST > > '[www.affordablequalitylighting.com](http://www.affordablequalitylighting.com)' > > SCRIPT\_URL > > '/outdoor-lighting' > > wsgi.multithread > > True > > mod\_wsgi.callable\_object > > 'application' > > REQUEST\_URI > > '/outdoor-lighting' > > HTTP\_ACCEPT > > 'text/html,application/xhtml+xml,application/xml;q=0.9,_/_;q=0.8' > > wsgi.version > > (1, 0) > > GATEWAY\_INTERFACE > > 'CGI/1.1' > > HTTP\_X\_FORWARDED\_FOR > > '173.196.151.198' > > wsgi.errors > > \ > > REMOTE\_PORT > > '37237' > > HTTP\_ACCEPT\_LANGUAGE > > 'en-US,en;q=0.8' > > mod\_wsgi.version > > (2, 8) > > wsgi.run\_once > > False > > HTTP\_X\_FORWARDED\_PORT > > '80' > > mod\_wsgi.application\_group > > '' > > mod\_wsgi.script\_reloading > > '1' > > wsgi.file\_wrapper > > '' > > CSRF\_COOKIE > > '8b335c16f43607ae18f730559c2e0d56' > > HTTP\_ACCEPT\_ENCODING > > 'gzip,deflate,sdch' > > SettingsUsing settings module settingsSettingValueGOOGLE\_ANALYTICS\_ID > > 'UA-13030541-1' > > SERVER\_EMAIL > > 'noreply@affordablequalitylighting.com' > > USE\_L10N > > True > > USE\_THOUSAND\_SEPARATOR > > False > > IMAGES\_CONFIG > > {'dest\_dir': '/var/www/singularity-media/images/store', > 'url\_prefix': 'images/store'} > > LANGUAGE\_CODE > > 'en-us' > > ROOT\_URLCONF > > 'urls' > > MANAGERS > > (('Blake Eggleston', 'bdeggleston@gmail.com'), > ('Blake Eggleston', 'be@concordlighting.com')) > > SESSION\_EXPIRE\_AT\_BROWSER\_CLOSE > > False > > DEFAULT\_CHARSET > > 'utf-8' > > STATIC\_ROOT > > '' > > TEST\_DATABASE\_CHARSET > > None > > USING\_WSGI > > True > > MESSAGE\_STORAGE > > 'django.contrib.messages.storage.user\_messages.LegacyFallbackStorage' > > DATABASE\_HOST > > '' > > EMAIL\_SUBJECT\_PREFIX > > '[Django] ' > > SEND\_BROKEN\_LINK\_EMAILS > > False > > URL\_VALIDATOR\_USER\_AGENT > > 'Django/1.3.1 ([http://www.djangoproject.com](http://www.djangoproject.com))' > > STATICFILES\_FINDERS > > ('django.contrib.staticfiles.finders.FileSystemFinder', > 'django.contrib.staticfiles.finders.AppDirectoriesFinder') > > SESSION\_COOKIE\_DOMAIN > > None > > SESSION\_COOKIE\_NAME > > 'sessionid' > > CSRF\_COOKIE\_NAME > > 'csrftoken' > > ADMIN\_FOR > > () > > TIME\_INPUT\_FORMATS > > ('%H:%M:%S', '%H:%M') > > DATABASES > > {'default': {'ENGINE': 'django.db.backends.mysql', > 'HOST': '[aqldb.clapuphfn4dw.us-west-1.rds.amazonaws.com](http://aqldb.clapuphfn4dw.us-west-1.rds.amazonaws.com)', > 'NAME': 'singularity', > 'OPTIONS': {}, > 'PASSWORD': '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*', > 'PORT': '', > 'TEST\_CHARSET': None, > 'TEST\_COLLATION': None, > 'TEST\_MIRROR': None, > 'TEST\_NAME': None, > 'TIME\_ZONE': 'America/Los\_Angeles', > 'USER': 'singularity'}} > > TEST\_DATABASE\_NAME > > None > > FILE\_UPLOAD\_PERMISSIONS > > None > > FILE\_UPLOAD\_HANDLERS > > ('django.core.files.uploadhandler.MemoryFileUploadHandler', > 'django.core.files.uploadhandler.TemporaryFileUploadHandler') > > DEFAULT\_CONTENT\_TYPE > > 'text/html' > > TEST\_RUNNER > > 'store.testing.runners.TestRunner' > > AUTHNET\_DEBUG > > False > > FIRST\_DAY\_OF\_WEEK > > 0 > > DATABASE\_ROUTERS > > SEND\_EMAILS > > True > > YEAR\_MONTH\_FORMAT > > 'F Y' > > CONTENT\_PERMS > > 508 > > CACHES > > {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache', > 'LOCATION': ''}} > > ACCOUNT\_CONTENT\_BASE\_PATH > > '/var/www/singularity-media/images/store/account\_src' > > PAYPAL\_DEBUG > > False > > SESSION\_COOKIE\_PATH > > '/' > > USE\_X\_FORWARDED\_HOST > > False > > CONTENT\_BASE\_PATH > > '/var/www/singularity-media/images/store/content' > > AUTHNET\_ENABLED > > True > > IGNORABLE\_404\_ENDS > > ('mail.pl', 'mailform.pl', 'mail.cgi', 'mailform.cgi', 'favicon.ico', '.php') > > ENCRYPTION\_CONFIG > > {'cc\_staging\_key': '54c376a2210b8ca994e88758c9a31871', > 'cc\_storage\_key': 'ea284f3c20a9d2c944a6bcb4f7b774d9'} > > MIDDLEWARE\_CLASSES > > ('store.metrics.middleware.MetricsMiddleware', > 'store.middleware.WorkQueue', > 'store.middleware.RedirectMiddleware', > 'django.middleware.common.CommonMiddleware', > 'django.contrib.sessions.middleware.SessionMiddleware', > 'django.middleware.csrf.CsrfViewMiddleware', > 'django.contrib.auth.middleware.AuthenticationMiddleware', > 'django.contrib.messages.middleware.MessageMiddleware', > 'store.middleware.UrlRenamer', > 'store.discount.middleware.DiscountUrlAttach', > 'dynamicpages.DynamicPagesHandler') > > USE\_I18N > > True > > THOUSAND\_SEPARATOR > > ',' > > SECRET\_KEY > > '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*' > > LANGUAGE\_COOKIE\_NAME > > 'django\_language' > > DEFAULT\_INDEX\_TABLESPACE > > '' > > SERVE\_IMAGES > > True > > CONFIG\_PATH > > '/var/www/singularity/data/config' > > TRANSACTIONS\_MANAGED > > False > > LOGGING\_CONFIG > > 'django.utils.log.dictConfig' > > PAYPAL\_DOMAIN\_NAME > > '[aql-lb002-1208657660.us-west-1.elb.amazonaws.com](http://aql-lb002-1208657660.us-west-1.elb.amazonaws.com)' > > APPEND\_SLASH > > True > > TEMPLATE\_LOADERS > > ('django.template.loaders.filesystem.Loader', > 'django.template.loaders.app\_directories.Loader') > > ACCOUNT\_IMAGE\_FORMATS > > {'formats': [{'description': 'the fullsize account image', > 'max\_x': 80, > 'max\_y': 80, > 'name': 'account\_full'}, > {'description': 'images shown in the sub comments', > 'max\_x': 40, > 'max\_y': 40, > 'name': 'account\_small'}], > 'src\_dir': '/var/www/singularity-media/images/store/account\_src'} > > TEMPLATE\_DEBUG > > False > > CONTENT\_BASE\_URL > > '/images/store/content' > > TEST\_DATABASE\_COLLATION > > None > > FORCE\_SCRIPT\_NAME > > None > > CACHE\_BACKEND > > 'locmem://' > > SESSION\_COOKIE\_SECURE > > False > > TEST\_EXCLUDE > > ('django', 'authorizenet', 'paypal') > > COMPILE\_TEMPLATES > > True > > LOCAL\_PATH > > '/var/www/singularity' > > CSRF\_COOKIE\_DOMAIN > > None > > FILE\_CHARSET > > 'utf-8' > > DEBUG > > False > > SESSION\_FILE\_PATH > > None > > DEFAULT\_FILE\_STORAGE > > 'django.core.files.storage.FileSystemStorage' > > INSTALLED\_APPS > > ['django.contrib.auth', > 'django.contrib.contenttypes', > 'django.contrib.sessions', > 'django.contrib.sites', > 'django.contrib.messages', > 'django.contrib.admin', > 'django.contrib.admindocs', > 'authorizenet', > 'paypal.standard.ipn', > 'caching', > 'sitesearch', > 'interaction', > 'blog', > 'offline', > 'store', > 'store.account', > 'store.cart', > 'store.catalog', > 'store.catalog.indexing', > 'store.catalog.manage', > 'store.content', > 'store.discount', > 'store.images', > 'store.locations', > 'store.marketing', > 'store.metrics', > 'store.orders', > 'store.reviews', > 'store.shipments', > 'store.transactions'] > > LANGUAGES\_BIDI > > ('he', 'ar', 'fa') > > DATABASE\_ENGINE > > '' > > DEFAULT\_FILTER\_RESULTS > > 20 > > DATABASE\_NAME > > '' > > COMMENTS\_FIRST\_FEW > > 0 > > AUTHNET\_LOGIN\_ID > > '2w87JmTv' > > REQUIRE\_PAYMENT\_AT > > 'invoice' > > SEARCH\_SERVERS > > ('127.0.0.1:9200',) > > SESSION\_COOKIE\_HTTPONLY > > False > > DATABASE\_PORT > > '' > > DEBUG\_PROPAGATE\_EXCEPTIONS > > False > > PAYPAL\_RECEIVER\_EMAIL > > 'paypal@affordablequalitylighting.com' > > MONTH\_DAY\_FORMAT > > 'F j' > > AUTHNET\_IMMEDIATE\_CAPTURE > > False > > LOGIN\_URL > > '/user' > > DEFAULT\_SEARCH\_QTY > > 9 > > TIME\_FORMAT > > 'P' > > DATE\_INPUT\_FORMATS > > ('%Y-%m-%d', > '%m/%d/%Y', > '%m/%d/%y', > '%b %d %Y', > '%b %d, %Y', > '%d %b %Y', > '%d %b, %Y', > '%B %d %Y', > '%B %d, %Y', > '%d %B %Y', > '%d %B, %Y') > > AUTHENTICATION\_BACKENDS > > ('store.account.backends.EmailAuth',) > > EMAIL\_HOST\_PASSWORD > > '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*' > > APP\_INSTANCE > > 0 > > TEMPLATE\_PATH > > '/var/www/tmplaql' > > CONTENT\_GROUP > > 'images' > > PASSWORD\_RESET\_TIMEOUT\_DAYS > > '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*' > > CACHE\_MIDDLEWARE\_ALIAS > > 'default' > > SESSION\_SAVE\_EVERY\_REQUEST > > True > > ADMIN\_MEDIA\_PREFIX > > '/admin/media/' > > NUMBER\_GROUPING > > 0 > > SESSION\_ENGINE > > 'django.contrib.sessions.backends.db' > > STATICFILES\_STORAGE > > 'django.contrib.staticfiles.storage.StaticFilesStorage' > > CSRF\_FAILURE\_VIEW > > 'django.views.csrf.csrf\_failure' > > COMMENTS\_SKETCHY\_USERS\_GROUP > > None > > LOGIN\_REDIRECT\_URL > > '/accounts/profile/' > > PAYPAL\_ENABLED > > True > > DECIMAL\_SEPARATOR > > '.' > > CACHE\_MIDDLEWARE\_KEY\_PREFIX > > '' > > LOCALE\_PATHS > > () > > TEMPLATE\_STRING\_IF\_INVALID > > '' > > COMMENTS\_ALLOW\_PROFANITIES > > False > > LOGOUT\_URL > > '/accounts/logout/' > > EMAIL\_USE\_TLS > > True > > TEMPLATE\_DIRS > > ('/var/www/tmplaql/templates', '/var/www/singularity/templates') > > BLOG\_CONTENT\_BASE\_URL > > '/images/blog' > > FIXTURE\_DIRS > > ('/var/www/singularity/fixtures',) > > EMAIL\_HOST > > '[smtp.gmail.com](http://smtp.gmail.com)' > > DATE\_FORMAT > > 'N j, Y' > > ACCOUNT\_CONTENT\_BASE\_URL > > '/images/store/account\_src' > > MEDIA\_ROOT > > '' > > ADMINS > > (('Blake Eggleston', 'bdeggleston@gmail.com'), > ('Blake Eggleston', 'be@concordlighting.com')) > > FORMAT\_MODULE\_PATH > > None > > DEFAULT\_FROM\_EMAIL > > 'webmaster@localhost' > > BLOG\_CONTENT\_BASE\_PATH > > '/var/www/singularity-media/images/blog' > > PRODUCTS\_PER\_PAGE > > 10000 > > REQUIRE\_PAYMENT\_CHOICES > > ['invoice', 'processing', 'shipment', 'completion'] > > STATICFILES\_DIRS > > () > > MEDIA\_URL > > '/media/' > > DATETIME\_FORMAT > > 'N j, Y, P' > > IGNORABLE\_404\_STARTS > > ('/cgi-bin/', '/\_vti\_bin', '/\_vti\_inf') > > DEBUG\_CHECKOUT > > False > > PROFILE\_SQL > > False > > SITE\_ID > > 1 > > DISALLOWED\_USER\_AGENTS > > () > > ALLOWED\_INCLUDE\_ROOTS > > () > > PRODUCT\_IMAGE\_FORMATS > > {'formats': [{'description': 'the default image on the product page', > 'max\_x': 447, > 'max\_y': 384, > 'name': 'product\_page'}, > {'description': 'images shown in the category/filtering view', > 'max\_x': 130, > 'max\_y': 96, > 'name': 'product\_cart'}, > {'description': 'images shown in the order review view', > 'max\_x': 60, > 'max\_y': 60, > 'name': 'product\_review'}, > {'description': 'images shown in the category/filtering view', > 'max\_x': 48, > 'max\_y': 49, > 'name': 'product\_preview'}, > {'description': 'category list and related products', > 'max\_x': 150, > 'max\_y': 150, > 'name': 'product\_list'}, > {'description': 'the tiny images in the footer', > 'max\_x': 25, > 'max\_y': 25, > 'name': 'product\_tiny'}, > {'description': 'the full highres image', > 'force\_size': False, > 'max\_x': 1000, > 'max\_y': 1000, > 'name': 'product\_full'}], > 'src\_dir': '/var/www/singularity-media/images/store/product\_src'} > > CONTENT\_USER > > 'www-data' > > LOGGING > > {'disable\_existing\_loggers': False, > 'handlers': {'mail\_admins': {'class': 'django.utils.log.AdminEmailHandler', > 'level': 'ERROR'}}, > 'loggers': {'django.request': {'handlers': ['mail\_admins'], > 'level': 'ERROR', > 'propagate': True}}, > 'version': 1} > > PREPEND\_WWW > > False > > SHORT\_DATE\_FORMAT > > 'm/d/Y' > > DATABASE\_USER > > '' > > FREIGHT\_CARRIERS > > {'rate\_modifiers': {'3aa49ec6bfc910647fa1c5a013e48eef': 25}, > 'ups': {'api\_access\_key': 'FC6D4E635C4A7F10', > 'api\_password': 'passive1', > 'api\_user\_id': 'LampsDirect', > 'billing\_city': 'Valencia', > 'billing\_country\_code': 'US', > 'billing\_post\_code': '91355', > 'billing\_territory': 'CA', > 'dim\_type': 'IN', > 'free\_freight\_amount': 0, > 'freight\_markup': -20, > 'shipper\_number': 'X0305A', > 'weight\_type': 'LBS'}, > 'ups\_freight': {'api\_access\_key': 'CC770A558C47ACB8', > 'api\_password': 'passive1', > 'api\_user\_id': 'LampsDirect', > 'billing\_city': 'Valencia', > 'billing\_country\_code': 'US', > 'billing\_name': 'Concord Lighting', > 'billing\_post\_code': '91355', > 'billing\_street1': '28150 Ave Crocker', > 'billing\_street2': 'Ste 312', > 'billing\_territory': 'CA', > 'dim\_type': 'IN', > 'free\_freight\_amount': 0, > 'freight\_markup': -20, > 'shipper\_number': 'X0305A', > 'weight\_type': 'LBS'}} > > ANALYTICS\_ACTIVE > > True > > TIME\_ZONE > > 'America/Los\_Angeles' > > FILE\_UPLOAD\_MAX\_MEMORY\_SIZE > > 2621440 > > PAYMENT\_PROCESSORS > > {'authorizenet': {'key': '7862YPJ34uumy3MF', > 'live': True, > 'username': '2w87JmTv'}, > 'paypalwps': {'business\_display\_name': 'Affordable Quality Lighting', > 'domain\_name': '[ec2-50-18-148-185.us-west-1.compute.amazonaws.com](http://ec2-50-18-148-185.us-west-1.compute.amazonaws.com)', > 'key': 'eyoBTzMK8wy25X-Yq5irPxrSe\_\_Gx5BBev4-UVhcq150mnR2VEEWeEbbCRm', > 'live': False, > 'username': 'be\_1333732418\_biz@concordlighting.com'}} > > EMAIL\_BACKEND > > 'django.core.mail.backends.smtp.EmailBackend' > > BLOG\_TITLE > > 'DIY Lighting Blog' > > DEFAULT\_TABLESPACE > > '' > > TEMPLATE\_CONTEXT\_PROCESSORS > > ('django.contrib.auth.context\_processors.auth', > 'django.core.context\_processors.debug', > 'django.core.context\_processors.i18n', > 'django.core.context\_processors.media', > 'django.core.context\_processors.static', > 'django.contrib.messages.context\_processors.messages') > > AUTHNET\_TRANSACTION\_KEY > > '7862YPJ34uumy3MF' > > TEST\_RUN > > False > > SESSION\_COOKIE\_AGE > > 1209600 > > SETTINGS\_MODULE > > 'settings' > > USE\_ETAGS > > False > > EMAIL\_HOST\_NAME > > 'Affordable Quality Lighting' > > LANGUAGES > > (('ar', 'Arabic'), > ('az', 'Azerbaijani'), > ('bg', 'Bulgarian'), > ('bn', 'Bengali'), > ('bs', 'Bosnian'), > ('ca', 'Catalan'), > ('cs', 'Czech'), > ('cy', 'Welsh'), > ('da', 'Danish'), > ('de', 'German'), > ('el', 'Greek'), > ('en', 'English'), > ('en-gb', 'British English'), > ('es', 'Spanish'), > ('es-ar', 'Argentinian Spanish'), > ('es-mx', 'Mexican Spanish'), > ('es-ni', 'Nicaraguan Spanish'), > ('et', 'Estonian'), > ('eu', 'Basque'), > ('fa', 'Persian'), > ('fi', 'Finnish'), > ('fr', 'French'), > ('fy-nl', 'Frisian'), > ('ga', 'Irish'), > ('gl', 'Galician'), > ('he', 'Hebrew'), > ('hi', 'Hindi'), > ('hr', 'Croatian'), > ('hu', 'Hungarian'), > ('id', 'Indonesian'), > ('is', 'Icelandic'), > ('it', 'Italian'), > ('ja', 'Japanese'), > ('ka', 'Georgian'), > ('km', 'Khmer'), > ('kn', 'Kannada'), > ('ko', 'Korean'), > ('lt', 'Lithuanian'), > ('lv', 'Latvian'), > ('mk', 'Macedonian'), > ('ml', 'Malayalam'), > ('mn', 'Mongolian'), > ('nl', 'Dutch'), > ('no', 'Norwegian'), > ('nb', 'Norwegian Bokmal'), > ('nn', 'Norwegian Nynorsk'), > ('pa', 'Punjabi'), > ('pl', 'Polish'), > ('pt', 'Portuguese'), > ('pt-br', 'Brazilian Portuguese'), > ('ro', 'Romanian'), > ('ru', 'Russian'), > ('sk', 'Slovak'), > ('sl', 'Slovenian'), > ('sq', 'Albanian'), > ('sr', 'Serbian'), > ('sr-latn', 'Serbian Latin'), > ('sv', 'Swedish'), > ('ta', 'Tamil'), > ('te', 'Telugu'), > ('th', 'Thai'), > ('tr', 'Turkish'), > ('uk', 'Ukrainian'), > ('ur', 'Urdu'), > ('vi', 'Vietnamese'), > ('zh-cn', 'Simplified Chinese'), > ('zh-tw', 'Traditional Chinese')) > > FILE\_UPLOAD\_TEMP\_DIR > > None > > INTERNAL\_IPS > > () > > STATIC\_URL > > None > > EMAIL\_PORT > > 25 > > SHORT\_DATETIME\_FORMAT > > 'm/d/Y P' > > ENFORCE\_SSL > > True > > PROFILE > > False > > ABSOLUTE\_URL\_OVERRIDES > > {} > > DATABASE\_OPTIONS > > {} > > CACHE\_MIDDLEWARE\_SECONDS > > 600 > > BANNED\_IPS > > () > > DATETIME\_INPUT\_FORMATS > > ('%Y-%m-%d %H:%M:%S', > '%Y-%m-%d %H:%M', > '%Y-%m-%d', > '%m/%d/%Y %H:%M:%S', > '%m/%d/%Y %H:%M', > '%m/%d/%Y', > '%m/%d/%y %H:%M:%S', > '%m/%d/%y %H:%M', > '%m/%d/%y') > > DATABASE\_PASSWORD > > '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*' > > COMMENTS\_MODERATORS\_GROUP > > None > > PROFANITIES\_LIST > > '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*' > > EMAIL\_HOST\_USER > > 'noreply@affordablequalitylighting.com' > > COMMENTS\_BANNED\_USERS\_GROUP > > None > > You're seeing this error because you have DEBUG = True in your Django > settings file. Change that to False, and Django will display a standard > 500 page. > > -- -- ---
**Author:** ![muzakcube64](https://avatars.discourse-cdn.com/v4/letter/m/a183cd/32.png) [@muzakcube64](https://discuss.elastic.co/u/muzakcube64)\ **Post date:** [January 3, 2013, 4:21pm UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/3 "2013-01-03T16:21:47Z")
I appreciate the fast response! I ran the command and this was the output: "cluster\_name" : "elasticsearch", "status" : "red", "timed\_out" : false, "number\_of\_nodes" : 1, "number\_of\_data\_nodes" : 1, "active\_primary\_shards" : 0, "active\_shards" : 0, "relocating\_shards" : 0, "initializing\_shards" : 0, "unassigned\_shards" : 20 How do I get the status out of the red? I would hazard a guess that I have to allocate the shards but again I'm a moron with this type of thing and have no idea on where to start. On Thursday, January 3, 2013 2:48:03 AM UTC-8, Radu Gheorghe wrote: > Hello, > > The "no active shards" part seems the most relevant. I would assume that > none of the shards of the index(indices) you're looking for are > active/allocated. > > You can confirm/invalidate this assumption with a command like this: > curl localhost:9200/\_cluster/health?pretty=true > > You need to have yellow/green state to get all the needed results from a > search. > > ## Best regards, Radu > > [http://sematext.com/](http://sematext.com/) -- Elasticsearch -- Solr -- Lucene > > On Thu, Jan 3, 2013 at 11:27 AM, \<[muzak...@yahoo.com](mailto:muzak...@yahoo.com) \\> wrote: > > > I'm having issues and I don't know where to turn. Long story short, my > > web designer left me high and dry and I have no idea what he did and he > > refuses to answer his phone. I have access to the main page but after that, > > I'm completely locked out and staring at a SearchPhaseExecutionException > > for every single product in my store. Any help would be much appreciated > > as I am completely clueless on what to do. Here is the full error log: > > > > SearchPhaseExecutionException at /category/1 > > > > Failed to execute phase [query], total failure; shardFailures {[_na_][product][0]: No active shards}{[_na_][product][1]: No active shards}{[_na_][product][2]: No active shards}{[_na_][product][3]: No active shards}{[_na_][product][4]: No active shards} > > > > Request Method: GETRequest URL: > > [http://www.affordablequalitylighting.com/category/1](http://www.affordablequalitylighting.com/category/1) Django Version:1.3.1Exception > > Type: SearchPhaseExecutionExceptionException Value: > > > > Failed to execute phase [query], total failure; shardFailures {[_na_][product][0]: No active shards}{[_na_][product][1]: No active shards}{[_na_][product][2]: No active shards}{[_na_][product][3]: No active shards}{[_na_][product][4]: No active shards} > > > > Exception Location:/usr/local/lib/python2.6/dist-packages/pyes/convert\_errors.py > > in raise\_if\_error, line 68 Python Executable:/usr/bin/python Python > > Version:2.6.5Python Path: > > > > ['/usr/lib/python2.6', > > '/usr/lib/python2.6/plat-linux2', > > '/usr/lib/python2.6/lib-tk', > > '/usr/lib/python2.6/lib-old', > > '/usr/lib/python2.6/lib-dynload', > > '/usr/lib/python2.6/dist-packages', > > '/usr/lib/python2.6/dist-packages/PIL', > > '/usr/lib/pymodules/python2.6', > > '/usr/lib/pymodules/python2.6/gtk-2.0', > > '/usr/lib/python2.6/dist-packages/wx-2.8-gtk2-unicode', > > '/usr/local/lib/python2.6/dist-packages', > > '/var/www/singularity/py'] > > > > Server time: Thu, 3 Jan 2013 01:24:15 -0800 > > Traceback Switch to copy-and-paste view[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > > > - /usr/local/lib/python2.6/dist-packages/django/core/handlers/base.py > > in get\_response > > > > 1. > > > > ``` > > response = callback(request, *callback_args, **callback_kwargs) > > > > ... > > > > ``` > > > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > > > - /var/www/singularity/py/store/catalog/views.py in category\_view > > > > 1. > > > > ``` > > filterblock = filtering.filter(category, request, num_results, page_num) > > > > ... > > > > ``` > > > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > > > - /var/www/singularity/py/store/catalog/filtering.py in filter > > > > 1. > > > > ``` > > results = sitesearch.raw_search(q, search.product_index) > > > > ... > > > > ``` > > > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > > > - /var/www/singularity/py/sitesearch/interface.py in raw\_search > > > > 1. > > > > ``` > > return C.search(data, [_idxname(index_name)]) > > > > ... > > > > ``` > > > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > > > - /usr/local/lib/python2.6/dist-packages/pyes/es.py in search > > > > 1. > > > > ``` > > return self._query_call("_search", body, indexes, doc_types, **query_params) > > > > ... > > > > ``` > > > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > > > - /usr/local/lib/python2.6/dist-packages/pyes/es.py in \_query\_call > > > > 1. > > > > ``` > > response = self._send_request('GET', path, body, querystring_args) > > > > ... > > > > ``` > > > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > > > - /usr/local/lib/python2.6/dist-packages/pyes/es.py in \_send\_request > > > > 1. > > > > ``` > > raise_if_error(response.status, decoded) > > > > ... > > > > ``` > > > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > > > - /usr/local/lib/python2.6/dist-packages/pyes/convert\_errors.py in > > raise\_if\_error > > > > 1. > > > > ``` > > raise excClass(msg, status, result) > > > > ... > > > > ``` > > > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > > > Request information GET > > > > No GET data > > POST > > > > No POST data > > FILES > > > > No FILES data > > COOKIES VariableValue \_\_utmz > > > > '36364016.1355763714.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)' > > > > \_vis\_opt\_s > > > > '2%7C' > > > > \_vis\_opt\_exp\_11\_goal\_3 > > > > '1' > > > > sessionid > > > > '8894e58e6eee1d47f9bdfdb41e9fe7f4' > > > > \_vis\_opt\_exp\_11\_combi > > > > '2' > > > > csrftoken > > > > '8b335c16f43607ae18f730559c2e0d56' > > > > \_\_utma > > > > '36364016.1140701240.1355763714.1355942217.1355945322.4' > > > > \_vis\_opt\_exp\_10\_combi > > > > '1' > > > > META Variable Valuemod\_wsgi.reload\_mechanism > > > > '1' > > > > mod\_wsgi.listener\_port > > > > '80' > > > > HTTP\_REFERER > > > > '[http://www.affordablequalitylighting.com/](http://www.affordablequalitylighting.com/)' > > > > mod\_wsgi.listener\_host > > > > '' > > > > SERVER\_SOFTWARE > > > > 'Apache/2.2.14 (Ubuntu)' > > > > SCRIPT\_NAME > > > > u'' > > > > SERVER\_SIGNATURE > > > > 'Apache/2.2.14 (Ubuntu) Server at [www.affordablequalitylighting.com](http://www.affordablequalitylighting.com) Port 80\n' > > > > REQUEST\_METHOD > > > > 'GET' > > > > PATH\_INFO > > > > u'/outdoor-lighting' > > > > SERVER\_PROTOCOL > > > > 'HTTP/1.1' > > > > QUERY\_STRING > > > > '' > > > > PATH > > > > '/usr/local/bin:/usr/bin:/bin' > > > > HTTP\_ACCEPT\_CHARSET > > > > 'ISO-8859-1,utf-8;q=0.7,\*;q=0.3' > > > > HTTP\_USER\_AGENT > > > > 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.97 Safari/537.11' > > > > HTTP\_CONNECTION > > > > 'keep-alive' > > > > HTTP\_COOKIE > > > > '\_vis\_opt\_exp\_10\_combi=1; \_vis\_opt\_s=2%7C; \_vis\_opt\_exp\_11\_combi=2; \_vis\_opt\_exp\_11\_goal\_3=1; \_\_utma=36364016.1140701240.1355763714.1355942217.1355945322.4; \_\_utmz=36364016.1355763714.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); csrftoken=8b335c16f43607ae18f730559c2e0d56; sessionid=8894e58e6eee1d47f9bdfdb41e9fe7f4' > > > > SERVER\_NAME > > > > '[www.affordablequalitylighting.com](http://www.affordablequalitylighting.com)' > > > > REMOTE\_ADDR > > > > '10.168.14.143' > > > > wsgi.url\_scheme > > > > 'http' > > > > PATH\_TRANSLATED > > > > '/var/www/singularity/py/wsgi/singularity.py/outdoor-lighting' > > > > SERVER\_PORT > > > > '80' > > > > wsgi.multiprocess > > > > False > > > > SERVER\_ADDR > > > > '10.160.83.83' > > > > DOCUMENT\_ROOT > > > > '/htdocs' > > > > mod\_wsgi.process\_group > > > > 'django' > > > > HTTP\_X\_FORWARDED\_PROTO > > > > 'http' > > > > SCRIPT\_FILENAME > > > > '/var/www/singularity/py/wsgi/singularity.py' > > > > SERVER\_ADMIN > > > > '[no address given]' > > > > SCRIPT\_URI > > > > '[http://www.affordablequalitylighting.com/outdoor-lighting](http://www.affordablequalitylighting.com/outdoor-lighting)' > > > > wsgi.input > > > > \ > > > > HTTP\_HOST > > > > '[www.affordablequalitylighting.com](http://www.affordablequalitylighting.com)' > > > > SCRIPT\_URL > > > > '/outdoor-lighting' > > > > wsgi.multithread > > > > True > > > > mod\_wsgi.callable\_object > > > > 'application' > > > > REQUEST\_URI > > > > '/outdoor-lighting' > > > > HTTP\_ACCEPT > > > > 'text/html,application/xhtml+xml,application/xml;q=0.9,_/_;q=0.8' > > > > wsgi.version > > > > (1, 0) > > > > GATEWAY\_INTERFACE > > > > 'CGI/1.1' > > > > HTTP\_X\_FORWARDED\_FOR > > > > '173.196.151.198' > > > > wsgi.errors > > > > \ > > > > REMOTE\_PORT > > > > '37237' > > > > HTTP\_ACCEPT\_LANGUAGE > > > > 'en-US,en;q=0.8' > > > > mod\_wsgi.version > > > > (2, 8) > > > > wsgi.run\_once > > > > False > > > > HTTP\_X\_FORWARDED\_PORT > > > > '80' > > > > mod\_wsgi.application\_group > > > > '' > > > > mod\_wsgi.script\_reloading > > > > '1' > > > > wsgi.file\_wrapper > > > > '' > > > > CSRF\_COOKIE > > > > '8b335c16f43607ae18f730559c2e0d56' > > > > HTTP\_ACCEPT\_ENCODING > > > > 'gzip,deflate,sdch' > > > > SettingsUsing settings module settings SettingValue GOOGLE\_ANALYTICS\_ID > > > > 'UA-13030541-1' > > > > SERVER\_EMAIL > > > > 'nor...@affordablequalitylighting.com \' > > > > USE\_L10N > > > > True > > > > USE\_THOUSAND\_SEPARATOR > > > > False > > > > IMAGES\_CONFIG > > > > {'dest\_dir': '/var/www/singularity-media/images/store', > > 'url\_prefix': 'images/store'} > > > > LANGUAGE\_CODE > > > > 'en-us' > > > > ROOT\_URLCONF > > > > 'urls' > > > > MANAGERS > > > > (('Blake Eggleston', 'bdegg...@gmail.com \'), > > ('Blake Eggleston', 'b...@concordlighting.com \')) > > > > SESSION\_EXPIRE\_AT\_BROWSER\_CLOSE > > > > False > > > > DEFAULT\_CHARSET > > > > 'utf-8' > > > > STATIC\_ROOT > > > > '' > > > > TEST\_DATABASE\_CHARSET > > > > None > > > > USING\_WSGI > > > > True > > > > MESSAGE\_STORAGE > > > > 'django.contrib.messages.storage.user\_messages.LegacyFallbackStorage' > > > > DATABASE\_HOST > > > > '' > > > > EMAIL\_SUBJECT\_PREFIX > > > > '[Django] ' > > > > SEND\_BROKEN\_LINK\_EMAILS > > > > False > > > > URL\_VALIDATOR\_USER\_AGENT > > > > 'Django/1.3.1 ([http://www.djangoproject.com](http://www.djangoproject.com))' > > > > STATICFILES\_FINDERS > > > > ('django.contrib.staticfiles.finders.FileSystemFinder', > > 'django.contrib.staticfiles.finders.AppDirectoriesFinder') > > > > SESSION\_COOKIE\_DOMAIN > > > > None > > > > SESSION\_COOKIE\_NAME > > > > 'sessionid' > > > > CSRF\_COOKIE\_NAME > > > > 'csrftoken' > > > > ADMIN\_FOR > > > > () > > > > TIME\_INPUT\_FORMATS > > > > ('%H:%M:%S', '%H:%M') > > > > DATABASES > > > > {'default': {'ENGINE': 'django.db.backends.mysql', > > 'HOST': '[aqldb.clapuphfn4dw.us-west-1.rds.amazonaws.com](http://aqldb.clapuphfn4dw.us-west-1.rds.amazonaws.com)', > > 'NAME': 'singularity', > > 'OPTIONS': {}, > > 'PASSWORD': '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*', > > 'PORT': '', > > 'TEST\_CHARSET': None, > > 'TEST\_COLLATION': None, > > 'TEST\_MIRROR': None, > > 'TEST\_NAME': None, > > 'TIME\_ZONE': 'America/Los\_Angeles', > > 'USER': 'singularity'}} > > > > TEST\_DATABASE\_NAME > > > > None > > > > FILE\_UPLOAD\_PERMISSIONS > > > > None > > > > FILE\_UPLOAD\_HANDLERS > > > > ('django.core.files.uploadhandler.MemoryFileUploadHandler', > > 'django.core.files.uploadhandler.TemporaryFileUploadHandler') > > > > DEFAULT\_CONTENT\_TYPE > > > > 'text/html' > > > > TEST\_RUNNER > > > > 'store.testing.runners.TestRunner' > > > > AUTHNET\_DEBUG > > > > False > > > > FIRST\_DAY\_OF\_WEEK > > > > 0 > > > > DATABASE\_ROUTERS > > > > SEND\_EMAILS > > > > True > > > > YEAR\_MONTH\_FORMAT > > > > 'F Y' > > > > CONTENT\_PERMS > > > > 508 > > > > CACHES > > > > {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache', > > 'LOCATION': ''}} > > > > ACCOUNT\_CONTENT\_BASE\_PATH > > > > '/var/www/singularity-media/images/store/account\_src' > > > > PAYPAL\_DEBUG > > > > False > > > > SESSION\_COOKIE\_PATH > > > > '/' > > > > USE\_X\_FORWARDED\_HOST > > > > False > > > > CONTENT\_BASE\_PATH > > > > '/var/www/singularity-media/images/store/content' > > > > AUTHNET\_ENABLED > > > > True > > > > IGNORABLE\_404\_ENDS > > > > ('mail.pl', 'mailform.pl', 'mail.cgi', 'mailform.cgi', 'favicon.ico', '.php') > > > > ENCRYPTION\_CONFIG > > > > {'cc\_staging\_key': '54c376a2210b8ca994e88758c9a31871', > > 'cc\_storage\_key': 'ea284f3c20a9d2c944a6bcb4f7b774d9'} > > > > MIDDLEWARE\_CLASSES > > > > ('store.metrics.middleware.MetricsMiddleware', > > 'store.middleware.WorkQueue', > > 'store.middleware.RedirectMiddleware', > > 'django.middleware.common.CommonMiddleware', > > 'django.contrib.sessions.middleware.SessionMiddleware', > > 'django.middleware.csrf.CsrfViewMiddleware', > > 'django.contrib.auth.middleware.AuthenticationMiddleware', > > 'django.contrib.messages.middleware.MessageMiddleware', > > 'store.middleware.UrlRenamer', > > 'store.discount.middleware.DiscountUrlAttach', > > 'dynamicpages.DynamicPagesHandler') > > > > USE\_I18N > > > > True > > > > THOUSAND\_SEPARATOR > > > > ',' > > > > SECRET\_KEY > > > > '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*' > > > > LANGUAGE\_COOKIE\_NAME > > > > 'django\_language' > > > > DEFAULT\_INDEX\_TABLESPACE > > > > '' > > > > SERVE\_IMAGES > > > > True > > > > CONFIG\_PATH > > > > '/var/www/singularity/data/config' > > > > TRANSACTIONS\_MANAGED > > > > False > > > > LOGGING\_CONFIG > > > > 'django.utils.log.dictConfig' > > > > PAYPAL\_DOMAIN\_NAME > > > > '[aql-lb002-1208657660.us-west-1.elb.amazonaws.com](http://aql-lb002-1208657660.us-west-1.elb.amazonaws.com)' > > > > APPEND\_SLASH > > > > True > > > > TEMPLATE\_LOADERS > > > > ('django.template.loaders.filesystem.Loader', > > 'django.template.loaders.app\_directories.Loader') > > > > ACCOUNT\_IMAGE\_FORMATS > > > > {'formats': [{'description': 'the fullsize account image', > > 'max\_x': 80, > > 'max\_y': 80, > > 'name': 'account\_full'}, > > {'description': 'images shown in the sub comments', > > 'max\_x': 40, > > 'max\_y': 40, > > 'name': 'account\_small'}], > > 'src\_dir': '/var/www/singularity-media/images/store/account\_src'} > > > > TEMPLATE\_DEBUG > > > > False > > > > CONTENT\_BASE\_URL > > > > '/images/store/content' > > > > TEST\_DATABASE\_COLLATION > > > > None > > > > FORCE\_SCRIPT\_NAME > > > > None > > > > CACHE\_BACKEND > > > > 'locmem://' > > > > SESSION\_COOKIE\_SECURE > > > > False > > > > TEST\_EXCLUDE... > > Show original[https://groups.google.com/group/elasticsearch/msg/3bdcdfd29278d32f?dmode=source&output=gplain&noredirect](https://groups.google.com/group/elasticsearch/msg/3bdcdfd29278d32f?dmode=source&output=gplain&noredirect) -- ---
**Author:** ![muzakcube64](https://avatars.discourse-cdn.com/v4/letter/m/a183cd/32.png) [@muzakcube64](https://discuss.elastic.co/u/muzakcube64)\ **Post date:** [January 3, 2013, 5:19pm UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/4 "2013-01-03T17:19:42Z")
I appreciate the fast response! I ran the command and this was the output: "cluster\_name" : "elasticsearch", "status" : "red", "timed\_out" : false, "number\_of\_nodes" : 1, "number\_of\_data\_nodes" : 1, "active\_primary\_shards" : 0, "active\_shards" : 0, "relocating\_shards" : 0, "initializing\_shards" : 0, "unassigned\_shards" : 20 -- ---
**Author:** ![Ivan](https://avatars.discourse-cdn.com/v4/letter/i/df788c/32.png) [@Ivan](https://discuss.elastic.co/u/Ivan)\ **Post date:** [January 3, 2013, 5:21pm UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/5 "2013-01-03T17:21:59Z")
Do you have only 1 node in the cluster? Is the underlying filesystem where the index is stored still intact? Can you show the output of [http://localhost:9200/product/\_status](http://localhost:9200/product/_status) ? Replace localhost with the IP of your elasticsearch instance. -- Ivan On Thu, Jan 3, 2013 at 8:21 AM, [muzakcube64@yahoo.com](mailto:muzakcube64@yahoo.com) wrote: > I appreciate the fast response! I ran the command and this was the output: > > "cluster\_name" : "elasticsearch", > "status" : "red", > "timed\_out" : false, > "number\_of\_nodes" : 1, > "number\_of\_data\_nodes" : 1, > "active\_primary\_shards" : 0, > "active\_shards" : 0, > "relocating\_shards" : 0, > "initializing\_shards" : 0, > "unassigned\_shards" : 20 > > How do I get the status out of the red? I would hazard a guess that I > have to allocate the shards but again I'm a moron with this type of thing > and have no idea on where to start. -- ---
**Author:** ![muzakcube64](https://avatars.discourse-cdn.com/v4/letter/m/a183cd/32.png) [@muzakcube64](https://discuss.elastic.co/u/muzakcube64)\ **Post date:** [January 3, 2013, 5:30pm UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/6 "2013-01-03T17:30:53Z")
root@ip-10-160-231-18:/etc# curl -XPUT localhost:9200/products {"ok":true,"acknowledged":true} unless I'm using the wrong command (which is a distinct possibility) On Thursday, January 3, 2013 9:21:59 AM UTC-8, Ivan Brusic wrote: > Do you have only 1 node in the cluster? Is the underlying filesystem where > the index is stored still intact? > > Can you show the output of [http://localhost:9200/product/\_status](http://localhost:9200/product/_status) ? > Replace localhost with the IP of your elasticsearch instance. > > -- > Ivan -- ---
**Author:** ![Ivan](https://avatars.discourse-cdn.com/v4/letter/i/df788c/32.png) [@Ivan](https://discuss.elastic.co/u/Ivan)\ **Post date:** [January 3, 2013, 5:49pm UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/7 "2013-01-03T17:49:19Z")
That command is to create a new index. Try this instead: curl [http://localhost:9200/product/\*\*\_status](http://localhost:9200/product/**_status)[http://localhost:9200/product/\_status](http://localhost:9200/product/_status) Do you know what version of ES you are running? If you don't, try: curl [http://localhost:9200/](http://localhost:9200/) [http://localhost:9200/product/\_status](http://localhost:9200/product/_status) On Thu, Jan 3, 2013 at 9:30 AM, [muzakcube64@yahoo.com](mailto:muzakcube64@yahoo.com) wrote: > root@ip-10-160-231-18:/etc# curl -XPUT localhost:9200/products > > {"ok":true,"acknowledged":true} > > unless I'm using the wrong command (which is a distinct possibility) > > On Thursday, January 3, 2013 9:21:59 AM UTC-8, Ivan Brusic wrote: > > > Do you have only 1 node in the cluster? Is the underlying filesystem > > where the index is stored still intact? > > > > Can you show the output of [http://localhost:9200/product/\*\*\_status](http://localhost:9200/product/**_status)[http://localhost:9200/product/\_status](http://localhost:9200/product/_status)? Replace localhost with the IP of your elasticsearch instance. > > > > -- > > Ivan > > > > -- -- ---
**Author:** ![Igor\_Motov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/igor_motov/32/45193_2.png) [@Igor\_Motov](https://discuss.elastic.co/u/Igor_Motov)\ **Post date:** [January 3, 2013, 5:54pm UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/8 "2013-01-03T17:54:46Z")
That command successfully creates a new index. It should have failed if index existed. But it seems that you are running it on another server. At least log file that you posted on stackoverflow contains different ip address. Could you find logging.yml file in your elasticsearch installation, uncomment the following lines: # gateway gateway: DEBUG index.gateway: DEBUG # peer shard recovery indices.recovery: DEBUG restart elasticsearch service and post the new log file here? On Thursday, January 3, 2013 12:30:53 PM UTC-5, [muzak...@yahoo.com](mailto:muzak...@yahoo.com) wrote: > root@ip-10-160-231-18:/etc# curl -XPUT localhost:9200/products > > {"ok":true,"acknowledged":true} > > unless I'm using the wrong command (which is a distinct possibility) > > On Thursday, January 3, 2013 9:21:59 AM UTC-8, Ivan Brusic wrote: > > > Do you have only 1 node in the cluster? Is the underlying filesystem > > where the index is stored still intact? > > > > Can you show the output of [http://localhost:9200/product/\_status](http://localhost:9200/product/_status) ? > > Replace localhost with the IP of your elasticsearch instance. > > > > -- > > Ivan -- ---
**Author:** ![Ivan](https://avatars.discourse-cdn.com/v4/letter/i/df788c/32.png) [@Ivan](https://discuss.elastic.co/u/Ivan)\ **Post date:** [January 3, 2013, 6:00pm UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/9 "2013-01-03T18:00:14Z")
The index names are different: product and products. On Thu, Jan 3, 2013 at 9:54 AM, Igor Motov [imotov@gmail.com](mailto:imotov@gmail.com) wrote: > That command successfully creates a new index. It should have failed if > index existed. But it seems that you are running it on another server. At > least log file that you posted on stackoverflow contains different ip > address. > > Could you find logging.yml file in your elasticsearch installation, > uncomment the following lines: > > # gateway > > gateway: DEBUG > index.gateway: DEBUG > > # peer shard recovery > > indices.recovery: DEBUG > > restart elasticsearch service and post the new log file here? > > On Thursday, January 3, 2013 12:30:53 PM UTC-5, [muzak...@yahoo.com](mailto:muzak...@yahoo.com) wrote: > > > root@ip-10-160-231-18:/etc# curl -XPUT localhost:9200/products > > > > {"ok":true,"acknowledged":\*\*true} > > > > unless I'm using the wrong command (which is a distinct possibility) > > > > On Thursday, January 3, 2013 9:21:59 AM UTC-8, Ivan Brusic wrote: > > > > > Do you have only 1 node in the cluster? Is the underlying filesystem > > > where the index is stored still intact? > > > > > > Can you show the output of [http://localhost:9200/product/\*\*\_status](http://localhost:9200/product/**_status)[http://localhost:9200/product/\_status](http://localhost:9200/product/_status)? Replace localhost with the IP of your elasticsearch instance. > > > > > > -- > > > Ivan > > > > > > -- -- ---
**Author:** ![Igor\_Motov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/igor_motov/32/45193_2.png) [@Igor\_Motov](https://discuss.elastic.co/u/Igor_Motov)\ **Post date:** [January 3, 2013, 6:03pm UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/10 "2013-01-03T18:03:34Z")
Good catch! On Thursday, January 3, 2013 1:00:14 PM UTC-5, Ivan Brusic wrote: > The index names are different: product and products. > > On Thu, Jan 3, 2013 at 9:54 AM, Igor Motov \<[imo...@gmail.com](mailto:imo...@gmail.com) \ > > > wrote: > > > That command successfully creates a new index. It should have failed if > > index existed. But it seems that you are running it on another server. At > > least log file that you posted on stackoverflow contains different ip > > address. > > > > Could you find logging.yml file in your elasticsearch installation, > > uncomment the following lines: > > > > # gateway > > > > gateway: DEBUG > > index.gateway: DEBUG > > > > # peer shard recovery > > > > indices.recovery: DEBUG > > > > restart elasticsearch service and post the new log file here? > > > > On Thursday, January 3, 2013 12:30:53 PM UTC-5, [muzak...@yahoo.com](mailto:muzak...@yahoo.com) wrote: > > > > > root@ip-10-160-231-18:/etc# curl -XPUT localhost:9200/products > > > > > > {"ok":true,"acknowledged":\*\*true} > > > > > > unless I'm using the wrong command (which is a distinct possibility) > > > > > > On Thursday, January 3, 2013 9:21:59 AM UTC-8, Ivan Brusic wrote: > > > > > > > Do you have only 1 node in the cluster? Is the underlying filesystem > > > > where the index is stored still intact? > > > > > > > > Can you show the output of [http://localhost:9200/product/\*\*\_status](http://localhost:9200/product/**_status)[http://localhost:9200/product/\_status](http://localhost:9200/product/_status)? Replace localhost with the IP of your elasticsearch instance. > > > > > > > > -- > > > > Ivan > > > > > > > > -- -- ---
**Author:** ![muzakcube64](https://avatars.discourse-cdn.com/v4/letter/m/a183cd/32.png) [@muzakcube64](https://discuss.elastic.co/u/muzakcube64)\ **Post date:** [January 3, 2013, 6:55pm UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/11 "2013-01-03T18:55:59Z")
curl [http://localhost:9200/product/\_status](http://localhost:9200/product/_status) outputs: {"ok":true,"\_shards":{"total":10,"successful":0,"failed":0},"indices":{}} the version of ES is 0.19.1 On Thursday, January 3, 2013 9:49:19 AM UTC-8, Ivan Brusic wrote: > That command is to create a new index. Try this instead: curl > [http://localhost:9200/product/\*\*\_status](http://localhost:9200/product/**_status)[http://localhost:9200/product/\_status](http://localhost:9200/product/_status) > > Do you know what version of ES you are running? If you don't, try: curl > [http://localhost:9200/](http://localhost:9200/) [http://localhost:9200/product/\_status](http://localhost:9200/product/_status) > > On Thu, Jan 3, 2013 at 9:30 AM, \<[muzak...@yahoo.com](mailto:muzak...@yahoo.com) \\> wrote: > > > root@ip-10-160-231-18:/etc# curl -XPUT localhost:9200/products > > > > {"ok":true,"acknowledged":true} > > > > unless I'm using the wrong command (which is a distinct possibility) > > > > On Thursday, January 3, 2013 9:21:59 AM UTC-8, Ivan Brusic wrote: > > > > > Do you have only 1 node in the cluster? Is the underlying filesystem > > > where the index is stored still intact? > > > > > > Can you show the output of [http://localhost:9200/product/\*\*\_status](http://localhost:9200/product/**_status)[http://localhost:9200/product/\_status](http://localhost:9200/product/_status)? Replace localhost with the IP of your elasticsearch instance. > > > > > > -- > > > Ivan > > > > > > -- -- ---
**Author:** ![muzakcube64](https://avatars.discourse-cdn.com/v4/letter/m/a183cd/32.png) [@muzakcube64](https://discuss.elastic.co/u/muzakcube64)\ **Post date:** [January 3, 2013, 7:04pm UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/12 "2013-01-03T19:04:12Z")
this is the new log (remaned to elasticsearch2.log for my own sanity) [http://www.filedropper.com/elasticsearch2](http://www.filedropper.com/elasticsearch2) On Thursday, January 3, 2013 9:54:46 AM UTC-8, Igor Motov wrote: > That command successfully creates a new index. It should have failed if > index existed. But it seems that you are running it on another server. At > least log file that you posted on stackoverflow contains different ip > address. > > Could you find logging.yml file in your elasticsearch installation, > uncomment the following lines: > > # gateway > > gateway: DEBUG > index.gateway: DEBUG > > # peer shard recovery > > indices.recovery: DEBUG > > restart elasticsearch service and post the new log file here? > > On Thursday, January 3, 2013 12:30:53 PM UTC-5, [muzak...@yahoo.com](mailto:muzak...@yahoo.com) wrote: > > > root@ip-10-160-231-18:/etc# curl -XPUT localhost:9200/products > > > > {"ok":true,"acknowledged":true} > > > > unless I'm using the wrong command (which is a distinct possibility) > > > > On Thursday, January 3, 2013 9:21:59 AM UTC-8, Ivan Brusic wrote: > > > > > Do you have only 1 node in the cluster? Is the underlying filesystem > > > where the index is stored still intact? > > > > > > Can you show the output of [http://localhost:9200/product/\_status](http://localhost:9200/product/_status) ? > > > Replace localhost with the IP of your elasticsearch instance. > > > > > > -- > > > Ivan -- ---
**Author:** ![Igor\_Motov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/igor_motov/32/45193_2.png) [@Igor\_Motov](https://discuss.elastic.co/u/Igor_Motov)\ **Post date:** [January 3, 2013, 7:40pm UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/13 "2013-01-03T19:40:16Z")
I don't see any difference. Could you just paste it as a gist ([https://gist.github.com/](https://gist.github.com/))? It doesn't look that big. On Thursday, January 3, 2013 2:04:12 PM UTC-5, [muzak...@yahoo.com](mailto:muzak...@yahoo.com) wrote: > this is the new log (remaned to elasticsearch2.log for my own sanity) > [http://www.filedropper.com/elasticsearch2](http://www.filedropper.com/elasticsearch2) > > On Thursday, January 3, 2013 9:54:46 AM UTC-8, Igor Motov wrote: > > > That command successfully creates a new index. It should have failed if > > index existed. But it seems that you are running it on another server. At > > least log file that you posted on stackoverflow contains different ip > > address. > > > > Could you find logging.yml file in your elasticsearch installation, > > uncomment the following lines: > > > > # gateway > > > > gateway: DEBUG > > index.gateway: DEBUG > > > > # peer shard recovery > > > > indices.recovery: DEBUG > > > > restart elasticsearch service and post the new log file here? > > > > On Thursday, January 3, 2013 12:30:53 PM UTC-5, [muzak...@yahoo.com](mailto:muzak...@yahoo.com) wrote: > > > > > root@ip-10-160-231-18:/etc# curl -XPUT localhost:9200/products > > > > > > {"ok":true,"acknowledged":true} > > > > > > unless I'm using the wrong command (which is a distinct possibility) > > > > > > On Thursday, January 3, 2013 9:21:59 AM UTC-8, Ivan Brusic wrote: > > > > > > > Do you have only 1 node in the cluster? Is the underlying filesystem > > > > where the index is stored still intact? > > > > > > > > Can you show the output of [http://localhost:9200/product/\_status](http://localhost:9200/product/_status) ? > > > > Replace localhost with the IP of your elasticsearch instance. > > > > > > > > -- > > > > Ivan -- ---
**Author:** ![muzakcube64](https://avatars.discourse-cdn.com/v4/letter/m/a183cd/32.png) [@muzakcube64](https://discuss.elastic.co/u/muzakcube64)\ **Post date:** [January 3, 2013, 8:16pm UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/14 "2013-01-03T20:16:11Z")
> if the formatting is wrong or if I did something wrong, let me know On Thursday, January 3, 2013 11:40:16 AM UTC-8, Igor Motov wrote: > I don't see any difference. Could you just paste it as a gist ( > [https://gist.github.com/](https://gist.github.com/))? It doesn't look that big. > > On Thursday, January 3, 2013 2:04:12 PM UTC-5, [muzak...@yahoo.com](mailto:muzak...@yahoo.com) wrote: > > > this is the new log (remaned to elasticsearch2.log for my own sanity) > > [http://www.filedropper.com/elasticsearch2](http://www.filedropper.com/elasticsearch2) > > > > On Thursday, January 3, 2013 9:54:46 AM UTC-8, Igor Motov wrote: > > > > > That command successfully creates a new index. It should have failed if > > > index existed. But it seems that you are running it on another server. At > > > least log file that you posted on stackoverflow contains different ip > > > address. > > > > > > Could you find logging.yml file in your elasticsearch installation, > > > uncomment the following lines: > > > > > > # gateway > > > > > > gateway: DEBUG > > > index.gateway: DEBUG > > > > > > # peer shard recovery > > > > > > indices.recovery: DEBUG > > > > > > restart elasticsearch service and post the new log file here? > > > > > > On Thursday, January 3, 2013 12:30:53 PM UTC-5, muzak...@yahoo.comwrote: > > > > > > > root@ip-10-160-231-18:/etc# curl -XPUT localhost:9200/products > > > > > > > > {"ok":true,"acknowledged":true} > > > > > > > > unless I'm using the wrong command (which is a distinct possibility) > > > > > > > > On Thursday, January 3, 2013 9:21:59 AM UTC-8, Ivan Brusic wrote: > > > > > > > > > Do you have only 1 node in the cluster? Is the underlying filesystem > > > > > where the index is stored still intact? > > > > > > > > > > Can you show the output of [http://localhost:9200/product/\_status](http://localhost:9200/product/_status) ? > > > > > Replace localhost with the IP of your elasticsearch instance. > > > > > > > > > > -- > > > > > Ivan -- ---
**Author:** ![Ivan](https://avatars.discourse-cdn.com/v4/letter/i/df788c/32.png) [@Ivan](https://discuss.elastic.co/u/Ivan)\ **Post date:** [January 3, 2013, 8:39pm UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/15 "2013-01-03T20:39:25Z")
BTW, you probably want to delete that new index you created. It uses the default settings of 1 replica, and since you do not have more than 1 node, the cluster will be in a red state. curl -XDELETE '[http://localhost:9200/products/](http://localhost:9200/products/)' It also appears that you have two other indices, one being product. Is the other index correct? Can you gist the output of curl [http://192.168.52.155:9200/\_cluster/state](http://192.168.52.155:9200/_cluster/state) For those that really know the internals, the error message has [_na_][product][0], which means the nodeId is null. Is that an issue? -- Ivan On Thu, Jan 3, 2013 at 9:49 AM, Ivan Brusic [ivan@brusic.com](mailto:ivan@brusic.com) wrote: > That command is to create a new index. Try this instead: curl > [http://localhost:9200/product/\*\*\_status](http://localhost:9200/product/**_status)[http://localhost:9200/product/\_status](http://localhost:9200/product/_status) > > Do you know what version of ES you are running? If you don't, try: curl > [http://localhost:9200/](http://localhost:9200/) [http://localhost:9200/product/\_status](http://localhost:9200/product/_status) > > On Thu, Jan 3, 2013 at 9:30 AM, [muzakcube64@yahoo.com](mailto:muzakcube64@yahoo.com) wrote: > > > root@ip-10-160-231-18:/etc# curl -XPUT localhost:9200/products > > > > {"ok":true,"acknowledged":true} > > > > unless I'm using the wrong command (which is a distinct possibility) > > > > On Thursday, January 3, 2013 9:21:59 AM UTC-8, Ivan Brusic wrote: > > > > > Do you have only 1 node in the cluster? Is the underlying filesystem > > > where the index is stored still intact? > > > > > > Can you show the output of [http://localhost:9200/product/\*\*\_status](http://localhost:9200/product/**_status)[http://localhost:9200/product/\_status](http://localhost:9200/product/_status)? Replace localhost with the IP of your elasticsearch instance. > > > > > > -- > > > Ivan > > > > > > -- -- ---
**Author:** ![Rafal\_Kuc\_3](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rafal_kuc_3/32/799_2.png) [@Rafal\_Kuc\_3](https://discuss.elastic.co/u/Rafal_Kuc_3)\ **Post date:** [January 3, 2013, 10:42pm UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/16 "2013-01-03T22:42:42Z")
Hello! Ivan I think that the cluster will be in yellow state, not red (of course when talking about healthy deployment). Red would mean that primary shards can't be allocated, yellow that replicas can't be. _--_ Regards, Rafał Kuć Sematext :: [http://sematext.com/](http://sematext.com/) _:: Solr - Lucene - Nutch - ElasticSearch_ BTW, you probably want to delete that new index you created. It uses the default settings of 1 replica, and since you do not have more than 1 node, the cluster will be in a red state. curl -XDELETE '[http://localhost:9200/products/](http://localhost:9200/products/)' It also appears that you have two other indices, one being product. Is the other index correct? Can you gist the output of curl [http://192.168.52.155:9200/\_cluster/state](http://192.168.52.155:9200/_cluster/state) For those that really know the internals, the error message has [_na_][product][0], which means the nodeId is null. Is that an issue? -- Ivan On Thu, Jan 3, 2013 at 9:49 AM, Ivan Brusic \<[ivan@brusic.com](mailto:ivan@brusic.com)\> wrote: That command is to create a new index. Try this instead: curl [http://localhost:9200/product/](http://localhost:9200/product/_status)[\_status](http://localhost:9200/product/_status) Do you know what version of ES you are running? If you don't, try: curl [http://localhost:9200/](http://localhost:9200/product/_status) On Thu, Jan 3, 2013 at 9:30 AM, \<[muzakcube64@yahoo.com](mailto:muzakcube64@yahoo.com)\> wrote: root@ip-10-160-231-18:/etc# curl -XPUT localhost:9200/products {"ok":true,"acknowledged":true} unless I'm using the wrong command (which is a distinct possibility) On Thursday, January 3, 2013 9:21:59 AM UTC-8, Ivan Brusic wrote: Do you have only 1 node in the cluster? Is the underlying filesystem where the index is stored still intact? Can you show the output of [http://localhost:9200/product/](http://localhost:9200/product/_status)[\_status](http://localhost:9200/product/_status) ? Replace localhost with the IP of your elasticsearch instance. -- Ivan -- -- ---
**Author:** ![Igor\_Motov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/igor_motov/32/45193_2.png) [@Igor\_Motov](https://discuss.elastic.co/u/Igor_Motov)\ **Post date:** [January 3, 2013, 11:06pm UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/17 "2013-01-03T23:06:04Z")
Are you sure you applied changes to right logging.yml and they were applied correctly? It doesn't look like the had any effect. On Thursday, January 3, 2013 3:16:11 PM UTC-5, [muzak...@yahoo.com](mailto:muzak...@yahoo.com) wrote: > [ElasticSearch.log · GitHub](https://gist.github.com/4446755) > if the formatting is wrong or if I did something wrong, let me know > > On Thursday, January 3, 2013 11:40:16 AM UTC-8, Igor Motov wrote: > > > I don't see any difference. Could you just paste it as a gist ( > > [https://gist.github.com/](https://gist.github.com/))? It doesn't look that big. > > > > On Thursday, January 3, 2013 2:04:12 PM UTC-5, [muzak...@yahoo.com](mailto:muzak...@yahoo.com) wrote: > > > > > this is the new log (remaned to elasticsearch2.log for my own sanity) > > > [http://www.filedropper.com/elasticsearch2](http://www.filedropper.com/elasticsearch2) > > > > > > On Thursday, January 3, 2013 9:54:46 AM UTC-8, Igor Motov wrote: > > > > > > > That command successfully creates a new index. It should have failed if > > > > index existed. But it seems that you are running it on another server. At > > > > least log file that you posted on stackoverflow contains different ip > > > > address. > > > > > > > > Could you find logging.yml file in your elasticsearch installation, > > > > uncomment the following lines: > > > > > > > > # gateway > > > > > > > > gateway: DEBUG > > > > index.gateway: DEBUG > > > > > > > > # peer shard recovery > > > > > > > > indices.recovery: DEBUG > > > > > > > > restart elasticsearch service and post the new log file here? > > > > > > > > On Thursday, January 3, 2013 12:30:53 PM UTC-5, muzak...@yahoo.comwrote: > > > > > > > > > root@ip-10-160-231-18:/etc# curl -XPUT localhost:9200/products > > > > > > > > > > {"ok":true,"acknowledged":true} > > > > > > > > > > unless I'm using the wrong command (which is a distinct possibility) > > > > > > > > > > On Thursday, January 3, 2013 9:21:59 AM UTC-8, Ivan Brusic wrote: > > > > > > > > > > > Do you have only 1 node in the cluster? Is the underlying filesystem > > > > > > where the index is stored still intact? > > > > > > > > > > > > Can you show the output of [http://localhost:9200/product/\_status](http://localhost:9200/product/_status) ? > > > > > > Replace localhost with the IP of your elasticsearch instance. > > > > > > > > > > > > -- > > > > > > Ivan -- ---
**Author:** ![Patra\_Nutan](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Patra\_Nutan](https://discuss.elastic.co/u/Patra_Nutan)\ **Post date:** [February 18, 2013, 4:01pm UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/18 "2013-02-18T16:01:53Z")
Hello Team, Greetings!!! I am also too naive to elasticsearch,graylog2-web-interface,graylog2-server. I am facing an issue where suddenly _graylog has stopped posting log messages to graylog2-web-interface_. I thought it caused due to elasticsearch which shows the below error:- curl [http://localhost:9200/graylog2/message/\_search?q=\_source.streams=50937c0173b5b56c9a000005&sort=\_score](http://localhost:9200/graylog2/message/_search?q=_source.streams=50937c0173b5b56c9a000005&sort=_score) [1] 18723 [root@index]# {"error":"SearchPhaseExecutionException[Failed to execute phase [query], total failure; shardFailures {[_na_][graylog2][0]: No active shards}{[_na_][graylog2][1]: No active shards}{[_na_][graylog2][2]: No active shards}{[_na_][graylog2][3]: No active shards}{[_na_][graylog2][4]: No active shards}]","status":500} Please guide on the same. Regards, Patra N _Messages_ Your Graylog2 version (0.9.6) is outdated. Get the current package from [http://www.graylog2.org/](http://www.graylog2.org/). \*Currently containing 0 messages. Stored 183 messages in the last 2 minutes. \* On Friday, January 4, 2013 4:36:04 AM UTC+5:30, Igor Motov wrote: > Are you sure you applied changes to right logging.yml and they were > applied correctly? It doesn't look like the had any effect. > > On Thursday, January 3, 2013 3:16:11 PM UTC-5, [muzak...@yahoo.com](mailto:muzak...@yahoo.com) wrote: > > > [ElasticSearch.log · GitHub](https://gist.github.com/4446755) > > if the formatting is wrong or if I did something wrong, let me know > > > > On Thursday, January 3, 2013 11:40:16 AM UTC-8, Igor Motov wrote: > > > > > I don't see any difference. Could you just paste it as a gist ( > > > [https://gist.github.com/](https://gist.github.com/))? It doesn't look that big. > > > > > > On Thursday, January 3, 2013 2:04:12 PM UTC-5, [muzak...@yahoo.com](mailto:muzak...@yahoo.com) wrote: > > > > > > > this is the new log (remaned to elasticsearch2.log for my own sanity) > > > > [http://www.filedropper.com/elasticsearch2](http://www.filedropper.com/elasticsearch2) > > > > > > > > On Thursday, January 3, 2013 9:54:46 AM UTC-8, Igor Motov wrote: > > > > > > > > > That command successfully creates a new index. It should have failed > > > > > if index existed. But it seems that you are running it on another server. > > > > > At least log file that you posted on stackoverflow contains different ip > > > > > address. > > > > > > > > > > Could you find logging.yml file in your elasticsearch installation, > > > > > uncomment the following lines: > > > > > > > > > > # gateway > > > > > > > > > > gateway: DEBUG > > > > > index.gateway: DEBUG > > > > > > > > > > # peer shard recovery > > > > > > > > > > indices.recovery: DEBUG > > > > > > > > > > restart elasticsearch service and post the new log file here? > > > > > > > > > > On Thursday, January 3, 2013 12:30:53 PM UTC-5, muzak...@yahoo.comwrote: > > > > > > > > > > > root@ip-10-160-231-18:/etc# curl -XPUT localhost:9200/products > > > > > > > > > > > > {"ok":true,"acknowledged":true} > > > > > > > > > > > > unless I'm using the wrong command (which is a distinct possibility) > > > > > > > > > > > > On Thursday, January 3, 2013 9:21:59 AM UTC-8, Ivan Brusic wrote: > > > > > > > > > > > > > Do you have only 1 node in the cluster? Is the underlying filesystem > > > > > > > where the index is stored still intact? > > > > > > > > > > > > > > Can you show the output of [http://localhost:9200/product/\_status](http://localhost:9200/product/_status) ? > > > > > > > Replace localhost with the IP of your elasticsearch instance. > > > > > > > > > > > > > > -- > > > > > > > Ivan -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![Patra\_Nutan](https://avatars.discourse-cdn.com/v4/letter/p/e68b1a/32.png) [@Patra\_Nutan](https://discuss.elastic.co/u/Patra_Nutan)\ **Post date:** [February 19, 2013, 10:50am UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/19 "2013-02-19T10:50:10Z")
Hello Team, These are some more info:- [root@config]# _curl localhost:9200/graylog2/\_status ?_ {"ok":true, "\_shards":{"total":10,"successful":4,"failed":0},"indices":{"graylog2":{"index":{"primary\_size":"9.8gb","primary\_size\_in\_bytes":10594702144,"size":"9.8gb","size\_in\_bytes":10594702144},"merges":{"current":0,"current\_docs":0,"current\_size":"0b","current\_size\_in\_bytes":0,"total":0,"total\_time":"0s","total\_time\_in\_millis":0,"total\_docs":0,"total\_size":"0b","total\_size\_in\_bytes":0},"refresh":{"total":0,"total\_time":"0s","total\_time\_in\_millis":0},"flush":{"total":0,"total\_time":"0s","total\_time\_in\_millis":0},"shards":{"0":[{"routing":{"state":"INITIALIZING","primary":true,"node":"\_NfoAETRTs2H6KrQNqcLlg","relocating\_node":null,"shard":0,"index":"graylog2"},"state":"RECOVERING","index":{"size":"2.4gb","size\_in\_bytes":2644780398}}],"1":[{"routing":{"state":"INITIALIZING","primary":true,"node":"\_NfoAETRTs2H6KrQNqcLlg","relocating\_node":null,"shard":1,"index":"graylog2"},"state":"RECOVERING","index":{"size":"2.4gb","size\_in\_bytes":2648693851}}],"3":[{"routing":{"state":"INITIALIZING","primary":true,"node":"\_Ncurl: (6) Couldn't resolve host '' foAETRTs2H6KrQNqcLlg","relocating\_node":null,"shard":3,"index":"graylog2"},"state":"RECOVERING","index":{"size":"2.4gb","size\_in\_bytes":2647564709}}],"4":[{"routing":{"state":"INITIALIZING","primary":true,"node":"\_NfoAETRTs2H6KrQNqcLlg","relocating\_node":null,"shard":4,"index":"graylog2"},"state":"RECOVERING","index":{"size":"2.4gb","size\_in\_bytes":2653663186}}]}}}} [root@config]# _curl localhost:9200_ { "ok" : true, "status" : 200, "name" : "Thing", "version" : { "number" : "0.19.3", "snapshot\_build" : false }, "tagline" : "You Know, for Search" [root@elasticsearch]# _curl localhost:9200//\_cluster/health_ { "cluster\_name":"graylog2", "_status":"red_", "timed\_out":false, "number\_of\_nodes":1, "number\_of\_data\_nodes":1, "active\_primary\_shards":15, "active\_shards":15, "relocating\_shards":0, "initializing\_shards":4, "unassigned\_shards":21 } Please reply. Thanks in advance. Regards, Patra N On Thursday, January 3, 2013 2:57:31 PM UTC+5:30, [muzak...@yahoo.com](mailto:muzak...@yahoo.com) wrote: > I'm having issues and I don't know where to turn. Long story short, my > web designer left me high and dry and I have no idea what he did and he > refuses to answer his phone. I have access to the main page but after that, > I'm completely locked out and staring at a SearchPhaseExecutionException > for every single product in my store. Any help would be much appreciated > as I am completely clueless on what to do. Here is the full error log: > > SearchPhaseExecutionException at /category/1 > > Failed to execute phase [query], total failure; shardFailures {[_na_][product][0]: No active shards}{[_na_][product][1]: No active shards}{[_na_][product][2]: No active shards}{[_na_][product][3]: No active shards}{[_na_][product][4]: No active shards} > > Request Method:GETRequest URL: > [http://www.affordablequalitylighting.com/category/1Django](http://www.affordablequalitylighting.com/category/1Django) Version:1.3.1Exception > Type:SearchPhaseExecutionExceptionException Value: > > Failed to execute phase [query], total failure; shardFailures {[_na_][product][0]: No active shards}{[_na_][product][1]: No active shards}{[_na_][product][2]: No active shards}{[_na_][product][3]: No active shards}{[_na_][product][4]: No active shards} > > Exception Location:/usr/local/lib/python2.6/dist-packages/pyes/convert\_errors.py > in raise\_if\_error, line 68Python Executable:/usr/bin/pythonPython Version: > 2.6.5Python Path: > > ['/usr/lib/python2.6', > '/usr/lib/python2.6/plat-linux2', > '/usr/lib/python2.6/lib-tk', > '/usr/lib/python2.6/lib-old', > '/usr/lib/python2.6/lib-dynload', > '/usr/lib/python2.6/dist-packages', > '/usr/lib/python2.6/dist-packages/PIL', > '/usr/lib/pymodules/python2.6', > '/usr/lib/pymodules/python2.6/gtk-2.0', > '/usr/lib/python2.6/dist-packages/wx-2.8-gtk2-unicode', > '/usr/local/lib/python2.6/dist-packages', > '/var/www/singularity/py'] > > Server time:Thu, 3 Jan 2013 01:24:15 -0800 > Traceback Switch to copy-and-paste view[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > - /usr/local/lib/python2.6/dist-packages/django/core/handlers/base.py > in get\_response > > 1. > > ``` > response = callback(request, *callback_args, **callback_kwargs) > > ... > > ``` > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > - /var/www/singularity/py/store/catalog/views.py in category\_view > > 1. > > ``` > filterblock = filtering.filter(category, request, num_results, page_num) > > ... > > ``` > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > - /var/www/singularity/py/store/catalog/filtering.py in filter > > 1. > > ``` > results = sitesearch.raw_search(q, search.product_index) > > ... > > ``` > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > - /var/www/singularity/py/sitesearch/interface.py in raw\_search > > 1. > > ``` > return C.search(data, [_idxname(index_name)]) > > ... > > ``` > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > - /usr/local/lib/python2.6/dist-packages/pyes/es.py in search > > 1. > > ``` > return self._query_call("_search", body, indexes, doc_types, **query_params) > > ... > > ``` > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > - /usr/local/lib/python2.6/dist-packages/pyes/es.py in \_query\_call > > 1. > > ``` > response = self._send_request('GET', path, body, querystring_args) > > ... > > ``` > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > - /usr/local/lib/python2.6/dist-packages/pyes/es.py in \_send\_request > > 1. > > ``` > raise_if_error(response.status, decoded) > > ... > > ``` > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > - /usr/local/lib/python2.6/dist-packages/pyes/convert\_errors.py in > raise\_if\_error > > 1. > > ``` > raise excClass(msg, status, result) > > ... > > ``` > > ▶ Local vars[http://www.affordablequalitylighting.com/outdoor-lighting#](http://www.affordablequalitylighting.com/outdoor-lighting#) > > Request informationGET > > No GET data > POST > > No POST data > FILES > > No FILES data > COOKIESVariableValue\_\_utmz > > '36364016.1355763714.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)' > > \_vis\_opt\_s > > '2%7C' > > \_vis\_opt\_exp\_11\_goal\_3 > > '1' > > sessionid > > '8894e58e6eee1d47f9bdfdb41e9fe7f4' > > \_vis\_opt\_exp\_11\_combi > > '2' > > csrftoken > > '8b335c16f43607ae18f730559c2e0d56' > > \_\_utma > > '36364016.1140701240.1355763714.1355942217.1355945322.4' > > \_vis\_opt\_exp\_10\_combi > > '1' > > METAVariableValuemod\_wsgi.reload\_mechanism > > '1' > > mod\_wsgi.listener\_port > > '80' > > HTTP\_REFERER > > '[http://www.affordablequalitylighting.com/](http://www.affordablequalitylighting.com/)' > > mod\_wsgi.listener\_host > > '' > > SERVER\_SOFTWARE > > 'Apache/2.2.14 (Ubuntu)' > > SCRIPT\_NAME > > u'' > > SERVER\_SIGNATURE > > 'Apache/2.2.14 (Ubuntu) Server at [www.affordablequalitylighting.com](http://www.affordablequalitylighting.com) Port 80\n' > > REQUEST\_METHOD > > 'GET' > > PATH\_INFO > > u'/outdoor-lighting' > > SERVER\_PROTOCOL > > 'HTTP/1.1' > > QUERY\_STRING > > '' > > PATH > > '/usr/local/bin:/usr/bin:/bin' > > HTTP\_ACCEPT\_CHARSET > > 'ISO-8859-1,utf-8;q=0.7,\*;q=0.3' > > HTTP\_USER\_AGENT > > 'Mozilla/5.0 (Windows NT 6.2; WOW64) AppleWebKit/537.11 (KHTML, like Gecko) Chrome/23.0.1271.97 Safari/537.11' > > HTTP\_CONNECTION > > 'keep-alive' > > HTTP\_COOKIE > > '\_vis\_opt\_exp\_10\_combi=1; \_vis\_opt\_s=2%7C; \_vis\_opt\_exp\_11\_combi=2; \_vis\_opt\_exp\_11\_goal\_3=1; \_\_utma=36364016.1140701240.1355763714.1355942217.1355945322.4; \_\_utmz=36364016.1355763714.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none); csrftoken=8b335c16f43607ae18f730559c2e0d56; sessionid=8894e58e6eee1d47f9bdfdb41e9fe7f4' > > SERVER\_NAME > > '[www.affordablequalitylighting.com](http://www.affordablequalitylighting.com)' > > REMOTE\_ADDR > > '10.168.14.143' > > wsgi.url\_scheme > > 'http' > > PATH\_TRANSLATED > > '/var/www/singularity/py/wsgi/singularity.py/outdoor-lighting' > > SERVER\_PORT > > '80' > > wsgi.multiprocess > > False > > SERVER\_ADDR > > '10.160.83.83' > > DOCUMENT\_ROOT > > '/htdocs' > > mod\_wsgi.process\_group > > 'django' > > HTTP\_X\_FORWARDED\_PROTO > > 'http' > > SCRIPT\_FILENAME > > '/var/www/singularity/py/wsgi/singularity.py' > > SERVER\_ADMIN > > '[no address given]' > > SCRIPT\_URI > > '[http://www.affordablequalitylighting.com/outdoor-lighting](http://www.affordablequalitylighting.com/outdoor-lighting)' > > wsgi.input > > \ > > HTTP\_HOST > > '[www.affordablequalitylighting.com](http://www.affordablequalitylighting.com)' > > SCRIPT\_URL > > '/outdoor-lighting' > > wsgi.multithread > > True > > mod\_wsgi.callable\_object > > 'application' > > REQUEST\_URI > > '/outdoor-lighting' > > HTTP\_ACCEPT > > 'text/html,application/xhtml+xml,application/xml;q=0.9,_/_;q=0.8' > > wsgi.version > > (1, 0) > > GATEWAY\_INTERFACE > > 'CGI/1.1' > > HTTP\_X\_FORWARDED\_FOR > > '173.196.151.198' > > wsgi.errors > > \ > > REMOTE\_PORT > > '37237' > > HTTP\_ACCEPT\_LANGUAGE > > 'en-US,en;q=0.8' > > mod\_wsgi.version > > (2, 8) > > wsgi.run\_once > > False > > HTTP\_X\_FORWARDED\_PORT > > '80' > > mod\_wsgi.application\_group > > '' > > mod\_wsgi.script\_reloading > > '1' > > wsgi.file\_wrapper > > '' > > CSRF\_COOKIE > > '8b335c16f43607ae18f730559c2e0d56' > > HTTP\_ACCEPT\_ENCODING > > 'gzip,deflate,sdch' > > SettingsUsing settings module settingsSettingValueGOOGLE\_ANALYTICS\_ID > > 'UA-13030541-1' > > SERVER\_EMAIL > > 'nor...@affordablequalitylighting.com \' > > USE\_L10N > > True > > USE\_THOUSAND\_SEPARATOR > > False > > IMAGES\_CONFIG > > {'dest\_dir': '/var/www/singularity-media/images/store', > 'url\_prefix': 'images/store'} > > LANGUAGE\_CODE > > 'en-us' > > ROOT\_URLCONF > > 'urls' > > MANAGERS > > (('Blake Eggleston', 'bdegg...@gmail.com \'), > ('Blake Eggleston', 'b...@concordlighting.com \')) > > SESSION\_EXPIRE\_AT\_BROWSER\_CLOSE > > False > > DEFAULT\_CHARSET > > 'utf-8' > > STATIC\_ROOT > > '' > > TEST\_DATABASE\_CHARSET > > None > > USING\_WSGI > > True > > MESSAGE\_STORAGE > > 'django.contrib.messages.storage.user\_messages.LegacyFallbackStorage' > > DATABASE\_HOST > > '' > > EMAIL\_SUBJECT\_PREFIX > > '[Django] ' > > SEND\_BROKEN\_LINK\_EMAILS > > False > > URL\_VALIDATOR\_USER\_AGENT > > 'Django/1.3.1 ([http://www.djangoproject.com](http://www.djangoproject.com))' > > STATICFILES\_FINDERS > > ('django.contrib.staticfiles.finders.FileSystemFinder', > 'django.contrib.staticfiles.finders.AppDirectoriesFinder') > > SESSION\_COOKIE\_DOMAIN > > None > > SESSION\_COOKIE\_NAME > > 'sessionid' > > CSRF\_COOKIE\_NAME > > 'csrftoken' > > ADMIN\_FOR > > () > > TIME\_INPUT\_FORMATS > > ('%H:%M:%S', '%H:%M') > > DATABASES > > {'default': {'ENGINE': 'django.db.backends.mysql', > 'HOST': '[aqldb.clapuphfn4dw.us-west-1.rds.amazonaws.com](http://aqldb.clapuphfn4dw.us-west-1.rds.amazonaws.com)', > 'NAME': 'singularity', > 'OPTIONS': {}, > 'PASSWORD': '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*', > 'PORT': '', > 'TEST\_CHARSET': None, > 'TEST\_COLLATION': None, > 'TEST\_MIRROR': None, > 'TEST\_NAME': None, > 'TIME\_ZONE': 'America/Los\_Angeles', > 'USER': 'singularity'}} > > TEST\_DATABASE\_NAME > > None > > FILE\_UPLOAD\_PERMISSIONS > > None > > FILE\_UPLOAD\_HANDLERS > > ('django.core.files.uploadhandler.MemoryFileUploadHandler', > 'django.core.files.uploadhandler.TemporaryFileUploadHandler') > > DEFAULT\_CONTENT\_TYPE > > 'text/html' > > TEST\_RUNNER > > 'store.testing.runners.TestRunner' > > AUTHNET\_DEBUG > > False > > FIRST\_DAY\_OF\_WEEK > > 0 > > DATABASE\_ROUTERS > > SEND\_EMAILS > > True > > YEAR\_MONTH\_FORMAT > > 'F Y' > > CONTENT\_PERMS > > 508 > > CACHES > > {'default': {'BACKEND': 'django.core.cache.backends.locmem.LocMemCache', > 'LOCATION': ''}} > > ACCOUNT\_CONTENT\_BASE\_PATH > > '/var/www/singularity-media/images/store/account\_src' > > PAYPAL\_DEBUG > > False > > SESSION\_COOKIE\_PATH > > '/' > > USE\_X\_FORWARDED\_HOST > > False > > CONTENT\_BASE\_PATH > > '/var/www/singularity-media/images/store/content' > > AUTHNET\_ENABLED > > True > > IGNORABLE\_404\_ENDS > > ('mail.pl', 'mailform.pl', 'mail.cgi', 'mailform.cgi', 'favicon.ico', '.php') > > ENCRYPTION\_CONFIG > > {'cc\_staging\_key': '54c376a2210b8ca994e88758c9a31871', > 'cc\_storage\_key': 'ea284f3c20a9d2c944a6bcb4f7b774d9'} > > MIDDLEWARE\_CLASSES > > ('store.metrics.middleware.MetricsMiddleware', > 'store.middleware.WorkQueue', > 'store.middleware.RedirectMiddleware', > 'django.middleware.common.CommonMiddleware', > 'django.contrib.sessions.middleware.SessionMiddleware', > 'django.middleware.csrf.CsrfViewMiddleware', > 'django.contrib.auth.middleware.AuthenticationMiddleware', > 'django.contrib.messages.middleware.MessageMiddleware', > 'store.middleware.UrlRenamer', > 'store.discount.middleware.DiscountUrlAttach', > 'dynamicpages.DynamicPagesHandler') > > USE\_I18N > > True > > THOUSAND\_SEPARATOR > > ',' > > SECRET\_KEY > > '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*' > > LANGUAGE\_COOKIE\_NAME > > 'django\_language' > > DEFAULT\_INDEX\_TABLESPACE > > '' > > SERVE\_IMAGES > > True > > CONFIG\_PATH > > '/var/www/singularity/data/config' > > TRANSACTIONS\_MANAGED > > False > > LOGGING\_CONFIG > > 'django.utils.log.dictConfig' > > PAYPAL\_DOMAIN\_NAME > > '[aql-lb002-1208657660.us-west-1.elb.amazonaws.com](http://aql-lb002-1208657660.us-west-1.elb.amazonaws.com)' > > APPEND\_SLASH > > True > > TEMPLATE\_LOADERS > > ('django.template.loaders.filesystem.Loader', > 'django.template.loaders.app\_directories.Loader') > > ACCOUNT\_IMAGE\_FORMATS > > {'formats': [{'description': 'the fullsize account image', > 'max\_x': 80, > 'max\_y': 80, > 'name': 'account\_full'}, > {'description': 'images shown in the sub comments', > 'max\_x': 40, > 'max\_y': 40, > 'name': 'account\_small'}], > 'src\_dir': '/var/www/singularity-media/images/store/account\_src'} > > TEMPLATE\_DEBUG > > False > > CONTENT\_BASE\_URL > > '/images/store/content' > > TEST\_DATABASE\_COLLATION > > None > > FORCE\_SCRIPT\_NAME > > None > > CACHE\_BACKEND > > 'locmem://' > > SESSION\_COOKIE\_SECURE > > False > > TEST\_EXCLUDE > > ('django', 'authorizenet', 'paypal') > > COMPILE\_TEMPLATES > > True > > LOCAL\_PATH > > '/var/www/singularity' > > CSRF\_COOKIE\_DOMAIN > > None > > FILE\_CHARSET > > 'utf-8' > > DEBUG > > False > > SESSION\_FILE\_PATH > > None > > DEFAULT\_FILE\_STORAGE > > 'django.core.files.storage.FileSystemStorage' > > INSTALLED\_APPS > > ['django.contrib.auth', > 'django.contrib.contenttypes', > 'django.contrib.sessions', > 'django.contrib.sites', > 'django.contrib.messages', > 'django.contrib.admin', > 'django.contrib.admindocs', > 'authorizenet', > 'paypal.standard.ipn', > 'caching', > 'sitesearch', > 'interaction', > 'blog', > 'offline', > 'store', > 'store.account', > 'store.cart', > 'store.catalog', > 'store.catalog.indexing', > 'store.catalog.manage', > 'store.content', > 'store.discount', > 'store.images', > 'store.locations', > 'store.marketing', > 'store.metrics', > 'store.orders', > 'store.reviews', > 'store.shipments', > 'store.transactions'] > > LANGUAGES\_BIDI > > ('he', 'ar', 'fa') > > DATABASE\_ENGINE > > '' > > DEFAULT\_FILTER\_RESULTS > > 20 > > DATABASE\_NAME > > '' > > COMMENTS\_FIRST\_FEW > > 0 > > AUTHNET\_LOGIN\_ID > > '2w87JmTv' > > REQUIRE\_PAYMENT\_AT > > 'invoice' > > SEARCH\_SERVERS > > ('127.0.0.1:9200',) > > SESSION\_COOKIE\_HTTPONLY > > False > > DATABASE\_PORT > > '' > > DEBUG\_PROPAGATE\_EXCEPTIONS > > False > > PAYPAL\_RECEIVER\_EMAIL > > 'pay...@affordablequalitylighting.com \' > > MONTH\_DAY\_FORMAT > > 'F j' > > AUTHNET\_IMMEDIATE\_CAPTURE > > False > > LOGIN\_URL > > '/user' > > DEFAULT\_SEARCH\_QTY > > 9 > > TIME\_FORMAT > > 'P' > > DATE\_INPUT\_FORMATS > > ('%Y-%m-%d', > '%m/%d/%Y', > '%m/%d/%y', > '%b %d %Y', > '%b %d, %Y', > '%d %b %Y', > '%d %b, %Y', > '%B %d %Y', > '%B %d, %Y', > '%d %B %Y', > '%d %B, %Y') > > AUTHENTICATION\_BACKENDS > > ('store.account.backends.EmailAuth',) > > EMAIL\_HOST\_PASSWORD > > '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*' > > APP\_INSTANCE > > 0 > > TEMPLATE\_PATH > > '/var/www/tmplaql' > > CONTENT\_GROUP > > 'images' > > PASSWORD\_RESET\_TIMEOUT\_DAYS > > '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*' > > CACHE\_MIDDLEWARE\_ALIAS > > 'default' > > SESSION\_SAVE\_EVERY\_REQUEST > > True > > ADMIN\_MEDIA\_PREFIX > > '/admin/media/' > > NUMBER\_GROUPING > > 0 > > SESSION\_ENGINE > > 'django.contrib.sessions.backends.db' > > STATICFILES\_STORAGE > > 'django.contrib.staticfiles.storage.StaticFilesStorage' > > CSRF\_FAILURE\_VIEW > > 'django.views.csrf.csrf\_failure' > > COMMENTS\_SKETCHY\_USERS\_GROUP > > None > > LOGIN\_REDIRECT\_URL > > '/accounts/profile/' > > PAYPAL\_ENABLED > > True > > DECIMAL\_SEPARATOR > > '.' > > CACHE\_MIDDLEWARE\_KEY\_PREFIX > > '' > > LOCALE\_PATHS > > () > > TEMPLATE\_STRING\_IF\_INVALID > > '' > > COMMENTS\_ALLOW\_PROFANITIES > > False > > LOGOUT\_URL > > '/accounts/logout/' > > EMAIL\_USE\_TLS > > True > > TEMPLATE\_DIRS > > ('/var/www/tmplaql/templates', '/var/www/singularity/templates') > > BLOG\_CONTENT\_BASE\_URL > > '/images/blog' > > FIXTURE\_DIRS > > ('/var/www/singularity/fixtures',) > > EMAIL\_HOST > > '[smtp.gmail.com](http://smtp.gmail.com)' > > DATE\_FORMAT > > 'N j, Y' > > ACCOUNT\_CONTENT\_BASE\_URL > > '/images/store/account\_src' > > MEDIA\_ROOT > > '' > > ADMINS > > (('Blake Eggleston', 'bdegg...@gmail.com \'), > ('Blake Eggleston', 'b...@concordlighting.com \')) > > FORMAT\_MODULE\_PATH > > None > > DEFAULT\_FROM\_EMAIL > > 'webmaster@localhost' > > BLOG\_CONTENT\_BASE\_PATH > > '/var/www/singularity-media/images/blog' > > PRODUCTS\_PER\_PAGE > > 10000 > > REQUIRE\_PAYMENT\_CHOICES > > ['invoice', 'processing', 'shipment', 'completion'] > > STATICFILES\_DIRS > > () > > MEDIA\_URL > > '/media/' > > DATETIME\_FORMAT > > 'N j, Y, P' > > IGNORABLE\_404\_STARTS > > ('/cgi-bin/', '/\_vti\_bin', '/\_vti\_inf') > > DEBUG\_CHECKOUT > > False > > PROFILE\_SQL > > False > > SITE\_ID > > 1 > > DISALLOWED\_USER\_AGENTS > > () > > ALLOWED\_INCLUDE\_ROOTS > > () > > PRODUCT\_IMAGE\_FORMATS > > {'formats': [{'description': 'the default image on the product page', > 'max\_x': 447, > 'max\_y': 384, > 'name': 'product\_page'}, > {'description': 'images shown in the category/filtering view', > 'max\_x': 130, > 'max\_y': 96, > 'name': 'product\_cart'}, > {'description': 'images shown in the order review view', > 'max\_x': 60, > 'max\_y': 60, > 'name': 'product\_review'}, > {'description': 'images shown in the category/filtering view', > 'max\_x': 48, > 'max\_y': 49, > 'name': 'product\_preview'}, > {'description': 'category list and related products', > 'max\_x': 150, > 'max\_y': 150, > 'name': 'product\_list'}, > {'description': 'the tiny images in the footer', > 'max\_x': 25, > 'max\_y': 25, > 'name': 'product\_tiny'}, > {'description': 'the full highres image', > 'force\_size': False, > 'max\_x': 1000, > 'max\_y': 1000, > 'name': 'product\_full'}], > 'src\_dir': '/var/www/singularity-media/images/store/product\_src'} > > CONTENT\_USER > > 'www-data' > > LOGGING > > {'disable\_existing\_loggers': False, > 'handlers': {'mail\_admins': {'class': 'django.utils.log.AdminEmailHandler', > 'level': 'ERROR'}}, > 'loggers': {'django.request': {'handlers': ['mail\_admins'], > 'level': 'ERROR', > 'propagate': True}}, > 'version': 1} > > PREPEND\_WWW > > False > > SHORT\_DATE\_FORMAT > > 'm/d/Y' > > DATABASE\_USER > > '' > > FREIGHT\_CARRIERS > > {'rate\_modifiers': {'3aa49ec6bfc910647fa1c5a013e48eef': 25}, > 'ups': {'api\_access\_key': 'FC6D4E635C4A7F10', > 'api\_password': 'passive1', > 'api\_user\_id': 'LampsDirect', > 'billing\_city': 'Valencia', > 'billing\_country\_code': 'US', > 'billing\_post\_code': '91355', > 'billing\_territory': 'CA', > 'dim\_type': 'IN', > 'free\_freight\_amount': 0, > 'freight\_markup': -20, > 'shipper\_number': 'X0305A', > 'weight\_type': 'LBS'}, > 'ups\_freight': {'api\_access\_key': 'CC770A558C47ACB8', > 'api\_password': 'passive1', > 'api\_user\_id': 'LampsDirect', > 'billing\_city': 'Valencia', > 'billing\_country\_code': 'US', > 'billing\_name': 'Concord Lighting', > 'billing\_post\_code': '91355', > 'billing\_street1': '28150 Ave Crocker', > 'billing\_street2': 'Ste 312', > 'billing\_territory': 'CA', > 'dim\_type': 'IN', > 'free\_freight\_amount': 0, > 'freight\_markup': -20, > 'shipper\_number': 'X0305A', > 'weight\_type': 'LBS'}} > > ANALYTICS\_ACTIVE > > True > > TIME\_ZONE > > 'America/Los\_Angeles' > > FILE\_UPLOAD\_MAX\_MEMORY\_SIZE > > 2621440 > > PAYMENT\_PROCESSORS > > {'authorizenet': {'key': '7862YPJ34uumy3MF', > 'live': True, > 'username': '2w87JmTv'}, > 'paypalwps': {'business\_display\_name': 'Affordable Quality Lighting', > 'domain\_name': '[ec2-50-18-148-185.us-west-1.compute.amazonaws.com](http://ec2-50-18-148-185.us-west-1.compute.amazonaws.com)', > 'key': 'eyoBTzMK8wy25X-Yq5irPxrSe\_\_Gx5BBev4-UVhcq150mnR2VEEWeEbbCRm', > 'live': False, > 'username': 'be\_13337...@concordlighting.com \'}} > > EMAIL\_BACKEND > > 'django.core.mail.backends.smtp.EmailBackend' > > BLOG\_TITLE > > 'DIY Lighting Blog' > > DEFAULT\_TABLESPACE > > '' > > TEMPLATE\_CONTEXT\_PROCESSORS > > ('django.contrib.auth.context\_processors.auth', > 'django.core.context\_processors.debug', > 'django.core.context\_processors.i18n', > 'django.core.context\_processors.media', > 'django.core.context\_processors.static', > 'django.contrib.messages.context\_processors.messages') > > AUTHNET\_TRANSACTION\_KEY > > '7862YPJ34uumy3MF' > > TEST\_RUN > > False > > SESSION\_COOKIE\_AGE > > 1209600 > > SETTINGS\_MODULE > > 'settings' > > USE\_ETAGS > > False > > EMAIL\_HOST\_NAME > > 'Affordable Quality Lighting' > > LANGUAGES > > (('ar', 'Arabic'), > ('az', 'Azerbaijani'), > ('bg', 'Bulgarian'), > ('bn', 'Bengali'), > ('bs', 'Bosnian'), > ('ca', 'Catalan'), > ('cs', 'Czech'), > ('cy', 'Welsh'), > ('da', 'Danish'), > ('de', 'German'), > ('el', 'Greek'), > ('en', 'English'), > ('en-gb', 'British English'), > ('es', 'Spanish'), > ('es-ar', 'Argentinian Spanish'), > ('es-mx', 'Mexican Spanish'), > ('es-ni', 'Nicaraguan Spanish'), > ('et', 'Estonian'), > ('eu', 'Basque'), > ('fa', 'Persian'), > ('fi', 'Finnish'), > ('fr', 'French'), > ('fy-nl', 'Frisian'), > ('ga', 'Irish'), > ('gl', 'Galician'), > ('he', 'Hebrew'), > ('hi', 'Hindi'), > ('hr', 'Croatian'), > ('hu', 'Hungarian'), > ('id', 'Indonesian'), > ('is', 'Icelandic'), > ('it', 'Italian'), > ('ja', 'Japanese'), > ('ka', 'Georgian'), > ('km', 'Khmer'), > ('kn', 'Kannada'), > ('ko', 'Korean'), > ('lt', 'Lithuanian'), > ('lv', 'Latvian'), > ('mk', 'Macedonian'), > ('ml', 'Malayalam'), > ('mn', 'Mongolian'), > ('nl', 'Dutch'), > ('no', 'Norwegian'), > ('nb', 'Norwegian Bokmal'), > ('nn', 'Norwegian Nynorsk'), > ('pa', 'Punjabi'), > ('pl', 'Polish'), > ('pt', 'Portuguese'), > ('pt-br', 'Brazilian Portuguese'), > ('ro', 'Romanian'), > ('ru', 'Russian'), > ('sk', 'Slovak'), > ('sl', 'Slovenian'), > ('sq', 'Albanian'), > ('sr', 'Serbian'), > ('sr-latn', 'Serbian Latin'), > ('sv', 'Swedish'), > ('ta', 'Tamil'), > ('te', 'Telugu'), > ('th', 'Thai'), > ('tr', 'Turkish'), > ('uk', 'Ukrainian'), > ('ur', 'Urdu'), > ('vi', 'Vietnamese'), > ('zh-cn', 'Simplified Chinese'), > ('zh-tw', 'Traditional Chinese')) > > FILE\_UPLOAD\_TEMP\_DIR > > None > > INTERNAL\_IPS > > () > > STATIC\_URL > > None > > EMAIL\_PORT > > 25 > > SHORT\_DATETIME\_FORMAT > > 'm/d/Y P' > > ENFORCE\_SSL > > True > > PROFILE > > False > > ABSOLUTE\_URL\_OVERRIDES > > {} > > DATABASE\_OPTIONS > > {} > > CACHE\_MIDDLEWARE\_SECONDS > > 600 > > BANNED\_IPS > > () > > DATETIME\_INPUT\_FORMATS > > ('%Y-%m-%d %H:%M:%S', > '%Y-%m-%d %H:%M', > '%Y-%m-%d', > '%m/%d/%Y %H:%M:%S', > '%m/%d/%Y %H:%M', > '%m/%d/%Y', > '%m/%d/%y %H:%M:%S', > '%m/%d/%y %H:%M', > '%m/%d/%y') > > DATABASE\_PASSWORD > > '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*' > > COMMENTS\_MODERATORS\_GROUP > > None > > PROFANITIES\_LIST > > '\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*' > > EMAIL\_HOST\_USER > > 'nor...@affordablequalitylighting.com \' > > COMMENTS\_BANNED\_USERS\_GROUP > > None > > You're seeing this error because you have DEBUG = True in your Django > settings file. Change that to False, and Django will display a standard > 500 page. -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com). For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 2:50am UTC](https://discuss.elastic.co/t/need-help-with-es-searchphaseexecutionexception/10217/20 "2017-07-06T02:50:47Z")