c - Ruby sqlite3 gem 无法在 WSL 上编译

Question

tl;博士:
sqlite3 无法在 WSL Ubuntu 环境中编译其 native 扩展，而在其他非 WSL Ubuntu native 环境中它不会失败。
概括:
我在 Windows 10 Pro (19042.1288) 上安装了运行 Ubuntu 20.04.1 LTS 的 WSL2。我有一个安装了 Ruby 2.7.4 和 Ruby 3.0.2 的工作 rbenv 环境。在 gem 原生扩展编译时( gem install sqlite3 -v '1.4.2' --source 'https://rubygems.org/' )它会吐出大量警告和错误，但第一个真正的错误是这个:

sqlite3.c:33:37: error: invalid type argument of ‘->’ (have ‘int’)
   33 | #   define RBIGNUM_LEN(x) RBIGNUM(x)->len
      |                                     ^~

我试过的
包更新
我已经更新了我被告知相关的软件包:

$ sudo apt-get update
$ sudo apt-get install sqlite3 libsqlite3-dev libxslt-dev libxml2-dev

安装标志
我试过用 --with-sqlite3-include 运行像这样的标志:

$ gem install sqlite3 -v '1.4.2' --source 'https://rubygems.org/' -- --with-sqlite3-include=/usr/include

从源代码安装 sqlite3
这会导致从源代码安装 sqlite3(在 $PATH 中正确加载)，但不会更改 gem native 扩展编译时的错误。

$ wget https://www.sqlite.org/2021/sqlite-autoconf-3360000.tar.gz
$ tar xvf sqlite-autoconf-3360000.tar.gz
$ cd sqlite-autoconf-3360000
$ ./configure
$ make
$ make install

只需在真正的 Ubuntu 机器上进行操作™
这工作正常。这是让我相信这个问题与 WSL 相关的部分原因。 (创建一个新的 WSL Ubuntu 实例会产生同样的问题，所以我认为这不是我的环境)
错误日志

$ gem install sqlite3 -v '1.4.2' --source 'https://rubygems.org/'
Fetching sqlite3-1.4.2.gem
Building native extensions. This could take a while...
ERROR:  Error installing sqlite3:
        ERROR: Failed to build gem native extension.

    current directory: /home/wwboynton/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/ext/sqlite3
/home/wwboynton/.rbenv/versions/3.0.2/bin/ruby -I /home/wwboynton/.rbenv/versions/3.0.2/lib/ruby/3.0.0 -r ./siteconf20211105-14591-ztfaj2.rb extconf.rb
checking for sqlite3.h... yes
checking for pthread_create() in -lpthread... yes
checking for -ldl... yes
checking for sqlite3_libversion_number() in -lsqlite3... yes
checking for rb_proc_arity()... no
checking for rb_integer_pack()... no
checking for sqlite3_initialize()... yes
checking for sqlite3_backup_init()... yes
checking for sqlite3_column_database_name()... no
checking for sqlite3_enable_load_extension()... yes
checking for sqlite3_load_extension()... yes
checking for sqlite3_open_v2()... yes
checking for sqlite3_prepare_v2()... yes
checking for sqlite3_int64 in sqlite3.h... yes
checking for sqlite3_uint64 in sqlite3.h... yes
creating Makefile

current directory: /home/wwboynton/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/ext/sqlite3
make DESTDIR\= clean

current directory: /home/wwboynton/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2/ext/sqlite3
make DESTDIR\=
compiling aggregator.c
compiling backup.c
compiling database.c
database.c: In function ‘rb_sqlite3_open_v2’:
database.c:38:9: warning: unused variable ‘flags’ [-Wunused-variable]
   38 |   VALUE flags;
      |         ^~~~~
database.c: In function ‘exec_batch’:
database.c:726:57: warning: passing argument 3 of ‘sqlite3_exec’ from incompatible pointer type [-Wincompatible-pointer-types]
  726 |     status = sqlite3_exec(ctx->db, StringValuePtr(sql), hash_callback_function, callback_ary, &errMsg);
      |                                                         ^~~~~~~~~~~~~~~~~~~~~~
      |                                                         |
      |                                                         int (*)(VALUE,  int,  char **, char **) {aka int (*)(long unsigned int,  int,  char **, char **)}
In file included from ./sqlite3_ruby.h:25,
                 from database.c:1:
/usr/local/include/sqlite3.h:405:9: note: expected ‘int (*)(void *, int,  char **, char **)’ but argument is of type ‘int (*)(VALUE,  int,  char **, char **)’ {aka ‘int (*)(long unsigned int,  int,  char **, char **)’}
  405 |   int (*callback)(void*,int,char**,char**),  /* Callback function */
      |   ~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
database.c:726:81: warning: passing argument 4 of ‘sqlite3_exec’ makes pointer from integer without a cast [-Wint-conversion]
  726 |     status = sqlite3_exec(ctx->db, StringValuePtr(sql), hash_callback_function, callback_ary, &errMsg);
      |                                                                                 ^~~~~~~~~~~~
      |                                                                                 |
      |                                                                                 VALUE {aka long unsigned int}
In file included from ./sqlite3_ruby.h:25,
                 from database.c:1:
/usr/local/include/sqlite3.h:406:3: note: expected ‘void *’ but argument is of type ‘VALUE’ {aka ‘long unsigned int’}
  406 |   void *,                                    /* 1st argument to callback */
      |   ^~~~~~
database.c:728:57: warning: passing argument 3 of ‘sqlite3_exec’ from incompatible pointer type [-Wincompatible-pointer-types]
  728 |     status = sqlite3_exec(ctx->db, StringValuePtr(sql), regular_callback_function, callback_ary, &errMsg);
      |                                                         ^~~~~~~~~~~~~~~~~~~~~~~~~
      |                                                         |
      |                                                         int (*)(VALUE,  int,  char **, char **) {aka int (*)(long unsigned int,  int,  char **, char **)}
In file included from ./sqlite3_ruby.h:25,
                 from database.c:1:
/usr/local/include/sqlite3.h:405:9: note: expected ‘int (*)(void *, int,  char **, char **)’ but argument is of type ‘int (*)(VALUE,  int,  char **, char **)’ {aka ‘int (*)(long unsigned int,  int,  char **, char **)’}
  405 |   int (*callback)(void*,int,char**,char**),  /* Callback function */
      |   ~~~~~~^~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
database.c:728:84: warning: passing argument 4 of ‘sqlite3_exec’ makes pointer from integer without a cast [-Wint-conversion]
  728 |     status = sqlite3_exec(ctx->db, StringValuePtr(sql), regular_callback_function, callback_ary, &errMsg);
      |                                                                                    ^~~~~~~~~~~~
      |                                                                                    |
      |                                                                                    VALUE {aka long unsigned int}
In file included from ./sqlite3_ruby.h:25,
                 from database.c:1:
/usr/local/include/sqlite3.h:406:3: note: expected ‘void *’ but argument is of type ‘VALUE’ {aka ‘long unsigned int’}
  406 |   void *,                                    /* 1st argument to callback */
      |   ^~~~~~
database.c: At top level:
cc1: warning: unrecognized command line option ‘-Wno-self-assign’
cc1: warning: unrecognized command line option ‘-Wno-parentheses-equality’
cc1: warning: unrecognized command line option ‘-Wno-constant-logical-operand’
compiling exception.c
compiling sqlite3.c
sqlite3.c: In function ‘bignum_to_int64’:
sqlite3.c:33:27: warning: implicit declaration of function ‘RBIGNUM’; did you mean ‘T_BIGNUM’? [-Wimplicit-function-declaration]
   33 | #   define RBIGNUM_LEN(x) RBIGNUM(x)->len
      |                           ^~~~~~~
sqlite3.c:35:20: note: in expansion of macro ‘RBIGNUM_LEN’
   35 |   const long len = RBIGNUM_LEN(value);
      |                    ^~~~~~~~~~~
sqlite3.c:33:37: error: invalid type argument of ‘->’ (have ‘int’)
   33 | #   define RBIGNUM_LEN(x) RBIGNUM(x)->len
      |                                     ^~
sqlite3.c:35:20: note: in expansion of macro ‘RBIGNUM_LEN’
   35 |   const long len = RBIGNUM_LEN(value);
      |                    ^~~~~~~~~~~
sqlite3.c:40:19: error: ‘SIZEOF_BDIGITS’ undeclared (first use in this function); did you mean ‘SIZEOF_INT’?
   40 |   if (len > 63 / (SIZEOF_BDIGITS * CHAR_BIT) + 1) return 0;
      |                   ^~~~~~~~~~~~~~
      |                   SIZEOF_INT
sqlite3.c:40:19: note: each undeclared identifier is reported only once for each function it appears in
sqlite3.c:42:11: error: unknown type name ‘BDIGIT’
   42 |     const BDIGIT *digits = RBIGNUM_DIGITS(value);
      |           ^~~~~~
sqlite3.c:42:28: warning: implicit declaration of function ‘RBIGNUM_DIGITS’; did you mean ‘RBIGNUM_SIGN’? [-Wimplicit-function-declaration]
   42 |     const BDIGIT *digits = RBIGNUM_DIGITS(value);
      |                            ^~~~~~~~~~~~~~
      |                            RBIGNUM_SIGN
sqlite3.c:42:28: warning: initialization of ‘const int *’ from ‘int’ makes pointer from integer without a cast [-Wint-conversion]
sqlite3.c:43:5: error: unknown type name ‘BDIGIT’; did you mean ‘ISDIGIT’?
   43 |     BDIGIT blast = digits[len-1];
      |     ^~~~~~
      |     ISDIGIT
sqlite3.c:44:5: error: unknown type name ‘BDIGIT’; did you mean ‘ISDIGIT’?
   44 |     BDIGIT bmax = (BDIGIT)1UL << (63 % (CHAR_BIT * SIZEOF_BDIGITS));
      |     ^~~~~~
      |     ISDIGIT
sqlite3.c:44:20: error: ‘BDIGIT’ undeclared (first use in this function); did you mean ‘ISDIGIT’?
   44 |     BDIGIT bmax = (BDIGIT)1UL << (63 % (CHAR_BIT * SIZEOF_BDIGITS));
      |                    ^~~~~~
      |                    ISDIGIT
sqlite3.c:44:27: error: expected ‘,’ or ‘;’ before numeric constant
   44 |     BDIGIT bmax = (BDIGIT)1UL << (63 % (CHAR_BIT * SIZEOF_BDIGITS));
      |                           ^~~
sqlite3.c: At top level:
cc1: warning: unrecognized command line option ‘-Wno-self-assign’
cc1: warning: unrecognized command line option ‘-Wno-parentheses-equality’
cc1: warning: unrecognized command line option ‘-Wno-constant-logical-operand’
make: *** [Makefile:245: sqlite3.o] Error 1

make failed, exit code 2

Gem files will remain installed in /home/wwboynton/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/gems/sqlite3-1.4.2 for inspection.
Results logged to /home/wwboynton/.rbenv/versions/3.0.2/lib/ruby/gems/3.0.0/extensions/x86_64-linux/3.0.0/sqlite3-1.4.2/gem_make.out

Answer 1

所以我似乎已经成功地解决了这个问题，尽管不是很优雅。
尽管很愚蠢，但我在一个正常工作的原生 Ubuntu 机器上安装了 gem，没有问题，然后我复制了我的 rbenv 安装的 ruby​​ 2.7.4从那台机器到这台机器(位于 ~/.rbenv/versions/2.7.4 )，完全覆盖了我本地安装的那个 ruby​​ 版本。显然，我可能只是移动了特定于 gem 的文件，而这个解决方案破坏了我已经安装的 gem，但这很好。当我运行 bundle install在我新生成的 rails 项目中，它安装了其他所有东西并使用了现有的 sqlite3 gem 毫无怨言。使用 irb 时，我可以毫无问题地要求 gem 。
如果出现一些微妙的行为表明这实际上不起作用并且只是回避了问题的第一个明显出现，我将编辑或删除此答案。如果它似乎有效并且在接下来的几天内没有人提交解决根本问题的东西，那么我将接受这个答案。