Hello all.
I am using BackgrounDRB with “great happiness and joy”, however, I am
running into one problem in that when I am running my tests with
autotest using Sqlite3 3.3.17 I am getting
“ActiveRecord::StatementInvalid” exception inside of the
sqlite_adapter.rb:360 which is checking for an empty structure.
I thought it might be the version of Sqlite, so I upgraded to 3.3.17
(just did a download, configure, make, make install and then saved the
old binary and linked back to the newly installed version. Calling
sqlite3 -version from the shell returns 3.3.17 (Running MacOSX 10.4.9)
Tracing the stack back gets me to line 18 of my code which is doing:
@object = Object.find_by_id(object_id)
And the next item in the stack trace is calling method_missing in
ActiveRecord:Base. It seems like the Object table is not being loaded
in at the start of the tests… or at least not getting loaded into to
the same environment that BackgrounDRB is running in. I am using
autotest with memory_test_fix.
The same code runs error free in MySQL (passes tests and runs properly
in the app).
The Unit Test that raises the error is including the fixtures for the
object being “finded”.
Has anyone else run into this problem?
It’s a bummer as to test BackgrounDRB section of the code, I need to
swap out to MySQL (as I use Sqlite3 for the speed on tests).
From what I can see the solution would be somehow linking BackgrounDRB
back into the same DB that Autotest is tearing down and setting back
up.
Not sure where to start on this.
Stack trace follows. Thanks!
Regards
Mikel
ActiveRecord::StatementInvalid - (ActiveRecord::StatementInvalid)
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/connection_adapters/sqlite_adapter.rb:360:in
table_structure' /usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/ active_support/core_ext/object/misc.rb:23:inreturning’
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/connection_adapters/sqlite_adapter.rb:359:in
table_structure' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/connection_adapters/sqlite_adapter.rb:210:incolumns’
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/base.rb:763:in columns' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/base.rb:776:incolumn_names’
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/base.rb:789:in column_methods_hash' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/base.rb:1262:inall_attributes_exists?’
/usr/local/lib/ruby/gems/1.8/gems/activesupport-1.4.2/lib/
active_support/inflector.rb:250:in all?' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/base.rb:1262:ineach’
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/base.rb:1262:in all?' /usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/ active_record/base.rb:1262:inall_attributes_exists?’
/usr/local/lib/ruby/gems/1.8/gems/activerecord-1.15.3/lib/
active_record/base.rb:1196:in method_missing' /Users/mikel/working/translation-system/trunk/config/../script/ backgroundrb/../../config/../lib/workers/book_import_worker.rb:18:indo_work’
/Users/mikel/working/translation-system/trunk/config/…/script/
backgroundrb/…/…/config/…/vendor/plugins/backgroundrb/
backgroundrb_rails.rb:36:in start_process' /Users/mikel/working/translation-system/trunk/config/../script/ backgroundrb/../../config/../vendor/plugins/backgroundrb/ backgroundrb_rails.rb:32:ininitialize’
/Users/mikel/working/translation-system/trunk/config/…/script/
backgroundrb/…/…/config/…/vendor/plugins/backgroundrb/
backgroundrb_rails.rb:32:in new' /Users/mikel/working/translation-system/trunk/config/../script/ backgroundrb/../../config/../vendor/plugins/backgroundrb/ backgroundrb_rails.rb:32:instart_process’
/Users/mikel/working/translation-system/trunk/config/…/script/
backgroundrb/…/…/config/…/vendor/plugins/backgroundrb/
backgroundrb.rb:57:in new_worker' /Users/mikel/working/translation-system/trunk/config/../script/ backgroundrb/../../config/../vendor/plugins/backgroundrb/ backgroundrb.rb:49:insynchronize’
/Users/mikel/working/translation-system/trunk/config/…/script/
backgroundrb/…/…/config/…/vendor/plugins/backgroundrb/
backgroundrb.rb:49:in new_worker' /usr/local/lib/ruby/1.8/drb/drb.rb:1555:insend’
/usr/local/lib/ruby/1.8/drb/drb.rb:1555:in perform_without_block' /usr/local/lib/ruby/1.8/drb/drb.rb:1515:inperform’
/usr/local/lib/ruby/1.8/drb/drb.rb:1589:in main_loop' /usr/local/lib/ruby/1.8/drb/drb.rb:1585:inloop’
/usr/local/lib/ruby/1.8/drb/drb.rb:1585:in main_loop' /usr/local/lib/ruby/1.8/drb/drb.rb:1581:instart’
/usr/local/lib/ruby/1.8/drb/drb.rb:1581:in main_loop' /usr/local/lib/ruby/1.8/drb/drb.rb:1430:inrun’
/usr/local/lib/ruby/1.8/drb/drb.rb:1427:in start' /usr/local/lib/ruby/1.8/drb/drb.rb:1427:inrun’
/usr/local/lib/ruby/1.8/drb/drb.rb:1347:in initialize' /usr/local/lib/ruby/1.8/drb/drb.rb:1627:innew’
/usr/local/lib/ruby/1.8/drb/drb.rb:1627:in start_service' /Users/mikel/working/translation-system/trunk/config/../script/ backgroundrb/start:98 /Users/mikel/working/translation-system/trunk/config/../script/ backgroundrb/start:94:infork’
/Users/mikel/working/translation-system/trunk/config/…/script/
backgroundrb/start:94
/Users/mikel/working/translation-system/trunk/config/…/script/
backgroundrb/start:86:in `fork’
/Users/mikel/working/translation-system/trunk/config/…/script/
backgroundrb/start:86
It is only playing up when BackgrounDRB tries to access it.