Ubuntu22.04下Ruby调用MySQL2出现Segmentation fault问题求助

环境信息 #

• Ubuntu 22.04
• Ruby 2.5.3p105 (2018-10-18 revision 65156) [x86_64-linux]
• Rails 5.1.4
• MySQL 8.0.36

错误详情 #

在rails console中执行查询时触发Segmentation Fault，错误输出如下：

/home/user/.rvm/gems/ruby-2.5.3/gems/mysql2-0.5.6/lib/mysql2/client.rb:97: [BUG] Segmentation fault at 0x0000000000000000
ruby 2.5.3p105 (2018-10-18 revision 65156) [x86_64-linux]

-- Control frame information -----------------------------------------------
c:0052 p:---- s:0319 e:000318 CFUNC  :connect
c:0051 p:0672 s:0307 e:000306 METHOD /home/user/.rvm/gems/ruby-2.5.3/gems/mysql2-0.5.6/lib/mysql2/client.rb:97 [FINISH]
c:0050 p:---- s:0292 e:000291 CFUNC  :new
c:0049 p:0104 s:0287 e:000286 METHOD /home/user/.rvm/gems/ruby-2.5.3/gems/activerecord-5.1.7/lib/active_record/connection_adapters/mysql2_adapter.rb:21
c:0048 p:0024 s:0280 e:000279 METHOD /home/user/.rvm/gems/ruby-2.5.3/gems/activerecord-5.1.7/lib/active_record/connection_adapters/abstract/connection_poo
c:0047 p:0021 s:0276 e:000275 METHOD /home/user/.rvm/gems/ruby-2.5.3/gems/activerecord-5.1.7/lib/active_record/connection_adapters/abstract/connection_poo
c:0046 p:0015 s:0272 e:000271 METHOD /home/user/.rvm/gems/ruby-2.5.3/gems/activerecord-5.1.7/lib/active_record/connection_adapters/abstract/connection_poo
c:0045 p:0014 s:0266 e:000265 METHOD /home/user/.rvm/gems/ruby-2.5.3/gems/activerecord-5.1.7/lib/active_record/connection_adapters/abstract/connection_poo
c:0044 p:0012 s:0260 e:000258 METHOD /home/user/.rvm/gems/ruby-2.5.3/gems/activerecord-5.1.7/lib/active_record/connection_adapters/abstract/connection_poo
c:0043 p:0038 s:0254 e:000250 METHOD /home/user/.rvm/gems/ruby-2.5.3/gems/activerecord-5.1.7/lib/active_record/connection_adapters/abstract/connection_poo
c:0042 p:0046 s:0247 e:000246 METHOD /home/user/.rvm/gems/ruby-2.5.3/gems/activerecord-5.1.7/lib/active_record/connection_adapters/abstract/connection_poo
c:0041 p:0011 s:0240 e:000239 METHOD /home/user/.rvm/gems/ruby-

已尝试的解决方法 #

• 重新安装最新版MySQL 8.0.36
• 执行以下命令重新安装依赖并编译mysql2 gem：

  sudo apt remove libmariadbd-dev
  sudo apt install libmariadbd-dev
  gem install mysql2 -v '0.5.6'
  

上述方法均无效，问题仍然存在，寻求解决方案。

内容的提问来源于stack exchange，提问作者SkRoR