ruby-dev

Issue #5175 has been updated by Shota Fukumori.

Status changed from Open to Feedback

ping?
----------------------------------------
Bug #5175: Ruby1.9.2p290　MySQLアクセスエラー
http://redmine.ruby-lang.org/issues/5175

Author: eiichi maekawa
Status: Feedback
Priority: Normal
Assignee: 
Category: 
Target version: 1.9.2
ruby -v: ruby 1.9.2p290 (2011-07-09) [i386-mingw32]


下記エラーは、RUBY1.9.2p180mingw、Ruby1.8.7p334mingwでは、生じません。
MySQL関連gemインストール
D:\>pik list
  187: ruby 1.8.7 (2010-12-23 patchlevel 330) [i386-mswin32]
  187: ruby 1.8.7 (2011-02-18 patchlevel 334) [i386-mingw32]
  187: ruby 1.8.7 (2011-06-30 patchlevel 352) [i386-mingw32]
  192: ruby 1.9.2p136 (2010-12-25 revision 30365) [i386-mswin32]
  192: ruby 1.9.2p180 (2011-02-18) [i386-mingw32]
  192: ruby 1.9.2p290 (2011-07-09) [i386-mingw32]

D:\>pik sw 192 290

D:\>cd d:\Ruby192p290

D:\Ruby192p290>gem install dbi-0.4.5.gem --no-ri --no-rdoc --local
Successfully installed deprecated-2.0.1
Successfully installed dbi-0.4.5
2 gems installed

D:\Ruby192p290>

D:\Ruby192p290>ruby -v
ruby 1.9.2p290 (2011-07-09) [i386-mingw32]

D:\Ruby192p290>gem install dbd-mysql-0.4.4.gem --no-ri --no-rdoc --local
Successfully installed mysql-2.8.1-x86-mingw32
Successfully installed dbd-mysql-0.4.4
2 gems installed

実行結果
D:\Ruby192p290>cd D:\Apache2.2\htdocs\ruby_prg\em_ruby\em_db

D:\Apache2.2\htdocs\ruby_prg\em_ruby\em_db>ruby dbi_mysql_connect2.rb
D:/Ruby192p290/lib/ruby/gems/1.9.1/gems/deprecated-2.0.1/lib/deprecated.rb:199: warning: already initialized constant Deprecate
#<DBI::DatabaseHandle:0xb444d0>
#<DBI::StatementHandle:0xb441d0>
D:/Ruby192p290/lib/ruby/gems/1.9.1/gems/dbd-mysql-0.4.4/lib/dbd/mysql/statement.rb:130: [BUG] Segmentation fault
ruby 1.9.2p290 (2011-07-09) [i386-mingw32]

-- control frame ----------
c:0009 p:---- s:0035 b:0035 l:000034 d:000034 CFUNC  :fetch_fields
c:0008 p:0093 s:0032 b:0032 l:000031 d:000031 METHOD D:/Ruby192p290/lib/ruby/gems/1.9.1/gems/dbd-mysql-0.4.4/lib/dbd/mysql/statement.rb:130
c:0007 p:0040 s:0024 b:0024 l:000018 d:000023 BLOCK  D:/Ruby192p290/lib/ruby/gems/1.9.1/gems/dbd-mysql-0.4.4/lib/dbd/mysql/statement.rb:37
c:0006 p:0019 s:0022 b:0022 l:000021 d:000021 METHOD <internal:prelude>:10
c:0005 p:0029 s:0019 b:0019 l:000018 d:000018 METHOD D:/Ruby192p290/lib/ruby/gems/1.9.1/gems/dbd-mysql-0.4.4/lib/dbd/mysql/statement.rb:34
c:0004 p:0096 s:0014 b:0014 l:000013 d:000013 METHOD D:/Ruby192p290/lib/ruby/gems/1.9.1/gems/dbi-0.4.5/lib/dbi/handles/statement.rb:116
c:0003 p:0091 s:0010 b:0010 l:001f64 d:0024f4 EVAL   dbi_mysql_connect2.rb:16
c:0002 p:---- s:0004 b:0004 l:000003 d:000003 FINISH
c:0001 p:0000 s:0002 b:0002 l:001f64 d:001f64 TOP
---------------------------
-- Ruby level backtrace information ----------------------------------------
dbi_mysql_connect2.rb:16:in `<main>'
D:/Ruby192p290/lib/ruby/gems/1.9.1/gems/dbi-0.4.5/lib/dbi/handles/statement.rb:116:in `execute'
D:/Ruby192p290/lib/ruby/gems/1.9.1/gems/dbd-mysql-0.4.4/lib/dbd/mysql/statement.rb:34:in `execute'
<internal:prelude>:10:in `synchronize'
D:/Ruby192p290/lib/ruby/gems/1.9.1/gems/dbd-mysql-0.4.4/lib/dbd/mysql/statement.rb:37:in `block in execute'
D:/Ruby192p290/lib/ruby/gems/1.9.1/gems/dbd-mysql-0.4.4/lib/dbd/mysql/statement.rb:130:in `column_info'
D:/Ruby192p290/lib/ruby/gems/1.9.1/gems/dbd-mysql-0.4.4/lib/dbd/mysql/statement.rb:130:in `fetch_fields'

[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


This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.

同様にRuby1.8.7p352でもエラーとなります。
Mysql関連設定及び実行結果
============ MySQL セットアップ ================================

※　libmysql.dll (サイズ 2028KB)⇒bin\にコピーする

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

=========== dbd-mysql-0.4.3 をセットする=====================
D:\>cd ruby187p352

D:\Ruby187p352>cd dbd-mysql-0.4.3

D:\Ruby187p352\dbd-mysql-0.4.3>ruby setup.rb config
---> lib
---> lib/dbd
---> lib/dbd/mysql
<--- lib/dbd/mysql
<--- lib/dbd
<--- lib

D:\Ruby187p352\dbd-mysql-0.4.3>ruby setup.rb setup
---> lib
---> lib/dbd
---> lib/dbd/mysql
<--- lib/dbd/mysql
<--- lib/dbd
<--- lib

D:\Ruby187p352\dbd-mysql-0.4.3>ruby setup.rb install
rm -f InstalledFiles
---> lib
mkdir -p D:/Ruby187p352/lib/ruby/site_ruby/1.8
---> lib/dbd
mkdir -p D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbd
install Mysql.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbd
---> lib/dbd/mysql
mkdir -p D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbd/mysql
install database.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbd/mysql
install driver.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbd/mysql
install statement.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbd/mysql
<--- lib/dbd/mysql
<--- lib/dbd
<--- lib

D:\Ruby187p352\dbd-mysql-0.4.3>

===================== dbd-mysql-0.4.3 をセットする ====================
D:\Ruby187p352\dbd-mysql-0.4.3>cd ..

D:\Ruby187p352>cd dbi-0.4.3

D:\Ruby187p352\dbi-0.4.3>ruby setup.rb config
---> bin
<--- bin
---> lib
---> lib/dbi
---> lib/dbi/base_classes
<--- lib/dbi/base_classes
---> lib/dbi/handles
<--- lib/dbi/handles
---> lib/dbi/sql
<--- lib/dbi/sql
---> lib/dbi/utils
<--- lib/dbi/utils
<--- lib/dbi
<--- lib

D:\Ruby187p352\dbi-0.4.3>ruby setup.rb setup
---> bin
updating shebang: dbi
updating shebang: test_broken_dbi
<--- bin
---> lib
---> lib/dbi
---> lib/dbi/base_classes
<--- lib/dbi/base_classes
---> lib/dbi/handles
<--- lib/dbi/handles
---> lib/dbi/sql
<--- lib/dbi/sql
---> lib/dbi/utils
<--- lib/dbi/utils
<--- lib/dbi
<--- lib

D:\Ruby187p352\dbi-0.4.3>ruby setup.rb install
rm -f InstalledFiles
---> bin
mkdir -p D:/Ruby187p352/bin
install dbi D:/Ruby187p352/bin/
install test_broken_dbi D:/Ruby187p352/bin/
<--- bin
---> lib
mkdir -p D:/Ruby187p352/lib/ruby/site_ruby/1.8
install dbi.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/
---> lib/dbi
mkdir -p D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi
install base_classes.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi
install binary.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi
install columninfo.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi
install exceptions.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi
install handles.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi
install row.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi
install sql.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi
install sql_type_constants.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi
install trace.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi
install types.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi
install typeutil.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi
install utils.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi
---> lib/dbi/base_classes
mkdir -p D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi/base_classes
install database.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi/base_classes
install driver.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi/base_classes
install statement.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi/base_classes
<--- lib/dbi/base_classes
---> lib/dbi/handles
mkdir -p D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi/handles
install database.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi/handles
install driver.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi/handles
install statement.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi/handles
<--- lib/dbi/handles
---> lib/dbi/sql
mkdir -p D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi/sql
install preparedstatement.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi/sql
<--- lib/dbi/sql
---> lib/dbi/utils
mkdir -p D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi/utils
install date.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi/utils
install tableformatter.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi/utils
install time.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi/utils
install timestamp.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi/utils
install xmlformatter.rb D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi/utils
<--- lib/dbi/utils
<--- lib/dbi
<--- lib

D:\Ruby187p352\dbi-0.4.3>

========= MySQL関連のgemをインストールする =============================

D:\Ruby187p352\dbi-0.4.3>cd ..

D:\Ruby187p352>gem install deprecated-2.0.1.gem --no-ri --no-rdoc --local
Successfully installed deprecated-2.0.1
1 gem installed

D:\Ruby187p352>gem install mysql-2.8.1-x86-mswin32.gem --no-ri --no-rdoc --local
Successfully installed mysql-2.8.1-x86-mswin32
1 gem installed

D:\Ruby187p352>

+++++++++++++++++++++MySQLアクセス検証++エラー発生++++++++++++++++++++

D:\>cd D:\Apache2.2\htdocs\ruby_prg\em_ruby\em_db

D:\Apache2.2\htdocs\ruby_prg\em_ruby\em_db>ruby dbi_mysql_connect2.rb
D:/Ruby187p352/lib/ruby/gems/1.8/gems/deprecated-2.0.1/lib/deprecated.rb:199: warning: already initialized constant Deprecate
D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi.rb:318:in `load_driver': Could not load driver (Could not find driver Mysql or mysql (error: RubyGem version error: mysql(2.8.1 not >= 0) (DBI::InterfaceError)
))
        from D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi.rb:160:in `_get_full_driver'
        from D:/Ruby187p352/lib/ruby/site_ruby/1.8/dbi.rb:145:in `connect'
        from dbi_mysql_connect2.rb:6

D:\Apache2.2\htdocs\ruby_prg\em_ruby\em_db>ruby -v
ruby 1.8.7 (2011-06-30 patchlevel 352) [i386-mingw32]






-- 
http://redmine.ruby-lang.org

Thread

Prev Next

In This Thread

Prev Next

[#44287] [Ruby 1.9 - Bug #5127] ruby 1.9.3 prev1 で Array#[]=( Array.new ) が1.9.2より2倍遅い — Motohiro KOSAKI <kosaki.motohiro@...>

[#44288] [Ruby 1.9 - Bug #5127] ruby 1.9.3 prev1 で Array#[]=( Array.new ) が1.9.2より2倍遅い — Tomoyuki Chikanaga <nagachika00@...>

[#44289] [Ruby 1.9 - Feature #5128][Open] 日本語ドキュメントをUTF-8に — Shyouhei Urabe <shyouhei@...>

[#44303] [Ruby 1.9 - Bug #5132][Open] test_parallel.rb fail when it run before 'make install' — Ayumu AIZAWA <ayumu.aizawa@...>

[#44304] [Ruby 1.9 - Feature #5133][Open] Array#unzip as an alias of Array#transpose — Kenta Murata <muraken@...>

[#44314] [Ruby 1.9 - Bug #5136][Open] :"!".inspect の結果が1.9.3devと1.9.2とでは異なる — Ayumu AIZAWA <ayumu.aizawa@...>

[#44315] [Ruby 1.9 - Bug #5139][Open] sigsegv のスタックオーバフロー — Tomoyuki Chikanaga <nagachika00@...>

[#44318] [Ruby 1.9 - Feature #5142][Open] Remove ruby-mode.el from ruby's repo — Yui NARUSE <naruse@...>

[#44327] [Ruby 1.9 - Bug #5150][Open] Ruby-trunk Crashed in running test-rubyspec — Ayumu AIZAWA <ayumu.aizawa@...>

[#44329] [Ruby 1.9 - Bug #5151][Open] test/socket/test_socket.rb fail when udp connection failed — Ayumu AIZAWA <ayumu.aizawa@...>

[#44337] [Ruby 1.9 - Bug #5152][Open] TestDateNew#test_civil が GC.stress = true 下で Failure — Tomoyuki Chikanaga <nagachika00@...>

[#44342] [Ruby 1.9 - Bug #5155][Open] [BUG] pthread_cond_signal: Resource temporarily unavailable (EAGAIN) — Kenta Murata <muraken@...>

[#44355] [Ruby 1.9 - Bug #5159][Open] r32777のためSolaris上のgcc-4.4でCFLAGS="-std=gnu99"のときコンパイルエラー — Naohisa Goto <ngotogenome@...>

[#44356] [Ruby 1.9 - Bug #5160][Open] Float::INFINITY and Float::NAN incorrect in big endian architecture — Naohisa Goto <ngotogenome@...>

[#44361] [Ruby 1.9 - Bug #5127] ruby 1.9.3 prev1 で Array#[]=( Array.new ) が1.9.2より2倍遅い — Narihiro Nakamura <authorNari@...>

[#44362] [Ruby 1.9 - Bug #5175][Open] Ruby1.9.2p290 MySQLアクセスエラー — eiichi maekawa <eiichi_maekawa@...>

[#44363] [Ruby 1.9 - Bug #5176][Open] UTF-8以外でpsychを使用し、YAML.dumpを実行するとエラーが発生する — Masafumi Kiribayashi <masafumi.kiribayashi@...>

[#44368] [Ruby 1.9 - Feature #5180][Open] net/http の接続時に用いる IP アドレスの指定 — Yui NARUSE <naruse@...>

[#44400] [Ruby 1.9 - Bug #5195][Open] Queue#popでsleepしているthreadをwakeupさせるとQueueの@waitingにそのthreadがpushされてしまう — Masaki Matsushita <glass.saga@...>

[#44404] [Ruby 1.9 - Bug #5208][Open] \b and \B don't match properly — Ken Takata <kentkt@...>

[#44409] [Ruby 1.9 - Bug #5213][Open] GC.stress=true で TestSH#test_commercial が Failure になる — Tomoyuki Chikanaga <nagachika00@...>

[#44412] Releasing r33028 as Ruby 1.9.3 RC1 — Yugui <yugui@...>

[#44413] [Ruby 1.9 - Bug #5217][Open] lineno is broken when source code has about 7000 lines — Yusuke Endoh <mame@...>

[#44420] [Ruby 1.9 - Bug #5222][Open] test_script_from_stdin のエラー — Naohisa Goto <ngotogenome@...>

[#44424] [Ruby 1.9 - Backport #5223][Open] please backport r33030 — Yusuke Endoh <mame@...>

[#44435] [BUG: ruby 1.9.3dev (2011-08-02 revision 32810) [i686-linux]] C の Proc の比較のバグ — Satoshi Shiba <shiba@...>

[#44436] [BUG: ruby 1.9.3dev (2011-08-27 revision 33101) [i686-linux]] class オブジェクトの開放時に segv — Satoshi Shiba <shiba@...>

[#44438] [Ruby 1.9 - Bug #5249] C の Proc の比較のバグ — Yui NARUSE <naruse@...>

[ruby-dev:44403] [Ruby 1.9 - Bug #5175][Feedback] Ruby1.9.2p290 MySQLアクセスエラー

Thread

In This Thread

[#44362] [Ruby 1.9 - Bug #5175][Open] Ruby1.9.2p290　MySQLアクセスエラー — eiichi maekawa <eiichi_maekawa@...>

[ruby-dev:44403] [Ruby 1.9 - Bug #5175][Feedback] Ruby1.9.2p290　MySQLアクセスエラー