Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[$_NIOREACTOR-7-RW] (io.mycat.net.NIOReactor$RW.run(NIOReactor.java:118)) - caught err:java.lang.NullPointerException #2922

Open
goudai opened this issue Aug 3, 2022 · 2 comments
Assignees
Labels

Comments

@goudai
Copy link

goudai commented Aug 3, 2022

1、bug描述
简单清晰描述下bug现象.

2022-08-02 13:47:33.589  WARN [$_NIOREACTOR-7-RW] (io.mycat.net.NIOReactor$RW.run(NIOReactor.java:118)) - caught err:java.lang.NullPointerException
2022-08-02 13:47:33.589  INFO [$_NIOREACTOR-7-RW] (io.mycat.net.AbstractConnection.close(AbstractConnection.java:508)) - close connection,reason:program err:java.lang.NullPointerException ,ServerConnection [id=447990, schema=order_db, host=0.0.0.0, user=xxx,txIsolation=3, autocommit=false, schema=xxx]
2022-08-02 13:47:33.590  INFO [$_NIOREACTOR-7-RW] (io.mycat.net.AbstractConnection.close(AbstractConnection.java:508)) - close connection,reason:client closed  ,MySQLConnection [id=50071, lastTime=1659419253027, user=xxx, schema=xxx2_8, old shema=xxx2_8, borrowed=true, fromSlaveDB=false, threadId=1042010, charset=utf8, txIsolation=3, autocommit=false, attachment=dn_xxx2_8{insert into t_xxx

2、版本号(非常重要)

BuildTime  2016-10-28 12:47:06
GitVersion   460930bb32b0007597796369bc92daa8428d8787
MavenVersion 1.6-RELEASE

3、相关表的配置信息
schema.xml (需包含表的配置信息,mysql的连接驱动是JDBC还是native方式)

        <dataHost name="hostxx" maxCon="1000" minCon="10" balance="0" writeType="0" switchType="1"  slaveThreshold="100" dbType="mysql" dbDriver="native">
                <heartbeat>select user()</heartbeat>
                <writeHost host="hostM1" url="xxx:3306" user="xxx" password="xxx">
                        <readHost host="hostS1" url="xxx:3306" user="xxx" password="xxx" />
                </writeHost>
        </dataHost>

rule.xml (涉及到的路由函数)
server.xml(可选)

    <system>
        <property name="useSqlStat">1</property>
        <property name="useGlobleTableCheck">0</property>
        <property name="sequnceHandlerType">2</property>
        <property name="processors">32</property>
        <property name="processorBufferPoolType">0</property>
        <property name="handleDistributedTransactions">0</property>
        <property name="useOffHeapForMerge">1</property>
        <property name="memoryPageSize">1m</property>
        <property name="spillsFileBufferSize">1k</property>
        <property name="useStreamOutput">0</property>
        <property name="systemReserveMemorySize">389m</property>
        <property name="useZKSwitch">true</property>
        <property name="charset">utf8mb4</property>
    </system>
@goudai
Copy link
Author

goudai commented Aug 3, 2022

在使用insert into * values(1),(2),(n)情况下触发

@zwyqz
Copy link
Collaborator

zwyqz commented Aug 9, 2022

需要打印出debug日志;

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants