Hello. rails (= 4.1.4) thinking-sphinx (3.1.1)
On localhost (development) command rake ts:index outputs: $ rake ts:index Generating configuration to /config/development.sphinx.conf Sphinx 2.1.8-release (rel21-r4675) Copyright (c) 2001-2014, Andrew Aksyonoff Copyright (c) 2008-2014, Sphinx Technologies Inc (http://sphinxsearch.com) using config file '/config/development.sphinx.conf'... indexing index 'spree_product_core'... collected 3587 docs, 0.6 MB sorted 1.6 Mhits, 100.0% done total 3587 docs, 593368 bytes total 0.915 sec, 648182 bytes/sec, 3918.36 docs/sec skipping non-plain index 'spree_product'... total 3 reads, 0.002 sec, 2415.7 kb/call avg, 0.9 msec/call avg total 23 writes, 0.089 sec, 657.2 kb/call avg, 3.9 msec/call avg rotating indices: successfully sent SIGHUP to searchd (pid=8888). and all products searches well. But on production same command RAILS_ENV=production bundle exec rake ts:index outputs only $ RAILS_ENV=production bundle exec rake ts:index Generating configuration to /releases/20140826214948/config/production. sphinx.conf and new products not found by search request. I tried index, rebuild, stop, start. No output about index and no new products in search results. And no errors in output. Generated production.sphinx.conf file is: $ cat config/production.sphinx.conf indexer { } searchd { listen = 127.0.0.1:9306:mysql41 log = /shared/log/production.searchd.log query_log = /shared/log/production.searchd.query.log pid_file = /shared/log/production.sphinx.pid workers = threads binlog_path = /releases/20140826214948/tmp/binlog/production } source spree_product_core_0 { type = pgsql sql_host = localhost sql_user = grocerymarket sql_pass = g4h709gq38qg sql_db = grocerymarket sql_port = 5432 sql_query_pre = SET TIME ZONE UTC sql_query = SELECT "spree_products"."id" * 2 + 0 AS "id", spree_products. "name" AS "name", spree_products."description" AS "description", spree_products."id" AS "sphinx_internal_id", 'Spree::Product' AS "sphinx_internal_class", 0 AS "sphinx_deleted", extract(epoch from spree_products."created_at")::int AS "created_at", extract(epoch from spree_products."updated_at")::int AS "updated_at" FROM "spree_products" WHERE ("spree_products"."id" BETWEEN $start AND $end AND deleted_at IS NULL ) GROUP BY "spree_products"."id", spree_products."name", spree_products. "description", spree_products."id", spree_products."created_at", spree_products."updated_at" sql_query_range = SELECT COALESCE(MIN("spree_products"."id"), 1), COALESCE (MAX("spree_products"."id"), 1) FROM "spree_products" sql_attr_uint = sphinx_internal_id sql_attr_uint = sphinx_deleted sql_attr_timestamp = created_at sql_attr_timestamp = updated_at sql_attr_string = sphinx_internal_class sql_field_string = name sql_query_info = SELECT "spree_products".* FROM "spree_products" WHERE ( "spree_products"."id" = ($id - 0) / 2) } index spree_product_core { type = plain path = /releases/20140826214948/db/sphinx/production/spree_product_core docinfo = extern charset_type = utf-8 min_infix_len = 3 enable_star = 1 source = spree_product_core_0 } index spree_product { type = distributed local = spree_product_core } Any ideas about problem? -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/d/optout.
