mysql 分组查询cat_MyCat1.6多表join后进行分组查询,MyCat直接崩溃

MyCat1.6多表join后进行分组查询,MyCat直接崩溃,以下是使用的方式,敬请大神解答。

mysql> select * from employee as e

-> ;

+----+-----------+-------------+

| id | name | sharding_id |

+----+-----------+-------------+

| 1 | leader us | 10000 |

| 3 | mycat | 10000 |

| 2 | me | 10010 |

| 4 | mydog | 10010 |

+----+-----------+-------------+

4 rows in set (0.15 sec)

mysql> select * from company;

+----+-----------+-------------+

| id | name | sharding_id |

+----+-----------+-------------+

| 1 | leader us | 10000 |

+----+-----------+-------------+

1 row in set (0.01 sec)

mysql> select * from employee as e inner join company as c on e.sharding_id=c.sharding_id;

+----+-----------+-------------+----+-----------+-------------+

| id | name | sharding_id | id | name | sharding_id |

+----+-----------+-------------+----+-----------+-------------+

| 1 | leader us | 10000 | 1 | leader us | 10000 |

| 3 | mycat | 10000 | 1 | leader us | 10000 |

+----+-----------+-------------+----+-----------+-------------+

2 rows in set (0.03 sec)

mysql> select * from employee as e inner join company as c on e.sharding_id=c.sharding_id group by e.sharding_id;

ERROR 2013 (HY000): Lost connection to MySQL server during query

mysql>

以下是生成的错误信息:

Java frames: (J=compiled Java code, j=interpreted, Vv=VM code)

J 1342 sun.misc.Unsafe.copyMemory(Ljava/lang/Object;JLjava/lang/Object;JJ)V (0 bytes) @ 0x0000000003742a32 [0x00000000037429c0+0x72]

j io.mycat.memory.unsafe.Platform.copyMemory(Ljava/lang/Object;JLjava/lang/Object;JJ)V+34

j io.mycat.memory.unsafe.row.UnsafeRow.getBinary(I)[B+54

j io.mycat.memory.unsafe.row.UnsafeRow.calcPacketSize()I+14

j io.mycat.memory.unsafe.row.UnsafeRow.write(Ljava/nio/ByteBuffer;Lio/mycat/net/FrontendConnection;Z)Ljava/nio/ByteBuffer;+13

j io.mycat.backend.mysql.nio.handler.MultiNodeQueryHandler.outputMergeResult(Lio/mycat/server/ServerConnection;[BLjava/util/Iterator;)V+216

j io.mycat.sqlengine.mpp.DataNodeMergeManager.run()V+229

j java.util.concurrent.ThreadPoolExecutor.runWorker(Ljava/util/concurrent/ThreadPoolExecutor$Worker;)V+95

j java.util.concurrent.ThreadPoolExecutor$Worker.run()V+5

j java.lang.Thread.run()V+11

v ~StubRoutines::call_stub

485611bae4a13a1eb0cac02d6257f24f.png

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

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值