服务的日志一直在刷_extra的问题,求解?

qq6631515 2020-7-4 246

04/07/2020 11:16:34,174 [nioEventLoopGroup-3-1] INFO  ProtocolProcessor 379  - The connect ACK has been sent. CId=3d1f81680b3e4fc71593832587598  04/07/2020 11:16:34,174 [nioEventLoopGroup-3-1] INFO  ProtocolProcessor 252  - The CONNECT message has been processed. CId=3d1f81680b3e4fc71593832587598, username=62c20c3e4b6545f6a7ee350cd9213a88  04/07/2020 11:16:34,256 [nioEventLoopGroup-3-1] INFO  ProtocolProcessor 469  - Processing PUBLISH message. CId=3d1f81680b3e4fc71593832587598, topic=MP, messageId=6, qos=AT_LEAST_ONCE  04/07/2020 11:16:34,257 [nioEventLoopGroup-3-1] INFO  Qos1PublishHandler 154  - imHandler fromUser=62c20c3e4b6545f6a7ee350cd9213a88, topic=MP  04/07/2020 11:16:34,257 [pool-2-thread-7] INFO  IMHandler 157  - imHandler fromUser=62c20c3e4b6545f6a7ee350cd9213a88, clientId=3d1f81680b3e4fc71593832587598, topic=MP  04/07/2020 11:16:34,257 [pool-2-thread-7] INFO  IMHandler 29  - User 62c20c3e4b6545f6a7ee350cd9213a88 pull message with count(0), payload size(4)  04/07/2020 11:16:34,257 [pool-2-thread-7] INFO  ConnectionDescriptorStore 53  - Sending PUBACK message CId=<3d1f81680b3e4fc71593832587598>, messageId=6, errorCode=ERROR_CODE_SUCCESS  04/07/2020 11:16:36,670 [nioEventLoopGroup-5-2] INFO  Qos1PublishHandler 154  - imHandler fromUser=62c20c3e4b6545f6a7ee350cd9213a88, topic=GETTOKEN  04/07/2020 11:16:36,670 [pool-2-thread-2] INFO  IMHandler 157  - imHandler fromUser=62c20c3e4b6545f6a7ee350cd9213a88, clientId=3d1f81680b3e4fc71593832587598, topic=GETTOKEN  04/07/2020 11:16:36,676 [pool-2-thread-2] INFO  DatabaseStore 1490  - clearMultiEndpoint 62c20c3e4b6545f6a7ee350cd9213a88, 3d1f81680b3e4fc71593832587598  04/07/2020 11:16:36,677 [pool-2-thread-2] INFO  DatabaseStore 1528  - Update rows 0  04/07/2020 11:16:37,291 [nioEventLoopGroup-3-1] INFO  ProtocolProcessor 469  - Processing PUBLISH message. CId=3d1f81680b3e4fc71593832587598, topic=FP, messageId=7, qos=AT_LEAST_ONCE  04/07/2020 11:16:37,292 [nioEventLoopGroup-3-1] INFO  Qos1PublishHandler 154  - imHandler fromUser=62c20c3e4b6545f6a7ee350cd9213a88, topic=FP  04/07/2020 11:16:37,292 [pool-2-thread-8] INFO  IMHandler 157  - imHandler fromUser=62c20c3e4b6545f6a7ee350cd9213a88, clientId=3d1f81680b3e4fc71593832587598, topic=FP  <u>04/07/2020 11:16:37,293 [pool-2-thread-8] ERROR DatabaseStore 37  - Exception: Unknown column '_extra' in 'field list' </u> 04/07/2020 11:16:37,293 [pool-2-thread-8] ERROR DatabaseStore 38  -   com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)  com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)  com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)  com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)  com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)  com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)  io.moquette.persistence.DatabaseStore.getPersistFriends(DatabaseStore.java:2534)  io.moquette.persistence.MemoryMessagesStore.loadFriend(MemoryMessagesStore.java:1999)  io.moquette.persistence.MemoryMessagesStore.getFriendList(MemoryMessagesStore.java:2031)  io.moquette.imhandler.FriendPullHandler.action(FriendPullHandler.java:25)  io.moquette.imhandler.FriendPullHandler.action(FriendPullHandler.java:21)  io.moquette.imhandler.IMHandler.lambda$doHandler$0(IMHandler.java:192)  cn.wildfirechat.server.ThreadPoolExecutorWrapper.lambda$execute$0(ThreadPoolExecutorWrapper.java:37)  java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)  java.util.concurrent.FutureTask.run(FutureTask.java:266)  java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)  java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)  java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)  java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)  java.lang.Thread.run(Thread.java:748)  04/07/2020 11:16:37,293 [pool-2-thread-8] INFO  ConnectionDescriptorStore 53  - Sending PUBACK message CId=<3d1f81680b3e4fc71593832587598>, messageId=7, errorCode=ERROR_CODE_SUCCESS  04/07/2020 11:16:37,377 [nioEventLoopGroup-5-4] INFO  Qos1PublishHandler 154  - imHandler fromUser=62c20c3e4b6545f6a7ee350cd9213a88, topic=FP  04/07/2020 11:16:37,377 [pool-2-thread-3] INFO  IMHandler 157  - imHandler fromUser=62c20c3e4b6545f6a7ee350cd9213a88, clientId=3d1f81680b3e4fc71593832587598, topic=FP  04/07/2020 11:16:37,379 [pool-2-thread-3] ERROR DatabaseStore 37  - Exception: Unknown column '_extra' in 'field list'  04/07/2020 11:16:37,379 [pool-2-thread-3] ERROR DatabaseStore 38  -   com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)  com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)  com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)  com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953)  com.mysql.cj.jdbc.ClientPreparedStatement.executeQuery(ClientPreparedStatement.java:1003)  com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:431)  io.moquette.persistence.DatabaseStore.getPersistFriends(DatabaseStore.java:2534)  io.moquette.persistence.MemoryMessagesStore.loadFriend(MemoryMessagesStore.java:1999)  io.moquette.persistence.MemoryMessagesStore.getFriendList(MemoryMessagesStore.java:2031)  io.moquette.imhandler.FriendPullHandler.action(FriendPullHandler.java:25)  io.moquette.imhandler.FriendPullHandler.action(FriendPullHandler.java:21)  io.moquette.imhandler.IMHandler.lambda$doHandler$0(IMHandler.java:192)  cn.wildfirechat.server.ThreadPoolExecutorWrapper.lambda$execute$0(ThreadPoolExecutorWrapper.java:37)  java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)  java.util.concurrent.FutureTask.run(FutureTask.java:266)  java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)  java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)  java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)  java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)  java.lang.Thread.run(Thread.java:748)  04/07/2020 11:16:37,441 [nioEventLoopGroup-3-1] INFO  ProtocolProcessor 469  - Processing PUBLISH message. CId=3d1f81680b3e4fc71593832587598, topic=UPUI, messageId=9, qos=AT_LEAST_ONCE  04/07/2020 11:16:37,442 [nioEventLoopGroup-3-1] INFO  Qos1PublishHandler 154  - imHandler fromUser=62c20c3e4b6545f6a7ee350cd9213a88, topic=UPUI  04/07/2020 11:16:37,442 [pool-2-thread-5] INFO  IMHandler 157  - imHandler fromUser=62c20c3e4b6545f6a7ee350cd9213a88, clientId=3d1f81680b3e4fc71593832587598, topic=UPUI  04/07/2020 11:16:37,443 [pool-2-thread-5] INFO  ConnectionDescriptorStore 53  - Sending PUBACK message CId=<3d1f81680b3e4fc71593832587598>, messageId=9, errorCode=ERROR_CODE_SUCCESS  04/07/2020 11:16:53,087 [nioEventLoopGroup-5-6] WARN  DefaultChannelPipeline 151  - An exceptionCaught() event was fired, and it reached at the tail of the pipeline. It usually means the last handler in the pipeline did not handle the exception.  java.lang.StringIndexOutOfBoundsException: String index out of range: 0  at java.lang.String.charAt(String.java:658)  at com.xiaoleilu.loServer.action.FileAction.getFileByPath(FileAction.java:113)  at com.xiaoleilu.loServer.action.FileAction.action(FileAction.java:49)  at com.xiaoleilu.loServer.action.Action.doAction(Action.java:65)  at com.xiaoleilu.loServer.handler.ActionHandler.doAction(ActionHandler.java:142)  at com.xiaoleilu.loServer.handler.ActionHandler.channelRead0(ActionHandler.java:52)  at com.xiaoleilu.loServer.handler.ActionHandler.channelRead0(ActionHandler.java:31)  at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105)  at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)  at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)  at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)  at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102)  at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)  at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)  at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)  at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86)  at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)  at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)  at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)  at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:310)  at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:284)  at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)  at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)  at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:340)  at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1334)  at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:362)  at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:348)  at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:926)  at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:134)  at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:644)  at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:579)  at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:496)  at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:458)  at io.netty.util.concurrent.SingleThreadEventExecutor$5.run(SingleThreadEventExecutor.java:858)  at io.netty.util.concurrent.DefaultThreadFactory$DefaultRunnableDecorator.run(DefaultThreadFactory.java:138)  at java.lang.Thread.run(Thread.java:748)

最新回复 (1)
  • HeavyRain 2020-7-5
    引用 2
    是不是升级版本的时候没有拷贝migrate目录,那个目录是数据库管理sql语句,没有拷贝就不会执行最新的数据库表结构的改动
返回