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
BUGCHECK 284 [CORE2291] #2716
Comments
Modified by: @hvladassignee: Vlad Khorsun [ hvlad ] |
Commented by: @hvlad Plain SELECT didn't produced bugcheck as problem code executed only when singleton verification is performed by the engine. |
Modified by: @hvladstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.5 Beta 1 [ 10251 ] |
Commented by: Lukas Petrlik (luki) It also happens with 2.0.5 (but not with 2.0.4): SQL> execute procedure a; Used software: Firebird 2.0.5 13206-1 Win32 embedded server |
Commented by: @hvlad Fix is backported into 2.1.3 |
Commented by: ramengo (ramengo) Same error here, after upgrading from 2.1.1 to 2.1.2. |
Commented by: @dyemanov You don't have to wait for v2.1.3, the bugfix is available in recent (post-2.1.2) snapshots. |
Commented by: ramengo (ramengo) Hi Dmitry, thx for the info. But are you sure I can install a snapshot ? Is it stable ? Where to download it ? |
Commented by: @dyemanov http://www.firebirdsql.org/index.php?op=files&id=snapshots |
Commented by: ramengo (ramengo) Excuse my extreme in-experience... I've done this: |
Commented by: maziar (maziar) i have same problem in 2.1.2 after one day work of my db in one sp call other sp in return of depth sql same error hapen |
Commented by: Andrew (coder2) I have such errors: internal gds software consistency check (cannot restore singleton select data (284), file: rse.cpp line: 3426) when the following statement is being executed: select name as file_name, title, text from cms_includes where lower(name) = lower(?) The installed package is FirebirdSS-2.1.2.18118-0.nptl.i686.rpm. |
Commented by: Alfonso Presa (foncci) Hi All: I had the same issue into a trigger but I just change the "select ..." in a "for select xxx" and everythings works fine. Maybe it workaround is usefull for somebody. Regards, Al |
Commented by: Rodrigo (rod_gomes) any fix for 2.0.5? |
Commented by: Pawel (doc19) Does anybody know reproduce procedure for this issue? Because this occures once on my system and I would like to know how what I have probably done. |
Commented by: @hvlad Pawel, re-read my description and suggestion of Alfonso Presa. But better upgrade to 2.1.3 |
Commented by: Pawel (doc19) I have read it, but unfortunately my knowledge of firebird is not sufficient (e.g. don't understand what "singleton verification" is). Could you please write what is the root cause of this problem, and what kind of action can cause it. Thanks in advance. |
Commented by: @hvlad Pawel, does you read what Alfonso Presa suggested ? Ok, if it is still not clear for you : code with singleton SELECT : begin same code without singleton SELECT : begin |
Modified by: @dyemanovFix Version: 2.0.6 [ 10303 ] |
Commented by: @pmakowski QA test made |
Modified by: @pmakowskistatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovQA Status: No test => Done successfully |
Submitted by: @hvlad
Is duplicated by CORE2469
Is duplicated by CORE2520
Jira_subtask_outward CORE2631
Is related to QA233
Is duplicated by CORE2605
recreate table t (id int, f2 char(16));
commit;
insert into t values (1, '0123456798012345');
insert into t values (2, '0123456798012345');
commit;
alter table t drop f2;
commit;
update t set id = 3 where id = 2;
commit;
execute block returns (id int)
as
begin
select http://t1.id from t t1 left join t t2 on http://t1.id = http://t2.id - 2
where http://t2.id = 3
into :id;
suspend;
end
Last statement produced bugcheck :
Commits: 69f3f95 df05e7d 9668dc5
The text was updated successfully, but these errors were encountered: