manticoresoftware / manticoresoftware/manticoresearch

Transactions cannot be expected to execute.

Open
#433 8 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

bug
Dominant language
C++
Stars
12k
Forks
642
Avg merge
3d 12h
Merged PRs (30d)
47

Description

3.5.0 1d34c491@200722 release

create table test (v text);  
insert into test (id,v) values(1,'v1');  
begin;  
replace into test (id,v) values(1,'v2');  
delete from test where id=1;  
commit;  
select count(*) from test;  
 ----------   
| count(*) |  
 ----------   
|        1 |  
 ----------   

Found in a transaction, ultimately unable to delete. Is this expected?
Did I misunderstand that I thought the transaction would end up being serialized?

It is stated in the document that there is a limit to the accumulation of transactions. Can this limit be configured there?

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the SQL transaction sequence from the issue against the reported 3.5.0 release. Read the transaction documentation referenced in the report, including the stated transaction accumulation limit, and determine whether the observed row count and configuration question match documented behavior. Done means the behavior is explained and any required correction or documentation scope is clearly identified.

Written by the indexing model from the issue text.

Assessment

Tech stack
cpp, sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.