error – ページ 2 – ぷすぅ～ぷすぅ～

Centos7 や Centos8 での情報は散見されたが、Centos9 の場合は情報が無かったので記載する。

以下のようなエラー


Gem::Ext::BuildError: ERROR: Failed to build gem native extension.

    current directory: /usr/share/gems/gems/mysql2-0.5.4/ext/mysql2
/usr/bin/ruby -I /usr/share/rubygems -r ./siteconf20220516-45530-uvk74g.rb extconf.rb
checking for rb_absint_size()... yes
checking for rb_absint_singlebit_p()... yes
checking for rb_wait_for_single_fd()... yes
checking for rb_enc_interned_str() in ruby.h... yes
*** extconf.rb failed ***
Could not create Makefile due to some reason, probably lack of necessary
libraries and/or headers.  Check the mkmf.log file for more details.  You may
need configuration options.

Provided configuration options:
        --with-opt-dir
        --without-opt-dir
        --with-opt-include
        --without-opt-include=${opt-dir}/include
        --with-opt-lib
        --without-opt-lib=${opt-dir}/lib64
        --with-make-prog
        --without-make-prog
        --srcdir=.
        --curdir
        --ruby=/usr/bin/$(RUBY_BASE_NAME)
        --with-mysql-dir
        --without-mysql-dir
        --with-mysql-include
        --without-mysql-include=${mysql-dir}/include
        --with-mysql-lib
        --without-mysql-lib=${mysql-dir}/lib64
        --with-mysql-config
        --without-mysql-config
        --with-mysqlclient-dir
        --without-mysqlclient-dir
        --with-mysqlclient-include
        --without-mysqlclient-include=${mysqlclient-dir}/include
        --with-mysqlclient-lib
        --without-mysqlclient-lib=${mysqlclient-dir}/lib64
        --with-mysqlclientlib
        --without-mysqlclientlib
/usr/share/ruby/mkmf.rb:1050:in `block in find_library': undefined method `split' for nil:NilClass (NoMethodError)
        from /usr/share/ruby/mkmf.rb:1050:in `collect'
        from /usr/share/ruby/mkmf.rb:1050:in `find_library'
        from extconf.rb:103:in `<main>'

To see why this extension failed to compile, please check the mkmf.log which can be found here:

  /usr/lib64/gems/ruby/mysql2-0.5.4/mkmf.log

extconf failed, exit code 1

Gem files will remain installed in /usr/share/gems/gems/mysql2-0.5.4 for inspection.
Results logged to /usr/lib64/gems/ruby/mysql2-0.5.4/gem_make.out

  /usr/share/rubygems/rubygems/ext/builder.rb:93:in `run'
  /usr/share/rubygems/rubygems/ext/ext_conf_builder.rb:47:in `block in build'
  /usr/share/ruby/tempfile.rb:317:in `open'
  /usr/share/rubygems/rubygems/ext/ext_conf_builder.rb:26:in `build'
  /usr/share/rubygems/rubygems/ext/builder.rb:159:in `build_extension'
  /usr/share/rubygems/rubygems/ext/builder.rb:193:in `block in build_extensions'
  /usr/share/rubygems/rubygems/ext/builder.rb:190:in `each'
  /usr/share/rubygems/rubygems/ext/builder.rb:190:in `build_extensions'
  /usr/share/rubygems/rubygems/installer.rb:845:in `build_extensions'
  /usr/share/gems/gems/bundler-2.2.32/lib/bundler/rubygems_gem_installer.rb:71:in `build_extensions'
  /usr/share/gems/gems/bundler-2.2.32/lib/bundler/rubygems_gem_installer.rb:28:in `install'
  /usr/share/gems/gems/bundler-2.2.32/lib/bundler/source/rubygems.rb:200:in `install'
  /usr/share/gems/gems/bundler-2.2.32/lib/bundler/installer/gem_installer.rb:54:in `install'
  /usr/share/gems/gems/bundler-2.2.32/lib/bundler/installer/gem_installer.rb:16:in `install_from_spec'
  /usr/share/gems/gems/bundler-2.2.32/lib/bundler/installer/parallel_installer.rb:186:in `do_install'
  /usr/share/gems/gems/bundler-2.2.32/lib/bundler/installer/parallel_installer.rb:177:in `block in worker_pool'
  /usr/share/gems/gems/bundler-2.2.32/lib/bundler/worker.rb:62:in `apply_func'
  /usr/share/gems/gems/bundler-2.2.32/lib/bundler/worker.rb:57:in `block in process_queue'
  /usr/share/gems/gems/bundler-2.2.32/lib/bundler/worker.rb:54:in `loop'
  /usr/share/gems/gems/bundler-2.2.32/lib/bundler/worker.rb:54:in `process_queue'
  /usr/share/gems/gems/bundler-2.2.32/lib/bundler/worker.rb:91:in `block (2 levels) in create_threads'

An error occurred while installing mysql2 (0.5.4), and Bundler cannot continue.

In Gemfile:
  mysql2

Gem::Ext::BuildError: ERROR: Failed to build gem native extension.

current directory: /usr/share/gems/gems/mysql2-0.5.4/ext/mysql2

/usr/bin/ruby -I /usr/share/rubygems -r ./siteconf20220516-45530-uvk74g.rb extconf.rb

checking for rb_absint_size()... yes

checking for rb_absint_singlebit_p()... yes

checking for rb_wait_for_single_fd()... yes

checking for rb_enc_interned_str() in ruby.h... yes

*** extconf.rb failed ***

Could not create Makefile due to some reason, probably lack of necessary

libraries and/or headers. Check the mkmf.log file for more details. You may

need configuration options.

Provided configuration options:

--with-opt-dir

--without-opt-dir

--with-opt-include

--without-opt-include=${opt-dir}/include

--with-opt-lib

--without-opt-lib=${opt-dir}/lib64

--with-make-prog

--without-make-prog

--srcdir=.

--curdir

--ruby=/usr/bin/$(RUBY_BASE_NAME)

--with-mysql-dir

--without-mysql-dir

--with-mysql-include

--without-mysql-include=${mysql-dir}/include

--with-mysql-lib

--without-mysql-lib=${mysql-dir}/lib64

--with-mysql-config

--without-mysql-config

--with-mysqlclient-dir

--without-mysqlclient-dir

--with-mysqlclient-include

--without-mysqlclient-include=${mysqlclient-dir}/include

--with-mysqlclient-lib

--without-mysqlclient-lib=${mysqlclient-dir}/lib64

--with-mysqlclientlib

--without-mysqlclientlib

/usr/share/ruby/mkmf.rb:1050:in `block in find_library': undefined method `split' for nil:NilClass (NoMethodError)

from /usr/share/ruby/mkmf.rb:1050:in `collect'

from /usr/share/ruby/mkmf.rb:1050:in `find_library'

from extconf.rb:103:in `<main>'

To see why this extension failed to compile, please check the mkmf.log which can be found here:

/usr/lib64/gems/ruby/mysql2-0.5.4/mkmf.log

extconf failed, exit code 1

Gem files will remain installed in /usr/share/gems/gems/mysql2-0.5.4 for inspection.

Results logged to /usr/lib64/gems/ruby/mysql2-0.5.4/gem_make.out

/usr/share/rubygems/rubygems/ext/builder.rb:93:in `run'

/usr/share/rubygems/rubygems/ext/ext_conf_builder.rb:47:in `block in build'

/usr/share/ruby/tempfile.rb:317:in `open'

/usr/share/rubygems/rubygems/ext/ext_conf_builder.rb:26:in `build'

/usr/share/rubygems/rubygems/ext/builder.rb:159:in `build_extension'

/usr/share/rubygems/rubygems/ext/builder.rb:193:in `block in build_extensions'

/usr/share/rubygems/rubygems/ext/builder.rb:190:in `each'

/usr/share/rubygems/rubygems/ext/builder.rb:190:in `build_extensions'

/usr/share/rubygems/rubygems/installer.rb:845:in `build_extensions'

/usr/share/gems/gems/bundler-2.2.32/lib/bundler/rubygems_gem_installer.rb:71:in `build_extensions'

/usr/share/gems/gems/bundler-2.2.32/lib/bundler/rubygems_gem_installer.rb:28:in `install'

/usr/share/gems/gems/bundler-2.2.32/lib/bundler/source/rubygems.rb:200:in `install'

/usr/share/gems/gems/bundler-2.2.32/lib/bundler/installer/gem_installer.rb:54:in `install'

/usr/share/gems/gems/bundler-2.2.32/lib/bundler/installer/gem_installer.rb:16:in `install_from_spec'

/usr/share/gems/gems/bundler-2.2.32/lib/bundler/installer/parallel_installer.rb:186:in `do_install'

/usr/share/gems/gems/bundler-2.2.32/lib/bundler/installer/parallel_installer.rb:177:in `block in worker_pool'

/usr/share/gems/gems/bundler-2.2.32/lib/bundler/worker.rb:62:in `apply_func'

/usr/share/gems/gems/bundler-2.2.32/lib/bundler/worker.rb:57:in `block in process_queue'

/usr/share/gems/gems/bundler-2.2.32/lib/bundler/worker.rb:54:in `loop'

/usr/share/gems/gems/bundler-2.2.32/lib/bundler/worker.rb:54:in `process_queue'

/usr/share/gems/gems/bundler-2.2.32/lib/bundler/worker.rb:91:in `block (2 levels) in create_threads'

An error occurred while installing mysql2 (0.5.4), and Bundler cannot continue.

In Gemfile:

mysql2

必要なのは以下


$ sudo dnf install mariadb-connector-c-devel

$ sudo dnf install mariadb-connector-c-devel

Micronaut / Grails で起動時に以下のようなエラー。

現象

mapping で、複数のindexを複数指定している場合に発生している模様。


Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: SQL strings added more than once for: xxxxxxxxxx.IDX-yyyyyyyyyyy_idx
	at org.hibernate.tool.schema.internal.SchemaCreatorImpl.checkExportIdentifier(SchemaCreatorImpl.java:409)
	at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createFromMetadata(SchemaCreatorImpl.java:335)
	at org.hibernate.tool.schema.internal.SchemaCreatorImpl.performCreation(SchemaCreatorImpl.java:167)
	at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:136)
	at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:122)
	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:164)
	at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:81)
	at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:327)
	at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:471)
	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:728)
	at org.grails.orm.hibernate.cfg.HibernateMappingContextConfiguration.buildSessionFactory(HibernateMappingContextConfiguration.java:287)
	at org.grails.orm.hibernate.connections.HibernateConnectionSourceFactory.create(HibernateConnectionSourceFactory.java:86)
	at org.grails.orm.hibernate.connections.AbstractHibernateConnectionSourceFactory.create(AbstractHibernateConnectionSourceFactory.java:39)
	at org.grails.orm.hibernate.connections.AbstractHibernateConnectionSourceFactory.create(AbstractHibernateConnectionSourceFactory.java:23)
	at org.grails.datastore.mapping.core.connections.AbstractConnectionSourceFactory.create(AbstractConnectionSourceFactory.java:64)
	at org.grails.datastore.mapping.core.connections.AbstractConnectionSourceFactory.create(AbstractConnectionSourceFactory.java:52)
	at org.grails.datastore.mapping.core.connections.ConnectionSourcesInitializer.create(ConnectionSourcesInitializer.groovy:24)
	at org.grails.orm.hibernate.HibernateDatastore.<init>(HibernateDatastore.java:212)
	at org.grails.orm.hibernate.HibernateDatastore.<init>(HibernateDatastore.java:233)
	at io.micronaut.configuration.

Caused by: org.hibernate.tool.schema.spi.SchemaManagementException: SQL strings added more than once for: xxxxxxxxxx.IDX-yyyyyyyyyyy_idx

at org.hibernate.tool.schema.internal.SchemaCreatorImpl.checkExportIdentifier(SchemaCreatorImpl.java:409)

at org.hibernate.tool.schema.internal.SchemaCreatorImpl.createFromMetadata(SchemaCreatorImpl.java:335)

at org.hibernate.tool.schema.internal.SchemaCreatorImpl.performCreation(SchemaCreatorImpl.java:167)

at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:136)

at org.hibernate.tool.schema.internal.SchemaCreatorImpl.doCreation(SchemaCreatorImpl.java:122)

at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:164)

at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:81)

at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:327)

at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:471)

at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:728)

at org.grails.orm.hibernate.cfg.HibernateMappingContextConfiguration.buildSessionFactory(HibernateMappingContextConfiguration.java:287)

at org.grails.orm.hibernate.connections.HibernateConnectionSourceFactory.create(HibernateConnectionSourceFactory.java:86)

at org.grails.orm.hibernate.connections.AbstractHibernateConnectionSourceFactory.create(AbstractHibernateConnectionSourceFactory.java:39)

at org.grails.orm.hibernate.connections.AbstractHibernateConnectionSourceFactory.create(AbstractHibernateConnectionSourceFactory.java:23)

at org.grails.datastore.mapping.core.connections.AbstractConnectionSourceFactory.create(AbstractConnectionSourceFactory.java:64)

at org.grails.datastore.mapping.core.connections.AbstractConnectionSourceFactory.create(AbstractConnectionSourceFactory.java:52)

at org.grails.datastore.mapping.core.connections.ConnectionSourcesInitializer.create(ConnectionSourcesInitializer.groovy:24)

at org.grails.orm.hibernate.HibernateDatastore.<init>(HibernateDatastore.java:212)

at org.grails.orm.hibernate.HibernateDatastore.<init>(HibernateDatastore.java:233)

at io.micronaut.configuration.

修正方法


static mapping = {
        col1 index: 'col1_idx, col_date_idx, col_type1_idx'

static mapping = {

col1 index: 'col1_idx, col_date_idx, col_type1_idx'

のように、indexの指定の,区切りに空白を入れない。


static mapping = {
        col1 index: 'col1_idx,col_date_idx,col_type1_idx'

static mapping = {

col1 index: 'col1_idx,col_date_idx,col_type1_idx'

原因

テーブル名の接頭語が被っていると同様の現象が発生しているような記述を見かけた。
確かに今回のプロジェクトだと、テーブル名の接頭語が被っているがそこは変更できない。
他のテーブルだとカンマの後に空白があって問題がないので、テーブル名の接頭語が被ってることで何らかの影響で上記現象が発生していると思われるが、根本原因はわからず、探る時間もなし！

タグ: error

[CentoOS9 ] gem install mysql2 が出来ない

[micronaut/Grails] 複数のindexがある時に、SQL strings added more than once for… のようなエラー

現象

修正方法

原因