在BC中使用XConomy,一直在报错,断连数据库,连接数据库[09:58:27 INFO]: [XConomy] 无法连接到数据库-----
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Shutdown initiated...
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Shutdown completed.
[09:58:27 WARN]: java.sql.SQLTransientConnectionException: XConomy - Connection is not available, request timed out after 30001ms.
[09:58:27 WARN]: at me.yic.libs.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:695)
[09:58:27 WARN]: at me.yic.libs.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
[09:58:27 WARN]: at me.yic.libs.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
[09:58:27 WARN]: at me.yic.libs.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
[09:58:27 WARN]: at me.yic.xconomy.utils.DatabaseConnection.getConnection(DatabaseConnection.java:158)
[09:58:27 WARN]: at me.yic.xconomy.utils.DatabaseConnection.getConnectionAndCheck(DatabaseConnection.java:140)
[09:58:27 WARN]: at me.yic.xconomy.data.sql.SQL.select(SQL.java:258)
[09:58:27 WARN]: at me.yic.xconomy.data.DataCon.getBal(DataCon.java:83)
[09:58:27 WARN]: at me.yic.xconomy.data.caches.Cache.getBalanceFromCacheOrDB(Cache.java:80)
[09:58:27 WARN]: at me.yic.xconomy.depend.economy.Vault.getBalance(Vault.java:145)
[09:58:27 WARN]: at net.milkbowl.vault.economy.AbstractEconomy.getBalance(AbstractEconomy.java:22)
[09:58:27 WARN]: at com.extendedclip.papi.expansion.vault.VaultEcoHook.getBalance(VaultEcoHook.java:223)
[09:58:27 WARN]: at com.extendedclip.papi.expansion.vault.VaultEcoHook.onPlaceholderRequest(VaultEcoHook.java:175)
[09:58:27 WARN]: at com.extendedclip.papi.expansion.vault.VaultExpansion.onRequest(VaultExpansion.java:108)
[09:58:27 WARN]: at me.clip.placeholderapi.replacer.CharsReplacer.apply(CharsReplacer.java:161)
[09:58:27 WARN]: at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:70)
[09:58:27 WARN]: at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:98)
[09:58:27 WARN]: at me.neznamy.tab.platforms.bukkit.BukkitPlatform.lambda$registerUnknownPlaceholder$2(BukkitPlatform.java:187)
[09:58:27 WARN]: at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.request(PlayerPlaceholderImpl.java:114)
[09:58:27 WARN]: at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.update(PlayerPlaceholderImpl.java:52)
[09:58:27 WARN]: at me.neznamy.tab.shared.features.PlaceholderManagerImpl.updatePlayerPlaceholder(PlaceholderManagerImpl.java:121)
[09:58:27 WARN]: at me.neznamy.tab.shared.features.PlaceholderManagerImpl.refresh(PlaceholderManagerImpl.java:67)
[09:58:27 WARN]: at me.neznamy.tab.shared.CpuManager.lambda$runMeasuredTask$8(CpuManager.java:353)
[09:58:27 WARN]: at me.neznamy.tab.shared.CpuManager.lambda$submit$1(CpuManager.java:115)
[09:58:27 WARN]: at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
[09:58:27 WARN]: at java.util.concurrent.FutureTask.run(Unknown Source)
[09:58:27 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[09:58:27 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[09:58:27 WARN]: at java.lang.Thread.run(Unknown Source)
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Starting...
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Start completed.
[09:57:57 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'UID' in 'where clause'
[09:57:57 WARN]: at sun.reflect.GeneratedConstructorAccessor177.newInstance(Unknown Source)
[09:57:57 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[09:57:57 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[09:57:57 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[09:57:57 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
[09:57:57 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
[09:57:57 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
[09:57:57 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
[09:57:57 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
[09:57:57 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
[09:57:57 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
[09:57:57 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
[09:57:57 WARN]: at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
[09:57:57 WARN]: at me.yic.libs.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
[09:57:57 WARN]: at me.yic.libs.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
[09:57:57 WARN]: at me.yic.xconomy.data.sql.SQL.select(SQL.java:262)
[09:57:57 WARN]: at me.yic.xconomy.data.DataCon.getBal(DataCon.java:83)
[09:57:57 WARN]: at me.yic.xconomy.data.caches.Cache.getBalanceFromCacheOrDB(Cache.java:80)
[09:57:57 WARN]: at me.yic.xconomy.depend.economy.Vault.getBalance(Vault.java:146)
[09:57:57 WARN]: at net.milkbowl.vault.economy.AbstractEconomy.getBalance(AbstractEconomy.java:22)
[09:57:57 WARN]: at com.extendedclip.papi.expansion.vault.VaultEcoHook.getBalance(VaultEcoHook.java:223)
[09:57:57 WARN]: at com.extendedclip.papi.expansion.vault.VaultEcoHook.onPlaceholderRequest(VaultEcoHook.java:175)
[09:57:57 WARN]: at com.extendedclip.papi.expansion.vault.VaultExpansion.onRequest(VaultExpansion.java:108)
[09:57:57 WARN]: at me.clip.placeholderapi.replacer.CharsReplacer.apply(CharsReplacer.java:161)
[09:57:57 WARN]: at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:70)
[09:57:57 WARN]: at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:98)
[09:57:57 WARN]: at me.neznamy.tab.platforms.bukkit.BukkitPlatform.lambda$registerUnknownPlaceholder$2(BukkitPlatform.java:187)
[09:57:57 WARN]: at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.request(PlayerPlaceholderImpl.java:114)
[09:57:57 WARN]: at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.update(PlayerPlaceholderImpl.java:52)
[09:57:57 WARN]: at me.neznamy.tab.shared.features.PlaceholderManagerImpl.updatePlayerPlaceholder(PlaceholderManagerImpl.java:121)
[09:57:57 WARN]: at me.neznamy.tab.shared.features.PlaceholderManagerImpl.refresh(PlaceholderManagerImpl.java:67)
[09:57:57 WARN]: at me.neznamy.tab.shared.CpuManager.lambda$runMeasuredTask$8(CpuManager.java:353)
[09:57:57 WARN]: at me.neznamy.tab.shared.CpuManager.lambda$submit$1(CpuManager.java:115)
[09:57:57 WARN]: at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
[09:57:57 WARN]: at java.util.concurrent.FutureTask.run(Unknown Source)
[09:57:57 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[09:57:57 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[09:57:57 WARN]: at java.lang.Thread.run(Unknown Source)
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Shutdown initiated...
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Shutdown completed.
[09:58:27 WARN]: java.sql.SQLTransientConnectionException: XConomy - Connection is not available, request timed out after 30001ms.
[09:58:27 WARN]: at me.yic.libs.zaxxer.hikari.pool.HikariPool.createTimeoutException(HikariPool.java:695)
[09:58:27 WARN]: at me.yic.libs.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:197)
[09:58:27 WARN]: at me.yic.libs.zaxxer.hikari.pool.HikariPool.getConnection(HikariPool.java:162)
[09:58:27 WARN]: at me.yic.libs.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128)
[09:58:27 WARN]: at me.yic.xconomy.utils.DatabaseConnection.getConnection(DatabaseConnection.java:158)
[09:58:27 WARN]: at me.yic.xconomy.utils.DatabaseConnection.getConnectionAndCheck(DatabaseConnection.java:140)
[09:58:27 WARN]: at me.yic.xconomy.data.sql.SQL.select(SQL.java:258)
[09:58:27 WARN]: at me.yic.xconomy.data.DataCon.getBal(DataCon.java:83)
[09:58:27 WARN]: at me.yic.xconomy.data.caches.Cache.getBalanceFromCacheOrDB(Cache.java:80)
[09:58:27 WARN]: at me.yic.xconomy.depend.economy.Vault.getBalance(Vault.java:145)
[09:58:27 WARN]: at net.milkbowl.vault.economy.AbstractEconomy.getBalance(AbstractEconomy.java:22)
[09:58:27 WARN]: at com.extendedclip.papi.expansion.vault.VaultEcoHook.getBalance(VaultEcoHook.java:223)
[09:58:27 WARN]: at com.extendedclip.papi.expansion.vault.VaultEcoHook.onPlaceholderRequest(VaultEcoHook.java:175)
[09:58:27 WARN]: at com.extendedclip.papi.expansion.vault.VaultExpansion.onRequest(VaultExpansion.java:108)
[09:58:27 WARN]: at me.clip.placeholderapi.replacer.CharsReplacer.apply(CharsReplacer.java:161)
[09:58:27 WARN]: at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:70)
[09:58:27 WARN]: at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:98)
[09:58:27 WARN]: at me.neznamy.tab.platforms.bukkit.BukkitPlatform.lambda$registerUnknownPlaceholder$2(BukkitPlatform.java:187)
[09:58:27 WARN]: at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.request(PlayerPlaceholderImpl.java:114)
[09:58:27 WARN]: at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.update(PlayerPlaceholderImpl.java:52)
[09:58:27 WARN]: at me.neznamy.tab.shared.features.PlaceholderManagerImpl.updatePlayerPlaceholder(PlaceholderManagerImpl.java:121)
[09:58:27 WARN]: at me.neznamy.tab.shared.features.PlaceholderManagerImpl.refresh(PlaceholderManagerImpl.java:67)
[09:58:27 WARN]: at me.neznamy.tab.shared.CpuManager.lambda$runMeasuredTask$8(CpuManager.java:353)
[09:58:27 WARN]: at me.neznamy.tab.shared.CpuManager.lambda$submit$1(CpuManager.java:115)
[09:58:27 WARN]: at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
[09:58:27 WARN]: at java.util.concurrent.FutureTask.run(Unknown Source)
[09:58:27 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[09:58:27 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[09:58:27 WARN]: at java.lang.Thread.run(Unknown Source)
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Starting...
[09:58:27 WARN]: [TAB Processing Thread] INFO me.yic.libs.zaxxer.hikari.HikariDataSource - XConomy - Start completed.
[09:57:57 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'UID' in 'where clause'
[09:57:57 WARN]: at sun.reflect.GeneratedConstructorAccessor177.newInstance(Unknown Source)
[09:57:57 WARN]: at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[09:57:57 WARN]: at java.lang.reflect.Constructor.newInstance(Unknown Source)
[09:57:57 WARN]: at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
[09:57:57 WARN]: at com.mysql.jdbc.Util.getInstance(Util.java:408)
[09:57:57 WARN]: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
[09:57:57 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3976)
[09:57:57 WARN]: at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3912)
[09:57:57 WARN]: at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
[09:57:57 WARN]: at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
[09:57:57 WARN]: at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2486)
[09:57:57 WARN]: at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
[09:57:57 WARN]: at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
[09:57:57 WARN]: at me.yic.libs.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
[09:57:57 WARN]: at me.yic.libs.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
[09:57:57 WARN]: at me.yic.xconomy.data.sql.SQL.select(SQL.java:262)
[09:57:57 WARN]: at me.yic.xconomy.data.DataCon.getBal(DataCon.java:83)
[09:57:57 WARN]: at me.yic.xconomy.data.caches.Cache.getBalanceFromCacheOrDB(Cache.java:80)
[09:57:57 WARN]: at me.yic.xconomy.depend.economy.Vault.getBalance(Vault.java:146)
[09:57:57 WARN]: at net.milkbowl.vault.economy.AbstractEconomy.getBalance(AbstractEconomy.java:22)
[09:57:57 WARN]: at com.extendedclip.papi.expansion.vault.VaultEcoHook.getBalance(VaultEcoHook.java:223)
[09:57:57 WARN]: at com.extendedclip.papi.expansion.vault.VaultEcoHook.onPlaceholderRequest(VaultEcoHook.java:175)
[09:57:57 WARN]: at com.extendedclip.papi.expansion.vault.VaultExpansion.onRequest(VaultExpansion.java:108)
[09:57:57 WARN]: at me.clip.placeholderapi.replacer.CharsReplacer.apply(CharsReplacer.java:161)
[09:57:57 WARN]: at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:70)
[09:57:57 WARN]: at me.clip.placeholderapi.PlaceholderAPI.setPlaceholders(PlaceholderAPI.java:98)
[09:57:57 WARN]: at me.neznamy.tab.platforms.bukkit.BukkitPlatform.lambda$registerUnknownPlaceholder$2(BukkitPlatform.java:187)
[09:57:57 WARN]: at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.request(PlayerPlaceholderImpl.java:114)
[09:57:57 WARN]: at me.neznamy.tab.shared.placeholders.PlayerPlaceholderImpl.update(PlayerPlaceholderImpl.java:52)
[09:57:57 WARN]: at me.neznamy.tab.shared.features.PlaceholderManagerImpl.updatePlayerPlaceholder(PlaceholderManagerImpl.java:121)
[09:57:57 WARN]: at me.neznamy.tab.shared.features.PlaceholderManagerImpl.refresh(PlaceholderManagerImpl.java:67)
[09:57:57 WARN]: at me.neznamy.tab.shared.CpuManager.lambda$runMeasuredTask$8(CpuManager.java:353)
[09:57:57 WARN]: at me.neznamy.tab.shared.CpuManager.lambda$submit$1(CpuManager.java:115)
[09:57:57 WARN]: at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
[09:57:57 WARN]: at java.util.concurrent.FutureTask.run(Unknown Source)
[09:57:57 WARN]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[09:57:57 WARN]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[09:57:57 WARN]: at java.lang.Thread.run(Unknown Source)
如果想要同步数据,不需要使用mysql,只需要在database.yml修改为例如
其中一个服务器是
SQLite:
#Address is the folder path
path: Default
这个服务器地址在'D:\mineserverall\Survival01\
那么另一个要同步是服务器就改为
SQLite:
#Address is the folder path
path: 'D:\mineserverall\Survival01\plugins\XConomy\playerdata\'
就可以实现同步数据
其中一个服务器是
SQLite:
#Address is the folder path
path: Default
这个服务器地址在'D:\mineserverall\Survival01\
那么另一个要同步是服务器就改为
SQLite:
#Address is the folder path
path: 'D:\mineserverall\Survival01\plugins\XConomy\playerdata\'
就可以实现同步数据
OOTW_Z 发表于 2022-6-28 10:08
如果想要同步数据,不需要使用mysql,只需要在database.yml修改为例如
其中一个服务器是
SQLite:
我不是一台机子开的bc,我是几台机子一起开的,没办法用本地同步
在保证Xconomy是最新版的情况下,排除数据库类写错,有如下可能:
首先你要保证数据库端口是开放的,默认3306,因为报错有链接超时java.sql.SQLTransientConnectionException: XConomy - Connection is not available, request timed out after 30001ms.
其次检查数据库、表是否是Xconomy创建的,否则表项不匹配,会引起 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'UID' in 'where clause'
最后错误相关方法名内含有papi,在上述两个确保正确后,可以删掉/更新papi来进行最后检查
其中蹦极需要改的配置有:
database.yml
Settings:
#SQLite MySQL
storage-type: SQLite
#MySQL settings
MySQL:
host: localhost
port: 3306
user: root
pass: root
database: data
config.yml
BungeeCord:
#Whether to enable BungeeCord synchronization
#After BungeeCord sync is turned on, the console and other plugins will not be able to modify the balance in the server without player
#Please Set bungeecord to true in the spigot.yml
enable: false
#Server ID, keep the ID and the MySQL settings is the same between the servers requiring synchronization
sign: aa
首先你要保证数据库端口是开放的,默认3306,因为报错有链接超时java.sql.SQLTransientConnectionException: XConomy - Connection is not available, request timed out after 30001ms.
其次检查数据库、表是否是Xconomy创建的,否则表项不匹配,会引起 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'UID' in 'where clause'
最后错误相关方法名内含有papi,在上述两个确保正确后,可以删掉/更新papi来进行最后检查
其中蹦极需要改的配置有:
database.yml
Settings:
#SQLite MySQL
storage-type: SQLite
#MySQL settings
MySQL:
host: localhost
port: 3306
user: root
pass: root
database: data
config.yml
BungeeCord:
#Whether to enable BungeeCord synchronization
#After BungeeCord sync is turned on, the console and other plugins will not be able to modify the balance in the server without player
#Please Set bungeecord to true in the spigot.yml
enable: false
#Server ID, keep the ID and the MySQL settings is the same between the servers requiring synchronization
sign: aa
OOTW_Z 发表于 2022-6-28 10:21
在保证Xconomy是最新版的情况下,排除数据库类写错,有如下可能:
首先你要保证数据库端口是开放的,默认33 ...
表是自动创建的,这个也都改了,这个插件放到bc里了,但是bc不加载他的配置文件