mycat php pdo,通过pdo 执行sql 字段类型为 smallint 报 ArrayIndexOutOfBoundsException 异常

mycat 1.6.5

php 5.4.3 预处理关闭 false

sql 随便一个就行比如 select * from table

表字段类型要有一个是 smallint not null

通过pdo 执行,就会抛如下的错误 。

我从早上一直找到现在。 。。。。

2016-12-22 15:50:43.586 WARN [$_NIOREACTOR-5-RW] (io.mycat.net.NIOReactor$RW.run(NIOReactor.java:107)) - caught err:

java.lang.ArrayIndexOutOfBoundsException: 1

at io.mycat.util.ByteUtil.getShort(ByteUtil.java:158) ~[Mycat-server-1.6.5-DEV.jar:?]

at io.mycat.net.mysql.BinaryRowDataPacket.convert(BinaryRowDataPacket.java:161) ~[Mycat-server-1.6.5-DEV.jar:?]

at io.mycat.net.mysql.BinaryRowDataPacket.read(BinaryRowDataPacket.java:95) ~[Mycat-server-1.6.5-DEV.jar:?]

at io.mycat.backend.mysql.nio.handler.SingleNodeHandler.rowResponse(SingleNodeHandler.java:452) ~[Mycat-server-1.6.5-DEV.jar:?]

at io.mycat.backend.mysql.nio.MySQLConnectionHandler.handleRowPacket(MySQLConnectionHandler.java:204) ~[Mycat-server-1.6.5-DEV.jar:?]

at io.mycat.backend.mysql.nio.MySQLConnectionHandler.handleData(MySQLConnectionHandler.java:135) ~[Mycat-server-1.6.5-DEV.jar:?]

at io.mycat.net.handler.BackendAsyncHandler.offerData(BackendAsyncHandler.java:36) ~[Mycat-server-1.6.5-DEV.jar:?]

at io.mycat.backend.mysql.nio.MySQLConnectionHandler.handle(MySQLConnectionHandler.java:80) ~[Mycat-server-1.6.5-DEV.jar:?]

at io.mycat.net.AbstractConnection.handle(AbstractConnection.java:263) ~[Mycat-server-1.6.5-DEV.jar:?]

at io.mycat.net.AbstractConnection.onReadData(AbstractConnection.java:321) ~[Mycat-server-1.6.5-DEV.jar:?]

at io.mycat.net.NIOSocketWR.asynRead(NIOSocketWR.java:190) ~[Mycat-server-1.6.5-DEV.jar:?]

at io.mycat.net.AbstractConnection.asynRead(AbstractConnection.java:273) ~[Mycat-server-1.6.5-DEV.jar:?]

at io.mycat.net.NIOReactor$RW.run(NIOReactor.java:102) ~[Mycat-server-1.6.5-DEV.jar:?]

at java.lang.Thread.run(Thread.java:745) [?:1.8.0_60]

2016-12-22 15:50:43.586 INFO [$_NIOREACTOR-5-RW] (io.mycat.net.AbstractConnection.close(AbstractConnection.java:508)) - close connection,reason:program err:java.lang.ArrayIndexOutOfBoundsException: 1 ,MySQLConnection [id=45, lastTime=1482393043580, user=ruby_user, schema=c2c_goods, old shema=c2c_goods, borrowed=true, fromSlaveDB=false, threadId=1200546, charset=utf8, txIsolation=3, autocommit=true, attachment=dn45{SELECT goods_id,sub_category_id,style_id,times_num,season_num,file_format,fize_resolution,dpi,pic_size,pci_sex,role_age,info.goods_info,info.preview,glist.goods_name,glist.stock_num,glist.create_time,glist.goods_name,glist.goods_info as ggoods_info,glist.file_size as file_size,glist.price as price,glist.seller_id as seller_id,info.preview as gpreview FROM c2c_goods_drawing info straight_join

c2c_goods_list glist

ON glist.id = info.goods_id

WHERE goods_id = 40}, respHandler=SingleNodeHandler [node=dn45{SELECT goods_id,sub_category_id,style_id,times_num,season_num,file_format,fize_resolution,dpi,pic_size,pci_sex,role_age,info.goods_info,info.preview,glist.goods_name,glist.stock_num,glist.create_time,glist.goods_name,glist.goods_info as ggoods_info,glist.file_size as file_size,glist.price as price,glist.seller_id as seller_id,info.preview as gpreview FROM c2c_goods_drawing info straight_join

c2c_goods_list glist

ON glist.id = info.goods_id

WHERE goods_id = 40}, packetId=25], host=10.171.219.217, port=3309, statusSync=null, writeQueue=0, modifiedSQLExecuted=false]

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值