使用BungeeSuite HOMES设置家时,家会莫名其妙消失 - 联机问答

夏逆520

本帖最后由夏逆520 于 2022-6-13 21:32 编辑

使用BungeeSuite HOMES设置家时,家会莫名其妙消失
有些时候使用BungeeSuite WARPS 设置坐标时也会丢失

BC端为 HexaCord_v237
子服端为 1.7.10 Uranium293
设置的家经常会莫名奇妙消失,消失后重新设置,仍然会消失,是过了段时间才消失的，而不是设置完就不能用
但有些时候又正常保存
Mysql是5.7.26版本
求解决方法

或者有无1.7.10U端可用且支持跨服的类似于BungeeSuiteHOMES与BungeeSuiteWARPS的插件

小计QWQ

最可能的就是数据库错误

夏逆520

本帖最后由 EmptyLava 于 2022-6-21 13:03 编辑

小计QWQ 发表于 2022-6-11 21:20
最可能的就是数据库错误

bc端有这个报错，子服无关于该方面的报错

21:17:42 [严重] com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 562,386 milliseconds ago. The last packet sent successfully to the server was 562,386 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
21:17:42 [严重] at sun.reflect.GeneratedConstructorAccessor44.newInstance(Unknown Source)
21:17:42 [严重] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
21:17:42 [严重] at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
21:17:42 [严重] at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
21:17:42 [严重] at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:990)
21:17:42 [严重] at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3751)
21:17:42 [严重] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2512)
21:17:42 [严重] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
21:17:42 [严重] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2491)
21:17:42 [严重] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2449)
21:17:42 [严重] at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1381)
21:17:42 [严重] at com.minecraftdimensions.bungeesuite.managers.SQLManager.sqlQuery(SQLManager.java:163)
21:17:42 [严重] at com.minecraftdimensions.bungeesuite.managers.SQLManager.existanceQuery(SQLManager.java:99)
21:17:42 [严重] at com.minecraftdimensions.bungeesuite.managers.BansManager.isPlayerBanned(BansManager.java:26)
21:17:42 [严重] at com.minecraftdimensions.bungeesuite.listeners.BansListener.banCheck(BansListener.java:19)
21:17:42 [严重] at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
21:17:42 [严重] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
21:17:42 [严重] at java.lang.reflect.Method.invoke(Method.java:498)
21:17:42 [严重] at net.md_5.bungee.event.EventHandlerMethod.invoke(EventHandlerMethod.java:19)
21:17:42 [严重] at net.md_5.bungee.event.EventBus.post(EventBus.java:46)
21:17:42 [严重] at net.md_5.bungee.api.plugin.PluginManager.callEvent(PluginManager.java:397)
21:17:42 [严重] at net.md_5.bungee.connection.InitialHandler.finish(InitialHandler.java:553)
21:17:42 [严重] at net.md_5.bungee.connection.InitialHandler.access$700(InitialHandler.java:69)
21:17:42 [严重] at net.md_5.bungee.connection.InitialHandler$4.done(InitialHandler.java:391)
21:17:42 [严重] at net.md_5.bungee.connection.InitialHandler$4.done(InitialHandler.java:372)
21:17:42 [严重] at net.md_5.bungee.api.event.AsyncEvent.postCall(AsyncEvent.java:40)
21:17:42 [严重] at net.md_5.bungee.api.plugin.PluginManager.callEvent(PluginManager.java:398)
21:17:42 [严重] at net.md_5.bungee.connection.InitialHandler.handle(InitialHandler.java:398)
21:17:42 [严重] at net.md_5.bungee.protocol.packet.LoginRequest.handle(LoginRequest.java:39)
21:17:42 [严重] at net.md_5.bungee.netty.HandlerBoss.channelRead(HandlerBoss.java:104)
21:17:42 [严重] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
21:17:42 [严重] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
21:17:42 [严重] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:337)
21:17:42 [严重] at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102)
21:17:42 [严重] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
21:17:42 [严重] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
21:17:42 [严重] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:337)
21:17:42 [严重] at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:323)
21:17:42 [严重] at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:297)
21:17:42 [严重] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
21:17:42 [严重] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
21:17:42 [严重] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:337)
21:17:42 [严重] at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:286)
21:17:42 [严重] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
21:17:42 [严重] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
21:17:42 [严重] at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:337)
21:17:42 [严重] at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1408)
21:17:42 [严重] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
21:17:42 [严重] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
21:17:42 [严重] at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:930)
21:17:42 [严重] at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:163)
21:17:42 [严重] at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:677)
21:17:42 [严重] at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:612)
21:17:42 [严重] at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:529)
21:17:42 [严重] at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:491)
21:17:42 [严重] at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:905)
21:17:42 [严重] at java.lang.Thread.run(Thread.java:750)
21:17:42 [严重] Caused by: java.net.SocketException: Software caused connection abort: socket write error
21:17:42 [严重] at java.net.SocketOutputStream.socketWrite0(Native Method)
21:17:42 [严重] at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:111)
21:17:42 [严重] at java.net.SocketOutputStream.write(SocketOutputStream.java:155)
21:17:42 [严重] at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
21:17:42 [严重] at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
21:17:42 [严重] at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3733)
21:17:42 [严重] ... 51 more
21:17:42 [警告] Error dispatching event LoginEvent(cancelled=false, cancelReasonComponents=null, connection=[qwe1808670925] <-> InitialHandler) to listener com.minecraftdimensions.bungeesuite.listeners.BansListener@2160e52a
java.lang.NullPointerException
at com.minecraftdimensions.bungeesuite.managers.SQLManager.existanceQuery(SQLManager.java:99)
at com.minecraftdimensions.bungeesuite.managers.BansManager.isPlayerBanned(BansManager.java:26)
at com.minecraftdimensions.bungeesuite.listeners.BansListener.banCheck(BansListener.java:19)
at sun.reflect.GeneratedMethodAccessor35.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at net.md_5.bungee.event.EventHandlerMethod.invoke(EventHandlerMethod.java:19)
at net.md_5.bungee.event.EventBus.post(EventBus.java:46)
at net.md_5.bungee.api.plugin.PluginManager.callEvent(PluginManager.java:397)
at net.md_5.bungee.connection.InitialHandler.finish(InitialHandler.java:553)
at net.md_5.bungee.connection.InitialHandler.access$700(InitialHandler.java:69)
at net.md_5.bungee.connection.InitialHandler$4.done(InitialHandler.java:391)
at net.md_5.bungee.connection.InitialHandler$4.done(InitialHandler.java:372)
at net.md_5.bungee.api.event.AsyncEvent.postCall(AsyncEvent.java:40)
at net.md_5.bungee.api.plugin.PluginManager.callEvent(PluginManager.java:398)
at net.md_5.bungee.connection.InitialHandler.handle(InitialHandler.java:398)
at net.md_5.bungee.protocol.packet.LoginRequest.handle(LoginRequest.java:39)
at net.md_5.bungee.netty.HandlerBoss.channelRead(HandlerBoss.java:104)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:337)
at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:337)
at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:323)
at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:297)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:337)
at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:286)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:337)
at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1408)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:359)
at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:345)
at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:930)
at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:163)
at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:677)
at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:612)
at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:529)
at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:491)
at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:905)
at java.lang.Thread.run(Thread.java:750)
21:17:42 [严重] Sat Jun 11 21:17:42 CST 2022 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

复制代码

小计QWQ

夏逆520 发表于 2022-6-11 21:21
bc端有这个报错，子服无关于该方面的报错

数据库调用失败

夏逆520

小计QWQ 发表于 2022-6-11 21:26
数据库调用失败

如何解决

小计QWQ

夏逆520 发表于 2022-6-11 21:29
如何解决

autoReconnect=true”来避免此问题

夏逆520

小计QWQ 发表于 2022-6-11 21:32
autoReconnect=true”来避免此问题

在什么地方+

小计QWQ

夏逆520 发表于 2022-6-11 21:33
在什么地方+

你先测试一下数据库链接

夏逆520

小计QWQ 发表于 2022-6-11 21:33
你先测试一下数据库链接

数据库连接肯定没有问题，其他很多插件都连着数据库
就BungeeSuite系的会丢失坐标

小计QWQ

BungeeSuite.jar (156.57 KB, 下载次数: 0)

小计QWQ

夏逆520 发表于 2022-6-11 21:35
数据库连接肯定没有问题，其他很多插件都连着数据库
就BungeeSuite系的会丢失坐标 ...

那就是本身插件的问题了

BungeeSuite.jar (156.57 KB, 下载次数: 3)

夏逆520

小计QWQ 发表于 2022-6-11 21:37
那就是本身插件的问题了

等服务器人少的时候我重启换一下试试

小计QWQ

夏逆520 发表于 2022-6-11 21:49
等服务器人少的时候我重启换一下试试

好的没问题

夏逆520

本帖最后由夏逆520 于 2022-6-12 13:28 编辑

小计QWQ 发表于 2022-6-11 21:53
好的没问题

用是能用，但需要删除原来的数据库，且还不知道会不会出现坐标消失的情况
原来数据库是frm和ibd作为后缀,这个是MYD和MYI作为后缀，有什么方法可以重新导入吗

小计QWQ

夏逆520 发表于 2022-6-12 11:30
用是能用，但需要删除原来的数据库，且还不知道会不会出现坐标消失的情况
原来数据库是frm和ibd作为后缀, ...

先导出再导入

夏逆520

本帖最后由夏逆520 于 2022-6-13 20:35 编辑

小计QWQ 发表于 2022-6-12 14:52
先导出再导入

经过测试这一款还是会出现丢失坐标的问题
有没有其他能够替代的插件，要1.7.10U端能用的
且要支持跨服