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

Can not corectly stop FB service when get internal FB consistency check: need to use kill process (by ProcessExplorer et al) [CORE5420] #5693

Open
firebird-automations opened this issue Dec 13, 2016 · 0 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pavel-zotov

Consider following script (from core-5392):

shell del c:\mix\firebird\qa\fbt-repo\tmp\c5392.fdb 2>nul;
create database 'localhost/3400:c:\mix\firebird\qa\fbt-repo\tmp\c5392.fdb';
shell gfix -w async localhost/3400:c:\mix\firebird\qa\fbt-repo\tmp\c5392.fdb;

commit;
connect 'localhost/3400:c:\mix\firebird\qa\fbt-repo\tmp\c5392.fdb';

create domain dm_longutf as varchar(8000) character set utf8;
recreate table test (id int not null, a int);
commit;

set echo on;

set term ^;
execute block as
declare i int;
declare n int = 100000;
begin
while (n>0) do insert into test(id, a) values(:n, :n) returning :n-1 into n;
end
^
set term ;^
commit;
alter table test add constraint pk_test primary key (id) using descending index pk_test_desc;
commit;

alter table test add b dm_longutf default '' not null;
commit;

update test set a=2;
rollback;

set list on;
-- this lead to decompression overran buffer (179), file: sqz.cpp line: 282
set echo on;
update test set a=3;
commit;

Statement "update test set a=3;" will lead to

Statement failed, SQLSTATE = XX000
internal Firebird consistency check (decompression overran buffer (179), file: sqz.cpp line: 282)

When this message appears one can NOT to stop FB service using control panel / services and FB process will load CPU on 100%.
Only ProcessExplorer kill command helps in this case.

Bug is reproducible on WI-T4.0.0.462 SuperServer.

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

1 participant