“要求”：/var/lib/gems/3.0.0/gems/do_postgres-0.10.17/lib/do_postgres/do_postgres.so:未定义符号: pg_fprintf

Question

在从20.04升级到ubuntu22.04之后，我得到了这个错误，我应该做什么来修复这个错误呢？

<internal:/usr/lib/ruby/vendor_ruby/rubygems/core_ext/kernel_require.rb>:85:in `require': /var/lib/gems/3.0.0/gems/do_postgres-0.10.17/lib/do_postgres/do_postgres.so: undefined symbol: pg_fprintf - /var/lib/gems/3.0.0/gems/do_postgres-0.10.17/lib/do_postgres/do_postgres.so (LoadError)
         from <internal:/usr/lib/ruby/vendor_ruby/rubygems/core_ext/kernel_require.rb>:85:in `require'
         from /var/lib/gems/3.0.0/gems/do_postgres-0.10.17/lib/do_postgres.rb:27:in `<top (required)>'
         from <internal:/usr/lib/ruby/vendor_ruby/rubygems/core_ext/kernel_require.rb>:85:in `require'
         from <internal:/usr/lib/ruby/vendor_ruby/rubygems/core_ext/kernel_require.rb>:85:in `require'
         from /var/lib/gems/3.0.0/gems/dm-postgres-adapter-1.2.0/lib/dm-postgres-adapter/adapter.rb:1:in `<top (required)>'
         from <internal:/usr/lib/ruby/vendor_ruby/rubygems/core_ext/kernel_require.rb>:85:in `require'
         from <internal:/usr/lib/ruby/vendor_ruby/rubygems/core_ext/kernel_require.rb>:85:in `require'
         from /var/lib/gems/3.0.0/gems/dm-postgres-adapter-1.2.0/lib/dm-postgres-adapter.rb:1:in `<top (required)>'
         from <internal:/usr/lib/ruby/vendor_ruby/rubygems/core_ext/kernel_require.rb>:160:in `require'
         from <internal:/usr/lib/ruby/vendor_ruby/rubygems/core_ext/kernel_require.rb>:160:in `rescue in require'
         from <internal:/usr/lib/ruby/vendor_ruby/rubygems/core_ext/kernel_require.rb>:149:in `require'
         from /var/lib/gems/3.0.0/gems/dm-core-1.2.1/lib/dm-core/adapters.rb:163:in `load_adapter'
         from /var/lib/gems/3.0.0/gems/dm-core-1.2.1/lib/dm-core/adapters.rb:133:in `adapter_class'
         from /var/lib/gems/3.0.0/gems/dm-core-1.2.1/lib/dm-core/adapters.rb:13:in `new'
         from /var/lib/gems/3.0.0/gems/dm-core-1.2.1/lib/dm-core.rb:230:in `setup'
         from /test/models/db/schema.rb:8:in `<top (required)>'
         from /test/tcpserver.rb:7:in `require_relative'
         from /test/tcpserver.rb:7:in `<main>'
 <internal:/usr/lib/ruby/vendor_ruby/rubygems/core_ext/kernel_require.rb>:85:in `require': cannot load such file -- dm-postgres-adapter (LoadError)
         from <internal:/usr/lib/ruby/vendor_ruby/rubygems/core_ext/kernel_require.rb>:85:in `require'
         from /var/lib/gems/3.0.0/gems/dm-core-1.2.1/lib/dm-core/adapters.rb:163:in `load_adapter'
         from /var/lib/gems/3.0.0/gems/dm-core-1.2.1/lib/dm-core/adapters.rb:133:in `adapter_class'
         from /var/lib/gems/3.0.0/gems/dm-core-1.2.1/lib/dm-core/adapters.rb:13:in `new'
         from /var/lib/gems/3.0.0/gems/dm-core-1.2.1/lib/dm-core.rb:230:in `setup'
         from /test/models/db/schema.rb:8:in `<top (required)>'
         from /test/tcpserver.rb:7:in `require_relative'
         from /test/tcpserver.rb:7:in `<main>'

我试过的是：

sudo apt remove postgres-14 
sudo apt install postgres-server-dev-12
gem uninstall do_postgres
gem install do_postgres

但是仍然有相同的错误，可能是因为libpq-dev使用14而不是12？我在任何地方都找不到12版

root@data:~# dpkg -l | grep postgres
ii  postgresql-12                         12.12-0ubuntu0.20.04.1                  amd64        object-relational SQL database, version 12 server
ii  postgresql-client-12                  12.12-0ubuntu0.20.04.1                  amd64        front-end programs for PostgreSQL 12
ii  postgresql-client-common              238                                     all          manager for multiple PostgreSQL client versions
ii  postgresql-common                     238                                     all          PostgreSQL database-cluster manager
ii  postgresql-doc-12                     12.12-0ubuntu0.20.04.1                  all          documentation for the PostgreSQL database management system
ii  postgresql-server-dev-12              12.12-0ubuntu0.20.04.1                  amd64        development files for PostgreSQL 12 server-side programming
root@data:~# dpkg -l | grep libpq
ii  libpq-dev                             14.5-0ubuntu0.22.04.1                   amd64        header files for libpq5 (PostgreSQL library)
ii  libpq5:amd64                          14.5-0ubuntu0.22.04.1                   amd64        PostgreSQL C client library

尝试将libpq降至12

wget http://security.ubuntu.com/ubuntu/pool/main/p/postgresql-12/libpq-dev_12.12-0ubuntu0.20.04.1_amd64.deb
wget http://security.ubuntu.com/ubuntu/pool/main/p/postgresql-12/libpq-dev_12.12-0ubuntu0.20.04.1_amd64.deb
sudo dpkg -i libpq*.deb
root@data:~# dpkg -l | grep libpq
ii  libpq-dev                             12.12-0ubuntu0.20.04.1                  amd64        header files for libpq5 (PostgreSQL library)
ii  libpq5:amd64                          12.12-0ubuntu0.20.04.1                  amd64        PostgreSQL C client library
gem uninstall do_postgres
gem install do_postgres

也有同样的错误

root@data:~# ldd /var/lib/gems/3.0.0/gems/do_postgres-0.10.17/lib/do_postgres/do_postgres.so | grep pq
        libpq.so.5 => /lib/x86_64-linux-gnu/libpq.so.5 (0x00007fb756725000)
root@data:~# ls -al /lib/x86_64-linux-gnu/libpq.so.5
lrwxrwxrwx 1 root root 13 Aug 12 02:54 /lib/x86_64-linux-gnu/libpq.so.5 -> libpq.so.5.12
root@data:~# ls -al /lib/x86_64-linux-gnu/libpq.so.5.12
-rw-r--r-- 1 root root 321672 Aug 12 02:54 /lib/x86_64-linux-gnu/libpq.so.5.12
root@data:~# strings /lib/x86_64-linux-gnu/libpq.so.5.12 | grep pg_fprintf # no result

Answer 1

降级到ruby2.7解决了这个问题：

sudo ln -sf ruby2.7 /usr/bin/ruby # previously pointing to ruby3.0
gem uninstall do_postgres
gem install do_postgres