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

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'

原因

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

ローカル環境では一切問題がないが、AWS Lambda 上で動かすと下記エラーが発生した。

環境
Java: java 11 corretto
Micronaut: 2.3.2 / 2.4.4


Error starting Micronaut container: Bean definition [service.SomeService] could not be loaded: Error instantiating bean of type [service.SomeService]: service.SomeService: com.amazonaws.serverless.exceptions.ContainerInitializationException
com.amazonaws.serverless.exceptions.ContainerInitializationException: Error starting Micronaut container: Bean definition [service.SomeService] could not be loaded: Error instantiating bean of type [service.SomeService]: service.SomeService
    at io.micronaut.function.aws.proxy.MicronautLambdaContainerHandler.initialize(MicronautLambdaContainerHandler.java:254)
    at io.micronaut.function.aws.proxy.MicronautLambdaContainerHandler.<init>(MicronautLambdaContainerHandler.java:164)
    at io.micronaut.function.aws.proxy.MicronautLambdaContainerHandler.<init>(MicronautLambdaContainerHandler.java:118)
    at io.micronaut.function.aws.proxy.MicronautLambdaHandler.<init>(MicronautLambdaHandler.java:54)
    at MyLambdaHandler.<init>(MyLambdaHandler.groovy:22)
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source)
Caused by: io.micronaut.context.exceptions.BeanInstantiationException: Bean definition [service.SomeService] could not be loaded: Error instantiating bean of type [service.SomeService]: service.SomeService
    at io.micronaut.context.DefaultBeanContext.initializeContext(DefaultBeanContext.java:1549)
    at io.micronaut.context.DefaultApplicationContext.initializeContext(DefaultApplicationContext.java:220)
    at io.micronaut.context.DefaultBeanContext.readAllBeanDefinitionClasses(DefaultBeanContext.java:2812)
    at io.micronaut.context.DefaultBeanContext.start(DefaultBeanContext.java:233)
    at io.micronaut.context.DefaultApplicationContext.start(DefaultApplicationContext.java:166)
    at io.micronaut.function.aws.proxy.MicronautLambdaContainerHandler.initialize(MicronautLambdaContainerHandler.java:250)
    ... 8 more
Caused by: io.micronaut.context.exceptions.BeanInstantiationException: Error instantiating bean of type [service.SomeService]: service.SomeService
    at io.micronaut.context.DefaultBeanContext.doCreateBean(DefaultBeanContext.java:1927)
    at io.micronaut.context.DefaultBeanContext.createAndRegisterSingletonInternal(DefaultBeanContext.java:2679)
    at io.micronaut.context.DefaultBeanContext.loadContextScopeBean(DefaultBeanContext.java:2215)
    at io.micronaut.context.DefaultBeanContext.initializeContext(DefaultBeanContext.java:1543)
    ... 13 more
Caused by: java.lang.InstantiationError: service.SomeService
    at service.$SomeServiceDefinition.build(Unknown Source)
    at io.micronaut.context.DefaultBeanContext.doCreateBean(DefaultBeanContext.java:1898)
    ... 16 more

Error starting Micronaut container: Bean definition [service.SomeService] could not be loaded: Error instantiating bean of type [service.SomeService]: service.SomeService: com.amazonaws.serverless.exceptions.ContainerInitializationException

com.amazonaws.serverless.exceptions.ContainerInitializationException: Error starting Micronaut container: Bean definition [service.SomeService] could not be loaded: Error instantiating bean of type [service.SomeService]: service.SomeService

at io.micronaut.function.aws.proxy.MicronautLambdaContainerHandler.initialize(MicronautLambdaContainerHandler.java:254)

at io.micronaut.function.aws.proxy.MicronautLambdaContainerHandler.<init>(MicronautLambdaContainerHandler.java:164)

at io.micronaut.function.aws.proxy.MicronautLambdaContainerHandler.<init>(MicronautLambdaContainerHandler.java:118)

at io.micronaut.function.aws.proxy.MicronautLambdaHandler.<init>(MicronautLambdaHandler.java:54)

at MyLambdaHandler.<init>(MyLambdaHandler.groovy:22)

at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)

at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source)

Caused by: io.micronaut.context.exceptions.BeanInstantiationException: Bean definition [service.SomeService] could not be loaded: Error instantiating bean of type [service.SomeService]: service.SomeService

at io.micronaut.context.DefaultBeanContext.initializeContext(DefaultBeanContext.java:1549)

at io.micronaut.context.DefaultApplicationContext.initializeContext(DefaultApplicationContext.java:220)

at io.micronaut.context.DefaultBeanContext.readAllBeanDefinitionClasses(DefaultBeanContext.java:2812)

at io.micronaut.context.DefaultBeanContext.start(DefaultBeanContext.java:233)

at io.micronaut.context.DefaultApplicationContext.start(DefaultApplicationContext.java:166)

at io.micronaut.function.aws.proxy.MicronautLambdaContainerHandler.initialize(MicronautLambdaContainerHandler.java:250)

... 8 more

Caused by: io.micronaut.context.exceptions.BeanInstantiationException: Error instantiating bean of type [service.SomeService]: service.SomeService

at io.micronaut.context.DefaultBeanContext.doCreateBean(DefaultBeanContext.java:1927)

at io.micronaut.context.DefaultBeanContext.createAndRegisterSingletonInternal(DefaultBeanContext.java:2679)

at io.micronaut.context.DefaultBeanContext.loadContextScopeBean(DefaultBeanContext.java:2215)

at io.micronaut.context.DefaultBeanContext.initializeContext(DefaultBeanContext.java:1543)

... 13 more

Caused by: java.lang.InstantiationError: service.SomeService

at service.$SomeServiceDefinition.build(Unknown Source)

at io.micronaut.context.DefaultBeanContext.doCreateBean(DefaultBeanContext.java:1898)

... 16 more

エラーとなっているサービスは、GormServiceのクラス。
原因は、@Service annotation を使っていたサービスで一部実装部分があったため、abstract class として利用していたのが原因。

@Service を利用する箇所は全て interface を利用し実装部分は普通の class を作成してそこに記載するようにした。

タグ: error

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

現象

修正方法

原因

[micronaut] GORMを利用したアプリをLambdaで起動するとエラー