签到成功

知道了

CNDBA社区CNDBA社区

mycat 分库分表启动报错解决

2019-02-21 14:26 5789 0 原创 Mysql
作者: Marvinn

mycat 启动报错解决

http://www.cndba.cn/Marvinn/article/3277

l.txt, mutiNodeLimitType=1, mutiNodePatchSize=100, defaultSqlParser=druidparser, usingAIO=0, packetHeaderSize=4, maxPacketSize=16777216, mycatNodeId=1]
2019-02-21 13:42:09.954  INFO [WrapperSimpleAppMain] (io.mycat.memory.MyCatMemory.<init>(MyCatMemory.java:53)) - useOffHeapForMerge = 1
2019-02-21 13:42:09.954  INFO [WrapperSimpleAppMain] (io.mycat.memory.MyCatMemory.<init>(MyCatMemory.java:54)) - memoryPageSize = 1m
2019-02-21 13:42:09.954  INFO [WrapperSimpleAppMain] (io.mycat.memory.MyCatMemory.<init>(MyCatMemory.java:55)) - spillsFileBufferSize = 2K
2019-02-21 13:42:09.954  INFO [WrapperSimpleAppMain] (io.mycat.memory.MyCatMemory.<init>(MyCatMemory.java:56)) - useStreamOutput = 0
2019-02-21 13:42:09.954  INFO [WrapperSimpleAppMain] (io.mycat.memory.MyCatMemory.<init>(MyCatMemory.java:57)) - systemReserveMemorySize = 384m
2019-02-21 13:42:09.961  INFO [WrapperSimpleAppMain] (io.mycat.memory.MyCatMemory.<init>(MyCatMemory.java:58)) - totalNetWorkBufferSize = 1600MB
2019-02-21 13:42:09.961  INFO [WrapperSimpleAppMain] (io.mycat.memory.MyCatMemory.<init>(MyCatMemory.java:59)) - dataNodeSortedTempDir = /opt/mycat
2019-02-21 13:42:09.963  INFO [WrapperSimpleAppMain] (io.mycat.memory.MyCatMemory.<init>(MyCatMemory.java:122)) - mycat.memory.offHeap.size: -845571686B
2019-02-21 13:42:09.965 ERROR [WrapperSimpleAppMain] (io.mycat.MycatStartup.main(MycatStartup.java:62)) - 2019-02-21 13:42:09 startup error
java.lang.NumberFormatException: Size must be specified as bytes (b), kibibytes (k), mebibytes (m), gibibytes (g), tebibytes (t), or pebibytes(p). E.g. 50b, 100k, or 250m.
Failed to parse byte string: -845571686B
        at io.mycat.memory.unsafe.utils.JavaUtils.byteStringAs(JavaUtils.java:223) ~[Mycat-server-1.6.5-release.jar:?]
        at io.mycat.memory.unsafe.utils.JavaUtils.byteStringAsBytes(JavaUtils.java:234) ~[Mycat-server-1.6.5-release.jar:?]
        at io.mycat.memory.unsafe.utils.MycatPropertyConf.byteStringAsBytes(MycatPropertyConf.java:92) ~[Mycat-server-1.6.5-release.jar:?]
        at io.mycat.memory.unsafe.utils.MycatPropertyConf.getSizeAsBytes(MycatPropertyConf.java:50) ~[Mycat-server-1.6.5-release.jar:?]
        at io.mycat.memory.unsafe.memory.mm.MemoryManager.<init>(MemoryManager.java:30) ~[Mycat-server-1.6.5-release.jar:?]
        at io.mycat.memory.unsafe.memory.mm.ResultMergeMemoryManager.<init>(ResultMergeMemoryManager.java:15) ~[Mycat-server-1.6.5-release.jar:?]
        at io.mycat.memory.MyCatMemory.<init>(MyCatMemory.java:125) ~[Mycat-server-1.6.5-release.jar:?]
        at io.mycat.MycatServer.startup(MycatServer.java:390) ~[Mycat-server-1.6.5-release.jar:?]
        at io.mycat.MycatStartup.main(MycatStartup.java:57) ~[Mycat-server-1.6.5-release.jar:?]
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.8.0_201]
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:1.8.0_201]
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.8.0_201]
        at java.lang.reflect.Method.invoke(Method.java:498) ~[?:1.8.0_201]
        at org.tanukisoftware.wrapper.WrapperSimpleApp.run(WrapperSimpleApp.java:240) ~[wrapper.jar:3.2.3]
        at java.lang.Thread.run(Thread.java:748) [?:1.8.0_201]

报错解决:http://www.cndba.cn/Marvinn/article/3277http://www.cndba.cn/Marvinn/article/3277http://www.cndba.cn/Marvinn/article/3277

修改server.xml文件中system标签值,

http://www.cndba.cn/Marvinn/article/3277
http://www.cndba.cn/Marvinn/article/3277

off heap for merge/order/group/limit 1开启 0关闭 —->修改配置文件值为: 0

http://www.cndba.cn/Marvinn/article/3277

添加如下: 0 http://www.cndba.cn/Marvinn/article/3277

http://www.cndba.cn/Marvinn/article/3277
http://www.cndba.cn/Marvinn/article/3277

       <system>
           ....中间配置省略....
         <property name="useOffHeapForMerge">0</property>
        </system>

版权声明:本文为博主原创文章,未经博主允许不得转载。

用户评论
* 以下用户言论只代表其个人观点,不代表CNDBA社区的观点或立场
Marvinn

Marvinn

关注

路漫漫其修远兮、吾将上下而求索

  • 99
    原创
  • 0
    翻译
  • 2
    转载
  • 36
    评论
  • 访问:458394次
  • 积分:449
  • 等级:中级会员
  • 排名:第12名
精华文章
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

        QQ交流群

        注册联系QQ