Pat, I saw your "external world" commit. Great! That commit solved my problem. Thank you for that! :)
Just a minor thing. At the Thinking Sphinx site your missing a comma after the lib option: config.gem 'ts-delayed-delta', :lib => 'thinking_sphinx/deltas/delayed_delta' :version => '>= 1.0.0', :source => 'http://gemcutter.org' On Nov 1, 10:14 pm, rejeep <[email protected]> wrote: > It not abvious how to solve it. Thanks anyway for your help! > > I'll be sure to post here if I find a solution! > > On Oct 27, 9:56 am, Pat Allan <[email protected]> wrote: > > > I'm sorry, I'm really not sure how to fix this. It's odd that it only > > happens in your test env, and that the query that's throwing errors > > doesn't do so when you run them manually. I'm not sure what the next > > step for debugging is... > > > -- > > Pat > > > On 16/10/2009, at 5:48 PM,rejeepwrote: > > > > 0.00 ms. Both with an empty database and if I add a klass record. > > > > On Oct 16, 6:37 am, Pat Allan <[email protected]> wrote: > > >> if you use the mysql command-line tool to connect to the test > > >> database, how quickly does the UPDATE statement (the first > > >> sql_query_pre) run? > > > >> -- > > >> Pat > > > >> On 16/10/2009, at 8:32 AM,rejeepwrote: > > > >>> Under *source klass_core_0* > > >>> sql_query_pre = UPDATE `java_classes` SET `delta` = 0 WHERE > > >>> `delta` = > > >>> 1 > > >>> sql_query_pre = SET NAMES utf8 > > > >>> And under *source klass_delta_0 : klass_core_0* > > >>> sql_query_pre = > > >>> sql_query_pre = SET NAMES utf8 > > > >>> On Oct 15, 9:20 pm, Pat Allan <[email protected]> wrote: > > >>>> Sorry, I should have been more clear... in your test.sphinx.conf > > >>>> file, > > >>>> what are the sql_query_pre values in your klass_core_i source? > > > >>>> -- > > >>>> Pat > > > >>>> On 15/10/2009, at 11:16 PM, Pat Allan wrote: > > > >>>>> Wow, something's really going wrong there with the sql_query_pre > > >>>>> SQL > > >>>>> statements... can you copy and paste the ones from the > > >>>>> klass_core_1 > > >>>>> source? > > > >>>>> -- > > >>>>> Pat > > > >>>>> On 15/10/2009, at 7:51 PM,rejeepwrote: > > > >>>>>> Sorry for the late reply. > > > >>>>>> Here's the log: > > >>>>>> Sphinx 0.9.9-rc2 (r1785) > > >>>>>> Copyright (c) 2001-2009, Andrew Aksyonoff > > > >>>>>> using config file '/home/rejeep/dev/closing/config/ > > >>>>>> test.sphinx.conf'... > > >>>>>> indexing index 'klass_core'... > > >>>>>> ERROR: index 'klass_core': sql_query_pre[0]: Lock wait timeout > > >>>>>> exceeded; try restarting transaction (DSN=mysql:// > > >>>>>> closing:*...@localhost:3306/closing_test). > > >>>>>> total 0 docs, 0 bytes > > >>>>>> total 51.825 sec, 0 bytes/sec, 0.00 docs/sec > > >>>>>> indexing index 'klass_delta'... > > >>>>>> collected 0 docs, 0.0 MB > > >>>>>> collected 0 attr values > > >>>>>> sorted 0.0 Mvalues, nan% done > > >>>>>> total 0 docs, 0 bytes > > >>>>>> total 0.005 sec, 0 bytes/sec, 0.00 docs/sec > > >>>>>> distributed index 'klass' can not be directly indexed; skipping. > > >>>>>> indexing index 'interface_core'... > > >>>>>> ERROR: index 'interface_core': sql_query_pre[0]: Lock wait > > >>>>>> timeout > > >>>>>> exceeded; try restarting transaction (DSN=mysql:// > > >>>>>> closing:*...@localhost:3306/closing_test). > > >>>>>> total 0 docs, 0 bytes > > >>>>>> total 50.052 sec, 0 bytes/sec, 0.00 docs/sec > > >>>>>> indexing index 'interface_delta'... > > >>>>>> collected 0 docs, 0.0 MB > > >>>>>> collected 0 attr values > > >>>>>> sorted 0.0 Mvalues, nan% done > > >>>>>> total 0 docs, 0 bytes > > >>>>>> total 0.005 sec, 0 bytes/sec, 0.00 docs/sec > > >>>>>> distributed index 'interface' can not be directly indexed; > > >>>>>> skipping. > > >>>>>> indexing index 'enum_core'... > > >>>>>> ERROR: index 'enum_core': sql_query_pre[0]: Lock wait timeout > > >>>>>> exceeded; try restarting transaction (DSN=mysql:// > > >>>>>> closing:*...@localhost:3306/closing_test). > > >>>>>> total 0 docs, 0 bytes > > >>>>>> total 51.055 sec, 0 bytes/sec, 0.00 docs/sec > > >>>>>> indexing index 'enum_delta'... > > >>>>>> collected 0 docs, 0.0 MB > > >>>>>> collected 0 attr values > > >>>>>> sorted 0.0 Mvalues, nan% done > > >>>>>> total 0 docs, 0 bytes > > >>>>>> total 0.005 sec, 0 bytes/sec, 0.00 docs/sec > > >>>>>> distributed index 'enum' can not be directly indexed; skipping. > > >>>>>> indexing index 'annotation_core'... > > >>>>>> ERROR: index 'annotation_core': sql_query_pre[0]: Lock wait > > >>>>>> timeout > > >>>>>> exceeded; try restarting transaction (DSN=mysql:// > > >>>>>> closing:*...@localhost:3306/closing_test). > > >>>>>> total 0 docs, 0 bytes > > >>>>>> total 51.058 sec, 0 bytes/sec, 0.00 docs/sec > > >>>>>> indexing index 'annotation_delta'... > > >>>>>> collected 0 docs, 0.0 MB > > >>>>>> collected 0 attr values > > >>>>>> sorted 0.0 Mvalues, nan% done > > >>>>>> total 0 docs, 0 bytes > > >>>>>> total 0.005 sec, 0 bytes/sec, 0.00 docs/sec > > >>>>>> distributed index 'annotation' can not be directly indexed; > > >>>>>> skipping. > > >>>>>> total 4 reads, 0.000 sec, 32.0 kb/call avg, 0.0 msec/call avg > > >>>>>> total 16 writes, 0.000 sec, 0.0 kb/call avg, 0.0 msec/call avg > > >>>>>> rotating indices: succesfully sent SIGHUP to searchd (pid=11305). > > >>>>>> Loaded suite /usr/bin/rake > > > >>>>>> On Oct 11, 8:44 pm, Pat Allan <[email protected]> wrote: > > >>>>>>> Right. Can you show me the output when it's running slowly? > > > >>>>>>> -- > > >>>>>>> Pat > > > >>>>>>> On 11/10/2009, at 7:09 PM,rejeepwrote: > > > >>>>>>>> That is not slow at all. But that's because the database does > > >>>>>>>> not > > >>>>>>>> contain any records. But if I create a record from a factory in > > >>>>>>>> the > > >>>>>>>> test and then run the rake task, also from the test, it will > > >>>>>>>> take > > >>>>>>>> forever. > > > >>>>>>>> On Oct 11, 1:36 pm, Pat Allan <[email protected]> > > >>>>>>>> wrote: > > >>>>>>>>> Either I'm missing it, or there isn't actually any data being > > >>>>>>>>> indexed > > >>>>>>>>> (nor does it seem to be running slowly). What's the output > > >>>>>>>>> (and > > >>>>>>>>> how > > >>>>>>>>> are you running it) when it *is* running slowly? > > > >>>>>>>>> -- > > >>>>>>>>> Pat > > > >>>>>>>>> On 10/10/2009, at 1:28 PM,rejeepwrote: > > > >>>>>>>>>> The test database is exactly the same as the development. I > > >>>>>>>>>> don't > > >>>>>>>>>> know > > >>>>>>>>>> if it matters, but it's a cucumber test, so it's actually the > > >>>>>>>>>> cucumber > > >>>>>>>>>> environment. But that environment is only linking to test, so > > >>>>>>>>>> it > > >>>>>>>>>> should be exactly the same. > > > >>>>>>>>>> $ rake ts:in RAILS_ENV=test > > >>>>>>>>>> (in /home/rejeep/dev/closing) > > >>>>>>>>>> Generating Configuration to /home/rejeep/dev/closing/config/ > > >>>>>>>>>> test.sphinx.conf > > >>>>>>>>>> Sphinx 0.9.9-rc2 (r1785) > > >>>>>>>>>> Copyright (c) 2001-2009, Andrew Aksyonoff > > > >>>>>>>>>> using config file '/home/rejeep/dev/closing/config/ > > >>>>>>>>>> test.sphinx.conf'... > > >>>>>>>>>> indexing index 'klass_core'... > > >>>>>>>>>> collected 0 docs, 0.0 MB > > >>>>>>>>>> collected 0 attr values > > >>>>>>>>>> sorted 0.0 Mvalues, nan% done > > >>>>>>>>>> total 0 docs, 0 bytes > > >>>>>>>>>> total 0.005 sec, 0 bytes/sec, 0.00 docs/sec > > >>>>>>>>>> indexing index 'klass_delta'... > > >>>>>>>>>> collected 0 docs, 0.0 MB > > >>>>>>>>>> collected 0 attr values > > >>>>>>>>>> sorted 0.0 Mvalues, nan% done > > >>>>>>>>>> total 0 docs, 0 bytes > > >>>>>>>>>> total 0.001 sec, 0 bytes/sec, 0.00 docs/sec > > >>>>>>>>>> distributed index 'klass' can not be directly indexed; > > >>>>>>>>>> skipping. > > >>>>>>>>>> indexing index 'interface_core'... > > >>>>>>>>>> collected 0 docs, 0.0 MB > > >>>>>>>>>> collected 0 attr values > > >>>>>>>>>> sorted 0.0 Mvalues, nan% done > > >>>>>>>>>> total 0 docs, 0 bytes > > >>>>>>>>>> total 0.002 sec, 0 bytes/sec, 0.00 docs/sec > > >>>>>>>>>> indexing index 'interface_delta'... > > >>>>>>>>>> collected 0 docs, 0.0 MB > > >>>>>>>>>> collected 0 attr values > > >>>>>>>>>> sorted 0.0 Mvalues, nan% done > > >>>>>>>>>> total 0 docs, 0 bytes > > >>>>>>>>>> total 0.001 sec, 0 bytes/sec, 0.00 docs/sec > > >>>>>>>>>> distributed index 'interface' can not be directly indexed; > > >>>>>>>>>> skipping. > > >>>>>>>>>> indexing index 'enum_core'... > > >>>>>>>>>> collected 0 docs, 0.0 MB > > >>>>>>>>>> collected 0 attr values > > >>>>>>>>>> sorted 0.0 Mvalues, nan% done > > >>>>>>>>>> total 0 docs, 0 bytes > > >>>>>>>>>> total 0.001 sec, 0 bytes/sec, 0.00 docs/sec > > >>>>>>>>>> indexing index 'enum_delta'... > > >>>>>>>>>> collected 0 docs, 0.0 MB > > >>>>>>>>>> collected 0 attr values > > >>>>>>>>>> sorted 0.0 Mvalues, nan% done > > >>>>>>>>>> total 0 docs, 0 bytes > > >>>>>>>>>> total 0.001 sec, 0 bytes/sec, 0.00 docs/sec > > >>>>>>>>>> distributed index 'enum' can not be directly indexed; > > >>>>>>>>>> skipping. > > >>>>>>>>>> indexing index 'annotation_core'... > > >>>>>>>>>> collected 0 docs, 0.0 MB > > >>>>>>>>>> collected 0 attr values > > >>>>>>>>>> sorted 0.0 Mvalues, nan% done > > >>>>>>>>>> total 0 docs, 0 bytes > > >>>>>>>>>> total 0.001 sec, 0 bytes/sec, 0.00 docs/sec > > >>>>>>>>>> indexing index 'annotation_delta'... > > >>>>>>>>>> collected 0 docs, 0.0 MB > > >>>>>>>>>> collected 0 attr values > > >>>>>>>>>> sorted 0.0 Mvalues, nan% done > > >>>>>>>>>> total 0 docs, 0 bytes > > >>>>>>>>>> total 0.002 sec, 0 bytes/sec, 0.00 docs/sec > > >>>>>>>>>> distributed index 'annotation' can not be directly indexed; > > >>>>>>>>>> skipping. > > >>>>>>>>>> total 8 reads, 0.000 sec, 32.0 kb/call avg, 0.0 msec/call avg > > >>>>>>>>>> total 32 writes, 0.001 sec, 0.0 kb/call avg, 0.0 msec/call > > >>>>>>>>>> avg > > >>>>>>>>>> Loaded suite /usr/bin/rake > > >>>>>>>>>> Started > > > >>>>>>>>>> Finished in 0.000242 seconds. > > > >>>>>>>>>> 0 tests, 0 assertions, 0 failures, 0 errors > > > >>>>>>>>>> On Oct 10, 10:42 am, Pat Allan <[email protected]> > > >>>>>>>>>> wrote: > > >>>>>>>>>>> If there's only one record, then it shouldn't matter what > > >>>>>>>>>>> your > > >>>>>>>>>>> range > > >>>>>>>>>>> step is, because Sphinx finds the smallest and largest ids > > >>>>>>>>>>> available - > > >>>>>>>>>>> which in this case, are the same number. > > > >>>>>>>>>>> Do you have all the same database indexes on your test db > > >>>>>>>>>>> and > > >>>>>>>>>>> development db? What's the output of rake ts:in > > >>>>>>>>>>> RAILS_ENV=test? > > > >>>>>>>>>>> -- > > ... > > read more » --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en -~----------~----~----~----~------~----~------~--~---
