启动报错：liquibase.exception.CommandExecutionException: liquibase.snapshot.InvalidExampleException: Found multiple catalogs matchin

yejunxi · 2024 年4 月 11 日 01:57

如图，使用spirng图标的启动与直接在java类启动时正常的，就是在大象图标启动就会报这个错

Ray.Lv · 2024 年4 月 11 日 07:50

你好，
数据库类型是什么呢？

yejunxi · 2024 年4 月 11 日 09:06

oracle ，而且项目里是多个DataSource 。

Ray.Lv · 2024 年4 月 12 日 07:41

数据源上右键能不能执行生成ChangeLog ？可以话去掉 Jmix Application configuration 中的 Check Jmix DataBase 任务，需要生成ChangeLog 时手工执行一下，不用每次启动应用时检查。这样就不影响正常的开发工作了。
IEDA 主菜单->help->show log in Explorer , 看看有没有更详细的异常日志。

yejunxi · 2024 年4 月 15 日 03:51

数据源上右键能不能执行生成ChangeLog ：不可以，报错信息是一样的
可以话去掉 Jmix Application configuration 中的 Check Jmix DataBase 任务：去掉后正常启动了

详细日志，似乎也没新发现：

2024-04-15 11:44:42,179 [ 913886]   INFO - #liquibase.ext.intellij.snapshot.IntellijSnapshotGenerator - Found primary key PK_AUDIT_LOGGED_ATTR
2024-04-15 11:44:42,189 [ 913896]   INFO - #liquibase.ext.intellij.snapshot.IntellijSnapshotGenerator - Found primary key PK_UI_SETTING
2024-04-15 11:44:42,197 [ 913904]   INFO - #liquibase.ext.intellij.snapshot.IntellijSnapshotGenerator - Found primary key PK_AUDIT_ENTITY_LOG
2024-04-15 11:44:42,242 [ 913949]   INFO - #liquibase.ext.intellij.snapshot.IntellijSnapshotGenerator - Found primary key PK_SEC_ROW_LEVEL_ROLE
2024-04-15 11:44:42,255 [ 913962]   INFO - #liquibase.ext.intellij.snapshot.IntellijSnapshotGenerator - Found primary key PK_UI_FILTER_CONFIGURATION
2024-04-15 11:44:42,263 [ 913970]   INFO - #liquibase.ext.intellij.snapshot.IntellijSnapshotGenerator - Found primary key PK_SEC_USER_SUBSTITUTION
2024-04-15 11:44:42,273 [ 913980]   INFO - #liquibase.ext.intellij.snapshot.IntellijSnapshotGenerator - Found primary key PK_UI_TABLE_PRESENTATION
2024-04-15 11:44:42,283 [ 913990]   INFO - #liquibase.ext.intellij.snapshot.IntellijSnapshotGenerator - Found primary key PK_SEC_ROLE_ASSIGNMENT
2024-04-15 11:44:42,292 [ 913999]   INFO - #liquibase.ext.intellij.snapshot.IntellijSnapshotGenerator - Found primary key PK_SEC_ROW_LEVEL_POLICY
2024-04-15 11:44:42,306 [ 914013]   INFO - #liquibase.ext.intellij.snapshot.IntellijSnapshotGenerator - Found primary key PK_SEC_RESOURCE_POLICY
2024-04-15 11:44:42,320 [ 914027]   INFO - #liquibase.ext.intellij.snapshot.IntellijSnapshotGenerator - Found primary key PK_SEC_RESOURCE_ROLE
2024-04-15 11:44:42,329 [ 914036]   INFO - #liquibase.ext.intellij.snapshot.IntellijSnapshotGenerator - Found primary key PK_AUDIT_ENTITY_SNAPSHOT
2024-04-15 11:44:42,383 [ 914090]   INFO - liquibase.command - Command execution complete
2024-04-15 11:44:42,392 [ 914099]   WARN - #com.haulmont.jmixstudio.intellij.runconfiguration.stepbefore.SyncDbBeforeRunProcess - liquibase.exception.CommandExecutionException: liquibase.snapshot.InvalidExampleException: Found multiple catalogs matching JMIX_BOSS
liquibase.exception.LiquibaseException: liquibase.exception.CommandExecutionException: liquibase.snapshot.InvalidExampleException: Found multiple catalogs matching JMIX_BOSS
	at com.haulmont.jmixstudio.liquibase.LiquibaseCommandManager.doDiffToChangeLog(LiquibaseCommandManager.kt:313)
	at com.haulmont.jmixstudio.liquibase.LiquibaseCommandManager.generateDiffChangeLog(LiquibaseCommandManager.kt:281)
	at com.haulmont.jmixstudio.liquibase.LiquibaseIntellijDiffGenerationHandler$doRun$1$1$1.invoke(LiquibaseIntellijDiffGenerationHandler.kt:110)
	at com.haulmont.jmixstudio.liquibase.LiquibaseIntellijDiffGenerationHandler$doRun$1$1$1.invoke(LiquibaseIntellijDiffGenerationHandler.kt:96)
	at com.haulmont.jmixstudio.liquibase.LiquibaseIntellijDiffGenerationHandler.use(LiquibaseIntellijDiffGenerationHandler.kt:137)
	at com.haulmont.jmixstudio.liquibase.LiquibaseIntellijDiffGenerationHandler.access$use(LiquibaseIntellijDiffGenerationHandler.kt:34)
	at com.haulmont.jmixstudio.liquibase.LiquibaseIntellijDiffGenerationHandler$doRun$1$1.invoke(LiquibaseIntellijDiffGenerationHandler.kt:96)
	at com.haulmont.jmixstudio.liquibase.LiquibaseIntellijDiffGenerationHandler$doRun$1$1.invoke(LiquibaseIntellijDiffGenerationHandler.kt:95)
	at com.haulmont.jmixstudio.liquibase.LiquibaseCommandManagerKt.runWithPluginClassLoader(LiquibaseCommandManager.kt:528)
	at com.haulmont.jmixstudio.liquibase.LiquibaseIntellijDiffGenerationHandler$doRun$1.invoke(LiquibaseIntellijDiffGenerationHandler.kt:95)
	at com.haulmont.jmixstudio.liquibase.LiquibaseIntellijDiffGenerationHandler$doRun$1.invoke(LiquibaseIntellijDiffGenerationHandler.kt:94)
	at com.intellij.openapi.application.ActionsKt.runReadAction$lambda$3(actions.kt:31)
	at com.intellij.openapi.application.impl.ApplicationImpl.runReadAction(ApplicationImpl.java:894)
	at com.intellij.openapi.application.ActionsKt.runReadAction(actions.kt:31)
	at com.haulmont.jmixstudio.liquibase.LiquibaseIntellijDiffGenerationHandler.doRun(LiquibaseIntellijDiffGenerationHandler.kt:94)
	at com.haulmont.jmixstudio.liquibase.LiquibaseIntellijDiffGenerationHandler.run$lambda$0(LiquibaseIntellijDiffGenerationHandler.kt:70)
	at com.intellij.openapi.progress.impl.CoreProgressManager$1.run(CoreProgressManager.java:258)
	at com.intellij.openapi.progress.impl.CoreProgressManager.startTask(CoreProgressManager.java:434)
	at com.intellij.openapi.progress.impl.ProgressManagerImpl.startTask(ProgressManagerImpl.java:132)
	at com.intellij.openapi.progress.impl.CoreProgressManager.lambda$runProcessWithProgressSynchronously$8(CoreProgressManager.java:518)
	at com.intellij.openapi.progress.impl.ProgressRunner.lambda$new$0(ProgressRunner.java:84)
	at com.intellij.openapi.progress.impl.ProgressRunner.lambda$submit$4(ProgressRunner.java:248)
	at com.intellij.openapi.progress.ProgressManager.lambda$runProcess$0(ProgressManager.java:73)
	at com.intellij.openapi.progress.impl.CoreProgressManager.lambda$runProcess$1(CoreProgressManager.java:192)
	at com.intellij.openapi.progress.impl.CoreProgressManager.lambda$executeProcessUnderProgress$12(CoreProgressManager.java:610)
	at com.intellij.openapi.progress.impl.CoreProgressManager.registerIndicatorAndRun(CoreProgressManager.java:685)
	at com.intellij.openapi.progress.impl.CoreProgressManager.computeUnderProgress(CoreProgressManager.java:641)
	at com.intellij.openapi.progress.impl.CoreProgressManager.executeProcessUnderProgress(CoreProgressManager.java:609)
	at com.intellij.openapi.progress.impl.ProgressManagerImpl.executeProcessUnderProgress(ProgressManagerImpl.java:78)
	at com.intellij.openapi.progress.impl.CoreProgressManager.runProcess(CoreProgressManager.java:179)
	at com.intellij.openapi.progress.ProgressManager.runProcess(ProgressManager.java:73)
	at com.intellij.openapi.progress.impl.ProgressRunner.lambda$submit$5(ProgressRunner.java:248)
	at com.intellij.openapi.progress.impl.ProgressRunner$ProgressRunnable.run(ProgressRunner.java:498)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)
	at java.base/java.util.concurrent.Executors$PrivilegedThreadFactory$1$1.run(Executors.java:702)
	at java.base/java.util.concurrent.Executors$PrivilegedThreadFactory$1$1.run(Executors.java:699)
	at java.base/java.security.AccessController.doPrivileged(AccessController.java:399)
	at java.base/java.util.concurrent.Executors$PrivilegedThreadFactory$1.run(Executors.java:699)
	at java.base/java.lang.Thread.run(Thread.java:840)
Caused by: liquibase.exception.CommandExecutionException: liquibase.snapshot.InvalidExampleException: Found multiple catalogs matching JMIX_BOSS
	at liquibase.command.CommandScope.execute(CommandScope.java:237)
	at com.haulmont.jmixstudio.liquibase.LiquibaseCommandManager.doDiffToChangeLog(LiquibaseCommandManager.kt:310)
	... 39 more
Caused by: liquibase.snapshot.InvalidExampleException: Found multiple catalogs matching JMIX_BOSS
	at liquibase.snapshot.jvm.CatalogSnapshotGenerator.snapshotObject(CatalogSnapshotGenerator.java:41)
	at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:65)
	at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
	at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:68)
	at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
	at liquibase.snapshot.jvm.JdbcSnapshotGenerator.snapshot(JdbcSnapshotGenerator.java:68)
	at liquibase.snapshot.SnapshotGeneratorChain.snapshot(SnapshotGeneratorChain.java:49)
	at liquibase.snapshot.DatabaseSnapshot.include(DatabaseSnapshot.java:313)
	at liquibase.snapshot.DatabaseSnapshot.init(DatabaseSnapshot.java:100)
	at liquibase.snapshot.DatabaseSnapshot.<init>(DatabaseSnapshot.java:59)
	at liquibase.snapshot.JdbcDatabaseSnapshot.<init>(JdbcDatabaseSnapshot.java:34)
	at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:215)
	at liquibase.snapshot.SnapshotGeneratorFactory.createSnapshot(SnapshotGeneratorFactory.java:188)
	at liquibase.command.core.DiffCommandStep.generateDatabaseShapshot(DiffCommandStep.java:205)
	at liquibase.command.core.DiffCommandStep.getTargetSnapshot(DiffCommandStep.java:155)
	at liquibase.command.core.DiffCommandStep.createDiffResult(DiffCommandStep.java:114)
	at liquibase.command.core.DiffCommandStep.run(DiffCommandStep.java:89)
	at liquibase.command.CommandScope.execute(CommandScope.java:214)
	... 40 more
2024-04-15 11:44:47,033 [ 918740]   INFO - #c.i.u.MemTester - not supported: not an executable file: null

liren.xu · 2024 年4 月 15 日 07:45

你检查一下数据库中是否有多个 JMIX_BOSS schema, 只是大小写不同?