MatrixOne Files

Release date: June 18, 2025 MatrixOne version: v2.2.0

MatrixOne 2.2.0 introduces a series of bug fixes that enhance system performance, stability, and usability. Below are the major updates.

Bugfix

Fix cdc bug Fix the bug of enum Fix duplicate pk due to big delete Fix rollup with having by Fix join order for DML plan

What's Changed

• sync verfied 2.0 merge changes to 2.1 by @aptend in https://github.com/matrixorigin/matrixone/pull/21528
• modify mergify config to adapt 2.1-dev by @guguducken in https://github.com/matrixorigin/matrixone/pull/21536
• improve the performance of cleaning up the deleted table stats from the stats table. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21541
• fix: ignore some test in prepare.test by @huby2358 in https://github.com/matrixorigin/matrixone/pull/21545
• fix read ckp meta by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21548
• malloc: fix VSS leaks by @reusee in https://github.com/matrixorigin/matrixone/pull/21543
• Small refactor ckp by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21559
• fix potential memory leak by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21563
• fix the prepare.test BVT case. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21568
• fix timeout - main by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21571
• spherical kmeans for sparse vector and bug fix by @cpegeric in https://github.com/matrixorigin/matrixone/pull/21529
• fix adding incorrect delete entris to partition state index by @aptend in https://github.com/matrixorigin/matrixone/pull/21558
• fix: AnalyzeExecPlan bug which cause sysbench10w update panic by @huby2358 in https://github.com/matrixorigin/matrixone/pull/21549
• Fix get snapshot "file not found" error by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/21581
• Unify the snapshot read and latest read-1 by @triump2020 in https://github.com/matrixorigin/matrixone/pull/21441
• [improvement] logservice: add some logs in truncation of logservice. by @volgariver6 in https://github.com/matrixorigin/matrixone/pull/21583
• fix change handle by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21579
• add wasm support for merge mo-ctl by @aptend in https://github.com/matrixorigin/matrixone/pull/21586
• [opt] merge multiple filters on primary key by @aunjgr in https://github.com/matrixorigin/matrixone/pull/21593
• Fix workspace delete - main by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21597
• fix an invalid memory access by @aunjgr in https://github.com/matrixorigin/matrixone/pull/21600
• fix wasm dir to avoid grep check by @aptend in https://github.com/matrixorigin/matrixone/pull/21604
• Fix collectObjects for updateTableInfo by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/21612
• fix data race by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21544
• vector array remove unncessary cast from []float32 to []float64. by @cpegeric in https://github.com/matrixorigin/matrixone/pull/21576
• update ckp cluster column by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21613
• Fix cdc issues main by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21625
• merge small insert/delete bat to full batch in workspace. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21587
• Fix the bug of enum.Formt missing value by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/21628
• Fix cdc ddl error by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/21631
• refactor cn s3 writer. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21522
• fix bug: panic in replace statement by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/21633
• update CDC change handle by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21636
• better expr print for debug by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21642
• fix bug: prefix_in not sorted in prepare stmt by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/21643
• fix the TestRemoveRunningTaskNotExists. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21646
• fix TestGlobalCheckpoint7 by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21648
• reduce goroutines used calculating stats by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21650
• fix bug: dot not upgrade BM25 by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/21661
• update cdc sinker and changes handle by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21665
• fix the object sort key index mismatch when CN flush objects. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21660
• [opt] convert BETWEEN filter to PREFIX_BETWEEN on composite keys by @aunjgr in https://github.com/matrixorigin/matrixone/pull/21673
• [fix] properly handle sing-column CLUSTER BY by @aunjgr in https://github.com/matrixorigin/matrixone/pull/21671
• fix checkpoint UT by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21675
• Fix TestKill data race by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/21683
• merge small insert batch into full batch in the workspace. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21639
• fix collect softdelete objects in TN by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21688
• fix abort mark active txn by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/21692
• fix CN OOM by S3Writer in big data test. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21694
• [Refactoring]: IVFFLAT better error handling by @cpegeric in https://github.com/matrixorigin/matrixone/pull/21621
• fix dynamic rpath error for darwin by @guguducken in https://github.com/matrixorigin/matrixone/pull/21697
• fileservice: delete temp files if write error by @reusee in https://github.com/matrixorigin/matrixone/pull/21662
• fix mergeTxnWorkspaceLocked by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21705
• add check local timeout txn by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/21703
• BVT cases for the replace statements in the workspace. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21707
• fix TestAppend2 by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21717
• fix bug: agg push down panic by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/21709
• fix ExportStats by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21719
• use variables ORIGIN instead of absolute paths by @guguducken in https://github.com/matrixorigin/matrixone/pull/21710
• Fix TestCkpLeak (#21572) by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/21723
• add debug log by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21724
• fix the compaction of objects by deletion when merging the TXN workspace. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21727
• Fix TestPitrMeta by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/21635
• fix merge alloc by @aptend in https://github.com/matrixorigin/matrixone/pull/21731
• Fix data race in TestDoHeartbeatInvalidTask by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/21735
• [opt] improve join order and enable runtime filter for fulltext UPDATE by @aunjgr in https://github.com/matrixorigin/matrixone/pull/21733
• Fix the block filter not work when where sortKey = ''. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21741
• add debug log by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21745
• feat: alter user lock by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/21737
• Fix the file service not found error when CN flushes objects. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21746
• Improve the performance of the apply deletes in the workspace writes. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21627
• fix the duplicated entry issue caused by merging deletion on the uncommitted objects. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21753
• refactor some cdc code - phase 1 by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21656
• fix duplicate pk due to big delete by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21757
• [#21676]revert commid 6fbbd by @triump2020 in https://github.com/matrixorigin/matrixone/pull/21749
• Fix cdc mo to mo invalid connection by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/21755
• chore: remove bvt test tag [#14293] by @xzxiong in https://github.com/matrixorigin/matrixone/pull/21752
• retry when remote lock i/o timeout by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/21761
• Fix mo_cdc_task does not exist by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/21765
• small updates for the workspace. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21766
• fix txn mistakenly aborted duo to deadlock by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/21750
• remove bvt tag by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/21770
• clean some code in the workspace. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21725
• fix bug: panic in order by uuid column by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/21775
• improve txn leak checker by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/21780
• Support changing the product name into OmniFabric by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/21777
• Remove the wrong sql by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/21783
• Fix TestPitrMeta by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/21787
• Add Fast GC by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/21325
• Revert "Add Fast GC (#21325)" by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/21789
• fix block_max_row is defined and used inconsistently across multiple files by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21772
• reduce goetty log output by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/21793
• improve lock holders by @zhangxu19830126 in https://github.com/matrixorigin/matrixone/pull/21779
• [#21676]Bug fix : performance degradation since commit id 6fbbd by @triump2020 in https://github.com/matrixorigin/matrixone/pull/21773
• [ci] remove bvt tag 14475 by @aunjgr in https://github.com/matrixorigin/matrixone/pull/21797
• BUG FIX: Fulltext skip overlap from N-gram output by @cpegeric in https://github.com/matrixorigin/matrixone/pull/21794
• Remove txn reader from logtail by @aptend in https://github.com/matrixorigin/matrixone/pull/21315
• Fix duplicate entry in replace into caused by the FastApplyDeletesByRowIds. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21801
• BUG FIX: [Subtask]: 对象分配优化：fifocache.shardCacheKey by @cpegeric in https://github.com/matrixorigin/matrixone/pull/21806
• [Subtask]: 对象分配优化：fileservice.newEventLogger [#21394] by @cpegeric in https://github.com/matrixorigin/matrixone/pull/21805
• Fengttt cl by @fengttt in https://github.com/matrixorigin/matrixone/pull/18212
• Revert "[Subtask]: 对象分配优化：fileservice.newEventLogger [#21394] (#21805)" by @cpegeric in https://github.com/matrixorigin/matrixone/pull/21808
• add comments on functions like buildFulltextIndexTable by @cpegeric in https://github.com/matrixorigin/matrixone/pull/21804
• [ci] remove bvt tags by @aunjgr in https://github.com/matrixorigin/matrixone/pull/21802
• s3fifo add ghost fifo by @cpegeric in https://github.com/matrixorigin/matrixone/pull/21653
• Fix make clean by @fengttt in https://github.com/matrixorigin/matrixone/pull/21817
• [Refactoring]: Add comment on functions like buildFulltextIndexTable by @cpegeric in https://github.com/matrixorigin/matrixone/pull/21827
• Refactor merge scheduler by @aptend in https://github.com/matrixorigin/matrixone/pull/21818
• Remove some fileds to simplify dirty tree by @aptend in https://github.com/matrixorigin/matrixone/pull/21820
• fix rollup with having by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/21834
• fix concurrent map read and map write by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/21832
• Add LoadColumnsData error log by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/21842
• fix the cdc duplicated entry issue caused by in-memory transfer tombstones. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21846
• disable enum column in pk/index by @aunjgr in https://github.com/matrixorigin/matrixone/pull/21822
• Hdfs by @cpegeric in https://github.com/matrixorigin/matrixone/pull/21492
• CI: upgrade go version to 1.24.3 by @guguducken in https://github.com/matrixorigin/matrixone/pull/21841
• ci(mergify): upgrade configuration to current format by @mergify in https://github.com/matrixorigin/matrixone/pull/21622
• fix TestLockWithBindIsStale, TestIterLocks by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/21860
• fix the data race in statsInCache and add slices sorted check when compiling with -race. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21857
• fix data race 2.2 by @aptend in https://github.com/matrixorigin/matrixone/pull/21871
• for_debug_21865_2.2 by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21875
• Pick revert s3fifo to 2.2-dev by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21876
• For 2.2-dev : metadata_scan supports checking the metadata of index table by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/21872
• add case(2.2-dev) by @Ariznawlll in https://github.com/matrixorigin/matrixone/pull/21879
• fix join order for DML plan by @aunjgr in https://github.com/matrixorigin/matrixone/pull/21890
• For 2.2 dev: metadata_scan supports checking the metadata of tombstone objects now by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/21892
• force SINK_SCAN to run on single CN by @aunjgr in https://github.com/matrixorigin/matrixone/pull/21898
• fix bug: execute using @var which value is null (#21895) by @ouyuanning in https://github.com/matrixorigin/matrixone/pull/21901
• persist merge settings 2.2 by @aptend in https://github.com/matrixorigin/matrixone/pull/21902
• to 2.2: fix the duplicate entry in the CDC test. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21909
• Modify the e2e log configuration by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/21912
• For 2.2: not throw panic "not supported: median in distinct mode:" by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/21897
• fix 21911 by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21919
• Fix version bug of cpt file 2.2 by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/21925
• to 2.2: fix tombstone object missing after the CN transfer by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21930
• Fix vacuum check 2.2 by @aptend in https://github.com/matrixorigin/matrixone/pull/21934
• Fix 5252 to 2.2-dev by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21936
• For 2.2: remove bvt tag by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/21939
• For 2.2: fix panic by @Cabbage74 in https://github.com/matrixorigin/matrixone/pull/21953
• fix 21952 for 2.2-dev by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21954
• fix error handling of merge settings 2.2 by @aptend in https://github.com/matrixorigin/matrixone/pull/21947
• update median by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21959
• to 2.2: fix data race in buildTablePairFromCache by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21965
• remove dummy debug info by @XuPeng-SH in https://github.com/matrixorigin/matrixone/pull/21962
• update by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21970
• Add merge simulator and wide-span check by @aptend in https://github.com/matrixorigin/matrixone/pull/21972
• CI: modify dockerfile (#21935) by @guguducken in https://github.com/matrixorigin/matrixone/pull/21966
• disable runtime filter on fulltext DML temporarily by @aunjgr in https://github.com/matrixorigin/matrixone/pull/21976
• to 2.2: fix data race in ReConnectionBackOff. by @gouhongshen in https://github.com/matrixorigin/matrixone/pull/21975
• add merge input trace command and span priority check by @aptend in https://github.com/matrixorigin/matrixone/pull/21986
• fix changes handle by @jiangxinmeng1 in https://github.com/matrixorigin/matrixone/pull/21991
• fix txn unlock fatal by @iamlinjunhong in https://github.com/matrixorigin/matrixone/pull/21995
• [#21864]Cherry pick fix 21864 by @triump2020 in https://github.com/matrixorigin/matrixone/pull/21967
• fix allocate id by @aptend in https://github.com/matrixorigin/matrixone/pull/22006
• Fix PopulateBinaryFuse8 error panic by @LeftHandCold in https://github.com/matrixorigin/matrixone/pull/22019

New Contributors

• @mergify made their first contribution in https://github.com/matrixorigin/matrixone/pull/21622

Full Changelog: https://github.com/matrixorigin/matrixone/compare/v2.1.1-hotfix-20250611...v2.2.0