matrixorigin / matrixone

Hyperconverged cloud-edge native database
https://docs.matrixorigin.cn/en
Apache License 2.0
1.79k stars 277 forks source link

[Bug]: panic happens when load data into the temporary table. #7875

Open daviszhen opened 1 year ago

daviszhen commented 1 year ago

Is there an existing issue for the same bug?

Environment

- Version or commit-id (e.g. v0.1.0 or 8b23a93):4410d8618193455fc0be25d3af17d19b5bbc1a0e
- Hardware parameters: mac
- OS type:
- Others:

Actual Behavior

mysql> create temporary table t1( -> col1 tinyint, -> col2 smallint, -> col3 int, -> col4 bigint, -> col5 tinyint unsigned, -> col6 smallint unsigned, -> col7 int unsigned, -> col8 bigint unsigned -> ); Query OK, 0 rows affected (0.01 sec)

mysql> load data infile '/Users/pengzhen/Documents/GitHub/matrixone/test/distributed/resources/load_data/integer_numbers_1.csv' into table t1; ERROR 20101 (HY000): internal error: panic unknown attr: %!%mo__meta_loc: github.com/matrixorigin/matrixone/pkg/txn/storage/memorystorage.(MemHandler).rangeBatchPhysicalRows /Users/pengzhen/Documents/GitHub/matrixone/pkg/txn/storage/memorystorage/mem_handler.go:1252 github.com/matrixorigin/matrixone/pkg/txn/storage/memorystorage.(MemHandler).HandleWrite /Users/pengzhen/Documents/GitHub/matrixone/pkg/txn/storage/memorystorage/mem_handler.go:1168 github.com/matrixorigin/matrixone/pkg/txn/storage/memorystorage.(*CatalogHandl mysql>

Expected Behavior

Insert succeeds without panic

Steps to Reproduce

it can be reproduced everytime.

Additional information

No response

jensenojs commented 1 year ago

cn write s3 finished insert operations, we need to process with delete and the performance of unique,primary key constraints

jensenojs commented 1 year ago

The temporary table needs to be redesigned. Shouldn't be able to fix it that quickly

jensenojs commented 1 year ago

On leave of absence