Closed greenhandzdl closed 2 years ago
Caused by: java.lang.Exception: No native library found for os.name=Linux, os.arch=s390x, paths=[/usr/java/packages/lib:/usr/lib/s390x-linux-gnu/jni:/lib/s390x-linux-gnu:/usr/lib/s390x-linux-gnu:/usr/lib/jni:/lib:/usr/lib] at mirai-hibernate-plugin-2.4.2.jar[shared]//org.sqlite.SQLiteJDBCLoader.loadSQLiteNativeLibrary(SQLiteJDBCLoader.java:389) at mirai-hibernate-plugin-2.4.2.jar[shared]//org.sqlite.SQLiteJDBCLoader.initialize(SQLiteJDBCLoader.java:68) at mirai-hibernate-plugin-2.4.2.jar[shared]//org.sqlite.core.NativeDB.load(NativeDB.java:63) at mirai-hibernate-plugin-2.4.2.jar[shared]//org.sqlite.SQLiteConnection.open(SQLiteConnection.java:240) ... 63 more
sqlite 数据库 不支持 s390x 你应该换一下 其他数据库,例如 h2 或 mysql
是对这个进行修改吗
linux1@gservice:~/mirai$ cat config/xyz.cssxsh.mirai.plugin.mirai-hibernate-plugin/hibernate.properties
hibernate.connection.url=jdbc:h2:file:./data/xyz.cssxsh.mirai.plugin.mirai-hibernate-plugin/hibernate.h2
hibernate.connection.driver_class=org.h2.Driver
hibernate.dialect=org.hibernate.dialect.H2Dialect
hibernate.connection.provider_class=org.hibernate.hikaricp.internal.HikariCPConnectionProvider
hibernate.hikari.connectionTimeout=180000
hibernate.connection.isolation=1
hibernate.hbm2ddl.auto=update
hibernate-connection-autocommit=true
hibernate.connection.show_sql=false
hibernate.autoReconnect=true
hibernate.current_session_context_class=thread
org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment] at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:267) at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:230) at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:207) at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.model.relational.Database.
(Database.java:44) at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.internal.InFlightMetadataCollectorImpl.getDatabase(InFlightMetadataCollectorImpl.java:217) at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.internal.InFlightMetadataCollectorImpl. (InFlightMetadataCollectorImpl.java:190) at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:138) at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:97) at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:402) at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:90) at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:735) at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:773) at pixiv-helper-2.0.0-M5.mirai2.jar//xyz.cssxsh.mirai.pixiv.model.PixivSqlLoadKt$factory$2.invoke(PixivSqlLoad.kt:36) at pixiv-helper-2.0.0-M5.mirai2.jar//xyz.cssxsh.mirai.pixiv.model.PixivSqlLoadKt$factory$2.invoke(PixivSqlLoad.kt:35) at kotlin.SynchronizedLazyImpl.getValue(LazyJVM.kt:74) at pixiv-helper-2.0.0-M5.mirai2.jar//xyz.cssxsh.mirai.pixiv.model.PixivSqlLoadKt.getFactory(PixivSqlLoad.kt:35) at pixiv-helper-2.0.0-M5.mirai2.jar//xyz.cssxsh.mirai.pixiv.PixivConfigKt.initConfiguration(PixivConfig.kt:94) at pixiv-helper-2.0.0-M5.mirai2.jar//xyz.cssxsh.mirai.pixiv.PixivHelperPlugin.onEnable(PixivHelperPlugin.kt:46)
找错了,你应该修改 pixiv插件 的那个
linux1@gservice:~/mirai$ cat config/xyz.cssxsh.mirai.plugin.pixiv-helper/hibernate.properties
hibernate.connection.url=jdbc:sqlite:file:./data/xyz.cssxsh.mirai.plugin.pixiv-helper/pixiv.sqlite
hibernate.connection.driver_class=mysql:mysql-connector-java:8.0.29
hibernate.dialect=org.hibernate.community.dialect.SQLiteDialect
hibernate.connection.provider_class=org.hibernate.hikaricp.internal.HikariCPConnectionProvider
hibernate.connection.isolation=1
hibernate-connection-autocommit=true
hibernate.connection.show_sql=false
hibernate.autoReconnect=true
hibernate.current_session_context_class=thread
这样还是有点问题
linux1@gservice:~/mirai$ cat config/xyz.cssxsh.mirai.plugin.pixiv-helper/hibernate.properties hibernate.connection.url=jdbc:sqlite:file:./data/xyz.cssxsh.mirai.plugin.pixiv-helper/pixiv.sqlite hibernate.connection.driver_class=mysql:mysql-connector-java:8.0.29 hibernate.dialect=org.hibernate.community.dialect.SQLiteDialect hibernate.connection.provider_class=org.hibernate.hikaricp.internal.HikariCPConnectionProvider hibernate.connection.isolation=1 hibernate-connection-autocommit=true hibernate.connection.show_sql=false hibernate.autoReconnect=true hibernate.current_session_context_class=thread
这样还是有点问题
谁和你说要这样改的
example 里面不是有模板吗
我用的mysql的那个模板,但还是红了
linux1@gservice:~/mirai$ cat config/xyz.cssxsh.mirai.plugin.pixiv-helper/hibernate.properties
hibernate.connection.url=jdbc:mysql://localhost:3306/mirai?autoReconnect=true
hibernate.connection.driver_class=com.mysql.cj.jdbc.Driver
hibernate.connection.CharSet=utf8mb4
hibernate.connection.useUnicode=true
hibernate.connection.username=root
hibernate.connection.password=root
hibernate.dialect=org.hibernate.dialect.MariaDBDialect
hibernate.connection.provider_class=org.hibernate.hikaricp.internal.HikariCPConnectionProvider
hibernate.connection.isolation=1
hibernate.hbm2ddl.auto=update
hibernate.autoReconnect=true
2022-07-28 06:52:27 I/mirai-hibernate-plugin: Database jdbc:h2:file:./data/xyz.cssxsh.mirai.plugin.mirai-hibernate-plugin/hibernate.h2 by H2 JDBC Driver.
2022-07-28 06:52:27 I/pixiv-helper: CacheFolder: /home/linux1/mirai/data/xyz.cssxsh.mirai.plugin.pixiv-helper/cache
2022-07-28 06:52:27 I/pixiv-helper: BackupFolder: /home/linux1/mirai/data/xyz.cssxsh.mirai.plugin.pixiv-helper/backup
2022-07-28 06:52:27 I/pixiv-helper: TempFolder: /home/linux1/mirai/data/xyz.cssxsh.mirai.plugin.pixiv-helper/temp
2022-07-28 06:52:32 E/pixiv-helper: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:267)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:230)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:207)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.model.relational.Database.<init>(Database.java:44)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.internal.InFlightMetadataCollectorImpl.getDatabase(InFlightMetadataCollectorImpl.java:217)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:190)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:138)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:97)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:402)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:90)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:735)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:773)
at pixiv-helper-2.0.0-M5.mirai2.jar//xyz.cssxsh.mirai.pixiv.model.PixivSqlLoadKt$factory$2.invoke(PixivSqlLoad.kt:36)
at pixiv-helper-2.0.0-M5.mirai2.jar//xyz.cssxsh.mirai.pixiv.model.PixivSqlLoadKt$factory$2.invoke(PixivSqlLoad.kt:35)
at kotlin.SynchronizedLazyImpl.getValue(LazyJVM.kt:74)
at pixiv-helper-2.0.0-M5.mirai2.jar//xyz.cssxsh.mirai.pixiv.model.PixivSqlLoadKt.getFactory(PixivSqlLoad.kt:35)
at pixiv-helper-2.0.0-M5.mirai2.jar//xyz.cssxsh.mirai.pixiv.PixivConfigKt.initConfiguration(PixivConfig.kt:94)
at pixiv-helper-2.0.0-M5.mirai2.jar//xyz.cssxsh.mirai.pixiv.PixivHelperPlugin.onEnable(PixivHelperPlugin.kt:46)
at net.mamoe.mirai.console.internal.plugin.JvmPluginInternal.internalOnEnable$mirai_console(JvmPluginInternal.kt:131)
at net.mamoe.mirai.console.internal.plugin.BuiltInJvmPluginLoaderImpl.enable(BuiltInJvmPluginLoaderImpl.kt:278)
at net.mamoe.mirai.console.internal.plugin.BuiltInJvmPluginLoaderImpl.enable(BuiltInJvmPluginLoaderImpl.kt:35)
at net.mamoe.mirai.console.plugin.jvm.JvmPluginLoader$BuiltIn.enable(JvmPluginLoader.kt)
at net.mamoe.mirai.console.plugin.jvm.JvmPluginLoader$BuiltIn.enable(JvmPluginLoader.kt:50)
at net.mamoe.mirai.console.plugin.PluginManager.enablePlugin(PluginManager.kt:173)
at net.mamoe.mirai.console.internal.plugin.PluginManagerImpl.enableAllLoadedPlugins$mirai_console(PluginManagerImpl.kt:178)
at net.mamoe.mirai.console.internal.MiraiConsoleImplementationBridge.doStart$mirai_console(MiraiConsoleImplementationBridge.kt:235)
at net.mamoe.mirai.console.MiraiConsoleImplementation$Companion.start(MiraiConsoleImplementation.kt:464)
at net.mamoe.mirai.console.terminal.MiraiConsoleTerminalLoader.startAsDaemon(MiraiConsoleTerminalLoader.kt:168)
at net.mamoe.mirai.console.terminal.MiraiConsoleTerminalLoader.startAsDaemon$default(MiraiConsoleTerminalLoader.kt:167)
at net.mamoe.mirai.console.terminal.MiraiConsoleTerminalLoader.main(MiraiConsoleTerminalLoader.kt:52)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.itxtech.mcl.Utility.bootJars(Utility.java:89)
at org.itxtech.mcl.Utility.bootJars(Utility.java:79)
at org.itxtech.mcl.Utility.bootMirai(Utility.java:101)
at org.itxtech.mcl.module.builtin.Boot.boot(Boot.java:109)
at org.itxtech.mcl.module.ModuleManager.phaseBoot(ModuleManager.java:148)
at org.itxtech.mcl.Loader.lambda$start$4(Loader.java:189)
at org.itxtech.mcl.Loader.tryCatching(Loader.java:146)
at org.itxtech.mcl.Loader.start(Loader.java:189)
at org.itxtech.mcl.Loader.main(Loader.java:79)
Caused by: org.hibernate.HibernateException: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.hikaricp.internal.HikariCPConnectionProvider.configure(HikariCPConnectionProvider.java:62)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:125)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:239)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:207)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess(JdbcEnvironmentInitiator.java:249)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:175)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:36)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:119)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:255)
... 42 more
Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:596)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:582)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81) at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.hikaricp.internal.HikariCPConnectionProvider.configure(HikariCPConnectionProvider.java:58)
... 50 more
Caused by: java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:898)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:823)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:448)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:241)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:198)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
... 53 more
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.base/java.lang.reflect.Constructor.newInstanceWithCaller(Constructor.java:499)
at java.base/java.lang.reflect.Constructor.newInstance(Constructor.java:480)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:89)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.NativeSession.connect(NativeSession.java:120)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:842)
... 62 more
Caused by: java.net.ConnectException: Connection refused
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:542)
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:597)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
at java.base/java.net.Socket.connect(Socket.java:633)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.protocol.StandardSocketFactory.connect(StandardSocketFactory.java:153)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.mysql.cj.protocol.a.NativeSocketConnection.connect(NativeSocketConnection.java:63)
... 64 more
mysql 是独立的数据库软件 如果你没装的话,请用 h2
话说这个mysql指的是mariadb吗还是社区版mysqld
h2的报错...
2022-07-28 07:05:17 E/pixiv-helper: 数据库初始化失败
org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "-- Illust Data\000aCREATE TABLE IF NOT EXISTS users\000a(\000a `uid` INTEGER NOT NULL,\000a `name` NVARCHAR(15) NOT NULL,\000a `account` VARCHAR(32) DEFAULT NULL,\000a PRIMARY KEY (`uid`),\000a UNIQUE [*]KEY (`account`)\000a)"; expected "("; SQL statement:
-- Illust Data
CREATE TABLE IF NOT EXISTS users
(
`uid` INTEGER NOT NULL,
`name` NVARCHAR(15) NOT NULL,
`account` VARCHAR(32) DEFAULT NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY (`account`)
) [42001-214]
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.message.DbException.getJdbcSQLException(DbException.java:502)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.message.DbException.getSyntaxError(DbException.java:261)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.getSyntaxError(Parser.java:900)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.read(Parser.java:5675)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.parseTableConstraintIf(Parser.java:9086)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.parseTableColumnDefinition(Parser.java:9321)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.parseCreateTable(Parser.java:9271)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.parseCreate(Parser.java:6784)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.parsePrepared(Parser.java:763)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.parse(Parser.java:689)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.parse(Parser.java:666)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.prepareCommand(Parser.java:569)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:92)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:288)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:327)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:90)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:176)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:75)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.query.sql.internal.NativeNonSelectQueryPlanImpl.lambda$executeUpdate$0(NativeNonSelectQueryPlanImpl.java:84)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.sql.exec.internal.StandardJdbcMutationExecutor.execute(StandardJdbcMutationExecutor.java:63)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.query.sql.internal.NativeNonSelectQueryPlanImpl.executeUpdate(NativeNonSelectQueryPlanImpl.java:78)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.query.sql.internal.NativeQueryImpl.doExecuteUpdate(NativeQueryImpl.java:814)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.query.spi.AbstractQuery.executeUpdate(AbstractQuery.java:643)
at pixiv-helper-2.0.0-M5.mirai2.jar//xyz.cssxsh.mirai.pixiv.model.PixivSqlLoadKt.create(PixivSqlLoad.kt:101)
at pixiv-helper-2.0.0-M5.mirai2.jar//xyz.cssxsh.mirai.pixiv.PixivConfigKt.initConfiguration(PixivConfig.kt:95)
at pixiv-helper-2.0.0-M5.mirai2.jar//xyz.cssxsh.mirai.pixiv.PixivHelperPlugin.onEnable(PixivHelperPlugin.kt:46)
at net.mamoe.mirai.console.internal.plugin.JvmPluginInternal.internalOnEnable$mirai_console(JvmPluginInternal.kt:131)
at net.mamoe.mirai.console.internal.plugin.BuiltInJvmPluginLoaderImpl.enable(BuiltInJvmPluginLoaderImpl.kt:278)
at net.mamoe.mirai.console.internal.plugin.BuiltInJvmPluginLoaderImpl.enable(BuiltInJvmPluginLoaderImpl.kt:35)
at net.mamoe.mirai.console.plugin.jvm.JvmPluginLoader$BuiltIn.enable(JvmPluginLoader.kt)
at net.mamoe.mirai.console.plugin.jvm.JvmPluginLoader$BuiltIn.enable(JvmPluginLoader.kt:50)
at net.mamoe.mirai.console.plugin.PluginManager.enablePlugin(PluginManager.kt:173)
at net.mamoe.mirai.console.internal.plugin.PluginManagerImpl.enableAllLoadedPlugins$mirai_console(PluginManagerImpl.kt:178)
at net.mamoe.mirai.console.internal.MiraiConsoleImplementationBridge.doStart$mirai_console(MiraiConsoleImplementationBridge.kt:235)
at net.mamoe.mirai.console.MiraiConsoleImplementation$Companion.start(MiraiConsoleImplementation.kt:464)
at net.mamoe.mirai.console.terminal.MiraiConsoleTerminalLoader.startAsDaemon(MiraiConsoleTerminalLoader.kt:168)
at net.mamoe.mirai.console.terminal.MiraiConsoleTerminalLoader.startAsDaemon$default(MiraiConsoleTerminalLoader.kt:167)
at net.mamoe.mirai.console.terminal.MiraiConsoleTerminalLoader.main(MiraiConsoleTerminalLoader.kt:52)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.itxtech.mcl.Utility.bootJars(Utility.java:89)
at org.itxtech.mcl.Utility.bootJars(Utility.java:79)
at org.itxtech.mcl.Utility.bootMirai(Utility.java:101)
at org.itxtech.mcl.module.builtin.Boot.boot(Boot.java:109)
at org.itxtech.mcl.module.ModuleManager.phaseBoot(ModuleManager.java:148)
at org.itxtech.mcl.Loader.lambda$start$4(Loader.java:189)
at org.itxtech.mcl.Loader.tryCatching(Loader.java:146)
at org.itxtech.mcl.Loader.start(Loader.java:189)
at org.itxtech.mcl.Loader.main(Loader.java:79)
2022-07-28 07:05:17 E/pixiv-helper: jakarta.persistence.PersistenceException: Converting `org.hibernate.exception.SQLGrammarException` to JPA `PersistenceException` : could not prepare statement
jakarta.persistence.PersistenceException: Converting `org.hibernate.exception.SQLGrammarException` to JPA `PersistenceException` : could not prepare statement
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:165)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:175)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.query.spi.AbstractQuery.executeUpdate(AbstractQuery.java:654)
at pixiv-helper-2.0.0-M5.mirai2.jar//xyz.cssxsh.mirai.pixiv.model.PixivSqlLoadKt.create(PixivSqlLoad.kt:101)
at pixiv-helper-2.0.0-M5.mirai2.jar//xyz.cssxsh.mirai.pixiv.PixivConfigKt.initConfiguration(PixivConfig.kt:95)
at pixiv-helper-2.0.0-M5.mirai2.jar//xyz.cssxsh.mirai.pixiv.PixivHelperPlugin.onEnable(PixivHelperPlugin.kt:46)
at net.mamoe.mirai.console.internal.plugin.JvmPluginInternal.internalOnEnable$mirai_console(JvmPluginInternal.kt:131)
at net.mamoe.mirai.console.internal.plugin.BuiltInJvmPluginLoaderImpl.enable(BuiltInJvmPluginLoaderImpl.kt:278)
at net.mamoe.mirai.console.internal.plugin.BuiltInJvmPluginLoaderImpl.enable(BuiltInJvmPluginLoaderImpl.kt:35)
at net.mamoe.mirai.console.plugin.jvm.JvmPluginLoader$BuiltIn.enable(JvmPluginLoader.kt)
at net.mamoe.mirai.console.plugin.jvm.JvmPluginLoader$BuiltIn.enable(JvmPluginLoader.kt:50)
at net.mamoe.mirai.console.plugin.PluginManager.enablePlugin(PluginManager.kt:173)
at net.mamoe.mirai.console.internal.plugin.PluginManagerImpl.enableAllLoadedPlugins$mirai_console(PluginManagerImpl.kt:178)
at net.mamoe.mirai.console.internal.MiraiConsoleImplementationBridge.doStart$mirai_console(MiraiConsoleImplementationBridge.kt:235)
at net.mamoe.mirai.console.MiraiConsoleImplementation$Companion.start(MiraiConsoleImplementation.kt:464)
at net.mamoe.mirai.console.terminal.MiraiConsoleTerminalLoader.startAsDaemon(MiraiConsoleTerminalLoader.kt:168)
at net.mamoe.mirai.console.terminal.MiraiConsoleTerminalLoader.startAsDaemon$default(MiraiConsoleTerminalLoader.kt:167)
at net.mamoe.mirai.console.terminal.MiraiConsoleTerminalLoader.main(MiraiConsoleTerminalLoader.kt:52)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.itxtech.mcl.Utility.bootJars(Utility.java:89)
at org.itxtech.mcl.Utility.bootJars(Utility.java:79)
at org.itxtech.mcl.Utility.bootMirai(Utility.java:101)
at org.itxtech.mcl.module.builtin.Boot.boot(Boot.java:109)
at org.itxtech.mcl.module.ModuleManager.phaseBoot(ModuleManager.java:148)
at org.itxtech.mcl.Loader.lambda$start$4(Loader.java:189)
at org.itxtech.mcl.Loader.tryCatching(Loader.java:146)
at org.itxtech.mcl.Loader.start(Loader.java:189)
at org.itxtech.mcl.Loader.main(Loader.java:79)
Caused by: org.hibernate.exception.SQLGrammarException: could not prepare statement
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:64)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:56)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:186)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:75)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.query.sql.internal.NativeNonSelectQueryPlanImpl.lambda$executeUpdate$0(NativeNonSelectQueryPlanImpl.java:84)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.sql.exec.internal.StandardJdbcMutationExecutor.execute(StandardJdbcMutationExecutor.java:63)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.query.sql.internal.NativeNonSelectQueryPlanImpl.executeUpdate(NativeNonSelectQueryPlanImpl.java:78)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.query.sql.internal.NativeQueryImpl.doExecuteUpdate(NativeQueryImpl.java:814)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.query.spi.AbstractQuery.executeUpdate(AbstractQuery.java:643)
... 28 more
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "-- Illust Data\000aCREATE TABLE IF NOT EXISTS users\000a(\000a `uid` INTEGER NOT NULL,\000a `name` NVARCHAR(15) NOT NULL,\000a `account` VARCHAR(32) DEFAULT NULL,\000a PRIMARY KEY (`uid`),\000a UNIQUE [*]KEY (`account`)\000a)"; expected "("; SQL statement:
-- Illust Data
CREATE TABLE IF NOT EXISTS users
(
`uid` INTEGER NOT NULL,
`name` NVARCHAR(15) NOT NULL,
`account` VARCHAR(32) DEFAULT NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY (`account`)
) [42001-214]
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.message.DbException.getJdbcSQLException(DbException.java:502)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.message.DbException.getSyntaxError(DbException.java:261)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.getSyntaxError(Parser.java:900)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.read(Parser.java:5675)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.parseTableConstraintIf(Parser.java:9086)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.parseTableColumnDefinition(Parser.java:9321)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.parseCreateTable(Parser.java:9271)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.parseCreate(Parser.java:6784)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.parsePrepared(Parser.java:763)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.parse(Parser.java:689)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.parse(Parser.java:666)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.command.Parser.prepareCommand(Parser.java:569)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:631)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:554)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1116)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:92)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:288)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:327)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:90)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:176)
... 34 more
哦,pixiv可能还没有适配 h2
2022-07-30 06:27:35 E/mirai-hibernate-plugin: org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
org.hibernate.service.spi.ServiceException: Unable to create requested service [org.hibernate.engine.jdbc.env.spi.JdbcEnvironment]
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:267)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:230)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:207)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.model.relational.Database.<init>(Database.java:44)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.internal.InFlightMetadataCollectorImpl.getDatabase(InFlightMetadataCollectorImpl.java:217)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.internal.InFlightMetadataCollectorImpl.<init>(InFlightMetadataCollectorImpl.java:190)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete(MetadataBuildingProcess.java:138)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.model.process.spi.MetadataBuildingProcess.build(MetadataBuildingProcess.java:97)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:402)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.internal.MetadataBuilderImpl.build(MetadataBuilderImpl.java:90)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:735)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:773)
at mirai-hibernate-plugin-2.4.2.jar//xyz.cssxsh.mirai.hibernate.MiraiHibernatePlugin.onEnable(MiraiHibernatePlugin.kt:41)
at net.mamoe.mirai.console.internal.plugin.JvmPluginInternal.internalOnEnable$mirai_console(JvmPluginInternal.kt:131)
at net.mamoe.mirai.console.internal.plugin.BuiltInJvmPluginLoaderImpl.enable(BuiltInJvmPluginLoaderImpl.kt:278)
at net.mamoe.mirai.console.internal.plugin.BuiltInJvmPluginLoaderImpl.enable(BuiltInJvmPluginLoaderImpl.kt:35)
at net.mamoe.mirai.console.plugin.jvm.JvmPluginLoader$BuiltIn.enable(JvmPluginLoader.kt)
at net.mamoe.mirai.console.plugin.jvm.JvmPluginLoader$BuiltIn.enable(JvmPluginLoader.kt:50)
at net.mamoe.mirai.console.plugin.PluginManager.enablePlugin(PluginManager.kt:173)
at net.mamoe.mirai.console.internal.plugin.PluginManagerImpl.enableAllLoadedPlugins$mirai_console(PluginManagerImpl.kt:178)
at net.mamoe.mirai.console.internal.MiraiConsoleImplementationBridge.doStart$mirai_console(MiraiConsoleImplementationBridge.kt:235)
at net.mamoe.mirai.console.MiraiConsoleImplementation$Companion.start(MiraiConsoleImplementation.kt:464)
at net.mamoe.mirai.console.terminal.MiraiConsoleTerminalLoader.startAsDaemon(MiraiConsoleTerminalLoader.kt:168)
at net.mamoe.mirai.console.terminal.MiraiConsoleTerminalLoader.startAsDaemon$default(MiraiConsoleTerminalLoader.kt:167)
at net.mamoe.mirai.console.terminal.MiraiConsoleTerminalLoader.main(MiraiConsoleTerminalLoader.kt:52)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:568)
at org.itxtech.mcl.Utility.bootJars(Utility.java:89)
at org.itxtech.mcl.Utility.bootJars(Utility.java:79)
at org.itxtech.mcl.Utility.bootMirai(Utility.java:101)
at org.itxtech.mcl.module.builtin.Boot.boot(Boot.java:109)
at org.itxtech.mcl.module.ModuleManager.phaseBoot(ModuleManager.java:148)
at org.itxtech.mcl.Loader.lambda$start$4(Loader.java:189)
at org.itxtech.mcl.Loader.tryCatching(Loader.java:146)
at org.itxtech.mcl.Loader.start(Loader.java:189)
at org.itxtech.mcl.Loader.main(Loader.java:79)
Caused by: org.hibernate.HibernateException: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Database may be already in use: "/home/linux1/mirai/data/xyz.cssxsh.mirai.plugin.mirai-hibernate-plugin/hibernate.h2.mv.db". Possible solutions: close all other connection(s); use the server mode [90020-214]
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.hikaricp.internal.HikariCPConnectionProvider.configure(HikariCPConnectionProvider.java:62)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:125)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:239)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:207)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.buildJdbcConnectionAccess(JdbcEnvironmentInitiator.java:249)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:175)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService(JdbcEnvironmentInitiator.java:36)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService(StandardServiceRegistryImpl.java:119)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.service.internal.AbstractServiceRegistryImpl.createService(AbstractServiceRegistryImpl.java:255)
... 37 more
Caused by: com.zaxxer.hikari.pool.HikariPool$PoolInitializationException: Failed to initialize pool: Database may be already in use: "/home/linux1/mirai/data/xyz.cssxsh.mirai.plugin.mirai-hibernate-plugin/hibernate.h2.mv.db". Possible solutions: close all other connection(s); use the server mode [90020-214]
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.pool.HikariPool.throwPoolInitializationException(HikariPool.java:596)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:582)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.HikariDataSource.<init>(HikariDataSource.java:81)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.hibernate.hikaricp.internal.HikariCPConnectionProvider.configure(HikariCPConnectionProvider.java:58)
... 45 more
Caused by: org.h2.jdbc.JdbcSQLNonTransientConnectionException: Database may be already in use: "/home/linux1/mirai/data/xyz.cssxsh.mirai.plugin.mirai-hibernate-plugin/hibernate.h2.mv.db". Possible solutions: close all other connection(s); use the server mode [90020-214]
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.message.DbException.getJdbcSQLException(DbException.java:678)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.message.DbException.get(DbException.java:212)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.mvstore.db.Store.convertMVStoreException(Store.java:168)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.mvstore.db.Store.<init>(Store.java:145)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.engine.Database.<init>(Database.java:324)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.engine.Engine.openSession(Engine.java:92)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.engine.Engine.openSession(Engine.java:222)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.engine.Engine.createSession(Engine.java:201)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.Driver.connect(Driver.java:59)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:121)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
at mirai-hibernate-plugin-2.4.2.jar[shared]//com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
... 48 more
Caused by: org.h2.mvstore.MVStoreException: The file is locked: /home/linux1/mirai/data/xyz.cssxsh.mirai.plugin.mirai-hibernate-plugin/hibernate.h2.mv.db [2.1.214/7]
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.mvstore.FileStore.open(FileStore.java:178)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.mvstore.FileStore.open(FileStore.java:128)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.mvstore.MVStore.<init>(MVStore.java:452)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.mvstore.MVStore$Builder.open(MVStore.java:4082)
at mirai-hibernate-plugin-2.4.2.jar[shared]//org.h2.mvstore.db.Store.<init>(Store.java:136)
... 60 more
2022-07-30 06:27:35 E/JvmPluginLoader: Failed to enable 'pixiv-helper' because dependencies not enabled: 'mirai-hibernate-plugin'
2022-07-30 06:27:35 I/MCL Addon: iTXTech MCL Version: 2.1.0-71ec418
2022-07-30 06:27:35 W/MCL Addon: iTXTech Soyuz 未安装,Soyuz MCL Handler 特性已禁用
2022-07-30 06:27:35 I/plugin_9 Author - HRS LSys idiom Loaded:
2022-07-30 06:27:35 I/main: 24 plugin(s) enabled.
2022-07-30 06:27:35 I/main: Auto-login 742431945
2022-07-30 06:27:36 I/Bot.742431945: Loaded account secrets from local cache.
2022-07-30 06:27:36 I/Bot.742431945: Saved account secrets to local cache for fast login.
2022-07-30 06:27:37 I/Bot.742431945: Login successful.
2022-07-30 06:27:38 V/Bot.742431945: Event: BotOnlineEvent(bot=Bot(742431945))
2022-07-30 06:27:38 I/Bot.742431945: Bot login successful.
2022-07-30 06:27:38 I/main: mirai-console started successfully.
2022-07-30 06:27:38 I/stdout: 开启定时任务:好感度及每日状态重载
2022-07-30 06:27:38 I/stdout: 好感度及每日状态重载完毕
> stop
Stopping mirai-console
2022-07-30 06:30:01 V/Bot.742431945: Event: BotOfflineEvent.Active(bot=Bot(742431945), cause=kotlinx.coroutines.JobCancellationException: Job was cancelled; job=SupervisorJobImpl{Cancelling}@6a7a665b, reconnect=false)
2022-07-30 06:30:01 I/Bot.742431945: Bot cancelled: Job was cancelled
2022-07-30 06:30:01 I/HuYanSession: HuYanSession已卸载!
2022-07-30 06:30:01 I/Molly: 已卸载
2022-07-30 06:30:01 I/CaiyunAI: 卸载完毕
>
mirai-console stopped successfully.
2022-07-30 06:30:02 W/stderr:
linux1@gservice:~/mirai$ cat config/xyz.cssxsh.mirai.plugin.
xyz.cssxsh.mirai.plugin.mirai-hibernate-plugin/ xyz.cssxsh.mirai.plugin.pixiv-helper/
linux1@gservice:~/mirai$ cat config/xyz.cssxsh.mirai.plugin.pixiv-helper/
hibernate.properties ImageSearchConfig.yml PixivConfig.yml PixivGifConfig.yml PixivHelperSettings.yml
linux1@gservice:~/mirai$ cat config/xyz.cssxsh.mirai.plugin.pixiv-helper/hibernate.properties
hibernate.connection.url=jdbc:h2:file:./data/xyz.cssxsh.mirai.plugin.mirai-hibernate-plugin/record.h2
hibernate.connection.driver_class=org.h2.Driver
hibernate.dialect=org.hibernate.dialect.H2Dialect
hibernate.connection.provider_class=org.hibernate.hikaricp.internal.HikariCPConnectionProvider
hibernate.connection.isolation=1
hibernate.hbm2ddl.auto=update
hibernate-connection-autocommit=true
linux1@gservice:~/mirai$
这个mcl删了还是怎么。。
linux1@gservice:~/mirai$ ls plugins
a1-miraiLSys.jar HiveSearchFroQQ-1.1.0.mirai2.jar mirai-console-jnr-plugin-1.1.0.mirai.jar z1-Lsys-GetPic.jar
AntiSetu-0.0.3.mirai.jar HoshiniYumemi-0.0.3.mirai.jar mirai-hibernate-plugin-2.4.2.jar z2-Lsys-GetSong.jar
CaiyunAI-1.0.2.jar HuYanSession-1.11.27.mirai2.jar mirai-hibernate-plugin-2.4.2.sha1 z3-Lsys-PicParser.jar
chat-command-0.5.1.jar libs-ttsj.jar MiraiSongPlugin-2.7-1.1.7.jar z4-Lsys-Score1.jar
chat-command-0.5.1.metadata mcl-addon-2.0.2.jar Molly-1.2.0.mirai.jar z5-Lsys-Score2.jar
chat-command-0.5.1.sha1 mcl-addon-2.0.2.sha1 petpet-4.0.mirai2.jar z6-Lsys-idiom.jar
douDiZhu-1.1.2.jar mirai-api-http-2.5.2.jar pixiv-helper-2.0.0-M6.mirai2.jar z7-Lsys-repeat.jar
GenshinGacha-1.2.1.mirai.jar mirai-api-http-2.5.2.sha1 simple-welcome-plugin-1.1.0.mirai.jar
group-1.0.1.jar MiraiCallApiPlugin-v2.4.jar testmiraidemo-0.1.6.mirai2.jar
linux1@gservice:~/mirai$ cat config.json
{
"module_packages": [
"mcl:org.itxtech.mcl.module.builtin"
],
"mirai_repo": "https://repo.itxtech.org",
"maven_repo": [
"https://maven.aliyun.com/repository/public"
],
"packages": {
"net.mamoe:mirai-console": {
"channel": "stable",
"version": "2.12.0",
"type": "libs",
"versionLocked": false
},
"net.mamoe:mirai-console-terminal": {
"channel": "stable",
"version": "2.12.0",
"type": "libs",
"versionLocked": false
},
"net.mamoe:mirai-core-all": {
"channel": "stable",
"version": "2.12.0",
"type": "libs",
"versionLocked": false
},
"org.itxtech:mcl-addon": {
"channel": "c2001",
"version": "2.0.2",
"type": "plugins",
"versionLocked": false
},
"net.mamoe:mirai-api-http": {
"channel": "stable-v2",
"version": "2.5.2",
"type": "plugins",
"versionLocked": false
},
"xyz.cssxsh.mirai:mirai-hibernate-plugin": {
"channel": "stable",
"version": "2.4.2",
"type": "plugins",
"versionLocked": false
},
"net.mamoe:chat-command": {
"channel": "stable",
"version": "0.5.1",
"type": "plugins",
"versionLocked": false
}
},
"archiveSuffix": [
".zip",
".mirai2.jar",
".mirai.jar",
"-all.jar",
".jar"
],
"disabled_modules": [],
"proxy": "",
"log_level": 1,
"modules_props": {}
linux1@gservice:~/mirai$ cat config/xyz.cssxsh.mirai.plugin.pixiv-helper/hibernate.properties hibernate.connection.url=jdbc:h2:file:./data/xyz.cssxsh.mirai.plugin.mirai-hibernate-plugin/record.h2
你给 pixiv-helper 配置 mirai-hibernate-plugin 的文件路径干嘛, 一个文件被两个插件同时使用,你这样不就冲突了吗