query too complex, not enough stack (thread_stack=67K or higher required)

Ben's Avatar

Ben

14 Jul, 2014 03:10 PM

We are running into some limitations on some large queries and are exploring options. We will probably end up limiting the query on our end, but out of curiosity: is it possible to set the thread_stack value higher? What is it set to by default? Thanks!

  1. Support Staff 1 Posted by Pat Allan on 14 Jul, 2014 04:02 PM

    Pat Allan's Avatar

    Hi Ben

    According to the Sphinx documentation, the default value is 64K:
    http://sphinxsearch.com/docs/manual-2.1.8.html#conf-thread-stack

    Presuming you're using Thinking Sphinx, you can configure this in config/thinking_sphinx.yml per environment (or config/sphinx.yml if you're using TS v1/v2). I'm currently not enforcing any limits for this, so you're certainly welcome to set it to what's needed (but also: don't go overboard, given you're on a shared server :) The Sphinx docs provide some detail on how to calculate that, but it's hard for me to advise anything specific without knowing what your queries are looking like.

    Let me know if you need any further help with this :)

    Cheers

    Pat

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac