 |
Forums |
Admin Discussion Forums: help Start New Thread
By: Alex Roev
 RE: frequent crashes on Win 2008 Server R2 x64 [ reply ]
2012-01-11 18:15
|
While following the steps, I have found out that SQL*Plus did not work fine. In fact, it also frequently crashed at start. I have uninstalled the client I used (XE client 10), and installed the latest instant client (11). Everything seems to work correctly now. I will do more testing a bit later.
By the way, the output indeed ended with "-- C level backtrace information ----", but it looked like the execution did not end - there was no option to input something into command line - just like the program did not return.
So, the problem seems to be solved at the moment, but do you still need minidump or any other information? I have reproduced the situation on a virtual machine, so I can take minidump if it can be useful in any way.
|
By: Kubo Takehiro
RE: frequent crashes on Win 2008 Server R2 x64 [ reply ]
2012-01-10 21:53
|
1. Does the backtrace end with the line "-- C level backtrace information ----"? No more lines?
2. Does sqlplus work fine?
3. What type of Oracle client do you use? Instant client or full client?
4. What varsion of Oracle client do you use?
Post the output of "sqlplus -v".
5. Could you make a minidump and send it to me?
5.1. Download http://www.jiubao.org/tmp/windump_191.so and copy it to "c:/Ruby19/lib/ruby/gems/1.9.1/gems/ruby-oci8-2.1.0-x86-mingw32/lib/".
5.2. add "require 'windump_191'" at the head of
"c:/Ruby19/lib/ruby/gems/1.9.1/gems/ruby-oci8-2.1.0-x86-mingw32/lib/oci8.rb".
5.3. run "bundle exec rake db:seed" until it is stopped by a segmentation fault
5.4. A dump file "minidump.dmp" is created at the current working directory.
5.5. Check the inside of the dump not to contain sensitive data such as password.
5.6. Send the dump to kubo@jiubao.org. />
|
By: Alex Roev
frequent crashes on Win 2008 Server R2 x64 [ reply ]
2012-01-10 11:45
|
Hello.
I am working with oracle in Windows 2008 server R2 x64. The necessary condition is that my ruby app runs on the same machine and system.
I frequently get segmentation faults that, as far as I understand are caused by ruby-oci8. At the moment I am getting constant crashes while tryin to use rake db:seed, but their occurences are not limited to this case.
Is there some way to get rid of the crashes? I've tried ruby-oci8 2.0.4 and 2.1.0. The symptoms seem to be the same for these versions.
I am using ruby 1.9.3p0.
Thank you in advance.
Attached crash log:
c:\server>bundle exec rake db:seed
c:/Ruby19/lib/ruby/gems/1.9.1/gems/ruby-oci8-2.1.0-x86-mingw32/lib/oci8lib_191.s
o: [BUG] Segmentation fault
ruby 1.9.3p0 (2011-10-30) [i386-mingw32]
-- Control frame information -----------------------------------------------
c:0075 p:-14546790 s:0252 b:0252 l:000251 d:000251 TOP
c:0074 p:---- s:0250 b:0250 l:000249 d:000249 CFUNC :require
c:0073 p:0012 s:0246 b:0246 l:000230 d:000245 BLOCK c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:239
c:0072 p:0005 s:0244 b:0244 l:000235 d:000243 BLOCK c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:225
c:0071 p:0045 s:0242 b:0242 l:000241 d:000241 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:596
c:0070 p:0041 s:0236 b:0236 l:000235 d:000235 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:225
c:0069 p:0013 s:0231 b:0231 l:000230 d:000230 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:239
c:0068 p:0277 s:0226 b:0226 l:000225 d:000225 TOP c:/Ruby19/lib/ruby/gems/1.9
.1/gems/ruby-oci8-2.1.0-x86-mingw32/lib/oci8.rb:43
c:0067 p:---- s:0221 b:0221 l:000220 d:000220 FINISH
c:0066 p:---- s:0219 b:0219 l:000218 d:000218 CFUNC :require
c:0065 p:0012 s:0215 b:0215 l:000199 d:000214 BLOCK c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:239
c:0064 p:0005 s:0213 b:0213 l:000204 d:000212 BLOCK c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:225
c:0063 p:0045 s:0211 b:0211 l:000210 d:000210 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:596
c:0062 p:0041 s:0205 b:0205 l:000204 d:000204 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:225
c:0061 p:0013 s:0200 b:0200 l:000199 d:000199 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:239
c:0060 p:0025 s:0195 b:0195 l:000194 d:000194 TOP c:/server/vendor/gems/oracl
e-enhanced/lib/active_record/connection_adapters/oracle_enhanced_oci_connection.
rb:4
c:0059 p:---- s:0191 b:0191 l:000190 d:000190 FINISH
c:0058 p:---- s:0189 b:0189 l:000188 d:000188 CFUNC :require
c:0057 p:0012 s:0185 b:0185 l:000169 d:000184 BLOCK c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:239
c:0056 p:0005 s:0183 b:0183 l:000174 d:000182 BLOCK c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:225
c:0055 p:0045 s:0181 b:0181 l:000180 d:000180 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:596
c:0054 p:0041 s:0175 b:0175 l:000174 d:000174 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:225
c:0053 p:0013 s:0170 b:0170 l:000169 d:000169 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:239
c:0052 p:0056 s:0165 b:0165 l:000164 d:000164 TOP c:/server/vendor/gems/oracl
e-enhanced/lib/active_record/connection_adapters/oracle_enhanced_connection.rb:1
12
c:0051 p:---- s:0163 b:0163 l:000162 d:000162 FINISH
c:0050 p:---- s:0161 b:0161 l:000160 d:000160 CFUNC :require
c:0049 p:0012 s:0157 b:0157 l:000141 d:000156 BLOCK c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:239
c:0048 p:0005 s:0155 b:0155 l:000146 d:000154 BLOCK c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:225
c:0047 p:0045 s:0153 b:0153 l:000152 d:000152 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:596
c:0046 p:0041 s:0147 b:0147 l:000146 d:000146 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:225
c:0045 p:0013 s:0142 b:0142 l:000141 d:000141 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:239
c:0044 p:0058 s:0137 b:0137 l:000136 d:000136 TOP c:/server/vendor/gems/oracl
e-enhanced/lib/active_record/connection_adapters/oracle_enhanced_adapter.rb:36
c:0043 p:---- s:0135 b:0135 l:000134 d:000134 FINISH
c:0042 p:---- s:0133 b:0133 l:000132 d:000132 CFUNC :require
c:0041 p:0012 s:0129 b:0129 l:000113 d:000128 BLOCK c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:239
c:0040 p:0005 s:0127 b:0127 l:000118 d:000126 BLOCK c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:225
c:0039 p:0045 s:0125 b:0125 l:000124 d:000124 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:596
c:0038 p:0041 s:0119 b:0119 l:000118 d:000118 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:225
c:0037 p:0013 s:0114 b:0114 l:000113 d:000113 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/dependencies.rb:239
c:0036 p:0011 s:0109 b:0109 l:0020cc d:000108 BLOCK c:/server/vendor/gems/oracl
e-enhanced/lib/activerecord-oracle_enhanced-adapter.rb:12
c:0035 p:---- s:0107 b:0107 l:000106 d:000106 FINISH
c:0034 p:---- s:0105 b:0105 l:000104 d:000104 CFUNC :instance_eval
c:0033 p:0038 s:0102 b:0102 l:000101 d:000101 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/lazy_load_hooks.rb:36
c:0032 p:0035 s:0096 b:0096 l:000095 d:000095 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/activesupport-3.0.9/lib/active_support/lazy_load_hooks.rb:26
c:0031 p:0029 s:0089 b:0089 l:0020cc d:0020cc CLASS c:/server/vendor/gems/oracl
e-enhanced/lib/activerecord-oracle_enhanced-adapter.rb:11
c:0030 p:0022 s:0087 b:0087 l:000086 d:000086 CLASS c:/server/vendor/gems/oracl
e-enhanced/lib/activerecord-oracle_enhanced-adapter.rb:6
c:0029 p:0011 s:0085 b:0085 l:000084 d:000084 CLASS c:/server/vendor/gems/oracl
e-enhanced/lib/activerecord-oracle_enhanced-adapter.rb:5
c:0028 p:0038 s:0083 b:0083 l:000082 d:000082 TOP c:/server/vendor/gems/oracl
e-enhanced/lib/activerecord-oracle_enhanced-adapter.rb:4
c:0027 p:---- s:0081 b:0081 l:000080 d:000080 FINISH
c:0026 p:---- s:0079 b:0079 l:000078 d:000078 CFUNC :require
c:0025 p:0026 s:0075 b:0075 l:000056 d:000074 BLOCK c:/Ruby19/lib/ruby/gems/1.9
.1/gems/bundler-1.0.21/lib/bundler/runtime.rb:68
c:0024 p:---- s:0072 b:0072 l:000071 d:000071 FINISH
c:0023 p:---- s:0070 b:0070 l:000069 d:000069 CFUNC :each
c:0022 p:0091 s:0067 b:0067 l:000056 d:000066 BLOCK c:/Ruby19/lib/ruby/gems/1.9
.1/gems/bundler-1.0.21/lib/bundler/runtime.rb:66
c:0021 p:---- s:0062 b:0062 l:000061 d:000061 FINISH
c:0020 p:---- s:0060 b:0060 l:000059 d:000059 CFUNC :each
c:0019 p:0046 s:0057 b:0057 l:000056 d:000056 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/bundler-1.0.21/lib/bundler/runtime.rb:55
c:0018 p:0021 s:0053 b:0053 l:000052 d:000052 METHOD c:/Ruby19/lib/ruby/gems/1.9
.1/gems/bundler-1.0.21/lib/bundler.rb:122
c:0017 p:0079 s:0049 b:0049 l:000048 d:000048 TOP c:/server/config/applicatio
n.rb:8
c:0016 p:---- s:0047 b:0047 l:000046 d:000046 FINISH
c:0015 p:---- s:0045 b:0045 l:000044 d:000044 CFUNC :require
c:0014 p:0026 s:0041 b:0041 l:000040 d:000040 TOP c:/server/Rakefile:4
c:0013 p:---- s:0039 b:0039 l:000038 d:000038 FINISH
c:0012 p:---- s:0037 b:0037 l:000036 d:000036 CFUNC :load
c:0011 p:0013 s:0033 b:0033 l:000032 d:000032 METHOD c:/Ruby19/lib/ruby/1.9.1/ra
ke/rake_module.rb:25
c:0010 p:0274 s:0029 b:0029 l:000028 d:000028 METHOD c:/Ruby19/lib/ruby/1.9.1/ra
ke/application.rb:501
c:0009 p:0009 s:0024 b:0024 l:000017 d:000023 BLOCK c:/Ruby19/lib/ruby/1.9.1/ra
ke/application.rb:82
c:0008 p:0009 s:0022 b:0022 l:000021 d:000021 METHOD c:/Ruby19/lib/ruby/1.9.1/ra
ke/application.rb:133
c:0007 p:0011 s:0018 b:0018 l:000017 d:000017 METHOD c:/Ruby19/lib/ruby/1.9.1/ra
ke/application.rb:81
c:0006 p:0019 s:0015 b:0015 l:000008 d:000014 BLOCK c:/Ruby19/lib/ruby/1.9.1/ra
ke/application.rb:65
c:0005 p:0009 s:0013 b:0013 l:000012 d:000012 METHOD c:/Ruby19/lib/ruby/1.9.1/ra
ke/application.rb:133
c:0004 p:0011 s:0009 b:0009 l:000008 d:000008 METHOD c:/Ruby19/lib/ruby/1.9.1/ra
ke/application.rb:63
c:0003 p:0048 s:0006 b:0006 l:002134 d:001f24 EVAL c:/Ruby19/bin/rake:32
c:0002 p:---- s:0004 b:0004 l:000003 d:000003 FINISH
c:0001 p:0000 s:0002 b:0002 l:002134 d:002134 TOP
-- Ruby level backtrace information ----------------------------------------
c:/Ruby19/bin/rake:32:in `<main>'
c:/Ruby19/lib/ruby/1.9.1/rake/application.rb:63:in `run'
c:/Ruby19/lib/ruby/1.9.1/rake/application.rb:133:in `standard_exception_handling
'
c:/Ruby19/lib/ruby/1.9.1/rake/application.rb:65:in `block in run'
c:/Ruby19/lib/ruby/1.9.1/rake/application.rb:81:in `load_rakefile'
c:/Ruby19/lib/ruby/1.9.1/rake/application.rb:133:in `standard_exception_handling
'
c:/Ruby19/lib/ruby/1.9.1/rake/application.rb:82:in `block in load_rakefile'
c:/Ruby19/lib/ruby/1.9.1/rake/application.rb:501:in `raw_load_rakefile'
c:/Ruby19/lib/ruby/1.9.1/rake/rake_module.rb:25:in `load_rakefile'
c:/Ruby19/lib/ruby/1.9.1/rake/rake_module.rb:25:in `load'
c:/server/Rakefile:4:in `<top (required)>'
c:/server/Rakefile:4:in `require'
c:/server/config/application.rb:8:in `<top (required)>'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/bundler-1.0.21/lib/bundler.rb:122:in `require
'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/bundler-1.0.21/lib/bundler/runtime.rb:55:in `
require'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/bundler-1.0.21/lib/bundler/runtime.rb:55:in `
each'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/bundler-1.0.21/lib/bundler/runtime.rb:66:in `
block in require'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/bundler-1.0.21/lib/bundler/runtime.rb:66:in `
each'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/bundler-1.0.21/lib/bundler/runtime.rb:68:in `
block (2 levels) in require'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/bundler-1.0.21/lib/bundler/runtime.rb:68:in `
require'
c:/server/vendor/gems/oracle-enhanced/lib/activerecord-oracle_enhanced-adapter.r
b:4:in `<top (required)>'
c:/server/vendor/gems/oracle-enhanced/lib/activerecord-oracle_enhanced-adapter.r
b:5:in `<module:ActiveRecord>'
c:/server/vendor/gems/oracle-enhanced/lib/activerecord-oracle_enhanced-adapter.r
b:6:in `<module:ConnectionAdapters>'
c:/server/vendor/gems/oracle-enhanced/lib/activerecord-oracle_enhanced-adapter.r
b:11:in `<class:OracleEnhancedRailtie>'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/lazy_l
oad_hooks.rb:26:in `on_load'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/lazy_l
oad_hooks.rb:36:in `execute_hook'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/lazy_l
oad_hooks.rb:36:in `instance_eval'
c:/server/vendor/gems/oracle-enhanced/lib/activerecord-oracle_enhanced-adapter.r
b:12:in `block in <class:OracleEnhancedRailtie>'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:239:in `require'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:225:in `load_dependency'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:596:in `new_constants_in'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:225:in `block in load_dependency'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:239:in `block in require'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:239:in `require'
c:/server/vendor/gems/oracle-enhanced/lib/active_record/connection_adapters/orac
le_enhanced_adapter.rb:36:in `<top (required)>'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:239:in `require'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:225:in `load_dependency'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:596:in `new_constants_in'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:225:in `block in load_dependency'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:239:in `block in require'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:239:in `require'
c:/server/vendor/gems/oracle-enhanced/lib/active_record/connection_adapters/orac
le_enhanced_connection.rb:112:in `<top (required)>'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:239:in `require'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:225:in `load_dependency'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:596:in `new_constants_in'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:225:in `block in load_dependency'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:239:in `block in require'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:239:in `require'
c:/server/vendor/gems/oracle-enhanced/lib/active_record/connection_adapters/orac
le_enhanced_oci_connection.rb:4:in `<top (required)>'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:239:in `require'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:225:in `load_dependency'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:596:in `new_constants_in'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:225:in `block in load_dependency'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:239:in `block in require'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:239:in `require'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/ruby-oci8-2.1.0-x86-mingw32/lib/oci8.rb:43:in
`<top (required)>'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:239:in `require'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:225:in `load_dependency'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:596:in `new_constants_in'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:225:in `block in load_dependency'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:239:in `block in require'
c:/Ruby19/lib/ruby/gems/1.9.1/gems/activesupport-3.0.9/lib/active_support/depend
encies.rb:239:in `require'
-- C level backtrace information -------------------------------------------
|
|
|
