Good news :), but still a bit odd - it’s great that it’s working, but I’ve no idea why the first attempt failed.
Also: there’ll always be at least two searchd processes - the master process, and then one for each current connection to Sphinx (the threaded worker model): http://sphinxsearch.com/docs/manual-2.2.5.html#conf-workers — Pat On 13 Nov 2014, at 4:04 am, Jeanine Soterwood <[email protected]> wrote: > Success! But I'm not sure what happened. I stopped searchd, grepped to make > sure none was running. Tried regenerate, same error. Grepped again, saw > that two processes of searchd were now running, killed them both, regenerated > again, and it was fine. Any ideas what may have happened? Thank you so much > for the help! > > Here is my output: > > [08:58:36 jeanine (search) ~/Sites/igb]$ bundle exec rake ts:stop > Stopped searchd daemon (pid: 10742). > [08:59:03 jeanine (search) ~/Sites/igb]$ ps aux | grep searchd > jeanine 18797 0.0 0.0 2423356 204 s008 U+ 8:59AM 0:00.00 > grep searchd > [08:59:11 jeanine (search) ~/Sites/igb]$ bundle exec rake ts:regenerate > searchd is not currently running. > Stopped searchd daemon (pid: ). > Generating configuration to > /Users/jeanine/Sites/igb/config/development.sphinx.conf > Started searchd successfully (pid: 18818). > Generating index files for product_core > rake aborted! > unknown column: 'name_sort' - REPLACE INTO product_core (id, > `sphinx_internal_class_name`, `name`, `sphinx_internal_id`, > `sphinx_internal_class`, `sphinx_deleted`, `name_sort`, `abbreviation`, > `created_at`, `updated_at`, `discipline_name`) VALUES (2, 'Product', > 'Revealing World Religions', 1, 'Product', 0, 'Revealing World Religions', > 'WR', 1219159749, 1219159749, 'Religious Studies') > > Tasks: TOP => ts:regenerate => ts:generate > (See full trace by running task with --trace) > [08:59:38 jeanine (search) ~/Sites/igb]$ ps aux | grep searchd > jeanine 18828 0.0 0.0 2432768 588 s008 S+ 8:59AM 0:00.00 > grep searchd > jeanine 18818 0.0 0.0 2460352 2504 ?? S 8:59AM 0:00.02 > searchd --pidfile --config > /Users/jeanine/Sites/igb/config/development.sphinx.conf > jeanine 18817 0.0 0.0 2443832 288 ?? S 8:59AM 0:00.00 > searchd --pidfile --config > /Users/jeanine/Sites/igb/config/development.sphinx.conf > [08:59:50 jeanine (search) ~/Sites/igb]$ kill -9 18818 18817 > [09:00:05 jeanine (search) ~/Sites/igb]$ ps aux | grep searchd > jeanine 18847 0.0 0.0 2432768 588 s008 S+ 9:00AM 0:00.00 > grep searchd > [09:00:09 jeanine (search) ~/Sites/igb]$ bundle exec rake ts:regenerate > searchd is not currently running. > Stopped searchd daemon (pid: 18818). > Generating configuration to > /Users/jeanine/Sites/igb/config/development.sphinx.conf > Started searchd successfully (pid: 18869). > Generating index files for product_core > ..... > [09:00:33 jeanine (search) ~/Sites/igb]$ > > On Tue, Nov 11, 2014 at 6:14 PM, Pat Allan <[email protected]> wrote: > … and then, once you’re sure there’s no searchd processes in the way, try > ts:regenerate again. > > On 12 Nov 2014, at 1:10 pm, Pat Allan <[email protected]> wrote: > >> Hmm. Can you run `rake ts:stop` and then `ps aux | grep searchd` to confirm >> there’s no searchd processes running? >> >> On 12 Nov 2014, at 4:37 am, Jeanine <[email protected]> wrote: >> >>> Yes, here is my product model: >>> >>> class Product < ActiveRecord::Base >>> >>> attr_accessible :discipline_id, :name, :abbreviation >>> >>> belongs_to :discipline >>> has_many :product_versions, dependent: :destroy >>> >>> validates :name, presence: true, uniqueness: true >>> validates :abbreviation, presence: true, uniqueness: true >>> validates :discipline_id, presence: true >>> >>> after_save ThinkingSphinx::RealTime.callback_for(:product) >>> end >>> >>> I tried deleting my config/development.sphinx.com file and clearing out >>> db/sphinx/development directory, but to no avail. >>> >>> -- >>> 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. >> >> >> -- >> 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. > > > -- > 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. > > > -- > 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. -- 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.
