matrixone icon indicating copy to clipboard operation
matrixone copied to clipboard
verified publisher icon matrixorigin

[Bug]: Batch insert fails

Open DanielZhangQD opened this issue 1 year ago • 5 comments

Is there an existing issue for the same bug?

  • [X] I have checked the existing issues.

Branch Name

1.2-dev

Commit ID

v1.2.0-76ce4ef7e-2024-05-14

Other Environment Information

- Hardware parameters:
- OS type:
- Others:

Actual Behavior

Table schema:

CREATE TABLE `storage` (
`collecttime` DATETIME NOT NULL,
`value` DOUBLE NOT NULL,
`account` VARCHAR(128) NOT NULL,
`interval` INT NOT NULL,
PRIMARY KEY (`collecttime`,`account`)
)

Insert fails:

2024/05/15 16:27:09.373681 +0000 ERROR [email protected]/finisher_api.go:647 trace {"error": "Error 20101 (HY000): internal error: panic runtime error: slice bounds out of range [:174276] with capacity 0: \nruntime.goPanicSliceAcap\n\t/usr/local/go/src/runtime/panic.go:140\ngithub.com/matrixorigin/matrixone/pkg/container/types.(*Varlena).GetByteSlice\n\t/go/src/github.com/matrixorigin/matrixone/pkg/container/types/bytes.go:106\ngithub.com/matrixorigin/matrixone/pkg/vm/engine/tae/index.ZM.AnyIn.func23\n\t/go/src/github.com/matrixorigin/matrixone/pkg/vm/engine/tae/index/zm.go:1168\nsort.Search\n\t/usr/local/go/src/sort/search.go:65\ngithub.com/matrixorigin/matrixone/pkg/vm/engine/tae/index.ZM.AnyIn\n\t/go/src/github.com/matrixorigin/matrixone/pkg/vm/engine/tae/index/zm.go:1167\ngithub.com/matrixorigin/matrixone/pkg/vm/engine/disttae.(*txnTable).tryFastRanges.func2\n\t/go/src/github.com/matrixorigin/matrixone/pkg/vm/engine/disttae/txn_table.go:1062\ngithub.com/matrixorigin/matrixone/pkg/vm/engine/disttae.ForeachSnapshotObjects\n\t/go/src/github.com/matrixorigin/matrixone/pkg/vm/engine/disttae/util.go:1833\ngithub.com/matrixorigin/matrixone/pkg/vm/engine/disttae.(*txnTable).tryFastRanges\n\t/go/src/github.com/matrixorigin/matrixone/pkg/vm/engine/disttae/txn_table.go:1053\ngithub.com/matrixorigin/matrixone/pkg/vm/engine/disttae.(*txnTable).rangesOnePart\n\t/go/src/github.com/matrixorigin/matrixone/pkg/vm/engine/disttae/txn_table.go:728\ngithub.com/matrixorigin/matrixone/pkg/vm/engine/disttae.(*txnTable).Ranges\n\t/go/src/github.com/matrixorigin/matrixone/pkg/vm/engine/disttae/txn_table.go:675\ngithub.com/matrixorigin/matrixone/pkg/sql/compile.(*Compile).expandRanges\n\t/go/src/github.com/matrixorigin/matrixone/pkg/sql/compile/compile.go:3737\ngithub.com/matrixorigin/matrixone/pkg/sql/compile.(*Compile).generateNodes\n\t/go/src/github.com/matrixorigin/matrixone/pkg/sql/compile/compile.go:3867\ngithub.com/matrixorigin/matrixone/pkg/sql/compile.(*Compile).compileTableScan\n\t/go/src/github.com/matrixorigin/matrixone/pkg/sql/compile/compile.go:2139\ngithub.com/matrixorigin/matrixone/pkg/sql/compile.(*Compile).compilePlanScope\n\t/go/src/github.com/matrixorigin/matrixone/pkg/sql/compile/compile.go:1160\ngithub.com/matrixorigin/matrixone/pkg/sql/compile.(*Compile).compilePlanScope\n\t/go/src/github.com/matrixorigin/matrixone/pkg/sql/compile/compile.go:1414\ngithub.com/matrixorigin/matrixone/pkg/sql/compile.(*Compile).compileQuery\n\t/go/src/github.com/matrixorigin/matrixone/pkg/sql/compile/compile.go:1006\ngithub.com/matrixorigin/matrixone/pkg/sql/compile.(*Compile).compileScope\n\t/go/src/github.com/matrixorigin/matrixone/pkg/sql/compile/compile.go:685\ngithub.com/matrixorigin/matrixone/pkg/sql/compile.(*Compile).Compile\n\t/go/src/github.com/matrixorigin/matrixone/pkg/sql/compile/compile.go:292\ngithub.com/matrixorigin/matrixone/pkg/frontend.(*TxnComputationWrapper).Compile\n\t/go/src/github.com/matrixorigin/matrixone/pkg/frontend/computation_wrapper.go:352\ngithub.com/matrixorigin/matrixone/pkg/frontend.executeStmt\n\t/go/src/github.com/matrixorigin/matrixone/pkg/frontend/mysql_cmd_executor.go:2627\ngithub.com/matrixorigin/matrixone/pkg/frontend.dispatchStmt\n\t/go/src/github.com/matrixorigin/matrixone/pkg/frontend/mysql_cmd_executor.go:2527\ngithub.com/matrixorigin/matrixone/pkg/frontend.executeStmtWithIncrStmt\n\t/go/src/github.com/matrixorigin/matrixone/pkg/frontend/mysql_cmd_executor.go:2498\ngithub.com/matrixorigin/matrixone/pkg/frontend.executeStmtWithWorkspace\n\t/go/src/github.com/matrixorigin/matrixone/pkg/frontend/mysql_cmd_executor.go:2468\ngithub.com/matrixorigin/matrixone/pkg/frontend.executeStmtWithTxn\n\t/go/src/github.com/matrixorigin/matrixone/pkg/frontend/mysql_cmd_executor.go:2382\ngithub.com/matrixorigin/matrixone/pkg/frontend.executeStmtWithResponse\n\t/go/src/github.com/matrixorigin/matrixone/pkg/frontend/mysql_cmd_executor.go:2351\ngithub.com/matrixorigin/matrixone/pkg/frontend.doComQuery\n\t/go/src/github.com/matrixorigin/matrixone/pkg/frontend/mysql_cmd_executor.go:2899\ngithub.com/matrixorigin/matrixone/pkg/frontend.ExecRequest\n\t/go/src/github.com/matrixorigin/matrixone/pkg/frontend/mysql_cmd_executor.go:3028\ngithub.com/matrixorigin/matrixone/pkg/frontend.(*Routine).handleRequest\n\t/go/src/github.com/matrixorigin/matrixone/pkg/frontend/routine.go:284\ngithub.com/matrixorigin/matrixone/pkg/frontend.(*RoutineManager).Handler\n\t/go/src/github.com/matrixorigin/matrixone/pkg/frontend/routine_manager.go:516\ngithub.com/matrixorigin/matrixone/pkg/frontend.(*MOServer).handleMessage\n\t/go/src/github.com/matrixorigin/matrixone/pkg/frontend/server.go:187\ngithub.com/fagongzi/goetty/v2.(*server).doStart.func2.1\n\t/go/pkg/mod/github.com/matrixorigin/goetty/[email protected]/application.go:356\nruntime.goexit\n\t/usr/local/go/src/runtime/asm_amd64.s:1650", "elapsed": "9.133124ms", "rows": 0, "sql": "INSERT INTO `mo_cloud`.`storage` (`collecttime`,`value`,`account`,`interval`) VALUES ('2024-05-14 09:34:00',1359.036876,'1af94fff_9a6c_4008_a946_4d15036618e1',1),('2024-05-14 09:34:00',0.011262,'4fb01180_5286_48fe_bde7_a77cf16a6e4e',1),('2024-05-14 09:34:00',1492.753363,'be8f7e22_6bc1_41c3_b510_0ef1ed98dab1',1),('2024-05-14 09:34:00',0.011261,'ef945ec6_21d5_4758_bd72_7effe814500b',1),('2024-05-14 09:34:00',0.011315,'018ee4e0_35b8_781a_b208_4735dce1378b',1),('2024-05-14 09:34:00',0.011274,'018f7506_e13b_7333_abdd_107ba823a778',1),('2024-05-14 09:34:00',0.011274,'018f7528_f9a0_75c5_b88f_1fbda12e34ea',1),('2024-05-14 09:34:00',0.011312,'1625f417_5edd_4fdb_ac0d_e4dc23814643',1),('2024-05-14 09:34:00',0.01192,'1c6025cb_8ee0_411a_96e6_0f412438bf7c',1),('2024-05-14 09:34:00',1519.472215,'2fcebfc1_c9ca_40c5_a1e3_6b5df9a2de9c',1),('2024-05-14 09:34:00',0.011262,'38fcb782_d2ca_4065_94f7_e432e7a1b089',1),('2024-05-14 09:34:00',0.011262,'42da5d6b_d751_4c7a_86fd_6514850b0a66',1),('2024-05-14 09:34:00',0.015039,'569e680b_94e1_4a53_b78f_fcdfaf392e5e',1),('2024-05-14 09:34:00',5018.133015,'585b49fc_852b_4bd1_b6d1_d64bc1d8d485',1),('2024-05-14 09:34:00',0.059463,'6f7b9ea3_b00d_4e17_aa04_fbd909cd2b4c',1),('2024-05-14 09:34:00',0.011269,'73b5b1f9_8ae6_474f_a7a6_e447c16e019b',1),('2024-05-14 09:34:00',0.173038,'7d5658ed_eba3_4323_897c_893368a6e0cc',1),('2024-05-14 09:34:00',0.011274,'d90ca951_cbb2_4543_9916_56a05e8a181c',1),('2024-05-14 09:34:00',0.453361,'2cd2c634_ba11_4353_b8a5_9f52c72c99a8',1),('2024-05-14 09:34:00',0.011262,'4a42e33f_2f81_4a4b_95d4_656e5106ee4c',1),('2024-05-14 09:34:00',0.011262,'a31a22a9_cfa2_47ff_8eee_c1c5af01ea52',1),('2024-05-14 09:34:00',0.011274,'018ef126_3f70_798e_a226_afc28a3c717d',1),('2024-05-14 09:34:00',0.011355,'018f74f2_899a_7d5d_b3b4_46bb0e7fad1f',1),('2024-05-14 09:34:00',22170.67641,'098a1746_fc4b_4cb2_a56f_71321551ec41',1),('2024-05-14 09:34:00',0.011281,'0f911f6d_3fc1_4489_b67d_1711f2ffd265',1),('2024-05-14 09:34:00',536.522927,'67d014ca_ebe2_4c21_b853_00e9ecae5c46',1),('2024-05-14 09:34:00',0.011262,'7a593cd2_58c9_409e_b6c4_7c1b3261e70a',1),('2024-05-14 09:34:00',0.011274,'ea625c88_d3e6_4257_809b_a57e0707d6d8',1),('2024-05-14 09:34:00',0.022199,'018ebb8b_f660_7528_bd01_c58675edad89',1),('2024-05-14 09:34:00',41418.752821,'018f6fd0_bcfd_7b65_869f_8d33e3bcb0d8',1),('2024-05-14 09:34:00',0.011269,'31fe3fbc_9994_46b6_ad01_66e8c20bbcf8',1),('2024-05-14 09:34:00',0.011258,'373e40d0_7435_48ca_920e_d9a66b974e2c',1),('2024-05-14 09:34:00',46952.470351,'4d8e99a9_2ae3_4461_a6dd_ecdc1273a575',1),('2024-05-14 09:34:00',103483.681499,'79307612_ae09_4fc0_81c3_e3f8b13a9927',1),('2024-05-14 09:34:00',18293.461542,'877d99a7_33f7_4d6c_b5b2_7fda26380eb6',1),('2024-05-14 09:34:00',0.011262,'9ff55d43_05e3_4b5f_8e54_b305f020da14',1),('2024-05-14 09:34:00',824.060298,'c073b9f3_590c_4b84_9f5b_245973d3b09d',1),('2024-05-14 09:34:00',3.832031,'cb492f5a_7b19_4c18_a0ce_f9f507e186c0',1),('2024-05-14 09:34:00',4449.246924,'d2553c63_c8c7_4887_8248_48ca4eb7ebaa',1),('2024-05-14 09:34:00',0.011274,'018f7523_c376_7ffc_a892_2d12433e2b7c',1),('2024-05-14 09:34:00',0.011262,'37e423d7_32b0_417d_858c_6f84cdef01cf',1),('2024-05-14 09:34:00',0.011262,'427e3ee2_6282_4a82_a8b3_7d0def7f9797',1),('2024-05-14 09:34:00',0.011262,'5730369b_49ba_4a69_8864_bf9496cd9fc5',1),('2024-05-14 09:34:00',0.011262,'88f78a84_8b06_4307_ba01_1131b496a7f8',1),('2024-05-14 09:34:00',3880.648889,'f300703c_76ab_4e24_9c5e_4167d12b57a7',1),('2024-05-14 09:34:00',0.011262,'f3771e21_5d1f_4080_80e4_c3b975a45508',1),('2024-05-14 09:34:00',10.713967,'12cea735_8bc9_42c3_a842_12b311b8bc9b',1),('2024-05-14 09:34:00',0.013938,'72b5d43e_b533_4960_a44e_35bf027c4357',1),('2024-05-14 09:34:00',0.011275,'786f4703_a5ac_4b40_90f4_8ec113122b08',1),('2024-05-14 09:34:00',935.419684,'7e084425_1c80_4877_9465_114f0005bbeb',1),('2024-05-14 09:34:00',0.011274,'4fdd3e5d_9df5_46b6_8d58_fa53614aabf8',1),('2024-05-14 09:34:00',0.011262,'7863cc80_f50b_4bb1_84b3_2f87a359dc0b',1),('2024-05-14 09:34:00',0.011262,'8a5b8c23_c005_417c_a85a_90a7fc247389',1),('2024-05-14 09:34:00',0.011262,'dd1299f8_b731_492b_b6da_47cf6d276910',1),('2024-05-14 09:34:00',0.011262,'e44d4e36_0131_42b8_8c94_87a36b6506fc',1),('2024-05-14 09:34:00',0.011262,'1ee6f5e0_79d1_4391_9b06_2637a25c6830',1),('2024-05-14 09:34:00',0.016056,'37927cc2_7272_4270_9828_aaf00f28fe59',1),('2024-05-14 09:34:00',0.011262,'710ff294_a7b8_4095_8380_f7617357528e',1),('2024-05-14 09:34:00',0.011262,'81ffda90_4221_4a41_89d5_ef77d160e04f',1),('2024-05-14 09:34:00',0.011266,'93805064_7a89_4275_86dc_1d059555ffe8',1),('2024-05-14 09:34:00',1463.847266,'b748a49f_5a02_4912_b46e_2c1338cd52a8',1),('2024-05-14 09:34:00',0.030155,'c234ab5d_779d_4e0b_a884_b929decee97c',1),('2024-05-14 09:34:00',0.011262,'c8f0d71b_7ce6_4a14_9413_571f4a4a9e84',1),('2024-05-14 09:34:00',0.011274,'018f7506_60d9_74e8_933f_6db0ff2b668e',1),('2024-05-14 09:34:00',8.209218,'449ab6d3_b8bb_4bc7_b402_7c894d141176',1),('2024-05-14 09:34:00',0.011262,'461c806b_5fe8_4038_b823_b000d77ccf8a',1),('2024-05-14 09:34:00',5558.947912,'6d966d73_a195_437e_88f8_7f75b3cc6496',1),('2024-05-14 09:34:00',0.011262,'6d9ab279_372d_4382_83ec_736db7f1eb86',1),('2024-05-14 09:34:00',0.011262,'d0d376a2_7598_49ff_92e3_098ee8ef1a45',1),('2024-05-14 09:34:00',0.013418,'1e6ba5d8_ca04_407b_a044_a2798d27bba5',1),('2024-05-14 09:34:00',0.011285,'5142ee19_0df7_462d_8ecd_1983c2ed4812',1),('2024-05-14 09:34:00',0.011262,'5b6eb760_1597_4f36_9028_7283aeaced05',1),('2024-05-14 09:34:00',0.011262,'5cbbd77d_7f36_4c6f_98ba_2dbba03bd412',1),('2024-05-14 09:34:00',0.011262,'c645c2e9_4605_4808_ab63_1fdc1803873f',1),('2024-05-14 09:34:00',0.011261,'c89c09b9_1a55_488e_8636_6380c6b3d658',1),('2024-05-14 09:34:00',0.011274,'0da7e4c8_10e8_4728_b271_b68a26a5bf7a',1),('2024-05-14 09:34:00',0.011262,'2b9dd283_e87b_49ed_b4f7_01df57570c63',1),('2024-05-14 09:34:00',26742.08487,'bbbafa55_339e_4498_b2e4_ea2d4757f9e0',1),('2024-05-14 09:34:00',0.011262,'e0160763_da5a_497d_a867_24241bc6697c',1),('2024-05-14 09:34:00',0.011274,'018f708b_9c0c_7bba_9b1d_b42638144dc4',1),('2024-05-14 09:34:00',0.011319,'018f764b_a3f0_74f4_944d_f0c65ece0efb',1),('2024-05-14 09:34:00',0.011295,'37fe614f_8090_4d3b_b8c3_d34fa3b6d079',1),('2024-05-14 09:34:00',0.011262,'4032cb4f_fb91_4985_a207_f7861dd6fdf2',1),('2024-05-14 09:34:00',0.011262,'4f38ea5b_f826_43ee_99a4_ba812c171d71',1),('2024-05-14 09:34:00',0.015107,'6738b286_4ee2_40ce_844b_d8e8eee49d93',1),('2024-05-14 09:34:00',0.011259,'73f648c4_704a_4e9c_ab2f_2ee229a11707',1),('2024-05-14 09:34:00',0.011262,'7e23b5fd_e903_45d5_b9eb_497f0d67763c',1),('2024-05-14 09:34:00',0.231333,'80aaa3f3_480f_4714_a0fd_5db009c5021e',1),('2024-05-14 09:34:00',0.011262,'a9b7ac88_ecb9_4554_9bc4_3a2c26f25cb5',1),('2024-05-14 09:34:00',0.011262,'07f7e7c6_f04c_4668_bc73_61d6aa4cc4ba',1),('2024-05-14 09:34:00',0.011262,'4afb8fcc_7b0c_44ac_be60_047fb1558096',1),('2024-05-14 09:34:00',0.011271,'8c29e7fa_4e23_4051_b094_d38aeb876baf',1),('2024-05-14 09:34:00',0.011262,'96fd3435_7ef5_4048_8fb3_75b9af61a41f',1),('2024-05-14 09:34:00',6130.109424,'d42df999_7cf9_4d44_ae01_a18ef558e6e3',1),('2024-05-14 09:34:00',0.011262,'0dd498be_ac1d_42f4_a263_87e43a7a37c7',1),('2024-05-14 09:34:00',0.501173,'4e8f2861_2ddd_4726_8e62_8750f8d4b057',1),('2024-05-14 09:34:00',0.011262,'d3317d03_ab5f_43d9_b6d9_c6afdb3e7e01',1),('2024-05-14 09:34:00',0.011274,'018ee79d_f7cd_791a_8bde_773a0b4869f6',1),('2024-05-14 09:34:00',0.011274,'018eebe8_b895_7e3e_96e9_f5120ca22e03',1),('2024-05-14 09:34:00',0.023324,'018ef175_1aee_7582_a1e5_de343926c84d',1),('2024-05-14 09:34:00',802.998499,'018f66bf_2780_74cc_a7ca_55fc18b9fa40',1),('2024-05-14 09:34:00',0.011262,'0cbe6193_be3d_4935_82f2_de3f796d9f16',1),('2024-05-14 09:34:00',19365.61479,'188ebcb8_0747_4475_8c27_8791e4e0f8b6',1),('2024-05-14 09:34:00',0.011271,'2b539c5e_62e8_4648_b24a_c8d1dbe3e112',1),('2024-05-14 09:34:00',5.054771,'59ff391e_5b74_4f9b_905d_e0ab6ec77648',1),('2024-05-14 09:34:00',0.012228,'6ddf1967_9338_4e10_baee_e95c90aa88bb',1),('2024-05-14 09:34:00',0.011262,'87c91be4_8340_426c_afbe_af23d7de950a',1),('2024-05-14 09:34:00',0.011262,'ec8e7909_6615_4790_a4ef_811b23ff18c6',1),('2024-05-14 09:34:00',0.011262,'0bbdbfbf_de5c_4205_be14_281811af819b',1),('2024-05-14 09:34:00',0.011262,'24512718_9705_4509_9a6a_d68b835f4c1d',1),('2024-05-14 09:34:00',3736.545885,'40b092bd_1079_4134_a773_75bce4e3cc3f',1),('2024-05-14 09:34:00',0.011262,'a026696f_c4db_413e_b7b3_5f22497b79fd',1),('2024-05-14 09:34:00',0.011262,'bde9e320_74f5_4b15_8e73_4441d449ff57',1),('2024-05-14 09:34:00',0.011262,'2df77a09_8230_4367_9678_79a60ac81664',1),('2024-05-14 09:34:00',0.011294,'4ba6b08a_86bf_4050_a22b_eabf51ea5388',1),('2024-05-14 09:34:00',0.011269,'5382c173_55ba_4ed9_8be7_7662cd1d26c7',1),('2024-05-14 09:34:00',0.011262,'90fd7310_cac1_4c75_be08_eea45d638367',1),('2024-05-14 09:34:00',661.020162,'96f31238_1969_4069_8696_fab1d48691e9',1),('2024-05-14 09:34:00',8.287948,'b4686b82_9c83_4314_9d0b_f01935d5b918',1),('2024-05-14 09:34:00',0.011327,'cb16e331_e033_458a_8820_7f496c6c6f55',1),('2024-05-14 09:34:00',0.011274,'018f66f8_75af_76a6_8aa9_9af052193c4d',1),('2024-05-14 09:34:00',0.011262,'15a21375_ed78_44e0_b75f_7820e1040bcd',1),('2024-05-14 09:34:00',0.01128,'2b7f178c_9907_49cd_8b5f_0c5bff19b24a',1),('2024-05-14 09:34:00',0.0113,'30a38052_c54f_49a3_bd37_73262c5b52fc',1),('2024-05-14 09:34:00',0.011262,'30ba1572_5119_46aa_b44b_6236fd282e15',1),('2024-05-14 09:34:00',0.011262,'6d6d15dc_bc13_44e3_b5b3_ea98b978cca0',1),('2024-05-14 09:34:00',995.940667,'db461497_bcb5_474d_ba84_0784bdefe5c2',1),('2024-05-14 09:34:00',0.011295,'018f75d7_6d4d_7cf3_9da8_5928795cea71',1),('2024-05-14 09:34:00',1305.329475,'7386dae2_d5f9_4767_b48f_5ff81d3416fb',1),('2024-05-14 09:34:00',0.011262,'881201e9_a3cb_4c9b_94df_52847255c068',1),('2024-05-14 09:34:00',0.166559,'abb20c26_00e0_439b_96aa_36944b53718a',1),('2024-05-14 09:34:00',107766.350069,'018f6fd1_7c07_7506_9a6d_e6b265c5d6a4',1),('2024-05-14 09:34:00',0.011353,'018f7530_56a2_785b_ae11_25616caf3d21',1),('2024-05-14 09:34:00',0.011262,'2cba2a98_ae4a_44f0_a056_4f8f03da06ea',1),('2024-05-14 09:34:00',754.120761,'41d37772_54f9_4295_8a3a_ee960870f590',1),('2024-05-14 09:34:00',0.011262,'47a0152a_c2f6_4ce8_952a_f8a430b5e8bd',1),('2024-05-14 09:34:00',367.53186,'7605857e_707c_43c9_93ff_f4d5d563a309',1),('2024-05-14 09:34:00',1.055816,'8616e1f3_7d18_4a96_adbf_8fa0efd04988',1),('2024-05-14 09:34:00',71.296525,'cbda3516_b5e8_4663_ace8_37f21a64f1aa',1),('2024-05-14 09:34:00',0.011283,'e70a0326_c59f_4ff2_8d70_faf0b978a77b',1),('2024-05-14 09:34:00',0.011274,'018f7199_f2dd_79ab_aa97_99c0cfa5f2fc',1),('2024-05-14 09:34:00',0.011274,'1d26314e_5c88_471d_a1f3_5d83d504a4fb',1),('2024-05-14 09:34:00',0.011262,'63e95d66_0f09_433e_ac51_d417cf61e067',1),('2024-05-14 09:34:00',0.011262,'851ef559_f2b6_4d97_ac16_3001b71d1594',1),('2024-05-14 09:34:00',0.011262,'b82e862c_9671_4ccd_9c09_f948cf505453',1),('2024-05-14 09:34:00',0.011281,'ce82f0cd_75a5_49da_be5e_92207a83d11d',1),('2024-05-14 09:34:00',0.011262,'f0b591c1_7ab8_4ac3_8441_3455edbb8c38',1),('2024-05-14 09:34:00',0.011274,'018ee0ff_633b_7821_a98d_5440bd900eb8',1),('2024-05-14 09:34:00',13.786467,'b77812fc_3c4d_4da9_afb9_0d2bbe308268',1),('2024-05-14 09:34:00',0.06599,'e28eeb00_615c_4432_8ade_bbbef0c4eccc',1),('2024-05-14 09:34:00',0.011274,'018f7504_82cc_73ee_bd2d_487e2d760657',1),('2024-05-14 09:34:00',0.011262,'0d60bb09_8d69_47bd_8d02_0ebdb84249a2',1),('2024-05-14 09:34:00',0.011262,'138a5039_b54a_40cc_a5e3_20bf287878cd',1),('2024-05-14 09:34:00',0.011262,'15dc32c5_09c6_4fba_a3da_18b9198ea52d',1),('2024-05-14 09:34:00',0.011262,'1ebee764_8a09_4509_a609_22911591cf9a',1),('2024-05-14 09:34:00',75095.506922,'3aa12bfc_9609_41d2_818e_ead61ae15a89',1),('2024-05-14 09:34:00',0.011276,'8cf57fac_9cc4_41cb_9f47_5e1d465fa328',1),('2024-05-14 09:34:00',0.070017,'98dd1a20_f3b4_4e44_bcaa_8e56a57efb6b',1),('2024-05-14 09:34:00',52.941374,'ca3e7774_2e2e_4182_b43a_fd7ae6c55ade',1),('2024-05-14 09:34:00',0.011262,'d9b40ec9_cf8e_4fc0_aed4_b66a0b26dd75',1),('2024-05-14 09:34:00',139078.224266,'018ea356_7b0f_7940_a3eb_53a627bcf657',1),('2024-05-14 09:34:00',0.011269,'79f5c5e5_ab63_42ce_9386_7995133ede83',1),('2024-05-14 09:34:00',0.011274,'8d229d66_e73e_4abc_ba5c_2710f0ddfb07',1),('2024-05-14 09:34:00',0.011274,'backup_0428',1),('2024-05-14 09:34:00',0.011262,'c16eaa71_85b1_4e8f_9d03_a956f72c4bf7',1),('2024-05-14 09:34:00',0.011262,'f633cbad_016a_4334_9284_347d56051432',1),('2024-05-14 09:34:00',0.012045,'018ee6d3_74be_7916_8d67_e95214eca2d4',1),('2024-05-14 09:34:00',0.016117,'23f1bef1_4211_4a60_9199_fa6846b94f67',1),('2024-05-14 09:34:00',0.011262,'7e21bc2c_1fe5_45c1_ba9e_6b5be3d69891',1),('2024-05-14 09:34:00',0.011274,'89d70ed7_4802_4bd3_b34a_54159c1328cd',1),('2024-05-14 09:34:00',6996.084768,'a9fb46e7_754f_4242_90fa_d259438c1584',1),('2024-05-14 09:34:00',0.011262,'fd077067_ee63_458a_9faf_bdb7f31c3869',1),('2024-05-14 09:34:00',0.217139,'2eef7bbd_b507_422c_96e3_4a51513ad942',1),('2024-05-14 09:34:00',173.090146,'4525eab3_fe4e_4901_870b_e7913fc48f42',1),('2024-05-14 09:34:00',1884.358188,'72ce7472_c878_45a4_8c31_29fe9b241a66',1),('2024-05-14 09:34:00',0.011262,'af62045e_a203_47be_a8bb_0428ee9eb875',1),('2024-05-14 09:34:00',4635.655005,'018ee6da_7812_715e_8ab6_61994c684870',1),('2024-05-14 09:34:00',0.012196,'26630d5a_529f_43fa_938c_6793a2052e9e',1),('2024-05-14 09:34:00',366.838664,'41a3cf87_fdaf_415e_850f_b833b711441c',1),('2024-05-14 09:34:00',0.016332,'57f13ca8_94d2_4084_b118_9bf76b0a8192',1),('2024-05-14 09:34:00',0.013138,'59abc9c7_2271_4f89_a744_0e966017e6ef',1),('2024-05-14 09:34:00',892.625617,'5ebbb287_b5a2_43e5_ae4c_016446c6cc5b',1),('2024-05-14 09:34:00',0.062768,'655c8d87_44f2_45dc_bb9b_0235f5fe9138',1),('2024-05-14 09:34:00',0.011262,'ced01ed7_299d_4d91_a526_519fff1a059b',1),('2024-05-14 09:34:00',0.025125,'d79bf09a_8256_4303_96e8_2c73a948c76c',1),('2024-05-14 09:34:00',0.011262,'e202c074_1009_4759_9798_98679b9e5ffe',1),('2024-05-14 09:34:00',0.218119,'1a51e647_e6bf_4d77_ba53_a7a2b01725f2',1),('2024-05-14 09:34:00',0.011274,'363924ff_af19_4496_9d2b_12bb334c2968',1),('2024-05-14 09:34:00',0.011262,'4569a9a7_a447_4b01_a517_5abe48f16442',1),('2024-05-14 09:34:00',689.04851,'eb159c93_5d65_4484_9c12_805743bbd9ae',1),('2024-05-14 09:34:00',0.011259,'f1092f9d_0400_4886_8b16_31ba527f7911',1),('2024-05-14 09:34:00',0.011274,'018f7505_f89c_78ae_aaed_dd966d34b023',1),('2024-05-14 09:34:00',0.012043,'0b6d35cc_11ab_4da5_a5c5_c4cc09917c11',1),('2024-05-14 09:34:00',0.011288,'3f7da07f_9e90_40d8_b373_de3ce5cdaf06',1),('2024-05-14 09:34:00',369.700976,'c0ed7baf_c26f_4eda_9b29_10dd06ee1f87',1),('2024-05-14 09:34:00',0.011262,'eeed9193_ed98_4c5c_82f8_90971b9b8c67',1),('2024-05-14 09:34:00',0.011274,'018f7141_5d0e_7fc6_af09_ee1807d5867b',1),('2024-05-14 09:34:00',0.011262,'319e5252_9d09_44a8_8ee1_f9f7ac09fcbe',1),('2024-05-14 09:34:00',0.5165,'b623760d_2e5e_488b_922d_4b66e3c83265',1),('2024-05-14 09:34:00',0.011274,'018f6ff2_7180_7214_b33d_80eee9c79fed',1),('2024-05-14 09:34:00',0.011274,'17fbfea7_2dbc_4a40_bb53_9f7499fa861c',1),('2024-05-14 09:34:00',1105.929523,'1c677ca7_6ec2_45f3_bcd2_52a5aa45763e',1),('2024-05-14 09:34:00',0.011262,'65a970d0_9c37_41d1_9865_0f4356d85ba8',1),('2024-05-14 09:34:00',0.011274,'a62f50b5_0b29_4b77_9878_f4e563159498',1),('2024-05-14 09:34:00',0.011262,'db54f319_cea9_4e53_8d91_7618532600a6',1)"}

Expected Behavior

Insert succeeds

Steps to Reproduce

See detail in Actual Behavior

Additional information

Cloud QA env

DanielZhangQD avatar May 16 '24 07:05 DanielZhangQD

像是取zmap有问题。

Selection_010

daviszhen avatar May 16 '24 07:05 daviszhen

有没有完整的重现步骤？仅仅一个ddl啥也看不出来

@DanielZhangQD

aunjgr avatar May 16 '24 07:05 aunjgr

  • Upgraded CN at about 2024.05.14 17:10 UTC+8 from v1.1.3-99e77a2c4-2024-04-24 to v1.2.0-76ce4ef7e-2024-05-14,
  • Default CN started at about 17:11 - 17:12, https://grafana.cn-qa.matrixone.tech/goto/IKqN3mEIg?orgId=1
  • And the error logs were fired from about 17:13:06 https://grafana.cn-qa.matrixone.tech/goto/7QIA3mESR?orgId=1

DanielZhangQD avatar May 16 '24 07:05 DanielZhangQD

Image

向 storage 表做 insert 时报错，初步认为是传入 zm.AnyIn(*Vector) 的参数 vec 的 area 为空

aptend avatar May 16 '24 10:05 aptend

原因如 #16085 所述

aunjgr avatar May 17 '24 07:05 aunjgr

修复panic的PR已经合并。

aunjgr avatar May 20 '24 07:05 aunjgr

It was fixed in the cloud dev with commit v1.2.0-9b28e8ec5-2024-05-21

DanielZhangQD avatar May 22 '24 00:05 DanielZhangQD

bvt补充复现case：创建符合主键的表，preprare insert 大于4行的values

heni02 avatar May 30 '24 09:05 heni02

add case done，closed

heni02 avatar May 31 '24 07:05 heni02