通过mycat一次性执行1000条插入语句，执行完成后，发现只插入了518条。发现不对，清除数据重新插入还是只插入了518条数据。
查看mycat的日志：
2023-03-24 11:03:15.942 INFO [Timer0] (io.mycat.net.AbstractConnection.idleCheck(AbstractConnection.java:537)) – ServerConnection [id=46114
1, schema=estore, host=192.168.30.100, user=estore,txIsolation=3, autocommit=true, schema=estore, executeSql=INSERT INTO es_coupon(coupon_co
de_id,customer_id,NAME,amount,STATUS,effect_date,expire_date,create_time,update_time,source,is_gift,ex_gift_exchange_record_id) SELECT 1557,
(SELECT id FROM es_customer WHERE phone=’15774428108′) AS customer_id,c.NAME,c.amount,0,c.effect_date,c.expire_date,NOW(),NOW(),0,0,0 FROM e
s_coupon_code c WHERE c.id = 1557] idle timeout
2023-03-24 11:03:15.942 INFO [Timer0] (io.mycat.net.AbstractConnection.close(AbstractConnection.java:520)) – close connection,reason: idle
,ServerConnection [id=461141, schema=estore, host=192.168.30.100, user=estore,txIsolation=3, autocommit=true, schema=estore, executeSql=INS
ERT INTO es_coupon(coupon_code_id,customer_id,NAME,amount,STATUS,effect_date,expire_date,create_time,update_time,source,is_gift,ex_gift_exch
ange_record_id) SELECT 1557,(SELECT id FROM es_customer WHERE phone=’15774428108′) AS customer_id,c.NAME,c.amount,0,c.effect_date,c.expire_d
ate,NOW(),NOW(),0,0,0 FROM es_coupon_code c WHERE c.id = 1557]
发现出现 idle timeout提示。换了一套测试环境，mycat配置相同，后端MySQL环境也相同，则可以正常执行1000条插入语句。
奇怪中。。。