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.
