This project is archived and is in readonly mode.

#4815 ✓invalid
Joseph Sak

Possible bug in ActiveRecord beta4 sqlite3_adapter / sqlite3

Reported by Joseph Sak | June 9th, 2010 @ 10:37 PM | in 3.0.2

From a fresh beta4 app, when I switch root to 'posts#index' (a scaffolded model) and try to load the home page in my browser, the server crashes and shuts off with this text:

/Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/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:0048 p:---- s:0245 b:0245 l:000244 d:000244 CFUNC :initialize
c:0047 p:---- s:0243 b:0243 l:000242 d:000242 CFUNC :new
c:0046 p:0082 s:0238 b:0238 l:000237 d:000237 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/lib/active_record/connection_adapters/sqlite3_adapter
c:0045 p:0045 s:0233 b:0233 l:000232 d:000232 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/lib/active_record/connection_adapters/abstract/connec
c:0044 p:0011 s:0230 b:0230 l:000229 d:000229 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/lib/active_record/connection_adapters/abstract/connec
c:0043 p:0048 s:0226 b:0226 l:000212 d:000225 BLOCK /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/lib/active_record/connection_adapters/abstract/connec
c:0042 p:---- s:0223 b:0223 l:000222 d:000222 FINISH
c:0041 p:---- s:0221 b:0221 l:000220 d:000220 CFUNC :loop
c:0040 p:0009 s:0218 b:0218 l:000212 d:000217 BLOCK /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/lib/active_record/connection_adapters/abstract/connec
c:0039 p:0019 s:0216 b:0216 l:000215 d:000215 METHOD /Users/hubble/.rvm/rubies/ruby-1.9.2-preview3/lib/ruby/1.9.1/monitor.rb:201
c:0038 p:0013 s:0213 b:0213 l:000212 d:000212 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/lib/active_record/connection_adapters/abstract/connec
c:0037 p:0047 s:0210 b:0207 l:000206 d:000206 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/lib/active_record/connection_adapters/abstract/connec
c:0036 p:0033 s:0203 b:0203 l:000202 d:000202 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/lib/active_record/connection_adapters/abstract/connec
c:0035 p:0018 s:0198 b:0198 l:000197 d:000197 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/lib/active_record/connection_adapters/abstract/connec
c:0034 p:0011 s:0195 b:0195 l:000194 d:000194 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/lib/active_record/connection_adapters/abstract/connec
c:0033 p:0043 s:0192 b:0192 l:000191 d:000191 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/lib/active_record/query_cache.rb:11
c:0032 p:0019 s:0188 b:0188 l:0007b0 d:0007b0 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/lib/active_record/query_cache.rb:30
c:0031 p:0015 s:0184 b:0184 l:000183 d:000183 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/lib/active_record/connection_adapters/abstract/connec
c:0030 p:0093 s:0180 b:0180 l:000179 d:000179 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta3/lib/action_dispatch/middleware/head.rb:14
c:0029 p:0155 s:0173 b:0173 l:000172 d:000172 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/methodoverride.rb:24
c:0028 p:0046 s:0167 b:0167 l:000166 d:000166 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta3/lib/action_dispatch/middleware/params_parser.rb:19
c:0027 p:0054 s:0162 b:0162 l:000161 d:000161 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta3/lib/action_dispatch/middleware/flash.rb:167
c:0026 p:0088 s:0156 b:0156 l:000155 d:000155 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta3/lib/action_dispatch/middleware/session/cookie_store.rb:
c:0025 p:0015 s:0146 b:0146 l:000145 d:000145 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta3/lib/action_dispatch/middleware/cookies.rb:202
c:0024 p:0031 s:0137 b:0137 l:001540 d:000136 BLOCK /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta3/lib/action_dispatch/middleware/callbacks.rb:46
c:0023 p:0210 s:0135 b:0135 l:000134 d:000134 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activesupport-3.0.0.beta3/lib/active_support/callbacks.rb:410
c:0022 p:0024 s:0125 b:0125 l:000124 d:000124 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activesupport-3.0.0.beta3/lib/active_support/callbacks.rb:88
c:0021 p:0013 s:0119 b:0119 l:001540 d:001540 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta3/lib/action_dispatch/middleware/callbacks.rb:44
c:0020 p:0015 s:0115 b:0115 l:000114 d:000114 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/sendfile.rb:105
c:0019 p:0049 s:0105 b:0105 l:000104 d:000104 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta3/lib/action_dispatch/middleware/remote_ip.rb:48
c:0018 p:0015 s:0101 b:0101 l:000100 d:000100 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta3/lib/action_dispatch/middleware/show_exceptions.rb:48
c:0017 p:0027 s:0096 b:0096 l:000095 d:000095 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/railties-3.0.0.beta3/lib/rails/rack/logger.rb:13
c:0016 p:0032 s:0092 b:0092 l:000091 d:000091 METHOD /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/runtime.rb:17
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.beta3/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.beta3/lib/rails/application.rb:132
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.beta3/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.beta3/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:001738 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:inrun' /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:inservice' /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.beta3/lib/rails/rack/log_tailer.rb:15:incall' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/railties-3.0.0.beta3/lib/rails/application.rb:81:in method_missing' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/railties-3.0.0.beta3/lib/rails/application.rb:132:incall' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta3/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:incall' <internal:prelude>:10:in synchronize'<br/> /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/lock.rb:11:inblock 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.beta3/lib/rails/rack/logger.rb:13:incall' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta3/lib/action_dispatch/middleware/show_exceptions.rb:48:in call' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta3/lib/action_dispatch/middleware/remote_ip.rb:48:incall' /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.beta3/lib/action_dispatch/middleware/callbacks.rb:44:incall' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activesupport-3.0.0.beta3/lib/active_support/callbacks.rb:88:in run_callbacks' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activesupport-3.0.0.beta3/lib/active_support/callbacks.rb:410:in_run_call_callbacks' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta3/lib/action_dispatch/middleware/callbacks.rb:46:in block in call' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta3/lib/action_dispatch/middleware/cookies.rb:202:incall' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta3/lib/action_dispatch/middleware/session/cookie_store.rb:107:in call' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta3/lib/action_dispatch/middleware/flash.rb:167:incall' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta3/lib/action_dispatch/middleware/params_parser.rb:19:in call' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/methodoverride.rb:24:incall' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta3/lib/action_dispatch/middleware/head.rb:14:in call' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/lib/active_record/connection_adapters/abstract/connection_pool.rb:365:incall' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/lib/active_record/query_cache.rb:30:in call' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/lib/active_record/query_cache.rb:11:incache' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/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.beta3/lib/active_record/connection_adapters/abstract/connection_specification.rb:103:inretrieve_connection' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/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.beta3/lib/active_record/connection_adapters/abstract/connection_pool.rb:99:inconnection' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/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:inmon_synchronize' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/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.beta3/lib/active_record/connection_adapters/abstract/connection_pool.rb:186:inloop' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/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.beta3/lib/active_record/connection_adapters/abstract/connection_pool.rb:248:incheckout_new_connection' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/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.beta3/lib/active_record/connection_adapters/sqlite3_adapter.rb:13:insqlite3_connection' /Users/hubble/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta3/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.beta3/lib/active_record/connection_adapters/sqlite3_adapter.rb:13:ininitialize'

-- 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 0x0000000101f3a8e7 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

Comments and changes to this ticket

  • Joseph Sak

    Joseph Sak June 9th, 2010 @ 10:38 PM

    • Tag changed from rails 3.0.0.beta4, sqlite3, sqlite3_adapter to activerecord 3.0, rails 3.0.0.beta4, sqlite3, sqlite3_adapter
  • Joseph Sak

    Joseph Sak June 9th, 2010 @ 10:42 PM

    I'm using Ruby 1.9.2-preview3

    On rails beta3, I did not have any problems.

  • Joseph Sak

    Joseph Sak June 9th, 2010 @ 10:59 PM

    I have confirmed that this is NOT an issue in Ruby 1.8.7-head

  • Joseph Sak

    Joseph Sak June 9th, 2010 @ 11:07 PM

    I have also reported this to the Ruby 1.9 team:
    http://redmine.ruby-lang.org/issues/show/3419

    thanks

  • Rohit Arondekar

    Rohit Arondekar June 11th, 2010 @ 10:25 AM

    • Assigned user set to “Rizwan Reza”

    Cannot reproduce on Rails master and 1.9.2-head (ruby 1.9.2dev (2010-06-06 revision 28184))

    Maybe it was fixed in the 1.9.2 branch?

    Even if the issue remains, it looks like a Ruby issue, so can this ticket be closed?

  • José Valim

    José Valim June 11th, 2010 @ 11:29 AM

    • Milestone cleared.
    • Assigned user changed from “Rizwan Reza” to “Aaron Patterson”

    This needs further investigation but you may be running on an old sqlite3 version. Have you tried using the latest version?

  • Joseph Sak

    Joseph Sak June 11th, 2010 @ 06:11 PM

    Ruby 1.9 team is asking the same thing

    I will upgrade when I am home and report back.

    Thanks for the quick responses, and I apologize if this turns out to be nothing more than user-error

  • Aaron Patterson
  • Joseph Sak

    Joseph Sak June 15th, 2010 @ 04:17 AM

    I am on Snow Leopard (10.6.3) with:

    sqlite3 3.6.17

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

    Rails 3.0.0.beta4 (in bundler)

    sqlite3-ruby 1.3.0

  • Aaron Patterson

    Aaron Patterson June 15th, 2010 @ 04:23 AM

    Could you possibly push the rails project to github? That would help me to reproduce the error.

  • Joseph Sak
  • Aaron Patterson

    Aaron Patterson June 15th, 2010 @ 05:42 AM

    Awesome, thanks for pushing this to github.

    I can't seem to reproduce this problem, so lets do a bit of investigative work.

    Why are you running sqlite3 version 3.6.17? Where did you get that version? Snow Leopard ships with 3.6.12, and macports seems to be at 3.6.23.1.

    Next, from your testapp root, can you show me the output of this command:

    $ otool -L `bundle show sqlite3-ruby`/lib/sqlite3/sqlite3_native.bundle
    

    Next, from your testapp root, are you able to do this without crashing in irb?

    $ bundle console
    irb(main):001:0> require 'sqlite3'
    => false
    irb(main):002:0> SQLite3::Database.new('db/development.sqlite3')
    => #<SQLite3::Database:0x000001019bbac0>
    irb(main):003:0>
    

    Let me know how that goes, and thanks for reporting this.

  • Joseph Sak

    Joseph Sak June 15th, 2010 @ 06:25 AM

    sqlite3 version

    port install sqlite3 gave me .17

    otool output:

    /Users/hubble/.rvm/gems/ruby-1.8.7-head/gems/sqlite3-ruby-1.3.0/lib/sqlite3/sqlite3_native.bundle:

    /Users/hubble/.rvm/rubies/ruby-1.8.7-head/lib/libruby.dylib (compatibility version 1.8.0, current version 1.8.7)
    /usr/lib/libsqlite3.dylib (compatibility version 9.0.0, current version 9.6.0)
    /usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 125.0.1)
    /usr/lib/libobjc.A.dylib (compatibility version 1.0.0, current version 227.0.0)
    

    bundle console

    yes:

    $ bundle console ruby-1.8.7-head > require 'sqlite3'
    => false ruby-1.8.7-head > SQLite3::Database.new('db/development.sqlite3')
    => #<SQLite3::Database:0x1018cf710> ruby-1.8.7-head >

  • Aaron Patterson

    Aaron Patterson June 15th, 2010 @ 04:30 PM

    Cool, thanks for the info.

    You were seeing this error when running ruby 1.9, right? Is your bundled sqlite3-ruby gem possibly linked against 1.8 yet you're using 1.9?

    Could you try rerunning those commands, but while you're using 1.9? Thanks.

  • Joseph Sak

    Joseph Sak June 15th, 2010 @ 04:49 PM

    No problem, Aaron. I'm at work until the evening, I will report back tonight

  • Aaron Patterson
  • Joseph Sak

    Joseph Sak June 17th, 2010 @ 06:04 PM

    I feel like an ass for not being more on top of this. Summers in Chicago don't make for much at-home time especially when you have company for the week.

    I had to reformat my computer because it's just so messed up from 3 years of my punishment on it.

    I'm sorry I haven't reported back very well. No updates yet. I will update you, I promise. Until then, this seems like a very low priority issue anyway. I'm sure it's a problem with my computer and not rails. Maybe ruby, but probably not rails.

  • Joseph Sak

    Joseph Sak June 18th, 2010 @ 03:46 PM

    AND FINALLY

    After a reformat

    RVM install, Bundler install, rails 3 beta 4, sqlite3 3.6.12, ruby 1.9.2-preview3

    everything works. Don't know what the bug was but it's pretty true that my computer was messed.

    Thanks for your patience, sorry this is nothing.

  • Aaron Patterson

    Aaron Patterson June 18th, 2010 @ 04:11 PM

    • State changed from “new” to “invalid”

    No problem. Glad I could help, even though I didn't do much. ;-)

  • David Sedeño

    David Sedeño June 22nd, 2010 @ 09:21 AM

    I have the same problem but with mysql adapter. ruby 1.9.2-preview3, rails beta4


    => 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-22 10:09:18] INFO WEBrick 1.3.1 [2010-06-22 10:09:18] INFO ruby 1.9.2 (2010-05-31) [i686-linux] [2010-06-22 10:09:18] INFO WEBrick::HTTPServer#start: pid=30031 port=3000 /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/mysql_adapter.rb:597: [BUG] unknown type 0x22 (0xc given) ruby 1.9.2dev (2010-05-31 revision 28117) [i686-linux]

    -- control frame ---------- c:0046 p:---- s:0240 b:0240 l:000239 d:000239 CFUNC :real_connect
    c:0045 p:0235 s:0230 b:0230 l:000229 d:000229 METHOD /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/mysql_adapter.rb:
    c:0044 p:0048 s:0226 b:0226 l:000225 d:000225 METHOD /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/mysql_adapter.rb:
    c:0043 p:---- s:0219 b:0219 l:000218 d:000218 FINISH
    c:0042 p:---- s:0217 b:0217 l:000216 d:000216 CFUNC :new
    c:0041 p:0339 s:0210 b:0210 l:000209 d:000209 METHOD /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/mysql_adapter.rb:
    c:0040 p:0045 s:0197 b:0197 l:000196 d:000196 METHOD /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connecti
    c:0039 p:0011 s:0194 b:0194 l:000193 d:000193 METHOD /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connecti
    c:0038 p:0048 s:0190 b:0190 l:000176 d:000189 BLOCK /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connecti
    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 /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connecti
    c:0034 p:0019 s:0180 b:0180 l:000179 d:000179 METHOD /home/david/.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 /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connecti
    c:0032 p:0047 s:0174 b:0171 l:000170 d:000170 METHOD /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connecti
    c:0031 p:0033 s:0167 b:0167 l:000166 d:000166 METHOD /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connecti
    c:0030 p:0018 s:0162 b:0162 l:000161 d:000161 METHOD /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connecti
    c:0029 p:0011 s:0159 b:0159 l:000158 d:000158 METHOD /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connecti
    c:0028 p:0043 s:0156 b:0156 l:000155 d:000155 METHOD /home/david/.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:0001b8 d:0001b8 METHOD /home/david/.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 /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connecti
    c:0025 p:0031 s:0144 b:0144 l:0009d8 d:000143 BLOCK /home/david/.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 /home/david/.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 /home/david/.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:0009d8 d:0009d8 METHOD /home/david/.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 /home/david/.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 /home/david/.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 /home/david/.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 /home/david/.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 /home/david/.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 /home/david/.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 /home/david/.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 /home/david/.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 /home/david/.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 /home/david/.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 /home/david/.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 /home/david/.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 /home/david/.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 /home/david/.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 /home/david/.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 /home/david/.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:001024 d:000008 BLOCK /home/david/.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 ---------------------------------------- /home/david/.rvm/rubies/ruby-1.9.2-preview3/lib/ruby/1.9.1/webrick/server.rb:183:in block in start_thread' /home/david/.rvm/rubies/ruby-1.9.2-preview3/lib/ruby/1.9.1/webrick/httpserver.rb:70:inrun' /home/david/.rvm/rubies/ruby-1.9.2-preview3/lib/ruby/1.9.1/webrick/httpserver.rb:111:in service' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/handler/webrick.rb:48:inservice' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/content_length.rb:13:in call' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/railties-3.0.0.beta4/lib/rails/rack/log_tailer.rb:15:incall' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/railties-3.0.0.beta4/lib/rails/application.rb:81:in method_missing' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/railties-3.0.0.beta4/lib/rails/application.rb:145:incall' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta4/lib/action_dispatch/middleware/static.rb:30:in call' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/lock.rb:11:incall' <internal:prelude>:10:in synchronize'<br/> /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/lock.rb:11:inblock in call' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activesupport-3.0.0.beta4/lib/active_support/cache/strategy/local_cache.rb:72:in call' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/runtime.rb:17:incall' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/railties-3.0.0.beta4/lib/rails/rack/logger.rb:14:in call' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta4/lib/action_dispatch/middleware/show_exceptions.rb:48:incall' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta4/lib/action_dispatch/middleware/remote_ip.rb:48:in call' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/rack-1.1.0/lib/rack/sendfile.rb:105:incall' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta4/lib/action_dispatch/middleware/callbacks.rb:44:in call' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activesupport-3.0.0.beta4/lib/active_support/callbacks.rb:88:inrun_callbacks' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activesupport-3.0.0.beta4/lib/active_support/callbacks.rb:414:in _run_call_callbacks' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/actionpack-3.0.0.beta4/lib/action_dispatch/middleware/callbacks.rb:46:inblock in call' /home/david/.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' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/query_cache.rb:30:incall' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/query_cache.rb:11:in cache' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_specification.rb:95:inconnection' /home/david/.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' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:330:inretrieve_connection' /home/david/.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' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:185:incheckout' /home/david/.rvm/rubies/ruby-1.9.2-preview3/lib/ruby/1.9.1/monitor.rb:201:in mon_synchronize' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:186:inblock in checkout' /home/david/.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' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:190:inblock (2 levels) in checkout' /home/david/.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' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/abstract/connection_pool.rb:226:innew_connection' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/mysql_adapter.rb:35:in mysql_connection' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/mysql_adapter.rb:35:innew' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/mysql_adapter.rb:163:in initialize' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/mysql_adapter.rb:597:inconnect' /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/activerecord-3.0.0.beta4/lib/active_record/connection_adapters/mysql_adapter.rb:597:in real_connect'

    -- C level backtrace information ------------------------------------------- /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby(rb_vm_bugreport+0xbd) [0x816f9fd] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x81af991] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby(rb_bug+0x28) [0x81afa28] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby(rb_check_type+0xce) [0x81b0ace] /home/david/.rvm/gems/ruby-1.9.2-preview3/gems/mysql-2.8.1/lib/mysql_api.so [0xb6e9158d] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x815a58d] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x8162802] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x8163f14] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x81695c4] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x815fb52] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby(rb_obj_call_init+0x42) [0x805dca2] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby(rb_class_new_instance+0x2a) [0x8099e9a] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x815a58d] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x8162802] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x8163f14] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x81695c4] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x816b1bd] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby(rb_rescue2+0x141) [0x805dec1] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x815b394] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x8162802] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x8163f14] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x81695c4] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x815fb52] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x816224a] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x81626b3] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x8163f14] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x81695c4] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby(rb_vm_invoke_proc+0x76) [0x8169db6] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x81767e5] /home/david/.rvm/rubies/ruby-1.9.2-preview3/bin/ruby [0x81768ce] /lib/tls/i686/cmov/libpthread.so.0 [0xb76f94ff] /lib/tls/i686/cmov/libc.so.6(clone+0x5e) [0xb760e5ee]

    [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

  • Jeremy Kemper

    Jeremy Kemper October 15th, 2010 @ 11:01 PM

    • Milestone set to 3.0.2
    • Importance changed from “” to “High”

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

<h2 style="font-size: 14px">Tickets have moved to Github</h2>

The new ticket tracker is available at <a href="https://github.com/rails/rails/issues">https://github.com/rails/rails/issues</a>

Pages