Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Server locks up while attempting to commit a deletion of an expression index [CORE1145] #1567

Closed
firebird-automations opened this issue Feb 28, 2007 · 10 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @dyemanov

Is related to QA41

The problem is related to LCK_expression locks. Index ID is not unique across database, so it shouldn't be used as a lock key.

Commits: a747534 2f1dc82

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Fix Version: 2.1 Alpha 1 [ 10150 ]

Fix Version: 2.1.0 [ 10041 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA41 [ QA41 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Dmitry, could you provide a test case for this one please? I can't reproduce on 2.0.0.

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

create table expt1 (col1 int);
create table expt2 (col2 int);
commit;

create index iexpt1 on expt1 computed (col1 + 1);
create index iexpt2 on expt2 computed (col2 + 1);
commit;

select * from expt1 where col1 + 1 = 0;
select * from expt2 where col2 + 1 = 0;
commit;

drop index iexpt2;
commit; -- lockup

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Fix verified, test added.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 11642 ] => Firebird [ 15325 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test => Done successfully

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants