Bug #3419: 1.9.2-preview3 possible bug with Rails 3 active_record sqlite_adapter

• Status: Rejected
• Assignee: tenderlovemaking (Aaron Patterson)
• Target version: -
• ruby -v: 1.9.2-preview3

[joemsak (Joe Sak)]

=begin
When accessing the home page of my rails3 app, this happens in console:

$ r s
=> Booting WEBrick
=> Rails 3.0.0.beta4 application starting in development on http://0.0.0.0:3000
=> Call with -d to detach
=> Ctrl-C to shutdown server
[2010-06-09 18:00:44] INFO WEBrick 1.3.1
[2010-06-09 18:00:44] INFO ruby 1.9.2 (2010-05-31) [x86_64-darwin10.3.0]
[2010-06-09 18:00:44] INFO WEBrick::HTTPServer#start: pid=15746 port=3000
/Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/sqlite3_adapter.rb:13: [BUG] unknown type 0x22 (0xc given)
ruby 1.9.2dev (2010-05-31 revision 28117) [x86_64-darwin10.3.0]

-- control frame ----------
c:0043 p:---- s:0209 b:0209 l:000208 d:000208 CFUNC :initialize
c:0042 p:---- s:0207 b:0207 l:000206 d:000206 CFUNC :new
c:0041 p:0082 s:0202 b:0202 l:000201 d:000201 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/sqlite3_adapter
c:0040 p:0045 s:0197 b:0197 l:000196 d:000196 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connec
c:0039 p:0011 s:0194 b:0194 l:000193 d:000193 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connec
c:0038 p:0048 s:0190 b:0190 l:000176 d:000189 BLOCK /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connec
c:0037 p:---- s:0187 b:0187 l:000186 d:000186 FINISH
c:0036 p:---- s:0185 b:0185 l:000184 d:000184 CFUNC :loop
c:0035 p:0009 s:0182 b:0182 l:000176 d:000181 BLOCK /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connec
c:0034 p:0019 s:0180 b:0180 l:000179 d:000179 METHOD /Users/hubble/.rvm/rubies/ruby-1.9.2-preview3/lib/ruby/1.9.1/monitor.rb:201
c:0033 p:0013 s:0177 b:0177 l:000176 d:000176 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connec
c:0032 p:0047 s:0174 b:0171 l:000170 d:000170 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connec
c:0031 p:0033 s:0167 b:0167 l:000166 d:000166 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connec
c:0030 p:0018 s:0162 b:0162 l:000161 d:000161 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connec
c:0029 p:0011 s:0159 b:0159 l:000158 d:000158 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connec
c:0028 p:0043 s:0156 b:0156 l:000155 d:000155 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/query_cache.rb:11
c:0027 p:0019 s:0152 b:0152 l:002000 d:002000 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/query_cache.rb:30
c:0026 p:0015 s:0148 b:0148 l:000147 d:000147 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connec
c:0025 p:0031 s:0144 b:0144 l:001d70 d:000143 BLOCK /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta4/lib/action_dispatch/middleware/callbacks.rb:46
c:0024 p:0235 s:0142 b:0142 l:000141 d:000141 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activesupport-3.0.0.beta4/lib/active_support/callbacks.rb:414
c:0023 p:0024 s:0132 b:0132 l:000131 d:000131 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activesupport-3.0.0.beta4/lib/active_support/callbacks.rb:88
c:0022 p:0013 s:0126 b:0126 l:001d70 d:001d70 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta4/lib/action_dispatch/middleware/callbacks.rb:44
c:0021 p:0015 s:0122 b:0122 l:000121 d:000121 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/sendfile.rb:105
c:0020 p:0049 s:0112 b:0112 l:000111 d:000111 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta4/lib/action_dispatch/middleware/remote_ip.rb:48
c:0019 p:0015 s:0108 b:0108 l:000107 d:000107 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta4/lib/action_dispatch/middleware/show_exceptions.rb:48
c:0018 p:0027 s:0100 b:0100 l:000099 d:000099 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/railties-3.0.0.beta4/lib/rails/rack/logger.rb:14
c:0017 p:0032 s:0096 b:0096 l:000095 d:000095 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/runtime.rb:17
c:0016 p:0052 s:0087 b:0087 l:000086 d:000086 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activesupport-3.0.0.beta4/lib/active_support/cache/strategy/local_cache.rb:72
c:0015 p:0014 s:0083 b:0083 l:000077 d:000082 BLOCK /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/lock.rb:11
c:0014 p:0019 s:0081 b:0081 l:000080 d:000080 METHOD internal:prelude:10
c:0013 p:0054 s:0078 b:0078 l:000077 d:000077 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/lock.rb:11
c:0012 p:0193 s:0073 b:0073 l:000072 d:000072 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta4/lib/action_dispatch/middleware/static.rb:30
c:0011 p:0032 s:0066 b:0066 l:000065 d:000065 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/railties-3.0.0.beta4/lib/rails/application.rb:145
c:0010 p:0021 s:0062 b:0062 l:000061 d:000061 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/railties-3.0.0.beta4/lib/rails/application.rb:81
c:0009 p:---- s:0057 b:0057 l:000056 d:000056 FINISH
c:0008 p:0015 s:0055 b:0055 l:000054 d:000054 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/railties-3.0.0.beta4/lib/rails/rack/log_tailer.rb:15
c:0007 p:0015 s:0050 b:0050 l:000049 d:000049 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/content_length.rb:13
c:0006 p:0331 s:0042 b:0042 l:000041 d:000041 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/handler/webrick.rb:48
c:0005 p:0257 s:0030 b:0030 l:000029 d:000029 METHOD /Users/hubble/.rvm/rubies/ruby-1.9.2-preview3/lib/ruby/1.9.1/webrick/httpserver.rb:111
c:0004 p:0393 s:0020 b:0020 l:000019 d:000019 METHOD /Users/hubble/.rvm/rubies/ruby-1.9.2-preview3/lib/ruby/1.9.1/webrick/httpserver.rb:70
c:0003 p:0126 s:0009 b:0009 l:002498 d:000008 BLOCK /Users/hubble/.rvm/rubies/ruby-1.9.2-preview3/lib/ruby/1.9.1/webrick/server.rb:183
c:0002 p:---- s:0004 b:0004 l:000003 d:000003 FINISH
c:0001 p:---- s:0002 b:0002 l:000001 d:000001 TOP

-- Ruby level backtrace information ----------------------------------------
/Users/hubble/.rvm/rubies/ruby-1.9.2-preview3/lib/ruby/1.9.1/webrick/server.rb:183:in block in start_thread' /Users/hubble/.rvm/rubies/ruby-1.9.2-preview3/lib/ruby/1.9.1/webrick/httpserver.rb:70:in run'
/Users/hubble/.rvm/rubies/ruby-1.9.2-preview3/lib/ruby/1.9.1/webrick/httpserver.rb:111:in service' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/handler/webrick.rb:48:in service'
/Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/content_length.rb:13:in call' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/railties-3.0.0.beta4/lib/rails/rack/log_tailer.rb:15:in call'
/Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/railties-3.0.0.beta4/lib/rails/application.rb:81:in method_missing' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/railties-3.0.0.beta4/lib/rails/application.rb:145:in call'
/Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta4/lib/action_dispatch/middleware/static.rb:30:in call' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/lock.rb:11:in call'
internal:prelude:10:in synchronize' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/lock.rb:11:in block in call'
/Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activesupport-3.0.0.beta4/lib/active_support/cache/strategy/local_cache.rb:72:in call' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/runtime.rb:17:in call'
/Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/railties-3.0.0.beta4/lib/rails/rack/logger.rb:14:in call' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta4/lib/action_dispatch/middleware/show_exceptions.rb:48:in call'
/Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta4/lib/action_dispatch/middleware/remote_ip.rb:48:in call' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/sendfile.rb:105:in call'
/Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta4/lib/action_dispatch/middleware/callbacks.rb:44:in call' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activesupport-3.0.0.beta4/lib/active_support/callbacks.rb:88:in run_callbacks'
/Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activesupport-3.0.0.beta4/lib/active_support/callbacks.rb:414:in _run_call_callbacks' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta4/lib/action_dispatch/middleware/callbacks.rb:46:in block in call'
/Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:365:in call' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/query_cache.rb:30:in call'
/Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/query_cache.rb:11:in cache' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_specification.rb:95:in connection'
/Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_specification.rb:103:in retrieve_connection' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:330:in retrieve_connection'
/Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:99:in connection' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:185:in checkout'
/Users/hubble/.rvm/rubies/ruby-1.9.2-preview3/lib/ruby/1.9.1/monitor.rb:201:in mon_synchronize' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:186:in block in checkout'
/Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:186:in loop' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:190:in block (2 levels) in checkout'
/Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:248:in checkout_new_connection' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:226:in new_connection'
/Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/sqlite3_adapter.rb:13:in sqlite3_connection' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/sqlite3_adapter.rb:13:in new'
/Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/sqlite3_adapter.rb:13:in `initialize'

-- C level backtrace information -------------------------------------------
0 libruby.1.9.1.dylib 0x000000010018a5a2 rb_vm_bugreport + 210
1 libruby.1.9.1.dylib 0x0000000100045c04 report_bug + 372
2 libruby.1.9.1.dylib 0x0000000100045dc8 rb_bug + 200
3 libruby.1.9.1.dylib 0x0000000100047866 rb_check_type + 166
4 sqlite3_native.bundle 0x00000001007ec8e7 initialize + 39
5 libruby.1.9.1.dylib 0x000000010017c159 vm_call0 + 601
6 libruby.1.9.1.dylib 0x000000010017f04e rb_funcall2 + 350
7 libruby.1.9.1.dylib 0x000000010009abe3 rb_class_new_instance + 51
8 libruby.1.9.1.dylib 0x000000010016ffe7 vm_call_method + 983
9 libruby.1.9.1.dylib 0x0000000100172d85 vm_exec_core + 8309
10 libruby.1.9.1.dylib 0x000000010017aa13 vm_exec + 1507
11 libruby.1.9.1.dylib 0x0000000100181ad8 loop_i + 56
12 libruby.1.9.1.dylib 0x000000010004ad67 rb_rescue2 + 519
13 libruby.1.9.1.dylib 0x000000010016ca46 rb_f_loop + 54
14 libruby.1.9.1.dylib 0x000000010016ffe7 vm_call_method + 983
15 libruby.1.9.1.dylib 0x0000000100172d85 vm_exec_core + 8309
16 libruby.1.9.1.dylib 0x000000010017aa13 vm_exec + 1507
17 libruby.1.9.1.dylib 0x000000010017c3f2 vm_call0 + 1266
18 libruby.1.9.1.dylib 0x00000001001864b1 vm_method_missing + 481
19 libruby.1.9.1.dylib 0x0000000100170403 vm_call_method + 2035
20 libruby.1.9.1.dylib 0x0000000100172d85 vm_exec_core + 8309
21 libruby.1.9.1.dylib 0x000000010017aa13 vm_exec + 1507
22 libruby.1.9.1.dylib 0x000000010017bd4a rb_vm_invoke_proc + 842
23 libruby.1.9.1.dylib 0x0000000100192045 thread_start_func_2 + 1669
24 libruby.1.9.1.dylib 0x00000001001921dd thread_start_func_1 + 29
25 libSystem.B.dylib 0x00007fff8575c8b6 _pthread_start + 331
26 libSystem.B.dylib 0x00007fff8575c769 thread_start + 13

[NOTE]
You may have encountered a bug in the Ruby interpreter or extension libraries.
Bug reports are welcome.
For details: http://www.ruby-lang.org/bugreport.html

Abort trap
saturn:new hubble$

See the Rails Lighthouse ticket for additional comments
https://rails.lighthouseapp.com/projects/8994-ruby-on-rails/tickets/4815
=end

[naruse (Yui NARUSE)]

=begin
What your version of sqlite3-ruby?
sqlite3-ruby 1.3.0 is required for Ruby 1.9
=end

[joemsak (Joe Sak)]

=begin
I am using sqlite3-ruby 1.3.0

$ bundle show sqlite3-ruby
/Users/hubble/.rvm/gems/ruby-1.8.7-head/gems/sqlite3-ruby-1.3.0

I have confirmed that my app works with Rails beta4 and Ruby 1.8.7, by the way
=end

[luislavena (Luis Lavena)]

=begin
Hello,

Can you tell us which version of SQLite3 you're linking with?

Seems you're using an old OSX version (10.3) which might have problems with the set of features sqlite3-ruby 1.3.0 uses, specially in statement release and could be affected only under 1.9.x

=end

[mame (Yusuke Endoh)]

• Status changed from Open to Feedback
• Priority changed from Normal to 3

=begin
Possibly third party's issue. Downgraded to Low-priority.
Please inform us if you find anything indicating ruby core's bug.
Thanks.

--
Yusuke Endoh [e-mail]
=end

[joemsak (Joe Sak)]

=begin
I will certainly report back to you on my version of sqlite3 and whether an upgrade helps

Thanks for the quick responses, all. Sorry if this is a waste of time
=end

[tenderlovemaking (Aaron Patterson)]

• Assignee set to tenderlovemaking (Aaron Patterson)

=begin

=end

[joemsak (Joe Sak)]

=begin
I am on Snow Leopard (10.6.3) with:

sqlite3 3.6.12

ruby 1.9.2dev (2010-05-31 revision 28117) [x86_64-darwin10.3.0]

Rails 3.0.0.beta4 (in bundler)

=end

[joemsak (Joe Sak)]

=begin
I fixed it by reformatting my computer and starting from scratch. Don't know what the problem was, but it's gone now.
=end

[tenderlovemaking (Aaron Patterson)]

• Status changed from Feedback to Rejected

=begin
Closing. I believe this was a problem with the system setup.
=end