使用外部数据库导入数据总是失败

 11:24:04 Thread-48 ERROR [standard] Error accessing index information: finedb.fine_dep_role

com.fr.third.org.hibernate.exception.JDBCConnectionException: Error accessing index information: finedb.fine_dep_role

at com.fr.third.org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:48)

at com.fr.third.org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)

at com.fr.third.org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)

at com.fr.third.org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)

at com.fr.third.org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.convertSQLException(InformationExtractorJdbcDatabaseMetaDataImpl.java:100)

at com.fr.third.org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.getIndexes(InformationExtractorJdbcDatabaseMetaDataImpl.java:753)

at com.fr.third.org.hibernate.tool.schema.extract.internal.TableInformationImpl.indexes(TableInformationImpl.java:122)

at com.fr.third.org.hibernate.tool.schema.extract.internal.TableInformationImpl.getIndex(TableInformationImpl.java:138)

at com.fr.third.org.hibernate.tool.schema.internal.AbstractSchemaMigrator.applyUniqueKeys(AbstractSchemaMigrator.java:366)

at com.fr.third.org.hibernate.tool.schema.internal.GroupedSchemaMigratorImpl.performTablesMigration(GroupedSchemaMigratorImpl.java:85)

at com.fr.third.org.hibernate.tool.schema.internal.AbstractSchemaMigrator.performMigration(AbstractSchemaMigrator.java:203)

at com.fr.third.org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:110)

at com.fr.third.org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:176)

at com.fr.third.org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)

at com.fr.third.org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:476)

at com.fr.third.org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:422)

at com.fr.third.org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:710)

at com.fr.third.org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:726)

at com.fr.stable.db.session.SessionManager.createSessionFactory(Unknown Source)

at com.fr.stable.db.session.SessionManager.createNewSessionFactory(Unknown Source)

at com.fr.stable.db.DBContext.init(Unknown Source)

at com.fr.decision.migration.manager.AbstractTransferManager.transfer(AbstractTransferManager.java:134)

at com.fr.decision.migration.manager.AbstractTransferManager.startTransfer(AbstractTransferManager.java:57)

at com.fr.decision.migration.MigrationContext$TransferManagerCollection.startTransfer(MigrationContext.java:216)

at com.fr.decision.migration.MigrationContext$1.run(MigrationContext.java:93)

at java.lang.Thread.run(Thread.java:748)

Caused by: java.sql.SQLNonTransientConnectionException: No operations allowed after connection closed.

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:526)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:505)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:479)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:489)

at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:66)

at com.mysql.cj.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:1882)

at com.mysql.cj.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java:1861)

at com.mysql.cj.jdbc.ConnectionImpl.getMetadataSafeStatement(ConnectionImpl.java:2147)

at com.mysql.cj.jdbc.DatabaseMetaData.getIndexInfo(DatabaseMetaData.java:2821)

at com.fr.third.org.hibernate.tool.schema.extract.internal.InformationExtractorJdbcDatabaseMetaDataImpl.getIndexes(InformationExtractorJdbcDatabaseMetaDataImpl.java:713)

... 20 more

Caused by: com.mysql.cj.core.exceptions.ConnectionIsClosedException: No operations allowed after connection closed.

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54)

at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:93)

at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:133)

at com.mysql.cj.jdbc.ConnectionImpl.checkClosed(ConnectionImpl.java:931)

at com.mysql.cj.jdbc.ConnectionImpl.createStatement(ConnectionImpl.java)

... 24 more


FineBI kloyf 发布于 2018-11-9 11:25
1min目标场景问卷 立即参与
回答问题
悬赏:5 F币 + 添加悬赏
提示:增加悬赏、完善问题、追问等操作,可使您的问题被置顶,并向所有关注者发送通知
共5回答
最佳回答
5
macro_hardLv1高级互助
发布于2018-11-9 11:52
No operations allowed after connection closed

没连上mysql8

最佳回答
0
lefantianLv2初级互助
发布于2018-11-9 11:41

Error accessing index information: finedb.fine_dep_role,这索引信息报错

最佳回答
0
neweguoLv2见习互助
发布于2020-2-22 14:28

default-storage-engine=INNOD
https://help.finebi.com/doc-view-529.html

原因分析:

               查看MySQL的数据引擎,为MyISAM数据引擎,该数据引擎为MySQL默认引擎,不支持事务,也不支持外键。且FineBI不支持MyISAM,后续不考虑兼容,因此需要为MySQL切换数据引擎为InnoDB;

              (此处查看引擎方法可使用:登录MySQL数据库,在mysql>提示符下搞入show engines 命令查看;)

解决方案:

                1. 在MySQL数据库配置文件my.cnf中的 [mysqld] 下面加入default-storage-engine=INNODB 一句,保存;

                2. 重启mysql服务器:mysqladmin -u root -p shutdown或者service mysqld restart。

                    登录mysql数据库,在mysql>提示符下输入show engines命令。如果出现 InnoDB |DEFAULT,则表示设置InnoDB为默认引擎成功;



最佳回答
0
ooshanghaiLv5初级互助
发布于2020-2-23 02:10

使用外部数据库???导入数据总是失败 ???

意思是finebi装在公网上,然后倒入公网比如阿里云的maxcompter架构的mysql数据?

或者finebi装在本地,需要从公网比如阿里云的mysql上倒入数据?


这样的话,你的驱动问题应该是。

最佳回答
0
miss_liLv2中级互助
发布于2020-8-24 22:55

配置外接数据库-https://help.finereport.com/doc-view-2458.html

  • 7关注人数
  • 3194浏览人数
  • 最后回答于:2020-8-24 22:55
    请选择关闭问题的原因
    确定 取消
    返回顶部