Thanks Pat. I remove temporary file and it works. Yes, it was situation when indexing process has beed cancelled.
среда, 27 августа 2014 г., 11:33:49 UTC+4 пользователь Pat Allan написал: > > Hi Michael > > Have a look in the folder where your index files are located on your > production server - you’ll very likely find some temporary files created by > Thinking Sphinx (to stop indexing of the same files happening concurrently > - I guess at some point indexing was started then cancelled?) > > TS v3.1.2 will make debugging these situations much easier, once it’s > released. > > Cheers > > — > Pat > > On 27 Aug 2014, at 5:29 pm, Michael Kechinov <[email protected] > <javascript:>> wrote: > > 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] <javascript:>. > To post to this group, send email to [email protected] > <javascript:>. > Visit this group at http://groups.google.com/group/thinking-sphinx. > For more options, visit https://groups.google.com/d/optout. > > > -- 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.
