Ruby 3.0.4 with Postgres 14 throws segmentation fault

Question

I have

Ruby 3.0.4
Rails 6.1.7
pg 1.4.5
postgresql 14.6

Here is my database.yml file

development:
adapter: postgresql
encoding: utf8
database: olio_development
username: postgres
password: password
pool: 5 
host: 127.0.0.1
port: 5432
gssencmode: disable

When I run rake db:create I am getting the following segmentatin fault

/home/usr/.rvm/gems/ruby-3.0.4/gems/pg-1.4.5/lib/pg/connection.rb:626: [BUG] Segmentation fault at 0x00007fd79729a140

ruby 3.0.4p208 (2022-04-12 revision 3fa771dded) [x86_64-linux]

-- Control frame information -----------------------------------------------
 c:0050 p:---- s:0275 e:000274 CFUNC  :connect_poll
c:0049 p:0543 s:0271 e:000270 METHOD /home/suganya/.rvm/gems/ruby-3.0.4/gems/pg-1.4.5/lib/pg/connection.rb:626

The connection fails.

I have verified postgres is running and is on host 127.0.0.1 and post 5432.

Please help me how to resolve this segmentation fault?

Has this code worked previously? What changed between it working and it not working? Rails or pg gems updated (even a tiny version bump)? Postgres updated? Ruby updated? Does it work on one machine but not another? — iftheshoefritz, Jan 26 '23 at 14:18
@iftheshoefritz This is a fresh project which has been started directly on the above mentioned versions. — Suganya Selvarajan, Jan 26 '23 at 16:57
@SuganyaSelvarajan how far back did you test? Unscientifically, `1.3.2` would be worth a shot. — Robert Nubel, Jan 27 '23 at 21:59

score 7 · Answer 1 · answered Aug 14 '23 at 09:37

7

I came across this question while searching for a solution to a similar issue. So will post the fix which worked for me, maybe it will help someone else.

My environment:

Ruby 3.2.2
Rails 7.0.4.3
pg 1.4.5
postgresql 14.9

Adding the following line to .zshrc (and restarting the terminal) fixed the problem for me:

export PGGSSENCMODE="disable"

answered Aug 14 '23 at 09:37

Anton Tsapov

1,181
9
10

It also fixed for: Ruby 3.1.2 Rails 7.0.6 pg 1.4.2 PostgreSQL 14.9 MacOS 13.5.1 (22G90) – AC de Souza Aug 30 '23 at 12:11

score 5 · Answer 2 · answered Jan 26 '23 at 14:10

I'm seeing a GitHub issue for the pg gem (https://github.com/ged/ruby-pg/issues/493) that matches your problem, so it might be a bug with pg v1.4.5. I would try pinning it to an older version:

gem 'pg', '1.4.4'

And work your way backwards if that still has issues. You can also add your information to the GitHub issue linked above to help the maintainers resolve the issue.

Ruby 3.0.4 with Postgres 14 throws segmentation fault

2 Answers2