Bug #87634 MysqlaProtocol.clearInputStream throw NullPointerException
Submitted: 1 Sep 2017 3:22 Modified: 1 Oct 2017 11:39
Reporter: Jiahe Cai Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / J Severity:S3 (Non-critical)
Version:6.0.6 OS:CentOS (centos7)
Assigned to: Assigned Account CPU Architecture:Any
Tags: clearInputStream

[1 Sep 2017 3:22] Jiahe Cai
Description:
java.lang.NullPointerException
        at com.mysql.cj.mysqla.io.MysqlaProtocol.clearInputStream(MysqlaProtocol.java:824)
        at com.mysql.cj.mysqla.MysqlaSession.clearInputStream(MysqlaSession.java:502)
        at com.mysql.cj.jdbc.ServerPreparedStatement.serverPrepare(ServerPreparedStatement.java:1451)
        at com.mysql.cj.jdbc.ServerPreparedStatement.<init>(ServerPreparedStatement.java:343)
        at com.mysql.cj.jdbc.ServerPreparedStatement.getInstance(ServerPreparedStatement.java:307)
        at com.mysql.cj.jdbc.ConnectionImpl.prepareStatement(ConnectionImpl.java:3117)
        at com.mysql.cj.jdbc.ServerPreparedStatement.prepareBatchedInsertSQL(ServerPreparedStatement.java:2389)
        at com.mysql.cj.jdbc.PreparedStatement.executeBatchedInserts(PreparedStatement.java:1471)
        at com.mysql.cj.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1209)
        at com.mysql.cj.jdbc.StatementImpl.executeBatch(StatementImpl.java:1009)
        at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:125)

How to repeat:
db version:mysql5.7.19
transaction isolation: repeatable read
autocommit:false

One transaction is waiting for another transaction next key lock.

wait a minute.

executeBatch.

NullPointerException

Suggested fix:
i don't know
[1 Sep 2017 3:26] Jiahe Cai
cachePrepStmts=true
useServerPrepStmts=true
prepStmtCacheSize=250
prepStmtCacheSqlLimit=2048
useLocalSessionState=true
useLocalTransactionState=true
rewriteBatchedStatements=true
cacheResultSetMetadata=true
cacheServerConfiguration=true
elideSetAutoCommits=true
maintainTimeStats=false
[1 Sep 2017 11:39] Chiranjeevi Battula
Hello Jiahe,

Thank you for the bug report.
Could you please provide repeatable test case (exact steps, database/create table statements, full stack trace, sample code etc. - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.
[2 Oct 2017 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".