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 crash on create index [CORE1049] #1468
Comments
Commented by: @hvlad Can you attach sample database with inserted record but without index ? |
Commented by: mbabuskov (mbabuskov) FWIW, I tried with embedded RC5, it doesn't crash and gives a little bit more useful error message: internal gds software consistency check (index key too big (174), file: idx.cpp line: 438) |
Commented by: @asfernandes This (key too big) is the same problem of CORE997, and I believe the crash is also fixed too. |
Commented by: @asfernandes Well, the crash problem was introduced in HEAD, so we need another test case. |
Commented by: Jan Hamann (jhamann) Database with table "test" but without index |
Modified by: Jan Hamann (jhamann)Attachment: TEST1.zip [ 10181 ] |
Commented by: @asfernandes Jan, where is the crash? This is exactly CORE997 error. |
Commented by: @dyemanov Maybe BugcheckAbort = 1? |
Commented by: Jan Hamann (jhamann) Can't reproduce the crash on my home machine. Will test tomorrow at work. |
Commented by: Jan Hamann (jhamann) Can't reproduce the crash. Sorry, false alarm. |
Modified by: @hvladstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Duplicate [ 3 ] Fix Version: 2.0.1 [ 10090 ] Fix Version: 2.1 [ 10041 ] |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Commented by: @pcisar Reopened to update ticket information. |
Modified by: @pcisarWorkflow: jira [ 11386 ] => Firebird [ 15246 ] |
Modified by: @pavel-zotovQA Status: No test |
Submitted by: Jan Hamann (jhamann)
Is related to QA20
Duplicates CORE997
Attachments:
TEST1.zip
The Firebird server crashes on a CREATE INDEX statement. Seen also on database restore.
The index is created on a varchar field. The field has a collation order, is fully filled and has umlauts.
Steps to reproduce:
Create a database with default character set win1252 (page size 4096).
create table test
(
id integer not null,
txt varchar(50) collate pxw_intl850,
constraint pk_test primary key (id)
);
insert into test values (1, 'Kompaktseminar Prozessorganisation f?r F?hrungskr?');
commit;
Before creating the index you have to disconnect and connect because "object test is in use"-error.
create index testtxt on test(txt);
The server crashes with following error message:
ISC ERROR CODE:335544333
ISC ERROR MESSAGE:
internal gds software consistency check (can't continue after bugcheck)
The text was updated successfully, but these errors were encountered: