Releases: matrixorigin/matrixone
MatrixOne-v2.2.0
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 #21528
- modify mergify config to adapt 2.1-dev by @guguducken in #21536
- improve the performance of cleaning up the deleted table stats from the stats table. by @gouhongshen in #21541
- fix: ignore some test in prepare.test by @huby2358 in #21545
- fix read ckp meta by @jiangxinmeng1 in #21548
- malloc: fix VSS leaks by @reusee in #21543
- Small refactor ckp by @XuPeng-SH in #21559
- fix potential memory leak by @XuPeng-SH in #21563
- fix the prepare.test BVT case. by @gouhongshen in #21568
- fix timeout - main by @XuPeng-SH in #21571
- spherical kmeans for sparse vector and bug fix by @cpegeric in #21529
- fix adding incorrect delete entris to partition state index by @aptend in #21558
- fix: AnalyzeExecPlan bug which cause sysbench10w update panic by @huby2358 in #21549
- Fix get snapshot "file not found" error by @LeftHandCold in #21581
- Unify the snapshot read and latest read-1 by @triump2020 in #21441
- [improvement] logservice: add some logs in truncation of logservice. by @volgariver6 in #21583
- fix change handle by @jiangxinmeng1 in #21579
- add wasm support for merge mo-ctl by @aptend in #21586
- [opt] merge multiple filters on primary key by @aunjgr in #21593
- Fix workspace delete - main by @XuPeng-SH in #21597
- fix an invalid memory access by @aunjgr in #21600
- fix wasm dir to avoid grep check by @aptend in #21604
- Fix collectObjects for updateTableInfo by @LeftHandCold in #21612
- fix data race by @jiangxinmeng1 in #21544
- vector array remove unncessary cast from []float32 to []float64. by @cpegeric in #21576
- update ckp cluster column by @jiangxinmeng1 in #21613
- Fix cdc issues main by @XuPeng-SH in #21625
- merge small insert/delete bat to full batch in workspace. by @gouhongshen in #21587
- Fix the bug of enum.Formt missing value by @LeftHandCold in #21628
- Fix cdc ddl error by @LeftHandCold in #21631
- refactor cn s3 writer. by @gouhongshen in #21522
- fix bug: panic in replace statement by @ouyuanning in #21633
- update CDC change handle by @jiangxinmeng1 in #21636
- better expr print for debug by @XuPeng-SH in #21642
- fix bug: prefix_in not sorted in prepare stmt by @ouyuanning in #21643
- fix the
TestRemoveRunningTaskNotExists
. by @gouhongshen in #21646 - fix TestGlobalCheckpoint7 by @jiangxinmeng1 in #21648
- reduce goroutines used calculating stats by @XuPeng-SH in #21650
- fix bug: dot not upgrade BM25 by @ouyuanning in #21661
- update cdc sinker and changes handle by @jiangxinmeng1 in #21665
- fix the object sort key index mismatch when CN flush objects. by @gouhongshen in #21660
- [opt] convert BETWEEN filter to PREFIX_BETWEEN on composite keys by @aunjgr in #21673
- [fix] properly handle sing-column CLUSTER BY by @aunjgr in #21671
- fix checkpoint UT by @jiangxinmeng1 in #21675
- Fix TestKill data race by @LeftHandCold in #21683
- merge small insert batch into full batch in the workspace. by @gouhongshen in #21639
- fix collect softdelete objects in TN by @XuPeng-SH in #21688
- fix abort mark active txn by @iamlinjunhong in #21692
- fix CN OOM by S3Writer in big data test. by @gouhongshen in #21694
- [Refactoring]: IVFFLAT better error handling by @cpegeric in #21621
- fix dynamic rpath error for darwin by @guguducken in #21697
- fileservice: delete temp files if write error by @reusee in #21662
- fix mergeTxnWorkspaceLocked by @jiangxinmeng1 in #21705
- add check local timeout txn by @iamlinjunhong in #21703
- BVT cases for the replace statements in the workspace. by @gouhongshen in #21707
- fix TestAppend2 by @jiangxinmeng1 in #21717
- fix bug: agg push down panic by @ouyuanning in #21709
- fix ExportStats by @jiangxinmeng1 in #21719
- use variables ORIGIN instead of absolute paths by @guguducken in #21710
- Fix TestCkpLeak (#21572) by @LeftHandCold in #21723
- add debug log by @jiangxinmeng1 in #21724
- fix the compaction of objects by deletion when merging the TXN workspace. by @gouhongshen in #21727
- Fix TestPitrMeta by @LeftHandCold in #21635
- fix merge alloc by @aptend in #21731
- Fix data race in TestDoHeartbeatInvalidTask by @Cabbage74 in #21735
- [opt] improve join order and enable runtime filter for fulltext UPDATE by @aunjgr in #21733
- Fix the block filter not work when
where sortKey = ''
. by @gouhongshen in #21741 - add debug log by @jiangxinmeng1 in #21745
- feat: alter user lock by @ouyuanning in #21737
- Fix the file service not found error when CN flushes objects. by @gouhongshen in #21746
- Improve the performance of the apply deletes in the workspace writes. by @gouhongshen in #21627
- fix the duplicated entry issue caused by merging deletion on the uncommitted objects. by @gouhongshen in #21753
- refactor some cdc code - phase 1 by @XuPeng-SH in #21656
- fix duplicate pk due to big delete by @XuPeng-SH in #21757
- [#21676]revert commid 6fbbd by @triump2020 in #21749
- Fix cdc mo to mo invalid connection by @LeftHandCold in #21755
- chore: remove bvt test tag #14293 by @xzxiong in #21752
- retry when remote lock i/o timeout by @iamlinjunhong in #21761
- Fix mo_cdc_task does not exist by @LeftHandCold in #21765
- small updates for the workspace. by @gouhongshen in #21766
- fix txn mistakenly aborted duo to deadlock by @iamlinjunhong in #21750
- remove bvt tag by @ouyuanning in #21770
- clean some code in the workspace. by @gouhongshen in #21725
- fix bug: panic in order by uuid column by @ouyuanning in #21775
- improve txn leak checker by @zhangxu19830126 in #21780
- Support changing the product name into OmniFabric by @Cabbage74 in #21777
- Remove the wrong sql by @Cabbage7...
MatrixOne-v2.1.1-hotfix-20250611
Release date: June 11, 2025
MatrixOne version: v2.1.1-hotfix-20250611
MatrixOne v2.1.1-hotfix-20250611 introduces bug fixes. Below are the major updates and new features.
Bugfix
Fix bug Replace into duplicate
Fix delete hung
What's Changed
- to 2.1: fix tombstone object missing after cn transfer by @gouhongshen in #21948
- fix changes handle by @jiangxinmeng1 in #21994
- Pick delete hung fix to 2.1 by @XuPeng-SH in #21998
Full Changelog: v2.1.1-hotfix-20250519...v2.1.1-hotfix-20250611
MatrixOne-v2.1.1-hotfix-20250519
Release date: April 19, 2025
MatrixOne version: v2.1.1-hotfix-20250519
MatrixOne v2.1.1-hotfix-20250519 introduces bug fixes that enhance system usability and stability. Below are the major updates and new features.
Bugfix
- Fix bug related to Fulltext searching and GC-PANIC
What's Changed
- BUG FIX: Fulltext skip overlap from N-gram output 2.1-dev (#21799) by @volgariver6 in #21844
- Remove GC's panic(), use Warn log instead: GC-PANIC by @LeftHandCold in #21843
Full Changelog: v2.1.1...v2.1.1-hotfix-20250519
MatrixOne-v2.1.1
Release date: May 08, 2025
MatrixOne version: v2.1.1
MatrixOne 2.1.1 introduces a series of improvements and bug fixes that enhance system performance, stability, and usability. Below are the major updates and new features.
Key Improvements
- improve join order and enable runtime filter for fulltext UPDATE
- add check local timeout txn
- retry when remote lock i/o timeout
- convert BETWEEN filter to PREFIX_BETWEEN on composite keys
Bugfix
- Fix bugs related to oom
- Fix some merge bugs
- Fix bugs related to cdc func
- Fix bugs releted to sing-column CLUSTER BY key
- fix bugs related to big delete
- fix panic in order by uuid column type
- fix bug related to deadlock overkill
What's Changed
- Cp 21661 to 2.1-dev by @ouyuanning in #21664
- [fix] properly handle sing-column CLUSTER BY by @aunjgr in #21672
- Fix cdc Error panic by @LeftHandCold in #21680
- to 2.1: filter out the deletes object when merging deletes in the workspace. by @gouhongshen in #21681
- fix collect softdelete objects in TN in 2.1 by @XuPeng-SH in #21689
- fix abort mark active txn by @iamlinjunhong in #21693
- fix cdc panic by @XuPeng-SH in #21700
- fix mergeTxnWorkspaceLocked by @jiangxinmeng1 in #21706
- to 2.1: BVT cases for the replace statements in the workspace. by @gouhongshen in #21708
- fix bug: agg push down panic by @ouyuanning in #21712
- add check local timeout txn by @iamlinjunhong in #21704
- fix ExportStats by @jiangxinmeng1 in #21720
- [opt] improve join order and enable runtime filter for fulltext UPDATE by @aunjgr in #21747
- Fix merge alloc 2.1 by @aptend in #21732
- [opt] convert BETWEEN filter to PREFIX_BETWEEN on composite keys by @aunjgr in #21674
- to 2.1: fix the compaction of objects by deletion when merging the TXN workspace. by @gouhongshen in #21729
- fix duplicate pk due to big delete by @XuPeng-SH in #21756
- retry when remote lock i/o timeout by @iamlinjunhong in #21762
- fix txn mistakenly aborted duo to deadlock by @iamlinjunhong in #21751
- sync dynamic link fix to 2.1-dev by @guguducken in #21764
- fix bug: panic in order by uuid column by @ouyuanning in #21776
- to 2.1: Fix the block filter not work when
where sortKey = ''
by @gouhongshen in #21781 - Support changing the product name into OmniFabric(For 2.1dev) by @Cabbage74 in #21782
Full Changelog: v2.1.0...v2.1.1
v2.0.3-hotfix-20250417
Release date: April 17, 2025
MatrixOne version: v2.0.3-hotfix-20250417
MatrixOne v2.0.3-hotfix-20250417 introduce a bug fix that enhance usability. Below are the major updates and new features.
Bugfix
- Fix bugs related to panic when executing particular statement
What's Changed
- fix bug: agg push down panic by @ouyuanning in #21715
Full Changelog: v2.0.3-hotfix-20250416...v2.0.3-hotfix-20250417
v2.0.3-hotfix-20250416
Release date: April 16, 2025
MatrixOne version: v2.0.3-hotfix-20250416
MatrixOne v2.0.3-hotfix-20250416 introduce a bug fix that enhance system stability, and usability. Below are the major updates and new features.
Bugfix
- Fix a bug related to txn stability
What's Changed
- cherry pick fix abort mark active txn to 2.0.3 hotfix (#21693) by @XuPeng-SH in #21696
Full Changelog: v2.0.3...v2.0.3-hotfix-20250416
MatrixOne-v2.1.0-hotfix-20250409
Release date: April 09, 2025
MatrixOne version: v2.1.0-hotfix-20250409
MatrixOne v2.1.0-hotfix-20250409 introduces a bug fix that enhance system usability and upgrade. Below are the major updates and new features.
Bugfix
- Fix bug related to data upgrade
What's Changed
- Cp 21661 to 2.1-dev by @ouyuanning in #21664
Full Changelog: v2.1.0...v2.1.0-hotfix-20250409
MatrixOne-v2.0.5
Release date: April 06, 2025
MatrixOne version: v2.0.5
MatrixOne 2.0.5 introduces a bug fixe that enhance system security. Below are the major updates and new features.
Bugfix
- Fix bugs related to security for license
What's Changed
- fix license by @zhangxu19830126 in #21655
Full Changelog: v2.0.4...v2.0.5
MatrixOne-v2.1.0
Release date: April 06, 2025
MatrixOne version: v25.2.1.0
We are thrilled to announce the official release of MatrixOne v25.2.1.0 on April 06, 2025!
What is MatrixOne?
MatrixOne is an AI-driven cloud-native hyper-converged database that adopts a storage-compute separation architecture and fully leverages cloud infrastructure. It is MySQL-compatible and supports hybrid workload scenarios. By combining vector data types and full-text search capabilities, MatrixOne efficiently handles multi-modal data querying and management for generative AI applications.
Feature Overview
The new version of MatrixOne comprehensively supports full-text search and BM25 relevance retrieval, significantly improving the accuracy and efficiency of text data queries. With the optimized LOAD DATA
command, it enables efficient loading of large-scale data from the HDFS file system, further enhancing data processing performance. The newly added inter-cluster CDC (Change Data Capture) feature ensures real-time data synchronization and consistency across multiple clusters. Additionally, as an experimental feature, it introduces vector indexing technology based on the HNSW algorithm, providing a new solution for high-dimensional data processing and vector similarity search. Furthermore, the newly supported Python SDK for full-text and vector search lowers the development barrier, accelerating the construction of intelligent applications.
Use Cases
MatrixOne is suitable for the following application scenarios. We warmly welcome users with the following business pain points and needs to contact us for trial testing.
- Generative AI Scenarios: MatrixOne's hyper-converged database provides robust multi-modal data support, real-time retrieval, and intelligent data processing capabilities for generative AI, forming the core infrastructure for generative AI applications. In multi-modal scenarios such as text generation and image generation, MatrixOne ensures rapid responses and high-quality generative results on large-scale datasets through efficient data management, vector and hybrid search, Python UDF-supported data cleaning and preprocessing, and GPU-accelerated real-time inference. Whether handling large-scale data access and storage or online inference and dynamic feedback, MatrixOne delivers stable, low-latency support for generative AI applications, helping enterprises quickly deploy, iterate, and optimize generative AI solutions.
- Time-Series Data Applications: In modern IoT applications, billions of devices and sensors continuously collect and transmit data, including industrial production lines, smart grids, smart city infrastructure, and autonomous vehicles, generating terabytes of real-time data daily. MatrixOne's hyper-converged database provides efficient real-time data processing capabilities for IoT scenarios, supporting millisecond-level high-concurrency writes and fast retrieval while offering superior scalability to handle peak loads. Its real-time analytics capabilities enable businesses to quickly derive critical insights from massive IoT data. Seamless integration with machine learning models allows real-time data streams to feed directly into models for prediction and anomaly detection, making it ideal for industrial predictive maintenance, energy efficiency optimization, and intelligent monitoring applications, fully meeting IoT needs for high throughput, low latency, and intelligent data management.
- Hybrid Workload Support: In enterprise OA, ERP, and CRM systems, traditional single-machine databases often struggle to meet performance demands during peak periods as data volume and business complexity grow. Critical timeframes, such as month-end or quarter-end, typically require high-frequency analysis and real-time statistical reporting for decision-making. Many enterprises resort to standalone analytical databases or sharding to alleviate query loads on primary databases. MatrixOne's hybrid workload support eliminates the need for additional systems by enabling both operational and analytical needs within a single database, ensuring rapid responses under high concurrency through real-time data analytics. Its scalability allows seamless expansion as business grows, maintaining efficient real-time queries and statistics even with large-scale data growth, ensuring real-time, continuous, and efficient data-driven decision-making while enhancing flexibility in data management.
- Enterprise SaaS Scenarios: With the rapid growth of enterprise SaaS applications, SaaS development must address multi-tenant model requirements. Traditional approaches often force a choice between shared database instances for multiple tenants or dedicated instances per tenant, creating trade-offs between management costs and tenant isolation. MatrixOne natively supports multi-tenancy, providing workload isolation and independent scalability between tenants while offering unified management. This architecture effectively reduces management costs, ensures data isolation, and improves operational efficiency, fully meeting SaaS needs for cost control, ease of management, and isolation, making it an ideal database choice for SaaS applications.
New Features
Key New Features
- Full-Text Search and BM25 Relevance Retrieval
Full-text search is now fully supported, leveraging the BM25 algorithm for precise relevance retrieval, significantly improving query efficiency and accuracy for text data. - HDFS Data Loading
The optimizedLOAD DATA
command enables users to directly load large-scale data from the HDFS file system, meeting efficient data import needs for big data scenarios. - Inter-Cluster CDC Support
The newly added inter-cluster CDC feature enables real-time data synchronization between MatrixOne clusters, ensuring data consistency and high availability for enterprise-grade real-time data management. - HNSW-Based Vector Indexing (Beta)
Introduces vector indexing technology based on the HNSW algorithm, providing a new solution for high-dimensional data processing and vector similarity search, expanding the database's applications in AI and machine learning. - Python SDK for Hybrid Search
The MatrixOne Python SDK offers developers convenient interfaces for efficient vector and full-text search, enabling vector, full-text, and hybrid retrieval while significantly reducing development complexity for rapid RAG application construction.
Other New Features
- Support select xx from xx{as of timestamp 'YYYY-MM-DD HH:MM:SS'}
- Optimized PITR-related syntax
- Optimized snapshot-related syntax
Known Issues
- CDC tasks currently only support table-level synchronization.
- Creating a CDC task requires first creating a PITR that includes the synchronization scope.
- Snapshot and PITR backups cannot restore data from deleted tenants.
- HNSW-type vector indexes currently do not support real-time index updates.
Full Changelog: v2.0.0...v2.1.0
MatrixOne-v2.0.4
Release date: April 04, 2025
MatrixOne version: v2.0.4
MatrixOne 2.0.4 introduces a series of improvements and bug fixes that enhance system security. Below are the major updates and new features.
Bugfix
- Fix bugs related to security
What's Changed
- fix safety bugs by @zhangxu19830126 in #21599
Full Changelog: v2.0.3...v2.0.4